trees

Custom SQL query returning 16 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
70417 5290 7 28 2070X O'Farrell St 2 Sidewalk: Curb side : Cutout Tree 11     18 3X3   6001402.6275094 2113220.9735965 37.78258062415 -122.43882275095 (37.78258062415, -122.43882275095) 15 5 11 29490 41
109789 5289 7 28 2070X O'Farrell St 1 Sidewalk: Curb side : Cutout Tree 11     18 3X3   6001402.6275094 2113220.9735965 37.78258062415 -122.43882275095 (37.78258062415, -122.43882275095) 15 5 11 29490 41
123029 24641 1 27 1450 Divisadero St 3 Sidewalk: Curb side : Cutout Tree 11   01/01/2010 12:00:00 AM 3 3X3   6001279.2498 2113291.632 37.7827676140685 -122.43925464983 (37.7827676140685, -122.43925464983) 15 5 11 29490 41
71136 26432 1 27 1450 Divisadero St 4 Sidewalk: Curb side : Cutout Tree 11   01/01/2010 12:00:00 AM 3 3X3   6001275.1888 2113317.3521 37.7828380038034 -122.439270543262 (37.7828380038034, -122.439270543262) 15 5 11 29490 41
31354 5288 7 148 1450 Divisadero St 1 Sidewalk: Curb side : Cutout Tree 11   01/01/2010 12:00:00 AM 3 3X3   6001279.3901091 2113342.5749494 37.7829074983832 -122.439257816981 (37.7829074983832, -122.439257816981) 15 5 11 29490 41
37348 116701 7 148 1450 Divisadero St 6 Sidewalk: Curb side : Cutout Tree 11       3X3   6001279.3901091 2113342.5749494 37.7829074983832 -122.439257816981 (37.7829074983832, -122.439257816981) 15 5 11 29490 41
68592 116702 7 148 1450 Divisadero St 7 Sidewalk: Curb side : Cutout Tree 11       3X3   6001279.3901091 2113342.5749494 37.7829074983832 -122.439257816981 (37.7829074983832, -122.439257816981) 15 5 11 29490 41
21593 8555 1 27 2141 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree 11     18 3X3   6001312.669 2113446.883 37.7831957953331 -122.43915016449 (37.7831957953331, -122.43915016449) 15 5 11 29490 41
30080 8550 7 27 2121 Geary Blvd 5 Sidewalk: Curb side : Cutout Tree 11     30 3X3   6001601.9223045 2113552.6348977 37.7835026179143 -122.438157044438 (37.7835026179143, -122.438157044438) 15 5 11 29490 41
56959 8553 7 27 2121 Geary Blvd 8 Sidewalk: Curb side : Cutout Tree 11     24 3X3   6001601.9223045 2113552.6348977 37.7835026179143 -122.438157044438 (37.7835026179143, -122.438157044438) 15 5 11 29490 41
63682 8551 7 27 2121 Geary Blvd 6 Sidewalk: Curb side : Cutout Tree 11     24 3X3   6001601.9223045 2113552.6348977 37.7835026179143 -122.438157044438 (37.7835026179143, -122.438157044438) 15 5 11 29490 41
115041 8552 7 27 2121 Geary Blvd 7 Sidewalk: Curb side : Cutout Tree 11     30 3X3   6001601.9223045 2113552.6348977 37.7835026179143 -122.438157044438 (37.7835026179143, -122.438157044438) 15 5 11 29490 41
122745 8547 7 27 2121 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree 11     24 3X3   6001601.9223045 2113552.6348977 37.7835026179143 -122.438157044438 (37.7835026179143, -122.438157044438) 15 5 11 29490 41
150360 8546 7 27 2121 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree 11     30 3X3   6001601.9223045 2113552.6348977 37.7835026179143 -122.438157044438 (37.7835026179143, -122.438157044438) 15 5 11 29490 41
158299 8549 7 27 2121 Geary Blvd 4 Sidewalk: Curb side : Cutout Tree 11     30 3X3   6001601.9223045 2113552.6348977 37.7835026179143 -122.438157044438 (37.7835026179143, -122.438157044438) 15 5 11 29490 41
188585 8548 7 27 2121 Geary Blvd 3 Sidewalk: Curb side : Cutout Tree 11     30 3X3   6001601.9223045 2113552.6348977 37.7835026179143 -122.438157044438 (37.7835026179143, -122.438157044438) 15 5 11 29490 41