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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1480 | 1480 | 251545 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 347 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6004948.0 | 2106317.0 | 37.7638250559684 | -122.426065641314 | (37.7638250559684, -122.426065641314) | ||||
| 2512 | 2512 | 178827 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 927 Brazil Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004338.08735 | 2090755.04432 | 37.7210610008535 | -122.427066663506 | (37.7210610008535, -122.427066663506) | |||
| 2517 | 2517 | 178826 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 927 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004356.8834 | 2090741.4764900003 | 37.7210248094256 | -122.427000725205 | (37.7210248094256, -122.427000725205) | |||
| 2537 | 2537 | 230348 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 280 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6004547.50076 | 2096560.5372400002 | 37.7370134334286 | -122.42675600438 | (37.7370134334286, -122.42675600438) | |||
| 5133 | 5133 | 242839 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1151 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 7ft | 6005182.8356800005 | 2101610.74761 | 37.750916060132106 | -122.424918561756 | (37.7509160601321, -122.424918561756) | |||
| 5141 | 5141 | 237496 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3927 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003620.49393 | 2101843.48933 | 37.751466742003295 | -122.430337889878 | (37.7514667420033, -122.430337889878) | |||
| 5246 | 5246 | 243453 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 73 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 4x6 | 6007416.818030001 | 2098970.61704 | 37.74379278831079 | -122.41700617529699 | (37.7437927883108, -122.417006175297) | |||
| 6833 | 6833 | 4378 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2425X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6006994.61601 | 2120672.53629 | 37.803357316535795 | -122.42000580642201 | (37.8033573165358, -122.420005806422) | |||
| 9341 | 9341 | 116840 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 636 POTRERO AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6010345.0 | 2105335.0 | 37.761432257364994 | -122.40732973919701 | (37.761432257365, -122.407329739197) | |||
| 10860 | 10860 | 104506 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 631 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 6002582.75614 | 2089515.1433 | 37.7175570910528 | -122.43304578096 | (37.7175570910528, -122.43304578096) | ||
| 12646 | 12646 | 115976 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011653.53869 | 2091254.58415 | 37.7228435956385 | -122.401814242757 | (37.7228435956385, -122.401814242757) | |||
| 17580 | 17580 | 4334 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 852 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001755.94767 | 2095865.71194 | 37.7349473777015 | -122.436357925586 | (37.7349473777015, -122.436357925586) | |||
| 19246 | 19246 | 97101 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1096@Jones Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008668.0 | 2115966.0 | 37.7905284677514 | -122.41388184826499 | (37.7905284677514, -122.413881848265) | ||||
| 21415 | 21415 | 136 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1025X 14th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6001971.14414 | 2107605.72409 | 37.767194880067294 | -122.436453906645 | (37.7671948800673, -122.436453906645) | |||
| 23545 | 23545 | 177395 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 715 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001937.656140001 | 2089768.77997 | 37.718216907458704 | -122.435293726344 | (37.7182169074587, -122.435293726344) | |||
| 23594 | 23594 | 230297 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1171 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008685.11737 | 2101744.284 | 37.7514799242568 | -122.412816735721 | (37.7514799242568, -122.412816735721) | |||
| 23977 | 23977 | 177421 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 0 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001079.38248 | 2091791.86287 | 37.7237230579705 | -122.438405269984 | (37.7237230579705, -122.438405269984) | |||
| 24356 | 24356 | 123622 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 111 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995179.48554 | 2114830.2995 | 37.786643385410706 | -122.460468639914 | (37.7866433854107, -122.460468639914) | |||
| 24569 | 24569 | 230346 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1801 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004582.48938 | 2098325.9035400003 | 37.74186270650671 | -122.426760715042 | (37.7418627065067, -122.426760715042) | |||
| 25024 | 25024 | 208840 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1350 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5995903.3540199995 | 2092975.62657 | 37.7266776159651 | -122.456383367909 | (37.7266776159651, -122.456383367909) | |||
| 26519 | 26519 | 115980 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011593.71434 | 2091235.60939 | 37.722788156028706 | -122.402019710862 | (37.7227881560287, -122.402019710862) | |||
| 27017 | 27017 | 230320 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 469 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002876.4268 | 2099458.33871 | 37.7448755037027 | -122.432740595108 | (37.7448755037027, -122.432740595108) | |||
| 27217 | 27217 | 230322 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 4089 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6003345.458190001 | 2100655.86235 | 37.7481902141138 | -122.43120423378299 | (37.7481902141138, -122.431204233783) | |||
| 28385 | 28385 | 230289 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3798 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6005260.07773 | 2101390.67485 | 37.750316153870294 | -122.424635797817 | (37.7503161538703, -122.424635797817) | |||
| 28727 | 28727 | 177449 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 324 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001907.3749400005 | 2086972.3844599999 | 37.7105369040276 | -122.43519848992901 | (37.7105369040276, -122.435198489929) | |||
| 29464 | 29464 | 230344 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1801 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004583.81865 | 2098292.85658 | 37.7417720422523 | -122.426753765994 | (37.7417720422523, -122.426753765994) | |||
| 30570 | 30570 | 193337 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1270 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015308.479069999 | 2102559.27559 | 37.7540872603324 | -122.389969077812 | (37.7540872603324, -122.389969077812) | |||
| 31120 | 31120 | 131005 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1109 Sansome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011966.28047 | 2119507.31076 | 37.8004367394276 | -122.40271908303001 | (37.8004367394276, -122.40271908303) | |||
| 31130 | 31130 | 177416 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 538 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002518.22292 | 2090772.4099400002 | 37.721005605292504 | -122.433358634398 | (37.7210056052925, -122.433358634398) | |||
| 32597 | 32597 | 130988 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008672.99088 | 2115994.19666 | 37.7906061691929 | -122.41386657548 | (37.7906061691929, -122.41386657548) | |||
| 32841 | 32841 | 193369 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 262 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6013943.1918 | 2116180.78279 | 37.791413056208704 | -122.39564492587601 | (37.7914130562087, -122.395644925876) | |||
| 33296 | 33296 | 110565 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 135 Theresa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x9 | 6002103.512680001 | 2093689.48997 | 37.728991712774295 | -122.43500068223301 | (37.7289917127743, -122.435000682233) | |||
| 33482 | 33482 | 230350 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 35 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002643.63835 | 2096299.62877 | 37.7361892128574 | -122.433319865541 | (37.7361892128574, -122.433319865541) | |||
| 34070 | 34070 | 177396 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 650 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002554.32379 | 2089489.05378 | 37.7174838421787 | -122.433142195459 | (37.7174838421787, -122.433142195459) | |||
| 34177 | 34177 | 177411 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 474 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003775.47727 | 2089725.4167 | 37.7182020389599 | -122.42893807173 | (37.7182020389599, -122.42893807173) | |||
| 34364 | 34364 | 177430 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 294 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6005292.64234 | 2094059.9977799999 | 37.730189610640004 | -122.424001946647 | (37.73018961064, -122.424001946647) | |||
| 34714 | 34714 | 177431 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 268 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005673.422730001 | 2092431.0022599997 | 37.7257382372047 | -122.42256982665 | (37.7257382372047, -122.42256982665) | |||
| 34741 | 34741 | 230311 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2901 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009504.69694 | 2104506.09173 | 37.7591091969416 | -122.41017748630101 | (37.7591091969416, -122.410177486301) | |||
| 34906 | 34906 | 120793 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 559 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5989373.68445 | 2111524.6737 | 37.7772313596652 | -122.48031303988998 | (37.7772313596652, -122.48031303989) | |||
| 35331 | 35331 | 193332 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1258 Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015304.05705 | 2102667.26372 | 37.7543835276007 | -122.38999191341999 | (37.7543835276007, -122.38999191342) | |||
| 36033 | 36033 | 177437 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 93 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010115.68283 | 2091447.6223799998 | 37.72328769526371 | -122.407143912081 | (37.7232876952637, -122.407143912081) | |||
| 36370 | 36370 | 130994 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 800 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008432.69085 | 2120383.1883 | 37.8026437557674 | -122.41500878732401 | (37.8026437557674, -122.415008787324) | |||
| 36589 | 36589 | 177408 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 638 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002397.88484 | 2090069.70643 | 37.71906931008821 | -122.43372440936301 | (37.7190693100882, -122.433724409363) | |||
| 36649 | 36649 | 177403 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 688 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002695.8436900005 | 2089531.77748 | 37.7176091789075 | -122.432656076817 | (37.7176091789075, -122.432656076817) | |||
| 37388 | 37388 | 123549 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 65 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5994237.46417 | 2115165.09446 | 37.7875084040974 | -122.46375209006099 | (37.7875084040974, -122.463752090061) | |||
| 37460 | 37460 | 230298 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 613 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009857.38844 | 2105338.70025 | 37.761415114429795 | -122.409016453452 | (37.7614151144298, -122.409016453452) | |||
| 37487 | 37487 | 177439 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 79 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010188.86492 | 2091471.00105 | 37.7233559834822 | -122.406892581232 | (37.7233559834822, -122.406892581232) | |||
| 37514 | 37514 | 193348 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2501 18th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6010227.27367 | 2105486.95448 | 37.7618429003376 | -122.407747622459 | (37.7618429003376, -122.407747622459) | |||
| 38082 | 38082 | 131000 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 937 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007889.3393 | 2120258.1981200003 | 37.8022700164033 | -122.416880201885 | (37.8022700164033, -122.416880201885) | |||
| 38105 | 38105 | 177410 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 470 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003782.11139 | 2089736.37793 | 37.718232511606296 | -122.428915921448 | (37.7182325116063, -122.428915921448) | |||
| 38343 | 38343 | 122390 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1958 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x2 | 5991007.0 | 2102078.0 | 37.7513881006776 | -122.47397354599501 | (37.7513881006776, -122.473973545995) | |||
| 38961 | 38961 | 230341 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 65 Chenery St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004909.36728 | 2097888.2006599996 | 37.7406793497697 | -122.425599332346 | (37.7406793497697, -122.425599332346) | |||
| 39201 | 39201 | 177424 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 85 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000559.946819999 | 2092109.10715 | 37.7245645787726 | -122.440223605655 | (37.7245645787726, -122.440223605655) | |||
| 39226 | 39226 | 230287 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3798 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6005284.60936 | 2101393.03847 | 37.750324029253505 | -122.42455113382299 | (37.7503240292535, -122.424551133823) | |||
| 39423 | 39423 | 193355 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 60 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013990.6766 | 2116456.52969 | 37.792172834057496 | -122.39549995516701 | (37.7921728340575, -122.395499955167) | |||
| 39564 | 39564 | 120406 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 619 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5988769.80583 | 2111094.18017 | 37.7760142347438 | -122.48237047472901 | (37.7760142347438, -122.482370474729) | |||
| 40529 | 40529 | 230283 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 626 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010353.7895 | 2105370.3020900004 | 37.761529680867 | -122.40730182853201 | (37.761529680867, -122.407301828532) | |||
| 41960 | 41960 | 177441 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 71 Karen Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010258.66598 | 2091491.8701799999 | 37.7234171913236 | -122.406652760812 | (37.7234171913236, -122.406652760812) | |||
| 42139 | 42139 | 230337 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 823 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002470.86224 | 2103420.79735 | 37.7557324674964 | -122.43442621241199 | (37.7557324674964, -122.434426212412) | |||
| 43019 | 43019 | 130992 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1645 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006789.62412 | 2117015.0975 | 37.7933033592027 | -122.420455425186 | (37.7933033592027, -122.420455425186) | |||
| 43609 | 43609 | 177447 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 762 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002442.748380001 | 2087164.23323 | 37.711094066412294 | -122.433361825211 | (37.7110940664123, -122.433361825211) | |||
| 44168 | 44168 | 177405 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 688 Vienna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002677.6930599995 | 2089500.91725 | 37.71752341415829 | -122.432716611994 | (37.7175234141583, -122.432716611994) | |||
| 44551 | 44551 | 230342 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 65 Chenery St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004911.05921 | 2097907.1085200002 | 37.740731362062704 | -122.42559482765499 | (37.7407313620627, -122.425594827655) | |||
| 44581 | 44581 | 177415 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 451 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003094.686869999 | 2091098.4419099998 | 37.7219335042119 | -122.431389232421 | (37.7219335042119, -122.431389232421) | |||
| 45146 | 45146 | 177401 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 263 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003956.36283 | 2088919.05641 | 37.7159981864394 | -122.42825539008601 | (37.7159981864394, -122.428255390086) | |||
| 45211 | 45211 | 193377 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 250 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008648.26214 | 2109663.47426 | 37.773222132835706 | -122.41350420897899 | (37.7732221328357, -122.413504208979) | |||
| 45642 | 45642 | 131006 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 25 Joice St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010297.06637 | 2116294.60935 | 37.7915221044126 | -122.40826853856599 | (37.7915221044126, -122.408268538566) | |||
| 46226 | 46226 | 230288 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3798 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6005272.34355 | 2101391.85682 | 37.7503200920091 | -122.424593465816 | (37.7503200920091, -122.424593465816) | |||
| 46349 | 46349 | 177433 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 439 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008733.06168 | 2093861.6141400002 | 37.7298385306021 | -122.412093908309 | (37.7298385306021, -122.412093908309) | |||
| 47177 | 47177 | 177448 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1022 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001291.58576 | 2086844.2282099999 | 37.7101500273691 | -122.437317616421 | (37.7101500273691, -122.437317616421) | |||
| 48031 | 48031 | 130967 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 213 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998523.7164 | 2115638.03819 | 37.7890530400256 | -122.448956666639 | (37.7890530400256, -122.448956666639) | |||
| 48337 | 48337 | 230332 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 73 Leese St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005526.20735 | 2096295.99594 | 37.736342348511 | -122.423353372654 | (37.736342348511, -122.423353372654) | |||
| 48794 | 48794 | 193328 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6015574.56777 | 2102562.74505 | 37.7541115402303 | -122.389049112743 | (37.7541115402303, -122.389049112743) | |||
| 49507 | 49507 | 230314 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 31 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009412.86003 | 2099877.13325 | 37.7463939631256 | -122.41016829345301 | (37.7463939631256, -122.410168293453) | |||
| 49891 | 49891 | 177413 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 518 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003506.69699 | 2090312.38662 | 37.719798511885706 | -122.42990897621401 | (37.7197985118857, -122.429908976214) | |||
| 50219 | 50219 | 230323 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 12 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004674.70805 | 2103511.60917 | 37.7561066672951 | -122.42681107348601 | (37.7561066672951, -122.426811073486) | |||
| 51534 | 51534 | 110564 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 135 Theresa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x9 | 6002092.75194 | 2093699.4633900002 | 37.7290184865087 | -122.43503859588199 | (37.7290184865087, -122.435038595882) | |||
| 51630 | 51630 | 193333 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1258 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015305.27356 | 2102653.19148 | 37.7543449556813 | -122.389986723422 | (37.7543449556813, -122.389986723422) | |||
| 52684 | 52684 | 131002 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 937 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007919.06293 | 2120264.13988 | 37.802288002842396 | -122.416777764577 | (37.8022880028424, -122.416777764577) | |||
| 52885 | 52885 | 120377 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 101 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5987995.9910699995 | 2115194.27342 | 37.7872268871617 | -122.485348201277 | (37.7872268871617, -122.485348201277) | |||
| 53029 | 53029 | 118073 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 449 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985293.2738 | 2112845.5441799997 | 37.7806201339604 | -122.49452567585199 | (37.7806201339604, -122.494525675852) | |||
| 53332 | 53332 | 131003 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1109 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011959.67514 | 2119544.33527 | 37.8005380309676 | -122.40274454551901 | (37.8005380309676, -122.402744545519) | |||
| 53678 | 53678 | 193364 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 260 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6013990.639330001 | 2116225.4508599997 | 37.791538343481605 | -122.395483887876 | (37.7915383434816, -122.395483887876) | |||
| 53694 | 53694 | 109906 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1415 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x3 | 6008272.88194 | 2109795.90835 | 37.773564680997296 | -122.41481207772199 | (37.7735646809973, -122.414812077722) | |||
| 54081 | 54081 | 193373 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 61 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6013783.27133 | 2116255.65231 | 37.7916097334637 | -122.39620350109699 | (37.7916097334637, -122.396203501097) | |||
| 54260 | 54260 | 177419 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 100 Capistrano Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001443.854169999 | 2093560.7227900003 | 37.7286006695825 | -122.437271950666 | (37.7286006695825, -122.437271950666) | |||
| 54394 | 54394 | 193368 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 262 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6013947.275280001 | 2116186.44855 | 37.79142884020779 | -122.395631194149 | (37.7914288402078, -122.395631194149) | |||
| 54472 | 54472 | 230304 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3689 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6005034.41688 | 2104845.09352 | 37.7597884333033 | -122.42566198362101 | (37.7597884333033, -122.425661983621) | |||
| 54565 | 54565 | 177434 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 131 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010258.4147 | 2094004.87757 | 37.7303173692474 | -122.40683065573099 | (37.7303173692474, -122.406830655731) | |||
| 54895 | 54895 | 193335 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1260 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015305.18557 | 2102619.11987 | 37.7542513973846 | -122.389984647787 | (37.7542513973846, -122.389984647787) | |||
| 55341 | 55341 | 130999 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2009 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008124.35834 | 2119571.24818 | 37.8003970406522 | -122.41601824307101 | (37.8003970406522, -122.416018243071) | |||
| 56377 | 56377 | 193374 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 778 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6008975.96564 | 2110229.86919 | 37.7747957152898 | -122.412410677425 | (37.7747957152898, -122.412410677425) | |||
| 56518 | 56518 | 177443 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 63 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010306.59987 | 2091507.00491 | 37.7234614298874 | -122.40648812732799 | (37.7234614298874, -122.406488127328) | |||
| 57463 | 57463 | 193356 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 60 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6014000.33626 | 2116445.25726 | 37.7921424198756 | -122.395465742269 | (37.7921424198756, -122.395465742269) | |||
| 57558 | 57558 | 230352 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 136 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002654.78135 | 2096839.9013099999 | 37.7376733091617 | -122.433319933881 | (37.7376733091617, -122.433319933881) | |||
| 57885 | 57885 | 230313 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 968 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010194.52879 | 2103588.6082900004 | 37.756628635618604 | -122.40772701540399 | (37.7566286356186, -122.407727015404) | |||
| 59077 | 59077 | 118718 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 818 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982331.02075 | 2110159.51383 | 37.7730712650544 | -122.504574285424 | (37.7730712650544, -122.504574285424) | |||
| 59160 | 59160 | 230296 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3500 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006123.351530001 | 2104947.42015 | 37.7601308699707 | -122.421903157405 | (37.7601308699707, -122.421903157405) | |||
| 59718 | 59718 | 193339 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1278 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015309.7122 | 2102531.15535 | 37.7540101165005 | -122.389962849121 | (37.7540101165005, -122.389962849121) | |||
| 59745 | 59745 | 208853 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 54 Martha Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6000650.73977 | 2095621.13276 | 37.734212959854396 | -122.440161475975 | (37.7342129598544, -122.440161475975) |
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");