sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
178187 183735 2 54 2267 30th Ave 1 1 1 1     22 Width 0ft   5986977.5528 2099855.5864 37.745051724667704 -122.487744403411 (37.7450517246677, -122.487744403411)
100812 115070 6 54 401 DARIEN WAY 1 7 1 1     17     5992724.0 2094938.0 37.7318827746659 -122.467516839465 (37.7318827746659, -122.467516839465)
74538 199648 2 54 420 05th St 1 7 1 1     15 Width 3ft   6012151.63129 2111560.33 37.7786265538123 -122.401518854125 (37.7786265538123, -122.401518854125)
84797 112378 6 54 1850 19TH AVE 1 1 1 1     10 3x3   5990394.0 2102783.0 37.7532883185876 -122.476144836826 (37.7532883185876, -122.476144836826)
83939 111850 2 54 245 STATES ST 1 1 1 1     9 3x3   6000624.0 2106601.0 37.764359516173 -122.441041378606 (37.764359516173, -122.441041378606)
127904 105121 2 54 721 BEACH ST   1 1 1     9     6006739.7 2121813.5 37.8064757462399 -122.42096901139601 (37.8064757462399, -122.420969011396)
163706 248457 2 54 141 Belvedere St 1 1 1 1     9 Width 0ft   5998243.6366 2107963.8685 37.767965740451395 -122.44937255538 (37.7679657404514, -122.44937255538)
178736 182521 2 54 2330 Lawton St 2 1 1 1     8 Width 0ft   5986994.5572 2104405.9226 37.7575467105125 -122.4880198933 (37.7575467105125, -122.4880198933)
2900 70091 1 54 752 24th Ave 1 1 1 1 1 12/12/1992 12:00:00 AM 6 3x3   5988512.5089 2110855.81451 37.7753447787774 -122.483243045223 (37.7753447787774, -122.483243045223)
79668 103672 2 54 2416 Folsom St 1 1 1 1     6 3x3   6008103.2 2104332.6 37.7585541718373 -122.41501226542499 (37.7585541718373, -122.415012265425)
89249 113382 2 54 146 CASTENADA AVE 1 1 1 1     6 3x3   5994461.0 2101055.0 37.7487786662853 -122.46195512222401 (37.7487786662853, -122.461955122224)
148762 182520 2 54 2330 Lawton St 1 1 1 1     6 Width 0ft   5987008.0531 2104405.4872 37.7575463023109 -122.48797318765499 (37.7575463023109, -122.487973187655)
181915 246180 2 54 1588 Waller St 5 1 1 1     6 Width 0ft   5997959.8858 2108225.8157 37.768668745448295 -122.450372898384 (37.7686687454483, -122.450372898384)
75195 246178 2 54 1588 Waller St 3 1 1 1     5 Width 0ft   5997994.7111 2108230.9638 37.76868487385529 -122.45025281211201 (37.7686848738553, -122.450252812112)
91751 121132 2 54 645 27th St 1 1 1 1     5 3x3   6002309.0 2100005.0 37.7463443097186 -122.434741732797 (37.7463443097186, -122.434741732797)
169919 183889 2 54 1390 Quintara St 5 2 1 1     5 Width 0ft   5988959.6443 2101014.682 37.748349707800706 -122.480975613562 (37.7483497078007, -122.480975613562)
45274 246179 2 54 1588 Waller St 4 1 1 1     4 Width 0ft   5997977.1471 2108227.9355 37.768675553750796 -122.45031334601101 (37.7686755537508, -122.450313346011)
51535 183816 2 54 2135 Rivera St 2 2 1 1     4 Width 0ft   5986457.7853 2100251.173 37.746107568513104 -122.48957072678002 (37.7461075685131, -122.48957072678)
51976 181517 2 54 1400 Sunset Blvd 77 9 1 1     4 Width 0ft   5984871.9567 2105586.7319 37.7606648313705 -122.49544767930401 (37.7606648313705, -122.495447679304)
53766 248316 2 54 1415 Waller St 1 1 1 1     4 Width 0ft   5998917.5828 2108317.7243 37.7689758669537 -122.44706692803001 (37.7689758669537, -122.44706692803)
63252 183894 2 54 1390 Quintara St 10 1 1 1     4 Width 0ft   5989083.3554 2101019.0158 37.7483687977509 -122.480548145718 (37.7483687977509, -122.480548145718)
70132 186781 2 54 1200 Sunset Blvd 49 9 1 1     4 Width 0ft   5984857.4742 2106824.7830000003 37.764063324835796 -122.49558908498399 (37.7640633248358, -122.495589084984)
151138 183895 2 54 1390 Quintara St 11 1 1 1     4 Width 0ft   5989106.2065 2101019.8038 37.74837228939921 -122.480469185732 (37.7483722893992, -122.480469185732)
166129 183896 2 54 1390 Quintara St 12 1 1 1     4 Width 0ft   5989127.4817 2101020.5917 37.7483756891409 -122.48039567509501 (37.7483756891409, -122.480395675095)
169869 186771 2 54 1200 Sunset Blvd 39 9 1 1     4 Width 0ft   5984865.2362 2106774.8154 37.7639265823683 -122.495558553205 (37.7639265823683, -122.495558553205)
184322 183815 2 54 2137 Rivera St 1 2 1 1     4 Width 0ft   5986412.1243 2100248.6126 37.746097872473506 -122.48972842623199 (37.7460978724735, -122.489728426232)
188195 183817 2 54 2133 Rivera St 3 2 1 1     4 Width 0ft   5986490.2175 2100252.0265 37.74611180538629 -122.48945864467301 (37.7461118053863, -122.489458644673)
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)
Powered by Datasette · Query took 8.932ms · Data source: data.sfgov.org