sf-trees

Data source: data.sfgov.org

Custom SQL query returning 39 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
44565 201717 2 47 1 Hawkins Ln 2 17 1 1     24     6017089.1408 2095350.86435 37.7343930239173 -122.38330932287201 (37.7343930239173, -122.383309322872)
51235 201716 2 47 1 Hawkins Ln 1 17 1 1     17     6017085.9132900005 2095352.6498 37.7343977480421 -122.38332060578001 (37.7343977480421, -122.38332060578)
55847 201720 2 47 1 Hawkins Ln 5 17 1 1     17     6017109.38533 2095355.2358400002 37.734406145933704 -122.383239634411 (37.7344061459337, -122.383239634411)
58146 201718 2 47 1 Hawkins Ln 3 17 1 1     14     6017093.28201 2095356.3247099998 37.7344082458391 -122.38329538517401 (37.7344082458391, -122.383295385174)
65706 201723 2 47 1 Hawkins Ln 6 17 1 1     10     6017160.60225 2095378.34378 37.734472425960895 -122.383064166774 (37.7344724259609, -122.383064166774)
146514 201719 2 47 1 Hawkins Ln 4 17 1 1     15     6017095.79964 2095357.4210400002 37.7344113952763 -122.38328675710501 (37.7344113952763, -122.383286757105)
167728 201724 2 47 1 Hawkins Ln 7 17 1 1     28     6017165.24184 2095383.9343 37.7344880327856 -122.383048514986 (37.7344880327856, -122.383048514986)
30768 223720 2 47 10 Crescent Ave 3 17 1 1     15 Width 3ft   6005295.72226 2095902.89747 37.7352499770995 -122.424122309196 (37.7352499770995, -122.424122309196)
67552 223719 2 47 10 Crescent Ave 4 17 1 1     6 Width 3ft   6005300.64092 2095902.62438 37.735249504969104 -122.424105284154 (37.7352495049691, -122.424105284154)
9916 173733 3 47 14 Richland Ave 1 17 1 2       3x3   6004601.0 2096122.0 37.7358123337564 -122.426539816145 (37.7358123337564, -122.426539816145)
38454 249866 2 47 1497 Montgomery St 2 17 1 1     20 Width 0ft   6011357.005059999 2120690.5710400003 37.8036516466761 -122.404910787509 (37.8036516466761, -122.404910787509)
171449 249865 2 47 1497 Montgomery St 1 17 1 1     24 Width 0ft   6011350.601919999 2120707.91777 37.8036989186248 -122.404934168095 (37.8036989186248, -122.404934168095)
158925 248059 2 47 18 Rutledge St 1 17 1 1     41     6010698.28988 2099365.5413599997 37.7450612101031 -122.40568737459299 (37.7450612101031, -122.405687374593)
35448 176098 2 47 184 Mount Vernon Ave 8 17 1 1     6     5998949.65718 2089392.42013 37.717013369950706 -122.44559487852699 (37.7170133699507, -122.445594878527)
65775 176097 2 47 184 Mount Vernon Ave 6 17 1 1     12     5998962.663240001 2089377.08137 37.716971995749795 -122.445548820645 (37.7169719957498, -122.445548820645)
180895 176096 2 47 184 Mount Vernon Ave 5 17 1 1     15     5998966.43073 2089373.6298 37.7169627336137 -122.445535550248 (37.7169627336137, -122.445535550248)
46469 250199 2 47 201 Union St 5 17 1 1     15 Width 0ft   6011821.07725 2119768.34547 37.8011453692141 -122.403239919993 (37.8011453692141, -122.403239919993)
60552 250197 2 47 201 Union St 3 17 1 1     14 Width 0ft   6011839.72623 2119769.92251 37.8011507408769 -122.403175497057 (37.8011507408769, -122.403175497057)
156317 250196 2 47 201 Union St 2 17 1 1     18 Width 0ft   6011857.70339 2119785.90004 37.801195615236395 -122.403114412425 (37.8011956152364, -122.403114412425)
186554 250195 2 47 201 Union St 1 17 1 1     18 Width 0ft   6011875.28376 2119779.56963 37.8011792152183 -122.40305313080401 (37.8011792152183, -122.403053130804)
53056 248184 2 47 216 Esmeralda Ave 3 17 1 1     28     6007432.5204300005 2098714.89498 37.7430915158666 -122.416933765486 (37.7430915158666, -122.416933765486)
136128 218153 2 47 22 Ashton Ave 1 17 1 1     20     5994153.71185 2090014.1877400002 37.7184456203604 -122.46221709555 (37.7184456203604, -122.46221709555)
69463 205919 2 47 230 Edna St 2 17 1 1     34     5998797.1475 2095343.94395 37.7333461617934 -122.44654997291599 (37.7333461617934, -122.446549972916)
35115 126414 2 47 2836 Larkin St 10 17 1 1     12     6006501.05561 2120998.5397099997 37.804224619123296 -122.421736962694 (37.8042246191233, -122.421736962694)
59780 126415 2 47 2836 Larkin St 11 17 1 1     48     6006502.51226 2121001.4648 37.804232732814704 -122.421732129727 (37.8042327328147, -122.421732129727)
184674 126416 2 47 2836 Larkin St 12 17 1 1     46     6006501.512069999 2121012.26216 37.804262323204895 -122.421736358356 (37.8042623232049, -122.421736358356)
181873 250227 2 47 312 Filbert St 7 17 1 1     17 Width 0ft   6011220.88869 2120048.61475 37.8018813824768 -122.40533659221902 (37.8018813824768, -122.405336592219)
66895 176112 2 47 35 Tomaso Ct 4 17 1 1     15 Width 3ft   6009187.4096 2086275.4475900002 37.7090339795175 -122.409987838189 (37.7090339795175, -122.409987838189)
135623 247911 2 47 399 Franconia St 2 17 1 1     39     6009944.29918 2098783.53182 37.7434209465163 -122.408253510886 (37.7434209465163, -122.408253510886)
34240 247903 2 47 582 Esmeralda Ave 1 17 1 1     31     6009830.823 2098729.7061900003 37.743266798225605 -122.40864208815701 (37.7432667982256, -122.408642088157)
152144 223808 2 47 6 Miguel St 1 17 1 1     37     6003326.01138 2097344.7820099997 37.739097652747205 -122.431035195413 (37.7390976527472, -122.431035195413)
186272 223809 2 47 6 Miguel St 2 17 1 1     34     6003330.909440001 2097346.2966299998 37.7391020890899 -122.431018368229 (37.7391020890899, -122.431018368229)
1875 251783 3 47 610 Clipper St 5 17 1 2       Width 2ft   6001275.75039 2100902.7174 37.7487505133321 -122.438378885672 (37.7487505133321, -122.438378885672)
75219 176164 2 47 654 Peru Ave 2 17 1 1     33     6005136.16004 2092540.09119 37.7260074465758 -122.42443486048201 (37.7260074465758, -122.424434860482)
166544 176163 2 47 654 Peru Ave 1 17 1 1     23     6005125.75661 2092550.7271200002 37.726036063007705 -122.42447158070601 (37.7260360630077, -122.424471580706)
167034 176166 2 47 654 Peru Ave 4 17 1 1     30     6005147.67241 2092530.2100099998 37.7259809651314 -122.424394360408 (37.7259809651314, -122.424394360408)
179538 176165 2 47 654 Peru Ave 3 17 1 1     27     6005141.81262 2092533.90812 37.7259907884276 -122.42441488026199 (37.7259907884276, -122.424414880262)
13271 187638 6 47 875 El Camino Del Mar 2 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
13275 187637 6 47 875 El Camino Del Mar 1 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
Powered by Datasette · Query took 10.508ms · Data source: data.sfgov.org