Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | ||
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 | |||||||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) | |||||
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) | ||||
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) | |||
5291 | 5291 | 17848 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2090 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003963.2928 | 2115315.9593 | 37.78847827825761 | -122.430113454106 | (37.7884782782576, -122.430113454106) | |||
5356 | 5356 | 17193 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6004642.48731 | 2116869.91995 | 37.792783506093706 | -122.427874318555 | (37.7927835060937, -122.427874318555) | |||
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) | ||
5502 | 5502 | 1908 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 35 Beideman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001516.9911 | 2113051.8602 | 37.782122787571 | -122.438414983045 | (37.782122787571, -122.438414983045) | |||
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) | |||
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) | |||
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) | |||
6117 | 6117 | 2621 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1806 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6004737.1436 | 2115078.0261 | 37.78786877138371 | -122.427419093403 | (37.7878687713837, -122.427419093403) | |||
6185 | 6185 | 17854 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2110 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3X3 | 6003813.5023 | 2115294.8194 | 37.7884117486508 | -122.430630196593 | (37.7884117486508, -122.430630196593) | |||
6236 | 6236 | 113401 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1620 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3x3 | 6006660.9339 | 2116485.9449 | 37.7918431849995 | -122.420863117756 | (37.7918431849995, -122.420863117756) | |||
6415 | 6415 | 18972 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6000755.04185 | 2115567.80541 | 37.7889875549728 | -122.441231548694 | (37.7889875549728, -122.441231548694) | |||
6606 | 6606 | 110464 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2820 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000086.68948 | 2117131.47994 | 37.793242901382 | -122.44365632957899 | (37.793242901382, -122.443656329579) | |||
6663 | 6663 | 17852 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2105 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003811.8281 | 2115238.2923 | 37.7882564446804 | -122.430631953837 | (37.7882564446804, -122.430631953837) | |||
6926 | 6926 | 18969 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6000801.71475 | 2115573.33512 | 37.78900539663729 | -122.44107046394501 | (37.7890053966373, -122.441070463945) | |||
7168 | 7168 | 18966 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6000828.50108 | 2115578.8735599997 | 37.789022129422 | -122.440978184497 | (37.789022129422, -122.440978184497) | |||
7394 | 7394 | 21614 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005184.5984 | 2114790.6062 | 37.787104884924204 | -122.42585051456699 | (37.7871048849242, -122.425850514567) | |||
7487 | 7487 | 21615 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005165.4963 | 2114788.8697 | 37.7870990374175 | -122.425916480019 | (37.7870990374175, -122.425916480019) | |||
7553 | 7553 | 142835 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1515 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Width 0ft | 6006663.5874 | 2116129.9342 | 37.7908658176323 | -122.42082865045799 | (37.7908658176323, -122.420828650458) | ||||
7600 | 7600 | 2716 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2178 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003083.0342 | 2114847.1509 | 37.7871411551889 | -122.433125499331 | (37.7871411551889, -122.433125499331) | |||
7742 | 7742 | 17849 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2098 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003937.153 | 2115309.199 | 37.7884582356735 | -122.43020341123001 | (37.7884582356735, -122.43020341123) | |||
7775 | 7775 | 27289 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005110.5056 | 2114781.9235 | 37.7870768570073 | -122.42610624116101 | (37.7870768570073, -122.426106241161) | |||
7843 | 7843 | 18977 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2912 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000739.52312 | 2115564.90607 | 37.788978710133 | -122.44128503318599 | (37.788978710133, -122.441285033186) | |||
7885 | 7885 | 21612 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005218.1717 | 2114795.8159 | 37.7871210866889 | -122.4257347292 | (37.7871210866889, -122.4257347292) | |||
7897 | 7897 | 2622 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1806 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004719.8929 | 2115076.5886 | 37.787863848693796 | -122.427478675215 | (37.7878638486938, -122.427478675215) | |||
7957 | 7957 | 21757 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2350 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008462.5324 | 2121012.4644 | 37.8043732668186 | -122.414950085154 | (37.8043732668186, -122.414950085154) | |||
7977 | 7977 | 121363 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2235 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 4x4 | 6003480.6040199995 | 2116883.14161 | 37.792754011941106 | -122.431895428424 | (37.7927540119411, -122.431895428424) | |||
8036 | 8036 | 116472 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 825 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009953.87046 | 2116097.82442 | 37.7909625570162 | -122.40944210258999 | (37.7909625570162, -122.40944210259) | |||
8052 | 8052 | 3037 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2611 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X2 | 6001770.5365 | 2115308.215 | 37.7883325797422 | -122.437699479333 | (37.7883325797422, -122.437699479333) | |||
8080 | 8080 | 18902 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2599 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002415.46801 | 2115750.47994 | 37.7895835752639 | -122.43549977541599 | (37.7895835752639, -122.435499775416) | |||
8090 | 8090 | 18971 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000776.930509999 | 2115571.586 | 37.7889991823101 | -122.44115608838301 | (37.7889991823101, -122.441156088383) | |||
8101 | 8101 | 18925 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2679 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002005.1865 | 2115691.57373 | 37.7893985235705 | -122.43691508526301 | (37.7893985235705, -122.436915085263) | |||
8262 | 8262 | 18970 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6000791.352940001 | 2115572.7233700003 | 37.789003126734706 | -122.441106270442 | (37.7890031267347, -122.441106270442) | |||
8285 | 8285 | 112347 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 21 Perine Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6002122.29425 | 2115555.10135 | 37.7890304607445 | -122.436500134475 | (37.7890304607445, -122.436500134475) | |||
8310 | 8310 | 110965 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2445 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | 5x5 | 6003004.00297 | 2116485.50112 | 37.791635163595096 | -122.433516057127 | (37.7916351635951, -122.433516057127) | |||
8544 | 8544 | 110463 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2820 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000109.08248 | 2117133.8316 | 37.7932506355596 | -122.443579017584 | (37.7932506355596, -122.443579017584) | |||
8652 | 8652 | 17853 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2107 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003780.8726 | 2115230.9219 | 37.7882344536868 | -122.430738528508 | (37.7882344536868, -122.430738528508) | |||
8865 | 8865 | 21647 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1660 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X2 | 6004652.0562 | 2114715.3557 | 37.786868156632295 | -122.427687630429 | (37.7868681566323, -122.427687630429) | |||
9024 | 9024 | 17192 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 6004636.98078 | 2116874.21207 | 37.792794979656 | -122.42789367737801 | (37.792794979656, -122.427893677378) | |||
9144 | 9144 | 23646 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006680.626318 | 2098423.5908349 | 37.7422493368979 | -122.419512955866 | (37.7422493368979, -122.419512955866) | |||
9152 | 9152 | 3994 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 281 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002294.9936565 | 2106589.3936607 | 37.7644226821565 | -122.435261055898 | (37.7644226821565, -122.435261055898) | |||
9222 | 9222 | 3940 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 101 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002266.5 | 2107605.5 | 37.767211043352 | -122.435432299631 | (37.767211043352, -122.435432299631) | |||
9224 | 9224 | 3988 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 263 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002289.1914049005 | 2106695.3229 | 37.764713208493795 | -122.435288701865 | (37.7647132084938, -122.435288701865) | |||
9281 | 9281 | 26276 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1770 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 1X1 | 6000824.4471487 | 2093863.5491185002 | 37.729396929882704 | -122.43943496951599 | (37.7293969298827, -122.439434969516) | |||
9408 | 9408 | 3991 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 271 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002291.775341 | 2106648.1490788003 | 37.76458382743429 | -122.435276390167 | (37.7645838274343, -122.435276390167) | |||
9523 | 9523 | 21636 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1630 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004948.4275 | 2114804.4986 | 37.7871296807328 | -122.42666860400298 | (37.7871296807328, -122.426668604003) | |||
9549 | 9549 | 14717 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 860 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 6002499.3078 | 2111491.3684 | 37.77789389493321 | -122.434904982102 | (37.7778938949332, -122.434904982102) | |||
9816 | 9816 | 113835 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 920X Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6007995.0 | 2102398.0 | 37.753236120336105 | -122.415249523598 | (37.7532361203361, -122.415249523598) | |||
9817 | 9817 | 121467 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 50 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 778925 | 6002578.0 | 2096112.0 | 37.735670303373 | -122.4335333993 | (37.735670303373, -122.4335333993) | ||
9979 | 9979 | 173763 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 347 Dolores St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6004948.0 | 2106317.0 | 37.7638250559684 | -122.426065641314 | (37.7638250559684, -122.426065641314) | |||
11183 | 11183 | 107055 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 116 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003293.700669999 | 2094464.35217 | 37.7311868176017 | -122.430941393456 | (37.7311868176017, -122.430941393456) |
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");