sf-trees

Data source: data.sfgov.org

Custom SQL query returning 16 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
6792 23871 3 35 1499X Webster St 4 1 1 2     12 3X3   6003600.3539 2113692.9201 37.784001259600295 -122.43125326646499 (37.7840012596003, -122.431253266465)
6874 13090 1 35 724 Lombard St 1 1 1 1   02/26/2004 12:00:00 AM 12 3X3   6008885.9219 2120447.4555 37.8028456756355 -122.413444921903 (37.8028456756355, -122.413444921903)
8518 18226 3 35 1675 Post St 3 1 1 2     12 3X3   6004172.0667 2114245.454 37.785550761919 -122.42931476245899 (37.785550761919, -122.429314762459)
18986 10211 3 35 1311 Guerrero St 1 1 1 2   01/15/1991 12:00:00 AM 12 2X2   6005852.922730001 2101311.29856 37.7501316687427 -122.422580057332 (37.7501316687427, -122.422580057332)
73827 142480 2 35 1656 POWELL ST 1 1 1 1     12 Width 0ft   6009655.9931 2119387.8477 37.799979462358706 -122.410705194848 (37.7999794623587, -122.410705194848)
76233 108192 2 35 603 Cambridge St 1 1 1 1     12 3x3   6007188.43841 2091737.3666 37.7239190175192 -122.417283387741 (37.7239190175192, -122.417283387741)
89705 109182 2 35 634 HURON AVE 1 1 1 1     12 3x3   5998040.0 2087925.4 37.7129332935716 -122.448633512376 (37.7129332935716, -122.448633512376)
137794 142584 2 35 2232 Mason St 3 1 1 1     12 Width 0ft   6008967.5673 2120856.1596 37.803972458794796 -122.41319130359699 (37.8039724587948, -122.413191303597)
141416 11200 3 35 186 Idora Ave 3 11 1 2     12 8   5995344.6608195 2099448.7962231003 37.74441926622529 -122.45878317784799 (37.7444192662253, -122.458783177848)
150022 238032 2 35 3851 21st St 1 1 1 1     12 Width 3ft   6002743.63234 2103545.30285 37.7560898095039 -122.43349178442499 (37.7560898095039, -122.433491784425)
151841 237989 2 35 114 Park St 4 1 1 1     12 Width 3ft   6005562.12851 2096385.4572 37.7365900164084 -122.423235535394 (37.7365900164084, -122.423235535394)
182223 214385 2 35 1955 10th Ave 1 2 1 1     12 Width 6ft   5993134.95065 2102190.16883 37.7518191170825 -122.46662305770501 (37.7518191170825, -122.466623057705)
182343 178937 2 35 250 Athens St 1 9 1 1     12     6004445.3973900005 2091822.37508 37.723997724407795 -122.426771694853 (37.7239977244078, -122.426771694853)
99821 34369 1 35 71 Harper St 1 1 1 1 1 07/14/1997 12:00:00 AM 12 12x4. 5 Permit Number 38124 6003708.03789498 2097975.15575924 37.740850154442896 -122.42975927113899 (37.7408501544429, -122.429759271139)
114472 65384 1 35 49 Wilder St 1 1 1 1 1 09/30/1989 12:00:00 AM 12   Permit Number 28223 6002684.49028093 2095505.99557199 37.734012395369 -122.433121936639 (37.734012395369, -122.433121936639)
121025 111845 1 35 1550 York St 3 1 1 1 1   12 3x3   6010144.81466304 2100398.61683821 37.7478668430794 -122.407674029985 (37.7478668430794, -122.407674029985)
Powered by Datasette · Query took 20.219ms · Data source: data.sfgov.org