sf-trees

Data source: data.sfgov.org

Custom SQL query returning 29 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3835 253567 5 218 25 Raycliff Ter 1 13 1 1           6000333.0 2116919.0 37.792673532262505 -122.44278881704399 (37.7926735322625, -122.442788817044)
12440 100166 7 218 2340 Twin Peaks Blvd   7 1 1         Permit Number 769026          
24893 249803 2 218 258 Chestnut St 2 13 1 1     5 Width 0ft   6010797.8681 2121034.56269 37.8045648929076 -122.406869977661 (37.8045648929076, -122.406869977661)
31900 197465 2 218 300 Tulare St 10 7 1 1     2     6015074.429330001 2100286.5599 37.747833879328205 -122.39061968157101 (37.7478338793282, -122.390619681571)
37531 197464 2 218 300 Tulare St 9 7 1 1     3     6015091.2774 2100275.40552 37.747804186425704 -122.390560641961 (37.7478041864257, -122.390560641961)
41112 249802 2 218 258 Chestnut St 1 13 1 1     9 Width 0ft   6010800.51699 2121027.19165 37.804544802067795 -122.40686029106399 (37.8045448020678, -122.406860291064)
41725 249801 2 218 199 Chestnut St 9 7 1 1     11 Width 0ft   6010817.41818 2121032.42215 37.8045601094112 -122.40680217150101 (37.8045601094112, -122.406802171501)
46915 249805 2 218 258 Chestnut St 4 13 1 1     14 Width 0ft   6010790.25874 2121038.89871 37.8045763727666 -122.40689661648099 (37.8045763727666, -122.406896616481)
53267 249799 2 218 199 Chestnut St 7 7 1 1     5 Width 0ft   6010830.01398 2121049.58658 37.8046079434619 -122.406759792755 (37.8046079434619, -122.406759792755)
59239 249804 2 218 258 Chestnut St 3 13 1 1     9 Width 0ft   6010798.41124 2121026.88639 37.8045438460731 -122.406867556714 (37.8045438460731, -122.406867556714)
73394 214151 2 218 312 Ortega St 1 1 1 1     3 Width 4ft   5993037.76549 2102572.2822 37.7528626930695 -122.466986911741 (37.7528626930695, -122.466986911741)
74282 249879 2 218 230 Greenwich St 15 13 1 1     31 Width 0ft   6011548.40111 2120431.82846 37.8029518994613 -122.404230226458 (37.8029518994613, -122.404230226458)
74556 181908 2 218 2361 27th Ave 1 1 1 1     2 Width 0ft   5987931.3863 2099236.8053 37.743408304681104 -122.484400882071 (37.7434083046811, -122.484400882071)
78641 116976 2 218 100x CARGO WAY 7 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
83082 91365 1 218 2850 22nd St 2 1 1 1   02/27/2009 12:00:00 AM   3x3 Permit Number 52066 6009160.0 2103356.0 37.755931978245705 -122.411288371704 (37.7559319782457, -122.411288371704)
83368 120504 2 218 2050 Turk Blvd 1 13 1 1           6000175.0 2112136.0 37.779531646131204 -122.442991859062 (37.7795316461312, -122.442991859062)
92869 99821 2 218 1230 Twin Peaks Blvd 1 13 1 1     11   Tree closest to sidewalk and retaining wall 5997905.5 2100119.1 37.7464066170132 -122.449976668748 (37.7464066170132, -122.449976668748)
95481 101470 2 218 1230 Twin Peaks Blvd 2 13 1 1           5997905.5 2100119.1 37.7464066170132 -122.449976668748 (37.7464066170132, -122.449976668748)
99185 91367 1 218 2850 22nd St 4 1 1 1   02/27/2009 12:00:00 AM   3x3 Permit Number 52066 6009160.0 2103356.0 37.755931978245705 -122.411288371704 (37.7559319782457, -122.411288371704)
101651 106059 6 218 339 FILBERT ST 1 7 1 1     6     6011263.6 2119947.8 37.801606957686 -122.40518168715599 (37.801606957686, -122.405181687156)
120600 97302 1 218 1051 Portola Dr 5 9 1 1           5995688.7 2098126.6 37.7408086112536 -122.457497926865 (37.7408086112536, -122.457497926865)
128483 91366 1 218 2850 22nd St 3 1 1 1   02/27/2009 12:00:00 AM   3x3 Permit Number 52066 6009160.0 2103356.0 37.755931978245705 -122.411288371704 (37.7559319782457, -122.411288371704)
140503 116975 2 218 100x CARGO WAY 6 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
152632 179421 2 218 700 John Muir Dr 1 4 1 1     18 Width 0ft   5986275.223040001 2087885.25154 37.7121433180403 -122.489292946617 (37.7121433180403, -122.489292946617)
154623 183597 2 218 2639 23rd Ave 2 2 1 1     1 Width 0ft   5989238.6658 2097359.0167 37.7383284221723 -122.479743320072 (37.7383284221723, -122.479743320072)
160668 197463 2 218 300 Tulare St 12 7 1 1     11 Width 5ft   6015063.03435 2100312.52398 37.7479045390722 -122.39066089929199 (37.7479045390722, -122.390660899292)
171764 197466 2 218 625 Bay Shore Blvd 4 9 1 1     6 Width 6ft   6010372.73357 2096324.48673 37.7366929195414 -122.40659883568199 (37.7366929195414, -122.406598835682)
179670 249796 2 218 199 Chestnut St 4 7 1 1     8 Width 0ft   6010844.62516 2121045.45639 37.80459742048421 -122.40670893787701 (37.8045974204842, -122.406708937877)
180980 249806 2 218 258 Chestnut St 5 13 1 1     16 Width 0ft   6010784.31321 2121039.01987 37.804576372755605 -122.406917200191 (37.8045763727556, -122.406917200191)
Powered by Datasette · Query took 1.6ms · Data source: data.sfgov.org