Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, 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) | ||
| 198 | 198 | 103786 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1221 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006804.9894 | 2115120.2532 | 37.7881014522033 | -122.420267712778 | (37.7881014522033, -122.420267712778) | ||
| 215 | 215 | 17196 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6004629.787409999 | 2116932.39582 | 37.792954330542 | -122.42792271466601 | (37.792954330542, -122.427922714666) | |||
| 246 | 246 | 251253 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1350 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008544.9526 | 2110145.4696299997 | 37.774539777213995 | -122.413895673958 | (37.774539777214, -122.413895673958) | ||||
| 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) | ||
| 465 | 465 | 200701 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1433 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 1 | Width 0ft | 6014951.6841 | 2095311.6378 | 37.7341669595219 | -122.390696529464 | (37.7341669595219, -122.390696529464) | ||
| 508 | 508 | 6667 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Evans Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:21:00 PM | 3 | 3X3 | 6015906.32098 | 2098408.37334 | 37.7427228837554 | -122.387611997891 | (37.7427228837554, -122.387611997891) | ||
| 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) | ||
| 690 | 690 | 230152 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6004291.387 | 2105480.80272 | 37.761491925527395 | -122.42827706645299 | (37.7614919255274, -122.428277066453) | |||
| 691 | 691 | 230156 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 3ft | 6004288.891419999 | 2105591.3935700003 | 37.7617954404249 | -122.42829357981 | (37.7617954404249, -122.42829357981) | |||
| 698 | 698 | 230154 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6004288.78705 | 2105528.40005 | 37.7616224693351 | -122.42828945101999 | (37.7616224693351, -122.42828945102) | |||
| 699 | 699 | 230157 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 3ft | 6004285.8388 | 2105617.0111 | 37.7618656073228 | -122.428305963472 | (37.7618656073228, -122.428305963472) | |||
| 722 | 722 | 230151 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 3ft | 6004293.8189199995 | 2105454.00937 | 37.761418494979296 | -122.42826674581998 | (37.7614184949793, -122.42826674582) | |||
| 723 | 723 | 230153 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 3ft | 6004293.15538 | 2105508.69845 | 37.7615686206128 | -122.428272938555 | (37.7615686206128, -122.428272938555) | |||
| 725 | 725 | 230155 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 3ft | 6004284.84721 | 2105568.89365 | 37.7617334321738 | -122.42830596346201 | (37.7617334321738, -122.428305963462) | |||
| 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) | ||
| 808 | 808 | 193091 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1395 Fairfax Ave | 1 | : 4 | Tree 1 | DPW 2 | 01/27/2015 12:22:00 PM | 6 | Width 3ft | 6016598.40823 | 2097419.6759099998 | 37.7400464320877 | -122.38515006152201 | (37.7400464320877, -122.385150061522) | ||
| 840 | 840 | 193039 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1800 Evans Ave | 10 | : 4 | Tree 1 | DPW 2 | 05/12/2011 12:00:00 AM | 5 | Width 4ft | 6014331.82546 | 2099544.27863 | 37.7457545046729 | -122.39313565907699 | (37.7457545046729, -122.393135659077) | ||
| 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) | ||
| 972 | 972 | 17847 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2082 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003983.5737 | 2115317.762 | 37.788484376640206 | -122.430043414021 | (37.7884843766402, -122.430043414021) | |||
| 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) | |||
| 1267 | 1267 | 18523 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1751X Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6009567.6842 | 2119779.6829 | 37.801050393337604 | -122.41103847024901 | (37.8010503933376, -122.411038470249) | |||
| 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) | |||
| 1443 | 1443 | 229286 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 301 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/2009 12:00:00 AM | 1 | Width 4ft | 6004913.9735 | 2106476.40674 | 37.7642608257117 | -122.426194678137 | (37.7642608257117, -122.426194678137) | ||
| 1566 | 1566 | 21756 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2350 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6008463.4743 | 2120995.0395 | 37.8043254753522 | -122.41494559157199 | (37.8043254753522, -122.414945591572) | |||
| 1746 | 1746 | 7330 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2049 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 1X1 | 6002872.8198 | 2115392.1403 | 37.7886256306485 | -122.433891763872 | (37.7886256306485, -122.433891763872) | |||
| 1853 | 1853 | 1906 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 27 Beideman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001522.4059 | 2113011.2495 | 37.782011588916795 | -122.43839333989901 | (37.7820115889168, -122.438393339899) | |||
| 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) | |
| 2040 | 2040 | 29049 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 270 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2016 12:00:00 AM | 3 | 3x3 | 6008308.58603 | 2109310.64459 | 37.772234267135 | -122.414654224229 | (37.772234267135, -122.414654224229) | ||
| 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) | |
| 2148 | 2148 | 18880 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2315 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/13/2014 12:00:00 AM | 3 | 3x3 | 6003622.42952 | 2115918.82336 | 37.790114278706604 | -122.43133583878799 | (37.7901142787066, -122.431335838788) | ||
| 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) | |
| 2217 | 2217 | 13060 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/26/2013 12:00:00 AM | 3 | 2X2 | 6009601.7098 | 2120500.5639 | 37.8030316618488 | -122.41097167179701 | (37.8030316618488, -122.410971671797) | ||
| 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) | |||
| 2756 | 2756 | 17850 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2100 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6003840.3349 | 2115295.8514 | 37.7884161023437 | -122.430537433765 | (37.7884161023437, -122.430537433765) | |||
| 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) | |
| 3326 | 3326 | 230158 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Church St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 6x9 | 6004286.27951 | 2105638.39668 | 37.7619243519609 | -122.42830596346901 | (37.7619243519609, -122.428305963469) | |||
| 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) | |
| 3711 | 3711 | 229522 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1400 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2008 12:00:00 AM | 3 | Width 2ft | 6004493.41372 | 2100695.79384 | 37.748364843572794 | -122.427237482541 | (37.7483648435728, -122.427237482541) | ||
| 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 | |||||||||
| 3824 | 3824 | 229287 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 420 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 2 | 6x6 | 6004863.64618 | 2105856.17124 | 37.7625549619753 | -122.42632458341299 | (37.7625549619753, -122.426324583413) | ||
| 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) | |||||
| 4619 | 4619 | 130948 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2361 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/2015 12:00:00 AM | 2 | Width 3ft | 6008329.55597 | 2121605.69745 | 37.8059946620911 | -122.41545228710501 | (37.8059946620911, -122.415452287105) | ||
| 4651 | 4651 | 229338 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2154 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2007 12:00:00 AM | 5 | 8x6 | 6009553.168190001 | 2104723.82915 | 37.759709771404296 | -122.41002522030001 | (37.7597097714043, -122.4100252203) | ||
| 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) | |
| 4833 | 4833 | 4457 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1408 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/2017 12:00:00 AM | 3 | 3X3 | Permit Number 779671 | 6004499.90701 | 2100635.94447 | 37.748200878269294 | -122.42721076637599 | (37.7482008782693, -122.427210766376) | |
| 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) |
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");