Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |
58949 | 58949 | 108642 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 167 Judson Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774606 | 5998978.54245 | 2093474.85877 | 37.7282244523119 | -122.44578846914 | (37.7282244523119, -122.44578846914) | |
80235 | 80235 | 96569 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
80502 | 80502 | 108638 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 414 Hearst Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774605 | 5998661.98035 | 2094402.2163900002 | 37.7307526786149 | -122.446949537766 | (37.7307526786149, -122.446949537766) | |
85391 | 85391 | 108840 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 171 Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774672 | 6004535.74354 | 2092399.5717799999 | 37.7255876870469 | -122.426500461978 | (37.7255876870469, -122.426500461978) | |
86927 | 86927 | 108735 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1514 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774640 | 5989640.683680001 | 2105037.22287 | 37.759434101142 | -122.478914795236 | (37.759434101142, -122.478914795236) | |
92457 | 92457 | 95437 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1570 29th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767299 | 5987198.0 | 2104590.4 | 37.7580651010612 | -122.487329865241 | (37.7580651010612, -122.487329865241) | ||
94098 | 94098 | 95434 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2151 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767298 | 5988486.9 | 2100677.9 | 37.747397502062995 | -122.482585657316 | (37.747397502063, -122.482585657316) | ||
99207 | 99207 | 96568 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
104049 | 104049 | 108471 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 783 09th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773780 | 5993180.23272 | 2110155.1088900003 | 37.7736913649846 | -122.467045486436 | (37.7736913649846, -122.467045486436) | |||
108470 | 108470 | 96849 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1401 Kearny St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767592 | 6010966.7 | 2119733.6 | 37.801002214186894 | -122.40619400162501 | (37.8010022141869, -122.406194001625) | ||
109575 | 109575 | 108838 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 267 Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774666 | 6004068.9172 | 2089601.41292 | 37.717878156846 | -122.42791494359501 | (37.717878156846, -122.427914943595) | |
114314 | 114314 | 108701 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 478 30th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774626 | 6003507.49152 | 2098366.3309400002 | 37.7419128730633 | -122.43048058961 | (37.7419128730633, -122.43048058961) | |
122814 | 122814 | 94886 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1571 Shafter Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53952 | 6015046.2 | 2094014.9 | 37.730611623012 | -122.3902791877 | (37.730611623012, -122.3902791877) | ||
124197 | 124197 | 96567 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
126720 | 126720 | 96850 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1401 Kearny St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767592 | 6010966.7 | 2119733.6 | 37.801002214186894 | -122.40619400162501 | (37.8010022141869, -122.406194001625) | ||
141006 | 141006 | 108474 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 619 06th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773774 | 5994069.31075 | 2111288.088 | 37.776853501233894 | -122.46405231337499 | (37.7768535012339, -122.464052313375) | |||
141571 | 141571 | 108835 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 582 Paris St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774664 | 6001569.98355 | 2090273.86395 | 37.7195828682199 | -122.436600744727 | (37.7195828682199, -122.436600744727) | |
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) |
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) |
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) | |
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) | |
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) |
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) | |
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) | ||
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) | ||
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) |
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) | ||
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) |
27700 | 27700 | 46652 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 352 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | 8 | Permit Number 767859 | 5990608.27157 | 2113041.98207 | 37.7814691334051 | -122.476153103488 | (37.7814691334051, -122.476153103488) | |
27907 | 27907 | 42155 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 519 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 5 | Permit Number 42450 | 5989365.15047 | 2111778.31526 | 37.7779272929593 | -122.480361131189 | (37.7779272929593, -122.480361131189) | |
28222 | 28222 | 68960 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2115 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1996 12:00:00 AM | 8 | Permit Number 32949 | 5988984.02499 | 2111212.07904 | 37.7763504110658 | -122.481638080092 | (37.7763504110658, -122.481638080092) | |
28259 | 28259 | 52567 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1571 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 6 | Permit Number 48664 | 5983720.4322 | 2104461.3413 | 37.757507331453795 | -122.49934705559099 | (37.7575073314538, -122.499347055591) | |
28300 | 28300 | 95760 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 207 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767497 | 6004854.06205 | 2091888.4438900002 | 37.7242022320271 | -122.425363703668 | (37.7242022320271, -122.425363703668) |
28409 | 28409 | 52286 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 68 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48444 | 6005456.52418218 | 2099358.34755357 | 37.7447469414441 | -122.423811979701 | (37.7447469414441, -122.423811979701) | ||
28643 | 28643 | 72844 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2474 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 8 | 5989246.9405 | 2098504.7662 | 37.741474833316005 | -122.47979852661899 | (37.741474833316, -122.479798526619) | ||
28693 | 28693 | 72007 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1919 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 9 | 5986594.8133 | 2102174.9289 | 37.7513976822301 | -122.489238323994 | (37.7513976822301, -122.489238323994) | ||
28924 | 28924 | 36448 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1270 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39350 | 5995753.99208011 | 2092527.19640407 | 37.725437758382796 | -122.456867284631 | (37.7254377583828, -122.456867284631) | ||
29342 | 29342 | 78567 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 40 Sears St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 0 | 5996717.44875 | 2086996.04025 | 37.7103057728767 | -122.453137611232 | (37.7103057728767, -122.453137611232) | ||
29722 | 29722 | 46645 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 329 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | 8 | Permit Number 44777 | 5990864.95756 | 2113183.37502 | 37.781872240560105 | -122.47527542879801 | (37.7818722405601, -122.475275428798) | |
29806 | 29806 | 79006 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3010 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/31/2001 12:00:00 AM | 4 | 5988598.81631 | 2095123.01531 | 37.73215174969361 | -122.48179184262 | (37.7321517496936, -122.48179184262) | ||
29935 | 29935 | 68653 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 218 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2012 12:00:00 AM | 10 | Permit Number 768874 | 5993704.111880001 | 2114020.8946700003 | 37.7843359956366 | -122.465514212776 | (37.7843359956366, -122.465514212776) | |
30207 | 30207 | 43802 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 626 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 12 | Permit Number 43432 | 5988815.3597099995 | 2111031.7516799998 | 37.7758454732565 | -122.482208318964 | (37.7758454732565, -122.482208318964) | |
30603 | 30603 | 78249 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 722 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 14 | 6002553.6088 | 2089304.67959 | 37.7169775508513 | -122.433131500725 | (37.7169775508513, -122.433131500725) | ||
30681 | 30681 | 71169 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2286 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 12 | 5988269.5036 | 2099757.2232 | 37.7448569176428 | -122.48326991258101 | (37.7448569176428, -122.483269912581) | ||
30893 | 30893 | 81813 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1419 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 5988645.6741 | 2105641.5626 | 37.7610356250119 | -122.482400266833 | (37.7610356250119, -122.482400266833) | |||
30895 | 30895 | 72325 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1024 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 17 | 5995456.74462 | 2112185.6673 | 37.7793978796409 | -122.459317808209 | (37.7793978796409, -122.459317808209) | ||
30974 | 30974 | 38188 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 467 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 13 | Permit Number 40317 | 6010993.92767 | 2092626.8959400002 | 37.7265748468264 | -122.40419092789101 | (37.7265748468264, -122.404190927891) | |
31350 | 31350 | 32756 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 548 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 11 | Permit Number 37134 | 5995923.97988 | 2088945.4822 | 37.7156129780405 | -122.456020830504 | (37.7156129780405, -122.456020830504) | |
32279 | 32279 | 50237 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1201 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | 1 | Permit Number 47607 | 5985808.2714 | 2106970.4182 | 37.764518829398604 | -122.492311327523 | (37.7645188293986, -122.492311327523) | |
32535 | 32535 | 95892 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1500X Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767600 | 5989616.6165 | 2103814.8649 | 37.7560764357046 | -122.47890862495701 | (37.7560764357046, -122.478908624957) |
32600 | 32600 | 30981 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2327 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 3 | Permit Number 34768 | 6004137.322380001 | 2116809.32877 | 37.7925885474784 | -122.42961788815201 | (37.7925885474784, -122.429617888152) | |
32825 | 32825 | 44438 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 531 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | 11 | Permit Number 43771 | 6002563.3537099995 | 2087475.55199 | 37.7119557212594 | -122.432967211681 | (37.7119557212594, -122.432967211681) | |
32836 | 32836 | 96072 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 575 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767698 | 5985634.97945 | 2111987.83926 | 37.778285115395704 | -122.49328036205601 | (37.7782851153957, -122.493280362056) |
32917 | 32917 | 42267 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1431 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 11 | Permit Number 46938 | 5987406.4873 | 2105538.1578 | 37.7606795409708 | -122.48667842785801 | (37.7606795409708, -122.486678427858) | |
32950 | 32950 | 67967 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3233 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2010 12:00:00 AM | 4 | Permit Number 53767 | 5988573.93418 | 2111880.53339 | 37.77816194510179 | -122.483105688312 | (37.7781619451018, -122.483105688312) | |
34212 | 34212 | 51272 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 442 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 10 | Permit Number 47647 | 5990630.5302099995 | 2112359.86559 | 37.7795975210663 | -122.476026266779 | (37.7795975210663, -122.476026266779) | |
34657 | 34657 | 35360 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 948 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 8 | Permit Number 38822 | 6011854.55892 | 2104004.68665 | 37.757863884136 | -122.40201524752199 | (37.757863884136, -122.402015247522) | |
34659 | 34659 | 42262 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1570 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 9 | Permit Number 42503 | 5988104.0896 | 2104611.0781 | 37.7581746751805 | -122.48419777491999 | (37.7581746751805, -122.48419777492) | |
35017 | 35017 | 75005 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 751 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 9 | 5991294.36984 | 2110367.2976 | 37.7741649440769 | -122.473584395208 | (37.7741649440769, -122.473584395208) | ||
35025 | 35025 | 38349 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1675 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1998 12:00:00 AM | 7 | Permit Number 40416 | 5981884.0826 | 2103708.5586 | 37.7553324970038 | -122.505641978834 | (37.7553324970038, -122.505641978834) | |
35749 | 35749 | 44460 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1543 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774159 | 6006374.3577 | 2092477.5987 | 37.7259056999789 | -122.420150048693 | (37.7259056999789, -122.420150048693) | |
35775 | 35775 | 81375 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1587 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52749 | 5988996.3417 | 2104539.6785 | 37.7580305410816 | -122.481106788836 | (37.7580305410816, -122.481106788836) |
35797 | 35797 | 73756 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 350 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 10 | 6012331.43076 | 2118154.70555 | 37.7967431913899 | -122.40136040075899 | (37.7967431913899, -122.401360400759) |
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");