Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45771 | 45771 | 48784 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 268 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | 7 | Permit Number 46039 | 6000083.90087 | 2091529.02554 | 37.7229446929396 | -122.44182761574801 | (37.7229446929396, -122.441827615748) | ||
| 46117 | 46117 | 68549 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 543 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 3 | Permit Number 32436 | 5982217.68828 | 2112054.92779 | 37.7782688503059 | -122.50510680493 | (37.7782688503059, -122.50510680493) | |
| 46218 | 46218 | 34478 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 755 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 16 | Permit Number 38205 | 6009336.13836 | 2119417.92641 | 37.8000441124981 | -122.411814144501 | (37.8000441124981, -122.411814144501) | |
| 46269 | 46269 | 41181 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1780 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | 11 | Permit Number 41899 | 6001559.95191 | 2121091.33566 | 37.8041995397404 | -122.438842652585 | (37.8041995397404, -122.438842652585) | |
| 46283 | 46283 | 31905 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2259 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 9 | Permit Number 35330 | 5991969.67434 | 2100068.6545599997 | 37.7459266717829 | -122.47049820945 | (37.7459266717829, -122.47049820945) | |
| 46285 | 46285 | 65280 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 435 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1989 12:00:00 AM | 1 | Permit Number 28085 | 6011091.92612 | 2112217.73363 | 37.7803724445696 | -122.405231107147 | (37.7803724445696, -122.405231107147) | |
| 46506 | 46506 | 46788 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 46 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 13 | Permit Number 44879 | 6002727.62043 | 2093608.9961599999 | 37.7288061125106 | -122.432837348688 | (37.7288061125106, -122.432837348688) | |
| 46730 | 46730 | 40853 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 126 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | 11 | Permit Number 45449 | 6014213.93466 | 2112556.76874 | 37.781477404701 | -122.394454288235 | (37.781477404701, -122.394454288235) | |
| 46997 | 46997 | 31908 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2227 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 13 | Permit Number 35333 | 5991730.6123 | 2100240.74702 | 37.746385367410205 | -122.47133738212601 | (37.7463853674102, -122.471337382126) | |
| 47328 | 47328 | 45483 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3020 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 3 | Permit Number 44263 | 5990296.648580001 | 2095102.6956099998 | 37.7321945457224 | -122.47592063752501 | (37.7321945457224, -122.475920637525) | |
| 47842 | 47842 | 52649 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 46@ LAKE 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2006 12:00:00 AM | 4 | Permit Number 48733 | 5993970.1832 | 2115226.91418 | 37.787662738807605 | -122.46468131190001 | (37.7876627388076, -122.4646813119) | ||
| 48200 | 48200 | 31194 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 354 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46596 | 5993258.721390001 | 2089558.71458 | 37.7171434272164 | -122.46527761436899 | (37.7171434272164, -122.465277614369) | |
| 48211 | 48211 | 73744 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 5 | 5995854.8721 | 2112478.1679599998 | 37.7802238906314 | -122.45796169978998 | (37.7802238906314, -122.45796169979) | ||
| 48217 | 48217 | 32078 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3847 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 6 | Permit Number 35451 | 6003283.17124 | 2105912.34445 | 37.7626197356314 | -122.431794879733 | (37.7626197356314, -122.431794879733) | |
| 48514 | 48514 | 50297 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2909 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 1 | Permit Number 47009 | 5989047.82914 | 2095849.4982599998 | 37.7341725865769 | -122.48029267728701 | (37.7341725865769, -122.480292677287) | |
| 48739 | 48739 | 57611 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 356 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/1976 12:00:00 AM | 13 | Permit Number 16500 | 6013179.72476 | 2105412.69394 | 37.761803835594705 | -122.397530985864 | (37.7618038355947, -122.397530985864) | ||
| 48981 | 48981 | 45577 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3866 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44317 | 5996397.2109199995 | 2114961.83643 | 37.78707452790071 | -122.456265143944 | (37.7870745279007, -122.456265143944) | |
| 49359 | 49359 | 238529 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Harry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6003245.126759999 | 2097701.12571 | 37.7400715069955 | -122.43134028773899 | (37.7400715069955, -122.431340287739) | ||||
| 49916 | 49916 | 37808 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 925 Woolsey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 14 | Permit Number 40128 | 6009009.75323 | 2091360.17391 | 37.7229856264714 | -122.41096074186702 | (37.7229856264714, -122.410960741867) | |
| 49933 | 49933 | 78363 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 6 | 6001858.247830001 | 2090145.2543799998 | 37.719246112288104 | -122.43559512512199 | (37.7192461122881, -122.435595125122) | ||
| 49985 | 49985 | 31912 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2256 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 9 | Permit Number 35336 | 5991754.81336 | 2100091.67364 | 37.745977450207 | -122.47124283909099 | (37.745977450207, -122.471242839091) | |
| 50364 | 50364 | 74315 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 6 | 6000588.288430001 | 2093013.22945 | 37.727048705022895 | -122.440190437741 | (37.7270487050229, -122.440190437741) | ||
| 50848 | 50848 | 50228 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 741 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 5 | Permit Number 46935 | 5987844.86264 | 2110914.45258 | 37.775466905732706 | -122.485556863724 | (37.7754669057327, -122.485556863724) | |
| 50853 | 50853 | 38717 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 458 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1998 12:00:00 AM | 8 | Permit Number 40620 | 5994382.59481 | 2112404.76272 | 37.779937641475705 | -122.463049617411 | (37.7799376414757, -122.463049617411) | ||
| 51040 | 51040 | 80385 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1754 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 8 | 6011729.10125 | 2092748.5600299998 | 37.7269499630479 | -122.40165799273599 | (37.7269499630479, -122.401657992736) | ||
| 51253 | 51253 | 51883 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 209 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48099 | 6006849.08815448 | 2097918.82782797 | 37.740872857816 | -122.418894673949 | (37.740872857816, -122.418894673949) | |||
| 51525 | 51525 | 33649 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 541 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 8 | Permit Number 37740 | 6004806.91261 | 2110706.66354 | 37.775870037302106 | -122.426866263978 | (37.7758700373021, -122.426866263978) | ||
| 51687 | 51687 | 246689 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 51 Stoneman St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6008012.99299 | 2099394.86915 | 37.744991208669504 | -122.414974758775 | (37.7449912086695, -122.414974758775) | ||||
| 51992 | 51992 | 62174 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 48 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1985 12:00:00 AM | 16 | Permit Number 22290 | 6000090.28991 | 2091840.80817 | 37.7238011406834 | -122.44182789633699 | (37.7238011406834, -122.441827896337) | |
| 54203 | 54203 | 78243 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 30 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 7 | 6000646.02726 | 2093117.37413 | 37.727337949475896 | -122.439998300301 | (37.7273379494759, -122.439998300301) | ||
| 54230 | 54230 | 34485 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 851 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 8 | Permit Number 38211 | 6008882.966680001 | 2119355.1714 | 37.799846369579704 | -122.41337785691299 | (37.7998463695797, -122.413377856913) | |
| 54523 | 54523 | 31006 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 75 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 8 | Permit Number 34780 | 6000669.33593 | 2088075.8661099998 | 37.713496437089894 | -122.43955646516599 | (37.7134964370899, -122.439556465166) | |
| 54653 | 54653 | 51291 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2020 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2004 12:00:00 AM | 1 | Permit Number 47663 | 5989189.38676 | 2113364.18569 | 37.7822714342333 | -122.481085302679 | (37.7822714342333, -122.481085302679) | ||
| 55317 | 55317 | 45550 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Sloat Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44299 | 5990341.112869999 | 2095936.17267 | 37.7344856397084 | -122.475827760949 | (37.7344856397084, -122.475827760949) | ||
| 55825 | 55825 | 67395 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 755 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1992 12:00:00 AM | 4 | Permit Number 30892 | 5990662.93226 | 2110247.15301 | 37.7737984716316 | -122.47575985163 | (37.7737984716316, -122.47575985163) | |
| 55895 | 55895 | 40019 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 12 Latona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 6 | Permit Number 41264 | 6014412.91208 | 2094585.9323200001 | 37.732144413937796 | -122.392508504263 | (37.7321444139378, -122.392508504263) | |
| 56028 | 56028 | 34878 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3009 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/1997 12:00:00 AM | 10 | Permit Number 38491 | 6000242.0296 | 2115774.84436 | 37.789526793876206 | -122.443021372241 | (37.7895267938762, -122.443021372241) | ||
| 56051 | 56051 | 136019 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Greenwich St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012283.42018 | 2120515.08235 | 37.803221537807204 | -122.401692519489 | (37.8032215378072, -122.401692519489) | ||||
| 56087 | 56087 | 58297 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1978 12:00:00 AM | 1 | Permit Number 17314 | 5995266.20192 | 2113689.20735 | 37.783515241763894 | -122.46008592615101 | (37.7835152417639, -122.460085926151) | ||
| 56131 | 56131 | 49551 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1084REVISED Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2003 12:00:00 AM | 5 | Permit Number 46441 | 6009968.28689 | 2111507.46699 | 37.7783593364429 | -122.40906818514601 | (37.7783593364429, -122.409068185146) | ||
| 56142 | 56142 | 46772 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 65 Norton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 11 | Permit Number 44868 | 6001770.38169 | 2092273.3615 | 37.7250844246807 | -122.436051045439 | (37.7250844246807, -122.436051045439) | |
| 56536 | 56536 | 68520 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 643 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 8 | Permit Number 32400 | 5995312.0360199995 | 2111170.0323400004 | 37.77660089482001 | -122.45974482687402 | (37.77660089482, -122.459744826874) | |
| 56597 | 56597 | 62492 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 61 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | 17 | Permit Number 22663 | 6000854.65183 | 2092771.54235 | 37.726400248862205 | -122.43925230995 | (37.7264002488622, -122.43925230995) | |
| 56599 | 56599 | 43215 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 365 Sweeny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 6 | Permit Number 43005 | 6008686.27116 | 2094503.726 | 37.731599006589704 | -122.41230103567499 | (37.7315990065897, -122.412301035675) | |
| 56604 | 56604 | 33140 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3143 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 6 | Permit Number 37367 | 6001896.074 | 2118984.29093 | 37.798433267540105 | -122.437528496644 | (37.7984332675401, -122.437528496644) | |
| 57170 | 57170 | 114542 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2035 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011944.84803 | 2103714.6650900003 | 37.757072587740296 | -122.401682603564 | (37.7570725877403, -122.401682603564) | ||
| 57869 | 57869 | 49452 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1483 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 4 | Permit Number 46386 | 6011771.85534 | 2101466.1696900004 | 37.7508890570981 | -122.402122808245 | (37.7508890570981, -122.402122808245) | |
| 57991 | 57991 | 37799 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 425 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2002 12:00:00 AM | 6 | Permit Number 40126 | 6010088.32636 | 2092511.7068599998 | 37.7262079180568 | -122.407313455853 | (37.7262079180568, -122.407313455853) | |
| 58171 | 58171 | 62166 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 92 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | 21 | Permit Number 23136 | 5999904.31715 | 2091941.2410400002 | 37.7240663075915 | -122.44247797848301 | (37.7240663075915, -122.442477978483) | |
| 58345 | 58345 | 72333 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 522 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 11 | 5989411.86479 | 2111751.27895 | 37.7778557732807 | -122.48019755247 | (37.7778557732807, -122.48019755247) | ||
| 58413 | 58413 | 40675 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 191 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | 6 | Permit Number 47920 | 6004642.33575 | 2093798.50545 | 37.7294348744024 | -122.42623153326099 | (37.7294348744024, -122.426231533261) | |
| 58748 | 58748 | 121640 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 195 Otsego Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 17 | 6000583.2387 | 2092221.3848599999 | 37.724874193767796 | -122.440151136477 | (37.7248741937678, -122.440151136477) | |||
| 58895 | 58895 | 37862 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 286 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | 10 | Permit Number 40149 | 6004552.23885 | 2091481.5698 | 37.7230679881701 | -122.426378106562 | (37.7230679881701, -122.426378106562) | |
| 59082 | 59082 | 46513 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2563 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | 4 | Permit Number 44679 | 6002506.83642 | 2116089.37205 | 37.790519274906 | -122.435207900427 | (37.790519274906, -122.435207900427) | ||
| 59162 | 59162 | 67443 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 161 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1992 12:00:00 AM | 9 | Permit Number 30946 | 5994572.42148 | 2114474.4165 | 37.785631285707105 | -122.46254309514099 | (37.7856312857071, -122.462543095141) | ||
| 59592 | 59592 | 68878 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 535 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 9 | Permit Number 32849 | 5994664.33554 | 2111876.7239 | 37.778504013274 | -122.462036654628 | (37.778504013274, -122.462036654628) | |
| 59593 | 59593 | 237207 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Valley St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6002742.12056 | 2099166.74161 | 37.7440672281147 | -122.433184169536 | (37.7440672281147, -122.433184169536) | ||||
| 59674 | 59674 | 33813 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 261 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | 6 | Permit Number 37827 | 6006152.11101 | 2110895.2275099996 | 37.776463756237504 | -122.42222627034401 | (37.7764637562375, -122.422226270344) | ||
| 59928 | 59928 | 32098 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 134 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 8 | Permit Number 35471 | 6002656.28427 | 2105089.46023 | 37.7603247386273 | -122.433904232401 | (37.7603247386273, -122.433904232401) | |
| 59954 | 59954 | 38239 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 81 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | 11 | Permit Number 40353 | 6010121.79913 | 2110806.9834 | 37.7764445709857 | -122.408487702448 | (37.7764445709857, -122.408487702448) | ||
| 60065 | 60065 | 65973 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2245 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1990 12:00:00 AM | 9 | Permit Number 28997 | 5988612.04832 | 2110519.74016 | 37.7744278044001 | -122.48287408378 | (37.7744278044001, -122.48287408378) | ||
| 60174 | 60174 | 40696 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 308 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 12 | Permit Number 41676 | 6005349.23912 | 2094062.7546400002 | 37.7302003755475 | -122.423806479907 | (37.7302003755475, -122.423806479907) | |
| 60196 | 60196 | 45485 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3036 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 3 | Permit Number 44264 | 5990298.1598 | 2095038.91467 | 37.7320195070769 | -122.47591075667299 | (37.7320195070769, -122.475910756673) | |
| 60351 | 60351 | 43678 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 447 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 11 | Permit Number 43321 | 5994953.99228 | 2112486.2595900004 | 37.7801943078359 | -122.461078821483 | (37.7801943078359, -122.461078821483) | |
| 60368 | 60368 | 69413 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 73 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33518 | 6001961.1999 | 2087395.4649599998 | 37.711701646594 | -122.43504269857 | (37.711701646594, -122.43504269857) | |
| 60883 | 60883 | 68231 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 257 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 5 | Permit Number 32026 | 5990849.231930001 | 2113671.85139 | 37.7832125496886 | -122.475365506488 | (37.7832125496886, -122.475365506488) | |
| 61324 | 61324 | 31297 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 53 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34941 | 6002026.478019999 | 2105548.36068 | 37.7615490072959 | -122.43611527411899 | (37.7615490072959, -122.436115274119) | ||
| 61632 | 61632 | 39922 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2335 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 6 | Permit Number 41196 | 6003527.33622 | 2116558.3105 | 37.791864757797896 | -122.431710530526 | (37.7918647577979, -122.431710530526) | |
| 61956 | 61956 | 72143 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 12 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1985 12:00:00 AM | 12 | 6000249.61025 | 2091756.3807599999 | 37.723578399296606 | -122.44127109908301 | (37.7235783992966, -122.441271099083) | ||
| 62212 | 62212 | 78428 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1000 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 10 | 6003760.55793 | 2089507.02649 | 37.7176015427445 | -122.42897407970699 | (37.7176015427445, -122.428974079707) | ||
| 62513 | 62513 | 69303 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 813 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2014 12:00:00 AM | 6 | Permit Number 770956 | 5999968.796 | 2111801.6454 | 37.7786018352438 | -122.443681177953 | (37.7786018352438, -122.443681177953) | |
| 62895 | 62895 | 40654 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Congdon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | 9 | Permit Number 47919 | 6004685.50571 | 2093693.1599299998 | 37.7291480590261 | -122.426074794035 | (37.7291480590261, -122.426074794035) | |
| 63147 | 63147 | 68401 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 16 | Permit Number 32233 | 6002304.62048 | 2093927.0229599997 | 37.7296553414093 | -122.434322413556 | (37.7296553414093, -122.434322413556) | |
| 63169 | 63169 | 62179 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/25/1985 12:00:00 AM | 14 | Permit Number 22296 | 6000171.69971 | 2091765.05125 | 37.723597768014 | -122.44154104320499 | (37.723597768014, -122.441541043205) | |
| 63221 | 63221 | 84826 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 855 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2010 12:00:00 AM | 7 | Permit Number 53480 | 6010945.70103 | 2090738.7413400002 | 37.7213876696754 | -122.404224813428 | (37.7213876696754, -122.404224813428) | ||
| 64152 | 64152 | 37966 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 456 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40197 | 6013485.30445 | 2104964.69116 | 37.7605907284002 | -122.396442696467 | (37.7605907284002, -122.396442696467) | |
| 65515 | 65515 | 103235 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 116 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2013 12:00:00 AM | 5 | Permit Number 770114 | 5998278.0 | 2110273.0 | 37.7743079905046 | -122.44942009353998 | (37.7743079905046, -122.44942009354) | ||
| 65573 | 65573 | 64859 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 45 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1993 12:00:00 AM | 10 | Permit Number 25875 | 5995863.10867 | 2112429.78445 | 37.7800915155758 | -122.457929703566 | (37.7800915155758, -122.457929703566) | |
| 65939 | 65939 | 31911 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2236 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 11 | Permit Number 35335 | 5991758.20148 | 2100218.73627 | 37.7463265274626 | -122.471240379447 | (37.7463265274626, -122.471240379447) | |
| 66348 | 66348 | 62035 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 526 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1985 12:00:00 AM | 3 | Permit Number 22108 | 5989101.14075 | 2111731.85837 | 37.777784389853004 | -122.481271020374 | (37.777784389853, -122.481271020374) | ||
| 67071 | 67071 | 78281 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 34 Wanda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 8 | 6000546.67018 | 2091525.62315 | 37.722961708992294 | -122.44022767776501 | (37.7229617089923, -122.440227677765) | ||
| 67338 | 67338 | 59187 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 559 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 13 | Permit Number 18503 | 5989063.8728 | 2111532.21619 | 37.777234061307205 | -122.481385317518 | (37.7772340613072, -122.481385317518) | |
| 67348 | 67348 | 50606 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 219 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2003 12:00:00 AM | 7 | Permit Number 47205 | 5994896.0666 | 2113978.5362299997 | 37.784288365194996 | -122.461387423321 | (37.784288365195, -122.461387423321) | ||
| 67388 | 67388 | 46777 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 San Juan Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 5 | Permit Number 44869 | 6001762.9966400005 | 2091991.0449700002 | 37.7243088277709 | -122.436056382001 | (37.7243088277709, -122.436056382001) | |
| 67416 | 67416 | 49399 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 535@ BALBOA 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2003 12:00:00 AM | 3 | Permit Number 46352 | 5993738.83746 | 2111833.0090900003 | 37.7783306565586 | -122.465235101695 | (37.7783306565586, -122.465235101695) | ||
| 68028 | 68028 | 45482 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3020 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 2 | Permit Number 44263 | 5990295.806419999 | 2095116.94306 | 37.7322336167725 | -122.475924589162 | (37.7322336167725, -122.475924589162) | |
| 68081 | 68081 | 64861 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 6 | Permit Number 25877 | 5995901.579469999 | 2112392.78617 | 37.779992138301296 | -122.457793938484 | (37.7799921383013, -122.457793938484) | |
| 68144 | 68144 | 72942 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Gladstone Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1999 12:00:00 AM | 8 | 6006185.1456 | 2093706.6722400002 | 37.729269804734294 | -122.420891365245 | (37.7292698047343, -122.420891365245) | ||
| 68159 | 68159 | 32124 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 70 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 10 | Permit Number 35486 | 6003846.92621 | 2106756.5408799998 | 37.764969637151 | -122.429905274625 | (37.764969637151, -122.429905274625) | |
| 68733 | 68733 | 31023 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 330 Naylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34788 | 6002794.80361 | 2086503.3822400002 | 37.7092994800486 | -122.43209787574 | (37.7092994800486, -122.43209787574) | |
| 68955 | 68955 | 67626 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1334 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/1993 12:00:00 AM | 7 | Permit Number 31212 | 6007155.75192 | 2118470.9352 | 37.7973213520513 | -122.41929191739901 | (37.7973213520513, -122.419291917399) | |
| 69153 | 69153 | 237112 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 San Jose Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004834.0708099995 | 2096408.3013799998 | 37.736611626213495 | -122.425754370088 | (37.7366116262135, -122.425754370088) | ||||
| 69163 | 69163 | 34484 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 845 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 6 | Permit Number 38210 | 6008932.65781 | 2119362.16351 | 37.799868357993105 | -122.41320640114901 | (37.7998683579931, -122.413206401149) | |
| 69301 | 69301 | 31909 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2227 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 14 | Permit Number 35333 | 5991726.96722 | 2100261.52129 | 37.746442197347605 | -122.471351499672 | (37.7464421973476, -122.471351499672) | |
| 69423 | 69423 | 57395 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1415 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1994 12:00:00 AM | 4 | Permit Number 33423 | 6007958.46126 | 2117300.9237 | 37.7941539658926 | -122.41643141230499 | (37.7941539658926, -122.416431412305) | ||
| 69458 | 69458 | 32354 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 116 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | 16 | Permit Number 36908 | 6002648.503 | 2105198.2324099997 | 37.7606229592107 | -122.43393891927299 | (37.7606229592107, -122.433938919273) | |
| 69559 | 69559 | 33659 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 545 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 8 | Permit Number 37747 | 6004792.43502 | 2110705.04365 | 37.7758647708832 | -122.42691623030599 | (37.7758647708832, -122.426916230306) | |
| 69577 | 69577 | 246688 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 51 Stoneman St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6008021.86099 | 2099397.11663 | 37.7449978780651 | -122.41494425378 | (37.7449978780651, -122.41494425378) | ||||
| 69827 | 69827 | 31988 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 137 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 12 | Permit Number 35388 | 5994566.451859999 | 2114623.28431 | 37.786039692573205 | -122.46257455055901 | (37.7860396925732, -122.462574550559) | |
| 70102 | 70102 | 44491 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 55 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 9 | Permit Number 45395 | 6005461.21441 | 2093276.5457799998 | 37.728047939957 | -122.42336349723499 | (37.728047939957, -122.423363497235) |
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");