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)
2730 138025 11 56 1661X Octavia St 2 Sidewalk: Curb side : Cutout Tree 1     49 Width 0ft   6004878.9655 2114979.8902 37.7876073348692 -122.426921423586 (37.7876073348692, -122.426921423586) 13 9 11 28858 27
2985 138087 11 56 1661X Octavia St 6 Sidewalk: Curb side : Cutout Tree 1     30 Width 0ft   6004894.5944 2114873.9606 37.7873173623789 -122.426859803648 (37.7873173623789, -122.426859803648) 13 9 11 28858 27
4739 138026 11 56 1661X Octavia St 3 Sidewalk: Curb side : Cutout Tree 1     57 Width 0ft   6004881.8597 2114953.842 37.7875359766764 -122.426909554358 (37.7875359766764, -122.426909554358) 13 9 11 28858 27
5001 138027 11 56 1661X Octavia St 4 Sidewalk: Curb side : Cutout Tree 1     39 Width 0ft   6004885.3328 2114935.3188 37.7874853129815 -122.426896218405 (37.7874853129815, -122.426896218405) 13 9 11 28858 27
6626 138028 11 56 1661X Octavia St 5 Sidewalk: Curb side : Cutout Tree 1     49 Width 0ft   6004887.6482 2114917.9533 37.7874377625804 -122.426886970359 (37.7874377625804, -122.426886970359) 13 9 11 28858 27
11977 24539 11 301 500X Cortland Ave 3 Sidewalk: Curb side : Cutout Tree 5     50 3X3   6007622.12549 2097206.54003 37.7389605708788 -122.41617135712 (37.7389605708788, -122.41617135712) 2 7 7 28859 2
13887 2618 11 56 1661X Octavia St 5 Sidewalk: Curb side : Cutout Tree 1     42 10X10   6004876.92395 2115038.87855 37.7877691866782 -122.426932689756 (37.7877691866782, -122.426932689756) 13 9 11 28858 27
14279 24540 11 301 500X Cortland Ave 4 Sidewalk: Curb side : Cutout Tree 5     50 3X3   6007652.96823 2097201.05938 37.7389472564055 -122.416064328819 (37.7389472564055, -122.416064328819) 2 7 7 28859 2
18571 138024 11 56 1661 Octavia St 1 Sidewalk: Curb side : Cutout Tree 1     48 Width 0ft   6004873.7558 2115028.5137 37.7877405482561 -122.42694291248 (37.7877405482561, -122.42694291248) 13 9 11 28858 27
28953 2619 11 56 1661X Octavia St 6 Sidewalk: Curb side : Cutout Tree 1     36 10X10   6004877.75733 2115027.26874 37.7877373561683 -122.426928979241 (37.7877373561683, -122.426928979241) 13 9 11 28858 27
40122 2614 11 56 1661X Octavia St 1 Sidewalk: Curb side : Cutout Tree 1     42 10X10   6004876.92395 2115038.87855 37.7877691866782 -122.426932689756 (37.7877691866782, -122.426932689756) 13 9 11 28858 27
47435 2617 11 56 1661X Octavia St 4 Sidewalk: Curb side : Cutout Tree 1     42 10X10   6004876.92395 2115038.87855 37.7877691866782 -122.426932689756 (37.7877691866782, -122.426932689756) 13 9 11 28858 27
49220 7946 11 151 1701 Franklin St 1 Sidewalk: Curb side : Cutout Tree 2     18 3X3   6005703.15328 2116043.32965 37.7905738421571 -122.424145551273 (37.7905738421571, -122.424145551273) 13 9 1 28858 27
51932 253858 11 417 115 Parker Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5996817 2113681 37.7835817804999 -122.454720202744 (37.7835817804999, -122.454720202744) 11 6 1 54 31
135688 1716 11 18 555 Battery St 4 Sidewalk: Curb side : Cutout Tree 1     18 5x15   6012528.51285 2117974.41064 37.7962591384932 -122.400665775228 (37.7962591384932, -122.400665775228) 3 1 10 28860 4
144603 231331 11 16 1221 Stanyan St 1 Sidewalk: Curb side : Cutout Tree 2   04/21/1988 12:00:00 AM 25 Width 4ft Permit Number 25220 5997416.53254 2105659.95446 37.7615924319549 -122.452067155375 (37.7615924319549, -122.452067155375) 15 5 11 29492 12
146721 2615 11 56 1661X Octavia St 2 Sidewalk: Curb side : Cutout Tree 1     42 10X10   6004876.92395 2115038.87855 37.7877691866782 -122.426932689756 (37.7877691866782, -122.426932689756) 13 9 11 28858 27
165250 2616 11 56 1661X Octavia St 3 Sidewalk: Curb side : Cutout Tree 1     42 10X10   6004876.92395 2115038.87855 37.7877691866782 -122.426932689756 (37.7877691866782, -122.426932689756) 13 9 11 28858 27
167750 64380 11 471 1221 Stanyan St 1 Sidewalk: Curb side : Cutout Tree 2   04/21/1988 12:00:00 AM     Permit Number 25220 5997415.00742592 2105661.0761541 37.7615954244829 -122.452072511028 (37.7615954244829, -122.452072511028) 15 5 11 29492 12