PURPOSE
Simple map of 311 calls


STEPS
 Select dates
 Press "Get 311 Data"
 Geographic boundary filter is used


Default Filter used
 service_name=Sewer Issues

Red marker
 request_detail Flooding

Green marker
 for all others

OPTIONS
 Modify default query string
 and plotted

FOR DEVELOPERS

New Item
Last 24 hr data uses
https://data.sfgov.org/resource/s5tu-9idx.json?$order=open_dt%20desc&$limit=50000
Output syntax is different from the rest. For example, opened vs open_dt.

All other

Data Source 
 https://data.sfgov.org/City-Infrastructure/Case-Data-from-San-Francisco-311-SF311-/vw6y-z8j6

Url Examples
 https://data.sfgov.org/resource/ktji-gk7t.json?service_name=Sewer Issues
 https://data.sfgov.org/resource/ktji-gk7t.json?service_name=Tree Maintenance
 https://data.sfgov.org/resource/ktji-gk7t.json?service_subtype=Odor

Actual url passed to server has date range appended
https://data.sfgov.org/resource/ktji-gk7t.json?service_name=Sewer%20Issues&$where=requested_datetime%20between%20%272016-10-14T00:00:00%27%20and%20%272016-10-15T23:59:00%27

https://data.sfgov.org/resource/ktji-gk7t.json?$where=requested_datetime%20between%20%272017-06-30T06:05:00%27%20and%20%272017-06-30T06:55:00%27

Example JSON Data
[{
	"address":"1321 NATOMA ST, SAN FRANCISCO, CA, 94103",
	"agency_responsible":"Recology_Abandoned",
	"closed_date":"2017-07-03T11:34:46.000",
	"lat":"37.76799",
	"long":"-122.4184",
	"media_url":"http://mobile311.sfgov.org/media/san_francisco/report/photos/59564c851ea55754bd9b8a4c/report.jpg",
	"neighborhoods_sffind_boundaries":"Mission",
	"point":{"type":"Point","coordinates":[-122.418453,37.768009]},
	"police_district":"MISSION",
	"requested_datetime":"2017-06-30T06:05:32.000",
	"service_details":"Other Loose Garbage",
	"service_name":"Street and Sidewalk Cleaning",
	"service_request_id":"7317164",
	"service_subtype":"General Cleaning",
	"source":"Mobile/Open311",
	"status_description":"Closed",
	"status_notes":"Case Resolved - Pickup completed.",
	"supervisor_district":"9",
	"updated_datetime":"2017-07-03T11:34:46.000"
}, ... more ]


Superseded field names
FIELD NAMES				| EXAMPLE DATA
------------------------------------------------------------------------
	address 			| Intersection of JERROLD AVE and SELBY ST
	case_id 			| 6399660
	category 			| Sewer Issues
	media_url 			| http://mobile311.sfgov.org/media/san_francisco/report/photos/57fa865adf866a3865f3ae4f/report.jpg
	neighborhood 			| Produce Market
	opened 				| 2016-10-09T11:03:13.000
	point 				| [object Object]
	request_details 		| From_side_sewer_vent
	request_type 			| Odor
	responsible_agency 		| PUC Sewer Ops
	source 				| Open311
	status 				| Open
	status_notes 			| open
	supervisor_district 		| 10
	updated 			| 2016-10-09T11:03:13.000
------------------------------------------------------------------------


REFERENCES
https://dev.socrata.com/docs/queries/


LIMITATIONS
 
 Last data may be upto 24 hours ago
 Rain data may not be up to date
 Pop-up block prevents table showing up

BS 2021 FEB
BS 2016 OCT 17