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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18879 | 18879 | 94134 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Nebraska St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53498 | 6009291.0 | 2097948.0 | 37.7410901551317 | -122.41045347697501 | (37.7410901551317, -122.410453476975) | |||
| 21236 | 21236 | 92078 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1151 Sutter St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2009 12:00:00 AM | 3x3 | Permit Number 52192 | 6007083.0 | 2115004.0 | 37.7877979108835 | -122.41929759225799 | (37.7877979108835, -122.419297592258) | |||
| 41693 | 41693 | 91420 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 770 18th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52101 | 5990400.3408699995 | 2110139.21584 | 37.7734868781795 | -122.47666030039301 | (37.7734868781795, -122.476660300393) | ||
| 50040 | 50040 | 87823 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 451 47th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 4 | 2x3 | Permit Number 50716 | 5981265.5826900005 | 2112596.97795 | 37.7797010943021 | -122.508440678428 | (37.7797010943021, -122.508440678428) | ||
| 60427 | 60427 | 88580 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 474 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51522 | 5989397.97956 | 2112106.21746 | 37.778829528805794 | -122.480271570948 | (37.7788295288058, -122.480271570948) | ||
| 67866 | 67866 | 92826 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 755 14th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2009 12:00:00 AM | 5 | 3x3 | Permit Number 53040 | 5991610.35704 | 2110282.0512900003 | 37.7739491753353 | -122.47248513397899 | (37.7739491753353, -122.472485133979) | ||
| 78144 | 78144 | 87131 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 De Montfort Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2008 12:00:00 AM | 3x3 | Permit Number 50083 | 5995245.2 | 2091924.0 | 37.7237522965749 | -122.45858247555599 | (37.7237522965749, -122.458582475556) | |||
| 79204 | 79204 | 95400 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 227 Valley St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767274 | 6004277.7 | 2099178.3 | 37.744185954454295 | -122.42787530142701 | (37.7441859544543, -122.427875301427) | ||
| 81443 | 81443 | 100355 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 Waller St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/30/2014 12:00:00 AM | 3 | 27x6 | Permit Number 769031 | 6002899.6 | 2108847.2 | 37.770656382716396 | -122.43333123962 | (37.7706563827164, -122.43333123962) | ||
| 81641 | 81641 | 89366 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 340 Benton Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2008 12:00:00 AM | 3x3 | Permit Number 51946 | 6006673.6 | 2095420.1 | 37.7340020224619 | -122.419324232824 | (37.7340020224619, -122.419324232824) | |||
| 82487 | 82487 | 104995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2220 Castro St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2013 12:00:00 AM | 3X3 | Permit Number 771144 | 6002644.3 | 2099031.5 | 37.7436903366208 | -122.433512747881 | (37.7436903366208, -122.433512747881) | |||
| 85190 | 85190 | 94875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 44 Ledyard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53944 | 6011618.0 | 2095077.0 | 37.7333371742049 | -122.40220570440799 | (37.7333371742049, -122.402205704408) | ||
| 86418 | 86418 | 96362 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1432 23rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2011 12:00:00 AM | Permit Number 767816 | 5989066.4 | 2105558.5 | 37.760832022681896 | -122.480939093689 | (37.7608320226819, -122.480939093689) | ||||
| 87143 | 87143 | 94697 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2443 Clement St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53831 | 5987960.0 | 2113267.0 | 37.7819330460656 | -122.485331246452 | (37.7819330460656, -122.485331246452) | ||
| 94217 | 94217 | 94954 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1725 Monterey Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53987 | 5992718.5 | 2095334.0 | 37.7329697745731 | -122.46756464142901 | (37.7329697745731, -122.467564641429) | ||
| 101711 | 101711 | 91489 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 430 Hamilton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2009 12:00:00 AM | 3x3 | Permit Number 52114 | 6009410.2 | 2092292.9 | 37.725569143547204 | -122.40964227476499 | (37.7255691435472, -122.409642274765) | |||
| 102787 | 102787 | 94874 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Ledyard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53943 | 6011600.0 | 2095102.0 | 37.7334048142135 | -122.402269692882 | (37.7334048142135, -122.402269692882) | ||
| 103165 | 103165 | 108498 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 762 10th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773796 | 5992905.3087 | 2110276.51424 | 37.774008838888996 | -122.468005315635 | (37.774008838889, -122.468005315635) | |
| 106314 | 106314 | 85007 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 850 Bryant St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49366 | 6010976.0 | 2110190.0 | 37.7747982776561 | -122.40548930108 | (37.7747982776561, -122.40548930108) | |||||
| 108918 | 108918 | 91235 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 470 Ramsell St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52048 | 5993008.0 | 2090300.0 | 37.719164355766 | -122.46619807183399 | (37.719164355766, -122.466198071834) | |||
| 110648 | 110648 | 94878 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 56 Ledyard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53946 | 6011673.0 | 2095004.0 | 37.73313980136 | -122.40201042294399 | (37.73313980136, -122.402010422944) | ||
| 112964 | 112964 | 89318 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450 Frederick St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2008 12:00:00 AM | 3x3 | Permit Number 51911 | 5997633.0 | 2107488.0 | 37.766624178434 | -122.451450341927 | (37.766624178434, -122.451450341927) | |||
| 114798 | 114798 | 105147 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Mirabel Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/26/2013 12:00:00 AM | 3X3 | Permit Number 771012 | 6007663.7 | 2099931.8 | 37.7464458666696 | -122.41622057503099 | (37.7464458666696, -122.416220575031) | |||
| 115262 | 115262 | 94958 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 201 San Benito Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53990 | 5992929.1 | 2095285.9 | 37.7328498609093 | -122.46683305318001 | (37.7328498609093, -122.46683305318) | ||
| 117893 | 117893 | 106553 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 213 Los Palmos Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2014 12:00:00 AM | 2.5x4 | Permit Number 771194 | 5998005.6 | 2096224.8 | 37.7357195377121 | -122.44935000292601 | (37.7357195377121, -122.449350002926) | |||
| 119175 | 119175 | 108830 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 46 Ney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | FUF 1 | 3x3 | 6003763.1265 | 2093992.4287599998 | 37.7299176091889 | -122.429284866217 | (37.7299176091889, -122.429284866217) | ||||
| 123805 | 123805 | 108831 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 46 Ney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 774658 | 6003763.1265 | 2093992.4287599998 | 37.7299176091889 | -122.429284866217 | (37.7299176091889, -122.429284866217) | |||
| 124322 | 124322 | 88528 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 771 14th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51478 | 6003493.0 | 2107743.0 | 37.7676581652647 | -122.431199833454 | (37.7676581652647, -122.431199833454) | |||
| 126268 | 126268 | 94585 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2725 Greenwich St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2010 12:00:00 AM | 3x3 | Permit Number 53761 | 5999865.0 | 2118793.0 | 37.7977923490456 | -122.44454285799999 | (37.7977923490456, -122.444542858) | |||
| 128179 | 128179 | 92032 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4232 21st St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2009 12:00:00 AM | 3x3 | Permit Number 52175 | 6001386.1 | 2103403.9 | 37.75562443672 | -122.43817644846001 | (37.75562443672, -122.43817644846) | |||
| 133299 | 133299 | 88377 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 458 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51355 | 5991270.95609 | 2112280.85053 | 37.7794176810179 | -122.47380501423599 | (37.7794176810179, -122.473805014236) | ||
| 138668 | 138668 | 89365 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 380 Benton Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2008 12:00:00 AM | 3x3 | Permit Number 51945 | 6006769.0 | 2095411.9 | 37.733984879603 | -122.418993823503 | (37.733984879603, -122.418993823503) | |||
| 140557 | 140557 | 109055 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 320 Hanover St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772693 | 5999569.6 | 2086544.4 | 37.70922872292179 | -122.443247602414 | (37.7092287229218, -122.443247602414) | |
| 143979 | 143979 | 106551 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 203 Los Palmos Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X4 | Permit Number 58742 | 5998066.5 | 2096226.6 | 37.7357279634759 | -122.449139578572 | (37.7357279634759, -122.449139578572) | ||||
| 144582 | 144582 | 94869 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Bridgeview Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53939 | 6012921.0 | 2095173.0 | 37.7336734157115 | -122.397707572671 | (37.7336734157115, -122.397707572671) | |
| 145079 | 145079 | 94876 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 48 Ledyard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53945 | 6011636.0 | 2095053.0 | 37.73327227995121 | -122.402141786329 | (37.7332722799512, -122.402141786329) | ||
| 145525 | 145525 | 108648 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 196 Lippard Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774607 | 6001751.75522 | 2094959.06379 | 37.7324576925005 | -122.436307555189 | (37.7324576925005, -122.436307555189) | |
| 73 | 73 | 65479 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1051 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1997 12:00:00 AM | 10 | 3x3 | Permit Number 28361 | 6008468.497880001 | 2115537.43749 | 37.789340533487795 | -122.41454177659901 | (37.7893405334878, -122.414541776599) |
| 1252 | 1252 | 61532 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 347 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2017 12:00:00 AM | 3 | Permit Number 772896 | 5991195.07104 | 2113068.5037599998 | 37.781575964268896 | -122.474125016615 | (37.7815759642689, -122.474125016615) | |
| 1495 | 1495 | 213442 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2455 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2002 12:00:00 AM | 6 | Width 3ft | Permit Number 45711 | 5992014.67382 | 2098752.22599 | 37.742314697659204 | -122.470246761681 | (37.7423146976592, -122.470246761681) | |
| 2424 | 2424 | 239429 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 565 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 5 | Width 2ft | Permit Number 51470 | 6001213.70363 | 2103034.08129 | 37.7545991976029 | -122.438746149019 | (37.7545991976029, -122.438746149019) | |
| 2617 | 2617 | 59596 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1401 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2014 12:00:00 AM | 0 | Permit Number 770950 | 6000181.59670606 | 2113731.76941076 | 37.7839135947641 | -122.443083674123 | (37.7839135947641, -122.443083674123) | ||
| 2636 | 2636 | 239448 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 224 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | 11 | Width 4ft | Permit Number 38139 | 6004193.01737 | 2096717.47365 | 37.7374242967807 | -122.427992792539 | (37.7374242967807, -122.427992792539) | |
| 2957 | 2957 | 238483 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 13 | Width 3ft | Permit Number 37768 | 6003709.010969999 | 2108821.61027 | 37.7706320052989 | -122.430529650538 | (37.7706320052989, -122.430529650538) | |
| 3084 | 3084 | 238169 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1018 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1989 12:00:00 AM | 2 | Width 4ft | Permit Number 27197 | 6003120.08624 | 2102266.16095 | 37.7525989407879 | -122.432098539422 | (37.7525989407879, -122.432098539422) | |
| 3100 | 3100 | 124475 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 336 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 1 | Width 3ft | Permit Number 51142 | 5996295.75285 | 2110564.44719 | 37.7749946376288 | -122.456298087251 | (37.7749946376288, -122.456298087251) | |
| 3103 | 3103 | 238168 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1010 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1989 12:00:00 AM | 14 | Width 4ft | Permit Number 27196 | 6003119.41534 | 2102323.30502 | 37.7527558068522 | -122.432104939916 | (37.7527558068522, -122.432104939916) | |
| 3188 | 3188 | 213685 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 428 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/2002 12:00:00 AM | 9 | Width 2ft | Permit Number 45997 | 6000116.1968 | 2095121.7561599999 | 37.7328113412593 | -122.44197372410801 | (37.7328113412593, -122.441973724108) | |
| 3739 | 3739 | 237154 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 861 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1992 12:00:00 AM | 5 | Width 6ft | Permit Number 30833 | 6010197.69553 | 2104230.40256 | 37.7583910361238 | -122.407761316458 | (37.7583910361238, -122.407761316458) | |
| 3846 | 3846 | 239484 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 725 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2017 12:00:00 AM | 8 | Width 3ft | Permit Number 779370 | 6007401.15098 | 2095467.39415 | 37.7341728312175 | -122.416812207728 | (37.7341728312175, -122.416812207728) | |
| 4162 | 4162 | 135980 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.58425 | 2115187.77482 | 37.7882922360442 | -122.419941763898 | (37.7882922360442, -122.419941763898) | ||
| 4456 | 4456 | 103803 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98X Hemlock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007001.17193 | 2114849.4881599997 | 37.7873690504995 | -122.419569735969 | (37.7873690504995, -122.419569735969) | ||
| 4537 | 4537 | 214730 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1999 12:00:00 AM | 8 | Width 2ft | Permit Number 41499 | 5994894.76005 | 2092775.8058599997 | 37.7260710034609 | -122.459855552309 | (37.7260710034609, -122.459855552309) | |
| 4600 | 4600 | 103784 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006741.56415 | 2115141.24736 | 37.788155522905505 | -122.420488644345 | (37.7881555229055, -122.420488644345) | ||
| 4918 | 4918 | 43245 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 150 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 9 | Permit Number 43034 | 6010460.0 | 2093774.0 | 37.729694705520004 | -122.40611748494 | (37.72969470552, -122.40611748494) | |
| 5453 | 5453 | 21659 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1750 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2015 12:00:00 AM | 3 | 4X4 | Permit Number 774105 | 6004291.1629 | 2114663.74 | 37.786706012119296 | -122.428932556586 | (37.7867060121193, -122.428932556586) | |
| 5641 | 5641 | 7950 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1735 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 3 | 3X3 | 6005696.54994 | 2116082.67925 | 37.7906815134801 | -122.424171198144 | (37.7906815134801, -122.424171198144) | ||
| 6091 | 6091 | 34255 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2280 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 6x4 | Permit Number 779106 | 6002701.36974 | 2117843.10011 | 37.7953456053627 | -122.43466028347099 | (37.7953456053627, -122.434660283471) | |
| 6734 | 6734 | 96373 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1315 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768288 | 6008912.46348 | 2117456.9297 | 37.7946359224745 | -122.41314148629499 | (37.7946359224745, -122.413141486295) | |
| 6793 | 6793 | 106875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2014 12:00:00 AM | 9 | 3x3 | Permit Number 772880 | 5999376.012619999 | 2115702.7008599997 | 37.7892792923525 | -122.446012495778 | (37.7892792923525, -122.446012495778) | |
| 6991 | 6991 | 103876 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106X Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006716.01893 | 2115511.31786 | 37.7891702054911 | -122.420603306998 | (37.7891702054911, -122.420603306998) | ||
| 7289 | 7289 | 111196 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2317 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2015 12:00:00 AM | 3 | Permit Number 775548 | 6003599.3502400005 | 2116566.69152 | 37.7918918516902 | -122.43146196059601 | (37.7918918516902, -122.431461960596) | ||
| 7328 | 7328 | 18943 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2799X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769995 | 6001475.92192 | 2115618.2324 | 37.7891670515542 | -122.438741019305 | (37.7891670515542, -122.438741019305) | |
| 8130 | 8130 | 18953 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2857 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2000 12:00:00 AM | 3 | 3X3 | 6001142.520269999 | 2115568.9795 | 37.789012843016295 | -122.439891012071 | (37.7890128430163, -122.439891012071) | ||
| 8629 | 8629 | 98380 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775239 | 6001192.51464 | 2117382.3552900003 | 37.7939947472129 | -122.439848106311 | (37.7939947472129, -122.439848106311) | |
| 9028 | 9028 | 103814 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Hemlock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006931.25215 | 2114822.01169 | 37.787289668217795 | -122.41980969397 | (37.7872896682178, -122.41980969397) | ||
| 9219 | 9219 | 4233 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4000X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1995 12:00:00 AM | 3 | 3x3 | 6003879.3665122 | 2100440.460437 | 37.7476290122472 | -122.429342637933 | (37.7476290122472, -122.429342637933) | ||
| 9780 | 9780 | 65693 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3779 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 779357 | 6005288.42845233 | 2101344.00549356 | 37.7501896116955 | -122.424534439725 | (37.7501896116955, -122.424534439725) |
| 10315 | 10315 | 47259 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1487 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/11/2014 12:00:00 AM | 1 | 3x3 | Permit Number 770986 | 5989591.7291 | 2105266.36 | 37.7600604072843 | -122.479100863475 | (37.7600604072843, -122.479100863475) |
| 10329 | 10329 | 109051 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772570 | 5995048.30925 | 2086814.9244099997 | 37.7097126663738 | -122.45889335865 | (37.7097126663738, -122.45889335865) |
| 10479 | 10479 | 35851 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 500 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778923 | 6001833.39372 | 2090697.4113200002 | 37.720760799954206 | -122.435720519401 | (37.7207607999542, -122.435720519401) | |
| 10801 | 10801 | 83237 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769756 | 6004043.10746 | 2093201.4009 | 37.727761469894794 | -122.42826058457099 | (37.7277614698948, -122.428260584571) |
| 11313 | 11313 | 26979 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 538 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004789.78173 | 2093487.7597 | 37.728589968546 | -122.42569968949199 | (37.728589968546, -122.425699689492) | |||
| 11353 | 11353 | 28245 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3312 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2002 12:00:00 AM | 8 | 2X3 | 6011933.46331 | 2090279.87862 | 37.7201828704297 | -122.40077815269899 | (37.7201828704297, -122.400778152699) | ||
| 11489 | 11489 | 918 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1246 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2000 12:00:00 AM | 3 | 3x6 | 6002972.02958 | 2094203.5052200002 | 37.730452359288996 | -122.43203484674801 | (37.730452359289, -122.432034846748) | ||
| 11888 | 11888 | 108379 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Bertita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773806 | 6000690.090969999 | 2090159.58738 | 37.7192190489897 | -122.439634019098 | (37.7192190489897, -122.439634019098) |
| 11960 | 11960 | 108570 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772580 | 6010210.43031 | 2095090.8811299999 | 37.733296619935004 | -122.407073064382 | (37.733296619935, -122.407073064382) |
| 12147 | 12147 | 62165 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 38 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779350 | 6000139.34294 | 2091815.10105 | 37.723733349795 | -122.441656484657 | (37.723733349795, -122.441656484657) | |
| 12196 | 12196 | 86961 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 212 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49929 | 5993495.99209 | 2087406.2303400002 | 37.7112468999028 | -122.464301303157 | (37.7112468999028, -122.464301303157) | |
| 12339 | 12339 | 62181 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2016 12:00:00 AM | 3 | Permit Number 778619 | 6000227.937530001 | 2091768.58709 | 37.7236106804803 | -122.44134689306802 | (37.7236106804803, -122.441346893068) | |
| 12555 | 12555 | 27112 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004609.34849 | 2093526.9165 | 37.728687286881204 | -122.426326244487 | (37.7286872868812, -122.426326244487) | |||
| 12648 | 12648 | 1088 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2222 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 8 | 3X3 | 5999676.1210900005 | 2089518.7544200001 | 37.717401703502205 | -122.443092918703 | (37.7174017035022, -122.443092918703) | ||
| 12716 | 12716 | 108567 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773758 | 6009500.29517 | 2092233.5680799999 | 37.725411278805296 | -122.409326636833 | (37.7254112788053, -122.409326636833) |
| 12718 | 12718 | 109057 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 825 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772770 | 5997289.5352300005 | 2087142.99435 | 37.7107420465867 | -122.45117096298401 | (37.7107420465867, -122.451170962984) |
| 12764 | 12764 | 83412 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52320 | 6003991.38049 | 2093029.1643599998 | 37.727285619722295 | -122.428427134505 | (37.7272856197223, -122.428427134505) |
| 12882 | 12882 | 62704 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 251 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1986 12:00:00 AM | 8 | 3x3 | Permit Number 23044 | 5999960.32769 | 2091545.33962 | 37.7229824455563 | -122.442255952067 | (37.7229824455563, -122.442255952067) | |
| 13060 | 13060 | 109069 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1065 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772763 | 6002105.570119999 | 2087176.80573 | 37.7111094529054 | -122.434528092094 | (37.7111094529054, -122.434528092094) |
| 13073 | 13073 | 28301 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3336 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2003 12:00:00 AM | 8 | 3X3 | 6011974.103080001 | 2090046.14983 | 37.719543365213 | -122.400621263274 | (37.719543365213, -122.400621263274) | ||
| 13168 | 13168 | 95747 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 223 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767492 | 6002627.86341 | 2092385.97592 | 37.7254423161963 | -122.433094867748 | (37.7254423161963, -122.433094867748) |
| 13234 | 13234 | 82735 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 174 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769757 | 6003803.82611 | 2092820.0296 | 37.726700767200896 | -122.429060604385 | (37.7267007672009, -122.429060604385) |
| 13327 | 13327 | 48822 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 512 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2017 12:00:00 AM | 3 | Permit Number 46801 | 6003066.62090041 | 2102150.20608679 | 37.7522775247752 | -122.43227515114401 | (37.7522775247752, -122.432275151144) | |
| 13385 | 13385 | 108724 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 566 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773100 | 6011759.6093 | 2105732.18704 | 37.762601916479504 | -122.40246509469401 | (37.7626019164795, -122.402465094694) |
| 13745 | 13745 | 4018 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1760 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1995 12:00:00 AM | 3 | 2X3 | 6013908.29896 | 2101074.88916 | 37.7499337000814 | -122.394707332299 | (37.7499337000814, -122.394707332299) | ||
| 13866 | 13866 | 10995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016004.21156 | 2097242.6965900003 | 37.7395275952262 | -122.387192226744 | (37.7395275952262, -122.387192226744) | |||
| 14555 | 14555 | 86928 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 838 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774404 | 6011553.2134300005 | 2104436.20347 | 37.759031910124 | -122.403087784389 | (37.759031910124, -122.403087784389) | |
| 14693 | 14693 | 67488 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1117 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 773109 | 6012239.52235 | 2103185.1315 | 37.7556350439301 | -122.400626303061 | (37.7556350439301, -122.400626303061) | |
| 14945 | 14945 | 44031 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 96 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52444 | 6007775.95033 | 2109430.42042 | 37.772533203581204 | -122.41650514858699 | (37.7725332035812, -122.416505148587) | |
| 15561 | 15561 | 43296 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 589 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | Permit Number 775309 | 6013581.06232 | 2104334.57728 | 37.758865901566296 | -122.39606735184601 | (37.7588659015663, -122.396067351846) | ||
| 16838 | 16838 | 63769 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 55 Hawthorne St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2013 12:00:00 AM | 18 | 3x3 | Permit Number 768706 | 6013040.47104 | 2113998.55413 | 37.7853709106802 | -122.398615140189 | (37.7853709106802, -122.398615140189) | |
| 16975 | 16975 | 4208 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3928 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/1995 12:00:00 AM | 3 | 3X3 | 6004332.42415 | 2100461.61534 | 37.747712737955105 | -122.427777497548 | (37.7477127379551, -122.427777497548) |
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");