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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 47863 | 47863 | 177393 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1657 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6006855.18138 | 2087491.9955900002 | 37.7122433757141 | -122.41813457086599 | (37.7122433757141, -122.418134570866) | |||
| 60469 | 60469 | 80737 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 186 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 1 | 6000043.5525400005 | 2087718.3093599998 | 37.7124790304587 | -122.44169374357 | (37.7124790304587, -122.44169374357) | ||
| 131019 | 131019 | 177392 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1654 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6006773.14965 | 2087593.0806 | 37.7125163163365 | -122.41842526053101 | (37.7125163163365, -122.418425260531) | |||
| 53993 | 53993 | 177425 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1764 Cayuga Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 5997936.35064 | 2088551.93116 | 37.7146476772225 | -122.44903686276301 | (37.7146476772225, -122.449036862763) | |||
| 146559 | 146559 | 208848 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 281 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994210.24416 | 2088699.7294 | 37.7148396860693 | -122.46192642387501 | (37.7148396860693, -122.461926423875) | |||
| 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) | |||
| 187349 | 187349 | 177394 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 833 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003056.79218 | 2089215.7831299999 | 37.716761991458604 | -122.431385897768 | (37.7167619914586, -122.431385897768) | |||
| 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) | ||
| 64511 | 64511 | 177400 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1112 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003994.8137 | 2089359.3172799998 | 37.7172092225078 | -122.428153843121 | (37.7172092225078, -122.428153843121) | |||
| 160548 | 160548 | 177398 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 650 France Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6002590.58454 | 2089466.88592 | 37.7174250310079 | -122.433015275935 | (37.7174250310079, -122.433015275935) | |||
| 62272 | 62272 | 177397 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 650 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6002573.73742 | 2089477.3552599999 | 37.717452821874105 | -122.433074256169 | (37.7174528218741, -122.433074256169) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 121083 | 121083 | 177404 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 688 Vienna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002686.6432 | 2089516.6103299998 | 37.717567011481705 | -122.432686795869 | (37.7175670114817, -122.432686795869) | |||
| 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) | |||
| 168525 | 168525 | 177402 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 670 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002753.398469999 | 2089622.73249 | 37.7178621851574 | -122.43246362908701 | (37.7178621851574, -122.432463629087) | |||
| 153491 | 153491 | 177399 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 908 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6003531.7567 | 2089652.07353 | 37.7179868563895 | -122.429775281212 | (37.7179868563895, -122.429775281212) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 173639 | 173639 | 177414 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 575 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003352.2884599995 | 2089985.19468 | 37.7188913693287 | -122.430419379246 | (37.7188913693287, -122.430419379246) | |||
| 63292 | 63292 | 177412 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 539 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003697.3420400005 | 2090030.0653 | 37.719034114214004 | -122.42922986306401 | (37.719034114214, -122.429229863064) | |||
| 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) | |||
| 171641 | 171641 | 177409 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 659 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002137.168430001 | 2090084.38724 | 37.719094822944996 | -122.434626653316 | (37.719094822945, -122.434626653316) | |||
| 173626 | 173626 | 177407 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 626 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002434.78266 | 2090132.2743 | 37.7192432011957 | -122.433601337127 | (37.7192432011957, -122.433601337127) | |||
| 71769 | 71769 | 177406 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 618 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002461.15734 | 2090172.80832 | 37.7193559950662 | -122.433513065093 | (37.7193559950662, -122.433513065093) | |||
| 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) | |||
| 29927 | 29927 | 83659 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 559 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 6 | 6001685.54257 | 2090383.4533900002 | 37.7198903425557 | -122.436209138162 | (37.7198903425557, -122.436209138162) | ||
| 71293 | 71293 | 208847 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 422 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995505.44933 | 2090582.5246599999 | 37.7200838784427 | -122.457585828931 | (37.7200838784427, -122.457585828931) | |||
| 25005 | 25005 | 177418 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 857 Dartmouth St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6009516.77243 | 2090302.7647799999 | 37.720110619797104 | -122.409133494811 | (37.7201106197971, -122.409133494811) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 60143 | 60143 | 72252 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 531 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 1 | 6002585.93283 | 2090796.9641 | 37.7210768666757 | -122.43312633500601 | (37.7210768666757, -122.433126335006) | ||
| 3940 | 3940 | 179536 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1880 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 10:42:00 AM | 3 | Width 3ft | 6000969.55481 | 2091096.3953200001 | 37.7218072142025 | -122.438735113438 | (37.7218072142025, -122.438735113438) | ||
| 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) | |||
| 174665 | 174665 | 177435 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 99 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010088.68836 | 2091439.3296700001 | 37.72326341446679 | -122.407236642978 | (37.7232634144668, -122.407236642978) | |||
| 75167 | 75167 | 177436 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 99 Karen Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010107.2934 | 2091444.47715 | 37.7232785896114 | -122.40717269128099 | (37.7232785896114, -122.407172691281) | |||
| 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) | |||
| 176355 | 176355 | 177438 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 83 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010165.7616 | 2091462.99776 | 37.723332715313894 | -122.406971881647 | (37.7233327153139, -122.406971881647) | |||
| 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) | |||
| 149083 | 149083 | 177440 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 71 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010238.57006 | 2091486.2001099999 | 37.7234004981218 | -122.406721829644 | (37.7234004981218, -122.406721829644) | |||
| 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) | |||
| 160433 | 160433 | 177442 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 67 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010267.21749 | 2091493.9064200001 | 37.723423260860706 | -122.40662334309799 | (37.7234232608607, -122.406623343098) | |||
| 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) | |||
| 129834 | 129834 | 208845 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 277 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995629.339 | 2091829.15928 | 37.7235139565963 | -122.457247722532 | (37.7235139565963, -122.457247722532) | |||
| 161633 | 161633 | 177444 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 15 Karen Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6010486.61044 | 2091547.46792 | 37.7235826018289 | -122.40586870937 | (37.7235826018289, -122.40586870937) | |||
| 154138 | 154138 | 177445 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 15 Karen Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6010506.33995 | 2091553.32971 | 37.723599800462296 | -122.405800920297 | (37.7235998004623, -122.405800920297) | |||
| 76787 | 76787 | 208846 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 36 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995163.31564 | 2091909.32906 | 37.7237073072365 | -122.45886447241999 | (37.7237073072365, -122.45886447242) | |||
| 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) | |||
| 151961 | 151961 | 177422 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 0 Santa Ynez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6001061.39064 | 2091803.12496 | 37.7237529577069 | -122.438468271097 | (37.7237529577069, -122.438468271097) | |||
| 129880 | 129880 | 177446 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 323 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6003320.62443 | 2091964.27953 | 37.7243237043587 | -122.43066997803999 | (37.7243237043587, -122.43066997804) | |||
| 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) | |||
| 155510 | 155510 | 177423 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 270 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999939.77666 | 2092147.8586099998 | 37.7246356530907 | -122.44237022711701 | (37.7246356530907, -122.442370227117) | |||
| 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) | |||
| 175968 | 175968 | 177426 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 125 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6003455.72001 | 2092686.0671599999 | 37.7263132250654 | -122.430254442684 | (37.7263132250654, -122.430254442684) | |||
| 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) | |||
| 26535 | 26535 | 177420 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 121 Cotter St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6001985.26237 | 2093449.7289900002 | 37.728326668619296 | -122.435392337892 | (37.7283266686193, -122.435392337892) | |||
| 181142 | 181142 | 208857 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1 Gennessee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5997408.7613699995 | 2093610.5667299998 | 37.7285073190505 | -122.451225020336 | (37.7285073190505, -122.451225020336) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 172336 | 172336 | 110563 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 135 Theresa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x9 | 6002082.973999999 | 2093709.6113599997 | 37.729045795311706 | -122.43507312442499 | (37.7290457953117, -122.435073124425) | |||
| 177264 | 177264 | 110562 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 135 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x9 | 6002071.86629 | 2093721.73728 | 37.729078459595605 | -122.43511239152001 | (37.7290784595956, -122.43511239152) | |||
| 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) | |||
| 151949 | 151949 | 177427 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 145 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004319.85704 | 2094053.89798 | 37.7301178924245 | -122.427364559453 | (37.7301178924245, -122.427364559453) | |||
| 171243 | 171243 | 177432 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 66 Gladstone Dr | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6006350.82649 | 2094014.80407 | 37.730125204807 | -122.420340452271 | (37.730125204807, -122.420340452271) | |||
| 185429 | 185429 | 177428 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 274 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005170.17326 | 2094055.30176 | 37.7301698012868 | -122.42442500480499 | (37.7301698012868, -122.424425004805) | |||
| 74564 | 74564 | 177429 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 278 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005195.233080001 | 2094056.1980299999 | 37.7301736773527 | -122.42433843338699 | (37.7301736773527, -122.424338433387) | |||
| 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) | |||
| 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) | |||
| 181425 | 181425 | 193353 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 75 Latona St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6014356.71381 | 2094130.9148900001 | 37.730891907436295 | -122.392670976684 | (37.7308919074363, -122.392670976684) | |||
| 173077 | 173077 | 193354 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 75 Latona St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014363.50892 | 2094164.90475 | 37.7309856140862 | -122.392649861509 | (37.7309856140862, -122.392649861509) | |||
| 182305 | 182305 | 208844 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 335 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 5995829.06738 | 2094841.15023 | 37.731795629859796 | -122.45677503524901 | (37.7317956298598, -122.456775035249) | |||
| 29022 | 29022 | 208856 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 331 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5999876.46994 | 2094937.06877 | 37.732290569037104 | -122.44278926080901 | (37.7322905690371, -122.442789260809) | |||
| 39525 | 39525 | 208855 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 358 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5999047.687609999 | 2095262.2243 | 37.7331360864596 | -122.445677914709 | (37.7331360864596, -122.445677914709) | |||
| 165587 | 165587 | 208854 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 403 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000738.2575199995 | 2095246.2380099997 | 37.7331885682037 | -122.439832030035 | (37.7331885682037, -122.439832030035) | |||
| 141933 | 141933 | 99876 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1295X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6003506.1 | 2095452.4 | 37.733911806121895 | -122.43027755668899 | (37.7339118061219, -122.430277556689) | |||
| 82995 | 82995 | 99875 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1301X San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6003616.3 | 2095455.7 | 37.733927108519204 | -122.429896797189 | (37.7339271085192, -122.429896797189) | |||
| 185939 | 185939 | 193350 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1752 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6014471.5284 | 2095248.21375 | 37.7339661589078 | -122.39235215802799 | (37.7339661589078, -122.392352158028) | |||
| 174129 | 174129 | 193351 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1752 Quesada Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6014452.02014 | 2095263.45344 | 37.734006920685204 | -122.392420670182 | (37.7340069206852, -122.392420670182) | |||
| 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) | |||
| 161888 | 161888 | 217796 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 21 Sloat Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5991264.945169999 | 2095927.55542 | 37.7345154980788 | -122.472633170284 | (37.7345154980788, -122.472633170284) | |||
| 151066 | 151066 | 230349 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 222 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001969.40377 | 2096197.83075 | 37.735871425709995 | -122.43564368671801 | (37.73587142571, -122.435643686718) | |||
| 142088 | 142088 | 114593 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1 BRADFORD ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | 6x9 | 6009441.0 | 2096050.0 | 37.735887066073104 | -122.409800886333 | (37.7358870660731, -122.409800886333) | |||
| 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) | |||
| 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) | |||
| 65368 | 65368 | 230328 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 518 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6008539.17549 | 2096369.5184099998 | 37.7367138134929 | -122.41294144560601 | (37.7367138134929, -122.412941445606) | |||
| 61328 | 61328 | 193352 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1707 McKinnon Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014777.576230001 | 2096343.32459 | 37.736990099615 | -122.39137057769199 | (37.736990099615, -122.391370577692) | |||
| 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) | |||
| 165815 | 165815 | 230351 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 132 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002667.4556599995 | 2096824.4771 | 37.737631676855294 | -122.43327501094299 | (37.7376316768553, -122.433275010943) | |||
| 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) | |||
| 129514 | 129514 | 230353 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 210 Moffitt St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002369.42033 | 2097177.7522 | 37.7385847765781 | -122.43433070979401 | (37.7385847765781, -122.434330709794) | |||
| 67518 | 67518 | 230357 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 137 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004642.1298400005 | 2097534.3319200003 | 37.739692602838296 | -122.426498147168 | (37.7396926028383, -122.426498147168) | |||
| 172322 | 172322 | 230356 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 137 Randall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004658.9023 | 2097536.10277 | 37.73969841334279 | -122.42644028119 | (37.7396984133428, -122.42644028119) | |||
| 176498 | 176498 | 230339 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 65 Chenery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004912.08615 | 2097855.70847 | 37.7405902872201 | -122.425587619594 | (37.7405902872201, -122.425587619594) |
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");