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)
5600 241053 1 86 201 Coso Ave 3 Side Yard : Yard Tree 2     11 Width 5ft   6007672.87316 2099533.13544 37.7453517387841 -122.416160625529 (37.7453517387841, -122.416160625529) 2 7 7 28859 2
43003 136693 1 86 2164 Hyde St 5 Sidewalk: Property side : Yard Tree 2     6 Width 5ft   6007181.34298 2119779.01061 37.8009144395066 -122.41929620626 (37.8009144395066, -122.41929620626) 5 1 1 28858 32
44005 179893 1 86 101 Dartmouth St 10 Sidewalk: Property side : Yard Tree 2     8 Width 5ft   6008518.11565 2093559.33094 37.7289964630154 -122.412815641254 (37.7289964630154, -122.412815641254) 9 3 7 309 28
51255 215297 1 86 615 Hearst Ave 5 Sidewalk: Property side : Yard Tree 2     12 Width 5ft   5997404.12695 2094370.52949 37.7305937308948 -122.45129582845 (37.7305937308948, -122.45129582845) 9 7 4 28861 40
63554 241060 1 86 112 Crescent Ave 3 Sidewalk: Curb side : Yard Tree 2     5 Width 5ft   6005928.78547 2095826.36488 37.7350755589952 -122.421928139697 (37.7350755589952, -122.421928139697) 2 7 7 28859 2
65143 241059 1 86 112 Crescent Ave 2 Sidewalk: Curb side : Yard Tree 2     6 Width 5ft   6005916.72603 2095826.92897 37.7350764277358 -122.421969873622 (37.7350764277358, -122.421969873622) 2 7 7 28859 2
68300 241061 1 86 112 Crescent Ave 4 Sidewalk: Curb side : Yard Tree 2     7 Width 5ft   6005940.184 2095824.54912 37.7350712161596 -122.421888601897 (37.7350712161596, -122.421888601897) 2 7 7 28859 2
81457 179891 1 86 101 Dartmouth St 7 Sidewalk: Property side : Yard Tree 2     8 Width 5ft   6008528.33324 2093531.3526 37.7289202139869 -122.41277834095 (37.7289202139869, -122.41277834095) 9 3 7 309 28
126177 179892 1 86 101 Dartmouth St 9 Sidewalk: Property side : Yard Tree 2     9 Width 5ft   6008521.95318 2093544.04536 37.728954707483 -122.412801294348 (37.728954707483, -122.412801294348) 9 3 7 309 28
126944 241063 1 86 112 Crescent Ave 6 Sidewalk: Curb side : Yard Tree 2     5 Width 5ft   6005947.85615 2095824.2566 37.73507084564 -122.421862055716 (37.73507084564, -122.421862055716) 2 7 7 28859 2
128394 241062 1 86 112 Crescent Ave 5 Sidewalk: Curb side : Yard Tree 2     5 Width 5ft   6005944.68012 2095825.54843 37.7350742136048 -122.421873128139 (37.7350742136048, -122.421873128139) 2 7 7 28859 2
129935 215324 1 86 1288 08th Ave 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 5ft   5993647.63812 2106753.81902 37.764379290687 -122.465181573075 (37.764379290687, -122.465181573075) 11 8 11 56 12
137739 241056 1 86 4864 17th St 3 Sidewalk: Property side : Yard Tree 2     9 Width 5ft   5997871.31028 2105665.38567 37.7616333843862 -122.450494663794 (37.7616333843862, -122.450494663794) 15 5 11 29492 9
149391 215296 1 86 615 Hearst Ave 3 Sidewalk: Property side : Yard Tree 2     15 Width 5ft   5997379.68023 2094370.54244 37.7305923666319 -122.451380344931 (37.7305923666319, -122.451380344931) 9 7 4 28861 40
167373 215302 1 86 698 Hearst Ave 9 Sidewalk: Property side : Yard Tree 2     15 Width 5ft   5996836.53539 2094438.39167 37.7307475482438 -122.453262964135 (37.7307475482438, -122.453262964135) 9 7 4 59 40
168206 179823 1 86 285 Foote Ave 2 Sidewalk: Property side : Yard Tree 2     6 Width 5ft   5998235.7927 2088724.10902 37.7151375595318 -122.448014262544 (37.7151375595318, -122.448014262544) 9 7 6 28861 25
172817 179824 1 86 285 Foote Ave 3 Sidewalk: Property side : Yard Tree 2     6 Width 5ft   5998241.3307 2088717.20403 37.715118916577 -122.447994624052 (37.715118916577, -122.447994624052) 9 7 6 28861 25
188876 241058 1 86 112 Crescent Ave 1 Sidewalk: Curb side : Yard Tree 2     6 Width 5ft   6005911.64547 2095827.03332 37.7350764277212 -122.421987446374 (37.7350764277212, -122.421987446374) 2 7 7 28859 2
189782 241071 1 86 1 Vicksburg St 2 Sidewalk: Curb side : Cutout Tree 2     13 Width 5ft   6004095.14268 2103015.18666 37.7547108223494 -122.428780017682 (37.7547108223494, -122.428780017682) 2 4 5 28862 22