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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79220 | 79220 | 86712 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3806 22nd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2007 12:00:00 AM | Permit Number 49698 | 6003066.0 | 2103019.0 | 37.7546629917484 | -122.43233934232599 | (37.7546629917484, -122.432339342326) | ||||
| 83723 | 83723 | 88533 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 55 Cervantes Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2008 12:00:00 AM | 3x3 | Permit Number 51490 | 6001717.8 | 2120796.9 | 37.8034000766729 | -122.438275302167 | (37.8034000766729, -122.438275302167) | |||
| 84654 | 84654 | 115910 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 867 HAYES ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003721.0 | 2110697.0 | 37.7757820445063 | -122.430622023399 | (37.7757820445063, -122.430622023399) | ||||||
| 85658 | 85658 | 96467 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
| 87455 | 87455 | 94559 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1652 12th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53733 | 5992517.8 | 2104198.3 | 37.7572972894341 | -122.468903351171 | (37.7572972894341, -122.468903351171) | ||
| 89325 | 89325 | 96464 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
| 101604 | 101604 | 108440 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 105 Lake St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5995179.45913 | 2114890.0759 | 37.786807513731105 | -122.46047306430201 | (37.7868075137311, -122.460473064302) | ||||
| 101631 | 101631 | 94927 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 325 Sanchez St | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/07/2010 12:00:00 AM | 3x3 | Permit Number 53976 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||
| 103701 | 103701 | 96466 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
| 111496 | 111496 | 108667 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 743 45th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773175 | 5981956.75596 | 2110691.0447299997 | 37.7745086716833 | -122.50590830698098 | (37.7745086716833, -122.505908306981) | |
| 114928 | 114928 | 108439 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 105 Lake St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5995179.45913 | 2114890.0759 | 37.786807513731105 | -122.46047306430201 | (37.7868075137311, -122.460473064302) | ||||
| 115356 | 115356 | 106044 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 415 DEWEY BLVD | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5995172.1 | 2100351.0 | 37.7468865723154 | -122.45944518004801 | (37.7468865723154, -122.459445180048) | ||||||
| 115707 | 115707 | 96469 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
| 120725 | 120725 | 96465 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
| 123887 | 123887 | 87142 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 54 Homestead St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50130 | 6000955.0 | 2101398.0 | 37.7500921913505 | -122.439523535984 | (37.7500921913505, -122.439523535984) | |||
| 124890 | 124890 | 96470 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
| 139065 | 139065 | 87822 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2274 44th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50715 | 5982710.3 | 2099649.4 | 37.744235769489 | -122.502484303694 | (37.744235769489, -122.502484303694) | |||
| 142217 | 142217 | 108441 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 105 Lake St | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773769 | 5995179.45913 | 2114890.0759 | 37.786807513731105 | -122.46047306430201 | (37.7868075137311, -122.460473064302) | |||
| 144888 | 144888 | 96468 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
| 167585 | 167585 | 88391 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 278 22nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51369 | 5989038.05439 | 2113475.60189 | 37.7825685533271 | -122.48161700200501 | (37.7825685533271, -122.481617002005) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |
| 2187 | 2187 | 47144 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3240 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780028 | 5998645.601919999 | 2116582.6217400003 | 37.7916535861885 | -122.448603018129 | (37.7916535861885, -122.448603018129) | |
| 2241 | 2241 | 193105 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1649 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 10/28/1996 12:00:00 AM | 10 | Width 5ft | 6014582.89152 | 2095437.7386599998 | 37.734492738953 | -122.39198038730301 | (37.734492738953, -122.391980387303) | ||
| 2257 | 2257 | 229627 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 3662 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008456.11159 | 2097816.22885 | 37.7406815009641 | -122.41333091228701 | (37.7406815009641, -122.413330912287) | |||
| 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) | |||
| 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) | ||
| 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) | |
| 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) |
| 3021 | 3021 | 230623 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1189 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 780105 | 6003227.47781 | 2101395.97858 | 37.7502157130929 | -122.431665039223 | (37.7502157130929, -122.431665039223) | |
| 3365 | 3365 | 229966 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 278 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 17 | Width 3ft | Permit Number 18733 | 6004468.47248 | 2096814.7875400002 | 37.7377070787211 | -122.42704734426 | (37.7377070787211, -122.42704734426) | |
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||||
| 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) | |
| 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) | ||||
| 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) | |||
| 4942 | 4942 | 58811 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2049 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2014 12:00:00 AM | 3 | Permit Number 773701 | 6003239.80181 | 2118222.27779 | 37.796417281581505 | -122.432824322909 | (37.7964172815815, -122.432824322909) | ||
| 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) | |||
| 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) | |||
| 5435 | 5435 | 33143 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2272 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 14 | 4x4 | Permit Number 37369 | 6002130.31107 | 2118463.23451 | 37.7970158973151 | -122.43668064819401 | (37.7970158973151, -122.436680648194) |
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 5915 | 5915 | 84945 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1812 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49349 | 6003466.4043 | 2115034.3792 | 37.7876769759783 | -122.431812496651 | (37.7876769759783, -122.431812496651) | |
| 6031 | 6031 | 27339 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 640 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6004290.4577 | 2110500.9764 | 37.7752760561488 | -122.428638148774 | (37.7752760561488, -122.428638148774) | |||
| 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) | |||
| 6118 | 6118 | 98490 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1815 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773915 | 5999966.14399 | 2115303.99268 | 37.788218224545005 | -122.443942059503 | (37.788218224545, -122.443942059503) | |
| 6146 | 6146 | 97674 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2619 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768452 | 5999883.3195 | 2113998.3376 | 37.7846285104726 | -122.444134760871 | (37.7846285104726, -122.444134760871) | |
| 6157 | 6157 | 117446 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1442 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778580 | 6007836.0514 | 2116543.8472700003 | 37.792068336434205 | -122.416801303441 | (37.7920683364342, -122.416801303441) | ||
| 6175 | 6175 | 18989 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2949 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 12 | 3x3 | Permit Number 49846 | 6000698.465009999 | 2115512.61265 | 37.78883278704021 | -122.44142333452 | (37.7888327870402, -122.44142333452) | |
| 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) | |||
| 6261 | 6261 | 58063 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1747 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1977 12:00:00 AM | 12 | Permit Number 17033 | 5999523.022000001 | 2114932.0979 | 37.7871718119958 | -122.445448429932 | (37.7871718119958, -122.445448429932) |
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");