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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||
| 52762 | 52762 | 71598 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 126 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 9 | 5994743.91592 | 2086305.62835 | 37.70829675666771 | -122.45990852057301 | (37.7082967566677, -122.459908520573) | ||
| 174882 | 174882 | 71606 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 182 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 13 | 5994495.515430001 | 2086527.6412 | 37.708892062899 | -122.460783093263 | (37.708892062899, -122.460783093263) | ||
| 180245 | 180245 | 44388 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 375 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | 11 | Permit Number 43748 | 6002261.2315 | 2086392.26553 | 37.708964112084104 | -122.433934046742 | (37.7089641120841, -122.433934046742) | |
| 41117 | 41117 | 71607 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 190 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 11 | 5994457.91424 | 2086560.2946 | 37.708979557936104 | -122.46091541234199 | (37.7089795579361, -122.460915412342) | ||
| 131156 | 131156 | 44387 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 330 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | 13 | Permit Number 43747 | 6002496.67334 | 2086552.28846 | 37.7094168586614 | -122.433131752528 | (37.7094168586614, -122.433131752528) | |
| 36293 | 36293 | 71578 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 94X De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 13 | 5994610.40755 | 2086820.2353700001 | 37.709702067873 | -122.460407199135 | (37.709702067873, -122.460407199135) | ||
| 111474 | 111474 | 98267 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98X De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5994599.8 | 2086859.2 | 37.7098084453918 | -122.460446681932 | (37.7098084453918, -122.460446681932) | |||
| 134606 | 134606 | 44739 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 227 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 11 | Permit Number 43856 | 5992060.248430001 | 2086948.89288 | 37.709908299502004 | -122.469230282263 | (37.709908299502, -122.469230282263) | |
| 185618 | 185618 | 78542 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 918 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 11 | 5996973.29255 | 2086886.4307 | 37.710019470088206 | -122.452245463059 | (37.7100194700882, -122.452245463059) | ||
| 129674 | 129674 | 44736 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 219 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 11 | Permit Number 43853 | 5992060.83811 | 2086996.78191 | 37.7100398253609 | -122.469231727479 | (37.7100398253609, -122.469231727479) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 80792 | 80792 | 108763 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Lathrop Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 84811 | 84811 | 108770 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Lathrop Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 97559 | 97559 | 108774 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Lathrop Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 103669 | 103669 | 108777 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Lathrop Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 128675 | 128675 | 108767 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Lathrop Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 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) | ||
| 166288 | 166288 | 44417 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 848 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 10 | Permit Number 43767 | 6002130.68513 | 2086945.75609 | 37.710476466874496 | -122.43442477978 | (37.7104764668745, -122.43442477978) | |
| 59346 | 59346 | 44416 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 842 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 13 | Permit Number 43766 | 6002162.64544 | 2086961.7492400003 | 37.7105221947079 | -122.43431546089501 | (37.7105221947079, -122.434315460895) | |
| 170312 | 170312 | 44447 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 59 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 5 | Permit Number 43776 | 6002676.42201 | 2086971.7309400002 | 37.7105787512666 | -122.432540451876 | (37.7105787512666, -122.432540451876) | |
| 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) | |
| 187451 | 187451 | 44412 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 33 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 13 | Permit Number 43763 | 6002334.21635 | 2087134.94604 | 37.7110074922697 | -122.43373484600201 | (37.7110074922697, -122.433734846002) | |
| 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) | |
| 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) | |
| 80778 | 80778 | 44439 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 531 Rolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | Permit Number 43771 | 6002514.79073702 | 2087514.7659814 | 37.7120606396298 | -122.433137858963 | (37.7120606396298, -122.433137858963) | ||
| 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) | |
| 60988 | 60988 | 34805 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 34 Rae Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | 13 | Permit Number 38441 | 5998256.61807 | 2087702.5747200001 | 37.712333850190895 | -122.447868780125 | (37.7123338501909, -122.447868780125) | |
| 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) | |
| 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) | ||
| 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) | ||
| 132394 | 132394 | 78776 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 290 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 12 | 5998994.264690001 | 2088056.9738200002 | 37.713349084963205 | -122.445344726679 | (37.7133490849632, -122.445344726679) | ||
| 141329 | 141329 | 49754 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 539 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | Permit Number 46550 | 6009441.1650233 | 2087900.21991399 | 37.7135094918061 | -122.409225395345 | (37.7135094918061, -122.409225395345) | ||
| 120941 | 120941 | 47374 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 225 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45291 | 5993206.52581664 | 2088692.73430225 | 37.7147626431959 | -122.465395157039 | (37.7147626431959, -122.465395157039) | ||
| 119045 | 119045 | 32752 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99X LOBOS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37130 | 5995934.0 | 2088667.0 | 37.714848906239204 | -122.455966075921 | (37.7148489062392, -122.455966075921) | ||
| 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) | ||
| 105848 | 105848 | 32749 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98X LOBOS ST | 1 | 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) | ||
| 126457 | 126457 | 32748 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98X LOBOS ST | 4 | 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) | ||
| 86681 | 86681 | 47375 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 234 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45292 | 5993259.27274872 | 2088756.05858057 | 37.7149395584038 | -122.46521744015699 | (37.7149395584038, -122.465217440157) | ||
| 81402 | 81402 | 32754 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 518 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41062 | 5995930.70396007 | 2088752.73433833 | 37.7150841234911 | -122.45598366275699 | (37.7150841234911, -122.455983662757) | ||
| 105484 | 105484 | 34799 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 50 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38435 | 5999698.159703299 | 2088804.83940078 | 37.7154427112757 | -122.44296550190599 | (37.7154427112757, -122.442965501906) | ||
| 142531 | 142531 | 39957 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 371 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | Permit Number 41219 | 6009194.44343188 | 2088629.08257144 | 37.7154969729595 | -122.410129582261 | (37.7154969729595, -122.410129582261) | ||
| 185789 | 185789 | 32755 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 542 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 11 | Permit Number 37133 | 5995923.45936 | 2088920.5817599997 | 37.7155445773895 | -122.456020830506 | (37.7155445773895, -122.456020830506) | |
| 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) | |
| 101749 | 101749 | 112766 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 209 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | Permit Number 774179 | 5994932.2 | 2088977.2 | 37.715643091976 | -122.459451143491 | (37.715643091976, -122.459451143491) | ||
| 184576 | 184576 | 80734 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 70 Tucker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/2002 12:00:00 AM | 2 | 6010673.12959 | 2088678.9601200002 | 37.7157166977341 | -122.405022064239 | (37.7157166977341, -122.405022064239) | ||
| 85899 | 85899 | 108980 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 70 Tucker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773181 | 6010690.3 | 2088693.9 | 37.7157586794381 | -122.40496376641701 | (37.7157586794381, -122.404963766417) |
| 125034 | 125034 | 47367 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 45 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45287 | 5993882.1938903 | 2089153.88326205 | 37.7160677926377 | -122.463093226229 | (37.7160677926377, -122.463093226229) | ||
| 110124 | 110124 | 47366 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 33 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45286 | 5993908.23807 | 2089153.6544134 | 37.7160686645166 | -122.46300318928499 | (37.7160686645166, -122.463003189285) | ||
| 144627 | 144627 | 47365 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 27 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45285 | 5993921.26015799 | 2089153.53998909 | 37.716069100430296 | -122.462958170818 | (37.7160691004303, -122.462958170818) | ||
| 123363 | 123363 | 46741 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 21 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44848 | 5993934.28224784 | 2089153.42556477 | 37.71606953632679 | -122.462913152344 | (37.7160695363268, -122.462913152344) | ||
| 126142 | 126142 | 47363 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 9 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/2002 12:00:00 AM | Permit Number 45283 | 5993960.32642568 | 2089153.19671613 | 37.716070408068106 | -122.46282311540199 | (37.7160704080681, -122.462823115402) | ||
| 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) | ||
| 140752 | 140752 | 39940 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 655 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | Permit Number 41211 | 6009369.48794776 | 2088843.22334956 | 37.7160947692695 | -122.40953965225401 | (37.7160947692695, -122.409539652254) | ||
| 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) | |
| 73824 | 73824 | 73215 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 331 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 11 | 6001346.03632 | 2089028.82617 | 37.7161515442477 | -122.43728574625901 | (37.7161515442477, -122.437285746259) | ||
| 94768 | 94768 | 46743 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 24 Sargent St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | ||
| 89926 | 89926 | 46742 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 22 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44849 | 5993955.77483291 | 2089205.23871813 | 37.716213040822204 | -122.462842621092 | (37.7162130408222, -122.462842621092) | ||
| 160920 | 160920 | 95728 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 235 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767474 | 6004052.27697 | 2089070.2546599999 | 37.716418770593 | -122.427934633383 | (37.716418770593, -122.427934633383) |
| 148784 | 148784 | 95726 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 221 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767473 | 6004091.251630001 | 2089133.0174099999 | 37.7165933083102 | -122.427804387274 | (37.7165933083102, -122.427804387274) |
| 39686 | 39686 | 95727 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 221 Dublin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767473 | 6004098.52125 | 2089144.6288599998 | 37.7166256020635 | -122.427780086703 | (37.7166256020635, -122.427780086703) |
| 40290 | 40290 | 32745 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 148 Montana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 8 | Permit Number 37127 | 5995448.12919 | 2089342.0569999998 | 37.7166745548685 | -122.45769425390101 | (37.7166745548685, -122.457694253901) | |
| 138166 | 138166 | 32744 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 148 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | Permit Number 37127 | 5995478.73081 | 2089341.7479 | 37.716675464066604 | -122.457588457653 | (37.7166754640666, -122.457588457653) | |
| 72531 | 72531 | 35128 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 801 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38662 | 6001643.72557577 | 2089290.87046445 | 37.7168879780513 | -122.436275534193 | (37.7168879780513, -122.436275534193) | ||
| 91716 | 91716 | 35132 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 801 Madrid St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38662 | 6001643.72557577 | 2089290.87046445 | 37.7168879780513 | -122.436275534193 | (37.7168879780513, -122.436275534193) | ||
| 101565 | 101565 | 35129 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 801 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38662 | 6001643.72557577 | 2089290.87046445 | 37.7168879780513 | -122.436275534193 | (37.7168879780513, -122.436275534193) | ||
| 104655 | 104655 | 35130 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 801 Madrid St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38662 | 6001643.72557577 | 2089290.87046445 | 37.7168879780513 | -122.436275534193 | (37.7168879780513, -122.436275534193) | ||
| 127651 | 127651 | 35131 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 801 Madrid St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38662 | 6001643.72557577 | 2089290.87046445 | 37.7168879780513 | -122.436275534193 | (37.7168879780513, -122.436275534193) | ||
| 129266 | 129266 | 43717 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43358 | 5997106.16676545 | 2089400.50441352 | 37.7169301472311 | -122.451967486806 | (37.7169301472311, -122.451967486806) | ||
| 121385 | 121385 | 74340 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 207 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52569 | 5997093.91103174 | 2089409.10522836 | 37.7169530610701 | -122.45201046888201 | (37.7169530610701, -122.452010468882) | |
| 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) | ||
| 35950 | 35950 | 78250 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 719 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 15 | 6002605.65384 | 2089306.22007 | 37.716984732838895 | -122.432951716346 | (37.7169847328389, -122.432951716346) | ||
| 128078 | 128078 | 50503 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 750 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | Permit Number 47139 | 6002235.40406143 | 2089315.23627837 | 37.7169884815609 | -122.43423213360501 | (37.7169884815609, -122.434232133605) | ||
| 62324 | 62324 | 78780 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 955 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 11 | 5998546.4614699995 | 2089401.2887400002 | 37.7170146937571 | -122.446989164045 | (37.7170146937571, -122.446989164045) | ||
| 51152 | 51152 | 78245 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 955 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 9 | 5998556.73841 | 2089414.9680700002 | 37.717052841202396 | -122.446954625574 | (37.7170528412024, -122.446954625574) | ||
| 104957 | 104957 | 35100 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 751 Edinburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38641 | 6002051.19589377 | 2089431.1716233997 | 37.7172963572107 | -122.434877137751 | (37.7172963572107, -122.434877137751) | ||
| 115337 | 115337 | 35099 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 751 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38641 | 6002051.19589377 | 2089431.1716233997 | 37.7172963572107 | -122.434877137751 | (37.7172963572107, -122.434877137751) | ||
| 138532 | 138532 | 32735 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 809 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37118 | 5995029.96287257 | 2089665.49407684 | 37.7175386053384 | -122.45916304432801 | (37.7175386053384, -122.459163044328) | ||
| 51718 | 51718 | 79811 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 514 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 17 | 6003624.73165 | 2089487.21102 | 37.717539444554 | -122.429442157036 | (37.717539444554, -122.429442157036) | ||
| 165591 | 165591 | 95774 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 674 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767509 | 6002740.18183 | 2089602.96297 | 37.7178071529464 | -122.432507901839 | (37.7178071529464, -122.432507901839) |
| 105071 | 105071 | 43737 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 66 Margaret Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43374 | 5996998.01935235 | 2089732.6586291 | 37.717835970241794 | -122.45236525277599 | (37.7178359702418, -122.452365252776) | ||
| 78543 | 78543 | 31177 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 315 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34875 | 5993203.237346901 | 2089815.65353127 | 37.717845719795704 | -122.465488049675 | (37.7178457197957, -122.465488049675) | ||
| 86689 | 86689 | 31176 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301 Shields St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/2002 12:00:00 AM | Permit Number 34874 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | ||
| 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) | ||
| 45157 | 45157 | 83662 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 739 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 8 | 6001858.1049 | 2089640.1660799999 | 37.717859244391796 | -122.43555950477501 | (37.7178592443918, -122.435559504775) | ||
| 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) | |
| 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) |
| 121823 | 121823 | 109692 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 943 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 774281 | 6003685.4 | 2089620.3 | 37.7179083124774 | -122.42924193906299 | (37.7179083124774, -122.429241939063) |
| 141321 | 141321 | 31187 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 726 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34884 | 5992132.93018265 | 2089881.18382937 | 37.7179638616377 | -122.46919236078001 | (37.7179638616377, -122.46919236078) | ||
| 124778 | 124778 | 31178 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 326 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34876 | 5993174.15849792 | 2089868.02517544 | 37.7179878425238 | -122.465592364204 | (37.7179878425238, -122.465592364204) | ||
| 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) | ||
| 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) | ||
| 82804 | 82804 | 32738 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 621 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37121 | 5995721.30828491 | 2089878.27647078 | 37.718162576672704 | -122.456788775002 | (37.7181625766727, -122.456788775002) | ||
| 102634 | 102634 | 31162 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 427 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34863 | 5992963.90040328 | 2090024.39392903 | 37.7184050637265 | -122.466330486658 | (37.7184050637265, -122.466330486658) | ||
| 54004 | 54004 | 73116 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 249 Niagara Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 7 | 5999023.152869999 | 2089904.73792 | 37.718424273151705 | -122.445377656271 | (37.7184242731517, -122.445377656271) | ||
| 91203 | 91203 | 31163 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 431 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34864 | 5992964.20726348 | 2090049.07022011 | 37.718472836559 | -122.466331218389 | (37.718472836559, -122.466331218389) |
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");