Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42 | 42 | 28375 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 3014 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2003 12:00:00 AM | 3 | 3x3 | Permit Number 54020 | 6000248.590919999 | 2115494.6796 | 37.788757908594896 | -122.442978542939 | (37.7887579085949, -122.442978542939) | |
| 83 | 83 | 130626 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3660 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | Permit Number 779583 | 5996802.12344 | 2115996.768 | 37.789939408212206 | -122.454939052208 | (37.7899394082122, -122.454939052208) | ||
| 190 | 190 | 57209 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2898 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | Permit Number 773671 | 6000999.92024 | 2115926.87738 | 37.7899874194288 | -122.440410066565 | (37.7899874194288, -122.440410066565) | ||
| 254 | 254 | 98489 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1813 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2016 12:00:00 AM | 3 | 4.5x5 | Permit Number 777656 | 5999969.69733 | 2115286.35323 | 37.7881699939074 | -122.443928497714 | (37.7881699939074, -122.443928497714) | |
| 430 | 430 | 103824 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006951.91038 | 2114418.6460599997 | 37.786183288961205 | -122.419709589538 | (37.7861832889612, -122.419709589538) | ||
| 566 | 566 | 243384 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 88 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2017 12:00:00 AM | 3 | 3x3 | 6010512.94245 | 2100000.19671 | 37.746793468955204 | -122.406372986245 | (37.7467934689552, -122.406372986245) | ||
| 768 | 768 | 13057 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 566 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2014 12:00:00 AM | 3 | 2x2 | 6009630.8999 | 2120542.6321 | 37.8031488074681 | -122.410873631329 | (37.8031488074681, -122.410873631329) | ||
| 878 | 878 | 108700 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3024 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772805 | 6001479.41501 | 2118822.32035 | 37.7979648412708 | -122.438958648025 | (37.7979648412708, -122.438958648025) |
| 943 | 943 | 17376 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1600 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Property owner contact Achmed 821-1594. | 6014810.6051199995 | 2095342.4042099998 | 37.7342436096391 | -122.391186437905 | (37.7342436096391, -122.391186437905) | ||
| 1138 | 1138 | 44040 | Section 143 8 | Magnolia grandiflora :: Southern Magnolia 21 | 2504 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2012 12:00:00 AM | 3 | Permit Number 769379 | 6002104.9323 | 2116736.7445400003 | 37.7922739619269 | -122.436644820121 | (37.7922739619269, -122.436644820121) | ||
| 1179 | 1179 | 40176 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3591 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1999 12:00:00 AM | 7 | 4X4 | Permit Number 41367 | 5997123.1138 | 2115994.68514 | 37.7899520976567 | -122.453828309438 | (37.7899520976567, -122.453828309438) | |
| 1258 | 1258 | 143477 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 645 CALIFORNIA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010516.819 | 2116392.3089 | 37.791802666645104 | -122.407515085146 | (37.7918026666451, -122.407515085146) | |||
| 1329 | 1329 | 108251 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2342 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2014 12:00:00 AM | 3 | Permit Number 772707 | 6003487.823480001 | 2116598.59659 | 37.791973133309796 | -122.43185012238199 | (37.7919731333098, -122.431850122382) | ||
| 1337 | 1337 | 251410 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2777 Pine St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 779015 | 6000658.0 | 2114782.0 | 37.7868244087741 | -122.441510888069 | (37.7868244087741, -122.441510888069) | |||
| 1396 | 1396 | 21755 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2350 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008465.3581 | 2120976.6726 | 37.8042751503167 | -122.414937771753 | (37.8042751503167, -122.414937771753) | |||
| 1857 | 1857 | 251765 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | ||||
| 1870 | 1870 | 251767 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | ||||
| 1871 | 1871 | 176854 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | |||
| 1876 | 1876 | 251766 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | ||||
| 1915 | 1915 | 124401 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3974 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779990 | 5995681.39121 | 2115513.426 | 37.788547927118294 | -122.45878165411999 | (37.7885479271183, -122.45878165412) | |
| 2055 | 2055 | 130716 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2998 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779575 | 5999812.313709999 | 2117089.58142 | 37.79311220651329 | -122.444602671772 | (37.7931122065133, -122.444602671772) | |
| 2176 | 2176 | 103962 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3240 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | Permit Number 780028 | 5998623.05948 | 2116578.56663 | 37.7916411629484 | -122.448680722253 | (37.7916411629484, -122.448680722253) | ||
| 2187 | 2187 | 47144 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3240 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780028 | 5998645.601919999 | 2116582.6217400003 | 37.7916535861885 | -122.448603018129 | (37.7916535861885, -122.448603018129) | |
| 2241 | 2241 | 193105 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1649 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 10/28/1996 12:00:00 AM | 10 | Width 5ft | 6014582.89152 | 2095437.7386599998 | 37.734492738953 | -122.39198038730301 | (37.734492738953, -122.391980387303) | ||
| 2257 | 2257 | 229627 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 3662 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008456.11159 | 2097816.22885 | 37.7406815009641 | -122.41333091228701 | (37.7406815009641, -122.413330912287) | |||
| 2302 | 2302 | 97526 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 532 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Permit Number 778941 | 6013958.0435 | 2114445.5251 | 37.7866492675441 | -122.395471917224 | (37.7866492675441, -122.395471917224) | ||
| 2308 | 2308 | 193164 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 282 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6013490.496590001 | 2114117.3583299997 | 37.785722181364896 | -122.397066509426 | (37.7857221813649, -122.397066509426) | |||
| 2311 | 2311 | 193166 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 282 02nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | Permit Number 778941 | 6013536.23807 | 2114063.46383 | 37.7855767457266 | -122.396904475854 | (37.7855767457266, -122.396904475854) | ||
| 2316 | 2316 | 193165 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 282 02nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6013505.95629 | 2114104.3862 | 37.7856874234834 | -122.39701211302099 | (37.7856874234834, -122.397012113021) | |||
| 2317 | 2317 | 97527 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 532 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Permit Number 778941 | 6013942.6198 | 2114432.1579 | 37.7866117064154 | -122.395524343042 | (37.7866117064154, -122.395524343042) | ||
| 2321 | 2321 | 201175 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 600 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | Permit Number 778941 | 6013539.5466 | 2114043.4802 | 37.7855220594596 | -122.396891627661 | (37.7855220594596, -122.396891627661) | ||
| 2348 | 2348 | 97523 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 532 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2016 12:00:00 AM | 2 | 3x3 | Permit Number 778941 | 6013933.3655 | 2114419.8189 | 37.7865773116244 | -122.395555496101 | (37.7865773116244, -122.395555496101) | |
| 2349 | 2349 | 97528 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 532 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 778941 | 6013984.7779 | 2114467.1183 | 37.78671004442771 | -122.395380935237 | (37.7867100444277, -122.395380935237) | ||
| 2353 | 2353 | 97525 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 532 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Permit Number 778941 | 6013969.3542 | 2114455.8076 | 37.786678130014 | -122.395433505269 | (37.786678130014, -122.395433505269) | ||
| 2357 | 2357 | 39974 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 0 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
| 2473 | 2473 | 253095 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1201 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779996 | 5987047.82966 | 2107087.0186099997 | 37.7649113707945 | -122.488032657316 | (37.7649113707945, -122.488032657316) | |
| 2679 | 2679 | 21616 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005148.1308 | 2114788.2908 | 37.7870964664996 | -122.425976519639 | (37.7870964664996, -122.425976519639) | |||
| 2802 | 2802 | 229983 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 568 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1982 12:00:00 AM | 15 | Width 2ft | Permit Number 19661 | 6003129.342019999 | 2095763.1248 | 37.7347436380916 | -122.43160229890499 | (37.7347436380916, -122.431602298905) | |
| 2807 | 2807 | 229984 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 570 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 15 | Width 2ft | Permit Number 18749 | 6003101.73362 | 2095751.10024 | 37.734709056481705 | -122.431696892311 | (37.7347090564817, -122.431696892311) | |
| 2809 | 2809 | 229980 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 542 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1982 12:00:00 AM | 15 | Width 3ft | Permit Number 19660 | 6003257.39485 | 2095864.5781900003 | 37.735029463323 | -122.431166815702 | (37.735029463323, -122.431166815702) | |
| 2813 | 2813 | 229987 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 581 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 13 | Width 2ft | Permit Number 18753 | 6003140.984180001 | 2095726.54341 | 37.734643853813296 | -122.431559437241 | (37.7346438538133, -122.431559437241) | |
| 2818 | 2818 | 229986 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 599 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1984 12:00:00 AM | 9 | Width 2ft | Permit Number 21284 | 6003081.800919999 | 2095704.053 | 37.734578745606704 | -122.431762448377 | (37.7345787456067, -122.431762448377) | |
| 2820 | 2820 | 229988 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 569 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 10 | Width 2ft | Permit Number 18752 | 6003200.6174 | 2095770.85092 | 37.734768891957394 | -122.43135642697099 | (37.7347688919574, -122.431356426971) | |
| 2821 | 2821 | 229978 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 530 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 16 | Width 2ft | Permit Number 18745 | 6003326.59414 | 2095915.8411400001 | 37.735174140867294 | -122.43093122660801 | (37.7351741408673, -122.430931226608) | |
| 2822 | 2822 | 229979 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 536 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1982 12:00:00 AM | 11 | Width 3ft | Permit Number 19659 | 6003305.39384 | 2095901.6279 | 37.7351339132885 | -122.431003509611 | (37.7351339132885, -122.431003509611) | |
| 2831 | 2831 | 229982 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 560 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 12 | Width 2ft | Permit Number 18747 | 6003179.1898 | 2095802.1923599998 | 37.734853734004105 | -122.431432746149 | (37.7348537340041, -122.431432746149) | |
| 2836 | 2836 | 229976 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 506 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1983 12:00:00 AM | 13 | Width 2ft | Permit Number 20257 | 6003460.201330001 | 2096023.8631099998 | 37.7354783140686 | -122.430477003328 | (37.7354783140686, -122.430477003328) | |
| 2838 | 2838 | 229981 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 556 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 14 | Width 3ft | Permit Number 18746 | 6003219.85889 | 2095834.25264 | 37.7349440691062 | -122.431294426813 | (37.7349440691062, -122.431294426813) | |
| 2840 | 2840 | 229977 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 522 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 14 | Width 2ft | Permit Number 18744 | 6003363.64026 | 2095947.4621700002 | 37.7352630640274 | -122.43080540066099 | (37.7352630640274, -122.430805400661) | |
| 2905 | 2905 | 140308 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2084 HAYES ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997875.744 | 2109950.7455 | 37.773400144182 | -122.450788324281 | (37.773400144182, -122.450788324281) | |||
| 2938 | 2938 | 60590 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 601 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 14 | 4x4 | Permit Number 20209 | 6000481.0 | 2111039.0 | 37.77653700517929 | -122.441854521628 | (37.7765370051793, -122.441854521628) |
| 2969 | 2969 | 139518 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 601 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6000481.0 | 2111039.0 | 37.77653700517929 | -122.441854521628 | (37.7765370051793, -122.441854521628) | |||
| 3021 | 3021 | 230623 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1189 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 780105 | 6003227.47781 | 2101395.97858 | 37.7502157130929 | -122.431665039223 | (37.7502157130929, -122.431665039223) | |
| 3365 | 3365 | 229966 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 278 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 17 | Width 3ft | Permit Number 18733 | 6004468.47248 | 2096814.7875400002 | 37.7377070787211 | -122.42704734426 | (37.7377070787211, -122.42704734426) | |
| 3456 | 3456 | 27619 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2799X Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001525.7969 | 2115623.6000599996 | 37.7891846270188 | -122.438568843173 | (37.7891846270188, -122.438568843173) | |||
| 3473 | 3473 | 8205 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1374 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/2006 12:00:00 AM | 30 | 3X3 | 6001195.167 | 2111111.9943 | 37.7767780974284 | -122.43938925166599 | (37.7767780974284, -122.439389251666) | ||
| 3593 | 3593 | 108302 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2200X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | Permit Number 773671 | 6000905.886 | 2115941.06387 | 37.7900210171946 | -122.440736434162 | (37.7900210171946, -122.440736434162) | ||
| 3616 | 3616 | 97137 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2929 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 24 | 3x3 | Permit Number 776885 | 6000677.09541 | 2116163.2813 | 37.790618136459706 | -122.441543981264 | (37.7906181364597, -122.441543981264) | |
| 3634 | 3634 | 245136 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 102 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2017 12:00:00 AM | 3 | Width 0ft | 6000842.6527 | 2109374.9669 | 37.7719885903551 | -122.440484089064 | (37.7719885903551, -122.440484089064) | ||
| 3678 | 3678 | 208759 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 300 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/24/2005 12:00:00 AM | 2 | Width 3ft | Permit Number 48287 | 5993126.46853 | 2099702.60224 | 37.7449884054972 | -122.466471606489 | (37.7449884054972, -122.466471606489) | |
| 3753 | 3753 | 253554 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 1855 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778968 | 5986885.63083 | 2102641.2721 | 37.7526951056681 | -122.48826692291901 | (37.7526951056681, -122.488266922919) | |
| 3821 | 3821 | 46195 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 3888 | 3888 | 229599 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 955 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2000 12:00:00 AM | 2 | Width 4ft | Permit Number 43291 | 5999204.37358 | 2106797.0588 | 37.7648168837066 | -122.44596555389 | (37.7648168837066, -122.44596555389) | |
| 4027 | 4027 | 253600 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 865 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | |||||
| 4034 | 4034 | 253599 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 865 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x9 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | ||||
| 4041 | 4041 | 253601 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 865 El Camino Del Mar | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | |||||
| 4777 | 4777 | 177351 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 501X San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | 4 | Width 3ft | Permit Number 48612 | 6000375.5599 | 2092850.3110099998 | 37.7265892548896 | -122.440914152761 | (37.7265892548896, -122.440914152761) | |
| 4783 | 4783 | 177353 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 501X San Juan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | 7 | Width 3ft | Permit Number 48612 | 6000427.73907 | 2092811.4085099997 | 37.726485409251794 | -122.44073098247401 | (37.7264854092518, -122.440730982474) | |
| 4824 | 4824 | 177352 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 501X San Juan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | 8 | Width 3ft | Permit Number 48612 | 6000403.69972 | 2092831.46295 | 37.7265391050915 | -122.44081552323999 | (37.7265391050915, -122.44081552324) | |
| 4864 | 4864 | 253698 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2200 Ofarrell St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Width 0ft | 6000775.0 | 2113124.0 | 37.7822786323031 | -122.440987106931 | (37.7822786323031, -122.440987106931) | ||||
| 4879 | 4879 | 171860 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 909 Woolsey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 2ft | 6009090.60075 | 2091384.92035 | 37.72305810822721 | -122.41068301413601 | (37.7230581082272, -122.410683014136) | |||
| 4921 | 4921 | 253716 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2959 21st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5x15 | 5989962.0 | 2095532.0 | 37.733353897105495 | -122.477108940264 | (37.7333538971055, -122.477108940264) | ||||
| 4942 | 4942 | 58811 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2049 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2014 12:00:00 AM | 3 | Permit Number 773701 | 6003239.80181 | 2118222.27779 | 37.796417281581505 | -122.432824322909 | (37.7964172815815, -122.432824322909) | ||
| 5098 | 5098 | 253771 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 844 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2017 12:00:00 AM | 3 | 3x3 | 6008309.10382 | 2120362.6037 | 37.802580290063 | -122.41543500385 | (37.802580290063, -122.41543500385) | ||
| 5109 | 5109 | 36635 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 5149 | 5149 | 229451 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 265 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6005008.0 | 2106862.0 | 37.7653248869664 | -122.425896916313 | (37.7653248869664, -122.425896916313) | |||
| 5162 | 5162 | 110966 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2445 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5x5 | 6003013.8449 | 2116487.52825 | 37.791641287967 | -122.433482149098 | (37.791641287967, -122.433482149098) | |||
| 5381 | 5381 | 103000 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2440 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | Permit Number 19730 | 6002354.34125 | 2116771.6973599996 | 37.7923841036956 | -122.435784363176 | (37.7923841036956, -122.435784363176) | ||
| 5435 | 5435 | 33143 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2272 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 14 | 4x4 | Permit Number 37369 | 6002130.31107 | 2118463.23451 | 37.7970158973151 | -122.43668064819401 | (37.7970158973151, -122.436680648194) |
| 5511 | 5511 | 27288 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005131.3442 | 2114782.5023 | 37.78707962400679 | -122.426034185389 | (37.7870796240068, -122.426034185389) | |||
| 5578 | 5578 | 18957 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2870 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2000 12:00:00 AM | 3 | 3X3 | 6001094.21569 | 2115613.50067 | 37.789132336830605 | -122.44006133289 | (37.7891323368306, -122.44006133289) | ||
| 5593 | 5593 | 103823 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006948.133219999 | 2114434.09135 | 37.7862254851663 | -122.419723753855 | (37.7862254851663, -122.419723753855) | ||
| 5724 | 5724 | 18967 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X5 | 6000819.2901800005 | 2115577.18131 | 37.789016958326705 | -122.44100993146999 | (37.7890169583267, -122.44100993147) | |||
| 5750 | 5750 | 113067 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 170 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6002551.458330001 | 2119026.31072 | 37.7985858824821 | -122.435263675492 | (37.7985858824821, -122.435263675492) | |||
| 5776 | 5776 | 18968 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X5 | 6000810.83314 | 2115575.0283 | 37.789010565033294 | -122.44103903711901 | (37.7890105650333, -122.441039037119) | |||
| 5806 | 5806 | 103783 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1233 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006792.9578 | 2115204.8755 | 37.788333126211796 | -122.42031534861601 | (37.7883331262118, -122.420315348616) | ||
| 5809 | 5809 | 46193 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 5842 | 5842 | 103829 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006929.69351 | 2114192.11644 | 37.7855600426056 | -122.41977037472 | (37.7855600426056, -122.41977037472) | ||
| 5900 | 5900 | 27618 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2799X Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 6 | 3X3 | 6001512.5153 | 2115623.04918 | 37.789182358914 | -122.43861475628799 | (37.789182358914, -122.438614756288) | ||
| 5915 | 5915 | 84945 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1812 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49349 | 6003466.4043 | 2115034.3792 | 37.7876769759783 | -122.431812496651 | (37.7876769759783, -122.431812496651) | |
| 6031 | 6031 | 27339 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 640 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6004290.4577 | 2110500.9764 | 37.7752760561488 | -122.428638148774 | (37.7752760561488, -122.428638148774) | |||
| 6118 | 6118 | 98490 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1815 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773915 | 5999966.14399 | 2115303.99268 | 37.788218224545005 | -122.443942059503 | (37.788218224545, -122.443942059503) | |
| 6146 | 6146 | 97674 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2619 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768452 | 5999883.3195 | 2113998.3376 | 37.7846285104726 | -122.444134760871 | (37.7846285104726, -122.444134760871) | |
| 6157 | 6157 | 117446 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1442 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778580 | 6007836.0514 | 2116543.8472700003 | 37.792068336434205 | -122.416801303441 | (37.7920683364342, -122.416801303441) | ||
| 6175 | 6175 | 18989 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2949 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 12 | 3x3 | Permit Number 49846 | 6000698.465009999 | 2115512.61265 | 37.78883278704021 | -122.44142333452 | (37.7888327870402, -122.44142333452) | |
| 6261 | 6261 | 58063 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1747 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1977 12:00:00 AM | 12 | Permit Number 17033 | 5999523.022000001 | 2114932.0979 | 37.7871718119958 | -122.445448429932 | (37.7871718119958, -122.445448429932) | ||
| 6278 | 6278 | 103957 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2465 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770692 | 6002902.62076 | 2116470.8664700002 | 37.7915892279996 | -122.433865791789 | (37.7915892279996, -122.433865791789) | |
| 6300 | 6300 | 103795 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1215 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006811.4062 | 2115079.7468 | 37.78799059318229 | -122.42024263571899 | (37.7879905931823, -122.420242635719) | ||
| 6326 | 6326 | 58062 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1732 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1977 12:00:00 AM | 10 | 3x3 | Permit Number 17032 | 5999582.2359 | 2114859.9248 | 37.78697702365571 | -122.44523837241199 | (37.7869770236557, -122.445238372412) | |
| 6329 | 6329 | 18985 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2926 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1997 12:00:00 AM | 3 | 3X3 | 6000546.31871 | 2115537.57863 | 37.7888926683961 | -122.441951530652 | (37.7888926683961, -122.441951530652) |
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");