Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 103533 | 103533 | 12529 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 105 Lake St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 07/12/2004 12:00:00 AM | 6 | 3x3 | Permit Number 773769 | 5995136.95364 | 2114887.49287 | 37.78679797610221 | -122.460619935074 | (37.7867979761022, -122.460619935074) |
| 83616 | 83616 | 30531 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 100 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/1986 12:00:00 AM | 2 | 3x3 | Permit Number 34534 | 5989617.18715 | 2114630.7338900003 | 37.7857738797228 | -122.479698023599 | (37.7857738797228, -122.479698023599) |
| 41605 | 41605 | 30800 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 199 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 4 | Permit Number 34666 | 6001059.22701 | 2095245.3674599999 | 37.7332044430184 | -122.438722291799 | (37.7332044430184, -122.438722291799) | |
| 52436 | 52436 | 31977 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 134 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 7 | Permit Number 35376 | 5995230.64434 | 2114664.73917 | 37.7861917443429 | -122.460279644251 | (37.7861917443429, -122.460279644251) | |
| 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) | |
| 91749 | 91749 | 32526 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 871 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2015 12:00:00 AM | Permit Number 776214 | 6007576.4663397 | 2095282.92697428 | 37.733676184028795 | -122.416193025137 | (37.7336761840288, -122.416193025137) | ||
| 144271 | 144271 | 33553 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 238 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53983 | 6007052.33241005 | 2097631.90832878 | 37.740096482896 | -122.418171592585 | (37.740096482896, -122.418171592585) | |
| 134484 | 134484 | 34949 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1246 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1995 12:00:00 AM | 8 | Permit Number 38547 | 6007519.4935099995 | 2115461.74269 | 37.7890793334842 | -122.417819862092 | (37.7890793334842, -122.417819862092) | |
| 127785 | 127785 | 37585 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 210 Eagle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40016 | 5999628.99810136 | 2104552.86123042 | 37.758679112173205 | -122.444335603116 | (37.7586791121732, -122.444335603116) | ||
| 124483 | 124483 | 37803 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 465 Woolsey St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010402.90992445 | 2091781.87036726 | 37.7242215408534 | -122.406174555323 | (37.7242215408534, -122.406174555323) | ||
| 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) | |
| 108546 | 108546 | 41047 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1394 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53732 | 5999600.05829403 | 2107789.40004447 | 37.767564190631106 | -122.444668318417 | (37.7675641906311, -122.444668318417) | |
| 184009 | 184009 | 41941 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 646 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 10 | Permit Number 42299 | 5994427.444490001 | 2111105.89465 | 37.7763738805691 | -122.46280020914 | (37.7763738805691, -122.46280020914) | |
| 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) | |
| 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) |
| 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) |
| 106292 | 106292 | 43751 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 255 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2015 12:00:00 AM | 3 | Permit Number 773834 | 5991170.79793 | 2113718.28394 | 37.7833586747671 | -122.474256417664 | (37.7833586747671, -122.474256417664) | |
| 52541 | 52541 | 47432 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 432 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 2 | Permit Number 45343 | 5982855.38785 | 2112869.9347900003 | 37.7805441204791 | -122.50296115463001 | (37.7805441204791, -122.50296115463) | |
| 153237 | 153237 | 50024 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1704 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 3 | Permit Number 46757 | 6005953.2164199995 | 2092396.45471 | 37.725659158041104 | -122.421600147046 | (37.7256591580411, -122.421600147046) | |
| 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) | |
| 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) | |
| 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) | |
| 156259 | 156259 | 61491 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 178 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1990 12:00:00 AM | 3 | Permit Number 28869 | 5989634.7512 | 2114171.8446400003 | 37.784514919234205 | -122.47960366993601 | (37.7845149192342, -122.479603669936) | |
| 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) | |
| 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) | |
| 82388 | 82388 | 63744 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 690 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773423 | 6003267.19349485 | 2109664.80045569 | 37.772922159977 | -122.43211812531901 | (37.772922159977, -122.432118125319) |
| 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) | |
| 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) |
| 98471 | 98471 | 69097 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1652 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53733 | 5992497.75001654 | 2104207.48539143 | 37.7573213517081 | -122.46897335970101 | (37.7573213517081, -122.468973359701) | |
| 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) | |
| 66893 | 66893 | 69450 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 438 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 3 | Permit Number 33560 | 5985645.83858 | 2112922.4758599997 | 37.780851994355004 | -122.493311672832 | (37.780851994355, -122.493311672832) | |
| 125226 | 125226 | 70167 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 831 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2015 12:00:00 AM | 3 | Permit Number 773700 | 5981976.78091 | 2110066.45395 | 37.772794906459 | -122.505792724366 | (37.772794906459, -122.505792724366) | |
| 66578 | 66578 | 70266 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 414 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 8 | 5988762.33088 | 2112478.2196299997 | 37.7798139854521 | -122.482497769619 | (37.7798139854521, -122.482497769619) | ||
| 133294 | 133294 | 70331 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 73 Danton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 6 | 3x3 | Permit Number 54058 | 6002878.82262 | 2094505.5983099998 | 37.731276553757 | -122.43237864406 | (37.731276553757, -122.43237864406) |
| 73049 | 73049 | 70606 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1250 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 8 | 6007500.2862599995 | 2115460.0775 | 37.7890736803541 | -122.41788619879298 | (37.7890736803541, -122.417886198793) | ||
| 33867 | 33867 | 70607 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1256 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 9 | 6007485.00571 | 2115457.39575 | 37.78906545695621 | -122.41793887748301 | (37.7890654569562, -122.417938877483) | ||
| 174370 | 174370 | 71615 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 536 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 2 | 5983503.66193 | 2112151.1699 | 37.7786086821922 | -122.500665338334 | (37.7786086821922, -122.500665338334) | ||
| 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) | ||
| 168053 | 168053 | 72311 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3769 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 4 | 5996250.37824 | 2115874.5059700003 | 37.7895720432509 | -122.456839183887 | (37.7895720432509, -122.456839183887) | ||
| 136360 | 136360 | 74692 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 200 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 6 | 6011876.44918 | 2119465.43765 | 37.8003167500634 | -122.403026990216 | (37.8003167500634, -122.403026990216) | ||
| 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) | ||
| 69848 | 69848 | 81662 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 563 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5991577.12734 | 2111607.04314 | 37.7775853186785 | -122.472696706975 | (37.7775853186785, -122.472696706975) | |||
| 142320 | 142320 | 82180 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 105 Lake St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773769 | 5995179.68463591 | 2114884.08050195 | 37.78679106496129 | -122.46047184952101 | (37.7867910649613, -122.460471849521) | ||
| 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) | ||
| 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) |
| 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) | ||
| 106163 | 106163 | 84574 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1090X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769743 | 6003150.0 | 2101890.0 | 37.7515677875779 | -122.43196823442301 | (37.7515677875779, -122.431968234423) |
| 82829 | 82829 | 88007 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1394 Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53732 | 5999618.7 | 2107794.0 | 37.7675778847064 | -122.44460417005699 | (37.7675778847064, -122.444604170057) | |
| 90961 | 90961 | 94705 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 682 12th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53845 | 5992291.3 | 2110837.3 | 37.7755131276945 | -122.470170100471 | (37.7755131276945, -122.470170100471) | ||
| 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) |
| 152466 | 152466 | 94730 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 418 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53862 | 5997217.67326 | 2114882.8026 | 37.7869045857318 | -122.45342083293001 | (37.7869045857318, -122.45342083293) |
| 90318 | 90318 | 94819 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1551 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53898 | 5993027.2 | 2104915.2 | 37.759295127513106 | -122.467193784759 | (37.7592951275131, -122.467193784759) | |
| 141970 | 141970 | 94820 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1227 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53900 | 5992334.0 | 2107055.2 | 37.7651309632558 | -122.469746983482 | (37.7651309632558, -122.469746983482) | |
| 138212 | 138212 | 94884 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2010 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53951 | 6013072.55459 | 2096282.04692 | 37.736727066797 | -122.397261344859 | (37.736727066797, -122.397261344859) |
| 188017 | 188017 | 94885 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2010 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53951 | 6013050.0613 | 2096298.0841299999 | 37.736769849332 | -122.39734023878599 | (37.736769849332, -122.397340238786) |
| 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) | |
| 131930 | 131930 | 95118 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 70 Danton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 54045 | 6002845.36735 | 2094508.37035 | 37.7312822680527 | -122.432494502827 | (37.7312822680527, -122.432494502827) |
| 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) | |
| 88687 | 88687 | 95549 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1712 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767351 | 6002582.0 | 2100598.0 | 37.7479880436154 | -122.433840109923 | (37.7479880436154, -122.433840109923) | |
| 61145 | 61145 | 95563 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 497 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6003239.0 | 2102086.6 | 37.75211264995529 | -122.43167449646799 | (37.7521126499553, -122.431674496468) | |||
| 126909 | 126909 | 95564 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 497 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767357 | 6003239.0 | 2102086.6 | 37.75211264995529 | -122.43167449646799 | (37.7521126499553, -122.431674496468) | |
| 142179 | 142179 | 95565 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 497 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767357 | 6003239.0 | 2102086.6 | 37.75211264995529 | -122.43167449646799 | (37.7521126499553, -122.431674496468) | |
| 15812 | 15812 | 95581 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3881 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779561 | 6003940.0 | 2101864.0 | 37.7515411523314 | -122.429234461777 | (37.7515411523314, -122.429234461777) |
| 121384 | 121384 | 95582 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1352 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767370 | 6002514.0 | 2101648.0 | 37.7508672366014 | -122.434150301439 | (37.7508672366014, -122.434150301439) | |
| 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) |
| 84591 | 84591 | 95703 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 497 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767357 | 6003239.0 | 2102086.6 | 37.75211264995529 | -122.43167449646799 | (37.7521126499553, -122.431674496468) | |
| 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) | |
| 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) |
| 108616 | 108616 | 95787 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3234 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767531 | 6008132.0 | 2101545.0 | 37.750901673491995 | -122.41471538692801 | (37.750901673492, -122.414715386928) | |
| 78394 | 78394 | 95830 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 5 Lucerne St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767564 | 6011975.0 | 2109856.0 | 37.7739369979495 | -122.402010048031 | (37.7739369979495, -122.402010048031) | |
| 105494 | 105494 | 95926 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 651 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767623 | 5988426.1 | 2111542.8 | 37.777226019991204 | -122.483592327097 | (37.7772260199912, -122.483592327097) | |
| 126977 | 126977 | 95932 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 218 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767629 | 5987170.3 | 2114494.3 | 37.7852568239907 | -122.488153421892 | (37.7852568239907, -122.488153421892) |
| 97250 | 97250 | 96057 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 110 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 2 | 3.5x6 | Permit Number 767685 | 6006775.4 | 2098937.3 | 37.7436652048745 | -122.419221689065 | (37.7436652048745, -122.419221689065) |
| 87866 | 87866 | 96066 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 957 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767691 | 6008013.0 | 2102358.0 | 37.753127300999395 | -122.415184444517 | (37.7531273009994, -122.415184444517) | |
| 110527 | 110527 | 96067 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 981 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767692 | 6008020.0 | 2102218.0 | 37.7527432860874 | -122.415150327914 | (37.7527432860874, -122.415150327914) | |
| 94972 | 94972 | 96116 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 201 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767772 | 6007577.0 | 2097739.0 | 37.7404200508617 | -122.41636508469699 | (37.7404200508617, -122.416365084697) | |
| 81271 | 81271 | 96117 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 201 Andover St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767772 | 6007577.0 | 2097739.0 | 37.7404200508617 | -122.41636508469699 | (37.7404200508617, -122.416365084697) | |
| 96203 | 96203 | 96118 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 201 Andover St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767772 | 6007577.0 | 2097739.0 | 37.7404200508617 | -122.41636508469699 | (37.7404200508617, -122.416365084697) | |
| 106722 | 106722 | 96167 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1325X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767799 | 6003578.5 | 2095430.2 | 37.7338549505754 | -122.430025664845 | (37.7338549505754, -122.430025664845) |
| 76012 | 76012 | 97025 | Property Tree 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 6714 | 6714 | 97108 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1472 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768373 | 6007110.8589699995 | 2117762.02293 | 37.795372327823 | -122.419396941128 | (37.795372327823, -122.419396941128) |
| 156900 | 156900 | 102081 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 525 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52509 | 5991566.610309999 | 2111852.8346 | 37.778259586012204 | -122.472751014651 | (37.7782595860122, -122.472751014651) |
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 90136 | 90136 | 108459 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 771 11th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773786 | 5992558.08669 | 2110211.94426 | 37.7738114893979 | -122.469201704334 | (37.7738114893979, -122.469201704334) | |||
| 91530 | 91530 | 108518 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 600-602 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773792 | 5993757.5779800005 | 2110759.58067 | 37.7753843907715 | -122.465092287532 | (37.7753843907715, -122.465092287532) |
| 128305 | 128305 | 108523 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1655 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773674 | 5990561.39992 | 2104128.4377099997 | 37.7569922406164 | -122.475664177859 | (37.7569922406164, -122.475664177859) |
| 122847 | 122847 | 108524 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1669 18th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773675 | 5990564.49357 | 2104037.4684 | 37.756742642361495 | -122.47564683648301 | (37.7567426423615, -122.475646836483) |
| 110033 | 110033 | 108525 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1673 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773676 | 5990565.37747 | 2104011.47717 | 37.7566713285758 | -122.47564188182501 | (37.7566713285758, -122.475641881825) |
| 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) |
| 99743 | 99743 | 108592 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 669 Parker Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774577 | 5997227.20075 | 2110944.62571 | 37.77609193478521 | -122.453103475186 | (37.7760919347852, -122.453103475186) |
| 127069 | 127069 | 108608 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 46 Mirabel Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774593 | 6007564.86266 | 2099909.6740900003 | 37.7463795558054 | -122.416560777242 | (37.7463795558054, -122.416560777242) | |
| 120168 | 120168 | 108610 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 745 Moultrie St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774595 | 6007633.33742 | 2095945.52231 | 37.7354987236975 | -122.416043312411 | (37.7354987236975, -122.416043312411) | |
| 139421 | 139421 | 108632 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 99 ORD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774601 | 6000898.0 | 2105859.0 | 37.7623377695764 | -122.440040482469 | (37.7623377695764, -122.440040482469) |
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");