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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 140958 | 140958 | 46133 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44496 | 5996328.40935041 | 2106768.45994323 | 37.7645737153289 | -122.45591064533001 | (37.7645737153289, -122.45591064533) | ||
| 81759 | 81759 | 46740 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Sargent St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44847 | 5994017.67630199 | 2089152.6927278999 | 37.7160723272597 | -122.46262485198 | (37.7160723272597, -122.46262485198) | ||
| 80475 | 80475 | 36472 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Southwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39369 | 5995851.10989113 | 2092636.8943718998 | 37.72574453903471 | -122.456539488375 | (37.7257445390347, -122.456539488375) | ||
| 98025 | 98025 | 36474 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Southwood Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39369 | 5995851.10989113 | 2092636.8943718998 | 37.72574453903471 | -122.456539488375 | (37.7257445390347, -122.456539488375) | ||
| 98854 | 98854 | 36475 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Southwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39369 | 5995851.10989113 | 2092636.8943718998 | 37.72574453903471 | -122.456539488375 | (37.7257445390347, -122.456539488375) | ||
| 111906 | 111906 | 36473 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Southwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39369 | 5995851.10989113 | 2092636.8943718998 | 37.72574453903471 | -122.456539488375 | (37.7257445390347, -122.456539488375) | ||
| 115398 | 115398 | 39512 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 10 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2005 12:00:00 AM | Permit Number 48185 | 6004053.55723632 | 2102994.83081039 | 37.7546525762409 | -122.428922380275 | (37.7546525762409, -122.428922380275) | ||
| 105683 | 105683 | 30796 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 100 Acadia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | Permit Number 34663 | 6001438.86054667 | 2094658.17341001 | 37.7316137334439 | -122.437367766054 | (37.7316137334439, -122.437367766054) | ||
| 118013 | 118013 | 31173 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 100 Shields St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34871 | 5993759.19888335 | 2089860.63162869 | 37.7180012684503 | -122.46356961432801 | (37.7180012684503, -122.463569614328) | ||
| 85132 | 85132 | 45247 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000-1098X Woolsey St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44094 | 6008759.06383256 | 2091334.69120464 | 37.7229015956225 | -122.411825527366 | (37.7229015956225, -122.411825527366) | ||
| 95458 | 95458 | 45245 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000-1098X Woolsey St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44094 | 6008759.06383256 | 2091334.69120464 | 37.7229015956225 | -122.411825527366 | (37.7229015956225, -122.411825527366) | ||
| 103070 | 103070 | 45248 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000-1098X Woolsey St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44095 | 6008704.15221598 | 2091317.858977 | 37.7228522971335 | -122.412014157155 | (37.7228522971335, -122.412014157155) | ||
| 117386 | 117386 | 45246 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000-1098X Woolsey St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44094 | 6008759.06383256 | 2091334.69120464 | 37.7229015956225 | -122.411825527366 | (37.7229015956225, -122.411825527366) | ||
| 119997 | 119997 | 45244 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000-1098X Woolsey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773816 | 6008759.06383256 | 2091334.69120464 | 37.7229015956225 | -122.411825527366 | (37.7229015956225, -122.411825527366) | |
| 125411 | 125411 | 45243 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000-1098X Woolsey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773816 | 6008759.06383256 | 2091334.69120464 | 37.7229015956225 | -122.411825527366 | (37.7229015956225, -122.411825527366) | |
| 146247 | 146247 | 45249 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000-1098X Woolsey St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44095 | 6008704.15221598 | 2091317.858977 | 37.7228522971335 | -122.412014157155 | (37.7228522971335, -122.412014157155) | ||
| 82845 | 82845 | 35562 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1001 Guerrero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38934 | 6005744.32633866 | 2103150.28398507 | 37.7551749707182 | -122.423086287164 | (37.7551749707182, -122.423086287164) | ||
| 113284 | 113284 | 35563 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1001 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38934 | 6005744.32633866 | 2103150.28398507 | 37.7551749707182 | -122.423086287164 | (37.7551749707182, -122.423086287164) | ||
| 120889 | 120889 | 35564 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1001 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38934 | 6005744.32633866 | 2103150.28398507 | 37.7551749707182 | -122.423086287164 | (37.7551749707182, -122.423086287164) | ||
| 129257 | 129257 | 35561 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1001 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38934 | 6005744.32633866 | 2103150.28398507 | 37.7551749707182 | -122.423086287164 | (37.7551749707182, -122.423086287164) | ||
| 110436 | 110436 | 34091 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37972 | 5995596.86014406 | 2093332.4924806 | 37.7276398840061 | -122.45746870824301 | (37.7276398840061, -122.457468708243) | ||
| 123198 | 123198 | 34093 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Eastwood Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37972 | 5995596.86014406 | 2093332.4924806 | 37.7276398840061 | -122.45746870824301 | (37.7276398840061, -122.457468708243) | ||
| 123473 | 123473 | 34090 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37972 | 5995596.86014406 | 2093332.4924806 | 37.7276398840061 | -122.45746870824301 | (37.7276398840061, -122.457468708243) | ||
| 140117 | 140117 | 34092 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37972 | 5995596.86014406 | 2093332.4924806 | 37.7276398840061 | -122.45746870824301 | (37.7276398840061, -122.457468708243) | ||
| 41447 | 41447 | 41800 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Henry Adams St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | 19 | Permit Number 42199 | 6011429.13339 | 2107699.88722 | 37.7679863230498 | -122.40374655935499 | (37.7679863230498, -122.403746559355) | |
| 74314 | 74314 | 41798 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Henry Adams St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 20 | Permit Number 42199 | 6011424.41149 | 2107769.58562 | 37.7681774352676 | -122.40376779686501 | (37.7681774352676, -122.403767796865) | |
| 110997 | 110997 | 40668 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Maynard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | Permit Number 41656 | 6004070.62612566 | 2093782.39936272 | 37.72935831911229 | -122.428206841061 | (37.7293583191123, -122.428206841061) | ||
| 86089 | 86089 | 46712 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44842 | 5992166.503410401 | 2093783.90158663 | 37.728681705159396 | -122.469360230164 | (37.7286817051594, -122.469360230164) | ||
| 87862 | 87862 | 35975 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Porter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39132 | 6007026.56427019 | 2095399.94161299 | 37.7339665448459 | -122.418102495053 | (37.7339665448459, -122.418102495053) | ||
| 89203 | 89203 | 35977 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Porter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39132 | 6007026.56427019 | 2095399.94161299 | 37.7339665448459 | -122.418102495053 | (37.7339665448459, -122.418102495053) | ||
| 97968 | 97968 | 35978 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Porter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39132 | 6007026.56427019 | 2095399.94161299 | 37.7339665448459 | -122.418102495053 | (37.7339665448459, -122.418102495053) | ||
| 124397 | 124397 | 35976 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Porter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39132 | 6007026.56427019 | 2095399.94161299 | 37.7339665448459 | -122.418102495053 | (37.7339665448459, -122.418102495053) | ||
| 123254 | 123254 | 31174 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34872 | 5993758.54176751 | 2089808.63578079 | 37.717858462466204 | -122.463568114182 | (37.7178584624662, -122.463568114182) | ||
| 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) | ||
| 84133 | 84133 | 48924 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1032 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46114 | 6009149.10279146 | 2103141.64576642 | 37.7553427986566 | -122.41131091591002 | (37.7553427986566, -122.41131091591) | ||
| 62121 | 62121 | 59801 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1035 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 3 | Permit Number 19252 | 6008957.26664 | 2115956.46154 | 37.7905185185761 | -122.412880324992 | (37.7905185185761, -122.412880324992) | |
| 103391 | 103391 | 50272 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 105 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | Permit Number 46976 | 6004292.09535547 | 2095650.45140016 | 37.734500099757106 | -122.42757423633199 | (37.7345000997571, -122.427574236332) | ||
| 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) | |
| 134769 | 134769 | 75008 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1055 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 6 | 6008853.984569999 | 2115941.6403900003 | 37.7904720254258 | -122.41323662737699 | (37.7904720254258, -122.413236627377) | ||
| 165901 | 165901 | 74872 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1055 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 4 | 6008870.271980001 | 2115943.97085 | 37.7904793386892 | -122.413180438633 | (37.7904793386892, -122.413180438633) | ||
| 94390 | 94390 | 33339 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 106 Aptos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37478 | 5993028.3286634 | 2094300.77063214 | 37.730150666201205 | -122.466418423463 | (37.7301506662012, -122.466418423463) | ||
| 103315 | 103315 | 33338 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 106 Aptos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37478 | 5993028.3286634 | 2094300.77063214 | 37.730150666201205 | -122.466418423463 | (37.7301506662012, -122.466418423463) | ||
| 171548 | 171548 | 44395 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 106 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 16 | Permit Number 43751 | 6001724.925980001 | 2087542.0541599998 | 37.71209072926629 | -122.43586980595501 | (37.7120907292663, -122.435869805955) | |
| 180720 | 180720 | 44398 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1076 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 14 | Permit Number 43753 | 6002036.48794 | 2087189.47909 | 37.7111403293394 | -122.43476776231701 | (37.7111403293394, -122.434767762317) | |
| 114606 | 114606 | 43645 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1079 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/2000 12:00:00 AM | Permit Number 43292 | 5998923.45036537 | 2106217.0557179 | 37.7632082954429 | -122.446895451648 | (37.7632082954429, -122.446895451648) | ||
| 115132 | 115132 | 43644 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1079 Ashbury St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/2000 12:00:00 AM | 3x3 | Permit Number 43292 | 5998923.45036537 | 2106217.0557179 | 37.7632082954429 | -122.446895451648 | (37.7632082954429, -122.446895451648) | |
| 116139 | 116139 | 43642 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1079 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/2000 12:00:00 AM | Permit Number 43292 | 5998923.45036537 | 2106217.0557179 | 37.7632082954429 | -122.446895451648 | (37.7632082954429, -122.446895451648) | ||
| 102919 | 102919 | 102596 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 108 Chaves Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2010 12:00:00 AM | 3 | 3x4 | 5996733.6 | 2098580.3 | 37.7421143248718 | -122.453917831989 | (37.7421143248718, -122.453917831989) | |
| 80781 | 80781 | 50274 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 109 Saint Mary's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | Permit Number 46977 | 6004258.47732897 | 2095669.39289632 | 37.734550207248 | -122.427691814129 | (37.734550207248, -122.427691814129) | ||
| 81154 | 81154 | 50273 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 109 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | Permit Number 46977 | 6004258.47732897 | 2095669.39289632 | 37.734550207248 | -122.427691814129 | (37.734550207248, -122.427691814129) | ||
| 85714 | 85714 | 34367 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 11 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38123 | 6003690.92575647 | 2098291.15537103 | 37.7417168477238 | -122.429840972658 | (37.7417168477238, -122.429840972658) | ||
| 105115 | 105115 | 34368 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 11 Harper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38123 | 6003690.92575647 | 2098291.15537103 | 37.7417168477238 | -122.429840972658 | (37.7417168477238, -122.429840972658) | ||
| 180379 | 180379 | 78545 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 110 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/2000 12:00:00 AM | 7 | 5987422.7656 | 2115217.03849 | 37.78725598224489 | -122.487333085464 | (37.7872559822449, -122.487333085464) | ||
| 125527 | 125527 | 69598 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 110 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | Permit Number 44979 | 5994659.28111275 | 2099606.44136159 | 37.7448127019584 | -122.461164486633 | (37.7448127019584, -122.461164486633) | ||
| 89980 | 89980 | 38465 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1100 Revere Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.38080993565399 | (37.7264471943371, -122.380809935654) | ||
| 117719 | 117719 | 38469 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1100 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.38080993565399 | (37.7264471943371, -122.380809935654) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 71513 | 71513 | 38473 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40475 | 6017552.80976309 | 2092179.29237205 | 37.7257101220071 | -122.381485769849 | (37.7257101220071, -122.381485769849) | ||
| 101554 | 101554 | 38472 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40475 | 6017552.80976309 | 2092179.29237205 | 37.7257101220071 | -122.381485769849 | (37.7257101220071, -122.381485769849) | ||
| 122369 | 122369 | 38471 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40475 | 6017552.80976309 | 2092179.29237205 | 37.7257101220071 | -122.381485769849 | (37.7257101220071, -122.381485769849) | ||
| 85641 | 85641 | 51227 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1103 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/11/2004 12:00:00 AM | Permit Number 47594 | 5997663.19635859 | 2106760.97042955 | 37.7646296692364 | -122.451293459098 | (37.7646296692364, -122.451293459098) | ||
| 141676 | 141676 | 51228 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1103 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/11/2004 12:00:00 AM | Permit Number 47594 | 5997663.19635859 | 2106760.97042955 | 37.7646296692364 | -122.451293459098 | (37.7646296692364, -122.451293459098) | ||
| 133246 | 133246 | 95115 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 111 Congdon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54042 | 6004702.49074 | 2094193.2145 | 37.730522057645395 | -122.426051658966 | (37.7305220576454, -122.426051658966) |
| 106201 | 106201 | 38457 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1115 Quesada Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | ||
| 111479 | 111479 | 38461 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1115 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | ||
| 94801 | 94801 | 34075 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 112 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37967 | 6007770.24988759 | 2106070.23684134 | 37.7633066061035 | -122.416286831326 | (37.7633066061035, -122.416286831326) | ||
| 83781 | 83781 | 44405 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1125 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43758 | 6001443.44700313 | 2087911.38765671 | 37.7130888435001 | -122.43686910009 | (37.7130888435001, -122.43686910009) | ||
| 117280 | 117280 | 33304 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1125 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37454 | 6008994.36021238 | 2116826.15970753 | 37.7929085797591 | -122.41281349577801 | (37.7929085797591, -122.412813495778) | ||
| 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) | |
| 66725 | 66725 | 44399 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1127 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 12 | Permit Number 43754 | 6001633.42416 | 2087033.93549 | 37.710690349047496 | -122.43614972354601 | (37.7106903490475, -122.436149723546) | |
| 94439 | 94439 | 44406 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1129 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43759 | 6001429.46075433 | 2087887.98782302 | 37.7130237978123 | -122.436915767025 | (37.7130237978123, -122.436915767025) | ||
| 80491 | 80491 | 33097 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1133 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37339 | 6011109.07538939 | 2118812.01806947 | 37.798479737398296 | -122.40563637234699 | (37.7984797373983, -122.405636372347) | ||
| 93842 | 93842 | 33096 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1133 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37339 | 6011109.07538939 | 2118812.01806947 | 37.798479737398296 | -122.40563637234699 | (37.7984797373983, -122.405636372347) | ||
| 143513 | 143513 | 31538 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 114 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35089 | 5998816.45843253 | 2112730.87431482 | 37.781087466275295 | -122.44773445172399 | (37.7810874662753, -122.447734451724) | ||
| 172647 | 172647 | 67624 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1140 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 15 | Permit Number 31210 | 6008085.564669999 | 2118599.77366 | 37.797727432817794 | -122.41608364716801 | (37.7977274328178, -122.416083647168) | |
| 136853 | 136853 | 62302 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 115 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1985 12:00:00 AM | 2 | Permit Number 22440 | 5996762.5032 | 2112265.3679 | 37.7796917028696 | -122.45480642540501 | (37.7796917028696, -122.454806425405) | |
| 80460 | 80460 | 33390 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 115 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37509 | 5993515.17395956 | 2093719.25061138 | 37.7285820353059 | -122.464693138563 | (37.7285820353059, -122.464693138563) | ||
| 105127 | 105127 | 31041 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1150 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34800 | 6000833.71199279 | 2086847.57656981 | 37.7101331809809 | -122.43890035557199 | (37.7101331809809, -122.438900355572) | ||
| 170956 | 170956 | 69401 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1158 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 9 | Permit Number 33505 | 6001276.42619 | 2087727.4959 | 37.71257442335379 | -122.43743321887501 | (37.7125744233538, -122.437433218875) | |
| 79681 | 79681 | 108942 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 115B Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773148 | 6006936.4 | 2098796.9 | 37.7432887637665 | -122.418655034453 | (37.7432887637665, -122.418655034453) |
| 99233 | 99233 | 31042 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1160 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34801 | 6000799.02081427 | 2086846.59721813 | 37.7101285180714 | -122.43902018475201 | (37.7101285180714, -122.439020184752) | ||
| 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) | ||
| 94038 | 94038 | 31044 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1170 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34802 | 6000764.32963575 | 2086845.61786645 | 37.710123855039896 | -122.439140013916 | (37.7101238550399, -122.439140013916) | ||
| 127451 | 127451 | 31045 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1170 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34802 | 6000764.32963575 | 2086845.61786645 | 37.710123855039896 | -122.439140013916 | (37.7101238550399, -122.439140013916) | ||
| 70428 | 70428 | 80086 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1171-1181 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2002 12:00:00 AM | 2 | 6007322.74748 | 2119486.0748799997 | 37.8001180745474 | -122.41878609912399 | (37.8001180745474, -122.418786099124) | ||
| 44450 | 44450 | 46657 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 118 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | 5 | Permit Number 44788 | 5989621.321219999 | 2114553.2872 | 37.785561473074296 | -122.479678052241 | (37.7855614730743, -122.479678052241) | |
| 89690 | 89690 | 108401 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1180 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773737 | 6010006.404180001 | 2102333.7538900003 | 37.7531725525046 | -122.408289117045 | (37.7531725525046, -122.408289117045) |
| 91688 | 91688 | 36979 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 119 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 12 | 3x3 | Permit Number 39604 | 5993013.385869999 | 2114670.1685099998 | 37.7860788615029 | -122.467951104989 | (37.7860788615029, -122.467951104989) |
| 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) |
| 108936 | 108936 | 36022 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 120 Coso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39168 | 6007185.94622824 | 2099739.76029032 | 37.745891693347 | -122.417858987138 | (37.745891693347, -122.417858987138) | ||
| 120021 | 120021 | 38943 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 120 Moncada Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1998 12:00:00 AM | Permit Number 40742 | 5992220.33076332 | 2092980.51351974 | 37.7264789109772 | -122.469115701075 | (37.7264789109772, -122.469115701075) | ||
| 96014 | 96014 | 32836 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1200-1204 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43121 | 6002497.0 | 2102089.0 | 37.7520771531238 | -122.434240612887 | (37.7520771531238, -122.434240612887) | ||
| 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) | |
| 135752 | 135752 | 38096 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1215 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 2 | Permit Number 46958 | 5987668.0452 | 2106994.1149 | 37.764692444358396 | -122.485880696708 | (37.7646924443584, -122.485880696708) | |
| 178636 | 178636 | 30813 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 122 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 15 | Permit Number 34675 | 6001247.81391 | 2094960.1313900002 | 37.7324319775395 | -122.43804987230601 | (37.7324319775395, -122.438049872306) | |
| 132754 | 132754 | 38124 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1222 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 10 | Permit Number 40288 | 5985853.7274 | 2106884.2289 | 37.764284834965 | -122.492147763152 | (37.764284834965, -122.492147763152) | |
| 93112 | 93112 | 49083 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1227 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46249 | 5995845.33017768 | 2092185.08925992 | 37.7245036582659 | -122.456526810942 | (37.7245036582659, -122.456526810942) | ||
| 93456 | 93456 | 49084 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1227 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46249 | 5995845.33017768 | 2092185.08925992 | 37.7245036582659 | -122.456526810942 | (37.7245036582659, -122.456526810942) |
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");