trees

Custom SQL query returning 25 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
3344 197494 1 91 401 Texas St 3 : Tree 2     23 Width 7ft   6013811.84722 2105166.53521 37.7611631145139 -122.395327465206 (37.7611631145139, -122.395327465206) 10 3 8 28856 29
7939 264649 1 91 2400 Keith St 3 Sidewalk: Curb side : Cutout Tree 1       3x3   6014365 2092317 37.7259117231873 -122.392515496721 (37.7259117231873, -122.392515496721) 10 3 8 58 1
12626 97156 5 91 1079 Le Conte Ave 3 Sidewalk: Curb side : Cutout Tree 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012721.62132 2089840.20593 37.7190195469812 -122.398022907844 (37.7190195469812, -122.398022907844) 10 3 8 58 1
12994 239597 1 91 1287 Noe St 3 Sidewalk: Curb side : Cutout Tree 2     17 Width 6ft   6003266.18046 2100734.45358 37.7484015143127 -122.431483983218 (37.7484015143127, -122.431483983218) 2 4 5 28862 22
23040 239637 1 91 3691 21st St 3 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   6003808.38299 2103603.27195 37.7563093313217 -122.429813654389 (37.7563093313217, -122.429813654389) 2 4 5 28862 22
23225 239627 1 91 3885 21st St 3 Sidewalk: Curb side : Cutout Tree 2     15 Width 3ft   6002571.81479 2103540.6818 37.7560673714328 -122.434085656222 (37.7560673714328, -122.434085656222) 2 4 5 28862 22
36540 49625 1 91 180 11th St 3 Sidewalk: Curb side : Cutout Tree 2   05/13/2003 12:00:00 AM 6   Permit Number 768701 6007969.67353 2109667.22612 37.773194308705 -122.415851810006 (37.773194308705, -122.415851810006) 8 2 9 28853 19
37249 35756 1 91 6838 Geary Blvd 3 Sidewalk: Curb side : Cutout Tree 2   04/20/1998 12:00:00 AM 8   Permit Number 39022 5985797.58958 2112563.51135 37.7798752557854 -122.492760252761 (37.7798752557854, -122.492760252761) 11 6 2 55 26
49320 32953 7 91 673X Missouri St 3 Sidewalk: Curb side : Cutout Tree 2   11/01/1996 12:00:00 AM     Permit Number 37269 6013554 2103938 37.7577754809094 -122.396133153567 (37.7577754809094, -122.396133153567) 10 3 8 28856 29
74800 214156 1 91 495 Pacheco St 3 Sidewalk: Curb side : Yard Tree 2     7 Width 6ft   5993555.55486 2101853.98601 37.7509203085364 -122.465144146879 (37.7509203085364, -122.465144146879) 1 8 4 29491 40
82754 239645 1 91 4 Ford St 3 Sidewalk: Curb side : Cutout Tree 2     12 Width 3ft   6003486.01122 2105681.39131 37.7619970900117 -122.431076844836 (37.7619970900117, -122.431076844836) 15 4 5 28862 3
107727 136369 1 91 2945 Scott St 3 Sidewalk: Curb side : Cutout Tree 2     2 Width 4ft   6000984.79842 2118544.66291 37.7971743129098 -122.440650232318 (37.7971743129098, -122.440650232318) 13 9 1 57 17
114058 239648 1 91 211 Cumberland St 3 Sidewalk: Curb side : Cutout Tree 2     12 Width 3ft   6004246.22251 2104509.47954 37.7588223473949 -122.42836403987 (37.7588223473949, -122.42836403987) 2 4 5 28862 3
115137 251332 1 91 920X Shotwell St 3 Sidewalk: Curb side : Cutout Tree 2   05/08/2017 12:00:00 AM 3 3x3 Permit Number 779528 6007731 2102403 37.7532350085981 -122.416162845847 (37.7532350085981, -122.416162845847) 2 4 7 28859 19
121062 46566 7 91 3900 22nd St 3 Sidewalk: Curb side : Cutout Tree 2   04/02/2002 12:00:00 AM     Permit Number 44701 6002455.82917315 2102994.91492425 37.7545622428397 -122.434447752947 (37.7545622428397, -122.434447752947) 2 4 5 28862 22
129925 200733 1 91 1462 Oakdale Ave 3 unknown : Yard Tree 2     14 Width 0ft   6015790.512 2094948.0194 37.7332150397253 -122.387771048105 (37.7332150397253, -122.387771048105) 10 3 8 58 1
132843 119662 4 91 699x Missouri St 3 Sidewalk: Property side : Yard Tree 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
133977 187556 1 91 3960 Somerset St 3 Side Yard : Yard Tree 2     23     6011365.57696 2088364.56073 37.7148921048592 -122.402606539166 (37.7148921048592, -122.402606539166) 10 7 8 309 39
144402 187554 1 91 3960 Somerset St 3 Side Yard : Yard Tree 2     12     6011368.52295 2088357.85007 37.7148738432156 -122.402595884908 (37.7148738432156, -122.402595884908) 10 7 8 309 39
149656 40810 7 91 240 Maywood Dr 3 Sidewalk: Curb side : Cutout Tree 2   08/25/1999 12:00:00 AM     Permit Number 41757 5994290.46519005 2095120.08849436 37.732473059968 -122.462114481375 (37.732473059968, -122.462114481375) 9 8 4 59 40
158555 104220 7 91 642-652 Castro St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6002365 2104465 37.7585935873912 -122.434866988999 (37.7585935873912, -122.434866988999) 2 4 5 28862 3
169069 112686 4 91 86 STANTON ST 3 Front Yard : Yard Tree 2       3x3   6000281 2103909 37.7569484049338 -122.442034474193 (37.7569484049338, -122.442034474193) 2 4 5 28862 38
173467 35617 7 91 42 Walter St 3 Sidewalk: Curb side : Cutout Tree 2   03/30/1998 12:00:00 AM     Permit Number 38971 6003128.23907612 2108063.84146095 37.7685184402848 -122.432484413704 (37.7685184402848, -122.432484413704) 15 5 5 28862 3
179961 138858 1 91 601 LAGUNA ST 3 Sidewalk: Curb side : Cutout Tree 2     14 Width 0ft   6004946.3367 2111001.3561 37.7766870733429 -122.426404947187 (37.7766870733429, -122.426404947187) 7 9 11 28852 10
181076 197484 1 91 99 Lafayette St 3 : Tree 2     8 Width 3ft   6007489.31465 2109652.98843 37.7731281986314 -122.417512429769 (37.7731281986314, -122.417512429769) 8 2 9 28853 19