trees

Custom SQL query returning 17 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
8003 21791 7 5 2585 Taylor St 6 Sidewalk: Curb side : Cutout Tree 2     8 4X4   6008347.28278 2121527.17705 37.8057800612465 -122.415385378175 (37.8057800612465, -122.415385378175) 5 1 10 308 23
18931 16634 1 5 158 Noe St 1 Sidewalk: Curb side : Cutout Tree 1     18 4X4   6002846.26234 2107315.61995 37.7664480128774 -122.433406271499 (37.7664480128774, -122.433406271499) 15 5 5 28862 3
34503 21789 1 5 2585 Taylor St 4 Sidewalk: Curb side : Cutout Tree 1   05/20/2015 12:00:00 AM 3 4X4   6008161.90241 2121549.79462 37.8058317424248 -122.41602851934 (37.8058317424248, -122.41602851934) 5 1 10 308 23
36850 21792 1 5 2598 Taylor St 1 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.415074380155 (37.8060518410095, -122.415074380155) 3 1 10 308 23
55304 14686 1 5 775 McAllister St 1 Sidewalk: Curb side : Cutout Tree 1     16 4X4   6005447.7824 2111997.5051 37.7794505882327 -122.424741179621 (37.7794505882327, -122.424741179621) 7 9 11 28852 41
62291 5529 1 5 895 Dolores St 1 Sidewalk: Curb side : Cutout Tree 1     100 4X4   6005093.86648 2103161.82188 37.7551699235695 -122.425336590916 (37.7551699235695, -122.425336590916) 2 4 5 28859 19
64093 21787 7 5 2585 Taylor St 2 Sidewalk: Curb side : Cutout Tree 2     10 4X4   6008331.30284 2121636.25204 37.8060786554609 -122.415448406282 (37.8060786554609, -122.415448406282) 5 1 10 308 23
66656 16644 1 5 170 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     12 4X4   6002849.24717 2107272.65524 37.7663302115978 -122.433392876987 (37.7663302115978, -122.433392876987) 15 5 5 28862 3
67442 21780 7 5 2535 Taylor St 2 Sidewalk: Curb side : Cutout Tree 2     3 4X4   6008357.89402 2121452.8869 37.805576675639 -122.41534339379 (37.805576675639, -122.41534339379) 5 1 10 308 23
71054 21785 1 5 2585 Taylor St 1 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6008161.90241 2121549.79462 37.8058317424248 -122.41602851934 (37.8058317424248, -122.41602851934) 5 1 10 308 23
72985 21790 7 5 2585 Taylor St 5 Sidewalk: Curb side : Cutout Tree 2     9 4X4   6008342.51156 2121554.8602 37.8058558040212 -122.415403850799 (37.8058558040212, -122.415403850799) 5 1 10 308 23
100104 21793 1 5 2598 Taylor St 2 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.415074380155 (37.8060518410095, -122.415074380155) 3 1 10 308 23
142841 21786 7 5 2585 Taylor St 7 Sidewalk: Curb side : Cutout Tree 2     8 4X4   6008350.54359 2121501.89618 37.8057108296313 -122.415372302772 (37.8057108296313, -122.415372302772) 5 1 10 308 23
142913 21795 1 5 2598 Taylor St 4 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.415074380155 (37.8060518410095, -122.415074380155) 3 1 10 308 23
145684 21794 1 5 2598 Taylor St 3 Sidewalk: Curb side : Cutout Tree 1     21 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.415074380155 (37.8060518410095, -122.415074380155) 3 1 10 308 23
176301 21784 1 5 2550X Taylor St 4 Sidewalk: Curb side : Cutout Tree 1   02/11/2016 12:00:00 AM 12 4X4   6008458.56586 2121488.77145 37.8056808631332 -122.41499754514 (37.8056808631332, -122.41499754514) 3 1 10 308 23
182657 5384 1 5 325X Dolores St 2 Sidewalk: Curb side : Cutout Tree 1     90 4X4   6004919.4864142 2106495.5645768 37.7643137401636 -122.426176974515 (37.7643137401636, -122.426176974515) 8 4 5 28859 19