sf-trees

Data source: data.sfgov.org

Custom SQL query returning 37 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3361 253428 6 47 3 Valletta Ct 1 18 1 1       6x10   5999319.0 2096479.0 37.736492551957895 -122.44482735214198 (37.7364925519579, -122.444827352142)
4923 253718 6 47 227 Madison St 1 7 1 1       3x3   6005690.0 2092595.0 37.726189474375204 -122.422524168298 (37.7261894743752, -122.422524168298)
7834 119605 6 47 299x Avalon Ave 1 7 1 1                    
9683 173631 6 47 99X Everglade Dr 1 5 1 1       3x3   5986361.0 2095495.0 37.733042731061104 -122.48955570953301 (37.7330427310611, -122.489555709533)
10256 173933 6 47 190 Beacon St 1 7 1 1           6003193.0 2097540.0 37.739626138558705 -122.43150902083299 (37.7396261385587, -122.431509020833)
13271 187638 6 47 875 El Camino Del Mar 2 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
13275 187637 6 47 875 El Camino Del Mar 1 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
13307 187654 6 47 375 Woodside Ave 1 2 1 1       3x3   5997267.0 2099886.0 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039)
50101 121189 6 47 1000x Duncan St 10 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
75294 93205 6 47 400 Masonic Ave 3 7 1 1   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.777471434329904 -122.446572853901 (37.7774714343299, -122.446572853901)
82925 112725 6 47 40x BERNAL HEIGHTS BLVD 1 1 1 1     30 3x3   6009324.0 2098099.0 37.7415066181332 -122.41035003366801 (37.7415066181332, -122.410350033668)
86774 122640 6 47 3630X 19th Ave 4 9 1 1       3x8   5990614.0 2091411.0 37.7220764711857 -122.47455416918999 (37.7220764711857, -122.47455416919)
88391 122637 6 47 3630X 19th Ave 1 9 1 1       3x8   5990614.0 2091411.0 37.7220764711857 -122.47455416918999 (37.7220764711857, -122.47455416919)
91819 122638 6 47 3630X 19th Ave 2 9 1 1       3x8   5990614.0 2091411.0 37.7220764711857 -122.47455416918999 (37.7220764711857, -122.47455416919)
98176 105497 6 47 3929 19TH ST 1 7 1 1     60     6003450.9 2104734.8 37.7593959875427 -122.431130714429 (37.7593959875427, -122.431130714429)
98711 105649 6 47 3 Gonzalez Dr 1 7 1 1           5990274.6 2090665.2 37.7200090188364 -122.475672946469 (37.7200090188364, -122.475672946469)
103620 93204 6 47 400 Masonic Ave 1 7 1 1   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.777471434329904 -122.446572853901 (37.7774714343299, -122.446572853901)
108351 106363 6 47 101 URBANO DR 1 7 1 1     80     5993535.8 2092458.1 37.7251204132224 -122.464530299025 (37.7251204132224, -122.464530299025)
110409 98703 6 47 7070@ 32nd Ave California St 4 25 1 1   03/10/2012 12:00:00 AM     Permit Number 767466 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427)
110973 106962 6 47 218 SADOWA ST 3 5 1 1     22     5994814.0 2087793.9 37.7123872323548 -122.459774032106 (37.7123872323548, -122.459774032106)
112771 109706 6 47 96 CRESTA VISTA DR   16 1 1           5995602.1 2096103.5 37.7352487002973 -122.45765100803699 (37.7352487002973, -122.457651008037)
118374 93206 6 47 400 Masonic Ave 4 7 1 1   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.777471434329904 -122.446572853901 (37.7774714343299, -122.446572853901)
118710 105850 6 47 44 MENDOSA AVE 1 9 1 1     100 6x15   5993395.1 2101192.7 37.7490953323683 -122.465650972372 (37.7490953323683, -122.465650972372)
120114 122639 6 47 3630X 19th Ave 3 9 1 1       3x8   5990614.0 2091411.0 37.7220764711857 -122.47455416918999 (37.7220764711857, -122.47455416919)
120332 103422 6 47 1365 Portola Dr 1 7 1 1         Permit Number 769779 5993416.2 2097683.7 37.7394617231066 -122.46532315146601 (37.7394617231066, -122.465323151466)
122936 107159 6 47 1000 ESMERALDA AVE   7 1 1           6009839.0 2098688.0 37.7431527400861 -122.408610872619 (37.7431527400861, -122.408610872619)
123752 95982 6 47 100 Vasquez Ave 1 13 1 1           5995122.4 2099706.3 37.7451135296363 -122.459570350972 (37.7451135296363, -122.459570350972)
125647 85060 6 47 7070 California St 1 8 1 1   07/03/2007 12:00:00 AM     Permit Number 49405 5985878.0 2113896.0 37.7835385880022 -122.49258024231199 (37.7835385880022, -122.492580242312)
125813 103600 6 47 50X Hermann St 1 7 1 1           6005031.0649 2108842.56611 37.7707643495235 -122.42595813798201 (37.7707643495235, -122.425958137982)
125828 112726 6 47 40x BERNAL HEIGHTS BLVD 2 1 1 1     30 3x3   6009324.0 2098099.0 37.7415066181332 -122.41035003366801 (37.7415066181332, -122.410350033668)
139394 93203 6 47 400 Masonic Ave 2 7 1 1   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.777471434329904 -122.446572853901 (37.7774714343299, -122.446572853901)
139692 99826 6 47 1 Cascade Walk 1 7 1 1           5992183.1 2103187.3 37.7545020044945 -122.469987253468 (37.7545020044945, -122.469987253468)
140312 115391 6 47 21X BELMONT AVE 1 7 1 1     48     5996611.0 2106266.0 37.7632103037359 -122.45489693849501 (37.7632103037359, -122.454896938495)
140584 117248 6 47 299x GRAYSTONE TER 1 1 1 1       3x3   5999641.0 2104067.0 37.7573457417117 -122.44425918093 (37.7573457417117, -122.44425918093)
143237 104888 6 47 146 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
144598 99662 6 47 1337 Portola Dr 1 7 1 1           5993559.3 2097744.3 37.7396363671104 -122.46483277796801 (37.7396363671104, -122.464832777968)
145554 121180 6 47 1000x Duncan St 1 1 1 1       3x3   5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
Powered by Datasette · Query took 6.479ms · Data source: data.sfgov.org