sf-trees

Data source: data.sfgov.org

Custom SQL query returning 16 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
174137 84659 2 48 187 Beaumont Ave 1 1 1 1 1   1     5996845.0781 2111686.6666 37.7781074773999 -122.45447894833201 (37.7781074773999, -122.454478948332)
175623 184549 2 48 3501 Moraga St 3 2 1 1     1 Width 0ft   5983411.1343 2103548.3965 37.754982490057 -122.50034921882099 (37.754982490057, -122.500349218821)
175819 117934 2 48 867 42nd Ave 1 1 1 1     1 Width 3ft   5982916.92515 2109877.9656700003 37.7723326617078 -122.502526759002 (37.7723326617078, -122.502526759002)
176471 182700 2 48 1651 Moraga St 2 1 1 1     1 Width 0ft   5989102.9459 2103739.8915 37.7558407372502 -122.48067956122401 (37.7558407372502, -122.480679561224)
177014 95521 1 48 1510 35th Ave 1 1 1 1 1 03/01/2011 12:00:00 AM 1 3x3 Permit Number 767313 5985302.4962 2104889.3961 37.7587753414156 -122.49390726731899 (37.7587753414156, -122.493907267319)
177664 118188 2 48 762 34th Ave 1 1 1 1     1 Width 3ft   5985415.78787 2110692.34221 37.7747152280145 -122.49394311659901 (37.7747152280145, -122.493943116599)
178120 181690 2 48 1374 45th Ave 1 1 1 1     1 Width 0ft   5982168.1662 2105754.9295 37.760967965591604 -122.504811174863 (37.7609679655916, -122.504811174863)
178920 201812 2 48 101 Friedell St 3 4 1 1     1 Width 6ft   6021065.67541 2093224.76894 37.728774126326705 -122.369414113788 (37.7287741263267, -122.369414113788)
179813 137671 2 48 756 LYON ST 1 1 1 1     1 Width 0ft   6000049.6788 2111547.4906 37.7779086039439 -122.443383113797 (37.7779086039439, -122.443383113797)
180010 118666 2 48 465 43rd Ave 3 1 1 1     1 Width 4ft   5982506.22463 2112651.7557200002 37.779924536981504 -122.50415288931299 (37.7799245369815, -122.504152889313)
180870 227099 2 48 75 Montcalm St 2 1 1 1     1 Width 3ft   6010635.77556 2100089.10311 37.7470444571367 -122.40595450111401 (37.7470444571367, -122.405954501114)
185807 182658 2 48 2242 Ortega St 1 1 1 1     1 Width 0ft   5987004.6631 2102364.6195 37.751942436508706 -122.487834969288 (37.7519424365087, -122.487834969288)
186108 176878 2 48 526 Lathrop Ave 17 1 1 1     1 Width 3ft   6013154.94381 2086496.55313 37.709862662502104 -122.396290845073 (37.7098626625021, -122.396290845073)
187121 58124 1 48 527 15th Ave 1 1 1 1   02/10/1978 12:00:00 AM 1   Permit Number 17106 5991241.869630001 2111793.32926 37.778077396785 -122.473870058582 (37.778077396785, -122.473870058582)
187445 176900 2 48 167 Madison St 3 9 1 1     1 Width 4ft   6005606.72127 2092829.9713400002 37.7268299557374 -122.42282875044701 (37.7268299557374, -122.422828750447)
188215 183121 2 48 2327 41st Ave 5 1 1 1     1 Width 0ft   5983581.7952 2099373.3538 37.7435289932417 -122.49945051311 (37.7435289932417, -122.49945051311)
Powered by Datasette · Query took 1.463ms · Data source: data.sfgov.org