sf-trees

Data source: data.sfgov.org

Custom SQL query returning 23 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1982 118349 3 109 100X Guerrero St 4 11 1 2   07/15/2016 06:43:00 AM 3              
111021 43728 1 109 760 Lakeview Ave 4 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
153605 221517 3 109 1300x Guerrero St 4 11 1 2     7 Width 3ft   6005823.4134 2101214.1336 37.7498632112216 -122.422675198428 (37.7498632112216, -122.422675198428)
155379 221559 2 109 1306 York St 4 4 1 1     7 Width 3ft   6010039.89073 2101557.1439900002 37.7510420290671 -122.408118546954 (37.7510420290671, -122.408118546954)
65787 221527 3 109 1200x Guerrero St 4 11 1 2     7 Width 3ft   6005790.21854 2101800.81566 37.7514722323764 -122.422831677752 (37.7514722323764, -122.422831677752)
18710 91284 3 109 1212x Guerrero St 4 11 1 2   11/20/2008 12:00:00 AM 3     6005738.0 2101906.0 37.7517580978369 -122.42301973133999 (37.7517580978369, -122.42301973134)
179284 221563 2 109 4286 23rd St 4 1 1 1     1 Width 3ft   6001305.60339 2102341.6071 37.752703058000705 -122.438378727412 (37.7527030580007, -122.438378727412)
130218 221537 3 109 1100x Guerrero St 4 11 1 2     6 Width 3ft   6005757.84067 2102377.3752200003 37.753053504939 -122.422984619142 (37.753053504939, -122.422984619142)
148793 221561 2 109 100 San Jose Ave 4 1 1 1     1 Width 3ft   6006161.81341 2102510.42937 37.7534416280528 -122.42159704977 (37.7534416280528, -122.42159704977)
131374 221548 3 109 1000x Guerrero St 4 11 1 2     3 Width 3ft   6005727.072790001 2102965.9789400003 37.7546679382008 -122.42313285530899 (37.7546679382008, -122.423132855309)
18919 110775 3 109 1000X GUERRERO ST 4 11 1 2   05/26/2015 02:57:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
5137 152415 3 109 700x Guerrero St 4 11 1 2     0 Width 3ft   6005628.48676 2104715.95286 37.7594673942256 -122.423598204106 (37.7594673942256, -122.423598204106)
4491 221497 3 109 600x Guerrero St 4 11 1 2   02/21/2015 10:57:00 PM 2 Width 3ft   6005595.06917 2105295.4476799998 37.761056664463204 -122.42375498292499 (37.7610566644632, -122.423754982925)
88573 109696 3 109 600x GUERRERO ST 4 11 1 2   02/21/2015 10:57:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
65305 221484 3 109 500x Guerrero St 4 11 1 2     2 Width 3ft   6005563.22827 2105880.05418 37.7626600585326 -122.42390667874399 (37.7626600585326, -122.423906678744)
4370 221471 3 109 400x Guerrero St 4 11 1 2   04/29/2015 10:27:00 AM 1 Width 3ft   6005532.14271 2106464.3538900004 37.764262652233704 -122.42405574678301 (37.7642626522337, -122.424055746783)
47711 187781 2 109 101 Pennsylvania Ave 4 7 1 1     3     6014331.70125 2106323.79299 37.7643695906061 -122.393610496623 (37.7643695906061, -122.393610496623)
90408 110621 3 109 400X GUERRERO ST 4 11 1 2   04/29/2015 10:27:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
122606 110762 3 109 300X GUERRERO ST 4 11 1 2   06/19/2015 10:45:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
4381 221459 3 109 300x Guerrero St 4 11 1 2   06/19/2015 10:45:00 AM 3 Width 3ft   6005495.536040001 2107056.71588 37.7658870706576 -122.424224491084 (37.7658870706576, -122.424224491084)
4420 221452 3 109 200x Guerrero St 4 11 1 2   02/09/2016 11:41:00 AM 1 Width 3ft   6005465.56003 2107641.57919 37.7674912732207 -122.42436977475501 (37.7674912732207, -122.424369774755)
75755 115513 3 109 200x Guerrero St 4 11 1 2   02/09/2016 11:41:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
766 221431 3 109 100x Guerrero St 4 11 1 2   07/15/2016 06:43:00 AM 1 Width 3ft   6005433.2519 2108280.1340799998 37.769242767658 -122.424526951068 (37.769242767658, -122.424526951068)
Powered by Datasette · Query took 4.147ms · Data source: data.sfgov.org