Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
340 | 340 | 191854 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 573 10th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 24 | Width 6ft | tree is in ROW therefore DPW maintained | 6009977.72395 | 2108375.30106 | 37.7697596664942 | -122.408814503513 | (37.7697596664942, -122.408814503513) | ||
1502 | 1502 | 223929 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 610 Clipper St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779880 | 6001216.05485 | 2100901.84413 | 37.748744719898 | -122.43858524950599 | (37.748744719898, -122.438585249506) | |
167432 | 167432 | 105846 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 227-229 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 772678 | 6008913.98004 | 2110186.85299 | 37.774674124254 | -122.41262205766 | (37.774674124254, -122.41262205766) | ||
108488 | 108488 | 105973 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1336 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 771235 | 6006462.9 | 2119771.0 | 37.8008519560253 | -122.421781757787 | (37.8008519560253, -122.421781757787) | ||||
123804 | 123804 | 105974 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1336 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 771235 | 6006462.9 | 2119771.0 | 37.8008519560253 | -122.421781757787 | (37.8008519560253, -122.421781757787) | ||||
15438 | 15438 | 104819 | Planning Code 138.1 required 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 468 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770905 | 6011018.41682 | 2111922.08536 | 37.7795565535331 | -122.405464583724 | (37.7795565535331, -122.405464583724) | |
40488 | 40488 | 32598 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1488 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 770751 | 5985603.1005 | 2105094.5695 | 37.759356274150704 | -122.492882766578 | (37.7593562741507, -122.492882766578) | ||
172347 | 172347 | 32599 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1488 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 770751 | 5985602.7329 | 2105115.8853 | 37.7594147799348 | -122.492885607985 | (37.7594147799348, -122.492885607985) | ||
118530 | 118530 | 104452 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1045 Mission St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 2x6 | Permit Number 770594 | 6009749.9 | 2112056.4 | 37.7798543407434 | -122.40986242910299 | (37.7798543407434, -122.409862429103) | |||
98079 | 98079 | 104865 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 80 Stoneman St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770375 | 6007947.7 | 2099422.0 | 37.7450620347132 | -122.415202450973 | (37.7450620347132, -122.415202450973) | ||||
19560 | 19560 | 103375 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 22 VANDEWATER ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x2.5 | Permit Number 770057 | 6009069.0 | 2121391.0 | 37.8054466905223 | -122.41287812458401 | (37.8054466905223, -122.412878124584) | ||||
82947 | 82947 | 46916 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 161 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2013 12:00:00 AM | Permit Number 769519 | 6007338.4828929 | 2096787.18196624 | 37.7377931534639 | -122.41712235805201 | (37.7377931534639, -122.417122358052) | ||
103843 | 103843 | 43507 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 161 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2013 12:00:00 AM | Permit Number 769519 | 6007338.4828929 | 2096787.18196624 | 37.7377931534639 | -122.41712235805201 | (37.7377931534639, -122.417122358052) | |||
79414 | 79414 | 55370 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 177 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2011 12:00:00 AM | 2x3 | Permit Number 767959 | 5993373.59500695 | 2094436.22943113 | 37.7305425193622 | -122.465234638195 | (37.7305425193622, -122.465234638195) | ||
41375 | 41375 | 45055 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2311 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2011 12:00:00 AM | 1 | Permit Number 767715 | 5988234.443 | 2099548.661 | 37.7442822204704 | -122.483375858058 | (37.7442822204704, -122.483375858058) | ||
110154 | 110154 | 92101 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1076 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/2009 12:00:00 AM | 3x3 | Permit Number 52984 | 6005698.0 | 2102695.0 | 37.7539222521842 | -122.42321413605801 | (37.7539222521842, -122.423214136058) | ||
26017 | 26017 | 82939 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 741 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52449 | 6009171.80953 | 2110382.94472 | 37.775227013061 | -122.411744028881 | (37.775227013061, -122.411744028881) | |
184713 | 184713 | 66497 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2468 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51581 | 6001708.326 | 2114654.8124 | 37.786534966555 | -122.43786789884399 | (37.786534966555, -122.437867898844) | |
89160 | 89160 | 73475 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 340 Ritch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2008 12:00:00 AM | 3x3 | Permit Number 50288 | 6014252.15043428 | 2111690.62627274 | 37.7791012985319 | -122.394261419296 | (37.7791012985319, -122.394261419296) | ||
87641 | 87641 | 87256 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2 Garrison Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50279 | 6008242.3 | 2086782.6 | 37.710373499787394 | -122.413290127101 | (37.7103734997874, -122.413290127101) | |||
93982 | 93982 | 69756 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2008 12:00:00 AM | 3x3 | Permit Number 50279 | 6008252.26832326 | 2086801.73422247 | 37.710426598074605 | -122.41325702656601 | (37.7104265980746, -122.413257026566) | ||
108241 | 108241 | 87255 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2 Garrison Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2008 12:00:00 AM | 3x3 | Permit Number 50279 | 6008242.3 | 2086782.6 | 37.710373499787394 | -122.413290127101 | (37.7103734997874, -122.413290127101) | ||
143938 | 143938 | 87251 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50275 | 6008259.0 | 2086838.7 | 37.7105284764145 | -122.413236372693 | (37.7105284764145, -122.413236372693) | |||
171739 | 171739 | 73437 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 201 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2008 12:00:00 AM | 8 | 4x4 | Permit Number 50063 | 5992414.36096 | 2114080.94062 | 37.784426393924605 | -122.46998063366001 | (37.7844263939246, -122.46998063366) | |
79810 | 79810 | 68817 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 125 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2007 12:00:00 AM | Permit Number 49379 | 6000058.92001633 | 2094143.32486819 | 37.730121532663105 | -122.442101535638 | (37.7301215326631, -122.442101535638) | ||
90990 | 90990 | 84960 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2616 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2007 12:00:00 AM | Permit Number 49352 | 5988993.8 | 2097500.0 | 37.7387012975774 | -122.48060025376301 | (37.7387012975774, -122.480600253763) | |||
89550 | 89550 | 52895 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1642 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2006 12:00:00 AM | 3x3 | Permit Number 48894 | 5992495.5632863 | 2104272.70590883 | 37.757500303864 | -122.468985668503 | (37.757500303864, -122.468985668503) | ||
112971 | 112971 | 52587 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 690@ CABRILLO 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2006 12:00:00 AM | Permit Number 48680 | 5989145.55322023 | 2110639.08863484 | 37.774786529724494 | -122.48103735116399 | (37.7747865297245, -122.481037351164) | |||
178982 | 178982 | 51993 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1260 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2005 12:00:00 AM | 14 | Permit Number 48211 | 6007573.69475 | 2118185.59644 | 37.796561412322795 | -122.417825488274 | (37.7965614123228, -122.417825488274) | |
82285 | 82285 | 50882 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2055 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47392 | 5991593.93786831 | 2101441.81632133 | 37.7496752859252 | -122.471897503797 | (37.7496752859252, -122.471897503797) | ||
134985 | 134985 | 49935 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2526 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 14 | Permit Number 46695 | 5988329.1563 | 2098089.6264 | 37.7402816069206 | -122.48294145156 | (37.7402816069206, -122.48294145156) | |
84579 | 84579 | 49746 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 40@ LELAND Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | Permit Number 46545 | 6008551.24165341 | 2087877.47374564 | 37.7133971377495 | -122.412299691068 | (37.7133971377495, -122.412299691068) | ||
4251 | 4251 | 246122 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1518 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | Permit Number 46036 | 5998379.9097 | 2108286.3815 | 37.768859073318 | -122.448924438468 | (37.768859073318, -122.448924438468) | ||
99641 | 99641 | 48625 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1548 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45922 | 5992473.51988967 | 2104913.75628044 | 37.7592591867123 | -122.46910855694901 | (37.7592591867123, -122.469108556949) | ||
84343 | 84343 | 47201 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801X Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45157 | 5986666.180509999 | 2113215.9234599997 | 37.7817173456419 | -122.489803447111 | (37.7817173456419, -122.489803447111) |
106239 | 106239 | 47203 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801X Clement St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45157 | 5986727.74959 | 2113216.7702900004 | 37.7817232655044 | -122.48959051227101 | (37.7817232655044, -122.489590512271) |
115776 | 115776 | 47200 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801X Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45157 | 5986636.7904199995 | 2113215.6243 | 37.7817148081587 | -122.489905099586 | (37.7817148081587, -122.489905099586) |
138862 | 138862 | 47202 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2801X Clement St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 12 | 3x3 | Permit Number 45157 | 5986698.68199 | 2113217.08014 | 37.7817224192006 | -122.489691093913 | (37.7817224192006, -122.489691093913) |
101395 | 101395 | 46613 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 394 Fair Oaks St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44735. Tree 4 on 25th St. | 6005464.68638444 | 2101420.18882448 | 37.750408745884 | -122.423930345056 | (37.750408745884, -122.423930345056) | ||
121735 | 121735 | 46612 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 394 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44735. Tree 1 on 25th St | 6005464.68638444 | 2101420.18882448 | 37.750408745884 | -122.423930345056 | (37.750408745884, -122.423930345056) | ||
125434 | 125434 | 46586 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 498 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/05/2002 12:00:00 AM | Permit Number 44715 | 6005498.22104123 | 2100816.59479858 | 37.74875330870471 | -122.423771466824 | (37.7487533087047, -122.423771466824) | ||
110365 | 110365 | 46585 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 496 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/05/2002 12:00:00 AM | Permit Number 44714 | 6005497.60346294 | 2100827.74105942 | 37.748783878914296 | -122.423774394842 | (37.7487838789143, -122.423774394842) | ||
119632 | 119632 | 45473 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1301 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | Permit Number 44252 | 5993960.36650023 | 2094413.72258595 | 37.730514541433 | -122.463204465727 | (37.730514541433, -122.463204465727) | ||
126339 | 126339 | 41716 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 543 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44133 | 6008753.21337376 | 2096281.65864333 | 37.736484582007606 | -122.412195213265 | (37.7364845820076, -122.412195213265) | ||
12964 | 12964 | 44723 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1946 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 13 | Permit Number 43842 | 5989432.8015 | 2102080.7043 | 37.751304216428 | -122.47941744514699 | (37.751304216428, -122.479417445147) | |
91233 | 91233 | 44205 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 341 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1986 12:00:00 AM | Permit Number 43653 | 6007751.99799899 | 2097517.30165944 | 37.739821155436 | -122.415744314793 | (37.739821155436, -122.415744314793) | ||
43975 | 43975 | 43992 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 141 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | 13 | Permit Number 43551 | 6010011.61771 | 2107517.81839 | 37.7674071146631 | -122.408636765987 | (37.7674071146631, -122.408636765987) | ||
94001 | 94001 | 43523 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1442 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43199 | 6000900.07851404 | 2110723.16086375 | 37.7756936614931 | -122.44038215551001 | (37.7756936614931, -122.44038215551) | ||
90863 | 90863 | 43515 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 165 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43192 | 6007354.1406378 | 2096784.95342482 | 37.7377879152119 | -122.41706806363999 | (37.7377879152119, -122.41706806364) | ||
108551 | 108551 | 43516 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 165 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43192 | 6007354.1406378 | 2096784.95342482 | 37.7377879152119 | -122.41706806363999 | (37.7377879152119, -122.41706806364) | ||
118408 | 118408 | 43517 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 165 Newman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43192 | 6007354.1406378 | 2096784.95342482 | 37.7377879152119 | -122.41706806363999 | (37.7377879152119, -122.41706806364) | ||
167098 | 167098 | 43384 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 127 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2000 12:00:00 AM | 16 | Permit Number 43132 | 5993941.8721 | 2114666.09803 | 37.7861212585447 | -122.464738521118 | (37.7861212585447, -122.464738521118) | ||
11531 | 11531 | 43168 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 285 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 14 | 3x3 | Permit Number 42977 | 6005738.99154 | 2092366.96158 | 37.7255660943895 | -122.422338611837 | (37.7255660943895, -122.422338611837) |
101434 | 101434 | 43022 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 71 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42883 | 6005491.3790617995 | 2109225.31619528 | 37.7718412930396 | -122.424393129042 | (37.7718412930396, -122.424393129042) | ||
30141 | 30141 | 42966 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 160 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | Permit Number 42854 | 5997814.60948514 | 2104925.35351079 | 37.75959819679839 | -122.45063741216002 | (37.7595981967984, -122.45063741216) | |||
138666 | 138666 | 42670 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1575 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42698 | 6006081.025120299 | 2117910.0746573997 | 37.7957207841663 | -122.422970868865 | (37.7957207841663, -122.422970868865) | ||
86261 | 86261 | 42484 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 50 Phelan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997088.18001 | 2092254.3140099999 | 37.7247650096883 | -122.452235460018 | (37.7247650096883, -122.452235460018) | ||
95530 | 95530 | 42477 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 50 Phelan Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997094.69001 | 2092414.90401 | 37.7252063248445 | -122.45222453793501 | (37.7252063248445, -122.452224537935) | ||
117157 | 117157 | 42476 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 50 Phelan Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997093.60501 | 2092371.5010099998 | 37.725087088302104 | -122.452225158319 | (37.7250870883021, -122.452225158319) | ||
78184 | 78184 | 42222 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 661 Howard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | ||
78814 | 78814 | 42223 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 661 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | ||
92147 | 92147 | 42218 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 661 Howard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | ||
92358 | 92358 | 42224 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 661 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | ||
96781 | 96781 | 42220 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 661 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | ||
105957 | 105957 | 42221 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 661 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | ||
109004 | 109004 | 42219 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 661 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | ||
119378 | 119378 | 42217 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 661 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | ||
127455 | 127455 | 42182 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 715 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42466 | 6012416.63723338 | 2111137.79713862 | 37.77748115885579 | -122.400572401541 | (37.7774811588558, -122.400572401541) | ||
111119 | 111119 | 42127 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 57 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42423 | 5999631.06894657 | 2093753.11151717 | 37.729025705554704 | -122.44355264659401 | (37.7290257055547, -122.443552646594) | ||
145734 | 145734 | 42121 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 110 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42418 | 5999349.45513333 | 2095526.80253467 | 37.7338797805201 | -122.44465363726002 | (37.7338797805201, -122.44465363726) | ||
8274 | 8274 | 41820 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 848 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/2016 12:00:00 AM | 3 | Permit Number 42207 | 6000005.683999999 | 2111868.9913 | 37.7787888536845 | -122.44355840768 | (37.7787888536845, -122.44355840768) | |
84687 | 84687 | 41668 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 500 Corbett Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42131 | 5999528.76445246 | 2104225.15584588 | 37.7577735947767 | -122.44465870166599 | (37.7577735947767, -122.444658701666) | ||
102771 | 102771 | 38682 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1785 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/2000 12:00:00 AM | Permit Number 41971 | 5999225.65056076 | 2110784.42467282 | 37.7757663950795 | -122.446178803683 | (37.7757663950795, -122.446178803683) | ||
115512 | 115512 | 41136 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1890 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41875 | 5997533.67783563 | 2108867.16274176 | 37.7704053182028 | -122.451893385496 | (37.7704053182028, -122.451893385496) | ||
141513 | 141513 | 39210 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 101 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/1999 12:00:00 AM | Permit Number 41852 | 5998202.98711321 | 2108218.1904746 | 37.7686617185434 | -122.449531484363 | (37.7686617185434, -122.449531484363) | ||
140922 | 140922 | 40278 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 327 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41430 | 6006777.24179017 | 2101874.53362521 | 37.751730286943996 | -122.41942365408998 | (37.751730286944, -122.41942365409) | ||
112553 | 112553 | 39757 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 513 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41124 | 6002972.50040311 | 2103846.50934997 | 37.7569298331089 | -122.43272179816601 | (37.7569298331089, -122.432721798166) | ||
95191 | 95191 | 39732 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41104 | 6004245.08369654 | 2106017.71232833 | 37.7629635309961 | -122.428475481414 | (37.7629635309961, -122.428475481414) | ||
109085 | 109085 | 39733 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41104 | 6004245.08369654 | 2106017.71232833 | 37.7629635309961 | -122.428475481414 | (37.7629635309961, -122.428475481414) | ||
111572 | 111572 | 39734 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41104 | 6004245.08369654 | 2106017.71232833 | 37.7629635309961 | -122.428475481414 | (37.7629635309961, -122.428475481414) | ||
97152 | 97152 | 39662 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 340 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41053 | 5995802.87923545 | 2090583.42381532 | 37.7201034282275 | -122.45655778592199 | (37.7201034282275, -122.456557785922) | ||
81989 | 81989 | 39617 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 143 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1998 12:00:00 AM | Permit Number 41017 | 5997752.15145133 | 2106762.51515119 | 37.7646390036764 | -122.45098590004999 | (37.7646390036764, -122.45098590005) | |||
98607 | 98607 | 39097 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3014 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | 12 | 5x9 | Permit Number 40786 | 6008165.45158313 | 2103310.33864273 | 37.7557507733516 | -122.414724626281 | (37.7557507733516, -122.414724626281) |
157487 | 157487 | 38868 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2439 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 7 | Permit Number 40694 | 5987331.8721 | 2098675.8712 | 37.7418332004815 | -122.486432648249 | (37.7418332004815, -122.486432648249) | |
1985 | 1985 | 252841 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1763 Golden Gate Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1998 12:00:00 AM | 3x3 | Permit Number 40601 | 6001163.0 | 2111730.0 | 37.7784731541065 | -122.43954484007 | (37.7784731541065, -122.43954484007) | |||
93935 | 93935 | 38688 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1763 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | Permit Number 40601 | 6001154.46973963 | 2111747.51694807 | 37.7785207657155 | -122.439575605477 | (37.7785207657155, -122.439575605477) | ||
94433 | 94433 | 38683 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1785 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1998 12:00:00 AM | Permit Number 40599 | 5999225.65056076 | 2110784.42467282 | 37.7757663950795 | -122.446178803683 | (37.7757663950795, -122.446178803683) | |||
97389 | 97389 | 38684 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1785 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1998 12:00:00 AM | Permit Number 40599 | 5999225.65056076 | 2110784.42467282 | 37.7757663950795 | -122.446178803683 | (37.7757663950795, -122.446178803683) | |||
123872 | 123872 | 38685 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1785 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1998 12:00:00 AM | Permit Number 40599 | 5999225.65056076 | 2110784.42467282 | 37.7757663950795 | -122.446178803683 | (37.7757663950795, -122.446178803683) | |||
175378 | 175378 | 38350 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1666 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1998 12:00:00 AM | 0 | Permit Number 40417 | 5981619.44120207 | 2103744.31851256 | 37.7554151050669 | -122.506559824318 | (37.7554151050669, -122.506559824318) | |
65910 | 65910 | 38340 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1517 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2000 12:00:00 AM | 14 | Permit Number 40407 | 5982158.3822 | 2104738.8652 | 37.7581775666431 | -122.504769723467 | (37.7581775666431, -122.504769723467) | |
94979 | 94979 | 38022 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 180 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40233 | 5992584.62016279 | 2098022.80205393 | 37.740344819144795 | -122.468223027257 | (37.7403448191448, -122.468223027257) | |||
98015 | 98015 | 38023 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 180 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40233 | 5992584.62016279 | 2098022.80205393 | 37.740344819144795 | -122.468223027257 | (37.7403448191448, -122.468223027257) | ||
30876 | 30876 | 37950 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 609 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 17 | Permit Number 40190 | 6013298.71774 | 2104246.1656 | 37.7586074292188 | -122.397037638472 | (37.7586074292188, -122.397037638472) | |
40072 | 40072 | 37951 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 609 Connecticut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 12 | Permit Number 40190 | 6013298.65055 | 2104257.08873 | 37.7586374180095 | -122.397038636728 | (37.7586374180095, -122.397038636728) | |
92407 | 92407 | 37521 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1112 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 3x3 | Permit Number 39974 | 6007343.449516599 | 2115114.77721986 | 37.7881167428842 | -122.41840434148199 | (37.7881167428842, -122.418404341482) | |
138113 | 138113 | 37523 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1112 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 10 | Permit Number 39974 | 6007334.6804 | 2115172.44683 | 37.7882745958345 | -122.41843877194599 | (37.7882745958345, -122.418438771946) | |
153704 | 153704 | 37522 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1112 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 9 | Permit Number 39974 | 6007335.91955 | 2115154.21819 | 37.7882246142201 | -122.418433191643 | (37.7882246142201, -122.418433191643) | |
48476 | 48476 | 36977 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 181 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 16 | Permit Number 39602 | 5993647.32145 | 2114324.1067 | 37.7851652576674 | -122.46573272346599 | (37.7851652576674, -122.465732723466) | |
76522 | 76522 | 36974 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 181 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 10 | Permit Number 39602 | 5993649.0736 | 2114306.93888 | 37.7851182205824 | -122.46572541386601 | (37.7851182205824, -122.465725413866) |
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");