trees

Custom SQL query returning 19 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
704 10945 1 134 1400X Hudson Ave 5 Sidewalk: Curb side : Cutout Tree 1   03/11/2006 12:00:00 AM 3 3X4   6016738.0241541 2096692.24342 37.7380567715564 -122.384616664641 (37.7380567715564, -122.384616664641) 10 3 8 58 1
35035 95795 7 134 330 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/19/2011 12:00:00 AM   3x3 Permit Number 767538 6006154 2101094.4 37.7495530959347 -122.421523510351 (37.7495530959347, -122.421523510351) 2 4 5 28859 19
44765 10889 7 134 1270X Hudson Ave 5 Sidewalk: Curb side : Cutout Tree 2   03/11/2006 12:00:00 AM 3 3X4   6017265.0162454 2095327.7862917 37.734339374173 -122.382699652574 (37.734339374173, -122.382699652574) 10 3 8 58 1
57647 34026 7 134 2730 16th St 2 Sidewalk: Curb side : Cutout Tree 2   08/01/2008 12:00:00 AM   3x3 Permit Number 51549 6008501.61322181 2106845.55424255 37.7654765469809 -122.413812123028 (37.7654765469809, -122.413812123028) 8 4 7 28853 19
62999 34028 7 134 2730 16th St 4 Sidewalk: Curb side : Cutout Tree 2   08/01/2008 12:00:00 AM   3x3 Permit Number 51549 6008501.61322181 2106845.55424255 37.7654765469809 -122.413812123028 (37.7654765469809, -122.413812123028) 8 4 7 28853 19
66406 95798 7 134 1106 Treat Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/19/2011 12:00:00 AM   3x3 Permit Number 767540 6008629.6 2102091.1 37.7524290867487 -122.413033242012 (37.7524290867487, -122.413033242012) 2 4 7 28859 19
73899 29569 1 134 1175X Hudson Ave 18 Sidewalk: Curb side : Cutout Tree 1   04/27/2006 12:00:00 AM 3 3x3   6017544.4990408 2094830.7506973 37.7329900490522 -122.381698823278 (37.7329900490522, -122.381698823278) 10 3 8 58 1
80620 95796 7 134 330 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 08/19/2011 12:00:00 AM   3x3 Permit Number 767538 6006154 2101094.4 37.7495530959347 -122.421523510351 (37.7495530959347, -122.421523510351) 2 4 5 28859 19
86866 10957 1 134 1425X Hudson Ave 2 Sidewalk: Curb side : Cutout Tree 1   03/11/2006 12:00:00 AM 3 3X4   6016592.1339091 2096738.5714059 37.7381759097054 -122.385124311518 (37.7381759097054, -122.385124311518) 10 3 8 58 1
87266 10873 1 134 1175X Hudson Ave 6 Sidewalk: Curb side : Cutout Tree 1   03/23/2006 12:00:00 AM 6 3X4   6017544.4990408 2094830.7506973 37.7329900490522 -122.381698823278 (37.7329900490522, -122.381698823278) 10 3 8 58 1
89060 94575 7 134 3889 20th St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 09/20/2010 12:00:00 AM 3 3x3 Permit Number 53753 6004405 2104227 37.7580557086801 -122.427794786333 (37.7580557086801, -122.427794786333) 2 4 5 28862 3
90349 10796 1 134 1139X Hudson Ave 4 Sidewalk: Curb side : Cutout Tree 1   03/23/2006 12:00:00 AM 3 3x4   6017446.51401 2094936.46101 37.7332748977764 -122.382044937386 (37.7332748977764, -122.382044937386) 10 3 8 58 1
122726 41305 7 134 1387 Valencia St 4 Sidewalk: Curb side : Cutout Tree 2 FUF 03/27/2004 12:00:00 AM     Permit Number 41977 6006476.01966821 2101521.23564445 37.7507432410359 -122.420440247305 (37.7507432410359, -122.420440247305) 2 4 7 28859 19
124403 96166 7 134 166 Richland Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/08/2011 12:00:00 AM   3x3 Permit Number 767797 6005546.8 2096117.3 37.7358528516077 -122.423269476417 (37.7358528516077, -122.423269476417) 2 7 7 28859 2
136107 26892 1 134 1591 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree 1   03/11/2006 12:00:00 AM 3 3X3   6015737.7946966 2097374.5847744 37.7398749760386 -122.388122590187 (37.7398749760386, -122.388122590187) 10 3 8 58 1
144788 67677 7 134 1511 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/04/2006 12:00:00 AM     Permit Number 31281 6016146.7997149 2097069.00450631 37.7390585672526 -122.386687105419 (37.7390585672526, -122.386687105419) 10 3 8 58 1
146559 10890 7 134 1270X Hudson Ave 6 Sidewalk: Curb side : Cutout Tree 2   03/11/2006 12:00:00 AM 3 3X4   6017265.0162454 2095327.7862917 37.734339374173 -122.382699652574 (37.734339374173, -122.382699652574) 10 3 8 58 1
169868 96576 1 134 401x Otsego Ave 3 Sidewalk: Curb side : Cutout Tree 4     4     6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
182603 10853 1 134 1299X HUDSON AVE 2 Sidewalk: Curb side : Cutout Tree 1   03/11/2006 12:00:00 AM 3 3X4   6017281 2095243 37.734107450868 -122.382638493216 (37.734107450868, -122.382638493216) 10 3 8 58 1