ho2dev/permitmapping.rb at master · tractorfeed/ho2dev · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
require 'date'
require 'json'

	get '/' do
		erb :index
	end

	get '/api' do
		redirect '/'
	end

	get '/api/permits' do
		redirect '/'
	end

	get '/api/permits/query' do
		start_date = params.delete('start_date')
		end_date = params.delete('end_date')
		permit_type = params.delete('permit_type')
		permit_status = params.delete('permit_status')
		neighborhood = params.delete('neighborhood')
		lat = params.delete('lat')
		lng = params.delete('lng')
		radius = params.delete('radius')
		limit = params.delete('limit') || 100

		limit = [100, limit].min
		limit = [1,   limit].max
		conditions = Hash.new

		if(permit_status)
			permit_status = PermitStatus.first(permit_status)
			if(permit_status)
				conditions[:permit_status] = permit_status
			end
		end
		if(permit_type)
			permit_type = PermitType.first(permit_type)
			if(permit_type)
				conditions[:permit_type] = permit_type
			end
		end
		if(start_date)
			begin
				start_date = Date.strptime(start_date, "%m/%d/%Y")
			rescue
				start_date = nil
			end
			if(start_date)
				conditions[:date.gte] = start_date
			end
		end
		if(end_date)
			begin
				end_date = Date.strptime(end_date, "%m/%d/%Y")
			rescue
				end_date = nil
			end
			if(end_date)
				conditions[:date.lte] = end_date
			end
		end
		if(neighborhood)
			neighborhood = Neighborhood.first(neighborhood)
			if(neighborhood)
				conditions[:neighborhood] = neighborhood
			end
		end
		if(lat && lng && radius)
			bbox = get_bounding_box(lat, lng, radius)
			conditions[:latitude.gte]  = bbox['min_lat']
			conditions[:longitude.gte] = bbox['min_lng']
			conditions[:latitude.lte]  = bbox['max_lat']
			conditions[:longitude.lte] = bbox['max_lng']
		end
		if(conditions.keys.count > 0)
			permits = Permit.all(:conditions => conditions, :limit => limit)
		else
			permits = Permit.all(:limit => limit)
		end
		return permits.to_json
	end

	get '/api/permits/summary' do
		hoods = Array.new
		neighborhoods = Neighborhood.all

		neighborhoods.each do |neighborhood|
			hood = Hash.new
			hood['name'] = neighborhood['name']
			hood['id'] = neighborhood['id']
			hood['census_data'] = neighborhood
			hood['new_permits'] = Permit.count(:neighborhood => neighborhood)

#			[2011, 2012].each do |year|
#				[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12].each do |month|
#					month_key = Date::ABBR_MONTHNAMES[month] + year.to_s
#					month_conditions = Hash.new
#
#					# Set the start/end dates for the month
#					month_start_date = Date.new(year, month, 1)
#					month_end_date = Date.new(year, month, days_in_month(month, year))
#					month_conditions[:date.gte] = month_start_date
#					month_conditions[:date.lte] = month_end_date
#
#					month_value = Permit.count(:conditions => month_conditions)
#					hood['new_permits'][month_key] = month_value
#				end
#			end

			hoods.push(hood)
		end
		result = []
		weight = 1
		hoods = hoods.sort_by { |hsh| hsh['new_permits']}
		loop do
			group = hoods.pop([15, hoods.length].max)
			group.each do |hood|
				hood[:relative_growth] = weight
				result.push(hood)
			end
			weight += 1
			if(hoods.length == 0)
				break
			end
		end

		return result.to_json
	end

	get '/api/neighborhoods' do
		return Neighborhood.all.to_json
	end

	get '/api/permits/types' do
		return PermitType.all.to_json
	end

	get '/api/permits/statuses' do
		return PermitStatus.all.to_json
	end