Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH, PlotSize
| 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) | |||
| 165176 | 165176 | 114986 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1028 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 1 | Permit Number 770492 | 6001259.4385 | 2086848.65908 | 37.7101603659725 | -122.437429040618 | (37.7101603659725, -122.437429040618) | ||
| 109947 | 109947 | 120109 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 555 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2016 12:00:00 AM | 3 | 3x3 | 5997970.0 | 2087042.0 | 37.7105036758619 | -122.44881186315901 | (37.7105036758619, -122.448811863159) | ||
| 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) | |||
| 97637 | 97637 | 83771 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 924 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50981 | 6009720.30690757 | 2087000.33290755 | 37.7110542204407 | -122.408197148869 | (37.7110542204407, -122.408197148869) | |
| 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) | |||
| 156758 | 156758 | 69419 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 168 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 9 | Permit Number 33524 | 6001328.44378 | 2087365.87339 | 37.7115844451475 | -122.437227553813 | (37.7115844451475, -122.437227553813) | |
| 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) | |||
| 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) | ||
| 82889 | 82889 | 114908 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 281 LOBOS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994225.0 | 2088676.0 | 37.714775380268996 | -122.461873702271 | (37.714775380269, -122.461873702271) | ||||
| 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) | |||
| 69630 | 69630 | 177417 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1x Rolph St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 6000503.4246 | 2088653.73075 | 37.7150736797726 | -122.440171325345 | (37.7150736797726, -122.440171325345) | |||
| 123330 | 123330 | 84225 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1361 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50686 | 6011917.47723073 | 2088615.29524593 | 37.7156113688947 | -122.400716532679 | (37.7156113688947, -122.400716532679) | ||
| 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) | |||
| 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) | |
| 66636 | 66636 | 82354 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50649 | 6004015.90676212 | 2089097.25184538 | 37.716490841330106 | -122.428062269463 | (37.7164908413301, -122.428062269463) | ||
| 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) | |||
| 146771 | 146771 | 88351 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 700 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51333 | 6002622.22718 | 2089414.5665400003 | 37.7172831683531 | -122.432902166399 | (37.7172831683531, -122.432902166399) | |
| 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) | |||
| 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) | ||
| 11429 | 11429 | 83565 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 647 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769747 | 6003095.84203 | 2089582.30789 | 37.7177706009018 | -122.43127706988199 | (37.7177706009018, -122.431277069882) |
| 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) | |||
| 10886 | 10886 | 83673 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 618 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52311 | 6003154.7737300005 | 2089756.30482 | 37.7182516977425 | -122.43108578140499 | (37.7182516977425, -122.431085781405) | |
| 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) | |||
| 127266 | 127266 | 95734 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 626 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767481 | 6002384.8 | 2090170.7 | 37.7193458734928 | -122.43377685304199 | (37.7193458734928, -122.433776853042) | |
| 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) | |||
| 60907 | 60907 | 50426 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 250 Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773627 | 5997303.25557645 | 2090612.9654569 | 37.7202705700793 | -122.45137364778 | (37.7202705700793, -122.45137364778) | |
| 96004 | 96004 | 95123 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 75 Oneida Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54050 | 6000595.4 | 2090675.6 | 37.720630512863295 | -122.439998309146 | (37.7206305128633, -122.439998309146) | |
| 13056 | 13056 | 108448 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 90-98X Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | 6004670.84101 | 2090640.5659299998 | 37.7207654791334 | -122.42590828635599 | (37.7207654791334, -122.425908286356) | |
| 147335 | 147335 | 95762 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 417 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767499 | 6004100.3891199995 | 2090668.84671 | 37.720810876907 | -122.427882177716 | (37.720810876907, -122.427882177716) |
| 143274 | 143274 | 122379 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 466 Vernon St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/26/2016 12:00:00 AM | 3 | 3x3 | 5992521.0 | 2090937.0 | 37.7208852925782 | -122.46792773796801 | (37.7208852925782, -122.467927737968) | ||
| 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) | ||
| 139591 | 139591 | 87070 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 395 Byxbee St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 25430 | 25430 | 113267 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 83 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | 2 | Permit Number 774551 | 6012507.044369999 | 2090789.37208 | 37.7216138123142 | -122.398831200496 | (37.7216138123142, -122.398831200496) | ||
| 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) | |||
| 76764 | 76764 | 108377 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 226 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | Permit Number 773810 | 6004631.19295 | 2091083.0586299999 | 37.7219782266077 | -122.42607682199801 | (37.7219782266077, -122.426076821998) | |
| 10319 | 10319 | 109211 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 819 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773413 | 6011187.7232800005 | 2090968.5283099997 | 37.722032138266 | -122.403404362845 | (37.722032138266, -122.403404362845) | |
| 71256 | 71256 | 52791 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 955@ MOSCOW Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | 1 | Permit Number 48832 | 6004754.52241 | 2091271.3997400003 | 37.7225023397811 | -122.425663900979 | (37.7225023397811, -122.425663900979) | ||
| 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) | |||
| 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) | |||
| 110088 | 110088 | 114688 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 231 Dwight St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 774702 | 6010865.8 | 2091429.3 | 37.723279336417704 | -122.404549596707 | (37.7232793364177, -122.404549596707) | |||
| 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) | |||
| 171865 | 171865 | 114755 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 89 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777135 | 6010155.72688 | 2091460.8073900002 | 37.723326139481294 | -122.407006415641 | (37.7233261394813, -122.407006415641) | ||
| 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) | |||
| 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) | |||
| 85604 | 85604 | 115256 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 277 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 773180 | 5995612.8 | 2091840.6 | 37.723544420177205 | -122.457305721784 | (37.7235444201772, -122.457305721784) | |||
| 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) | ||
| 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) | |||
| 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) | |
| 78911 | 78911 | 95113 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 887 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54041 | 6001057.0 | 2091844.3 | 37.7238657652599 | -122.43848639746099 | (37.7238657652599, -122.438486397461) | |
| 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) | |||
| 145458 | 145458 | 108842 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 420 Woolsey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010509.54502 | 2091864.19266 | 37.7244535448266 | -122.405811727659 | (37.7244535448266, -122.405811727659) | |
| 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) | |||
| 72897 | 72897 | 43147 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 249 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767437 | 6005979.23995 | 2092615.6379200001 | 37.7262624547464 | -122.421525745221 | (37.7262624547464, -122.421525745221) |
| 153325 | 153325 | 43146 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 243 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774635 | 6005976.40354 | 2092622.5546099998 | 37.7262812865364 | -122.421536041574 | (37.7262812865364, -122.421536041574) | |
| 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) | |||
| 180774 | 180774 | 43160 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 261 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767438 | 6006282.82959 | 2092642.1581700002 | 37.7263523869376 | -122.42047813126499 | (37.7263523869376, -122.420478131265) |
| 22989 | 22989 | 37859 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 127 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | 6 | Permit Number 47618 | 6004006.380580001 | 2093054.46604 | 37.7273559413142 | -122.42837708183399 | (37.7273559413142, -122.428377081834) | |
| 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) | |||
| 181883 | 181883 | 62233 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 120 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | 3 | Permit Number 22359 | 6001435.36273 | 2093541.49048 | 37.728547379336206 | -122.437299929461 | (37.7285473793362, -122.437299929461) | |
| 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) |
| 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) | |||
| 10311 | 10311 | 27188 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 258 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 5 | 2X3 | 6002908.14927 | 2093727.2885 | 37.729141154025506 | -122.43222169348999 | (37.7291411540255, -122.43222169349) | ||
| 11066 | 11066 | 109684 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 250 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773450 | 6005044.41141 | 2093779.7607 | 37.729406123972296 | -122.42484018495001 | (37.7294061239723, -122.42484018495) |
| 12772 | 12772 | 109685 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 266 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775044 | 6005143.37702 | 2093783.4945099999 | 37.7294219655289 | -122.424498316649 | (37.7294219655289, -122.424498316649) |
| 123675 | 123675 | 113269 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1328 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | Permit Number 774425 | 6016744.9 | 2093624.7 | 37.7296342890732 | -122.384379303046 | (37.7296342890732, -122.384379303046) | |||
| 97155 | 97155 | 52415 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 445 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50993 | 5997805.99655674 | 2094075.37872241 | 37.729806319232004 | -122.44988524851401 | (37.729806319232, -122.449885248514) | ||
| 11730 | 11730 | 108558 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 222 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773717 | 6001903.01628 | 2093995.18892 | 37.729819706015704 | -122.43571567476101 | (37.7298197060157, -122.435715674761) |
| 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) | |||
| 164563 | 164563 | 61691 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 61 Lucy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 4 | Permit Number 31258 | 6014147.06906 | 2093799.2682599998 | 37.7299696274983 | -122.393372558494 | (37.7299696274983, -122.393372558494) | |
| 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) | |||
| 12835 | 12835 | 109714 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 250 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772039 | 6005020.03097 | 2094315.2579700002 | 37.7308751035831 | -122.424962554792 | (37.7308751035831, -122.424962554792) |
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");