trees

Custom SQL query returning 22 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
4591 113471 4 54 450 CHURCH ST 28 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
11090 38646 7 54 209 29th St 1 Sidewalk: Curb side : Cutout Tree 2   09/22/1998 12:00:00 AM     Permit Number 40570 6005214.92856016 2099001.03793316 37.7437522091261 -122.424621959344 (37.7437522091261, -122.424621959344) 2 7 5 63 22
15342 113473 4 54 450 CHURCH ST 30 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
17983 107661 4 54 1312 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree 2     16 3x3   5999086.9 2105066.2 37.7600576690463 -122.446247345124 (37.7600576690463, -122.446247345124) 15 5 5 28862 3
23530 245383 1 54 3720 Mission St 2 Sidewalk: Curb side : Cutout Tree 1     14 Width 0ft   6005268.7499 2096538.92 37.7369948294896 -122.424260783275 (37.7369948294896, -122.424260783275) 2 7 5 28859 2
33807 113465 4 54 450 CHURCH ST 1 Sidewalk: Curb side : Cutout Tree 4     20 6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
43317 113469 4 54 450 CHURCH ST 26 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
45788 113409 4 54 401x DUNCAN ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6003916 2099815 37.745913716911 -122.429171370863 (37.745913716911, -122.429171370863) 2 7 5 63 22
65054 113474 4 54 450 CHURCH ST 31 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
67077 113468 4 54 450 CHURCH ST 4 Sidewalk: Curb side : Cutout Tree 4   06/21/2016 02:14:00 PM 3 6x7   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
83117 113466 4 54 450 CHURCH ST 2 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
91889 113472 4 54 450 CHURCH ST 29 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
92667 37059 7 54 1450 Sanchez St 2 Sidewalk: Curb side : Cutout Tree 2   06/01/1998 12:00:00 AM   3x3 Permit Number 39663 6003906.83973736 2099821.31146391 37.7459305281666 -122.429203495744 (37.7459305281666, -122.429203495744) 2 7 5 63 22
132386 113054 4 54 25 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6003823 2108493 37.7697361782825 -122.430111915017 (37.7697361782825, -122.430111915017) 15 9 5 29492 10
134819 113410 4 54 401x DUNCAN ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6003916 2099815 37.745913716911 -122.429171370863 (37.745913716911, -122.429171370863) 2 7 5 63 22
142773 37061 7 54 1450 Sanchez St 4 Sidewalk: Curb side : Cutout Tree 2 FUF 06/01/1998 12:00:00 AM   3x3 Permit Number 39663 6003906.83973736 2099821.31146391 37.7459305281666 -122.429203495744 (37.7459305281666, -122.429203495744) 2 7 5 63 22
142974 245382 1 54 3720 Mission St 1 Sidewalk: Curb side : Cutout Tree 1     13 Width 0ft   6005277.267 2096556.8057 37.7370444205252 -122.424232607489 (37.7370444205252, -122.424232607489) 2 7 5 28859 2
143625 113475 4 54 450 CHURCH ST 32 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
145196 113408 4 54 1450 SANCHEZ ST 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6003890 2099760 37.7457612277667 -122.429257354108 (37.7457612277667, -122.429257354108) 2 7 5 63 22
147121 113467 4 54 450 CHURCH ST 24 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
178861 37062 7 54 1450 Sanchez St 1 Sidewalk: Curb side : Cutout Tree 2   06/01/1998 12:00:00 AM   3x3 Permit Number 39663 6003906.83973736 2099821.31146391 37.7459305281666 -122.429203495744 (37.7459305281666, -122.429203495744) 2 7 5 63 22
188448 113470 4 54 450 CHURCH ST 27 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3