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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17628 | 17628 | 27516 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005758.28533 | 2101749.6847900003 | 37.75133003695179 | -122.422938473144 | (37.7513300369518, -122.422938473144) | ||
18229 | 18229 | 27514 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005755.80226 | 2101784.51034 | 37.7514255197779 | -122.422949534811 | (37.7514255197779, -122.422949534811) | ||
20141 | 20141 | 27518 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 4 | 3x3 | 6005759.73558 | 2101716.47325 | 37.751238927544605 | -122.422931097816 | (37.7512389275446, -122.422931097816) | ||
21098 | 21098 | 10199 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2X2 | 6005752.31611 | 2101874.30524 | 37.7516718791661 | -122.42296797178801 | (37.7516718791661, -122.422967971788) | |||
21994 | 21994 | 27517 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005756.59865 | 2101732.46517 | 37.7512826606677 | -122.422943082157 | (37.7512826606677, -122.422943082157) | ||
96153 | 96153 | 50932 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1215 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47428 | 5990544.32078517 | 2103795.24406769 | 37.7560763890307 | -122.475698913277 | (37.7560763890307, -122.475698913277) | ||
140830 | 140830 | 54268 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1222 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1972 12:00:00 AM | Permit Number 10021 | 5993326.74641966 | 2107159.12142855 | 37.7654736346922 | -122.46632089692 | (37.7654736346922, -122.46632089692) | |||
17409 | 17409 | 4836 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 123 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2000 12:00:00 AM | 6 | 3X3 | 6006379.67825 | 2097659.7420099997 | 37.7401350234134 | -122.420499335499 | (37.7401350234134, -122.420499335499) | ||
141091 | 141091 | 47005 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 124 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45003 | 6004800.11223501 | 2108943.4032862997 | 37.771028169009995 | -122.426764190216 | (37.77102816901, -122.426764190216) | |||
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) |
38896 | 38896 | 62496 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2003 12:00:00 AM | 13 | Permit Number 22668 | 6000676.96581 | 2092453.0598400002 | 37.7255156559072 | -122.439843736499 | (37.7255156559072, -122.439843736499) | |
119880 | 119880 | 94825 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1255 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53905 | 5990438.0 | 2106842.5 | 37.764437175462 | -122.476289179121 | (37.764437175462, -122.476289179121) | |
93511 | 93511 | 67139 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1256 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778711 | 5995503.40408063 | 2107002.8233616003 | 37.765169831893104 | -122.45878106616199 | (37.7651698318931, -122.458781066162) |
124053 | 124053 | 94834 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1256 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53912 | 5993662.6 | 2106952.2 | 37.7649248555896 | -122.465144234508 | (37.7649248555896, -122.465144234508) | |
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) | |
99134 | 99134 | 92496 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1268 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53913 | 5993659.7 | 2106862.4 | 37.7646781211284 | -122.465147741843 | (37.7646781211284, -122.465147741843) | |
100940 | 100940 | 47001 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 127 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | Permit Number 45001 | 6004764.4 | 2108902.6 | 37.770914113875605 | -122.426884813577 | (37.7709141138756, -122.426884813577) | ||
142825 | 142825 | 47000 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 127 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | Permit Number 45000 | 6004753.51907903 | 2108901.08928055 | 37.770909350568296 | -122.42692234337099 | (37.7709093505683, -122.426922343371) | ||
30704 | 30704 | 43671 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 128 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 12 | Permit Number 43314 | 5995229.94076 | 2114692.20799 | 37.786267125837796 | -122.460284069366 | (37.7862671258378, -122.460284069366) | |
163806 | 163806 | 31987 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 128 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/2004 12:00:00 AM | 11 | Permit Number 35387 | 5994614.2845 | 2114627.8658 | 37.7860550266291 | -122.462409396175 | (37.7860550266291, -122.462409396175) | |
140778 | 140778 | 108402 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1285 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772748 | 6010079.79191 | 2101731.52319 | 37.7515230698123 | -122.407992860037 | (37.7515230698123, -122.407992860037) |
18339 | 18339 | 3945 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 129 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2000 12:00:00 AM | 6 | 3X3 | 6002246.22679 | 2107489.51068 | 37.7668914137434 | -122.435494123149 | (37.7668914137434, -122.435494123149) | ||
21301 | 21301 | 3944 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 129 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/1999 12:00:00 AM | 6 | 3X3 | 6002248.02502 | 2107476.74068 | 37.7668564525859 | -122.435486989749 | (37.7668564525859, -122.435486989749) | ||
171041 | 171041 | 65739 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 12 | Permit Number 28675 | 5999799.15568 | 2087425.51821 | 37.7116611636025 | -122.442517443427 | (37.7116611636025, -122.442517443427) | |
106528 | 106528 | 67499 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Marston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53740 | 5998608.31510896 | 2093230.29306516 | 37.7275317862578 | -122.44705076184601 | (37.7275317862578, -122.447050761846) | |
129160 | 129160 | 40530 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45382 | 5993353.73347688 | 2094704.41991722 | 37.7312777588569 | -122.46532277558998 | (37.7312777588569, -122.46532277559) | ||
114995 | 114995 | 94828 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1307 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53906 | 5994508.7 | 2106601.7 | 37.7640112277419 | -122.462192388622 | (37.7640112277419, -122.462192388622) | |
122446 | 122446 | 67082 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 770232 | 6007172.1618472 | 2097205.87642653 | 37.738933437859394 | -122.417727080669 | (37.7389334378594, -122.417727080669) | ||
173547 | 173547 | 37340 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 10 | Permit Number 39848 | 6000626.60293 | 2087367.0099799999 | 37.7115476439893 | -122.43965337791799 | (37.7115476439893, -122.439653377918) | |
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) |
649 | 649 | 96374 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1315 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768288 | 6008916.2106800005 | 2117429.1962900003 | 37.7945599836999 | -122.41312655846599 | (37.7945599836999, -122.413126558466) | |
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) | |
109340 | 109340 | 47007 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45005 | 6003838.67811356 | 2108860.89265049 | 37.770747209817294 | -122.43008393306499 | (37.7707472098173, -122.430083933065) | |||
20524 | 20524 | 26480 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2011 12:00:00 AM | 3 | 3x3 | 6001160.50342 | 2098677.8339 | 37.742634955228894 | -122.438618011821 | (37.7426349552289, -122.438618011821) | ||
150010 | 150010 | 57783 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/1977 12:00:00 AM | 5 | Permit Number 16708 | 6010300.606980001 | 2110589.59695 | 37.7758576905205 | -122.407853819819 | (37.7758576905205, -122.407853819819) | ||
84414 | 84414 | 26169 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1320 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2004 12:00:00 AM | 8 | 3X3 | 6005780.5723577 | 2101269.3137616003 | 37.750012306137 | -122.422827266036 | (37.750012306137, -122.422827266036) | ||
80326 | 80326 | 91975 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1320X 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993343.893066 | 2106486.203602 | 37.763626968645504 | -122.46621268437 | (37.7636269686455, -122.46621268437) | ||
117803 | 117803 | 91976 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1320X 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993343.893066 | 2106486.203602 | 37.763626968645504 | -122.46621268437 | (37.7636269686455, -122.46621268437) | ||
98755 | 98755 | 47002 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 133 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | Permit Number 45001 | 6004750.78049806 | 2108920.69040717 | 37.77096301566829 | -122.426933212426 | (37.7709630156683, -122.426933212426) | ||
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) | |
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) | |
83891 | 83891 | 36249 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 134 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1978 12:00:00 AM | Permit Number 39267 | 6002197.13789926 | 2096205.20394281 | 37.735904603360794 | -122.43485684800899 | (37.7359046033608, -122.434856848009) | |||
112791 | 112791 | 23845 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1360 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2001 12:00:00 AM | 8 | 3X3 | 6003737.7759918 | 2113383.7091882997 | 37.7831600307032 | -122.43075576300899 | (37.7831600307032, -122.430755763009) | ||
18631 | 18631 | 10219 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1361 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2002 12:00:00 AM | 6 | 3X3 | 6005865.11973 | 2101072.64646 | 37.7494770729178 | -122.422520923317 | (37.7494770729178, -122.422520923317) | ||
84751 | 84751 | 82096 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1363 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52338 | 6004802.97001971 | 2120513.88344233 | 37.802797975517294 | -122.42757877147899 | (37.8027979755173, -122.427578771479) | ||
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) | |
165571 | 165571 | 30804 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 137 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 14 | Permit Number 34669 | 6001616.65191 | 2095326.1919200001 | 37.733458064439 | -122.43680091003401 | (37.733458064439, -122.436800910034) | |
81130 | 81130 | 47147 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 138 Aptos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/2002 12:00:00 AM | Permit Number 45119 | 5992930.24436849 | 2094060.37682206 | 37.7294849440246 | -122.466740042815 | (37.7294849440246, -122.466740042815) | ||
90978 | 90978 | 47146 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 138 Aptos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/2002 12:00:00 AM | Permit Number 45119 | 5992930.24436849 | 2094060.37682206 | 37.7294849440246 | -122.466740042815 | (37.7294849440246, -122.466740042815) | ||
126699 | 126699 | 51677 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1398X 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2005 12:00:00 AM | 10 | 3x3 | Permit Number 47956 | 5993492.40184836 | 2105988.6022895 | 37.762269253020705 | -122.46566288928301 | (37.7622692530207, -122.465662889283) | |
123594 | 123594 | 91396 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2009 12:00:00 AM | 3x3 | Permit Number 52091 | 5996731.3 | 2091236.4 | 37.7219496073249 | -122.453395686079 | (37.7219496073249, -122.453395686079) | ||
38249 | 38249 | 64864 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Parsons St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 15 | Permit Number 25882 | 5996577.342130001 | 2110690.66447 | 37.775357357934205 | -122.45533313851999 | (37.7753573579342, -122.45533313852) | |
71686 | 71686 | 237107 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | 9 | Width 4ft | Permit Number 39047 | 6006621.1232900005 | 2105778.70866 | 37.7624414540443 | -122.42024059875 | (37.7624414540443, -122.42024059875) | |
125874 | 125874 | 95196 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 140 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2011 12:00:00 AM | 20 | 3x3 | Permit Number 767111 | 5992360.0 | 2098167.1 | 37.740728049154896 | -122.46901016645201 | (37.7407280491549, -122.469010166452) | |
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) | ||
116241 | 116241 | 48973 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1409 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2002 12:00:00 AM | 10 | 3x3 | Permit Number 46160 | 5992699.25598435 | 2105862.87116543 | 37.7618782478409 | -122.468396910406 | (37.7618782478409, -122.468396910406) |
145594 | 145594 | 46257 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1409 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2002 12:00:00 AM | 10 | 3x3 | Permit Number 44541 | 5992686.9 | 2105815.5 | 37.7617474653886 | -122.46843619791001 | (37.7617474653886, -122.46843619791) | |
19214 | 19214 | 10228 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1411 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2002 12:00:00 AM | 6 | 3X3 | 6005886.64477 | 2100667.53648 | 37.7483659479448 | -122.422417708118 | (37.7483659479448, -122.422417708118) | ||
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) | ||
104746 | 104746 | 52158 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1418 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | Permit Number 48350 | 6015559.23625291 | 2093031.45294248 | 37.727939717782895 | -122.388436912151 | (37.7279397177829, -122.388436912151) | ||
139643 | 139643 | 47148 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Aptos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | Permit Number 45120 | 5992914.30575006 | 2094031.34205886 | 37.72940430187629 | -122.466793033912 | (37.7294043018763, -122.466793033912) | ||
75951 | 75951 | 62499 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | 11 | Permit Number 22673 | 6000619.30471 | 2092428.3217900002 | 37.725444448481 | -122.440041292395 | (37.725444448481, -122.440041292395) | |
74464 | 74464 | 40637 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Russ St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1999 12:00:00 AM | 13 | Permit Number 41636 | 6010361.026959999 | 2111479.7034299998 | 37.7783050974438 | -122.407707586435 | (37.7783050974438, -122.407707586435) | ||
38699 | 38699 | 52528 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | 7 | Permit Number 48628 | 6001332.37944 | 2092272.13723 | 37.725056169781205 | -122.437565081984 | (37.7250561697812, -122.437565081984) | ||
95776 | 95776 | 47315 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1420 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | Permit Number 45244 | 6010384.18455371 | 2100995.83638931 | 37.7495200736312 | -122.406888381765 | (37.7495200736312, -122.406888381765) | ||
124587 | 124587 | 47313 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1420 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | Permit Number 45244 | 6010384.18455371 | 2100995.83638931 | 37.7495200736312 | -122.406888381765 | (37.7495200736312, -122.406888381765) | ||
125280 | 125280 | 47314 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1420 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | 2 | Permit Number 45244 | 6010384.18455371 | 2100995.83638931 | 37.7495200736312 | -122.406888381765 | (37.7495200736312, -122.406888381765) | |
106120 | 106120 | 50757 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1424 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2004 12:00:00 AM | 3x3 | Permit Number 47297 | 6000982.34687807 | 2110734.59068474 | 37.77572972876379 | -122.44009838927799 | (37.7757297287638, -122.440098389278) | ||
21329 | 21329 | 16625 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 143 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2007 12:00:00 AM | 3 | 3x3 | 6002893.733109999 | 2107470.63526 | 37.7668763401938 | -122.43325315650401 | (37.7668763401938, -122.433253156504) | ||
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) | ||||
22977 | 22977 | 109971 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1435 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2015 12:00:00 AM | 3 | 3x3 | 5999653.8 | 2113835.4 | 37.7841680297741 | -122.444917101722 | (37.7841680297741, -122.444917101722) | ||
95000 | 95000 | 36601 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1436 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2004 12:00:00 AM | Permit Number 46996 | 6009536.9669184005 | 2100854.59683239 | 37.749084817998096 | -122.40980812962 | (37.7490848179981, -122.40980812962) | ||
37085 | 37085 | 43877 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 144 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2000 12:00:00 AM | 7 | Permit Number 43492 | 6003098.49585 | 2092711.51751 | 37.726362865838 | -122.431491164302 | (37.726362865838, -122.431491164302) | ||
91518 | 91518 | 69086 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1466 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53819 | 5992143.8934222 | 2105465.60262386 | 37.7607553597545 | -122.47028874127399 | (37.7607553597545, -122.470288741274) | |
32843 | 32843 | 31989 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 6 | Permit Number 35389 | 5994568.75053 | 2114560.8648099997 | 37.78586843793 | -122.462562068449 | (37.78586843793, -122.462562068449) | |
186222 | 186222 | 56305 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1973 12:00:00 AM | 6 | Permit Number 12437 | 5993019.12779 | 2114510.13973 | 37.785639797963704 | -122.467919595671 | (37.7856397979637, -122.467919595671) | ||
145644 | 145644 | 102844 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1471 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2013 12:00:00 AM | 3x3 | Permit Number 770146 | 6003321.0 | 2099676.0 | 37.7454983546222 | -122.431218877952 | (37.7454983546222, -122.431218877952) | ||
86371 | 86371 | 67729 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1475 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/2014 12:00:00 AM | 3x3 | Permit Number 771981 | 5991458.91301226 | 2105384.63302746 | 37.760493412232 | -122.472651855625 | (37.760493412232, -122.472651855625) | |
36774 | 36774 | 69416 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 148 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 2 | Permit Number 33521 | 6001460.481240001 | 2087339.3254900002 | 37.7115190554232 | -122.436769298869 | (37.7115190554232, -122.436769298869) | |
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) | |
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) |
147925 | 147925 | 69417 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 149 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 7 | Permit Number 33522 | 6001453.459840001 | 2087297.44526 | 37.7114036625088 | -122.436790570551 | (37.7114036625088, -122.436790570551) | |
145898 | 145898 | 96036 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1498 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767675 | 6006383.0 | 2118353.0 | 37.7969539806541 | -122.421957458925 | (37.7969539806541, -122.421957458925) | |
85838 | 85838 | 58303 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 150 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 772898 | 5999424.90355926 | 2107324.72926963 | 37.766278324847605 | -122.445240741314 | (37.7662783248476, -122.445240741314) | ||
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) | |
171618 | 171618 | 68224 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1500 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2012 12:00:00 AM | 1 | Permit Number 769229 | 5990833.387490001 | 2113424.07906 | 37.782531317215295 | -122.47540222511999 | (37.7825313172153, -122.47540222512) | |
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) | |||
22921 | 22921 | 187655 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1548 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779523 | 6003789.0 | 2099328.0 | 37.744569337434 | -122.42957579341999 | (37.744569337434, -122.42957579342) | |
160545 | 160545 | 52065 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 155 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/2006 12:00:00 AM | 3 | Permit Number 48260 | 5994571.97803 | 2114501.44364 | 37.7857054693715 | -122.462546590502 | (37.7857054693715, -122.462546590502) | |
37021 | 37021 | 52927 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 155 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 7 | Permit Number 48911 | 6000347.40158 | 2092558.92243 | 37.7257875650324 | -122.44099059964199 | (37.7257875650324, -122.440990599642) | |
91148 | 91148 | 94157 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1552 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53538 | 5993733.5 | 2104914.7 | 37.7593345004852 | -122.464751039907 | (37.7593345004852, -122.464751039907) | ||
45985 | 45985 | 84283 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 156 Tioga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50701 | 6010175.00365 | 2089148.86152 | 37.7169790922895 | -122.40677692123501 | (37.7169790922895, -122.406776921235) | |
153524 | 153524 | 84212 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 156 Tioga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50701 | 6010164.59248 | 2089152.68925 | 37.7169890199119 | -122.406813177404 | (37.7169890199119, -122.406813177404) | |
121235 | 121235 | 108310 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1563 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | 5986200.157869999 | 2104606.03112 | 37.7580497793679 | -122.49078193256099 | (37.7580497793679, -122.490781932561) | |||
96866 | 96866 | 46685 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1563 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2016 12:00:00 AM | Permit Number 776034 | 5992114.70084954 | 2104801.75310053 | 37.758930915917 | -122.470341358559 | (37.758930915917, -122.470341358559) | ||
84842 | 84842 | 64782 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 158 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53736 | 5999914.43925974 | 2109028.32439413 | 37.7709839002497 | -122.443669932593 | (37.7709839002497, -122.443669932593) | |
125150 | 125150 | 114800 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1587 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2015 12:00:00 AM | Permit Number 770932 | 5990525.1 | 2104605.1 | 37.758298924152705 | -122.475824523864 | (37.7582989241527, -122.475824523864) | |||
177958 | 177958 | 45540 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 159 Middlefield Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44295 | 5987294.0576 | 2094889.97142 | 37.7314359091244 | -122.48628552285801 | (37.7314359091244, -122.486285522858) | |
131821 | 131821 | 84213 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 159 Tioga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50702 | 6010145.69333 | 2089116.11525 | 37.716887537712005 | -122.406875926694 | (37.716887537712, -122.406875926694) |
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");