trees

Custom SQL query returning 26 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1900 141936 7 36 1101 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout Tree 9   10/12/1994 12:00:00 AM 8 Width 0ft   6003954.1428 2112136.7195 37.7797483635991 -122.429918243479 (37.7797483635991, -122.429918243479) 7 9 11 29490 41
7377 14771 7 93 1000X McAllister St 6 Sidewalk: Curb side : Cutout Tree 9     18 4x4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 7 9 11 29490 41
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
21625 14774 7 11 1000X McAllister St 9 Sidewalk: Curb side : Cutout Tree 9   05/13/1992 12:00:00 AM 6 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 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
32237 14772 7 93 1000X McAllister St 7 Sidewalk: Curb side : Cutout Tree 9   06/30/1994 12:00:00 AM 18 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 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
46399 14769 7 11 1000X McAllister St 4 Sidewalk: Curb side : Cutout Tree 9   07/11/1995 12:00:00 AM 6 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 7 9 11 29490 41
49782 14776 7 93 1000X McAllister St 11 Sidewalk: Curb side : Cutout Tree 9   06/30/1994 12:00:00 AM 12 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 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
61736 115005 1 7 1050 MCALLISTER ST 2 Front Yard : Cutout Tree 9 DPW     3x3   6004148 2111858 37.7789940453007 -122.429227726914 (37.7789940453007, -122.429227726914) 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
97560 9555 7 83 1195X Golden Gate Ave 8 Sidewalk: Curb side : Cutout Tree 9     6 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.430062547125 (37.7797350134544, -122.430062547125) 7 9 11 29490 41
115880 14775 7 93 1000X McAllister St 10 Sidewalk: Curb side : Cutout Tree 9     12 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 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
130466 9554 7 36 1195X Golden Gate Ave 7 Sidewalk: Curb side : Cutout Tree 9   05/14/1992 12:00:00 AM 12 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.430062547125 (37.7797350134544, -122.430062547125) 7 9 11 29490 41
143126 14773 7 83 1000X McAllister St 8 Sidewalk: Curb side : Cutout Tree 9   05/13/1992 12:00:00 AM 6 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
165709 14777 7 93 1000X McAllister St 12 Sidewalk: Curb side : Cutout Tree 9     12 4X4   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 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
184416 9550 7 83 1195X Golden Gate Ave 3 Sidewalk: Curb side : Cutout Tree 9     6 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.430062547125 (37.7797350134544, -122.430062547125) 7 9 11 29490 41
188714 9553 7 83 1195X Golden Gate Ave 6 Sidewalk: Curb side : Cutout Tree 9     6 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