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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
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) | ||
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) | |||
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) | ||||
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) | ||
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) | ||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) | ||
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) | ||
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) | |||||
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) | ||
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) | ||||
5041 | 5041 | 13058 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2016 12:00:00 AM | 3 | 3x3 | 6009536.2583 | 2120492.2964 | 37.803005290938394 | -122.411197584686 | (37.8030052909384, -122.411197584686) | ||
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) | ||
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) | |||
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) | |||
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) | ||
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) | ||
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) | |||
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) | ||
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) | ||
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) | |||
6424 | 6424 | 29121 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6008434.8728 | 2114228.13336 | 37.7857436131333 | -122.414565426956 | (37.7857436131333, -122.414565426956) | ||
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) | |||
6648 | 6648 | 103825 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006956.54225 | 2114398.79268 | 37.786129037366294 | -122.41969215528 | (37.7861290373663, -122.41969215528) | ||
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) | |||
6781 | 6781 | 28297 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 886 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2003 12:00:00 AM | 3 | 3X3 | 6003187.6794 | 2110345.6225 | 37.77478702085 | -122.43244181014799 | (37.77478702085, -122.432441810148) | ||
6889 | 6889 | 27340 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 646 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1998 12:00:00 AM | 3 | 4X4 | 6004269.3633 | 2110497.2933 | 37.7752647494287 | -122.428710856528 | (37.7752647494287, -122.428710856528) | ||
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) | |||
7301 | 7301 | 103830 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006932.57902 | 2114171.45975 | 37.785503486943604 | -122.419758925448 | (37.7855034869436, -122.419758925448) | ||
7335 | 7335 | 21613 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1990 12:00:00 AM | 3 | 3X3 | 6005201.9639 | 2114793.5005 | 37.7871138132891 | -122.42579063980499 | (37.7871138132891, -122.425790639805) | ||
7345 | 7345 | 27341 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 646 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1998 12:00:00 AM | 3 | 4X4 | 6004251.9521 | 2110495.2843 | 37.7752582477922 | -122.4287709426 | (37.7752582477922, -122.4287709426) | ||
7388 | 7388 | 5226 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1031 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | 3 | 3X3 | 6001391.1909 | 2111988.4032 | 37.779195648412 | -122.43877396477501 | (37.779195648412, -122.438773964775) | ||
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) | |||
7506 | 7506 | 14836 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1300 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 10/22/2008 12:00:00 AM | 9 | 3X3 | 6002892.8097 | 2111692.1261 | 37.7784674596438 | -122.43355807318501 | (37.7784674596438, -122.433558073185) | |
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) | |||
7606 | 7606 | 27342 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 658 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1998 12:00:00 AM | 3 | 4X4 | 6004212.4421 | 2110492.9405 | 37.7752495760457 | -122.428907449576 | (37.7752495760457, -122.428907449576) | ||
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) | |||
7774 | 7774 | 103816 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1100 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006901.46306 | 2114785.14538 | 37.7871867641959 | -122.41991014106002 | (37.7871867641959, -122.41991014106) | ||
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) | |||
7813 | 7813 | 18956 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2867 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 3x3 | 6001086.2115 | 2115563.33325 | 37.788994134415496 | -122.440085427516 | (37.7889941344155, -122.440085427516) | ||
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) |
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");