sf-trees

Data source: data.sfgov.org

Custom SQL query returning 77 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1389 251532 1 54 2100X 20th St 4 1 2 1   05/15/2017 12:00:00 AM 3 4x11            
1391 251531 1 54 2100X 20th St 2 1 2 1   05/15/2017 12:00:00 AM 3 4x11            
1800 251700 1 54 1560 Sanchez St 1 1 2 1   06/05/2017 12:00:00 AM 3 410x11 Permit Number 780193 6003924.0 2099150.0 37.7440882334859 -122.429096301435 (37.7440882334859, -122.429096301435)
1824 251724 1 54 1630 Clay St 1 1 1 1   06/06/2017 12:00:00 AM 3 3x3   6006933.88533 2116748.92044 37.792580631742204 -122.419937373279 (37.7925806317422, -122.419937373279)
2270 253008 1 54 1201 Tennessee St 1 1 2 1   07/10/2017 12:00:00 AM 3 11x477   6015595.17459 2103370.35297 37.756330202721 -122.389034232236 (37.756330202721, -122.389034232236)
3276 149033 1 54 3916 Sacramento St 1 1 1 1   08/28/2017 12:00:00 AM 3 5.5x12   5996085.364440001 2114918.02173 37.7869363183091 -122.45734088598302 (37.7869363183091, -122.457340885983)
3639 253517 1 54 559 24th Ave 2 5 2 1   09/15/2017 12:00:00 AM 3 2x4.5   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3643 253515 1 54 559 24th Ave 1 1 2 1   09/15/2017 12:00:00 AM 3 7x9.5   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3650 253518 1 54 559 24th Ave 3 5 2 1   09/15/2017 12:00:00 AM 3 2x1   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3660 253516 1 54 559 24th Ave 1 5 2 1   09/15/2017 12:00:00 AM 3 2x2   5988392.0 2112177.0 37.778965370493495 -122.483756799769 (37.7789653704935, -122.483756799769)
4723 253676 1 54 2975 Van Ness Ave 6 5 2 1   10/24/2017 12:00:00 AM 3 3.2x3.75   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
4726 253675 1 54 2975 Van Ness Ave 1 5 2 1   10/24/2017 12:00:00 AM 3 3.2x14.2   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
10092 173852 1 54 450 Toland St 7 1 2 1   01/27/2017 12:00:00 AM 3 8.5x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10093 173849 1 54 450 Toland St 4 1 2 1   01/27/2017 12:00:00 AM 3 17.6x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10096 173850 1 54 450 Toland St 5 1 2 1   01/27/2017 12:00:00 AM 3 13.9x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10097 173851 1 54 450 Toland St 6 1 2 1   01/27/2017 12:00:00 AM 3 27.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10098 173848 1 54 450 Toland St 3 1 2 1   01/27/2017 12:00:00 AM 3 19.5x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10101 173846 1 54 450 Toland St 1 1 2 1   01/27/2017 12:00:00 AM 3 15x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10104 173847 1 54 450 Toland St 2 1 2 1   01/27/2017 12:00:00 AM 3 11.85x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10106 173853 1 54 450 Toland St 8 1 2 1   01/27/2017 12:00:00 AM 3 26.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10128 173868 1 54 808 Capitol Ave 2 5 1 1   01/31/2017 12:00:00 AM 3     5995075.959430001 2089664.9067799998 37.717539636984206 -122.45900401383601 (37.7175396369842, -122.459004013836)
10139 173867 1 54 808 Capitol Ave 1 5 1 1   01/31/2017 12:00:00 AM 3     5995075.959430001 2089664.9067799998 37.717539636984206 -122.45900401383601 (37.7175396369842, -122.459004013836)
42994 109343 1 54 3211 Baker St 2 9 2 1   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
51515 120669 2 54 61 Paradise Ave 1 1 1 1   08/22/2016 12:00:00 AM 3 3x3   6000974.0 2096001.0 37.7352743855737 -122.43907108078899 (37.7352743855737, -122.439071080789)
54387 246177 2 54 1588 Waller St 2 1 1 1     3 Width 0ft   5998014.6979 2108233.0836 37.7686918380665 -122.450183832466 (37.7686918380665, -122.450183832466)
55449 183888 2 54 1390 Quintara St 4 2 1 1     3 Width 0ft   5988941.521000001 2101013.106 37.7483443270077 -122.48103816738501 (37.7483443270077, -122.481038167385)
64371 248338 2 54 101 Belvedere St 1 1 1 1     3 Width 0ft   5998210.6283 2108198.2582 37.7686074267176 -122.44950361782 (37.7686074267176, -122.44950361782)
65435 183890 2 54 1390 Quintara St 6 2 1 1     3 Width 0ft   5988977.7676 2101017.0459 37.748357251925604 -122.480913117409 (37.7483572519256, -122.480913117409)
74231 246137 2 54 636 Shrader St 1 2 1 1     3 Width 0ft   5997583.3178 2108295.6178 37.7688388454445 -122.451680446787 (37.7688388454445, -122.451680446787)
77586 121129 2 54 201 Bemis St 4 1 1 1   09/09/2016 12:00:00 AM 3 3x3   6003216.0 2096386.0 37.7364588227531 -122.431347141396 (37.7364588227531, -122.431347141396)
81298 104856 1 54 739 27th St   1 2 1   02/12/2015 12:00:00 AM 3     6001722.3 2099959.7 37.746186600460604 -122.43676722664301 (37.7461866004606, -122.436767226643)
83041 109366 1 54 1205 Filbert St 3 5 2 1 1 02/11/2015 12:00:00 AM 3 3.125x22   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
83254 110159 1 54 1041 Broadway 5 1 1 1     3   Permit Number 55966 6008597.3 2118278.8 37.7968748776387 -122.414290174718 (37.7968748776387, -122.414290174718)
84556 115963 2 54 847 43RD AVE 2 1 1 1   03/07/2016 12:00:00 AM 3 3x3   5982585.0 2109998.0 37.7726427311472 -122.50368379034599 (37.7726427311472, -122.503683790346)
85364 115892 1 54 1900X Kirkham St 2 1 1 1   03/02/2016 12:00:00 AM 3     5988841.66469 2105121.6083400003 37.75961937033 -122.48168434385401 (37.75961937033, -122.481684343854)
85868 115996 2 54 136 DUNCAN ST 1 1 1 1     3 3x3   6005652.0 2099949.0 37.746379771639795 -122.423178037621 (37.7463797716398, -122.423178037621)
91154 109365 1 54 1205 Filbert St 2 1 2 1 1 02/11/2015 12:00:00 AM 3 4.5x16   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
92851 7876 3 54 1095X Franklin St 1 1 1 2   03/04/2011 12:00:00 AM 3 3x3   6006012.62101 2113826.37447 37.784504100894395 -122.42291717866101 (37.7845041008944, -122.422917178661)
93014 115931 2 54 847 43RD AVE 1 1 1 1   03/07/2016 12:00:00 AM 3 3x3   5982585.0 2109998.0 37.7726427311472 -122.50368379034599 (37.7726427311472, -122.503683790346)
96301 101476 6 54 541 Congo St 1 1 1 1   05/07/2015 12:00:00 AM 3   Permit Number 775316 6000089.0 2095440.1 37.7336838892166 -122.44209059296301 (37.7336838892166, -122.442090592963)
96541 110246 1 54 1706 28th Ave 1 1 2 1   04/01/2015 12:00:00 AM 3 1.5x12   5987540.7 2103643.4 37.755484875136204 -122.486075162345 (37.7554848751362, -122.486075162345)
97307 109345 1 54 3211 Baker St 4 9 2 1   02/11/2015 12:00:00 AM 3 8.75x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
97368 121128 2 54 201 Bemis St 3 1 1 1   09/09/2016 12:00:00 AM 3 3x3   6003216.0 2096386.0 37.7364588227531 -122.431347141396 (37.7364588227531, -122.431347141396)
98575 115891 1 54 1900X Kirkham St 1 1 1 1   03/02/2016 12:00:00 AM 3     5988841.66469 2105121.6083400003 37.75961937033 -122.48168434385401 (37.75961937033, -122.481684343854)
99380 119616 5 54 400 Grove St 1 1 2 1   07/28/2016 12:00:00 AM 3     6005873.6969099995 2111410.5639299997 37.777863036884796 -122.42322602570499 (37.7778630368848, -122.423226025705)
99464 109344 1 54 3211 Baker St 3 9 2 1   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
99672 121127 2 54 201 Bemis St 2 1 1 1   09/09/2016 12:00:00 AM 3 3x3   6003216.0 2096386.0 37.7364588227531 -122.431347141396 (37.7364588227531, -122.431347141396)
101115 109364 1 54 1205 Filbert St 1 1 2 1 1 02/11/2015 12:00:00 AM 3 4.5x6   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
101195 115894 1 54 1900X Kirkham St 4 1 1 1   03/02/2016 12:00:00 AM 3     5988841.66469 2105121.6083400003 37.75961937033 -122.48168434385401 (37.75961937033, -122.481684343854)
101235 109535 1 54 1234 Filbert St 3 5 2 1 1 02/23/2015 12:00:00 AM 3 1.5x2.4   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677)
103215 116528 4 54 125 CROWN TER 1 5 1 1     3 3x3   5998841.0 2104182.0 37.7576158290564 -122.447034160915 (37.7576158290564, -122.447034160915)
105398 117608 1 54 450 Hayes St 1 1 2 1   06/29/2016 12:00:00 AM 3     6005708.4 2111040.6 37.776837876057 -122.423771533631 (37.776837876057, -122.423771533631)
108481 28868 3 54 75 01st St 1 1 1 2   06/11/2011 12:00:00 AM 3 3x3   6013233.2298598 2115774.102568 37.790256890180295 -122.39807285434601 (37.7902568901803, -122.398072854346)
112218 109536 1 54 1234 Filbert St 4 5 2 1 1 02/23/2015 12:00:00 AM 3 1.5x2.4   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677)
112494 119244 2 54 311 30th St   1 1 1   08/09/2016 12:00:00 AM 3 3x3   6004402.0 2098353.0 37.7419269008751 -122.42738671849101 (37.7419269008751, -122.427386718491)
116050 111759 1 54 1235 47th Ave 2 2 2 1   06/23/2015 12:00:00 AM 3 6x4   5981472.7 2106671.7 37.7634442160317 -122.50728446314301 (37.7634442160317, -122.507284463143)
116207 109368 1 54 1205 Filbert St 5 1 2 1 1 02/11/2015 12:00:00 AM 3 3x22   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
124217 37151 1 54 124 27th St 1 1 1 1 1 06/09/2015 12:00:00 AM 3 4.5x10 Permit Number 775446 6005712.42544702 2100249.055732 37.7472070660376 -122.42299041598 (37.7472070660376, -122.42299041598)
124298 109367 1 54 1205 Filbert St 4 1 2 1 1 02/11/2015 12:00:00 AM 3 4.5x6.5   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
125370 3826 3 54 120 Cashmere St 1 1 1 2   11/16/1992 12:00:00 AM 3 3X3   6016868.5122165 2095917.6664165 37.7359371538987 -122.384111573291 (37.7359371538987, -122.384111573291)
125946 109370 1 54 2061 Hyde St 2 1 2 1 1 02/11/2015 12:00:00 AM 3 13x6   6007159.6 2119443.7 37.799992536546505 -122.41934764587201 (37.7999925365465, -122.419347645872)
126302 109534 1 54 1234 Filbert St 2 5 2 1 1 02/23/2015 12:00:00 AM 3 1.5x2.6   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677)
128427 109369 1 54 2061 Hyde St 1 1 2 1 1 02/11/2015 12:00:00 AM 3 5x6   6007159.6 2119443.7 37.799992536546505 -122.41934764587201 (37.7999925365465, -122.419347645872)
129313 117320 1 54 1935 09th Ave 2 1 1 1   06/07/2016 12:00:00 AM 3   Permit Number 778503 5993426.4 2102307.1 37.7521569948021 -122.465623688401 (37.7521569948021, -122.465623688401)
133057 183886 2 54 1390 Quintara St 2 2 1 1     3 Width 0ft   5988900.5466 2101013.106 37.7483419450285 -122.48117985419901 (37.7483419450285, -122.481179854199)
133477 246176 2 54 1588 Waller St 1 1 1 1     3 Width 0ft   5998032.5648 2108236.7175 37.7687028382608 -122.45012229449 (37.7687028382608, -122.45012229449)
138801 115762 2 54 84X Cordova St 1 1 1 1     3   on Athens Street frontage 6001679.7 2087642.4 37.712363687575795 -122.43603329568501 (37.7123636875758, -122.436033295685)
140543 109342 1 54 3211 Baker St 1 9 2 1   02/11/2015 12:00:00 AM 3 1x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
142347 109178 1 54 2832 Pierce St 1 1 1 1   01/30/2015 12:00:00 AM 3     6001592.1 2118171.6 37.796184544404895 -122.438522078694 (37.7961845444049, -122.438522078694)
143440 117372 1 54 1533 McAllister St 5 5 2 1   06/08/2016 12:00:00 AM 3 1x2.75   6001806.7 2111472.8 37.777803561930206 -122.437299621265 (37.7778035619302, -122.437299621265)
144086 115893 1 54 1900X Kirkham St 3 1 1 1   03/02/2016 12:00:00 AM 3     5988841.66469 2105121.6083400003 37.75961937033 -122.48168434385401 (37.75961937033, -122.481684343854)
145543 111758 1 54 1235 47th Ave 1 1 2 1   06/23/2015 12:00:00 AM 3 6x6   5981472.7 2106671.7 37.7634442160317 -122.50728446314301 (37.7634442160317, -122.507284463143)
145560 121126 2 54 201 Bemis St 1 1 1 1   09/09/2016 12:00:00 AM 3 3x3   6003216.0 2096386.0 37.7364588227531 -122.431347141396 (37.7364588227531, -122.431347141396)
149942 245941 2 54 142 Belvedere St 1 1 1 1     3 Width 0ft   5998288.6068 2107942.2163 37.7679088612974 -122.44921544906 (37.7679088612974, -122.44921544906)
167807 183887 2 54 1390 Quintara St 3 2 1 1     3 Width 0ft   5988922.6098 2101013.894 37.748345391297 -122.481103618778 (37.748345391297, -122.481103618778)
168416 186800 2 54 1200 Sunset Blvd 78 9 1 1     3 Width 0ft   5984846.2035 2106925.1049 37.7643381205783 -122.495635466651 (37.7643381205783, -122.495635466651)
173500 183897 2 54 1390 Quintara St 13 1 1 1     3 Width 0ft   5989145.605 2101022.1677 37.7483810695929 -122.480333121199 (37.7483810695929, -122.480333121199)
Powered by Datasette · Query took 8.792ms · Data source: data.sfgov.org