Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23030 | 23030 | 17382 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1627 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/2015 12:00:00 AM | 1 | 3X3 | Permit Number 776412 | 6014690.32946 | 2095358.97831 | 37.7342824432881 | -122.39160343105 | (37.7342824432881, -122.39160343105) | |
| 117870 | 117870 | 17877 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2189 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3X3 | 6003478.4464424 | 2115194.6078963 | 37.7881176060092 | -122.431782277912 | (37.7881176060092, -122.431782277912) | |||
| 77021 | 77021 | 32342 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 130 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1998 12:00:00 AM | 1 | Permit Number 770451 | 6006450.269730001 | 2105316.80145 | 37.761163536302206 | -122.420798725186 | (37.7611635363022, -122.420798725186) | |
| 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) | ||
| 27791 | 27791 | 38712 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2000 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2012 12:00:00 AM | 1 | Permit Number 768631 | 5999544.5843 | 2111225.8207 | 37.7769965642688 | -122.44510727559799 | (37.7769965642688, -122.445107275598) | ||
| 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) | |
| 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) | ||
| 149654 | 149654 | 47068 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 604 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2012 12:00:00 AM | 1 | Permit Number 768780 | 6004042.80919 | 2110860.8938 | 37.7762502823647 | -122.429520495178 | (37.7762502823647, -122.429520495178) | ||
| 27994 | 27994 | 52460 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 682@ CABRILLO 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 1 | Permit Number 48571 | 5992268.12798 | 2110826.06835 | 37.775480948973396 | -122.470249439229 | (37.7754809489734, -122.470249439229) | |
| 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) | ||
| 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) | ||
| 66302 | 66302 | 61318 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1419 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/2014 12:00:00 AM | 1 | Permit Number 772899 | 6011764.55732 | 2101642.9103 | 37.751373940974204 | -122.402160470048 | (37.7513739409742, -122.402160470048) | |
| 69222 | 69222 | 68687 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 133 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2014 12:00:00 AM | 1 | 6x6 | Permit Number 771044 | 5992088.87095 | 2114507.13587 | 37.7855777876584 | -122.471137767056 | (37.7855777876584, -122.471137767056) |
| 140795 | 140795 | 70259 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 613 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2014 12:00:00 AM | 1 | 3x5 | Permit Number 771047 | 6009849.60881533 | 2105419.99624628 | 37.761637898995104 | -122.409049096462 | (37.7616378989951, -122.409049096462) | |
| 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) | ||
| 65070 | 65070 | 78191 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 680 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 1 | 6015407.71241 | 2105894.14692 | 37.7632496064147 | -122.389858829046 | (37.7632496064147, -122.389858829046) | ||
| 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) | ||
| 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) | ||
| 61056 | 61056 | 85039 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 740 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49387 | 6008855.33926 | 2110725.28618 | 37.776149243538796 | -122.41286298423901 | (37.7761492435388, -122.412862984239) | |
| 173728 | 173728 | 87489 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 496 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50390 | 5984109.09334 | 2112519.44129 | 37.7796553729161 | -122.498598162167 | (37.7796553729161, -122.498598162167) | |
| 68243 | 68243 | 87490 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 496 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50390 | 5984109.08074 | 2112532.5405200003 | 37.77969133885821 | -122.498599173652 | (37.7796913388582, -122.498599173652) | |
| 179928 | 179928 | 94708 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 696 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53846 | 5992270.38847 | 2110735.82166 | 37.775233286679104 | -122.470235046427 | (37.7752332866791, -122.470235046427) |
| 70176 | 70176 | 94709 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 739 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53847 | 5992236.9095 | 2110392.30167 | 37.7742881380791 | -122.47032583467899 | (37.7742881380791, -122.470325834679) |
| 153587 | 153587 | 95071 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 319 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767740 | 5990554.377 | 2113243.49278 | 37.7820193005134 | -122.476354274932 | (37.7820193005134, -122.476354274932) | |
| 149661 | 149661 | 95133 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 450@ Wayland Somerset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2010 12:00:00 AM | 1 | 3x3 | Permit Number 54066 | 6010089.84133 | 2092358.2905700002 | 37.725786753837 | -122.407297408351 | (37.725786753837, -122.407297408351) | |
| 120994 | 120994 | 95216 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3623 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Magnolia planted in Fall; 2010 without permit; to replace Acacia baileyana; which there was no permit for planting or removing. | 6005441.0 | 2105452.0 | 37.761477821729706 | -122.424298976847 | (37.7614778217297, -122.424298976847) | ||
| 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) | ||
| 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) | |
| 135826 | 135826 | 99539 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 801X Central Ave | 2 | 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) | |
| 165837 | 165837 | 101128 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 295X 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769229 | 5990852.62725 | 2113482.2447900004 | 37.782692139400204 | -122.47533991256701 | (37.7826921394002, -122.475339912567) | |
| 134885 | 134885 | 102443 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 514 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2013 12:00:00 AM | 1 | Permit Number 770339 | 6013518.76597 | 2104573.81866 | 37.7595193399709 | -122.396299571184 | (37.7595193399709, -122.396299571184) | ||
| 180284 | 180284 | 105250 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 500 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2014 12:00:00 AM | 1 | Permit Number 771049 | 5984731.6893 | 2112357.9141599997 | 37.7792483592825 | -122.496432443475 | (37.7792483592825, -122.496432443475) | ||
| 171597 | 171597 | 105251 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 500 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2014 12:00:00 AM | 1 | Permit Number 771049 | 5984733.08187 | 2112389.43293 | 37.779334982299794 | -122.496429952441 | (37.7793349822998, -122.496429952441) | ||
| 79119 | 79119 | 105692 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2523 HARRISON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | 6008930.3 | 2103627.5 | 37.7566645705002 | -122.41210193949699 | (37.7566645705002, -122.412101939497) | ||
| 87725 | 87725 | 105693 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2523 HARRISON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6008930.3 | 2103627.5 | 37.7566645705002 | -122.41210193949699 | (37.7566645705002, -122.412101939497) | ||||
| 117109 | 117109 | 105717 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 409 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5987766.351369999 | 2113121.02315 | 37.7815209517603 | -122.485990454458 | (37.7815209517603, -122.485990454458) | |||
| 81426 | 81426 | 105758 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2523 HARRISON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | 6008930.3 | 2103627.5 | 37.7566645705002 | -122.41210193949699 | (37.7566645705002, -122.412101939497) | ||
| 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) | |
| 102284 | 102284 | 109757 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3590 20TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 1 | 3x3 | Permit Number 772584 | 6006354.0 | 2104372.0 | 37.75856390529879 | -122.421064595152 | (37.7585639052988, -122.421064595152) | |
| 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) | |||
| 68109 | 68109 | 112522 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 195 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776238 | 5995198.14893 | 2114301.9969900004 | 37.7851938828924 | -122.460365776533 | (37.7851938828924, -122.460365776533) | |
| 72706 | 72706 | 112523 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 195 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776238 | 5995199.36548 | 2114291.31706 | 37.7851646286632 | -122.46036079357799 | (37.7851646286632, -122.460360793578) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 182061 | 182061 | 115977 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011639.0005 | 2091249.90123 | 37.722829925953896 | -122.40186416949 | (37.7228299259539, -122.40186416949) | |||
| 172623 | 172623 | 115978 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011623.9012 | 2091244.95295 | 37.7228154963084 | -122.40191601721001 | (37.7228154963084, -122.40191601721) | |||
| 171742 | 171742 | 115979 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011610.19593 | 2091240.25279 | 37.722801825729604 | -122.401963063449 | (37.7228018257296, -122.401963063449) | |||
| 26519 | 26519 | 115980 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011593.71434 | 2091235.60939 | 37.722788156028706 | -122.402019710862 | (37.7227881560287, -122.402019710862) | |||
| 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) | |||
| 155447 | 155447 | 118202 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 744 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5985103.04881 | 2110791.51915 | 37.774969236334 | -122.495032243047 | (37.774969236334, -122.495032243047) | |||
| 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) | |||
| 132678 | 132678 | 120242 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 288 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5988397.89946 | 2114035.20565 | 37.7840678224086 | -122.483872680677 | (37.7840678224086, -122.483872680677) | |||
| 172445 | 172445 | 121908 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 320 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990601.2313 | 2113229.42539 | 37.781983392499704 | -122.476191154353 | (37.7819833924997, -122.476191154353) | |||
| 163844 | 163844 | 123126 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 771 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992555.29457 | 2110202.5485900003 | 37.773785530078605 | -122.469210678659 | (37.7737855300786, -122.469210678659) | |||
| 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) | |||
| 42403 | 42403 | 124334 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 176 Palm Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 5995958.15323 | 2113125.95358 | 37.782008471168 | -122.457651289636 | (37.782008471168, -122.457651289636) | |||
| 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) | |||
| 32904 | 32904 | 130968 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 95 Heather Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5997356.6821800005 | 2113906.91877 | 37.7842330344764 | -122.45286943159799 | (37.7842330344764, -122.452869431598) | ||||
| 65862 | 65862 | 130969 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 95 Heather Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5997355.4901 | 2113891.63765 | 37.7841910082488 | -122.452872452398 | (37.7841910082488, -122.452872452398) | ||||
| 29718 | 29718 | 130970 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002945.56276 | 2118345.7946599997 | 37.796739734404 | -122.433851284829 | (37.796739734404, -122.433851284829) | |||
| 35821 | 35821 | 130973 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002952.36205 | 2118301.89076 | 37.796619571497104 | -122.43382461811501 | (37.7966195714971, -122.433824618115) | |||
| 182271 | 182271 | 130978 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002959.932159999 | 2118244.90398 | 37.7964635301195 | -122.433794348725 | (37.7964635301195, -122.433794348725) | |||
| 55251 | 55251 | 130983 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2200 Beach St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 5999604.2907300005 | 2120890.91469 | 37.8035377808009 | -122.44559592174 | (37.8035377808009, -122.44559592174) | |||
| 160542 | 160542 | 130984 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2200 Beach St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 5999592.955130001 | 2120888.49408 | 37.803530487293 | -122.445634974783 | (37.803530487293, -122.445634974783) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 135931 | 135931 | 193323 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1189 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015597.773159999 | 2103545.2289400003 | 37.7568105190107 | -122.38903745483299 | (37.7568105190107, -122.389037454833) | |||
| 167402 | 167402 | 193327 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1398 Tennessee St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015585.429769999 | 2102602.25227 | 37.7542206208044 | -122.38901430715799 | (37.7542206208044, -122.389014307158) | |||
| 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) | |||
| 45125 | 45125 | 193342 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 401 Texas St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013812.69862 | 2105193.07398 | 37.7612360315304 | -122.39532637971901 | (37.7612360315304, -122.395326379719) | |||
| 153849 | 153849 | 193344 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1133 19th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6014141.435 | 2105240.8231200003 | 37.761385417914205 | -122.394192754591 | (37.7613854179142, -122.394192754591) | |||
| 187472 | 187472 | 193345 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1133 19th St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6014171.26133 | 2105242.63423 | 37.7613920486234 | -122.394089723782 | (37.7613920486234, -122.394089723782) | |||
| 165491 | 165491 | 193346 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1133 19th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6014187.49963 | 2105244.21667 | 37.761397296172 | -122.394033672633 | (37.761397296172, -122.394033672633) | |||
| 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) | |||
| 132124 | 132124 | 193349 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2501 18th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6010309.72434 | 2105489.81742 | 37.761855376635104 | -122.407462658778 | (37.7618553766351, -122.407462658778) | |||
| 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) |
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");