trees

Custom SQL query returning 15 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
122325 104309 9 62 3747 23RD ST 2 Sidewalk: Curb side : Cutout Tree 2       5x5   6004798 2102451 37.7532014528284 -122.426309178314 (37.7532014528284, -122.426309178314) 2 4 5 28862 22
97720 104310 9 348 3747 23RD ST 3 Sidewalk: Curb side : Cutout Tree 2     13 5x5   6004798 2102451 37.7532014528284 -122.426309178314 (37.7532014528284, -122.426309178314) 2 4 5 28862 22
16189 104502 9 15 30X SATURN ST 1 Median : Yard Tree 1     14     6000456 2106003 37.7627079858093 -122.44157952537 (37.7627079858093, -122.44157952537) 15 5 5 28862 3
112431 104768 9 31 912 CASTRO ST 1 Sidewalk: Curb side : Cutout Tree 2     17 3x3   6002431.1 2102873.8 37.7542282864134 -122.434524613527 (37.7542282864134, -122.434524613527) 2 4 5 28862 22
33896 104968 9 330 495 COLLINGWOOD ST 1 Front Yard : Yard Tree 2     15   Permit Number 770776 6002186.6 2103026 37.7546323087418 -122.435381040855 (37.7546323087418, -122.435381040855) 2 4 5 28862 22
193423 108885 9 195 707 NOE ST 5 Back Yard : Yard Tree 2       3x3   6003152.4 2104071.5 37.7575578048507 -122.432115704961 (37.7575578048507, -122.432115704961) 2 4 5 28862 3
186484 109125 9 91 890x CASTRO ST 1 Sidewalk: Curb side : Cutout Tree 2     12 3x3   6002411 2103002 37.7545791519678 -122.434603290485 (37.7545791519678, -122.434603290485) 2 4 5 28862 22
83952 109126 9 91 890x CASTRO ST 2 Sidewalk: Curb side : Cutout Tree 2     4 3x3   6002411 2103002 37.7545791519678 -122.434603290485 (37.7545791519678, -122.434603290485) 2 4 5 28862 22
181524 121089 9 56 1X Grand View Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
107120 121090 9 15 1X Grand View Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
7435 239668 9 313 180 Dolores St 3 Sidewalk: Property side : Pot Landscaping 2     23 Width 4ft   6004776.3298 2107329.36682 37.7665950691341 -122.426731495165 (37.7665950691341, -122.426731495165) 8 4 5 28862 3
8510 259163 9 66 1 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
9208 259164 9 66 1 Corbett Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
16349 259165 9 66 1 Corbett Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
4985 260550 9 284 155 Graystone Ter 1 Sidewalk: Property side : Yard Landscaping 2       3x3   5999080 2104142 37.7575196509651 -122.446204727568 (37.7575196509651, -122.446204727568) 2 5 5 28862 3