sf-trees

Data source: data.sfgov.org

Custom SQL query returning 11 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
28161 249840 2 92 305 Greenwich St 3 17 1 1     5 Width 0ft   6011283.33525 2120383.34662 37.8028039654926 -122.405144080631 (37.8028039654926, -122.405144080631)
39698 137639 2 92 1492 MCALLISTER ST 2 1 1 1     5 Width 0ft   6002021.6701 2111571.8465 37.7780877369401 -122.436563057586 (37.7780877369401, -122.436563057586)
48175 230432 2 92 1553 Alabama St 1 1 1 1     5 Width 3ft   6009354.44461 2100300.41884 37.7475529374354 -122.410400171033 (37.7475529374354, -122.410400171033)
53281 208871 2 92 148 Marston Ave 2 9 1 1     5     5998513.60656 2093229.6533400002 37.7275246181613 -122.447378122617 (37.7275246181613, -122.447378122617)
53808 88032 1 92 2301X Lyon St 2 1 1 1   06/23/2008 12:00:00 AM 5 3x3 Permit Number 51052 5999270.68055 2116740.2820200003 37.7921222013229 -122.44645160686399 (37.7921222013229, -122.446451606864)
59352 208870 2 92 1925 08th Ave 1 2 1 1     5 Width 6ft   5993749.46744 2102404.23974 37.752442344554 -122.46451353327 (37.752442344554, -122.46451353327)
149207 88033 1 92 2301X Lyon St 3 1 1 1   06/23/2008 12:00:00 AM 5 3x3 Permit Number 51052 5999271.52601 2116731.30769 37.7920976084744 -122.44644803565399 (37.7920976084744, -122.446448035654)
153911 177459 2 92 1733 Cayuga Ave 1 9 1 1     5 Width 4ft   5998094.41644 2088625.2684400002 37.7148580835165 -122.448495803641 (37.7148580835165, -122.448495803641)
157822 88035 1 92 2301X Lyon St 5 1 1 1   06/23/2008 12:00:00 AM 5 3x3 Permit Number 51052 5999273.69805 2116722.30576 37.792073015612104 -122.44643987249701 (37.7920730156121, -122.446439872497)
163891 249655 2 92 2401 Lyon St 7 7 1 1     5 Width 10ft   5999222.6408400005 2117247.53945 37.7935122519365 -122.44665433743201 (37.7935122519365, -122.446654337432)
186152 193440 2 92 1775 Silver Ave 5 7 1 1     5 Width 3ft   6011367.39112 2095333.90709 37.7340285952496 -122.403090198147 (37.7340285952496, -122.403090198147)
Powered by Datasette · Query took 2.044ms · Data source: data.sfgov.org