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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 31482 | 31482 | 53932 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 140 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1972 12:00:00 AM | 1 | Permit Number 9646 | 5993064.176969999 | 2114524.47346 | 37.785681755762894 | -122.46776478269899 | (37.7856817557629, -122.467764782699) | ||
| 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) | |||
| 33867 | 33867 | 70607 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1256 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 9 | 6007485.00571 | 2115457.39575 | 37.78906545695621 | -122.41793887748301 | (37.7890654569562, -122.417938877483) | ||
| 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) | |||
| 34611 | 34611 | 45681 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 440 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2001 12:00:00 AM | 8 | Permit Number 44368 | 6014041.208930001 | 2105068.9613799998 | 37.760907951647795 | -122.39452736264099 | (37.7609079516478, -122.394527362641) | ||
| 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) | |||
| 35817 | 35817 | 83433 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 760 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 4 | 6000998.571 | 2089370.50235 | 37.7170699516967 | -122.43851121642099 | (37.7170699516967, -122.438511216421) | ||
| 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) | |||
| 36801 | 36801 | 49512 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1928& 21st AVE Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2003 12:00:00 AM | 4 | Permit Number 46417 | 5989493.41802 | 2113376.93915 | 37.7823241210106 | -122.480034435471 | (37.7823241210106, -122.480034435471) | ||
| 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) | |||
| 38918 | 38918 | 87076 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2565 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50014 | 6006601.66741 | 2120051.34913 | 37.8016295480248 | -122.421321483111 | (37.8016295480248, -122.421321483111) | |
| 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) | |||
| 40091 | 40091 | 95676 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 232 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767428 | 6010063.65694 | 2093465.1071400002 | 37.7288243741431 | -122.407465923318 | (37.7288243741431, -122.407465923318) |
| 40468 | 40468 | 114753 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 10 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777133 | 6010495.976919999 | 2091580.43732 | 37.723673652787596 | -122.40583865223101 | (37.7236736527876, -122.405838652231) | ||
| 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) | |||
| 41605 | 41605 | 30800 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 199 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 4 | Permit Number 34666 | 6001059.22701 | 2095245.3674599999 | 37.7332044430184 | -122.438722291799 | (37.7332044430184, -122.438722291799) | |
| 41811 | 41811 | 108815 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 474 Munich St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774652 | 6003779.44726 | 2089723.3814299998 | 37.7181966752665 | -122.42892420414499 | (37.7181966752665, -122.428924204145) | |
| 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) | |||
| 42297 | 42297 | 80634 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 577 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 1 | 6013018.0309 | 2104352.7115 | 37.758884352052604 | -122.398015861652 | (37.7588843520526, -122.398015861652) | ||
| 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) | |||
| 43802 | 43802 | 65195 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 277 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 2 | Permit Number 27179 | 6002900.88646 | 2091805.0724099998 | 37.723862768534104 | -122.432109587587 | (37.7238627685341, -122.432109587587) | |
| 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) | |||
| 45272 | 45272 | 98453 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 518 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768642 | 6014340.87186 | 2104676.4561900003 | 37.7598468721503 | -122.393463482668 | (37.7598468721503, -122.393463482668) | |
| 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) | |||
| 45916 | 45916 | 99538 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 801X Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768631 | 5999563.7 | 2111218.2 | 37.776976730821794 | -122.445040600733 | (37.7769767308218, -122.445040600733) | |
| 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) | |||
| 49119 | 49119 | 65035 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1205 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51820 | 6003879.11104946 | 2101261.18670708 | 37.7498825208731 | -122.429402039878 | (37.7498825208731, -122.429402039878) | ||
| 49125 | 49125 | 84779 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 224 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2007 12:00:00 AM | 3 | Permit No. 49287 | 6013986.61648 | 2106050.38487 | 37.7635996908854 | -122.394784908699 | (37.7635996908854, -122.394784908699) | ||
| 49439 | 49439 | 83995 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51873 | 6003949.050969999 | 2088987.2537599998 | 37.7161850277922 | -122.428285520976 | (37.7161850277922, -122.428285520976) | |
| 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) | |||
| 49969 | 49969 | 112557 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 35 DOLORES ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2015 12:00:00 AM | 3x3 | 6004913.0 | 2108042.0 | 37.7685595148495 | -122.426309519551 | (37.7685595148495, -122.426309519551) | |||
| 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) | |||
| 50948 | 50948 | 85291 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 7350 Geary Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | 2 | 4x72 | Permit Number 49578 | 5984127.30348 | 2112512.4695 | 37.779637298343 | -122.498534651264 | (37.779637298343, -122.498534651264) | ||
| 51443 | 51443 | 105800 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 207 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2014 12:00:00 AM | 3 | Permit Number 769635 | 6010004.04754 | 2087785.0667299998 | 37.713224823850005 | -122.407271751589 | (37.71322482385, -122.407271751589) | ||
| 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) | |||
| 51726 | 51726 | 51497 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 741 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50950 | 6009247.81044 | 2119754.33215 | 37.80096284371879 | -122.412143582356 | (37.8009628437188, -122.412143582356) | |
| 52436 | 52436 | 31977 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 134 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 7 | Permit Number 35376 | 5995230.64434 | 2114664.73917 | 37.7861917443429 | -122.460279644251 | (37.7861917443429, -122.460279644251) | |
| 52442 | 52442 | 59600 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1116 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 9 | Permit Number 19001 | 6015518.08801 | 2103793.04215 | 37.757486543884 | -122.389330342431 | (37.757486543884, -122.389330342431) | ||
| 52541 | 52541 | 47432 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 432 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 2 | Permit Number 45343 | 5982855.38785 | 2112869.9347900003 | 37.7805441204791 | -122.50296115463001 | (37.7805441204791, -122.50296115463) | |
| 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) | |||
| 53463 | 53463 | 47067 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 604 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2012 12:00:00 AM | 1 | Permit Number 768780 | 6004041.40702 | 2110873.30571 | 37.7762842830232 | -122.429526231047 | (37.7762842830232, -122.429526231047) | ||
| 53628 | 53628 | 34942 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 462 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1997 12:00:00 AM | 8 | Permit Number 38539 | 5995310.64413 | 2112404.55918 | 37.7799904974934 | -122.459839088006 | (37.7799904974934, -122.459839088006) | ||
| 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) | |||
| 53809 | 53809 | 98842 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 313 Maple St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2012 12:00:00 AM | 1 | Permit Number 768890 | 5996633.94495 | 2115242.03804 | 37.7878574732038 | -122.455466360678 | (37.7878574732038, -122.455466360678) | ||
| 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) | |||
| 56020 | 56020 | 30506 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3615 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1998 12:00:00 AM | 6 | Permit Number 40581 | 5997549.204530001 | 2115073.9457400003 | 37.787448412048604 | -122.45228761430599 | (37.7874484120486, -122.452287614306) | ||
| 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) | |||
| 56984 | 56984 | 38711 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2000 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2012 12:00:00 AM | 1 | Permit Number 768631 | 5999529.3553 | 2111223.7902 | 37.7769901198015 | -122.44515981121201 | (37.7769901198015, -122.445159811212) | ||
| 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) |
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");