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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
156176 | 156176 | 44741 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 271 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 3 | Permit Number 43859 | 5992054.55445 | 2086618.7004799999 | 37.7090013413078 | -122.46922594483601 | (37.7090013413078, -122.469225944836) | |
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) | |
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) | |
178402 | 178402 | 31022 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 330 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 8 | Permit Number 34788 | 6002783.56511 | 2086520.12567 | 37.7093448166924 | -122.43213791266001 | (37.7093448166924, -122.43213791266) | |
73045 | 73045 | 31021 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 317 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34787 | 6002776.11429 | 2086581.1916200002 | 37.7095120680942 | -122.432168021935 | (37.7095120680942, -122.432168021935) | |
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) |
157300 | 157300 | 57927 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 559 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1977 12:00:00 AM | 3 | Permit Number 16885 | 5999203.256130001 | 2086855.58023 | 37.7100622571339 | -122.444536089569 | (37.7100622571339, -122.444536089569) | ||
97508 | 97508 | 108899 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 16 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772775 | 6000547.04329 | 2086890.00633 | 37.710233369404605 | -122.43989417722 | (37.7102333694046, -122.43989417722) |
105452 | 105452 | 37342 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 507 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 15 | Permit Number 39850 | 5999504.92576 | 2086983.7691900001 | 37.71043144412221 | -122.44350266602801 | (37.7104314441222, -122.443502666028) | |
28887 | 28887 | 84197 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 551 Sawyer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50697 | 6007614.52495 | 2086883.3270299998 | 37.7106148095844 | -122.41546698201 | (37.7106148095844, -122.41546698201) | |
82049 | 82049 | 69397 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1137 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | Permit Number 772744 | 6001523.93675849 | 2087030.79827901 | 37.7106755138649 | -122.436527911504 | (37.7106755138649, -122.436527911504) | |
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) |
80030 | 80030 | 84222 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1099 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50699 | 6008536.64493866 | 2086928.58742632 | 37.710790872531796 | -122.412283117187 | (37.7107908725318, -122.412283117187) | ||
93504 | 93504 | 84211 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1099 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50699 | 6008536.64493866 | 2086928.58742632 | 37.710790872531796 | -122.412283117187 | (37.7107908725318, -122.412283117187) | ||
141941 | 141941 | 84223 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1099 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50699 | 6008536.64493866 | 2086928.58742632 | 37.710790872531796 | -122.412283117187 | (37.7107908725318, -122.412283117187) | ||
92213 | 92213 | 99888 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5646 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.710904770255105 | -122.44766369700199 | (37.7109047702551, -122.447663697002) | ||
102810 | 102810 | 99892 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5646@ Whipple Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.710904770255105 | -122.44766369700199 | (37.7109047702551, -122.447663697002) | ||
103926 | 103926 | 99890 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5646@ Whipple Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.710904770255105 | -122.44766369700199 | (37.7109047702551, -122.447663697002) | ||
111780 | 111780 | 99887 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5646 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.710904770255105 | -122.44766369700199 | (37.7109047702551, -122.447663697002) | ||
139392 | 139392 | 99891 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5646@ Whipple Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.710904770255105 | -122.44766369700199 | (37.7109047702551, -122.447663697002) | ||
146325 | 146325 | 99889 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5646@ Whipple Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.710904770255105 | -122.44766369700199 | (37.7109047702551, -122.447663697002) | ||
135851 | 135851 | 31058 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 6 | Permit Number 34809 | 6002732.75221 | 2087097.44922 | 37.71092714054029 | -122.432354735598 | (37.7109271405403, -122.432354735598) | |
139522 | 139522 | 51976 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 163 Rae Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2005 12:00:00 AM | Permit Number 48195 | 5997753.64161846 | 2087210.79293758 | 37.710954767676704 | -122.449571795733 | (37.7109547676767, -122.449571795733) | |||
163282 | 163282 | 31057 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 5 | Permit Number 34809 | 6002747.277969999 | 2087115.5773200002 | 37.7109777400017 | -122.43230582505 | (37.7109777400017, -122.43230582505) | |
72980 | 72980 | 69395 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1075 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33499 | 6002066.46838 | 2087158.9447 | 37.711058190666705 | -122.43466196070801 | (37.7110581906667, -122.434661960708) | |
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) |
52624 | 52624 | 86960 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 208 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49928 | 5993493.7535 | 2087361.9529 | 37.71112519553311 | -122.464305827668 | (37.7111251955331, -122.464305827668) | |
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) | |
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) | |
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) | |
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) | |
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) | |
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) | |
106738 | 106738 | 95016 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 83 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010516.6 | 2087234.5 | 37.7117417518759 | -122.405461434977 | (37.7117417518759, -122.405461434977) | |||
81667 | 81667 | 44392 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X ATHENS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2001 12:00:00 AM | Permit Number 43750 | 6001492.0 | 2087581.0 | 37.7121844315022 | -122.436677650137 | (37.7121844315022, -122.436677650137) | |||
102329 | 102329 | 44394 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X ATHENS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2001 12:00:00 AM | Permit Number 43750 | 6001492.0 | 2087581.0 | 37.7121844315022 | -122.436677650137 | (37.7121844315022, -122.436677650137) | |||
121911 | 121911 | 44393 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X ATHENS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2001 12:00:00 AM | Permit Number 43750 | 6001492.0 | 2087581.0 | 37.7121844315022 | -122.436677650137 | (37.7121844315022, -122.436677650137) | |||
87906 | 87906 | 95006 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 195 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2013 12:00:00 AM | 3 | 3x3 | 6009968.4 | 2087457.4 | 37.7123231225616 | -122.407371876718 | (37.7123231225616, -122.407371876718) | ||
26523 | 26523 | 88167 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 189 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 51184 | 6010014.6058 | 2087504.2072 | 37.7124542316575 | -122.40721547231199 | (37.7124542316575, -122.407215472312) | |
129707 | 129707 | 48506 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 45 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 5 | Permit Number 45843 | 6001715.61599 | 2087735.00145 | 37.71261999108761 | -122.43591578108999 | (37.7126199910876, -122.43591578109) | ||
24585 | 24585 | 49743 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 114 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 8 | Permit Number 46542 | 6010621.23603 | 2087831.01483 | 37.7133855110935 | -122.405141759495 | (37.7133855110935, -122.405141759495) | |
174698 | 174698 | 49745 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 34@ LELAND Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 4 | Permit Number 46544 | 6008556.3350599995 | 2087877.23988 | 37.7133967814171 | -122.41228206988899 | (37.7133967814171, -122.412282069889) | |
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) | |
151932 | 151932 | 55259 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1972 12:00:00 AM | 8 | Permit Number 11181 | 6008604.18987 | 2088002.78931 | 37.7137441994136 | -122.41212553387501 | (37.7137441994136, -122.412125533875) | ||
107563 | 107563 | 86870 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 602 Randolph St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2007 12:00:00 AM | 3x3 | Permit Number 49803 | 5992443.0 | 2088555.0 | 37.7143403939216 | -122.46802418223301 | (37.7143403939216, -122.468024182233) | ||
115044 | 115044 | 86869 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 602 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2007 12:00:00 AM | 3x3 | Permit Number 49803 | 5992443.0 | 2088555.0 | 37.7143403939216 | -122.46802418223301 | (37.7143403939216, -122.468024182233) | ||
141542 | 141542 | 86868 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 602 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2007 12:00:00 AM | 3x3 | Permit Number 49803 | 5992443.0 | 2088555.0 | 37.7143403939216 | -122.46802418223301 | (37.7143403939216, -122.468024182233) | ||
70594 | 70594 | 41410 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 531 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2000 12:00:00 AM | 5 | Permit Number 42023 | 6007957.48629 | 2088255.0601400002 | 37.714400574992204 | -122.414378624292 | (37.7144005749922, -122.414378624292) | ||
156931 | 156931 | 48689 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 455 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2002 12:00:00 AM | 2 | Permit Number 45968 | 6008469.24313 | 2088342.73235 | 37.714670039767 | -122.412615977341 | (37.714670039767, -122.412615977341) | ||
56762 | 56762 | 49698 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 87@ TUCKER Alpha St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50825 | 6011117.29096 | 2088288.9421 | 37.7146706063491 | -122.403459407649 | (37.7146706063491, -122.403459407649) | |
182777 | 182777 | 49699 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 87@ TUCKER Alpha St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50825 | 6011128.67682 | 2088300.86402 | 37.7147039774881 | -122.403420891467 | (37.7147039774881, -122.403420891467) | |
84033 | 84033 | 48563 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 53 Byxbee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | Permit Number 45982 | 5991907.82184104 | 2088893.56567496 | 37.715239092234704 | -122.469898587444 | (37.7152390922347, -122.469898587444) | ||
102147 | 102147 | 46749 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 511 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44851 | 5992686.05826903 | 2089167.34064678 | 37.7160357673292 | -122.46722858069799 | (37.7160357673292, -122.467228580698) | ||
124864 | 124864 | 46734 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 315 Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2002 12:00:00 AM | Permit Number 44844 | 5993734.25176167 | 2089288.64398892 | 37.716429290025104 | -122.463614355193 | (37.7164292900251, -122.463614355193) | ||
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) | |
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) | |
95112 | 95112 | 28260 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3562 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2003 12:00:00 AM | 12 | 3x3 | 6012130.0554759 | 2089144.2345931 | 37.717075584405706 | -122.400018884967 | (37.7170755844057, -122.400018884967) | ||
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) | |
170473 | 170473 | 82703 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 67 Jennings Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52500 | 6012950.17329 | 2089208.10371 | 37.71729664739521 | -122.39718858698 | (37.7172966473952, -122.39718858698) | |
95982 | 95982 | 82672 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 69 Jennings Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 3x3 | Permit Number 52500 | 6012954.77206528 | 2089215.57064421 | 37.7173174061263 | -122.397173214353 | (37.7173174061263, -122.397173214353) | ||
101879 | 101879 | 95736 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 754 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767483 | 6001940.3 | 2089463.6 | 37.71737910133729 | -122.435262770583 | (37.7173791013373, -122.435262770583) | |
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) | ||
53191 | 53191 | 102037 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
87806 | 87806 | 102038 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
124779 | 124779 | 102039 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
146079 | 146079 | 102036 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
80258 | 80258 | 82918 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52501 | 6013030.57044013 | 2089280.70970627 | 37.717500484481704 | -122.396915777424 | (37.7175004844817, -122.396915777424) | |
86778 | 86778 | 82919 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 863 Meade Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52463 | 6013030.57044013 | 2089280.70970627 | 37.717500484481704 | -122.396915777424 | (37.7175004844817, -122.396915777424) | ||
120968 | 120968 | 82634 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 863 Meade Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52463 | 6013030.57044013 | 2089280.70970627 | 37.717500484481704 | -122.396915777424 | (37.7175004844817, -122.396915777424) | ||
129448 | 129448 | 82702 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 863 Meade Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52463 | 6013030.57044013 | 2089280.70970627 | 37.717500484481704 | -122.396915777424 | (37.7175004844817, -122.396915777424) | ||
142036 | 142036 | 82701 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 863 Meade Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52463 | 6013030.57044013 | 2089280.70970627 | 37.717500484481704 | -122.396915777424 | (37.7175004844817, -122.396915777424) | ||
102312 | 102312 | 46754 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 382 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/2002 12:00:00 AM | Permit Number 44856 | 5993270.59448238 | 2089720.53231804 | 37.717588424473604 | -122.465248322339 | (37.7175884244736, -122.465248322339) | ||
81369 | 81369 | 48567 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 482 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | Permit Number 45986 | 5994053.29361641 | 2089800.73897296 | 37.7178537586229 | -122.462548722634 | (37.7178537586229, -122.462548722634) | ||
127286 | 127286 | 98361 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 729 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2012 12:00:00 AM | 2x3 | Permit Number 768618 | 5994749.5 | 2089887.4 | 37.7181317785027 | -122.46014853713699 | (37.7181317785027, -122.460148537137) | ||
87051 | 87051 | 95735 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 700 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767482 | 6002113.5 | 2089738.7 | 37.7181442990561 | -122.43468376004999 | (37.7181442990561, -122.43468376005) | |
10340 | 10340 | 28256 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3476 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2003 12:00:00 AM | 6 | 3x3 | 6012060.981000001 | 2089540.1901200002 | 37.7181589470551 | -122.400285438425 | (37.7181589470551, -122.400285438425) | ||
187355 | 187355 | 50504 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 671 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 9 | Permit Number 47140 | 6001297.56946 | 2089761.94857 | 37.7181617790314 | -122.437505740198 | (37.7181617790314, -122.437505740198) | |
153971 | 153971 | 50505 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 671 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 7 | Permit Number 47140 | 6001286.63286 | 2089768.4439299998 | 37.7181789920349 | -122.43754400816002 | (37.7181789920349, -122.43754400816) | |
77358 | 77358 | 47252 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1001 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767654 | 6013117.42744406 | 2089558.25653077 | 37.718267407089 | -122.39663499597201 | (37.718267407089, -122.396634995972) | |
81215 | 81215 | 53899 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1057 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2009 12:00:00 AM | Permit Number 52970 | 6011224.04910165 | 2089865.72837227 | 37.7190061040508 | -122.403201256455 | (37.7190061040508, -122.403201256455) | |||
25348 | 25348 | 50499 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 608 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 5 | Permit Number 47136 | 6002721.49496 | 2090080.38174 | 37.719116979545795 | -122.432606577246 | (37.7191169795458, -122.432606577246) | |
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) | |||
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) |
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) | ||
90593 | 90593 | 50487 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 247 Louisburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47123 | 5997593.4002378 | 2090478.75871424 | 37.719918679369606 | -122.45036104889799 | (37.7199186793696, -122.450361048898) | ||
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) | ||
137613 | 137613 | 50785 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 525 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2004 12:00:00 AM | 11 | Permit Number 47311 | 6001785.39603 | 2090541.73065 | 37.72033060925639 | -122.435875299 | (37.7203306092564, -122.435875299) | ||
148458 | 148458 | 65791 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 523 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1990 12:00:00 AM | 7 | Permit Number 28759 | 6001804.02439 | 2090571.26735 | 37.7204127686105 | -122.43581301917801 | (37.7204127686105, -122.435813019178) | ||
107981 | 107981 | 95644 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 518 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/2011 12:00:00 AM | 3x3 | Permit Number 767414 | 6003055.0 | 2090608.0 | 37.7205846102013 | -122.431491425064 | (37.7205846102013, -122.431491425064) | |
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) | |
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) | ||
100494 | 100494 | 97562 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 182 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2012 12:00:00 AM | Permit Number 768967 | 5994515.7 | 2091119.6 | 37.7215016543215 | -122.461045939781 | (37.7215016543215, -122.461045939781) | |||
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) | ||
148683 | 148683 | 46833 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 471 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | 9 | Permit Number 44906 | 6002821.93172 | 2091174.08119 | 37.7221257307043 | -122.4323374767 | (37.7221257307043, -122.4323374767) | |
131388 | 131388 | 37775 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 718 Dwight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 16 | Permit Number 40113 | 6009462.43641 | 2091064.86672 | 37.722200148706605 | -122.40937507161699 | (37.7222001487066, -122.409375071617) | |
41715 | 41715 | 52943 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 428 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 4 | Permit Number 48930 | 6000112.39427 | 2091327.92801 | 37.722394148651 | -122.44171469507299 | (37.722394148651, -122.441714695073) | |
153792 | 153792 | 68094 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 51 Wanda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 7 | Permit Number 31838 | 6000539.95972 | 2091455.5942900002 | 37.7227690436428 | -122.440245854872 | (37.7227690436428, -122.440245854872) | |
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) | ||
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) |
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");