Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 62495 | 62495 | 118286 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 199X JULES AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Fire Dept 12 | 3x3 | 5994418.0 | 2091201.0 | 37.7217195365393 | -122.461389557582 | (37.7217195365393, -122.461389557582) | |||
| 112977 | 112977 | 118285 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 199X JULES AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Fire Dept 12 | 3x3 | 5994418.0 | 2091201.0 | 37.7217195365393 | -122.461389557582 | (37.7217195365393, -122.461389557582) | |||
| 51131 | 51131 | 90608 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2730 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 02/18/2008 12:00:00 AM | 3 | 3x3 | 5987165.187837999 | 2110514.57925 | 37.7743293423662 | -122.487878603265 | (37.7743293423662, -122.487878603265) | |
| 77531 | 77531 | 90600 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2626 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5987485.847424 | 2110526.216966 | 37.7743799956733 | -122.48677025153098 | (37.7743799956733, -122.486770251531) | |
| 77805 | 77805 | 89626 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3645X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987384.941021 | 2111843.8709319998 | 37.7779920191565 | -122.48721610074499 | (37.7779920191565, -122.487216100745) | |
| 92040 | 92040 | 89625 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3645X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987384.941021 | 2111843.8709319998 | 37.7779920191565 | -122.48721610074499 | (37.7779920191565, -122.487216100745) | |
| 95754 | 95754 | 90925 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3849X Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5986753.433769001 | 2111821.240765 | 37.7778930383067 | -122.489399014928 | (37.7778930383067, -122.489399014928) | |
| 97317 | 97317 | 89627 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3645X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987384.941021 | 2111843.8709319998 | 37.7779920191565 | -122.48721610074499 | (37.7779920191565, -122.487216100745) | |
| 103835 | 103835 | 86347 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2385 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 12/18/2006 12:00:00 AM | 6 | 3x3 | 5988561.573064 | 2099100.588411 | 37.7430709645331 | -122.48221190478901 | (37.7430709645331, -122.482211904789) | |
| 109181 | 109181 | 90915 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3228 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5988669.966739 | 2111929.945878 | 37.7783032057889 | -122.482777102874 | (37.7783032057889, -122.482777102874) | |
| 110381 | 110381 | 89471 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3828 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5986811.689623999 | 2111863.354052 | 37.7780120700323 | -122.48920058722601 | (37.7780120700323, -122.489200587226) | |
| 115329 | 115329 | 90636 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3112 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985977.353735 | 2110471.4693 | 37.7741416146835 | -122.49198430858401 | (37.7741416146835, -122.491984308584) | |
| 140471 | 140471 | 89620 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3745 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987075.727746 | 2111832.790252 | 37.7779435589789 | -122.48828495071001 | (37.7779435589789, -122.48828495071) | |
| 1043 | 1043 | 81845 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1421 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 04/28/2017 08:33:00 AM | 3 | 3x3 | Permit Number 50020 | 6007103.87391 | 2115697.8037 | 37.789704100621705 | -122.419274608151 | (37.7897041006217, -122.419274608151) |
| 2825 | 2825 | 81846 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1421 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50020 | 6007049.49584 | 2115692.06976 | 37.7896852939829 | -122.419462344328 | (37.7896852939829, -122.419462344328) |
| 8242 | 8242 | 81844 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1421 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 09/11/2012 12:00:00 AM | 3 | 3x3 | Permit Number 50020 | 6007169.781140001 | 2115706.72596 | 37.789732310539705 | -122.419047208268 | (37.7897323105397, -122.419047208268) |
| 81617 | 81617 | 81843 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) |
| 88938 | 88938 | 82383 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1421 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 09/11/2012 12:00:00 AM | 3 | 3x3 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) | |
| 97025 | 97025 | 81841 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) |
| 100401 | 100401 | 81842 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) |
| 111252 | 111252 | 81840 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Larkin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) |
| 141753 | 141753 | 81839 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) |
| 4776 | 4776 | 97245 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301X Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/25/2017 04:18:00 PM | 3 | 4x4 | Permit Number 767495 | 6003351.72812 | 2092154.8424200001 | 37.724848709697106 | -122.43057604836099 | (37.7248487096971, -122.430576048361) |
| 4799 | 4799 | 97246 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301X Excelsior Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/25/2017 04:11:00 PM | 3 | 4x4 | Permit Number 767495 | 6003334.6314 | 2092165.82905 | 37.724877907973706 | -122.430635933307 | (37.7248779079737, -122.430635933307) |
| 11025 | 11025 | 97251 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301X Excelsior Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003227.5697 | 2092233.02297 | 37.7250563415646 | -122.43101082650499 | (37.7250563415646, -122.431010826505) |
| 11401 | 11401 | 97248 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301X Excelsior Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003299.02479 | 2092188.3041400001 | 37.724937602283504 | -122.430760624301 | (37.7249376022835, -122.430760624301) |
| 12260 | 12260 | 97249 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301X Excelsior Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003279.34346 | 2092200.52554 | 37.7249700444293 | -122.43082953217301 | (37.7249700444293, -122.430829532173) |
| 12687 | 12687 | 97250 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301X Excelsior Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003264.30376 | 2092207.6887700001 | 37.724988860924 | -122.430882033691 | (37.724988860924, -122.430882033691) |
| 25232 | 25232 | 116051 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Kansas St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 4x4 | 6011500.28754 | 2105307.1354099996 | 37.761420339490705 | -122.40333209689699 | (37.7614203394907, -122.403332096897) | ||
| 90630 | 90630 | 98561 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2035X Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | ||||
| 91242 | 91242 | 98559 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2035X Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | ||||
| 126599 | 126599 | 98562 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2035X Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | ||||
| 141315 | 141315 | 98560 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2035X Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | ||||
| 141465 | 141465 | 97247 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301X Excelsior Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003399.0 | 2092092.0 | 37.7246788362927 | -122.43040815339701 | (37.7246788362927, -122.430408153397) |
| 158318 | 158318 | 116046 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 5x15 | 6011495.20108 | 2105434.8979700003 | 37.761770862847705 | -122.40335867726002 | (37.7617708628477, -122.40335867726) | ||
| 163065 | 163065 | 116050 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Kansas St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 4x4 | 6011499.79329 | 2105331.08163 | 37.76148606285779 | -122.403335490949 | (37.7614860628578, -122.403335490949) | ||
| 1767 | 1767 | 108696 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3219 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774620 | 6003723.121830001 | 2119813.07153 | 37.8008125903965 | -122.431265542364 | (37.8008125903965, -122.431265542364) |
| 2260 | 2260 | 49946 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2865 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 5 | 3x9 | Permit Number 46704 | 5985860.2058 | 2096036.9196 | 37.7345014493544 | -122.491326934377 | (37.7345014493544, -122.491326934377) |
| 2261 | 2261 | 49948 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2875@ SLOAT 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 6 | 3x9 | Permit Number 46705 | 5985861.2671 | 2096018.8777 | 37.7344519730851 | -122.491321937714 | (37.7344519730851, -122.491321937714) |
| 2262 | 2262 | 49949 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2875@ SLOAT 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 5 | 10x3 | Permit Number 46705 | 5985862.3284 | 2096008.2648 | 37.7344228948841 | -122.491317487651 | (37.7344228948841, -122.491317487651) |
| 3813 | 3813 | 43299 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 615 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 7 | Permit Number 43068 | 6011854.0 | 2105476.0 | 37.761903752987706 | -122.402120617661 | (37.7619037529877, -122.402120617661) | |
| 3815 | 3815 | 43300 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 615 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 10 | Permit Number 43068 | 6011854.0 | 2105476.0 | 37.761903752987706 | -122.402120617661 | (37.7619037529877, -122.402120617661) | |
| 4164 | 4164 | 57912 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1653 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 6 | Permit Number 16870 | 6006600.1246 | 2116572.8469 | 37.7920783685385 | -122.42107969148998 | (37.7920783685385, -122.42107969149) | |
| 4905 | 4905 | 44497 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1531 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 10 | Permit Number 43799 | 6006322.0 | 2092922.0 | 37.727122979083205 | -122.420362574607 | (37.7271229790832, -122.420362574607) | |
| 5124 | 5124 | 56265 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 15 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2006 12:00:00 AM | Permit Number 12391 | 6006208.27079513 | 2104027.08283356 | 37.7576086269531 | -122.42154409690501 | (37.7576086269531, -122.421544096905) | ||
| 5786 | 5786 | 108707 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1849 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773000 | 6003000.77487 | 2119918.27171 | 37.801060480419395 | -122.433772685874 | (37.8010604804194, -122.433772685874) |
| 6309 | 6309 | 63514 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1937 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769639 | 6000284.9286 | 2111624.1423 | 37.778132482558 | -122.44257480934799 | (37.778132482558, -122.442574809348) |
| 7158 | 7158 | 30976 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1950 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 24 | 6x12 | Permit Number 34765 | 6004885.74764 | 2117123.17132 | 37.7934926287434 | -122.427050672647 | (37.7934926287434, -122.427050672647) |
| 7558 | 7558 | 30975 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1950 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 24 | 6x9 | Permit Number 34765 | 6004860.3383 | 2117120.17233 | 37.7934829574257 | -122.42713837725799 | (37.7934829574257, -122.427138377258) |
| 7819 | 7819 | 74571 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1055 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774207 | 6008908.989 | 2115950.0282799997 | 37.7904981444129 | -122.413046908194 | (37.7904981444129, -122.413046908194) | |
| 8916 | 8916 | 44823 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2440 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778318 | 6001806.8581 | 2114669.8819999998 | 37.7865819462822 | -122.43752808228201 | (37.7865819462822, -122.437528082282) | |
| 9693 | 9693 | 50208 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 763 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 8 | 3x3 | Permit Number 46916 | 5987522.0 | 2110774.0 | 37.7750624459683 | -122.48666339258301 | (37.7750624459683, -122.486663392583) |
| 9815 | 9815 | 40304 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 276 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 10 | Permit Number 46688 | 6006675.32022229 | 2104512.13520977 | 37.7589667921547 | -122.419963267076 | (37.7589667921547, -122.419963267076) | |
| 10275 | 10275 | 32464 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99x Deming St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36974 | 5999085.33670349 | 2105174.9537063 | 37.7603561904001 | -122.446260575093 | (37.7603561904001, -122.446260575093) | ||
| 10443 | 10443 | 109691 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 926 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774277 | 6003588.14539 | 2089614.80455 | 37.7178877169308 | -122.42957771366699 | (37.7178877169308, -122.429577713667) |
| 10521 | 10521 | 108564 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 208 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772581 | 6010035.655230001 | 2093553.92933 | 37.7290666937725 | -122.407568987434 | (37.7290666937725, -122.407568987434) |
| 10633 | 10633 | 78424 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 337 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 12 | 3x3 | 6001367.33803 | 2089018.36243 | 37.716124024086 | -122.43721136872499 | (37.716124024086, -122.437211368725) | |
| 10912 | 10912 | 75399 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1350 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 12 | 4x6 | 5988689.6276 | 2099701.3205 | 37.7447278644639 | -122.48181312543501 | (37.7447278644639, -122.481813125435) | |
| 10939 | 10939 | 75321 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1350 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 9x4 | 5988672.5581 | 2099700.4669999997 | 37.7447245283024 | -122.481872085268 | (37.7447245283024, -122.481872085268) | |
| 11233 | 11233 | 108547 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773709 | 6002168.783340001 | 2093999.82608 | 37.7298475310412 | -122.43479722051799 | (37.7298475310412, -122.434797220518) |
| 11473 | 11473 | 40673 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 119 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 9 | 3x3 | Permit Number 41658 | 6004193.53589 | 2093779.4786099999 | 37.7293572530177 | -122.427781722549 | (37.7293572530177, -122.427781722549) |
| 12363 | 12363 | 92312 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2711 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985822.132 | 2096946.3119 | 37.7369961745626 | -122.49152548244 | (37.7369961745626, -122.49152548244) | |
| 12729 | 12729 | 108568 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 225 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773759 | 6006239.22183 | 2092782.68354 | 37.7267357814247 | -122.420638852723 | (37.7267357814247, -122.420638852723) |
| 12868 | 12868 | 31576 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1927 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767615 | 5989387.7672 | 2102208.476 | 37.751652427787704 | -122.47958252470501 | (37.7516524277877, -122.479582524705) |
| 13187 | 13187 | 106199 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2107 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 3x4 | 5983225.8003 | 2100763.9337 | 37.74732624942661 | -122.500784246807 | (37.7473262494266, -122.500784246807) | ||
| 14304 | 14304 | 110654 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2015 12:00:00 AM | 3 | 3x3 | 6012037.262709999 | 2106026.3006599997 | 37.763424983208 | -122.40152545783 | (37.763424983208, -122.40152545783) | |
| 15243 | 15243 | 109931 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2822 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775171 | |||||
| 15732 | 15732 | 49838 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 630 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/2016 12:00:00 AM | 3 | Permit Number 46621 | 6010947.62469 | 2105199.0558700003 | 37.7610926949039 | -122.405235926615 | (37.7610926949039, -122.405235926615) | |
| 17310 | 17310 | 32157 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 219 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | 18 | 2x2 | Permit Number 35507 | 6005455.872 | 2110108.4059 | 37.7742640388488 | -122.42457877877199 | (37.7742640388488, -122.424578778772) |
| 17908 | 17908 | 45501 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3070 23rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | Permit Number 44273 | 5989380.64559271 | 2094892.34202186 | 37.731563814981605 | -122.47907204836399 | (37.7315638149816, -122.479072048364) | ||
| 17914 | 17914 | 66442 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 263 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 772183 | 6006122.56808708 | 2096124.40877 | 37.73590484821929 | -122.421279320467 | (37.7359048482193, -122.421279320467) | |
| 18196 | 18196 | 108832 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 60 Ney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774659 | 6003833.887 | 2093995.50335 | 37.7299300570357 | -122.429040457944 | (37.7299300570357, -122.429040457944) | |
| 18921 | 18921 | 32751 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98X LOBOS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37130 | 5996424.0 | 2088680.0 | 37.71491271306979 | -122.45427337935101 | (37.7149127130698, -122.454273379351) | ||
| 19059 | 19059 | 43844 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2736 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/2003 12:00:00 AM | Permit Number 43466 | 5985584.65410627 | 2096702.64202879 | 37.7363132411039 | -122.492328600224 | (37.7363132411039, -122.492328600224) | ||
| 19106 | 19106 | 45210 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 600-698X Bowdoin St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2001 12:00:00 AM | Permit Number 44051 | 6008935.27610714 | 2093040.15073148 | 37.7275943109827 | -122.41133681828501 | (37.7275943109827, -122.411336818285) | ||
| 19353 | 19353 | 49110 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1411 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46250 | 5995842.78355552 | 2093401.69932097 | 37.7278440321398 | -122.456623556012 | (37.7278440321398, -122.456623556012) | ||
| 19470 | 19470 | 31542 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 150 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35092 | 5998688.18134384 | 2112713.18488923 | 37.7810315633484 | -122.44817695027099 | (37.7810315633484, -122.448176950271) | ||
| 19748 | 19748 | 42907 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2666 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 3x3 | Permit Number 42820 | 6010104.02523077 | 2104001.6158371996 | 37.757757594938 | -122.40806913661801 | (37.757757594938, -122.408069136618) | |
| 19784 | 19784 | 31175 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 230 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34873 | 5993424.36409325 | 2089864.86318911 | 37.7179935887517 | -122.464727290106 | (37.7179935887517, -122.464727290106) | ||
| 19804 | 19804 | 48657 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 601 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45947 | 5992474.12537509 | 2103859.88961246 | 37.7563655794475 | -122.469029766101 | (37.7563655794475, -122.469029766101) | ||
| 20267 | 20267 | 45221 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 801-899X Felton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2001 12:00:00 AM | Permit Number 44054 | 6008510.16746889 | 2093128.34888408 | 37.7278126322854 | -122.412812661196 | (37.7278126322854, -122.412812661196) | ||
| 20375 | 20375 | 36345 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 94 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39307 | 5995648.40057371 | 2093261.73046409 | 37.727448548862 | -122.45728541654199 | (37.727448548862, -122.457285416542) | ||
| 20376 | 20376 | 49064 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 820 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46228 | 5995441.21926362 | 2094283.33319861 | 37.7302417218115 | -122.45807554192699 | (37.7302417218115, -122.458075541927) | ||
| 22967 | 22967 | 109038 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1646 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773238 | 5985355.0 | 2103995.9 | 37.7563251201532 | -122.49365984919201 | (37.7563251201532, -122.493659849192) |
| 23631 | 23631 | 71784 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 335 London St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 7 | 3x3 | Permit Number 767514 | 6002237.25937 | 2091765.2641200002 | 37.723715816608504 | -122.43440079037902 | (37.7237158166085, -122.434400790379) |
| 23676 | 23676 | 52550 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1527 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 0 | Permit Number 49093 | 5984635.73167971 | 2104787.38586659 | 37.7584562156449 | -122.49620568519501 | (37.7584562156449, -122.496205685195) | |
| 24063 | 24063 | 62130 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54059 | 6001174.82097 | 2092290.03948 | 37.72509636588129 | -122.438111025319 | (37.7250963658813, -122.438111025319) |
| 24765 | 24765 | 68220 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 277 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 4 | Permit Number 32007 | 5990853.35695 | 2113538.0406299997 | 37.78284538159139 | -122.475341463071 | (37.7828453815914, -122.475341463071) | |
| 25081 | 25081 | 37199 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1501 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 7 | Permit Number 39766 | 5986185.9989 | 2104971.5764 | 37.7590526389001 | -122.490857797213 | (37.7590526389001, -122.490857797213) | |
| 25161 | 25161 | 60987 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 338 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 8 | 3x3 | Permit Number 767515 | 6002192.00153 | 2091772.7683700002 | 37.7237338525093 | -122.434557775148 | (37.7237338525093, -122.434557775148) |
| 25398 | 25398 | 48029 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 320 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45747 | 5992060.97145669 | 2097299.95564023 | 37.738329808716294 | -122.46998096184299 | (37.7383298087163, -122.469980961843) | ||
| 25468 | 25468 | 44463 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1600 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 7 | Permit Number 43782 | 6006251.1656 | 2092487.67845 | 37.7259264347478 | -122.420576631331 | (37.7259264347478, -122.420576631331) | |
| 25547 | 25547 | 95902 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1849 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767604 | 5989055.5587 | 2102725.7124 | 37.7530533181544 | -122.48076919458201 | (37.7530533181544, -122.480769194582) |
| 25826 | 25826 | 78305 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4435 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 14 | 5984852.19199 | 2111745.44954 | 37.777573766565396 | -122.49597038603301 | (37.7775737665654, -122.495970386033) | ||
| 26509 | 26509 | 78220 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1168 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 11 | 6009637.32407 | 2090762.2749400001 | 37.7213790919536 | -122.408749187543 | (37.7213790919536, -122.408749187543) | ||
| 26889 | 26889 | 92288 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2444 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52736 | 5989860.8925 | 2098710.0267 | 37.7420740738089 | -122.477690715305 | (37.7420740738089, -122.477690715305) |
| 26917 | 26917 | 84611 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2626 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2006 12:00:00 AM | 6 | 5987424.009980001 | 2110533.0833099997 | 37.7743952434606 | -122.486984660428 | (37.7743952434606, -122.486984660428) | ||
| 27060 | 27060 | 92454 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2343 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52844 | 5981710.4 | 2099132.4 | 37.742757425745204 | -122.50590336010201 | (37.7427574257452, -122.505903360102) |
| 27108 | 27108 | 47884 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1422 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2002 12:00:00 AM | 5 | Permit Number 45630 | 5982179.6052 | 2105409.3092 | 37.7600196636967 | -122.504746003202 | (37.7600196636967, -122.504746003202) | |
| 27331 | 27331 | 117477 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1999X Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 14 | Permit Number 778454 | 6004121.651819999 | 2117991.3278099997 | 37.7958331278375 | -122.429756453008 | (37.7958331278375, -122.429756453008) |
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");