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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) | ||
| 27482 | 27482 | 41214 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2526 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 11 | Permit Number 41922 | 5999213.18355 | 2119788.9581400002 | 37.8004897688328 | -122.446870019146 | (37.8004897688328, -122.446870019146) | |
| 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) | |
| 27801 | 27801 | 45230 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 901-999X Felton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2001 12:00:00 AM | 8 | Permit Number 44057 | 6008203.911069999 | 2093035.9367799999 | 37.7275416935775 | -122.41386486498699 | (37.7275416935775, -122.413864864987) | |
| 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) | ||
| 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) | ||
| 29335 | 29335 | 38897 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 125 Parker Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 10 | Permit Number 40711 | 5996844.4013 | 2113598.7498 | 37.783357514917704 | -122.454619461278 | (37.7833575149177, -122.454619461278) | |
| 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) | |
| 29801 | 29801 | 39865 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 55 Laurel St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 11 | Permit Number 41168 | 5997960.261419999 | 2116228.24387 | 37.7906413479758 | -122.450948714408 | (37.7906413479758, -122.450948714408) | |
| 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) | |
| 30544 | 30544 | 33244 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2595 25th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1996 12:00:00 AM | Permit Number 37425 | 5988605.01014938 | 2097676.97317707 | 37.7391646162219 | -122.481957449606 | (37.7391646162219, -122.481957449606) | ||
| 30546 | 30546 | 42330 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 640 Edna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45706 | 5998596.9019044 | 2094811.5025333 | 37.7318727635975 | -122.447203968283 | (37.7318727635975, -122.447203968283) | ||
| 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) | |
| 33481 | 33481 | 47801 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 45 Escondido Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2002 12:00:00 AM | 7 | Permit Number 45571 | 5986306.477999999 | 2096108.0259999998 | 37.7347227558266 | -122.489789272211 | (37.7347227558266, -122.489789272211) | |
| 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) | |
| 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) | |
| 35600 | 35600 | 44400 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1127 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 12 | Permit Number 43754 | 6001650.52714 | 2087033.38345 | 37.7106898049515 | -122.43609057243 | (37.7106898049515, -122.43609057243) | |
| 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) | |
| 35765 | 35765 | 51268 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 754 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 6 | Permit Number 47643 | 5991340.2204 | 2110277.65197 | 37.773921456767 | -122.473419251606 | (37.773921456767, -122.473419251606) | |
| 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) |
| 35996 | 35996 | 63211 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3515 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 4 | Permit Number 23754 | 5984549.109130001 | 2113139.52213 | 37.7813837305386 | -122.497121763929 | (37.7813837305386, -122.497121763929) | |
| 36195 | 36195 | 39856 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 462 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 7 | Permit Number 41163 | 5992834.400669999 | 2112304.93765 | 37.7795742464055 | -122.468398200084 | (37.7795742464055, -122.468398200084) | |
| 36373 | 36373 | 95886 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1851 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767595 | 5989982.9497 | 2102763.5943 | 37.753211191255495 | -122.477564899515 | (37.7532111912555, -122.477564899515) |
| 36411 | 36411 | 52946 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 25 Ruth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 4 | Permit Number 48933 | 6001610.069619999 | 2091593.3651700001 | 37.723208199685395 | -122.43655657684201 | (37.7232081996854, -122.436556576842) | |
| 36776 | 36776 | 92374 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2123 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52784 | 5986022.0821 | 2100766.4788 | 37.74749701238721 | -122.491115227462 | (37.7474970123872, -122.491115227462) |
| 37015 | 37015 | 84220 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1622 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52818 | 5984087.6187 | 2104108.821 | 37.756560944522 | -122.498051164125 | (37.756560944522, -122.498051164125) |
| 37045 | 37045 | 43860 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500 Crestlake Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 2 | Permit Number 43480 | 5986156.5709 | 2096489.2942 | 37.7357608636081 | -122.490335583477 | (37.7357608636081, -122.490335583477) | |
| 37129 | 37129 | 45047 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1854 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2001 12:00:00 AM | 4 | Permit Number 43933 | 5988175.8497 | 2102683.93 | 37.7528874240165 | -122.483808298799 | (37.7528874240165, -122.483808298799) | |
| 38195 | 38195 | 69034 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1378 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 3 | Permit Number 33040 | 5984339.0634 | 2105797.9538 | 37.7612135700499 | -122.497306281565 | (37.7612135700499, -122.497306281565) | |
| 38300 | 38300 | 60552 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 542 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 2 | Permit Number 20162 | 5985055.50705 | 2112151.6276599998 | 37.778700920741 | -122.49529702328199 | (37.778700920741, -122.495297023282) | |
| 38496 | 38496 | 34651 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1814 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 12 | Permit Number 38330 | 5988878.9314 | 2105836.9442 | 37.761585656021296 | -122.481607850901 | (37.7615856560213, -122.481607850901) |
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");