Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6246 | 6246 | 44214 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2296 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2001 12:00:00 AM | 7 | 3x3 | Permit Number 43661 | 6002622.65854 | 2117834.05168 | 37.7953162919605 | -122.434931989341 | (37.7953162919605, -122.434931989341) | |
| 6250 | 6250 | 92077 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1151 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775152 | 6007038.57451 | 2114995.4175 | 37.7877718433296 | -122.41945068732201 | (37.7877718433296, -122.419450687322) | |
| 6266 | 6266 | 11079 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1827 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007292.79546 | 2118623.6274900003 | 37.7977483240791 | -122.41882854531 | (37.7977483240791, -122.41882854531) | |||
| 6294 | 6294 | 23536 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005728.741 | 2119933.47422 | 37.801256640539606 | -122.424333821661 | (37.8012566405396, -122.424333821661) | |||
| 6302 | 6302 | 106216 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 585X Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 10 | 3x5 | 6010698.10573 | 2115852.22595 | 37.7903298740626 | -122.406849749212 | (37.7903298740626, -122.406849749212) | |||
| 6311 | 6311 | 18513 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 626 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6010133.96255 | 2115968.0118400003 | 37.7906162119074 | -122.408809826127 | (37.7906162119074, -122.408809826127) | |||
| 6366 | 6366 | 26161 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 220 Richardson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999103.92002 | 2119837.46914 | 37.800616724342206 | -122.447251606892 | (37.8006167243422, -122.447251606892) | |||
| 6379 | 6379 | 7348 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2226 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002838.16405 | 2116011.64355 | 37.79032466161 | -122.434055969611 | (37.79032466161, -122.434055969611) | |||
| 6385 | 6385 | 105541 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2098X Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 10x6 | 6002946.2979 | 2119265.29451 | 37.799264483936604 | -122.43391449907 | (37.7992644839366, -122.43391449907) | |||
| 6450 | 6450 | 18841 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2085 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6004830.024730001 | 2116087.16929 | 37.79064487779711 | -122.427169650269 | (37.7906448777971, -122.427169650269) | |||
| 6483 | 6483 | 23497 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2529 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6005737.90239 | 2119081.40662 | 37.7989175974325 | -122.424241484673 | (37.7989175974325, -122.424241484673) | |||
| 6487 | 6487 | 27264 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1735 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2X2 | 6006104.02915 | 2116478.43214 | 37.791791150977105 | -122.422789477077 | (37.7917911509771, -122.422789477077) | |||
| 6494 | 6494 | 7364 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2360 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002779.17574 | 2116404.82668 | 37.7914008937989 | -122.43428818627198 | (37.7914008937989, -122.434288186272) | |||
| 6527 | 6527 | 18518 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 655 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6010076.89605 | 2116057.79617 | 37.7908595414795 | -122.409013611597 | (37.7908595414795, -122.409013611597) | |||
| 6535 | 6535 | 23531 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1991 12:00:00 AM | 12 | 3x14 | 6005745.76756 | 2119852.67475 | 37.801035747261096 | -122.42426915231701 | (37.8010357472611, -122.424269152317) | ||
| 6581 | 6581 | 18689 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 210 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999128.28109 | 2119816.58855 | 37.800560783808706 | -122.44716580436899 | (37.8005607838087, -122.447165804369) | |||
| 6604 | 6604 | 105538 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2098X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 10x7 | 6003015.95136 | 2119274.793 | 37.7992945167788 | -122.43367415343398 | (37.7992945167788, -122.433674153434) | |||
| 6618 | 6618 | 11039 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1530 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007477.10012 | 2117617.5169599997 | 37.7949961710995 | -122.418119433479 | (37.7949961710995, -122.418119433479) | |||
| 6647 | 6647 | 23432 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1946 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X3 | 6006100.2402099995 | 2117213.04995 | 37.7938080137776 | -122.42285481909799 | (37.7938080137776, -122.422854819098) | |||
| 6742 | 6742 | 11038 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1520 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007480.78096 | 2117584.84386 | 37.7949066660644 | -122.41810437973801 | (37.7949066660644, -122.418104379738) | |||
| 6745 | 6745 | 7365 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2360 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002776.693940001 | 2116420.21341 | 37.791443000945705 | -122.43429787376002 | (37.7914430009457, -122.43429787376) | |||
| 6780 | 6780 | 105542 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2098X Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 10x6 | 6002909.68864 | 2119260.2606900004 | 37.7992485848011 | -122.434040819625 | (37.7992485848011, -122.434040819625) | |||
| 6822 | 6822 | 93476 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 113X Leroy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Tree 1 on Leroy. | 6008309.35619 | 2116677.55783 | 37.79246208300879 | -122.41517312764499 | (37.7924620830088, -122.415173127645) | ||
| 6842 | 6842 | 18517 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 655 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6010074.04531 | 2116083.22982 | 37.7909292164576 | -122.409025270411 | (37.7909292164576, -122.409025270411) | |||
| 6857 | 6857 | 18904 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2600 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6002312.77813 | 2115782.03277 | 37.789664378452 | -122.435857329676 | (37.789664378452, -122.435857329676) | |||
| 6858 | 6858 | 11115 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2044 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007228.08245 | 2119404.68115 | 37.799889257353705 | -122.419107900836 | (37.7998892573537, -122.419107900836) | |||
| 6860 | 6860 | 93474 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1345 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x2 | 6008356.752640001 | 2116586.1732799998 | 37.792213826952704 | -122.41500266293501 | (37.7922138269527, -122.415002662935) | |||
| 6866 | 6866 | 11041 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1535 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007427.37776 | 2117642.45986 | 37.7950618593598 | -122.418293249932 | (37.7950618593598, -122.418293249932) | |||
| 6868 | 6868 | 88774 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2580 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777079 | 6001246.21661 | 2117291.33076 | 37.79374787431421 | -122.43965576381399 | (37.7937478743142, -122.439655763814) | |
| 6869 | 6869 | 61837 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1945 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2014 12:00:00 AM | 8 | 3x3 | Permit Number 772931 | 6005379.73194 | 2116818.03322 | 37.792682717295 | -122.425319723246 | (37.792682717295, -122.425319723246) | |
| 6871 | 6871 | 9692 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 330 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005977.63731 | 2110934.31764 | 37.7765612454456 | -122.422832604057 | (37.7765612454456, -122.422832604057) | |||
| 6882 | 6882 | 11093 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1920 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007292.220869999 | 2118935.81145 | 37.7986054706223 | -122.41885268582199 | (37.7986054706223, -122.418852685822) | |||
| 6888 | 6888 | 27268 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2080 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6006061.90991 | 2117499.35626 | 37.794591976178296 | -122.423007804569 | (37.7945919761783, -122.423007804569) | |||
| 6910 | 6910 | 2812 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009199.61723 | 2116339.14024 | 37.7915828617187 | -122.41206885950301 | (37.7915828617187, -122.412068859503) | |||
| 6913 | 6913 | 42637 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x4 | Permit Number 42688 | 6005203.48268 | 2118840.06651 | 37.7982247489172 | -122.42607356463999 | (37.7982247489172, -122.42607356464) |
| 6920 | 6920 | 11030 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1456 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007504.98953 | 2117411.4555 | 37.7944319472334 | -122.418008316826 | (37.7944319472334, -122.418008316826) | |||
| 6936 | 6936 | 113768 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2580 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777079 | 6001245.42868 | 2117302.08267 | 37.7937773514059 | -122.43965926129101 | (37.7937773514059, -122.439659261291) | |
| 6965 | 6965 | 45818 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2260 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 3 | Permit Number 773615 | 6003397.29034 | 2116914.4207200003 | 37.7928351730475 | -122.43218593195499 | (37.7928351730475, -122.432185931955) | ||
| 6980 | 6980 | 98636 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3500X Fillmore St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 6x6 | 6002249.0569400005 | 2120273.69699 | 37.8019937006086 | -122.436399401415 | (37.8019937006086, -122.436399401415) | ||
| 7044 | 7044 | 115410 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2025 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 5999874.89435 | 2115932.55527 | 37.7899388875113 | -122.444302954718 | (37.7899388875113, -122.444302954718) | |||
| 7046 | 7046 | 23478 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2415 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 6x6 | 6005787.44434 | 2118746.70558 | 37.798001390610104 | -122.424046238267 | (37.7980013906101, -122.424046238267) | |||
| 7049 | 7049 | 11022 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1414 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3X3 | 6007530.75353 | 2117243.19197 | 37.793971387332704 | -122.417907236642 | (37.7939713873327, -122.417907236642) | |||
| 7085 | 7085 | 42636 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x5 | Permit Number 42688 | 6005181.30457 | 2118838.80185 | 37.7982200229931 | -122.426150217479 | (37.7982200229931, -122.426150217479) |
| 7086 | 7086 | 6376 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 311X Elm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006100.46192 | 2112621.53299 | 37.7812008577844 | -122.422527635837 | (37.7812008577844, -122.422527635837) | |||
| 7104 | 7104 | 11125 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2115 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007141.03643 | 2119683.43961 | 37.8006497555411 | -122.419428900332 | (37.8006497555411, -122.419428900332) | |||
| 7126 | 7126 | 18854 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2222 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6003994.67741 | 2116017.3776 | 37.790405972895705 | -122.430054924512 | (37.7904059728957, -122.430054924512) | |||
| 7146 | 7146 | 100477 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 340 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009834.90147 | 2114634.4517 | 37.7869378210564 | -122.40975039469102 | (37.7869378210564, -122.409750394691) | |||
| 7160 | 7160 | 4592 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2016 01:42:00 PM | 3 | 3x3 | 6011401.079390001 | 2118088.92644 | 37.796510626729706 | -122.40457501395299 | (37.7965106267297, -122.404575013953) | ||
| 7181 | 7181 | 27269 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2080 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006059.706040001 | 2117511.63162 | 37.7946255568702 | -122.423016303153 | (37.7946255568702, -122.423016303153) | |||
| 7182 | 7182 | 106215 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 585X Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 14 | 3x5 | 6010717.90235 | 2115854.24398 | 37.79033652277371 | -122.406781396238 | (37.7903365227737, -122.406781396238) | |||
| 7199 | 7199 | 23528 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005747.5216 | 2119833.83468 | 37.800984116282294 | -122.42426174187901 | (37.8009841162823, -122.424261741879) | |||
| 7200 | 7200 | 11029 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1450 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007510.83027 | 2117372.9611299997 | 37.7943265799737 | -122.417985376942 | (37.7943265799737, -122.417985376942) | |||
| 7205 | 7205 | 18500 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 519X Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6010154.14929 | 2115557.66128 | 37.789490618641295 | -122.408711019419 | (37.7894906186413, -122.408711019419) | |||
| 7209 | 7209 | 106548 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1439 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6006143.70032 | 2118621.75372 | 37.797678411694 | -122.422804603669 | (37.797678411694, -122.422804603669) | |||
| 7221 | 7221 | 109623 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 451 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775170 | 6011938.15364 | 2118065.18841 | 37.79647544883721 | -122.402714938942 | (37.7964754488372, -122.402714938942) | |
| 7245 | 7245 | 7988 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2123 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005523.45781 | 2117337.0408 | 37.794115900277205 | -122.424859366576 | (37.7941159002772, -122.424859366576) | |||
| 7281 | 7281 | 99181 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 350 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6008511.54291 | 2122127.64338 | 37.807438020907995 | -122.41485945401001 | (37.807438020908, -122.41485945401) | |||
| 7302 | 7302 | 23523 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2775 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4x5 | 6005638.08926 | 2119818.65991 | 37.800936270543204 | -122.424639344747 | (37.8009362705432, -122.424639344747) | |||
| 7303 | 7303 | 7359 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2318 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002798.384190001 | 2116304.6096200002 | 37.7911268136944 | -122.434214557878 | (37.7911268136944, -122.434214557878) | |||
| 7315 | 7315 | 93472 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1329 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x2 | 6008412.15519 | 2116591.32221 | 37.7922310777524 | -122.414811333085 | (37.7922310777524, -122.414811333085) | |||
| 7318 | 7318 | 23526 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3X3 | 6005750.26843 | 2119815.94369 | 37.8009351472915 | -122.424250963512 | (37.8009351472915, -122.424250963512) | |||
| 7329 | 7329 | 18516 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 634 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6010126.27023 | 2116022.066 | 37.7907642007458 | -122.40884025649099 | (37.7907642007458, -122.408840256491) | |||
| 7336 | 7336 | 11048 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1563 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4x4 | 6007418.062059999 | 2117715.56837 | 37.7952620727512 | -122.418330669843 | (37.7952620727512, -122.418330669843) | |||
| 7354 | 7354 | 42635 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x5 | Permit Number 42688 | 6005113.3477300005 | 2118824.42387 | 37.7981767035488 | -122.426384344263 | (37.7981767035488, -122.426384344263) |
| 7378 | 7378 | 2811 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009171.094 | 2116334.89627 | 37.791569608406895 | -122.412167249844 | (37.7915696084069, -122.412167249844) | |||
| 7383 | 7383 | 11062 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1706 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X4 | 6007399.48222 | 2118181.2662299997 | 37.796539717095 | -122.418427996257 | (37.796539717095, -122.418427996257) | |||
| 7389 | 7389 | 18951 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2841 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6001216.78701 | 2115581.69582 | 37.789051985994 | -122.439634971495 | (37.789051985994, -122.439634971495) | |||
| 7416 | 7416 | 106674 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 399 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2014 12:00:00 AM | 3 | 4x6 | Permit Number 773354 | 5998100.3376400005 | 2115239.0542599997 | 37.787933313904 | -122.450392722053 | (37.787933313904, -122.450392722053) | |
| 7426 | 7426 | 113070 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3108 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6002434.36436 | 2118927.2467400003 | 37.7983072284463 | -122.435661765772 | (37.7983072284463, -122.435661765772) | |||
| 7431 | 7431 | 11084 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1861 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007276.02636 | 2118733.9286 | 37.7980502390811 | -122.41889439817899 | (37.7980502390811, -122.418894398179) | |||
| 7484 | 7484 | 11441 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2200X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 6005093.38761 | 2117287.76065 | 37.7939562886077 | -122.42634394583901 | (37.7939562886077, -122.426343945839) | |||
| 7491 | 7491 | 11081 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1844 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6007326.98106 | 2118697.88229 | 37.7979541339441 | -122.418715522107 | (37.7979541339441, -122.418715522107) | |||
| 7492 | 7492 | 110964 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2461 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6002930.46719 | 2116476.98281 | 37.7916076020582 | -122.43376988089899 | (37.7916076020582, -122.433769880899) | |||
| 7505 | 7505 | 11073 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1800 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007352.3421 | 2118515.8500200002 | 37.797455746746 | -122.418614850203 | (37.797455746746, -122.418614850203) | |||
| 7532 | 7532 | 11105 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2000 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007252.676530001 | 2119218.74255 | 37.7993801016803 | -122.41900960041401 | (37.7993801016803, -122.419009600414) | |||
| 7546 | 7546 | 7345 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2201 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/1995 12:00:00 AM | 20 | 3x3 | 6002814.8619099995 | 2115881.6003099997 | 37.789966273667396 | -122.434127293036 | (37.7899662736674, -122.434127293036) | ||
| 7611 | 7611 | 93477 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 113X Leroy Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 1.5x3 | Tree 2 on Leroy | 6008311.901880001 | 2116662.47431 | 37.7924208104303 | -122.415163251278 | (37.7924208104303, -122.415163251278) | ||
| 7636 | 7636 | 99241 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 560X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10 | 4x4 | 6008235.1228 | 2113825.75072 | 37.7846275436788 | -122.415228013286 | (37.7846275436788, -122.415228013286) | |||
| 7640 | 7640 | 11018 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1400 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6007538.39019 | 2117184.37476 | 37.793810319634396 | -122.417876641695 | (37.7938103196344, -122.417876641695) | |||
| 7646 | 7646 | 120112 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2602 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6001610.3249699995 | 2116996.65392 | 37.7929594854561 | -122.43837479737499 | (37.7929594854561, -122.438374797375) | |||
| 7647 | 7647 | 99242 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 560X Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 8 | 4x4 | 6008195.716580001 | 2113819.71845 | 37.7846087658129 | -122.415363918808 | (37.7846087658129, -122.415363918808) | |||
| 7648 | 7648 | 100475 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 340 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009838.89839 | 2114609.02446 | 37.786868227930604 | -122.40973477074101 | (37.7868682279306, -122.409734770741) | |||
| 7684 | 7684 | 101521 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3010 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | Permit Number 23924 | 6000238.846469999 | 2115823.4476799998 | 37.7896600644188 | -122.443035877412 | (37.7896600644188, -122.443035877412) | ||
| 7704 | 7704 | 23562 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2935 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005556.47012 | 2120448.2319400003 | 37.8026603041809 | -122.42496659992202 | (37.8026603041809, -122.424966599922) | |||
| 7752 | 7752 | 115670 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2600X Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777079 | 6001200.65079 | 2117319.78555 | 37.7938234101762 | -122.43981546632 | (37.7938234101762, -122.43981546632) | |
| 7758 | 7758 | 107629 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2166 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6001500.40723 | 2119762.44668 | 37.80054737492579 | -122.438953418459 | (37.8005473749258, -122.438953418459) | |||
| 7832 | 7832 | 7341 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2133 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002836.01293 | 2115704.12201 | 37.7894801640146 | -122.434041420394 | (37.7894801640146, -122.434041420394) | |||
| 7844 | 7844 | 23431 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1946 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006104.866909999 | 2117188.27203 | 37.7937402408798 | -122.42283704849301 | (37.7937402408798, -122.422837048493) | |||
| 7865 | 7865 | 4751 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1201 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6007679.06678 | 2121391.72732 | 37.8053705712658 | -122.41768823913601 | (37.8053705712658, -122.417688239136) | |||
| 7883 | 7883 | 26843 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 775213 | 6006968.35618 | 2110982.6622 | 37.7767498377733 | -122.419408844544 | (37.7767498377733, -122.419408844544) | ||
| 7892 | 7892 | 18840 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2085 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6004805.00638 | 2116081.2171099996 | 37.790627119781796 | -122.42725578824499 | (37.7906271197818, -122.427255788245) | |||
| 7893 | 7893 | 113778 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1753 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776886 | 6004527.88766 | 2119441.95127 | 37.7998391633122 | -122.428454248166 | (37.7998391633122, -122.428454248166) | |
| 7894 | 7894 | 19205 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 630 Sansome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1994 12:00:00 AM | 3 | 3X3 | 6012236.37693 | 2117925.3952900004 | 37.7961082565352 | -122.401673184994 | (37.7961082565352, -122.401673184994) | ||
| 7903 | 7903 | 23532 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1991 12:00:00 AM | 9 | 3x3 | 6005730.01613 | 2119881.88283 | 37.8011150557677 | -122.42432573765801 | (37.8011150557677, -122.424325737658) | ||
| 7911 | 7911 | 42632 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x4 | Permit Number 42688 | 6005134.3142099995 | 2118828.07494 | 37.7981879136105 | -122.42631205408199 | (37.7981879136105, -122.426312054082) |
| 7915 | 7915 | 11104 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2000 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007257.36758 | 2119194.77806 | 37.7993145653706 | -122.41899166703699 | (37.7993145653706, -122.418991667037) | |||
| 7916 | 7916 | 63582 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1370 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1987 12:00:00 AM | 7 | 3x3 | Permit Number 24205 | 6006460.0817 | 2118715.02595 | 37.797952359573 | -122.42171646446998 | (37.797952359573, -122.42171646447) |
| 7936 | 7936 | 18691 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 220 Richardson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5999098.6283 | 2119842.2472900003 | 37.8006295414886 | -122.447270262423 | (37.8006295414886, -122.447270262423) | |||
| 7955 | 7955 | 2559 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 626X Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6010139.86522 | 2115942.29028 | 37.790545917314795 | -122.40878758770201 | (37.7905459173148, -122.408787587702) | |||
| 7986 | 7986 | 7370 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2420 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002758.068969999 | 2116587.9502 | 37.7919025059375 | -122.434374313431 | (37.7919025059375, -122.434374313431) |
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");