trees

Custom SQL query returning 12 rows (show)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
14852 9557 7 170 1195X Golden Gate Ave 10 Sidewalk: Curb side : Cutout Tree 9   01/19/2016 07:54:00 AM 3 3x3   6003912.3472435 2112132.7194564 37.7797350134544 -122.430062547125 (37.7797350134544, -122.430062547125) 7 9 11 29490 41
30150 9556 7 170 1195X Golden Gate Ave 9 Sidewalk: Curb side : Cutout Tree 9   01/19/2016 07:58:00 AM 3 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.430062547125 (37.7797350134544, -122.430062547125) 7 9 11 29490 41
30207 9548 7 36 1195X Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree 9   10/12/1994 12:00:00 AM 3 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.430062547125 (37.7797350134544, -122.430062547125) 7 9 11 29490 41
32567 14768 7 293 1000X McAllister St 3 Sidewalk: Curb side : Cutout Tree 9   11/25/1992 12:00:00 AM 3 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 7 9 11 29490 41
46316 9558 7 32 1195X Golden Gate Ave 11 Sidewalk: Curb side : Cutout Tree 9   12/15/2005 12:00:00 AM 3 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.430062547125 (37.7797350134544, -122.430062547125) 7 9 11 29490 41
60082 29064 7 75 1000X McAllister St 1 Sidewalk: Curb side : Cutout Tree 9   03/02/2006 12:00:00 AM 3 3x3   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 7 9 11 29490 41
90969 115004 1 177 1050 MCALLISTER ST 5 Front Yard : Cutout Tree 9 DPW 01/19/2016 09:19:00 AM 3 3x3   6004148 2111858 37.7789940453007 -122.429227726914 (37.7789940453007, -122.429227726914) 7 9 11 29490 41
117753 14770 7 83 1000X McAllister St 5 Sidewalk: Curb side : Cutout Tree 9   02/06/2016 08:42:00 AM 3 4x4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 7 9 11 29490 41
143453 9551 7 36 1195X Golden Gate Ave 4 Sidewalk: Curb side : Cutout Tree 9   05/14/1992 12:00:00 AM 3 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.430062547125 (37.7797350134544, -122.430062547125) 7 9 11 29490 41
180349 9559 7 36 1195X Golden Gate Ave 12 Sidewalk: Curb side : Cutout Tree 9     3 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.430062547125 (37.7797350134544, -122.430062547125) 7 9 11 29490 41
190390 9549 7 36 1195X Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree 9   05/14/1992 12:00:00 AM 3 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.430062547125 (37.7797350134544, -122.430062547125) 7 9 11 29490 41
191096 29063 7 75 1000X McAllister St 2 Sidewalk: Curb side : Cutout Tree 9   12/15/2005 12:00:00 AM 3 3x3   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 7 9 11 29490 41