sf-trees

Data source: data.sfgov.org

Custom SQL query returning 46 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1099 250070 3 70 399 Austin St 1 4 1 2     2 Width 3ft   6005393.47416 2115303.0126799997 37.788523627097 -122.425164323999 (37.788523627097, -122.425164323999)
24295 249534 2 70 201 Myrtle St 3 4 1 1     7 Width 3ft   6006252.357009999 2114034.72493 37.785089704362704 -122.422102579373 (37.7850897043627, -122.422102579373)
25088 189157 2 70 2 Shipley St 5 4 1 1     7 Width 3ft   6012230.29612 2112453.73281 37.78108402055079 -122.40130951984501 (37.7810840205508, -122.401309519845)
27386 220596 2 70 452 Shotwell St 1 4 1 1     4 Width 3ft   6007814.59662 2105186.38117 37.7608822364448 -122.416070852512 (37.7608822364448, -122.416070852512)
27524 189155 2 70 2 Shipley St 3 4 1 1     5 Width 3ft   6012260.87565 2112478.52323 37.7811537953404 -122.40120547186899 (37.7811537953404, -122.401205471869)
33240 189153 2 70 2 Shipley St 1 4 1 1     6 Width 3ft   6012332.534469999 2112551.48713 37.781358134807796 -122.400962694499 (37.7813581348078, -122.400962694499)
33829 189162 2 70 109 Kissling St 5 4 1 1     2 Width 3ft   6008137.74771 2109383.99653 37.7724260745213 -122.41525036411998 (37.7724260745213, -122.41525036412)
36697 220597 2 70 452 Shotwell St 3 4 1 1     4 Width 3ft   6007815.2262 2105168.52935 37.7608332548635 -122.416067410784 (37.7608332548635, -122.416067410784)
37156 189173 2 70 1960 Quesada Ave 1 4 1 1     4 Width 2ft   6013345.84088 2096070.7044 37.73616197508429 -122.396301660307 (37.7361619750843, -122.396301660307)
40929 249550 2 70 380 Fern St 2 4 1 1     7 Width 2ft   6005507.2276099995 2114996.10092 37.7876873493358 -122.424748911848 (37.7876873493358, -122.424748911848)
43603 249538 2 70 201 Myrtle St 7 4 1 1     4 Width 3ft   6006360.10871 2114050.0114700003 37.785137754239294 -122.421730877876 (37.7851377542393, -122.421730877876)
46216 189159 2 70 109 Kissling St 2 4 1 1     2 Width 3ft   6008170.01676 2109410.076 37.7724994960939 -122.415140588393 (37.7724994960939, -122.415140588393)
47327 201923 2 70 125 Elmira St 1 4 1 1     13 Width 4ft   6011215.48386 2096005.8192 37.735865039640395 -122.403662651736 (37.7358650396404, -122.403662651736)
48850 246960 2 70 2177 15th St 1 4 1 1     2 Width 3ft   6003038.46952 2107086.92585 37.7658309772437 -122.432725124067 (37.7658309772437, -122.432725124067)
55787 189171 2 70 672 Missouri St 2 4 1 1     4 Width 1ft   6013547.271380001 2103937.2716200002 37.7577731065529 -122.396156373043 (37.7577731065529, -122.396156373043)
56342 125442 2 70 3719 Scott St 1 4 1 1     1 Width 3ft   6000612.64349 2121133.3219999997 37.8042608824853 -122.442123892024 (37.8042608824853, -122.442123892024)
60321 203473 2 70 128 Howth St 1 4 1 1     10 Width 3ft   5997584.72507 2091125.26044 37.7216933258806 -122.450437617121 (37.7216933258806, -122.450437617121)
63274 203472 2 70 126 Howth St 1 4 1 1     5 Width 3ft   5997592.47815 2091138.0222 37.721728810427706 -122.450411736413 (37.7217288104277, -122.450411736413)
67177 249537 2 70 201 Myrtle St 6 4 1 1     5 Width 3ft   6006345.87488 2114047.3209700002 37.7851295641198 -122.421779931396 (37.7851295641198, -122.421779931396)
70634 189160 2 70 109 Kissling St 3 4 1 1     2 Width 3ft   6008158.83722 2109400.5814099996 37.772472797918 -122.415178587445 (37.772472797918, -122.415178587445)
130236 189156 2 70 2 Shipley St 4 4 1 1     5 Width 3ft   6012246.95244 2112466.10025 37.7811189079475 -122.401252766302 (37.7811189079475, -122.401252766302)
131923 125440 2 70 3517 Divisadero St 1 4 1 1     4 Width 2ft   6000220.82214 2120372.11662 37.8021484793247 -122.44342510578801 (37.8021484793247, -122.443425105788)
132055 189161 2 70 109 Kissling St 4 4 1 1     2 Width 3ft   6008149.50016 2109391.65635 37.7724477670719 -122.41521025345699 (37.7724477670719, -122.415210253457)
132641 250079 2 70 399 Austin St 5 4 1 1     13 Width 3ft   6005448.26526 2115310.78255 37.7885480563034 -122.42497530809099 (37.7885480563034, -122.424975308091)
136912 250078 2 70 399 Austin St 4 4 1 1     8 Width 3ft   6005435.52045 2115308.45101 37.78854093456471 -122.425019237271 (37.7885409345647, -122.425019237271)
148423 189174 2 70 14 Waterville St 1 4 1 1     10 Width 1ft   6011435.762019999 2096086.73565 37.7360995216629 -122.40290674814301 (37.7360995216629, -122.402906748143)
148879 249535 2 70 201 Myrtle St 4 4 1 1     5 Width 3ft   6006279.61488 2114039.5342599996 37.7851044469537 -122.422008617322 (37.7851044469537, -122.422008617322)
148997 125441 2 70 3517 Divisadero St 2 4 1 1     4 Width 2ft   6000221.62171 2120363.5906700003 37.8021251149445 -122.443421726125 (37.8021251149445, -122.443421726125)
149175 249549 2 70 380 Fern St 1 4 1 1     8 Width 2ft   6005525.061919999 2114997.09858 37.7876910959164 -122.424687279516 (37.7876910959164, -122.424687279516)
151339 189154 2 70 2 Shipley St 2 4 1 1     7 Width 3ft   6012314.00092 2112536.43535 37.781315772258104 -122.401025754031 (37.7813157722581, -122.401025754031)
156002 220591 2 70 45 Pearl St 1 4 1 1     11 Width 3ft   6005640.71146 2108782.82006 37.770634736546896 -122.42384510757601 (37.7706347365469, -122.423845107576)
162716 125448 2 70 3057 Franklin St 2 4 1 1     5 Width 2ft   6005070.86935 2120497.70862 37.8027687129688 -122.426650549882 (37.8027687129688, -122.426650549882)
163457 189152 2 70 1665 Hudson Ave 1 4 1 1     2 Width 3ft   6015368.44602 2097645.0372099997 37.7405971121722 -122.389418536259 (37.7405971121722, -122.389418536259)
168630 249544 2 70 298 Myrtle St 1 4 1 1     6 Width 3ft   6006142.8789800005 2114042.34322 37.7851044469485 -122.422481881052 (37.7851044469485, -122.422481881052)
170392 125444 2 70 3676 Fillmore St 3 4 1 1     6 Width 2ft   6002146.17897 2121077.47724 37.8041948227854 -122.436812979831 (37.8041948227854, -122.436812979831)
172051 249551 2 70 380 Fern St 3 4 1 1     7 Width 2ft   6005490.31575 2114993.82461 37.787680143969496 -122.424807261672 (37.7876801439695, -122.424807261672)
173152 249533 2 70 201 Myrtle St 2 4 1 1     3 Width 3ft   6006226.92854 2114031.46887 37.78507932978 -122.42219032262 (37.78507932978, -122.42219032262)
173556 246911 2 70 459 Frederick St 2 4 1 1     3 Width 3ft   5997556.58518 2107424.48902 37.766445417441204 -122.451710064262 (37.7664454174412, -122.451710064262)
177222 125447 2 70 3057 Franklin St 1 4 1 1     5 Width 2ft   6005068.7625400005 2120514.19483 37.8028138607435 -122.426659015206 (37.8028138607435, -122.426659015206)
181941 250077 2 70 399 Austin St 3 4 1 1     13 Width 3ft   6005420.83643 2115306.80822 37.7885355944018 -122.425069924841 (37.7885355944018, -122.425069924841)
182097 249536 2 70 201 Myrtle St 5 4 1 1     6 Width 3ft   6006331.73852 2114045.88325 37.7851248193023 -122.421828736708 (37.7851248193023, -122.421828736708)
182457 246824 2 70 402 Franconia St 1 4 1 1     10 Width 4ft   6009972.67277 2098701.6792900003 37.7431977860534 -122.408149630203 (37.7431977860534, -122.408149630203)
185548 203447 2 70 327 Ralston St 1 4 1 1     3 Width 3ft   5992190.092759999 2090032.52678 37.7183827154591 -122.469005784505 (37.7183827154591, -122.469005784505)
186515 189172 2 70 1947 Quesada Ave 1 4 1 1     2 Width 2ft   6013391.6303 2095988.7563900002 37.735939510689605 -122.396137605077 (37.7359395106896, -122.396137605077)
186745 189158 2 70 109 Kissling St 1 4 1 1     2 Width 3ft   6008181.208740001 2109420.17856 37.7725278642987 -122.41510258932301 (37.7725278642987, -122.415102589323)
187777 250076 2 70 399 Austin St 2 4 1 1     11 Width 3ft   6005407.46076 2115305.4621099997 37.788531142735295 -122.425116106829 (37.7885311427353, -122.425116106829)
Powered by Datasette · Query took 14.529ms · Data source: data.sfgov.org