sf-trees

Data source: data.sfgov.org

Custom SQL query returning 16 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4340 221479 3 109 400x Guerrero St 12 11 1 2   04/28/2015 07:46:00 PM 1 Width 3ft   6005545.66803 2106187.37905 37.7635029085615 -122.42398926890199 (37.7635029085615, -122.423989268902)
4413 221467 3 109 300x Guerrero St 12 11 1 2   06/19/2015 10:14:00 AM 1 Width 3ft   6005513.55753 2106751.9184 37.765051186799 -122.424140480012 (37.765051186799, -122.424140480012)
5127 152423 3 109 700x Guerrero St 12 11 1 2     0 Width 3ft   6005645.11359 2104396.78205 37.758591964470895 -122.423518008854 (37.7585919644709, -122.423518008854)
42667 221530 3 109 1100x Guerrero St 12 11 1 2     11 Width 3ft   6005772.5167 2102115.11175 37.75233421815221 -122.422915228372 (37.7523342181522, -122.422915228372)
47104 221492 3 109 500x Guerrero St 12 11 1 2     2 Width 3ft   6005579.45797 2105601.3239599997 37.761895647375205 -122.42383072560301 (37.7618956473752, -122.423830725603)
48680 221505 3 109 600x Guerrero St 12 11 1 2     2 Width 3ft   6005615.32825 2104975.43597 37.760179131174795 -122.423662162075 (37.7601791311748, -122.423662162075)
76663 221554 3 109 1000x Guerrero St 12 11 1 2     4 Width 3ft   6005736.5559 2102753.56312 37.754085228758505 -122.423084962814 (37.7540852287585, -122.423084962814)
94846 110770 3 109 300X GUERRERO ST 12 11 1 2   06/19/2015 10:14:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
110419 109704 3 109 600x GUERRERO ST 12 11 1 2   02/28/2015 10:40:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
118657 115521 3 109 200x Guerrero St 12 11 1 2           6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
120306 110649 3 109 400X GUERRERO ST 12 11 1 2   04/28/2015 07:46:00 PM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
134894 221423 3 109 800x Guerrero St 12 11 1 2     6 Width 3ft   6005658.05131 2104209.2390900003 37.7580777456208 -122.42345993152901 (37.7580777456208, -122.423459931529)
139744 110783 3 109 1000X GUERRERO ST 12 11 1 2   05/26/2015 02:16:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
151374 221444 3 109 200x Guerrero St 12 11 1 2     1 Width 3ft   6005482.048359999 2107327.01142 37.766628476241294 -122.42429036821301 (37.7666284762413, -122.424290368213)
159995 221439 3 109 100x Guerrero St 12 11 1 2     1 Width 3ft   6005446.76573 2108031.65533 37.768561267704705 -122.424462530821 (37.7685612677047, -122.424462530821)
182320 221521 3 109 1200x Guerrero St 12 11 1 2     7 Width 3ft   6005805.669319999 2101529.55059 37.7507282726947 -122.422758971142 (37.7507282726947, -122.422758971142)
Powered by Datasette · Query took 3.804ms · Data source: data.sfgov.org