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)
11882 81047 1 202 961 Prague St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   2     6001634.70169 2086773.55642 37.7099754779527 -122.436126687404 (37.7099754779527, -122.436126687404) 9 7 6 28861 5
37514 175226 1 202 1150 Munich St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 6ft   6001420.49828 2087082.59126 37.7108118474628 -122.43688912274 (37.7108118474628, -122.43688912274) 9 7 6 28861 5
38481 203600 1 202 200 Minerva St 3 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   5994977.66041 2089033.88982 37.7158013626108 -122.459298115614 (37.7158013626108, -122.459298115614) 9 8 6 28861 24
41452 203615 1 202 240 Colon Ave 2 Sidewalk: Curb side : Yard Tree 2     3 Width 3ft   5996037.38323 2094398.48179 37.7305921283128 -122.456022857589 (37.7305921283128, -122.456022857589) 9 7 4 28861 40
44573 175223 1 202 39 Naylor St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 4ft   6002350.25908 2087113.68805 37.7109500327891 -122.433677880228 (37.7109500327891, -122.433677880228) 9 7 6 28861 5
51205 203592 1 202 1485x Northwood Dr 1 Median : Yard Tree 1     2     5995892.33391 2093907.44512 37.7292355333897 -122.456488817009 (37.7292355333897, -122.456488817009) 9 7 4 28861 40
55725 203601 1 202 601 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 4ft   5995029.86532 2089100.67816 37.7159877489258 -122.459122505898 (37.7159877489258, -122.459122505898) 9 8 6 28861 24
64600 203602 1 202 601 Capitol Ave 2 Sidewalk: Curb side : Cutout Tree 2     2 Width 4ft   5995030.39824 2089062.56731 37.7158831361758 -122.459117905878 (37.7158831361758, -122.459117905878) 9 8 6 28861 24
70475 115759 1 202 1718 Cayuga Ave 3 Sidewalk: Curb side : Cutout Tree 2   02/24/2016 12:00:00 AM 3   Permit Number 772425 5998106.99194 2088701.93877 37.7150693216746 -122.448457855865 (37.7150693216746, -122.448457855865) 9 7 6 28861 25
78033 175218 1 202 93 Morse St 1 Sidewalk: Curb side : Cutout Tree 2     1 Width 4ft   6001014.57653 2087970.42853 37.7132265721263 -122.438355644521 (37.7132265721263, -122.438355644521) 9 7 6 28861 5
79067 175225 1 202 762 Prague St 3 Sidewalk: Curb side : Cutout Tree 2     3 Width 3ft   6002385.00148 2087111.82933 37.7109469004454 -122.433557669663 (37.7109469004454, -122.433557669663) 9 7 6 28861 5
95445 203599 1 202 200 Minerva St 2 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   5994990.66494 2089034.05641 37.7158025676981 -122.459253178313 (37.7158025676981, -122.459253178313) 9 8 6 28861 24
96705 114970 4 202 200X MINERVA ST 3 Sidewalk: Curb side : Cutout Tree 2     2 3x3   5994532 2089023 37.7157458289959 -122.460837724068 (37.7157458289959, -122.460837724068) 9 8 6 28861 24
112583 175217 1 202 1601 San Jose Ave 2 Sidewalk: Property side : Yard Tree 2     1     6001607.87231 2094169.86531 37.7302825582951 -122.436748518241 (37.7302825582951, -122.436748518241) 9 7 6 28861 25
116243 203604 1 202 349 Howth St 1 : Tree 2     2 Width 3ft   5997115.15384 2090174.96464 37.7190571494366 -122.451992266143 (37.7190571494366, -122.451992266143) 9 8 6 28861 24
116404 114968 4 202 200X MINERVA ST 1 Sidewalk: Curb side : Cutout Tree 2     2 3x3   5994532 2089023 37.7157458289959 -122.460837724068 (37.7157458289959, -122.460837724068) 9 8 6 28861 24
128898 203595 1 202 423 Flood Ave 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 2ft   5997934.90621 2094082.1225 37.729832211087 -122.44944008102 (37.729832211087, -122.44944008102) 9 7 4 28861 40
131041 203603 1 202 533 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree 2     1 Width 3ft   5995027.64484 2088883.389 37.7153909965718 -122.459114456087 (37.7153909965718, -122.459114456087) 9 8 6 28861 24
144618 175221 1 202 127 Cotter St 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6001956.44701 2093481.30015 37.728411719314 -122.435494211294 (37.728411719314, -122.435494211294) 9 7 6 28861 25
169515 175220 1 202 178 Allison St 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 4ft   6000035.73488 2087742.43428 37.7125448266481 -122.441722494022 (37.7125448266481, -122.441722494022) 9 7 6 28861 5
175831 114969 4 202 200X MINERVA ST 2 Sidewalk: Curb side : Cutout Tree 2     2 3x3   5994532 2089023 37.7157458289959 -122.460837724068 (37.7157458289959, -122.460837724068) 9 8 6 28861 24
177274 203598 1 202 200 Minerva St 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   5995008.49221 2089033.02481 37.715800760085 -122.459191484793 (37.715800760085, -122.459191484793) 9 8 6 28861 24
180191 175224 1 202 762 Prague St 2 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6002402.88459 2087125.99028 37.710986797965 -122.433496872809 (37.710986797965, -122.433496872809) 9 7 6 28861 5
186582 175227 1 202 225 Naylor St 2 Sidewalk: Curb side : Yard Tree 2     3 Width 6ft   6002635.08266 2086756.92621 37.709986599863 -122.432667995542 (37.709986599863, -122.432667995542) 9 7 6 28861 5
188343 175219 1 202 100 Morse St 5 Sidewalk: Curb side : Yard Tree 2     1 Width 1ft   6000840.49126 2087951.89335 37.7131657752649 -122.438956013912 (37.7131657752649, -122.438956013912) 9 7 6 28861 5
190155 203597 1 202 50 De Montfort Ave 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   5995113.88228 2091909.79504 37.7237057451058 -122.45903538769 (37.7237057451058, -122.45903538769) 9 8 4 28861 24