Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
99492 | 99492 | 110751 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 510 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | Permit Number 775489 | 5981042.2 | 2112214.0 | 37.778636382962 | -122.509184994454 | (37.778636382962, -122.509184994454) | ||
37553 | 37553 | 87825 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 451 47th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3 | 2x3 | Permit Number 50716 | 5981267.84329 | 2112567.4887599996 | 37.7796202589611 | -122.508430668506 | (37.7796202589611, -122.508430668506) | |
46301 | 46301 | 87824 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 451 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3 | 2x3 | Permit Number 50716 | 5981268.94768 | 2112581.1831099996 | 37.7796579246713 | -122.50842786485799 | (37.7796579246713, -122.508427864858) | |
187658 | 187658 | 92257 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 862 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52706 | 5981411.16308 | 2109852.88199 | 37.7721751933845 | -122.50773337462299 | (37.7721751933845, -122.507733374623) | |
185931 | 185931 | 118627 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 494 46th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5981628.0956 | 2112437.91019 | 37.7792856992778 | -122.50717480668301 | (37.7792856992778, -122.507174806683) | |||
131729 | 131729 | 34701 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 546 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52703 | 5981643.1854 | 2112019.5317 | 37.7781378442384 | -122.507091560706 | (37.7781378442384, -122.507091560706) | |
65153 | 65153 | 50405 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 815 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52709 | 5981666.2240699995 | 2110158.20965 | 37.7730285573555 | -122.506873764155 | (37.7730285573555, -122.506873764155) | |
52139 | 52139 | 118798 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 810 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5982020.13723 | 2110219.13712 | 37.7732166816615 | -122.50565407298599 | (37.7732166816615, -122.505654072986) | |||
46117 | 46117 | 68549 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 543 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 3 | Permit Number 32436 | 5982217.68828 | 2112054.92779 | 37.7782688503059 | -122.50510680493 | (37.7782688503059, -122.50510680493) | |
186975 | 186975 | 119011 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 501 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5982518.7729400005 | 2112266.03771 | 37.778866206576794 | -122.504080901039 | (37.7788662065768, -122.504080901039) | |||
181943 | 181943 | 119012 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 501 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5982519.09297 | 2112280.9796700003 | 37.778907251633704 | -122.50408090101801 | (37.7789072516337, -122.504080901018) | |||
54483 | 54483 | 119001 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 623 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5982546.8216699995 | 2111525.4630400003 | 37.7768344548721 | -122.503929004913 | (37.7768344548721, -122.503929004913) | |||
61940 | 61940 | 92237 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52681 | 5982614.54862 | 2110914.94505 | 37.7751621329201 | -122.503649497706 | (37.7751621329201, -122.503649497706) | |
175243 | 175243 | 96075 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 411 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767701 | 5983103.04582 | 2113013.19289 | 37.7809520179972 | -122.50211500631399 | (37.7809520179972, -122.502115006314) |
158906 | 158906 | 82734 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 663 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52670 | 5983795.84033 | 2111312.2935099998 | 37.776322519429606 | -122.499592582815 | (37.7763225194296, -122.499592582815) | |
61829 | 61829 | 79376 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 683 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52671 | 5983799.61702 | 2111191.23616 | 37.7759903525694 | -122.499570569578 | (37.7759903525694, -122.499570569578) | |
156479 | 156479 | 94817 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 683 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52671 | 5983800.6479400005 | 2111169.09276 | 37.775929613686294 | -122.499565366534 | (37.7759296136863, -122.499565366534) |
90446 | 90446 | 90655 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3434 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984935.16156 | 2110442.47233 | 37.774001023784706 | -122.495587241992 | (37.7740010237847, -122.495587241992) | ||
47309 | 47309 | 118074 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 490 34th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5985345.158419999 | 2112648.80165 | 37.780082972151796 | -122.494331678402 | (37.7800829721518, -122.494331678402) | |||
114388 | 114388 | 28783 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6938 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5985480.3602 | 2112543.9942799998 | 37.7798031124689 | -122.493856235161 | (37.7798031124689, -122.493856235161) | |||
80503 | 80503 | 28782 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6938 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5985488.09937 | 2112541.18326 | 37.7797958470089 | -122.493829255147 | (37.7797958470089, -122.493829255147) | |||
59367 | 59367 | 118092 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6909 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5985489.9688800005 | 2112456.39359 | 37.7795631483254 | -122.493816537688 | (37.7795631483254, -122.493816537688) | |||
84850 | 84850 | 28781 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6938 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5985497.48939 | 2112543.62929 | 37.7798031124744 | -122.493796951714 | (37.7798031124744, -122.493796951714) | |||
184337 | 184337 | 118091 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6909 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5985501.15731 | 2112457.22496 | 37.779566085611 | -122.493777893955 | (37.779566085611, -122.493777893955) | |||
110260 | 110260 | 28780 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6918 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5985532.54019 | 2112610.11302 | 37.7799877082801 | -122.493680597714 | (37.7799877082801, -122.493680597714) | |||
73215 | 73215 | 250760 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 228 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5985903.61307 | 2114361.31306 | 37.7848177008131 | -122.492525911365 | (37.7848177008131, -122.492525911365) | |||
80522 | 80522 | 90634 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3040 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5986072.775219999 | 2110484.3905599997 | 37.774182669931996 | -122.49165518484101 | (37.774182669932, -122.491655184841) | ||
142580 | 142580 | 90633 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3040 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5986086.317840001 | 2110484.4196099997 | 37.7741835411504 | -122.491608341302 | (37.7741835411504, -122.491608341302) | ||
127018 | 127018 | 90632 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3040 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5986103.36345 | 2110484.3741200003 | 37.774184412397794 | -122.491549374976 | (37.7741844123978, -122.491549374976) | ||
108780 | 108780 | 92311 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2211 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5986022.3 | 2100155.2 | 37.7458186185696 | -122.491069496457 | (37.7458186185696, -122.491069496457) | |
121235 | 121235 | 108310 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1563 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | 5986200.157869999 | 2104606.03112 | 37.7580497793679 | -122.49078193256099 | (37.7580497793679, -122.490781932561) | |||
71891 | 71891 | 250874 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986467.3841 | 2114682.3933599996 | 37.7857322411853 | -122.490599105779 | (37.7857322411853, -122.490599105779) | |||
27626 | 27626 | 67962 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 859 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 3 | Permit Number 31683 | 5986944.37754 | 2110090.6261299998 | 37.773152403641205 | -122.488611249777 | (37.7731524036412, -122.488611249777) | |
169602 | 169602 | 119955 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 330 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5987168.01965 | 2113716.3796200003 | 37.7831207441699 | -122.48810412836 | (37.7831207441699, -122.48810412836) | |||
139650 | 139650 | 108635 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Lake St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774602 | 5987336.48113 | 2114673.56953 | 37.7857587403195 | -122.487591667787 | (37.7857587403195, -122.487591667787) |
30548 | 30548 | 45544 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 79 Riverton Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44297 | 5987024.26021 | 2095319.08797 | 37.732598422284205 | -122.48724975796301 | (37.7325984222842, -122.487249757963) | |
80739 | 80739 | 86034 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1284 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987415.003943 | 2106546.656914 | 37.763449099217404 | -122.486723028948 | (37.7634490992174, -122.486723028948) | ||
96409 | 96409 | 109901 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2271 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775113 | 5987275.3 | 2099830.0 | 37.7449988337527 | -122.486712981387 | (37.7449988337527, -122.486712981387) |
109447 | 109447 | 86018 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1550 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5987476.600405 | 2104728.077894 | 37.758459369903605 | -122.48637646604901 | (37.7584593699036, -122.486376466049) | ||
177958 | 177958 | 45540 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 159 Middlefield Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44295 | 5987294.0576 | 2094889.97142 | 37.7314359091244 | -122.48628552285801 | (37.7314359091244, -122.486285522858) | |
84503 | 84503 | 86007 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1742 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987522.322672 | 2103422.5340299997 | 37.7548773659795 | -122.48612250342899 | (37.7548773659795, -122.486122503429) | ||
129008 | 129008 | 86060 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1869 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987511.195169 | 2102571.5912409998 | 37.7525402584661 | -122.486098523179 | (37.7525402584661, -122.486098523179) | ||
144160 | 144160 | 86065 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1939 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987527.802452 | 2102087.3075490003 | 37.7512115136965 | -122.486005547987 | (37.7512115136965, -122.486005547987) | ||
77375 | 77375 | 86070 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2115 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987568.946045 | 2100884.101082 | 37.7479102288924 | -122.485774970523 | (37.7479102288924, -122.485774970523) | ||
91229 | 91229 | 86519 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1309 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987691.436672 | 2106370.804533 | 37.7629823684162 | -122.485754041828 | (37.7629823684162, -122.485754041828) | ||
161720 | 161720 | 88140 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2445 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51172 | 5987869.621169999 | 2113257.1957099997 | 37.78190086066029 | -122.485643191826 | (37.7819008606603, -122.485643191826) |
112294 | 112294 | 86074 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2237 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5987597.115499 | 2100061.217249 | 37.74565245070821 | -122.48561718118499 | (37.7456524507082, -122.485617181185) | ||
138906 | 138906 | 86075 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2241 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5987598.017854 | 2100035.189447 | 37.7455810378659 | -122.48561215120199 | (37.7455810378659, -122.485612151202) | ||
107372 | 107372 | 86078 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2253 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5987600.724922 | 2099957.1059939996 | 37.7453667992034 | -122.485597061296 | (37.7453667992034, -122.485597061296) | ||
39327 | 39327 | 120359 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2420 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5987914.20542 | 2114679.4285 | 37.7858085051505 | -122.48559336049802 | (37.7858085051505, -122.485593360498) | |||
184812 | 184812 | 94696 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2443 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53831 | 5987889.1247 | 2113258.0139599997 | 37.7819042437171 | -122.48557577955201 | (37.7819042437171, -122.485575779552) |
81351 | 81351 | 85991 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2222 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987633.933236 | 2100153.700526 | 37.7459085303186 | -122.48549665823 | (37.7459085303186, -122.48549665823) | ||
81410 | 81410 | 85988 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2258 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987642.054438 | 2099919.450203 | 37.7452658143921 | -122.48545138958299 | (37.7452658143921, -122.485451389583) | ||
175674 | 175674 | 45552 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 168 Sylvan Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2003 12:00:00 AM | 3 | Permit Number 44300 | 5987586.8772599995 | 2094815.36489 | 37.7312481217032 | -122.485267730441 | (37.7312481217032, -122.485267730441) | |
184323 | 184323 | 45553 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 168 Sylvan Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44300 | 5987588.08064 | 2094826.81646 | 37.7312796348483 | -122.485264410152 | (37.7312796348483, -122.485264410152) | |
141412 | 141412 | 86539 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1719 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987787.197497 | 2103588.458912 | 37.755348384307105 | -122.485218677787 | (37.7553483843071, -122.485218677787) | ||
120382 | 120382 | 86542 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1731 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987789.915173001 | 2103510.132538 | 37.755133479572294 | -122.485203532524 | (37.7551334795723, -122.485203532524) | ||
119872 | 119872 | 86543 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1739 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2011 12:00:00 AM | 3 | 3x3 | 5987791.726956 | 2103457.914967 | 37.7549902097756 | -122.485193435735 | (37.7549902097756, -122.485193435735) | ||
107220 | 107220 | 86544 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1743 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987792.632848 | 2103431.806163 | 37.75491857482479 | -122.48518838735201 | (37.7549185748248, -122.485188387352) | ||
144272 | 144272 | 86370 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1299X 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5987998.480578 | 2106474.452955 | 37.763284845117205 | -122.484699699179 | (37.7632848451172, -122.484699699179) | ||
113728 | 113728 | 85959 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1298X 26TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988007.0 | 2106798.0 | 37.764173712799 | -122.484693968894 | (37.764173712799, -122.484693968894) | ||
79666 | 79666 | 86376 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1343 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988009.291975 | 2106160.192246 | 37.7624226008214 | -122.484639253233 | (37.7624226008214, -122.484639253233) | ||
120983 | 120983 | 86378 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1361 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988013.321416 | 2106043.0662599998 | 37.762101239533294 | -122.484616725198 | (37.7621012395333, -122.484616725198) | ||
84650 | 84650 | 85958 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1300 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988039.866297 | 2106434.861495 | 37.7631785479619 | -122.48455365718 | (37.7631785479619, -122.48455365718) | ||
113189 | 113189 | 85956 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1334 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988047.4774629995 | 2106213.623528 | 37.762571532243705 | -122.484511104656 | (37.7625715322437, -122.484511104656) | ||
100303 | 100303 | 86387 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1515 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988049.8019900005 | 2104982.6702779997 | 37.7591918054497 | -122.4844127767 | (37.7591918054497, -122.4844127767) | ||
94546 | 94546 | 86392 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1579 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988064.154428 | 2104565.481775 | 37.758047154773294 | -122.48433254224199 | (37.7580471547733, -122.484332542242) | ||
88698 | 88698 | 85946 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1490 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988083.436249 | 2105168.393711 | 37.7597037099979 | -122.48431007589701 | (37.7597037099979, -122.484310075897) | ||
81586 | 81586 | 85943 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1538 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988095.160504 | 2104827.59989 | 37.7587686653948 | -122.484244534442 | (37.7587686653948, -122.484244534442) | ||
84020 | 84020 | 85942 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1542 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988096.057532 | 2104801.525596 | 37.758697124688894 | -122.48423951990299 | (37.7586971246889, -122.484239519903) | ||
108528 | 108528 | 85940 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1554 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988098.748614 | 2104723.302763 | 37.7584825026991 | -122.48422447635599 | (37.7584825026991, -122.484224476356) | ||
116951 | 116951 | 85937 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600X 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988110.016747 | 2104395.766944 | 37.7575838341785 | -122.484161486754 | (37.7575838341785, -122.484161486754) | ||
88119 | 88119 | 86581 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2547 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987979.82634 | 2097967.749244 | 37.7399266315394 | -122.48414034443701 | (37.7399266315394, -122.484140344437) | ||
97679 | 97679 | 86443 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2450 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987997.37774 | 2098622.10748 | 37.741724349066 | -122.484127634313 | (37.741724349066, -122.484127634313) | |
82772 | 82772 | 85934 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1630 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988116.725594 | 2104200.7569 | 37.7570487799795 | -122.484123984508 | (37.7570487799795, -122.484123984508) | ||
143250 | 143250 | 86436 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2574 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988026.00444 | 2097787.2202669997 | 37.7394336348182 | -122.48396744726001 | (37.7394336348182, -122.48396744726) | ||
117846 | 117846 | 90860 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2325 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988359.69279 | 2110509.77218 | 37.7743857485973 | -122.483746287708 | (37.7743857485973, -122.483746287708) | ||
101084 | 101084 | 12827 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2212 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 3 | 3X3 | 5988580.16808 | 2114701.5279099997 | 37.785907963353296 | -122.483290964922 | (37.7859079633533, -122.483290964922) | ||
120658 | 120658 | 12826 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2212 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2010 12:00:00 AM | 3 | 3X3 | 5988595.84675 | 2114702.3275900004 | 37.785911071486396 | -122.48323678034299 | (37.7859110714864, -122.483236780343) | ||
98643 | 98643 | 86320 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1701 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988402.93355 | 2103727.2102369997 | 37.755765207864705 | -122.483099472181 | (37.7557652078647, -122.483099472181) | ||
84968 | 84968 | 86321 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1723 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988408.134093 | 2103583.601964 | 37.7553712008265 | -122.483070961912 | (37.7553712008265, -122.483070961912) | ||
73877 | 73877 | 45531 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 47 Inverness Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44290 | 5988290.9031 | 2095585.94321 | 37.733404918983204 | -122.482890269181 | (37.7334049189832, -122.482890269181) | |
138413 | 138413 | 86332 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2263 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988533.319976 | 2099923.8448349996 | 37.745329766428 | -122.482369901671 | (37.745329766428, -122.482369901671) | ||
125543 | 125543 | 86250 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2242 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988568.6306529995 | 2100055.451314 | 37.7456931770541 | -122.48225744501998 | (37.7456931770541, -122.48225744502) | ||
140305 | 140305 | 86249 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2266 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988574.227066 | 2099899.242089 | 37.7452645932744 | -122.482226651217 | (37.7452645932744, -122.482226651217) | ||
165599 | 165599 | 68952 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 747 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 3 | Permit Number 32941 | 5988797.45218 | 2110217.11495 | 37.7736076654938 | -122.482210568345 | (37.7736076654938, -122.482210568345) | |
128926 | 128926 | 45513 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2917 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 3 | Permit Number 44278 | 5988534.980140001 | 2095768.80664 | 37.733921213495 | -122.482059828009 | (37.733921213495, -122.482059828009) | |
32529 | 32529 | 120326 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 738 23rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 2ft | 5988846.16685 | 2110288.25768 | 37.773805837099 | -122.48204727167901 | (37.773805837099, -122.482047271679) | |||
135870 | 135870 | 68953 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 750 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 3 | 3x3 | Permit Number 32942 | 5988850.38114 | 2110206.21118 | 37.7735808052559 | -122.48202668229901 | (37.7735808052559, -122.482026682299) |
42627 | 42627 | 68954 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 754 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 3 | Permit Number 32943 | 5988851.01728 | 2110187.80327 | 37.7735302992339 | -122.482023133058 | (37.7735302992339, -122.482023133058) | |
184160 | 184160 | 45526 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3001 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/2001 12:00:00 AM | 3 | Permit Number 44287 | 5988554.87545 | 2095154.91197 | 37.732236774288396 | -122.481946089834 | (37.7322367742884, -122.481946089834) | |
189048 | 189048 | 95921 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 275 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767619 | 5988991.254980001 | 2113497.8107 | 37.782626811071296 | -122.48178053312701 | (37.7826268110713, -122.481780533127) |
118310 | 118310 | 91129 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2100X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52620 | 5989031.082830001 | 2111274.17492 | 37.776523645314 | -122.481479844539 | (37.776523645314, -122.481479844539) | |
66348 | 66348 | 62035 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 526 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1985 12:00:00 AM | 3 | Permit Number 22108 | 5989101.14075 | 2111731.85837 | 37.777784389853004 | -122.481271020374 | (37.777784389853, -122.481271020374) | ||
27317 | 27317 | 45508 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2929 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 3 | Permit Number 44276 | 5988794.6572900005 | 2095738.11606 | 37.7338520448427 | -122.48115980898899 | (37.7338520448427, -122.481159808989) | |
41917 | 41917 | 45509 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2929 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 3 | Permit Number 44276 | 5988795.25848 | 2095722.9447599999 | 37.7338104233161 | -122.48115661998399 | (37.7338104233161, -122.481156619984) | |
88699 | 88699 | 86200 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2379 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988870.37374 | 2099150.307919 | 37.743225438056605 | -122.481147807758 | (37.7432254380566, -122.481147807758) | ||
145745 | 145745 | 86213 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2487 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988895.867106 | 2098417.748537 | 37.74121550369679 | -122.481006033613 | (37.7412155036968, -122.481006033613) | ||
106625 | 106625 | 86214 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2491 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2015 04:31:00 PM | 3 | 3x3 | 5988896.775501 | 2098391.645558 | 37.7411438845393 | -122.48100098197399 | (37.7411438845393, -122.481000981974) | ||
117047 | 117047 | 90579 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2050X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989191.56818 | 2110598.34198 | 37.774677325483 | -122.480875193908 | (37.774677325483, -122.480875193908) |
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");