Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34 | 34 | 240126 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006399.28254 | 2110261.0751 | 37.7747364652596 | -122.42132618837299 | (37.7747364652596, -122.421326188373) | |||
| 71 | 71 | 251206 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 270 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005145.0 | 2094297.0 | 37.7308320294825 | -122.424529217878 | (37.7308320294825, -122.424529217878) | ||||
| 73 | 73 | 65479 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1051 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1997 12:00:00 AM | 10 | 3x3 | Permit Number 28361 | 6008468.497880001 | 2115537.43749 | 37.789340533487795 | -122.41454177659901 | (37.7893405334878, -122.414541776599) |
| 131 | 131 | 237033 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 7 | : 4 | Tree 1 | DPW 2 | 6 | Width 4ft | 6005718.98472 | 2109769.85153 | 37.7733493059578 | -122.423644547079 | (37.7733493059578, -122.423644547079) | |||
| 135 | 135 | 237030 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 5 | Width 4ft | 6005725.94025 | 2109733.85532 | 37.773250861665204 | -122.423617927146 | (37.7732508616652, -122.423617927146) | |||
| 299 | 299 | 196427 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 McLea Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010117.0 | 2109248.0 | 37.772163696411795 | -122.408394314545 | (37.7721636964118, -122.408394314545) | |||
| 383 | 383 | 181340 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1360 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5988678.0351 | 2106085.8063 | 37.7622572799997 | -122.48232089502501 | (37.7622572799997, -122.482320895025) | |||
| 649 | 649 | 96374 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1315 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768288 | 6008916.2106800005 | 2117429.1962900003 | 37.7945599836999 | -122.41312655846599 | (37.7945599836999, -122.413126558466) | |
| 1237 | 1237 | 103805 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98X Hemlock St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006953.73656 | 2114843.50125 | 37.7873499398897 | -122.41973342786999 | (37.7873499398897, -122.41973342787) | ||
| 1252 | 1252 | 61532 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 347 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2017 12:00:00 AM | 3 | Permit Number 772896 | 5991195.07104 | 2113068.5037599998 | 37.781575964268896 | -122.474125016615 | (37.7815759642689, -122.474125016615) | |
| 1311 | 1311 | 237352 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3186 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 4x4 | 6008549.69387 | 2100618.49329 | 37.7483811527756 | -122.413205447889 | (37.7483811527756, -122.413205447889) | |||
| 1495 | 1495 | 213442 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2455 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2002 12:00:00 AM | 6 | Width 3ft | Permit Number 45711 | 5992014.67382 | 2098752.22599 | 37.742314697659204 | -122.470246761681 | (37.7423146976592, -122.470246761681) | |
| 1749 | 1749 | 251678 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1841 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989656.0 | 2102823.0 | 37.7533553254519 | -122.478699889248 | (37.7533553254519, -122.478699889248) | ||||
| 2028 | 2028 | 137540 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1510 Steiner St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002670.5536 | 2113409.7602 | 37.7831710382055 | -122.434449780345 | (37.7831710382055, -122.434449780345) | |||
| 2102 | 2102 | 196505 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3536 Jennings St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6013064.418880001 | 2089502.0027700001 | 37.7181099951501 | -122.39681428375299 | (37.7181099951501, -122.396814283753) | |||
| 2141 | 2141 | 18982 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2920 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000616.67404 | 2115546.70514 | 37.7889217363036 | -122.44170876675699 | (37.7889217363036, -122.441708766757) | |||
| 2424 | 2424 | 239429 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 565 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 5 | Width 2ft | Permit Number 51470 | 6001213.70363 | 2103034.08129 | 37.7545991976029 | -122.438746149019 | (37.7545991976029, -122.438746149019) | |
| 2617 | 2617 | 59596 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1401 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2014 12:00:00 AM | 0 | Permit Number 770950 | 6000181.59670606 | 2113731.76941076 | 37.7839135947641 | -122.443083674123 | (37.7839135947641, -122.443083674123) | ||
| 2636 | 2636 | 239448 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 224 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | 11 | Width 4ft | Permit Number 38139 | 6004193.01737 | 2096717.47365 | 37.7374242967807 | -122.427992792539 | (37.7374242967807, -122.427992792539) | |
| 2957 | 2957 | 238483 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 13 | Width 3ft | Permit Number 37768 | 6003709.010969999 | 2108821.61027 | 37.7706320052989 | -122.430529650538 | (37.7706320052989, -122.430529650538) | |
| 2962 | 2962 | 238484 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 7 | Width 3ft | Permit Number 37768 | 6003723.3725 | 2108822.3529 | 37.7706348579377 | -122.430480026835 | (37.7706348579377, -122.430480026835) | |
| 2996 | 2996 | 178926 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 406 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 780238 | 6000939.854169999 | 2092384.3608900001 | 37.7253419851205 | -122.43893003518801 | (37.7253419851205, -122.438930035188) | ||
| 3084 | 3084 | 238169 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1018 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1989 12:00:00 AM | 2 | Width 4ft | Permit Number 27197 | 6003120.08624 | 2102266.16095 | 37.7525989407879 | -122.432098539422 | (37.7525989407879, -122.432098539422) | |
| 3100 | 3100 | 124475 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 336 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 1 | Width 3ft | Permit Number 51142 | 5996295.75285 | 2110564.44719 | 37.7749946376288 | -122.456298087251 | (37.7749946376288, -122.456298087251) | |
| 3103 | 3103 | 238168 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1010 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1989 12:00:00 AM | 14 | Width 4ft | Permit Number 27196 | 6003119.41534 | 2102323.30502 | 37.7527558068522 | -122.432104939916 | (37.7527558068522, -122.432104939916) | |
| 3188 | 3188 | 213685 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 428 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/2002 12:00:00 AM | 9 | Width 2ft | Permit Number 45997 | 6000116.1968 | 2095121.7561599999 | 37.7328113412593 | -122.44197372410801 | (37.7328113412593, -122.441973724108) | |
| 3251 | 3251 | 214594 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 352 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2017 12:00:00 AM | 3 | Width 2ft | 5993402.37378 | 2105988.92272 | 37.7622649396058 | -122.465974283195 | (37.7622649396058, -122.465974283195) | ||
| 3396 | 3396 | 253424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | ||||
| 3412 | 3412 | 117560 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2304 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 4x4 | Permit Number 778613 | 6002499.39832 | 2117814.1104 | 37.7952545391263 | -122.435357062003 | (37.7952545391263, -122.435357062003) | |
| 3629 | 3629 | 103766 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101X Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006706.11036 | 2115484.69473 | 37.7890965465282 | -122.420635698799 | (37.7890965465282, -122.420635698799) | ||
| 3683 | 3683 | 213464 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/24/2005 12:00:00 AM | 2 | Width 3ft | Permit Number 48287 | 5993110.29995 | 2099700.9644 | 37.7449829754007 | -122.46652739502701 | (37.7449829754007, -122.466527395027) | |
| 3739 | 3739 | 237154 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 861 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1992 12:00:00 AM | 5 | Width 6ft | Permit Number 30833 | 6010197.69553 | 2104230.40256 | 37.7583910361238 | -122.407761316458 | (37.7583910361238, -122.407761316458) | |
| 3800 | 3800 | 213446 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 530 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993033.55222 | 2099443.36305 | 37.744271238444206 | -122.46677405027799 | (37.7442712384442, -122.466774050278) | |||
| 3822 | 3822 | 253559 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Cortes Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5993184.39566 | 2099612.1282900004 | 37.7447433294416 | -122.46626473273199 | (37.7447433294416, -122.466264732732) | ||||
| 3846 | 3846 | 239484 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 725 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2017 12:00:00 AM | 8 | Width 3ft | Permit Number 779370 | 6007401.15098 | 2095467.39415 | 37.7341728312175 | -122.416812207728 | (37.7341728312175, -122.416812207728) | |
| 3874 | 3874 | 239439 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x9 | 6004683.2193 | 2097236.31541 | 37.7388766398495 | -122.426334864463 | (37.7388766398495, -122.426334864463) | |||
| 4125 | 4125 | 135979 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.63841 | 2115164.21663 | 37.788227554109504 | -122.419939904112 | (37.7882275541095, -122.419939904112) | ||
| 4128 | 4128 | 135978 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006877.42 | 2115159.3392 | 37.788212853775896 | -122.420019889812 | (37.7882128537759, -122.420019889812) | ||
| 4141 | 4141 | 135981 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | Width 4ft | 6006885.98637 | 2115183.79121 | 37.7882804756017 | -122.419991987453 | (37.7882804756017, -122.419991987453) | ||
| 4143 | 4143 | 135982 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | Width 4ft | 6006867.714380001 | 2115184.1661400003 | 37.788280475609795 | -122.420055232261 | (37.7882804756098, -122.420055232261) | ||
| 4162 | 4162 | 135980 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.58425 | 2115187.77482 | 37.7882922360442 | -122.419941763898 | (37.7882922360442, -122.419941763898) | ||
| 4328 | 4328 | 28085 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2255 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6002770.4091 | 2114749.1272 | 37.786854268374796 | -122.43420010239201 | (37.7868542683748, -122.434200102392) | |||
| 4329 | 4329 | 239457 | Planning Code 138.1 required 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 165 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001959.66963 | 2096487.1672 | 37.7366653238346 | -122.435698035437 | (37.7366653238346, -122.435698035437) | |
| 4404 | 4404 | 239458 | Planning Code 138.1 required 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 165 Sussex St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001977.4736 | 2096494.97635 | 37.7366877772239 | -122.435637038029 | (37.7366877772239, -122.435637038029) | |
| 4456 | 4456 | 103803 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98X Hemlock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007001.17193 | 2114849.4881599997 | 37.7873690504995 | -122.419569735969 | (37.7873690504995, -122.419569735969) | ||
| 4533 | 4533 | 214732 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1999 12:00:00 AM | 8 | Width 2ft | Permit Number 41499 | 5994886.41967 | 2092806.74885 | 37.7261554857857 | -122.459886624766 | (37.7261554857857, -122.459886624766) | |
| 4537 | 4537 | 214730 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1999 12:00:00 AM | 8 | Width 2ft | Permit Number 41499 | 5994894.76005 | 2092775.8058599997 | 37.7260710034609 | -122.459855552309 | (37.7260710034609, -122.459855552309) | |
| 4542 | 4542 | 214731 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1999 12:00:00 AM | 8 | Width 2ft | Permit Number 41499 | 5994889.57203 | 2092796.33348 | 37.7261270689877 | -122.459874973176 | (37.7261270689877, -122.459874973176) | |
| 4600 | 4600 | 103784 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006741.56415 | 2115141.24736 | 37.788155522905505 | -122.420488644345 | (37.7881555229055, -122.420488644345) | ||
| 4704 | 4704 | 253666 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 578 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5993791.71774 | 2111566.05198 | 37.7776007134003 | -122.465032776868 | (37.7776007134003, -122.465032776868) | ||||
| 4797 | 4797 | 214559 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1342 Irving St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | Width 3ft | 5991532.56497 | 2106606.32246 | 37.7638521099028 | -122.472486197695 | (37.7638521099028, -122.472486197695) | ||
| 4821 | 4821 | 214558 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1340 Irving St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 4 | Width 3ft | 5991564.93185 | 2106609.34919 | 37.7638622938456 | -122.472374472204 | (37.7638622938456, -122.472374472204) | ||
| 4841 | 4841 | 88280 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3261 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778851 | 5999200.48769 | 2115630.5359099996 | 37.789071121774796 | -122.446614594592 | (37.7890711217748, -122.446614594592) | |
| 4845 | 4845 | 38140 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 423 Burrows St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | 2 | Permit Number 40297 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | |
| 4846 | 4846 | 76677 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 423 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 3 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | ||
| 4918 | 4918 | 43245 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 150 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 9 | Permit Number 43034 | 6010460.0 | 2093774.0 | 37.729694705520004 | -122.40611748494 | (37.72969470552, -122.40611748494) | |
| 5453 | 5453 | 21659 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1750 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2015 12:00:00 AM | 3 | 4X4 | Permit Number 774105 | 6004291.1629 | 2114663.74 | 37.786706012119296 | -122.428932556586 | (37.7867060121193, -122.428932556586) | |
| 5481 | 5481 | 103804 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98X Hemlock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006974.73956 | 2114845.21209 | 37.7873558205593 | -122.419660883156 | (37.7873558205593, -122.419660883156) | ||
| 5494 | 5494 | 87738 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005444.64461 | 2121623.98788 | 37.8058823097966 | -122.425437295217 | (37.8058823097966, -122.425437295217) | ||
| 5495 | 5495 | 21662 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1750 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2015 12:00:00 AM | 3 | 4X4 | Permit Number 774105 | 6004219.9241 | 2114651.242 | 37.7866676632245 | -122.42917813434201 | (37.7866676632245, -122.429178134342) | |
| 5641 | 5641 | 7950 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1735 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 3 | 3X3 | 6005696.54994 | 2116082.67925 | 37.7906815134801 | -122.424171198144 | (37.7906815134801, -122.424171198144) | ||
| 6091 | 6091 | 34255 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2280 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 6x4 | Permit Number 779106 | 6002701.36974 | 2117843.10011 | 37.7953456053627 | -122.43466028347099 | (37.7953456053627, -122.434660283471) | |
| 6267 | 6267 | 17356 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2200 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005536.16539 | 2117610.65272 | 37.794867887291396 | -122.424834871756 | (37.7948678872914, -122.424834871756) | |||
| 6501 | 6501 | 103875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106X Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006702.4202 | 2115509.69435 | 37.7891649813311 | -122.42065024171002 | (37.7891649813311, -122.42065024171) | ||
| 6617 | 6617 | 103761 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106X Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006685.575019999 | 2115508.13748 | 37.7891597571573 | -122.42070841348101 | (37.7891597571573, -122.420708413481) | ||
| 6734 | 6734 | 96373 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1315 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768288 | 6008912.46348 | 2117456.9297 | 37.7946359224745 | -122.41314148629499 | (37.7946359224745, -122.413141486295) | |
| 6793 | 6793 | 106875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2014 12:00:00 AM | 9 | 3x3 | Permit Number 772880 | 5999376.012619999 | 2115702.7008599997 | 37.7892792923525 | -122.446012495778 | (37.7892792923525, -122.446012495778) | |
| 6991 | 6991 | 103876 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106X Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006716.01893 | 2115511.31786 | 37.7891702054911 | -122.420603306998 | (37.7891702054911, -122.420603306998) | ||
| 7138 | 7138 | 29119 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 509 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6008381.9659 | 2113792.89597 | 37.7845455839642 | -122.414717657915 | (37.7845455839642, -122.414717657915) | ||
| 7213 | 7213 | 105719 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2317 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775548 | 6003614.61217 | 2116568.84347 | 37.791898625373705 | -122.43140930798799 | (37.7918986253737, -122.431409307988) | |
| 7256 | 7256 | 71253 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1436 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | 10 | 3x3 | 6007270.15279 | 2117448.61656 | 37.7945207624857 | -122.418823519012 | (37.7945207624857, -122.418823519012) | |
| 7289 | 7289 | 111196 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2317 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2015 12:00:00 AM | 3 | Permit Number 775548 | 6003599.3502400005 | 2116566.69152 | 37.7918918516902 | -122.43146196059601 | (37.7918918516902, -122.431461960596) | ||
| 7324 | 7324 | 114856 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1416x Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2016 12:00:00 AM | 3 | 3x3 | 6006677.767419999 | 2115342.38606 | 37.7887042046809 | -122.42072365519199 | (37.7887042046809, -122.420723655192) | ||
| 7328 | 7328 | 18943 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2799X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769995 | 6001475.92192 | 2115618.2324 | 37.7891670515542 | -122.438741019305 | (37.7891670515542, -122.438741019305) | |
| 7650 | 7650 | 88367 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772880 | 5999340.32482 | 2115698.11509 | 37.7892646630799 | -122.44613564087099 | (37.7892646630799, -122.446135640871) | |
| 7662 | 7662 | 88451 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/07/2008 12:00:00 AM | 3 | 5x12 | 6005480.84439 | 2121378.35155 | 37.805209901088396 | -122.425294529632 | (37.8052099010884, -122.425294529632) | ||
| 7952 | 7952 | 17354 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2200 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005542.87933 | 2117567.08542 | 37.7947486417029 | -122.424808539584 | (37.7947486417029, -122.424808539584) | |||
| 8130 | 8130 | 18953 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2857 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2000 12:00:00 AM | 3 | 3X3 | 6001142.520269999 | 2115568.9795 | 37.789012843016295 | -122.439891012071 | (37.7890128430163, -122.439891012071) | ||
| 8180 | 8180 | 21666 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1765 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 4X4 | Permit Number 774582 | 6004178.5577 | 2114595.027 | 37.7865109691436 | -122.42931724201799 | (37.7865109691436, -122.429317242018) |
| 8222 | 8222 | 103806 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98X Hemlock St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006930.58351 | 2114841.83487 | 37.787344060129705 | -122.419813414468 | (37.7873440601297, -122.419813414468) | ||
| 8301 | 8301 | 21660 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1750 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774105 | 6004267.4166 | 2114661.2404 | 37.7866978047254 | -122.429014534836 | (37.7866978047254, -122.429014534836) | |
| 8535 | 8535 | 94877 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3043 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2010 12:00:00 AM | 12 | 3x3 | 6000192.74031 | 2115767.95632 | 37.7895050707416 | -122.443191412453 | (37.7895050707416, -122.443191412453) | ||
| 8626 | 8626 | 87739 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005433.618530001 | 2121623.41722 | 37.8058801199389 | -122.42547541206699 | (37.8058801199389, -122.425475412067) | ||
| 8629 | 8629 | 98380 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775239 | 6001192.51464 | 2117382.3552900003 | 37.7939947472129 | -122.439848106311 | (37.7939947472129, -122.439848106311) | |
| 8744 | 8744 | 21661 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1750 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2015 12:00:00 AM | 3 | 4X4 | Permit Number 774105 | 6004243.6704 | 2114654.9914 | 37.7866793023692 | -122.429096245288 | (37.7866793023692, -122.429096245288) | |
| 8751 | 8751 | 17355 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2200 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005540.30706 | 2117584.3351 | 37.7947958596827 | -122.424818667772 | (37.7947958596827, -122.424818667772) | |||
| 8777 | 8777 | 98381 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775239 | 6001191.27881 | 2117387.7488599997 | 37.7940094862005 | -122.43985276928801 | (37.7940094862005, -122.439852769288) | |
| 8858 | 8858 | 21651 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1689 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/31/2013 12:00:00 AM | 3 | 4X4 | 6004532.1578 | 2114645.7829 | 37.7866703442988 | -122.428097491401 | (37.7866703442988, -122.428097491401) | ||
| 8875 | 8875 | 2624 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1822 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004615.6699 | 2115060.0567 | 37.7878125608959 | -122.427838089219 | (37.7878125608959, -122.427838089219) | |||
| 8877 | 8877 | 103815 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Hemlock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006959.84507 | 2114826.77891 | 37.7873043685578 | -122.419711106691 | (37.7873043685578, -122.419711106691) | ||
| 8999 | 8999 | 103785 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103X Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006767.43674 | 2115144.46398 | 37.7881658129506 | -122.420399357843 | (37.7881658129506, -122.420399357843) | ||
| 9028 | 9028 | 103814 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Hemlock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006931.25215 | 2114822.01169 | 37.787289668217795 | -122.41980969397 | (37.7872896682178, -122.41980969397) | ||
| 9219 | 9219 | 4233 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4000X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1995 12:00:00 AM | 3 | 3x3 | 6003879.3665122 | 2100440.460437 | 37.7476290122472 | -122.429342637933 | (37.7476290122472, -122.429342637933) | ||
| 9424 | 9424 | 16412 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200X Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016451.798598001 | 2094870.8752060002 | 37.7330398269448 | -122.38547940494499 | (37.7330398269448, -122.385479404945) | ||
| 9468 | 9468 | 16413 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016451.798598001 | 2094870.8752060002 | 37.7330398269448 | -122.38547940494499 | (37.7330398269448, -122.385479404945) | ||
| 9712 | 9712 | 121497 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 468 Valley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2016 12:00:00 AM | 3 | 3x3 | 6002891.0 | 2099226.0 | 37.744238382256704 | -122.432673610292 | (37.7442383822567, -122.432673610292) | ||
| 9713 | 9713 | 121496 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 468 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2016 12:00:00 AM | 3 | 3x3 | 6002891.0 | 2099226.0 | 37.744238382256704 | -122.432673610292 | (37.7442383822567, -122.432673610292) | ||
| 9780 | 9780 | 65693 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3779 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 779357 | 6005288.42845233 | 2101344.00549356 | 37.7501896116955 | -122.424534439725 | (37.7501896116955, -122.424534439725) |
| 10315 | 10315 | 47259 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1487 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/11/2014 12:00:00 AM | 1 | 3x3 | Permit Number 770986 | 5989591.7291 | 2105266.36 | 37.7600604072843 | -122.479100863475 | (37.7600604072843, -122.479100863475) |
| 10329 | 10329 | 109051 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772570 | 5995048.30925 | 2086814.9244099997 | 37.7097126663738 | -122.45889335865 | (37.7097126663738, -122.45889335865) |
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");