sf-trees

Data source: data.sfgov.org

Custom SQL query returning 22 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
19468 6756 3 43 1215 Fairfax Ave 10 1 1 2     18 3x3 Permit Number 769095 6017521.099066501 2096743.3718321999 37.7382404347673 -122.381912713319 (37.7382404347673, -122.381912713319)
77710 6828 1 43 1450X Fairfax Ave 10 1 1 11     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
80976 41195 1 43 500 16th St 10 1 1 1 1 02/03/1996 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.38916212984199 (37.7669713213554, -122.389162129842)
95830 26951 3 43 2040 Sutter St 10 1 1 2     17 5x6   6002681.79801 2114441.89018 37.7860056439611 -122.434484700269 (37.7860056439611, -122.434484700269)
99696 113009 2 43 700x STANYAN ST 10 1 1 1       3x3   5997124.0 2108268.0 37.768736698354004 -122.453267191941 (37.768736698354, -122.453267191941)
99925 110704 2 43 2999X Turk St 10 1 1 1       3x3   5996638.0 2111487.0 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531)
103423 22714 1 43 1401X Turk St 10 1 1 18     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894)
105794 95046 3 43 3224 Pierce St 10 5 1 10     13 3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
106155 49290 1 43 2X Spear St 10 1 1 1   02/07/2003 12:00:00 AM     Permit Number 46305 6014371.0 2116872.0 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763)
106478 49239 1 43 500 Howard St 10 1 1 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
106836 110991 1 43 245x North Point St 10 1 1 1           6009556.06624176 2121873.83782792 37.806799769840296 -122.41122668881 (37.8067997698403, -122.41122668881)
106865 17729 1 43 1300X Pierce St 10 1 1 3     60 3X3   6002290.5602400005 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321)
108974 99595 2 43 1855X Evans Ave 10 1 1 1     10 3x3   6014349.8 2099426.2 37.7454312840379 -122.393065244865 (37.7454312840379, -122.393065244865)
114562 101724 2 43 560 Wisconsin St 10 1 1 1           6012536.0 2104936.0 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341)
115723 101767 2 43 45X 11th St 10 1 1 1     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.41790686002899 (37.7750397101602, -122.417906860029)
116711 103637 2 43 1450X Stevenson St 10 1 1 1     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.768764440650294 -122.42141735000799 (37.7687644406503, -122.421417350008)
117983 40357 1 43 379 TEHAMA ST 10 1 1 1   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447.0 2112547.0 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764)
120694 21805 3 43 2600X Taylor St 10 1 1 2   03/01/2016 12:00:00 AM 3 3X3   6008553.39113 2121935.04647 37.806911549800795 -122.414700989571 (37.8069115498008, -122.414700989571)
120886 48703 1 43 405 Howard St 10 1 1 1   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931)
139108 6818 1 43 1400X Fairfax Ave 10 1 1 11     12 3X3   6016560.821272099 2097522.8211505003 37.740327568702895 -122.385287208511 (37.7403275687029, -122.385287208511)
140910 50573 1 43 2295 Folsom St 10 1 1 1   11/18/2003 12:00:00 AM     Permit Number 47188 6008194.0 2105070.0 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926)
141141 120134 2 43 10X Grove St 10 1 1 1       3x3   6007842.0 2111812.0 37.779076168386105 -122.41644540073798 (37.7790761683861, -122.416445400738)
Powered by Datasette · Query took 13.038ms · Data source: data.sfgov.org