Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 178187 | 178187 | 183735 | Undocumented 2 | :: 54 | 2267 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5986977.5528 | 2099855.5864 | 37.745051724667704 | -122.487744403411 | (37.7450517246677, -122.487744403411) | |||
| 100812 | 100812 | 115070 | Significant Tree 6 | :: 54 | 401 DARIEN WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5992724.0 | 2094938.0 | 37.7318827746659 | -122.467516839465 | (37.7318827746659, -122.467516839465) | ||||
| 74538 | 74538 | 199648 | Undocumented 2 | :: 54 | 420 05th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 3ft | 6012151.63129 | 2111560.33 | 37.7786265538123 | -122.401518854125 | (37.7786265538123, -122.401518854125) | |||
| 84797 | 84797 | 112378 | Significant Tree 6 | :: 54 | 1850 19TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5990394.0 | 2102783.0 | 37.7532883185876 | -122.476144836826 | (37.7532883185876, -122.476144836826) | |||
| 83939 | 83939 | 111850 | Undocumented 2 | :: 54 | 245 STATES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6000624.0 | 2106601.0 | 37.764359516173 | -122.441041378606 | (37.764359516173, -122.441041378606) | |||
| 127904 | 127904 | 105121 | Undocumented 2 | :: 54 | 721 BEACH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6006739.7 | 2121813.5 | 37.8064757462399 | -122.42096901139601 | (37.8064757462399, -122.420969011396) | |||||
| 163706 | 163706 | 248457 | Undocumented 2 | :: 54 | 141 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998243.6366 | 2107963.8685 | 37.767965740451395 | -122.44937255538 | (37.7679657404514, -122.44937255538) | |||
| 178736 | 178736 | 182521 | Undocumented 2 | :: 54 | 2330 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5986994.5572 | 2104405.9226 | 37.7575467105125 | -122.4880198933 | (37.7575467105125, -122.4880198933) | |||
| 2900 | 2900 | 70091 | Permitted Site 1 | :: 54 | 752 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/1992 12:00:00 AM | 6 | 3x3 | 5988512.5089 | 2110855.81451 | 37.7753447787774 | -122.483243045223 | (37.7753447787774, -122.483243045223) | |
| 79668 | 79668 | 103672 | Undocumented 2 | :: 54 | 2416 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008103.2 | 2104332.6 | 37.7585541718373 | -122.41501226542499 | (37.7585541718373, -122.415012265425) | |||
| 89249 | 89249 | 113382 | Undocumented 2 | :: 54 | 146 CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5994461.0 | 2101055.0 | 37.7487786662853 | -122.46195512222401 | (37.7487786662853, -122.461955122224) | |||
| 148762 | 148762 | 182520 | Undocumented 2 | :: 54 | 2330 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5987008.0531 | 2104405.4872 | 37.7575463023109 | -122.48797318765499 | (37.7575463023109, -122.487973187655) | |||
| 181915 | 181915 | 246180 | Undocumented 2 | :: 54 | 1588 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997959.8858 | 2108225.8157 | 37.768668745448295 | -122.450372898384 | (37.7686687454483, -122.450372898384) | |||
| 75195 | 75195 | 246178 | Undocumented 2 | :: 54 | 1588 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997994.7111 | 2108230.9638 | 37.76868487385529 | -122.45025281211201 | (37.7686848738553, -122.450252812112) | |||
| 91751 | 91751 | 121132 | Undocumented 2 | :: 54 | 645 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6002309.0 | 2100005.0 | 37.7463443097186 | -122.434741732797 | (37.7463443097186, -122.434741732797) | |||
| 169919 | 169919 | 183889 | Undocumented 2 | :: 54 | 1390 Quintara St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5988959.6443 | 2101014.682 | 37.748349707800706 | -122.480975613562 | (37.7483497078007, -122.480975613562) | |||
| 45274 | 45274 | 246179 | Undocumented 2 | :: 54 | 1588 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997977.1471 | 2108227.9355 | 37.768675553750796 | -122.45031334601101 | (37.7686755537508, -122.450313346011) | |||
| 51535 | 51535 | 183816 | Undocumented 2 | :: 54 | 2135 Rivera St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5986457.7853 | 2100251.173 | 37.746107568513104 | -122.48957072678002 | (37.7461075685131, -122.48957072678) | |||
| 51976 | 51976 | 181517 | Undocumented 2 | :: 54 | 1400 Sunset Blvd | 77 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984871.9567 | 2105586.7319 | 37.7606648313705 | -122.49544767930401 | (37.7606648313705, -122.495447679304) | |||
| 53766 | 53766 | 248316 | Undocumented 2 | :: 54 | 1415 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998917.5828 | 2108317.7243 | 37.7689758669537 | -122.44706692803001 | (37.7689758669537, -122.44706692803) | |||
| 63252 | 63252 | 183894 | Undocumented 2 | :: 54 | 1390 Quintara St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5989083.3554 | 2101019.0158 | 37.7483687977509 | -122.480548145718 | (37.7483687977509, -122.480548145718) | |||
| 70132 | 70132 | 186781 | Undocumented 2 | :: 54 | 1200 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984857.4742 | 2106824.7830000003 | 37.764063324835796 | -122.49558908498399 | (37.7640633248358, -122.495589084984) | |||
| 151138 | 151138 | 183895 | Undocumented 2 | :: 54 | 1390 Quintara St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5989106.2065 | 2101019.8038 | 37.74837228939921 | -122.480469185732 | (37.7483722893992, -122.480469185732) | |||
| 166129 | 166129 | 183896 | Undocumented 2 | :: 54 | 1390 Quintara St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5989127.4817 | 2101020.5917 | 37.7483756891409 | -122.48039567509501 | (37.7483756891409, -122.480395675095) | |||
| 169869 | 169869 | 186771 | Undocumented 2 | :: 54 | 1200 Sunset Blvd | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984865.2362 | 2106774.8154 | 37.7639265823683 | -122.495558553205 | (37.7639265823683, -122.495558553205) | |||
| 184322 | 184322 | 183815 | Undocumented 2 | :: 54 | 2137 Rivera St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5986412.1243 | 2100248.6126 | 37.746097872473506 | -122.48972842623199 | (37.7460978724735, -122.489728426232) | |||
| 188195 | 188195 | 183817 | Undocumented 2 | :: 54 | 2133 Rivera St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5986490.2175 | 2100252.0265 | 37.74611180538629 | -122.48945864467301 | (37.7461118053863, -122.489458644673) | |||
| 1389 | 1389 | 251532 | Permitted Site 1 | :: 54 | 2100X 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x11 | |||||||
| 1391 | 1391 | 251531 | Permitted Site 1 | :: 54 | 2100X 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x11 | |||||||
| 1800 | 1800 | 251700 | Permitted Site 1 | :: 54 | 1560 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 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 | 1824 | 251724 | Permitted Site 1 | :: 54 | 1630 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2017 12:00:00 AM | 3 | 3x3 | 6006933.88533 | 2116748.92044 | 37.792580631742204 | -122.419937373279 | (37.7925806317422, -122.419937373279) | ||
| 2270 | 2270 | 253008 | Permitted Site 1 | :: 54 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 11x477 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | ||
| 3276 | 3276 | 149033 | Permitted Site 1 | :: 54 | 3916 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2017 12:00:00 AM | 3 | 5.5x12 | 5996085.364440001 | 2114918.02173 | 37.7869363183091 | -122.45734088598302 | (37.7869363183091, -122.457340885983) | ||
| 3639 | 3639 | 253517 | Permitted Site 1 | :: 54 | 559 24th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x4.5 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
| 3643 | 3643 | 253515 | Permitted Site 1 | :: 54 | 559 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 7x9.5 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
| 3650 | 3650 | 253518 | Permitted Site 1 | :: 54 | 559 24th Ave | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x1 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
| 3660 | 3660 | 253516 | Permitted Site 1 | :: 54 | 559 24th Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x2 | 5988392.0 | 2112177.0 | 37.778965370493495 | -122.483756799769 | (37.7789653704935, -122.483756799769) | ||
| 4723 | 4723 | 253676 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 6 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 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 | 4726 | 253675 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 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 | 10092 | 173852 | Permitted Site 1 | :: 54 | 450 Toland St | 7 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 8.5x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10093 | 10093 | 173849 | Permitted Site 1 | :: 54 | 450 Toland St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 17.6x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10096 | 10096 | 173850 | Permitted Site 1 | :: 54 | 450 Toland St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 13.9x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10097 | 10097 | 173851 | Permitted Site 1 | :: 54 | 450 Toland St | 6 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 27.75x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10098 | 10098 | 173848 | Permitted Site 1 | :: 54 | 450 Toland St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 19.5x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10101 | 10101 | 173846 | Permitted Site 1 | :: 54 | 450 Toland St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 15x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10104 | 10104 | 173847 | Permitted Site 1 | :: 54 | 450 Toland St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 11.85x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10106 | 10106 | 173853 | Permitted Site 1 | :: 54 | 450 Toland St | 8 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 26.75x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10128 | 10128 | 173868 | Permitted Site 1 | :: 54 | 808 Capitol Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/31/2017 12:00:00 AM | 3 | 5995075.959430001 | 2089664.9067799998 | 37.717539636984206 | -122.45900401383601 | (37.7175396369842, -122.459004013836) | |||
| 10139 | 10139 | 173867 | Permitted Site 1 | :: 54 | 808 Capitol Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/31/2017 12:00:00 AM | 3 | 5995075.959430001 | 2089664.9067799998 | 37.717539636984206 | -122.45900401383601 | (37.7175396369842, -122.459004013836) | |||
| 42994 | 42994 | 109343 | Permitted Site 1 | :: 54 | 3211 Baker St | 2 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 51515 | 51515 | 120669 | Undocumented 2 | :: 54 | 61 Paradise Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2016 12:00:00 AM | 3 | 3x3 | 6000974.0 | 2096001.0 | 37.7352743855737 | -122.43907108078899 | (37.7352743855737, -122.439071080789) | ||
| 54387 | 54387 | 246177 | Undocumented 2 | :: 54 | 1588 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998014.6979 | 2108233.0836 | 37.7686918380665 | -122.450183832466 | (37.7686918380665, -122.450183832466) | |||
| 55449 | 55449 | 183888 | Undocumented 2 | :: 54 | 1390 Quintara St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988941.521000001 | 2101013.106 | 37.7483443270077 | -122.48103816738501 | (37.7483443270077, -122.481038167385) | |||
| 64371 | 64371 | 248338 | Undocumented 2 | :: 54 | 101 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998210.6283 | 2108198.2582 | 37.7686074267176 | -122.44950361782 | (37.7686074267176, -122.44950361782) | |||
| 65435 | 65435 | 183890 | Undocumented 2 | :: 54 | 1390 Quintara St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988977.7676 | 2101017.0459 | 37.748357251925604 | -122.480913117409 | (37.7483572519256, -122.480913117409) | |||
| 74231 | 74231 | 246137 | Undocumented 2 | :: 54 | 636 Shrader St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5997583.3178 | 2108295.6178 | 37.7688388454445 | -122.451680446787 | (37.7688388454445, -122.451680446787) | |||
| 77586 | 77586 | 121129 | Undocumented 2 | :: 54 | 201 Bemis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216.0 | 2096386.0 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | ||
| 81298 | 81298 | 104856 | Permitted Site 1 | :: 54 | 739 27th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 02/12/2015 12:00:00 AM | 3 | 6001722.3 | 2099959.7 | 37.746186600460604 | -122.43676722664301 | (37.7461866004606, -122.436767226643) | ||||
| 83041 | 83041 | 109366 | Permitted Site 1 | :: 54 | 1205 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3.125x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 83254 | 83254 | 110159 | Permitted Site 1 | :: 54 | 1041 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 55966 | 6008597.3 | 2118278.8 | 37.7968748776387 | -122.414290174718 | (37.7968748776387, -122.414290174718) | |||
| 84556 | 84556 | 115963 | Undocumented 2 | :: 54 | 847 43RD AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 3x3 | 5982585.0 | 2109998.0 | 37.7726427311472 | -122.50368379034599 | (37.7726427311472, -122.503683790346) | ||
| 85364 | 85364 | 115892 | Permitted Site 1 | :: 54 | 1900X Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.6083400003 | 37.75961937033 | -122.48168434385401 | (37.75961937033, -122.481684343854) | |||
| 85868 | 85868 | 115996 | Undocumented 2 | :: 54 | 136 DUNCAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6005652.0 | 2099949.0 | 37.746379771639795 | -122.423178037621 | (37.7463797716398, -122.423178037621) | |||
| 91154 | 91154 | 109365 | Permitted Site 1 | :: 54 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x16 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 92851 | 92851 | 7876 | DPW Maintained 3 | :: 54 | 1095X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2011 12:00:00 AM | 3 | 3x3 | 6006012.62101 | 2113826.37447 | 37.784504100894395 | -122.42291717866101 | (37.7845041008944, -122.422917178661) | ||
| 93014 | 93014 | 115931 | Undocumented 2 | :: 54 | 847 43RD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 3x3 | 5982585.0 | 2109998.0 | 37.7726427311472 | -122.50368379034599 | (37.7726427311472, -122.503683790346) | ||
| 96301 | 96301 | 101476 | Significant Tree 6 | :: 54 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 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 | 96541 | 110246 | Permitted Site 1 | :: 54 | 1706 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/01/2015 12:00:00 AM | 3 | 1.5x12 | 5987540.7 | 2103643.4 | 37.755484875136204 | -122.486075162345 | (37.7554848751362, -122.486075162345) | ||
| 97307 | 97307 | 109345 | Permitted Site 1 | :: 54 | 3211 Baker St | 4 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 8.75x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 97368 | 97368 | 121128 | Undocumented 2 | :: 54 | 201 Bemis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216.0 | 2096386.0 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | ||
| 98575 | 98575 | 115891 | Permitted Site 1 | :: 54 | 1900X Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.6083400003 | 37.75961937033 | -122.48168434385401 | (37.75961937033, -122.481684343854) | |||
| 99380 | 99380 | 119616 | Private 5 | :: 54 | 400 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 6005873.6969099995 | 2111410.5639299997 | 37.777863036884796 | -122.42322602570499 | (37.7778630368848, -122.423226025705) | |||
| 99464 | 99464 | 109344 | Permitted Site 1 | :: 54 | 3211 Baker St | 3 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 99672 | 99672 | 121127 | Undocumented 2 | :: 54 | 201 Bemis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216.0 | 2096386.0 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | ||
| 101115 | 101115 | 109364 | Permitted Site 1 | :: 54 | 1205 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x6 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 101195 | 101195 | 115894 | Permitted Site 1 | :: 54 | 1900X Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.6083400003 | 37.75961937033 | -122.48168434385401 | (37.75961937033, -122.481684343854) | |||
| 101235 | 101235 | 109535 | Permitted Site 1 | :: 54 | 1234 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 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 | 103215 | 116528 | Planning Code 138.1 required 4 | :: 54 | 125 CROWN TER | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 3x3 | 5998841.0 | 2104182.0 | 37.7576158290564 | -122.447034160915 | (37.7576158290564, -122.447034160915) | |||
| 105398 | 105398 | 117608 | Permitted Site 1 | :: 54 | 450 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 06/29/2016 12:00:00 AM | 3 | 6005708.4 | 2111040.6 | 37.776837876057 | -122.423771533631 | (37.776837876057, -122.423771533631) | |||
| 108481 | 108481 | 28868 | DPW Maintained 3 | :: 54 | 75 01st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6013233.2298598 | 2115774.102568 | 37.790256890180295 | -122.39807285434601 | (37.7902568901803, -122.398072854346) | ||
| 112218 | 112218 | 109536 | Permitted Site 1 | :: 54 | 1234 Filbert St | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 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 | 112494 | 119244 | Undocumented 2 | :: 54 | 311 30th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2016 12:00:00 AM | 3 | 3x3 | 6004402.0 | 2098353.0 | 37.7419269008751 | -122.42738671849101 | (37.7419269008751, -122.427386718491) | |||
| 116050 | 116050 | 111759 | Permitted Site 1 | :: 54 | 1235 47th Ave | 2 | Sidewalk: Curb side : Yard 2 | Landscaping 2 | Private 1 | 06/23/2015 12:00:00 AM | 3 | 6x4 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.50728446314301 | (37.7634442160317, -122.507284463143) | ||
| 116207 | 116207 | 109368 | Permitted Site 1 | :: 54 | 1205 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 124217 | 124217 | 37151 | Permitted Site 1 | :: 54 | 124 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 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 | 124298 | 109367 | Permitted Site 1 | :: 54 | 1205 Filbert St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 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 | 125370 | 3826 | DPW Maintained 3 | :: 54 | 120 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/16/1992 12:00:00 AM | 3 | 3X3 | 6016868.5122165 | 2095917.6664165 | 37.7359371538987 | -122.384111573291 | (37.7359371538987, -122.384111573291) | ||
| 125946 | 125946 | 109370 | Permitted Site 1 | :: 54 | 2061 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 13x6 | 6007159.6 | 2119443.7 | 37.799992536546505 | -122.41934764587201 | (37.7999925365465, -122.419347645872) | |
| 126302 | 126302 | 109534 | Permitted Site 1 | :: 54 | 1234 Filbert St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 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 | 128427 | 109369 | Permitted Site 1 | :: 54 | 2061 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 5x6 | 6007159.6 | 2119443.7 | 37.799992536546505 | -122.41934764587201 | (37.7999925365465, -122.419347645872) | |
| 129313 | 129313 | 117320 | Permitted Site 1 | :: 54 | 1935 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 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 | 133057 | 183886 | Undocumented 2 | :: 54 | 1390 Quintara St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988900.5466 | 2101013.106 | 37.7483419450285 | -122.48117985419901 | (37.7483419450285, -122.481179854199) | |||
| 133477 | 133477 | 246176 | Undocumented 2 | :: 54 | 1588 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998032.5648 | 2108236.7175 | 37.7687028382608 | -122.45012229449 | (37.7687028382608, -122.45012229449) | |||
| 138801 | 138801 | 115762 | Undocumented 2 | :: 54 | 84X Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | on Athens Street frontage | 6001679.7 | 2087642.4 | 37.712363687575795 | -122.43603329568501 | (37.7123636875758, -122.436033295685) | |||
| 140543 | 140543 | 109342 | Permitted Site 1 | :: 54 | 3211 Baker St | 1 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 1x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 142347 | 142347 | 109178 | Permitted Site 1 | :: 54 | 2832 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2015 12:00:00 AM | 3 | 6001592.1 | 2118171.6 | 37.796184544404895 | -122.438522078694 | (37.7961845444049, -122.438522078694) | |||
| 143440 | 143440 | 117372 | Permitted Site 1 | :: 54 | 1533 McAllister St | 5 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 06/08/2016 12:00:00 AM | 3 | 1x2.75 | 6001806.7 | 2111472.8 | 37.777803561930206 | -122.437299621265 | (37.7778035619302, -122.437299621265) | ||
| 144086 | 144086 | 115893 | Permitted Site 1 | :: 54 | 1900X Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.6083400003 | 37.75961937033 | -122.48168434385401 | (37.75961937033, -122.481684343854) | |||
| 145543 | 145543 | 111758 | Permitted Site 1 | :: 54 | 1235 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 06/23/2015 12:00:00 AM | 3 | 6x6 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.50728446314301 | (37.7634442160317, -122.507284463143) | ||
| 145560 | 145560 | 121126 | Undocumented 2 | :: 54 | 201 Bemis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216.0 | 2096386.0 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");