sf-trees

Data source: data.sfgov.org

Custom SQL query returning 21 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
754 221432 3 109 100x Guerrero St 5 11 1 2   07/15/2016 05:53:00 AM 1 Width 3ft   6005434.00046 2108253.10785 37.769168602384205 -122.42452243915301 (37.7691686023842, -122.424522439153)
4332 221460 3 109 300x Guerrero St 5 11 1 2   06/19/2015 10:41:00 AM 2 Width 3ft   6005499.89777 2107004.0817 37.76574279600489 -122.424205661071 (37.7657427960049, -122.424205661071)
4377 221451 3 109 200x Guerrero St 5 11 1 2   02/09/2016 11:36:00 AM 1 Width 3ft   6005468.550009999 2107589.96825 37.76734973074429 -122.424355761536 (37.7673497307443, -122.424355761536)
4408 221472 3 109 400x Guerrero St 5 11 1 2   04/29/2015 10:24:00 AM 1 Width 3ft   6005534.310819999 2106426.8401 37.7641597706703 -122.424045579956 (37.7641597706703, -122.424045579956)
5111 152416 3 109 700x Guerrero St 5 11 1 2     0 Width 3ft   6005631.99539 2104658.5890900004 37.7593100848133 -122.423581991114 (37.7593100848133, -122.423581991114)
5429 118350 3 109 100X Guerrero St 5 11 1 2   07/15/2016 05:53:00 AM 3              
44105 221562 2 109 100 San Jose Ave 5 1 1 1     1 Width 3ft   6006161.28805 2102498.9287799997 37.753410020459995 -122.421598049829 (37.75341002046, -122.421598049829)
44886 221418 3 109 800x Guerrero St 5 11 1 2     8 Width 3ft   6005666.2176 2103986.40391 37.757466353200996 -122.423415847665 (37.757466353201, -122.423415847665)
46284 221426 3 109 900x Guerrero St 5 11 1 2     6 Width 3ft   6005693.61577 2103548.6076700003 37.7562658131324 -122.423289973179 (37.7562658131324, -122.423289973179)
73681 221526 3 109 1200x Guerrero St 5 11 1 2     8 Width 3ft   6005792.85635 2101748.62489 37.7513290773756 -122.42281884712601 (37.7513290773756, -122.422818847126)
87539 91285 3 109 1212x Guerrero St 5 11 1 2   11/20/2008 12:00:00 AM 3     6005738.0 2101906.0 37.7517580978369 -122.42301973133999 (37.7517580978369, -122.42301973134)
95444 109697 3 109 600x GUERRERO ST 5 11 1 2   02/21/2015 10:59:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
97820 110763 3 109 300X GUERRERO ST 5 11 1 2   06/19/2015 10:41:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
97980 110776 3 109 1000X GUERRERO ST 5 11 1 2   05/26/2015 02:53:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
104357 110622 3 109 400X GUERRERO ST 5 11 1 2   04/29/2015 10:24:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
146089 115514 3 109 200x Guerrero St 5 11 1 2   02/09/2016 11:36:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
151865 221485 3 109 500x Guerrero St 5 11 1 2     3 Width 3ft   6005566.92978 2105826.00789 37.762511869155105 -122.42389003321101 (37.7625118691551, -122.423890033211)
168829 221544 3 109 900x Guerrero St 5 11 1 2     7 Width 3ft   6005705.623380001 2103333.32509 37.755675374928295 -122.423233144119 (37.7556753749283, -122.423233144119)
169550 221558 3 109 1000x Guerrero St 5 11 1 2     3 Width 3ft   6005728.5881 2102926.2105099997 37.754558828830106 -122.423124788381 (37.7545588288301, -122.423124788381)
184414 221498 3 109 600x Guerrero St 5 11 1 2     3 Width 3ft   6005599.77613 2105242.7413 37.7609122108583 -122.423734955914 (37.7609122108583, -122.423734955914)
185218 221536 3 109 1100x Guerrero St 5 11 1 2     9 Width 3ft   6005762.1987 2102333.32685 37.75293280420979 -122.422966417762 (37.7529328042098, -122.422966417762)
Powered by Datasette · Query took 2.509ms · Data source: data.sfgov.org