Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▼ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
154 | 154 | 830 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1384 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:15:00 PM | 3 | 5.5x6.5 | 5981549.5887 | 2105676.5499 | 37.7607163481902 | -122.506944712409 | (37.7607163481902, -122.506944712409) | ||
163 | 163 | 29943 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 242 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:23:00 PM | 3 | 3x3 | 5994593.32204167 | 2088106.90572275 | 37.7132339790874 | -122.460559423837 | (37.7132339790874, -122.460559423837) | ||
2218 | 2218 | 114579 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3 | 3x3 | 6002950.36974 | 2121305.2817599997 | 37.8048659859314 | -122.43404631360701 | (37.8048659859314, -122.434046313607) | ||
2333 | 2333 | 253025 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1754 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2017 12:00:00 AM | 3 | 5993444.58369 | 2103545.63859 | 37.7555587516047 | -122.465650780273 | (37.7555587516047, -122.465650780273) | |||
4320 | 4320 | 178028 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 398x Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 09:59:00 AM | 3 | Width 3ft | 6004185.0 | 2091264.0 | 37.7224498233553 | -122.427632084441 | (37.7224498233553, -122.427632084441) | ||
4352 | 4352 | 178029 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 398x Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 10:03:00 AM | 3 | Width 3ft | 6003930.0 | 2091029.0 | 37.7217901378795 | -122.428496818895 | (37.7217901378795, -122.428496818895) | ||
4422 | 4422 | 253158 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 07:47:00 AM | 3 | 3x3 | 6004446.0 | 2092174.0 | 37.7249632430066 | -122.426794641082 | (37.7249632430066, -122.426794641082) | ||
4434 | 4434 | 253623 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1331 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778744 | 5983976.422619999 | 2106100.27997 | 37.7620224120695 | -122.498582815109 | (37.7620224120695, -122.498582815109) | |
4745 | 4745 | 253432 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501X Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2017 04:09:00 PM | 3 | 3x3 | 6002703.0 | 2090930.0 | 37.721448793681 | -122.43273116699801 | (37.721448793681, -122.432731166998) | ||
4758 | 4758 | 161382 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 523 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2017 03:54:00 PM | 3 | Width 0ft | 6002614.99011 | 2090841.7835900001 | 37.721201579268495 | -122.43302909312901 | (37.7212015792685, -122.433029093129) | ||
4788 | 4788 | 253430 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501X Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2017 04:04:00 PM | 3 | 3x3 | 6002703.0 | 2090930.0 | 37.721448793681 | -122.43273116699801 | (37.721448793681, -122.432731166998) | ||
4805 | 4805 | 253431 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501X Madrid St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2017 04:07:00 PM | 3 | 3x3 | 6002703.0 | 2090930.0 | 37.721448793681 | -122.43273116699801 | (37.721448793681, -122.432731166998) | ||
4984 | 4984 | 44099 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1880 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774618 | 6003969.398019999 | 2119063.44467 | 37.798768262294395 | -122.43035980995701 | (37.7987682622944, -122.430359809957) | |
5769 | 5769 | 39272 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2740 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 3 | Permit Number 774808 | 5999918.5789 | 2117802.13868 | 37.7950747637355 | -122.44428621834999 | (37.7950747637355, -122.44428621835) | ||
5982 | 5982 | 39271 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2740 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2015 12:00:00 AM | 3 | Permit Number 774808 | 5999943.4858099995 | 2117805.21945 | 37.7950846436855 | -122.444200258451 | (37.7950846436855, -122.444200258451) | ||
6209 | 6209 | 91354 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2131 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 52063 | 6007623.63084 | 2119707.2305900003 | 37.8007422490107 | -122.417760608464 | (37.8007422490107, -122.417760608464) | |
6649 | 6649 | 114581 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3 | 3x3 | 6002967.5258 | 2121305.9196 | 37.8048687108976 | -122.433986988903 | (37.8048687108976, -122.433986988903) | ||
8240 | 8240 | 111918 | Section 143 8 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 41 Toledo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773012 | 6001705.38657 | 2120044.83908 | 37.801334410325104 | -122.438264349848 | (37.8013344103251, -122.438264349848) | |
8700 | 8700 | 94740 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3208 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53872 | 6001386.25296 | 2119488.63139 | 37.799789054867794 | -122.439328800002 | (37.7997890548678, -122.439328800002) | |
9112 | 9112 | 122861 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:43:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9186 | 9186 | 10962 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1431 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 3 | 3X4 | 6016563.2925523 | 2096760.0557493 | 37.7382333059102 | -122.385225528118 | (37.7382333059102, -122.385225528118) | ||
9209 | 9209 | 122858 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:48:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9268 | 9268 | 122855 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:30:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9272 | 9272 | 122860 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:54:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9280 | 9280 | 122859 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:46:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9291 | 9291 | 122856 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:13:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9327 | 9327 | 122854 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:40:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9354 | 9354 | 122862 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:57:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9406 | 9406 | 122857 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:17:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
9629 | 9629 | 173614 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2955 20th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776469 | 5990236.78382 | 2095590.4495400002 | 37.7335303227244 | -122.476163213901 | (37.7335303227244, -122.476163213901) | |
9631 | 9631 | 173613 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2955 20th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776469 | 5990236.78382 | 2095590.4495400002 | 37.7335303227244 | -122.476163213901 | (37.7335303227244, -122.476163213901) | |
9732 | 9732 | 106018 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5285 DIAMOND HEIGHTS BLVD | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/2016 07:34:00 AM | 3 | 3x3 | 6001339.5 | 2099171.1 | 37.7439995285584 | -122.438034420154 | (37.7439995285584, -122.438034420154) | ||
9823 | 9823 | 63407 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2125 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770314 | 6000344.0086 | 2116075.3402400003 | 37.790357690994504 | -122.442690122255 | (37.7903576909945, -122.442690122255) | |
10028 | 10028 | 161764 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 142 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779227 | 6000990.7389 | 2087787.91218 | 37.7127240669257 | -122.43842496696001 | (37.7127240669257, -122.43842496696) | |
10929 | 10929 | 28307 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1818 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2003 12:00:00 AM | 3 | 6000526.74804 | 2093584.98162 | 37.7286151010044 | -122.440444169789 | (37.7286151010044, -122.440444169789) | |||
11064 | 11064 | 25312 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 163 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 3 | 3X3 | 6000515.96101 | 2091667.5202400002 | 37.7233495775944 | -122.440344004183 | (37.7233495775944, -122.440344004183) | ||
11707 | 11707 | 28306 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1818 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2003 12:00:00 AM | 3 | 6000533.35164 | 2093598.6883900003 | 37.7286531126447 | -122.440422323457 | (37.7286531126447, -122.440422323457) | |||
12132 | 12132 | 99909 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 210 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774553 | 6009399.78383 | 2095020.3189400001 | 37.7330574731105 | -122.40987072487499 | (37.7330574731105, -122.409870724875) | |
12474 | 12474 | 28305 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1818 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2003 12:00:00 AM | 3 | 6000543.0489 | 2093613.5897099997 | 37.7286945803894 | -122.440389867794 | (37.7286945803894, -122.440389867794) | |||
12988 | 12988 | 904 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1179 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2016 12:00:00 AM | 3 | 2X2 | 6003419.3756099995 | 2094263.29224 | 37.7306418725253 | -122.430492572378 | (37.7306418725253, -122.430492572378) | ||
13984 | 13984 | 21894 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2068 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2003 12:00:00 AM | 3 | 2X3 | 6015677.89854 | 2105976.47682 | 37.7634906462863 | -122.388930084758 | (37.7634906462863, -122.388930084758) | ||
14019 | 14019 | 95844 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 152 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767916 | 6010308.44062 | 2112179.38157 | 37.7802233055096 | -122.40793885609502 | (37.7802233055096, -122.407938856095) | |
14663 | 14663 | 28516 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 117 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | 6010207.243969999 | 2112381.64795 | 37.7807730152091 | -122.40830321374901 | (37.7807730152091, -122.408303213749) | |||
14801 | 14801 | 22531 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6619 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2015 08:00:00 AM | 3 | 3X3 | 6012836.07271 | 2089639.80613 | 37.7184756630977 | -122.397613243265 | (37.7184756630977, -122.397613243265) | ||
15042 | 15042 | 94225 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 625 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53569 | 6014481.04423 | 2111852.0491299997 | 37.7795572495918 | -122.393480876451 | (37.7795572495918, -122.393480876451) | |
15078 | 15078 | 2525 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1570 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 02:24:00 PM | 3 | 3X3 | 6016567.66909 | 2098923.0431 | 37.7441726718323 | -122.385361080243 | (37.7441726718323, -122.385361080243) | ||
15100 | 15100 | 48913 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 77 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768553 | 6013169.41892 | 2106659.71709 | 37.765227311822294 | -122.397654097675 | (37.7652273118223, -122.397654097675) | |
15205 | 15205 | 102387 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 84 Harriet St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010709.4483199995 | 2111466.67522 | 37.778288823307 | -122.406501343779 | (37.778288823307, -122.406501343779) | |||
15592 | 15592 | 102388 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 90X Harriet St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010739.31321 | 2111434.0362400003 | 37.778200875001104 | -122.406395729189 | (37.7782008750011, -122.406395729189) | |||
16215 | 16215 | 2527 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1570 Burke Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 02:21:00 PM | 3 | 3X3 | 6016536.91868 | 2098947.33995 | 37.7442376847211 | -122.38546910231001 | (37.7442376847211, -122.38546910231) | ||
16928 | 16928 | 10096 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 737 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | 3 | 3x3 | 6005665.871 | 2104659.8313700003 | 37.7593154078879 | -122.42346492097602 | (37.7593154078879, -122.423464920976) | ||
17358 | 17358 | 4165 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3770 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2016 12:00:00 AM | 3 | 3X3 | Permit Number 774303 | 6005421.09901 | 2100523.30385 | 37.747943645176704 | -122.424017300779 | (37.7479436451767, -122.424017300779) | |
17386 | 17386 | 857 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 400X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2015 09:50:00 AM | 3 | 3x3 | 6008157.97396 | 2095088.68273 | 37.7331755118234 | -122.41416883853701 | (37.7331755118234, -122.414168838537) | ||
17728 | 17728 | 10153 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 978 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2016 06:51:00 AM | 3 | 3x4 | 6005672.85931 | 2103292.97405 | 37.7555627312558 | -122.423343584439 | (37.7555627312558, -122.423343584439) | ||
18209 | 18209 | 10188 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1148 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/05/2016 12:00:00 AM | 3 | 2x4 | 6005734.612380001 | 2102244.83146 | 37.75268825965679 | -122.423055527089 | (37.7526882596568, -122.423055527089) | ||
18648 | 18648 | 10186 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1130 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2015 04:47:00 AM | 3 | 4x5 | 6005723.69305 | 2102361.07491 | 37.753006821117296 | -122.423101549889 | (37.7530068211173, -122.423101549889) | ||
18695 | 18695 | 16874 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 269 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/21/2015 08:43:00 AM | 3 | 3X3 | 6005705.9301 | 2110300.3269 | 37.7748051262311 | -122.423727430112 | (37.7748051262311, -122.423727430112) | ||
19486 | 19486 | 10095 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 727 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 05:21:00 AM | 3 | 2X2 | 6005664.2360000005 | 2104708.85405 | 37.759449920391 | -122.423474060781 | (37.759449920391, -122.423474060781) | ||
19508 | 19508 | 90355 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 745 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993230.153419999 | 2111367.69142 | 37.777023672198794 | -122.46696097646699 | (37.7770236721988, -122.466960976467) | ||
19807 | 19807 | 93394 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3077 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5996268.61185 | 2111428.40102 | 37.777365269924296 | -122.456454460594 | (37.7773652699243, -122.456454460594) | ||
19942 | 19942 | 26077 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 261 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 02:44:00 PM | 3 | 3X3 | 5994378.441000001 | 2088053.8388 | 37.7130759052536 | -122.461298276453 | (37.7130759052536, -122.461298276453) | ||
20425 | 20425 | 10057 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 439 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2016 06:50:00 AM | 3 | 3X3 | 6005566.67326 | 2106440.43668 | 37.7641989307536 | -122.423934614407 | (37.7641989307536, -122.423934614407) | ||
20752 | 20752 | 27680 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 320 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/2014 06:28:00 AM | 3 | 3x3 | 6005461.15776 | 2107102.0666400003 | 37.7660096518439 | -122.42434662439501 | (37.7660096518439, -122.424346624395) | ||
21046 | 21046 | 10125 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 876 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2015 02:57:00 PM | 3 | 3x3 | 6005640.441980001 | 2103866.83654 | 37.757136594295396 | -122.423496489872 | (37.7571365942954, -122.423496489872) | ||
21524 | 21524 | 29079 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2261 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 3 | 3x3 | 6009682.37784 | 2104210.24464 | 37.7583068254181 | -122.40954209818199 | (37.7583068254181, -122.409542098182) | ||
21694 | 21694 | 10206 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1274 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2010 12:00:00 AM | 3 | 2X2 | 6005768.7769 | 2101585.68354 | 37.7508803192719 | -122.422890537479 | (37.7508803192719, -122.422890537479) | ||
21836 | 21836 | 10190 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1160 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/2015 09:38:00 AM | 3 | 2x2 | 6005734.23383 | 2102203.6860700003 | 37.7525752625596 | -122.42305391193001 | (37.7525752625596, -122.42305391193) | ||
21922 | 21922 | 10107 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 799X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2014 06:59:00 AM | 3 | 3x4 | 6005682.50344 | 2104371.2203900004 | 37.7585238884792 | -122.423386880525 | (37.7585238884792, -122.423386880525) | ||
22211 | 22211 | 10150 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 966 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/2012 12:00:00 AM | 3 | 3x3 | 6005669.65476 | 2103355.68664 | 37.7557347445795 | -122.423359124725 | (37.7557347445795, -122.423359124725) | ||
22225 | 22225 | 15638 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3620 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774763 | 6005333.2664 | 2097101.2564 | 37.7385425216055 | -122.42407769940901 | (37.7385425216055, -122.424077699409) | |
22422 | 22422 | 7875 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2014 02:38:00 PM | 3 | 4X4 | 6006070.45315 | 2113764.9909599996 | 37.7843388199314 | -122.422712735214 | (37.7843388199314, -122.422712735214) | ||
22883 | 22883 | 87745 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50407 | 5991511.567969999 | 2113344.3212599996 | 37.7823516120795 | -122.47305021920299 | (37.7823516120795, -122.473050219203) | |
23715 | 23715 | 242332 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 206 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004510.161859999 | 2099597.97023 | 37.7453514204499 | -122.42710138452101 | (37.7453514204499, -122.427101384521) | |||
25557 | 25557 | 242876 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3298 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6005033.62978 | 2106658.32415 | 37.7647670900596 | -122.425793770266 | (37.7647670900596, -122.425793770266) | |||
26555 | 26555 | 86964 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49931 | 6005636.01311 | 2119594.66675 | 37.800321125284704 | -122.424630586241 | (37.8003211252847, -122.424630586241) | |
26764 | 26764 | 242331 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 206 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004526.0717 | 2099598.82102 | 37.74535465619329 | -122.427046431465 | (37.7453546561933, -122.427046431465) | |||
30440 | 30440 | 123815 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1951 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992581.39914 | 2112024.84953 | 37.7787905839512 | -122.469253041386 | (37.7787905839512, -122.469253041386) | |||
30659 | 30659 | 51400 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 421 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3 | 3c3 | Permit Number 50561 | 6011183.79367 | 2112305.04226 | 37.7806173092731 | -122.404919441686 | (37.7806173092731, -122.404919441686) | |
31127 | 31127 | 92816 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 410 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2009 12:00:00 AM | 3 | 3x3 | Permit Number 53025 | 5997688.97866 | 2114964.50163 | 37.787155913848 | -122.451796128513 | (37.787155913848, -122.451796128513) | |
32720 | 32720 | 198344 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 451 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010981.61371 | 2112109.48263 | 37.780069044799106 | -122.40560510460101 | (37.7800690447991, -122.405605104601) | |||
33820 | 33820 | 198396 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 16 Moss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010197.36501 | 2111335.28961 | 37.7778994078643 | -122.408263568012 | (37.7778994078643, -122.408263568012) | |||
33823 | 33823 | 136938 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1277 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008610.97542 | 2116946.31505 | 37.7932169703383 | -122.41414853544201 | (37.7932169703383, -122.414148535442) | |||
33902 | 33902 | 201660 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 Dore St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6009127.89234 | 2109540.91695 | 37.7729125385177 | -122.411836435997 | (37.7729125385177, -122.411836435997) | |||
34285 | 34285 | 242910 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 360 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6004800.5697 | 2110038.5843599997 | 37.774035296231105 | -122.426840616201 | (37.7740352962311, -122.426840616201) | |||
35317 | 35317 | 123509 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2636 Fulton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 5995163.8038800005 | 2110297.4884900004 | 37.77419659482779 | -122.46019437077899 | (37.7741965948278, -122.460194370779) | |||
36728 | 36728 | 136945 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 805 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008467.13732 | 2120338.97067 | 37.802524280839705 | -122.414886453447 | (37.8025242808397, -122.414886453447) | |||
38531 | 38531 | 86963 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49931 | 6005615.529680001 | 2119592.0276 | 37.8003127220137 | -122.42470127923401 | (37.8003127220137, -122.424701279234) | |
42077 | 42077 | 123803 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2000 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992423.59842 | 2112076.50258 | 37.7789232893614 | -122.469802692686 | (37.7789232893614, -122.469802692686) | |||
45566 | 45566 | 123719 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 111 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995199.7628 | 2111434.37432 | 37.777320250731705 | -122.460152365551 | (37.7773202507317, -122.460152365551) | |||
48995 | 48995 | 52026 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 55 Elmira St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2005 12:00:00 AM | 3 | Permit Number 48241 | 6011182.7446 | 2096571.6762 | 37.7374169340467 | -122.403815649781 | (37.7374169340467, -122.403815649781) | ||
49590 | 49590 | 23252 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 780X Turk St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/1997 12:00:00 AM | 3 | 4X4 | 6006324.392990001 | 2112868.49551 | 37.7818915869358 | -122.42177049090598 | (37.7818915869358, -122.421770490906) | ||
52515 | 52515 | 123697 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 126 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995184.692290001 | 2111494.1895 | 37.777483620495296 | -122.46020883366998 | (37.7774836204953, -122.46020883367) | |||
53168 | 53168 | 87747 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301 14th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50407 | 5991512.01725 | 2113306.58012 | 37.7822480113305 | -122.47304591178002 | (37.7822480113305, -122.47304591178) | |
54906 | 54906 | 249573 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006042.707780001 | 2113571.74375 | 37.7838066452086 | -122.422794986325 | (37.7838066452086, -122.422794986325) | |||
55227 | 55227 | 92817 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 410 Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2009 12:00:00 AM | 3 | 3x3 | Permit Number 53025 | 5997687.50186 | 2114976.0364200003 | 37.787187500742 | -122.45180207032499 | (37.787187500742, -122.451802070325) | |
55529 | 55529 | 198315 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 335 Ritch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014439.67715 | 2111549.1897299998 | 37.778723367631706 | -122.39360278135 | (37.7787233676317, -122.39360278135) | |||
56614 | 56614 | 198357 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 581 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009825.28404 | 2111621.68868 | 37.7786649503536 | -122.40957095115299 | (37.7786649503536, -122.409570951153) | |||
57137 | 57137 | 123801 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2000 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992459.32859 | 2112076.63971 | 37.7789257310694 | -122.46967909888001 | (37.7789257310694, -122.46967909888) | |||
57172 | 57172 | 123813 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2001 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992407.3835 | 2112015.56897 | 37.778755044993794 | -122.469854348482 | (37.7787550449938, -122.469854348482) | |||
57224 | 57224 | 87746 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50407 | 5991512.22402 | 2113324.82166 | 37.7822981095395 | -122.473046527131 | (37.7822981095395, -122.473046527131) |
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");