sf-trees

Data source: data.sfgov.org

Custom SQL query returning 17 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
16169 100329 1 99 555 04th St 3 1 1 1   04/01/2012 12:00:00 AM 3 3x3 Permit Number 768623 6013411.2884599995 2111661.36797 37.7789741867392 -122.39716827132 (37.7789741867392, -122.39716827132)
16787 100332 1 99 555 04th St 6 1 1 1   04/01/2012 12:00:00 AM 3 3x3 Permit Number 768623 6013356.21451 2111717.71239 37.779125829518705 -122.397362747904 (37.7791258295187, -122.397362747904)
17378 29984 3 99 1622X Guerrero St 5 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005923.58357 2099590.01571 37.7454094051301 -122.422213431617 (37.7454094051301, -122.422213431617)
17649 30005 3 99 795X San Jose Ave 1 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005615.08127 2098546.14287 37.7425257613504 -122.423205996259 (37.7425257613504, -122.423205996259)
19536 29706 3 99 1594X Guerrero St 1 11 1 2   03/30/2006 12:00:00 AM 3     6005915.3087 2099718.0441099997 37.745760475271204 -122.422251139273 (37.7457604752712, -122.422251139273)
19998 30014 3 99 738X San Jose Ave 6 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005753.20487 2098967.8779700003 37.7436915444264 -122.422758369527 (37.7436915444264, -122.422758369527)
20337 29707 3 99 1594X Guerrero St 2 11 1 2   03/30/2006 12:00:00 AM 3     6005916.90216 2099727.1189900003 37.74578548271 -122.422246273943 (37.74578548271, -122.422246273943)
20789 29999 3 99 681X San Jose Ave 13 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005890.72277 2099411.68829 37.7449179049514 -122.422314391296 (37.7449179049514, -122.422314391296)
21577 30015 3 99 738X San Jose Ave 7 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005757.33905 2098980.75435 37.7437271333024 -122.422744989392 (37.7437271333024, -122.422744989392)
21879 29710 3 99 1534X Guerrero St 5 11 1 2   03/30/2006 12:00:00 AM 3     6005894.4456400005 2100106.5973900002 37.7468261772965 -122.422350883111 (37.7468261772965, -122.422350883111)
22067 16311 3 99 700X Monterey Blvd 3 11 1 2   02/02/2003 12:00:00 AM 3 5   5997346.34886 2094713.5127 37.7315321725506 -122.45152030461901 (37.7315321725506, -122.451520304619)
40866 225175 2 99 3309 Folsom St 3 1 1 1     3 Width 3ft   6008515.82219 2099330.37365 37.7448423609829 -122.41323150034901 (37.7448423609829, -122.413231500349)
45931 190000 2 99 770 De Haro St 1 9 1 1     3 Width 3ft   6012104.84568 2104756.14819 37.7599411975544 -122.401202450128 (37.7599411975544, -122.401202450128)
66694 225148 2 99 1199 Capp St 1 9 1 1     3 Width 9ft   6007231.69522 2100624.49408 37.7483235475968 -122.417763493512 (37.7483235475968, -122.417763493512)
137477 189995 2 99 1301 Minnesota St 3 7 1 1     3     6015392.22277 2102247.2850900004 37.753235244428204 -122.389657680355 (37.7532352444282, -122.389657680355)
158218 190007 2 99 700 Arkansas St 5 7 1 1     3     6012984.44615 2103792.30277 37.7573437216454 -122.398092698838 (37.7573437216454, -122.398092698838)
172254 190033 2 99 651 Missouri St 30 9 1 1     3 Width 7ft   6013606.61157 2104092.53416 37.7582027253025 -122.39596202861901 (37.7582027253025, -122.395962028619)
Powered by Datasette · Query took 3.551ms · Data source: data.sfgov.org