Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCareAssistant, DBH
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5807 | 5807 | 47379 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4453 Manzanita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45296 | ||||||||
10621 | 10621 | 52188 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 76 Camona Av | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2005 12:00:00 AM | Permit Number 48379 | ||||||||
15164 | 15164 | 51415 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 7121 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2004 12:00:00 AM | Permit Number 47739 | ||||||||
58110 | 58110 | 96111 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 458 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767766 | 5981315.73412 | 2112558.6605700003 | 37.7795988416807 | -122.508264340954 | (37.7795988416807, -122.508264340954) |
88120 | 88120 | 117006 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2131x 48TH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778271 | 5981288.0 | 2100567.0 | 37.7466715647644 | -122.50747029290599 | (37.7466715647644, -122.507470292906) | |
108687 | 108687 | 117004 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2131x 48TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778271 | 5981288.0 | 2100567.0 | 37.7466715647644 | -122.50747029290599 | (37.7466715647644, -122.507470292906) | |
122779 | 122779 | 117005 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2131x 48TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778271 | 5981288.0 | 2100567.0 | 37.7466715647644 | -122.50747029290599 | (37.7466715647644, -122.507470292906) | |
140053 | 140053 | 34715 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 827 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/2003 12:00:00 AM | Permit Number 46400 | 5981665.27623832 | 2110104.83266166 | 37.7728819439334 | -122.506873082789 | (37.7728819439334, -122.506873082789) | ||
33462 | 33462 | 68846 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 731 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1993 12:00:00 AM | 9 | Permit Number 32807 | 5982263.55129 | 2110779.79011 | 37.774770393997706 | -122.50485363813101 | (37.7747703939977, -122.504853638131) | ||
106958 | 106958 | 111435 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3498x SANTIAGO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 12 | 3x3 | Permit Number 776176 | 5982094.0 | 2099503.0 | 37.7437975622932 | -122.50460445512199 | (37.7437975622932, -122.504604455122) | |
109320 | 109320 | 111436 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3498x SANTIAGO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 776176 | 5982094.0 | 2099503.0 | 37.7437975622932 | -122.50460445512199 | (37.7437975622932, -122.504604455122) | ||
127503 | 127503 | 111437 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3498x SANTIAGO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 776176 | 5982094.0 | 2099503.0 | 37.7437975622932 | -122.50460445512199 | (37.7437975622932, -122.504604455122) | ||
31927 | 31927 | 117672 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 7751 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5982922.15587 | 2112497.69809 | 37.77952599164671 | -122.502702614984 | (37.7795259916467, -122.502702614984) | |||
163820 | 163820 | 117670 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 7751 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 2ft | 5982957.689809999 | 2112492.79061 | 37.779514605287794 | -122.502579326611 | (37.7795146052878, -122.502579326611) | |||
180856 | 180856 | 72281 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 730 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 8 | 5982929.242880001 | 2110803.7534 | 37.7748753302021 | -122.502552686167 | (37.7748753302021, -122.502552686167) | ||
67644 | 67644 | 70573 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 862 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 11 | 5982961.78283 | 2109923.12422 | 37.772459289826 | -122.502374937437 | (37.772459289826, -122.502374937437) | ||
124300 | 124300 | 115233 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 839 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775531 | 5983204.4 | 2110077.1 | 37.772896315318 | -122.501547107446 | (37.772896315318, -122.501547107446) | |||
33703 | 33703 | 117914 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 839 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5983220.24264 | 2110063.17362 | 37.7728590079713 | -122.501491276363 | (37.7728590079713, -122.501491276363) | |||
24619 | 24619 | 41597 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 552 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49968 | 5983505.71138 | 2112036.0358 | 37.77829267778829 | -122.500649732794 | (37.7782926777883, -122.500649732794) | |
45764 | 45764 | 117863 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 798 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5983563.66024 | 2110432.70706 | 37.7738938035198 | -122.50033069971902 | (37.7738938035198, -122.500330699719) | |||
163695 | 163695 | 117668 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4826 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5983640.52001 | 2111755.82857 | 37.7775312233534 | -122.500162667158 | (37.7775312233534, -122.500162667158) | |||
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) | |
113986 | 113986 | 115182 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 315 Lakeshore Dr | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 01/15/2016 12:00:00 AM | Permit Number 775158 | 5983956.6 | 2095109.9 | 37.7318446842931 | -122.497839799214 | (37.7318446842931, -122.497839799214) | |||
31345 | 31345 | 54056 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 839 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1972 12:00:00 AM | 12 | Permit Number 9778 | 5985079.18018 | 2110144.91058 | 37.7731924364746 | -122.495067118327 | (37.7731924364746, -122.495067118327) | ||
164458 | 164458 | 81965 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 838 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49958 | 5985125.36626 | 2110132.785 | 37.773161846833204 | -122.494906462717 | (37.7731618468332, -122.494906462717) | |
36732 | 36732 | 54017 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 848 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49959 | 5985128.25093 | 2110100.49047 | 37.7730733441171 | -122.494894102815 | (37.7730733441171, -122.494894102815) | |
145364 | 145364 | 109041 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1638 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773601 | 5985043.8 | 2104034.4 | 37.7564126199144 | -122.49473890921699 | (37.7564126199144, -122.494738909217) |
149632 | 149632 | 118249 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 735 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985364.18401 | 2110859.1562900003 | 37.7751702324246 | -122.49413391969101 | (37.7751702324246, -122.494133919691) | |||
134090 | 134090 | 65079 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3255 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/1989 12:00:00 AM | 3 | Permit Number 27043 | 5985440.9852599995 | 2111085.56905 | 37.7757963909815 | -122.49388493990101 | (37.7757963909815, -122.493884939901) | ||
132731 | 132731 | 118170 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3247 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5985457.87188 | 2111086.97623 | 37.77580124268229 | -122.49382662937599 | (37.7758012426823, -122.493826629376) | |||
58219 | 58219 | 118168 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3238 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5985471.03875 | 2111143.13059 | 37.775956196854 | -122.493785221511 | (37.775956196854, -122.493785221511) | |||
59804 | 59804 | 118171 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3239 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5985480.725380001 | 2111087.37265 | 37.7758036681834 | -122.493747603691 | (37.7758036681834, -122.493747603691) | |||
45388 | 45388 | 118167 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3238 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5985487.69599 | 2111143.2321 | 37.775957450089 | -122.493727608092 | (37.775957450089, -122.493727608092) | |||
41342 | 41342 | 118172 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3239 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5985496.239630001 | 2111086.82124 | 37.7758030618006 | -122.493693896102 | (37.7758030618006, -122.493693896102) | |||
102715 | 102715 | 49568 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1219@ LINCOLN 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2003 12:00:00 AM | Permit Number 46453 | 5985494.10343232 | 2106914.89929476 | 37.764348018167 | -122.4933938427 | (37.764348018167, -122.4933938427) | |||
122916 | 122916 | 51509 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 563 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2005 12:00:00 AM | Permit Number 47817 | 5985629.08933557 | 2112062.08741907 | 37.7784886350537 | -122.493306209382 | (37.7784886350537, -122.493306209382) | |||
95797 | 95797 | 114729 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1930 35TH AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/03/2015 12:00:00 AM | 4x4 | 5985421.0 | 2102058.0 | 37.7510080399178 | -122.493288836187 | (37.7510080399178, -122.493288836187) | |||
95940 | 95940 | 52780 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1360@ JUDAH 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2006 12:00:00 AM | Permit Number 48824 | 5985578.993883401 | 2105959.75073826 | 37.7617304118264 | -122.493029870185 | (37.7617304118264, -122.493029870185) | |||
106496 | 106496 | 109917 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1627 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775114 | 5985575.9 | 2104128.7 | 37.7567026728441 | -122.492905692842 | (37.7567026728441, -122.492905692842) |
109701 | 109701 | 85066 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1811 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2007 12:00:00 AM | Permit Number 49432 | 5985617.8 | 2102880.2 | 37.753277085239894 | -122.49266884038299 | (37.7532770852399, -122.492668840383) | |||
155053 | 155053 | 45593 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1774 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 0 | Permit Number 44329 | 5985674.90223921 | 2103150.11186705 | 37.7540215279835 | -122.492491247628 | (37.7540215279835, -122.492491247628) | |
88350 | 88350 | 62378 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1985 12:00:00 AM | 24 | Permit Number 22527 | 5986003.033530001 | 2111613.32749 | 37.7772783336166 | -122.491979564694 | (37.7772783336166, -122.491979564694) | |
50296 | 50296 | 68581 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1526 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | 0 | Permit Number 775949 | 5985927.704093 | 2104831.6030171 | 37.7586532178591 | -122.491740786234 | (37.7586532178591, -122.491740786234) | ||
111058 | 111058 | 117123 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2550 34TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2016 12:00:00 AM | 3 | 3x3 | 5985875.0 | 2097864.0 | 37.7395189911199 | -122.491410221624 | (37.7395189911199, -122.491410221624) | ||
127315 | 127315 | 117122 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2550 34TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2016 12:00:00 AM | 3 | 3x3 | 5985875.0 | 2097864.0 | 37.7395189911199 | -122.491410221624 | (37.7395189911199, -122.491410221624) | ||
82941 | 82941 | 109034 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2042 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772948 | 5986068.5 | 2101324.0 | 37.749030526651396 | -122.490995740125 | (37.7490305266514, -122.490995740125) |
46618 | 46618 | 47195 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 371 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 6 | Permit Number 45155 | 5986820.372830001 | 2113443.94443 | 37.7823524278539 | -122.489286791849 | (37.7823524278539, -122.489286791849) | |
68356 | 68356 | 47196 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 430 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 7 | Permit Number 45156 | 5986884.14198 | 2113014.7647599997 | 37.781177745194995 | -122.48903462038 | (37.781177745195, -122.48903462038) | |
46320 | 46320 | 42868 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2649 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 0 | Permit Number 42791 | 5986726.28385176 | 2097377.23824555 | 37.738232180805895 | -122.48843112739999 | (37.7382321808059, -122.4884311274) | |
159217 | 159217 | 47193 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 383 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 8 | Permit Number 45152 | 5987133.5813 | 2113398.4948 | 37.7822459140534 | -122.488199902231 | (37.7822459140534, -122.488199902231) | |
188081 | 188081 | 47192 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 383 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 8 | Permit Number 45152 | 5987134.96931 | 2113380.92602 | 37.782197756171705 | -122.488193808962 | (37.7821977561717, -122.488193808962) | |
71898 | 71898 | 119960 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 426 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5987190.151740001 | 2113069.49972 | 37.7813458874945 | -122.487980015327 | (37.7813458874945, -122.487980015327) | |||
44344 | 44344 | 67959 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 7 | Permit Number 31679 | 5987285.58651 | 2110436.7954700002 | 37.774122792273204 | -122.48745641247 | (37.7741227922732, -122.48745641247) | |
98139 | 98139 | 64711 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2609 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 775401 | 5987378.59458857 | 2114604.15746818 | 37.7855706107791 | -122.48744086841299 | (37.7855706107791, -122.487440868413) | |||
32706 | 32706 | 120106 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5987317.09594 | 2110472.8163099997 | 37.7742235329464 | -122.487350063639 | (37.7742235329464, -122.487350063639) | |||
162489 | 162489 | 120105 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5987348.97771 | 2110473.7803 | 37.7742280389644 | -122.48723985111201 | (37.7742280389644, -122.487239851112) | |||
27672 | 27672 | 120104 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5987387.7348 | 2110475.1455200003 | 37.7742340474401 | -122.48710588538201 | (37.7742340474401, -122.487105885382) | |||
163717 | 163717 | 45083 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2262 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 0 | Permit Number 43965 | 5987339.72795159 | 2099883.00478137 | 37.7451481265601 | -122.48649409498199 | (37.7451481265601, -122.486494094982) | |
143729 | 143729 | 45539 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 11 Middlefield Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | Permit Number 44294 | 5987258.11223173 | 2095792.07894073 | 37.7339107660531 | -122.48647600029699 | (37.7339107660531, -122.486476000297) | ||
62677 | 62677 | 50483 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 111 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2003 12:00:00 AM | 5 | Permit Number 47118 | 5987691.11202 | 2115193.54019 | 37.787207107765 | -122.48640295005501 | (37.787207107765, -122.486402950055) | ||
46044 | 46044 | 120186 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 172 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5987746.67951 | 2114854.71533 | 37.7862800304413 | -122.48618581827 | (37.7862800304413, -122.48618581827) | |||
152744 | 152744 | 87311 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 428 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50317 | 5987813.7000400005 | 2113048.96983 | 37.78132587294579 | -122.485821362783 | (37.7813258729458, -122.485821362783) | |
84066 | 84066 | 83339 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2233 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52332 | 5987590.2167451 | 2100087.03718588 | 37.7457229434205 | -122.485642930331 | (37.7457229434205, -122.485642930331) | ||
70911 | 70911 | 79412 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1679 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2007 12:00:00 AM | 0 | 3x3 | Permit Number 49865 | 5987771.24371713 | 2103876.50800139 | 37.756138359775896 | -122.485294985325 | (37.7561383597759, -122.485294985325) | |
148278 | 148278 | 114811 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2382 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | 3 | Permit Number 774444 | 5987696.7 | 2099087.7 | 37.7429852324249 | -122.48520141926501 | (37.7429852324249, -122.485201419265) | ||
61309 | 61309 | 120173 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2350 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5988251.07109 | 2111245.15539 | 37.7763985819689 | -122.484175967181 | (37.7763985819689, -122.484175967181) | |||
67039 | 67039 | 120355 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2270 Lake St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5988402.72558 | 2114696.23379 | 37.78588309898829 | -122.48390447116999 | (37.7858830989883, -122.48390447117) | |||
70304 | 70304 | 120354 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2270 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5988430.28754 | 2114697.53592 | 37.7858882787477 | -122.483809211099 | (37.7858882787477, -122.483809211099) | |||
60774 | 60774 | 67952 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 564 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 11 | Permit Number 31667 | 5988466.35449 | 2112153.3787599998 | 37.778904841146 | -122.48349784875201 | (37.778904841146, -122.483497848752) | |
83343 | 83343 | 115277 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1909 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 777409 | 5988585.4 | 2105743.7 | 37.7613125601848 | -122.48261621096201 | (37.7613125601848, -122.482616210962) | |||
80755 | 80755 | 115918 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3100X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989005.40184 | 2111951.8122900003 | 37.7783827554231 | -122.481618324321 | (37.7783827554231, -122.481618324321) | |||
117433 | 117433 | 115917 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3100X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989023.45884 | 2111952.8782599997 | 37.7783867322409 | -122.481555937234 | (37.7783867322409, -122.481555937234) | |||
30123 | 30123 | 120689 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 598 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5989116.38632 | 2111294.87868 | 37.7765854515948 | -122.48118627511299 | (37.7765854515948, -122.481186275113) | |||
118517 | 118517 | 431 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2010X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 20 | 3X3 | 5989200.24086 | 2114740.63501 | 37.786051407249 | -122.481148573701 | (37.786051407249, -122.481148573701) | ||
159263 | 159263 | 120760 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2000 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5989219.70066 | 2114726.96958 | 37.7860150171 | -122.481080247842 | (37.7860150171, -122.481080247842) | |||
171454 | 171454 | 120759 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2000 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5989240.60328 | 2114727.2324 | 37.786016953821004 | -122.481007950527 | (37.786016953821, -122.481007950527) | |||
176772 | 176772 | 120687 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2040 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5989191.37637 | 2111280.32009 | 37.776549837038495 | -122.48092579961501 | (37.7765498370385, -122.480925799615) | |||
164874 | 164874 | 43809 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301X 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 6 | Permit Number 43439 | 5989308.00445 | 2113283.29992 | 37.7820562394021 | -122.480669019793 | (37.7820562394021, -122.480669019793) | |
106971 | 106971 | 47879 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5715 (24box) Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2002 12:00:00 AM | Permit Number 45625 | 5989314.34720797 | 2112581.92190213 | 37.780130820333 | -122.480595717558 | (37.780130820333, -122.480595717558) | |||
53744 | 53744 | 43786 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 354 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 4 | Permit Number 43416 | 5989368.92132 | 2112957.36095 | 37.78116484258071 | -122.48043441215599 | (37.7811648425807, -122.480434412156) | |
81523 | 81523 | 115220 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 663 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 775475 | 5989383.4 | 2110828.4 | 37.775320149744296 | -122.48022845818001 | (37.7753201497443, -122.48022845818) | |||
108155 | 108155 | 12781 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1914 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1997 12:00:00 AM | 40 | 3X3 | 5989486.1909300005 | 2114733.67338 | 37.786048911885096 | -122.48015876501101 | (37.7860489118851, -122.480158765011) | ||
161848 | 161848 | 70149 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 754 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 8 | 5989468.1167 | 2110177.57013 | 37.773538072981204 | -122.479887770247 | (37.7735380729812, -122.479887770247) | ||
34216 | 34216 | 32016 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2920 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2002 12:00:00 AM | 7 | Permit Number 46155 | 5989557.12792 | 2111970.2291 | 37.7784653891782 | -122.479711067145 | (37.7784653891782, -122.479711067145) | |
128791 | 128791 | 12775 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1842 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 20 | 6 | 5989652.1071 | 2114741.09637 | 37.786078932501 | -122.47958528952 | (37.786078932501, -122.47958528952) | ||
116647 | 116647 | 81972 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1822 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2015 12:00:00 AM | 3 | 3x6 | Permit Number 774361 | 5989407.90008391 | 2102936.76390687 | 37.7536532824256 | -122.47956618379699 | (37.7536532824256, -122.479566183797) | |
141833 | 141833 | 109934 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1890 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775172 | 5989442.7 | 2102500.8 | 37.7524582627735 | -122.479413946447 | (37.7524582627735, -122.479413946447) |
40418 | 40418 | 42151 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 554 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 7 | Permit Number 42446 | 5989728.75072 | 2111581.12126 | 37.7774069754215 | -122.47908889577499 | (37.7774069754215, -122.479088895775) | |
82780 | 82780 | 82795 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1995 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 771189 | 5989705.78063845 | 2101796.33096673 | 37.7505392542177 | -122.478452670316 | (37.7505392542177, -122.478452670316) | ||
111229 | 111229 | 82794 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1995 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 771189 | 5989705.78063845 | 2101796.33096673 | 37.7505392542177 | -122.478452670316 | (37.7505392542177, -122.478452670316) | ||
91118 | 91118 | 81458 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1111 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49734 | 5989787.55086775 | 2099004.4958045 | 37.742878352926795 | -122.47796582741002 | (37.7428783529268, -122.47796582741) | ||
103314 | 103314 | 120914 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1356 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2016 12:00:00 AM | 3 | 3x3 | 5989939.0 | 2106143.0 | 37.7624875866057 | -122.477963922005 | (37.7624875866057, -122.477963922005) | ||
78095 | 78095 | 109876 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1631 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775090 | 5989917.1 | 2104254.5 | 37.7573010006541 | -122.47790160153099 | (37.7573010006541, -122.477901601531) |
137904 | 137904 | 35593 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 168 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1999 12:00:00 AM | 7 | Permit Number 41773 | 5990252.30789 | 2114278.94729 | 37.784844846933105 | -122.47747498791901 | (37.7848448469331, -122.477474987919) | ||
39912 | 39912 | 68348 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 518 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32167 | 5990339.7966 | 2111825.86021 | 37.7781144278241 | -122.476992997759 | (37.7781144278241, -122.476992997759) | |
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) | |
78031 | 78031 | 12721 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1535 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 20 | 3X3 | 5990655.40582 | 2114718.61196 | 37.7860754253896 | -122.476112538286 | (37.7860754253896, -122.476112538286) | ||
72944 | 72944 | 218771 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1418 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990557.09281 | 2105700.43464 | 37.7613082758806 | -122.47579386731701 | (37.7613082758806, -122.475793867317) | |||
154104 | 154104 | 218770 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1677 18th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990554.36808 | 2103987.92429 | 37.7566060203584 | -122.47567823607001 | (37.7566060203584, -122.47567823607) |
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");