Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 88593 | 88593 | 104720 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 63 SUSSEX ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6002455.5 | 2096493.1 | 37.7367097651894 | -122.43398416151399 | (37.7367097651894, -122.433984161514) | ||||
| 124459 | 124459 | 104719 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 61- 63 SUSSEX ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 771137 | 6002409.7 | 2096544.3 | 37.7368477492981 | -122.434146170859 | (37.7368477492981, -122.434146170859) | |||
| 80 | 80 | 225032 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4425 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2004 12:00:00 AM | 11 | Width 3ft | Permit Number 47310 | 6001257.01437 | 2105216.66208 | 37.7605944983664 | -122.43875275812799 | (37.7605944983664, -122.438752758128) | |
| 87 | 87 | 11032 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007492.86428 | 2117507.22815 | 37.794694232707 | -122.41805706457599 | (37.794694232707, -122.418057064576) | |||
| 181 | 181 | 9914 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1900 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 126 | 3X3 | 6005235.69262 | 2116267.9294 | 37.7911641319684 | -122.42577893234899 | (37.7911641319684, -122.425778932349) | |||
| 183 | 183 | 15429 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2125 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2015 12:00:00 AM | 15 | 4X4 | 6006871.98757 | 2105962.63928 | 37.762960616913205 | -122.41938599878401 | (37.7629606169132, -122.419385998784) | ||
| 206 | 206 | 4750 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1201 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6007660.31382 | 2121409.3470799997 | 37.8054178953714 | -122.417754386066 | (37.8054178953714, -122.417754386066) | |||
| 388 | 388 | 11057 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1630 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007426.31744 | 2117960.00612 | 37.795933702633796 | -122.418319444503 | (37.7959337026338, -122.418319444503) | |||
| 436 | 436 | 6932 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 500 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004980.8762 | 2110598.20876 | 37.775582081585895 | -122.42625675563801 | (37.7755820815859, -122.426256755638) | |||
| 448 | 448 | 224849 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | Permit Number 779889 | 6003244.1353400005 | 2095137.54828 | 37.733032453088704 | -122.431160782146 | (37.7330324530887, -122.431160782146) | ||
| 462 | 462 | 187628 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779889 | 6003236.0 | 2095183.0 | 37.7331567921798 | -122.431192151262 | (37.7331567921798, -122.431192151262) | |||
| 538 | 538 | 224356 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3122 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 20 | Width 4ft | Permit Number 16121 | 6005963.44888 | 2106707.74991 | 37.7649553019601 | -122.422581275918 | (37.7649553019601, -122.422581275918) | |
| 540 | 540 | 224369 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3159 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1981 12:00:00 AM | 16 | Width 3ft | Permit Number 18874 | 6005753.01157 | 2106639.16646 | 37.7647551137777 | -122.423304250809 | (37.7647551137777, -122.423304250809) | |
| 542 | 542 | 224353 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3024 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6006632.75905 | 2106740.0972599997 | 37.7650818572521 | -122.42026859194901 | (37.7650818572521, -122.420268591949) | |||
| 544 | 544 | 224355 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3120 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 23 | Width 6ft | Permit Number 16120 | 6005992.7506800005 | 2106707.14788 | 37.7649553019752 | -122.42247988543501 | (37.7649553019752, -122.422479885435) | |
| 559 | 559 | 224354 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3030 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 21 | Width 4ft | Permit Number 16115 | 6006614.25148 | 2106740.2812200002 | 37.7650813194782 | -122.420332618267 | (37.7650813194782, -122.420332618267) | |
| 562 | 562 | 15241 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1370 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 49662 | 6008042.0 | 2110573.0 | 37.7756854149614 | -122.415665767345 | (37.7756854149614, -122.415665767345) | ||
| 599 | 599 | 251330 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2232 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003295.0 | 2116396.0 | 37.791405922266996 | -122.43250281523301 | (37.791405922267, -122.432502815233) | ||||
| 762 | 762 | 7350 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2239 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002792.88059 | 2116041.24067 | 37.790403357673895 | -122.434214763813 | (37.7904033576739, -122.434214763813) | |||
| 910 | 910 | 7954 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1756 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6005736.45543 | 2116153.36588 | 37.7908778543671 | -122.424038156058 | (37.7908778543671, -122.424038156058) | |||
| 1182 | 1182 | 11089 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1900 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/10/2007 12:00:00 AM | 70 | 3X3 | 6007306.35542 | 2118856.39008 | 37.798388195314296 | -122.418798140138 | (37.7983881953143, -122.418798140138) | ||
| 1217 | 1217 | 113450 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 21X Leroy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008324.74095 | 2116562.6798400003 | 37.7921475208351 | -122.415111760598 | (37.7921475208351, -122.415111760598) | |||
| 1306 | 1306 | 127778 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1459 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 5ft | 6007455.77406 | 2117413.73976 | 37.794435449198495 | -122.418178770753 | (37.7944354491985, -122.418178770753) | |||
| 1568 | 1568 | 251592 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1999X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6007220.0 | 2119146.0 | 37.799178528828 | -122.41911751038602 | (37.799178528828, -122.419117510386) | |||
| 1752 | 1752 | 11021 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1407 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007490.12051 | 2117192.20597 | 37.7938291055709 | -122.41804421508002 | (37.7938291055709, -122.41804421508) | |||
| 1770 | 1770 | 192158 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 13 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | Permit Number 779453 | 6007102.0 | 2110018.0 | 37.7741086326202 | -122.418878096719 | (37.7741086326202, -122.418878096719) | ||
| 1783 | 1783 | 251690 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
| 1787 | 1787 | 11037 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1523 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007436.11305 | 2117588.78298 | 37.794914967702496 | -122.41825921689801 | (37.7949149677025, -122.418259216898) | |||
| 1802 | 1802 | 123705 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 448 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/1996 12:00:00 AM | 7 | Width 3ft | 5994163.86514 | 2111457.6280799997 | 37.7773244619044 | -122.46373753196501 | (37.7773244619044, -122.463737531965) | ||
| 1825 | 1825 | 224880 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 691 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2016 12:00:00 AM | 15 | Width 3ft | Permit Number 779045 | 6002530.35822 | 2095666.1320599997 | 37.734443349068606 | -122.43366625920099 | (37.7344433490686, -122.433666259201) | |
| 1913 | 1913 | 127946 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 855 Front St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 3ft | 6012709.78092 | 2119164.70922 | 37.7995375216859 | -122.400122182714 | (37.7995375216859, -122.400122182714) | ||
| 1924 | 1924 | 127943 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 3ft | 6012601.19681 | 2119174.02118 | 37.7995570351977 | -122.400498579547 | (37.7995570351977, -122.400498579547) | ||
| 2003 | 2003 | 127110 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3201 Laguna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 6ft | 6003718.35126 | 2119752.0994 | 37.8006449063974 | -122.431277695812 | (37.8006449063974, -122.431277695812) | |||
| 2013 | 2013 | 225525 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 27 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1981 12:00:00 AM | 25 | Width 3ft | Permit Number 19152 | 6003169.56249 | 2108141.44694 | 37.7687338691973 | -122.432347023007 | (37.7687338691973, -122.432347023007) | |
| 2060 | 2060 | 127860 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1898 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 6ft | 6007322.606430001 | 2118731.77235 | 37.798046941256 | -122.418733064272 | (37.798046941256, -122.418733064272) | |||
| 2116 | 2116 | 11044 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1550 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | 6007464.945230001 | 2117711.8455 | 37.795254489665 | -122.418168182118 | (37.795254489665, -122.418168182118) | |||
| 2140 | 2140 | 225336 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3030 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1980 12:00:00 AM | 15 | Width 2ft | Permit Number 18789 | 6002856.92306 | 2096000.60547 | 37.7353802609748 | -122.43256110120899 | (37.7353802609748, -122.432561101209) | |
| 2157 | 2157 | 127892 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2016 12:00:00 AM | 20 | Width 4ft | Resulted descion 9/7/16 -DE | 6010045.66816 | 2119169.32215 | 37.7994012851886 | -122.40934133534999 | (37.7994012851886, -122.40934133535) | |
| 2469 | 2469 | 48871 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 535 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2002 12:00:00 AM | 12 | 3x3 | Permit Number 46080 | 6011476.385009999 | 2118326.9888400002 | 37.797168496982 | -122.404331203243 | (37.797168496982, -122.404331203243) | |
| 2472 | 2472 | 224776 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1600 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 6ft | 6005221.0 | 2098972.0 | 37.743672820465896 | -122.42459890056001 | (37.7436728204659, -122.42459890056) | |||
| 2586 | 2586 | 225598 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 236 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/1986 12:00:00 AM | 16 | Width 3ft | Permit Number 22999 | 6003567.57753 | 2109171.0221700002 | 37.771583391799396 | -122.431043812717 | (37.7715833917994, -122.431043812717) | |
| 2646 | 2646 | 18988 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2939 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000733.58986 | 2115514.6365 | 37.7888403449574 | -122.44130195304301 | (37.7888403449574, -122.441301953043) | |||
| 2682 | 2682 | 102785 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3343 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 5.5x6 | Permit Number 772480 | 6003227.9831 | 2119876.64018 | 37.800959061171206 | -122.43298347232599 | (37.8009590611712, -122.432983472326) | ||
| 2697 | 2697 | 11019 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1401 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3x3 | 6007491.51177 | 2117162.78636 | 37.793748404921 | -122.418037314589 | (37.793748404921, -122.418037314589) | |||
| 2796 | 2796 | 101896 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1030 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | Permit Number 769674 | 6008183.011080001 | 2116026.65387 | 37.7906677592601 | -122.41556418166901 | (37.7906677592601, -122.415564181669) | ||
| 2879 | 2879 | 105455 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2307X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777222 | 6003193.66965 | 2116635.80681 | 37.7920586237566 | -122.43287055523899 | (37.7920586237566, -122.432870555239) | |
| 2893 | 2893 | 11107 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2016 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007247.08519 | 2119278.6571299997 | 37.799544297196995 | -122.419033200434 | (37.799544297197, -122.419033200434) | |||
| 3018 | 3018 | 128709 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4x Columbus Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 19 | Width 9ft | 6011726.08303 | 2117794.9108 | 37.795721488711294 | -122.403429729102 | (37.7957214887113, -122.403429729102) | |||
| 3069 | 3069 | 128380 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Waverly Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010746.0 | 2116993.0 | 37.7934648453026 | -122.406764467868 | (37.7934648453026, -122.406764467868) | |||
| 3213 | 3213 | 107592 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1812 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772847 | 5999539.4256 | 2115189.16926 | 37.7878785991598 | -122.44541016857 | (37.7878785991598, -122.44541016857) | |
| 3308 | 3308 | 220877 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 600X Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998682.13916 | 2105626.63204 | 37.7615733510574 | -122.44768755773701 | (37.7615733510574, -122.447687557737) | |||
| 3329 | 3329 | 110970 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2485 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6002790.71835 | 2116462.02658 | 37.791558605188705 | -122.434252340185 | (37.7915586051887, -122.434252340185) | |||
| 3358 | 3358 | 11102 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1987 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007225.03995 | 2119093.74122 | 37.799035323169704 | -122.419096361621 | (37.7990353231697, -122.419096361621) | |||
| 3407 | 3407 | 11127 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2124 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6007196.70195 | 2119630.59252 | 37.8005077858571 | -122.419232523471 | (37.8005077858571, -122.419232523471) | |||
| 3414 | 3414 | 102265 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2029 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6001885.4061199995 | 2115556.68597 | 37.789021347891 | -122.437319848541 | (37.789021347891, -122.437319848541) | |||
| 3499 | 3499 | 85478 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1745 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6007333.51995 | 2118328.0568 | 37.7969390538357 | -122.41866665564699 | (37.7969390538357, -122.418666655647) | |||
| 3516 | 3516 | 7363 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2343 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002738.924769999 | 2116408.16832 | 37.791407784388795 | -122.434427692684 | (37.7914077843888, -122.434427692684) | |||
| 3564 | 3564 | 127915 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1175 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6007842.32885 | 2121243.82267 | 37.8049736482837 | -122.417112761139 | (37.8049736482837, -122.417112761139) | |||
| 3607 | 3607 | 107433 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3000 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999745.83562 | 2116735.23196 | 37.792135462722705 | -122.444807206383 | (37.7921354627227, -122.444807206383) | |||
| 3655 | 3655 | 116023 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 755 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x5 | 6012121.98551 | 2118393.88956 | 37.7973882454367 | -122.40210195745199 | (37.7973882454367, -122.402101957452) | |||
| 3669 | 3669 | 128007 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 450 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2017 12:00:00 AM | 3 | Width 3ft | 6008574.61168 | 2121448.10995 | 37.8055757371873 | -122.414593071218 | (37.8055757371873, -122.414593071218) | ||
| 3671 | 3671 | 128005 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 444 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2017 12:00:00 AM | 3 | Width 3ft | 6008626.93235 | 2121456.53692 | 37.805601814825394 | -122.414412604251 | (37.8056018148254, -122.414412604251) | ||
| 3725 | 3725 | 51148 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1600X North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 47562 | 6003040.244080001 | 2121015.99755 | 37.804076787673104 | -122.43371460583799 | (37.8040767876731, -122.433714605838) | ||
| 3802 | 3802 | 11116 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2054 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007222.73261 | 2119440.0608900003 | 37.7999860999421 | -122.419128924277 | (37.7999860999421, -122.419128924277) | |||
| 3872 | 3872 | 62953 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1439 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1986 12:00:00 AM | 14 | 3x3 | Permit Number 23336 | 6006137.63839 | 2118621.23272 | 37.797676639130295 | -122.42282554258101 | (37.7976766391303, -122.422825542581) | |
| 3958 | 3958 | 49965 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1809 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2004 12:00:00 AM | 7 | Permit Number 47574 | 5999971.572269999 | 2115235.0808 | 37.7880293201371 | -122.443918325478 | (37.7880293201371, -122.443918325478) | ||
| 3995 | 3995 | 18900 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2590 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002437.1511699995 | 2115800.3303799997 | 37.789721683256296 | -122.435428321554 | (37.7897216832563, -122.435428321554) | |||
| 4248 | 4248 | 115669 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2600X Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777079 | 6001202.18162 | 2117312.3728400003 | 37.793803143947294 | -122.43980963780399 | (37.7938031439473, -122.439809637804) | |
| 4442 | 4442 | 11124 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2115 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/14/2002 12:00:00 AM | 3 | 3X3 | 6007136.72657 | 2119705.75668 | 37.8007107898386 | -122.41944539839899 | (37.8007107898386, -122.419445398399) | ||
| 4476 | 4476 | 94930 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1771 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6004538.80013 | 2118744.2703 | 37.7979241280397 | -122.428366733352 | (37.7979241280397, -122.428366733352) | |||
| 4539 | 4539 | 112349 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 60 Perine Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6002105.70967 | 2115571.30242 | 37.7890740023038 | -122.436558674947 | (37.7890740023038, -122.436558674947) | |||
| 4543 | 4543 | 224782 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3870 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/1976 12:00:00 AM | 23 | Width 4ft | Permit Number 16267 | 6004694.83499 | 2101360.27534 | 37.7502007447699 | -122.426588281746 | (37.7502007447699, -122.426588281746) | |
| 4624 | 4624 | 98532 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1805X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5999984.2458 | 2115196.51475 | 37.7879241507313 | -122.443871705528 | (37.7879241507313, -122.443871705528) | |||
| 4756 | 4756 | 11056 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1626 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007429.229230001 | 2117940.34689 | 37.795879887193706 | -122.418307974559 | (37.7958798871937, -122.418307974559) | |||
| 4878 | 4878 | 23564 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2945 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005549.1196800005 | 2120503.94425 | 37.8028128606857 | -122.424996002386 | (37.8028128606857, -122.424996002386) | |||
| 5148 | 5148 | 11040 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1529 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6007430.95213 | 2117616.8305599997 | 37.7949916888776 | -122.418279064023 | (37.7949916888776, -122.418279064023) | |||
| 5196 | 5196 | 225446 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4633 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1979 12:00:00 AM | 14 | Width 3ft | Permit Number 18031 | 6000267.22366 | 2105166.93872 | 37.760401610855496 | -122.442172414947 | (37.7604016108555, -122.442172414947) | |
| 5232 | 5232 | 11064 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1718 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x4 | 6007387.23956 | 2118261.4099 | 37.79675908240829 | -122.418476044354 | (37.7967590824083, -122.418476044354) | |||
| 5276 | 5276 | 64629 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1824 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1988 12:00:00 AM | 12 | 3x3 | Permit Number 25539 | 6004249.16577 | 2118756.87495 | 37.7979423438312 | -122.429369849745 | (37.7979423438312, -122.429369849745) | |
| 5284 | 5284 | 14661 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 683 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/14/2016 12:00:00 AM | 35 | 3x3 | 6005906.95663 | 2112062.04188 | 37.7796537135926 | -122.42315728808501 | (37.7796537135926, -122.423157288085) | ||
| 5444 | 5444 | 7347 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2226 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6002843.64008 | 2115975.51024 | 37.790225759563 | -122.43403443894199 | (37.790225759563, -122.434034438942) | |||
| 5474 | 5474 | 23494 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2517 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6005746.70695 | 2119056.5774 | 37.7988499198478 | -122.424209251152 | (37.7988499198478, -122.424209251152) | |||
| 5497 | 5497 | 23429 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1940 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6006113.16891 | 2117146.74095 | 37.7936266753722 | -122.422805369879 | (37.7936266753722, -122.422805369879) | |||
| 5534 | 5534 | 11055 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1623 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007391.69604 | 2117910.02014 | 37.7957945046705 | -122.41843569535 | (37.7957945046705, -122.41843569535) | |||
| 5558 | 5558 | 18892 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2512 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002699.44606 | 2115838.2675 | 37.789840741817706 | -122.43452352174499 | (37.7898407418177, -122.434523521745) | |||
| 5583 | 5583 | 11099 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1954 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007274.65529 | 2119058.52438 | 37.7989414204558 | -122.41892217641599 | (37.7989414204558, -122.418922176416) | |||
| 5680 | 5680 | 112346 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 21 Perine Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6002111.28405 | 2115552.10792 | 37.789021615903 | -122.436538013926 | (37.789021615903, -122.436538013926) | |||
| 5696 | 5696 | 98622 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3500X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 6x6 | 6002297.34528 | 2119958.5907400004 | 37.8011312453645 | -122.436209738003 | (37.8011312453645, -122.436209738003) | ||
| 5799 | 5799 | 9920 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1950 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005221.35655 | 2116381.71252 | 37.7914757416708 | -122.42583663734501 | (37.7914757416708, -122.425836637345) | |||
| 5844 | 5844 | 11094 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1919 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6007253.30573 | 2118908.87044 | 37.798529306126795 | -122.41898543293001 | (37.7985293061268, -122.41898543293) | |||
| 5848 | 5848 | 2810 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009146.78627 | 2116331.3706 | 37.7915585638337 | -122.412251105309 | (37.7915585638337, -122.412251105309) | |||
| 5868 | 5868 | 106881 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3261 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 778851 | 5999192.38841 | 2115631.9922700003 | 37.789074657915 | -122.446642721777 | (37.789074657915, -122.446642721777) | ||
| 5870 | 5870 | 11049 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1600 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007448.09091 | 2117829.58315 | 37.7955768192645 | -122.41823485247299 | (37.7955768192645, -122.418234852473) | |||
| 5911 | 5911 | 11043 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1544 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007466.55131 | 2117689.1178599996 | 37.795192175619704 | -122.41816101271601 | (37.7951921756197, -122.418161012716) | |||
| 5933 | 5933 | 11024 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1421 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | 6007479.55159 | 2117260.34001 | 37.7940155898903 | -122.418085617153 | (37.7940155898903, -122.418085617153) | |||
| 5942 | 5942 | 11045 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1555 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007422.39408 | 2117681.06672 | 37.7951675836594 | -122.418313232892 | (37.7951675836594, -122.418313232892) | |||
| 5945 | 5945 | 7354 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2302 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002812.8867 | 2116206.99877 | 37.790859622428705 | -122.43415739873899 | (37.7908596224287, -122.434157398739) | |||
| 5971 | 5971 | 11078 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1825X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6007296.45899 | 2118589.59773 | 37.7976550931564 | -122.41881345378799 | (37.7976550931564, -122.418813453788) | |||
| 6009 | 6009 | 103505 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1348 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008358.2632 | 2116617.67877 | 37.7923004181806 | -122.41499966729799 | (37.7923004181806, -122.414999667298) | |||
| 6013 | 6013 | 95273 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004855.86616 | 2110874.93767 | 37.776334844721 | -122.42670890691299 | (37.776334844721, -122.426708906913) |
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");