Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | ||
| 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) | ||
| 11150 | 11150 | 28262 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3624 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2003 12:00:00 AM | 12 | 3x3 | 6012194.4874599995 | 2088681.14992 | 37.715807638979705 | -122.399763675165 | (37.7158076389797, -122.399763675165) | ||
| 11292 | 11292 | 86217 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2621 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2013 12:00:00 AM | 3 | 3x3 | 5988925.7787 | 2097455.0086 | 37.7385738093546 | -122.48083214346799 | (37.7385738093546, -122.480832143468) | ||
| 11481 | 11481 | 28255 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3476 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2003 12:00:00 AM | 6 | 3x3 | 6012058.005419999 | 2089554.66958 | 37.7181985388057 | -122.400296740219 | (37.7181985388057, -122.400296740219) | ||
| 17532 | 17532 | 24463 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3550 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/1995 12:00:00 AM | 3 | 3x3 | 6006349.89396 | 2100605.1669900003 | 37.7482208171583 | -122.420811373242 | (37.7482208171583, -122.420811373242) | ||
| 18995 | 18995 | 19331 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/05/2000 12:00:00 AM | 6 | 3x3 | 5993203.76699 | 2089824.45321 | 37.7178699121392 | -122.465486857851 | (37.7178699121392, -122.465486857851) | ||
| 19154 | 19154 | 4234 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4013X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/1995 12:00:00 AM | 3 | 3x3 | 6003806.79862 | 2100387.84018 | 37.7474804205949 | -122.429589821227 | (37.7474804205949, -122.429589821227) | ||
| 19279 | 19279 | 91934 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1115 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992339.241228 | 2106582.494136 | 37.7638333412086 | -122.46969443927 | (37.7638333412086, -122.46969443927) | ||
| 20828 | 20828 | 4100 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3321 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/2000 12:00:00 AM | 3 | 3x3 | 6007597.59872 | 2100526.27366 | 37.748074440783796 | -122.416491248692 | (37.7480744407838, -122.416491248692) | ||
| 20836 | 20836 | 4276 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4221 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1995 12:00:00 AM | 3 | 3x3 | 6002451.40883 | 2100314.3802 | 37.7472018789671 | -122.434271414787 | (37.7472018789671, -122.434271414787) | ||
| 20906 | 20906 | 89402 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1914 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5992725.997880001 | 2112086.29643 | 37.7789676550624 | -122.468757294436 | (37.7789676550624, -122.468757294436) | ||
| 21550 | 21550 | 27620 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1149 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010601.0802 | 2102491.1542599997 | 37.7536380210979 | -122.40624368710199 | (37.7536380210979, -122.406243687102) | |||
| 21630 | 21630 | 26477 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 112 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/2001 12:00:00 AM | 8 | 3x3 | 6001287.0278199995 | 2098748.5722 | 37.742836382684295 | -122.438185594392 | (37.7428363826843, -122.438185594392) | ||
| 22029 | 22029 | 25409 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3763-3767 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 6 | 3x3 | 6005453.81691 | 2100480.39517 | 37.7478276749239 | -122.42390111285 | (37.7478276749239, -122.42390111285) | ||
| 23228 | 23228 | 28259 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3562 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/2004 12:00:00 AM | 10 | 3x3 | 6012127.60331 | 2089140.68412 | 37.717065698801 | -122.400027111788 | (37.717065698801, -122.400027111788) | ||
| 38128 | 38128 | 88409 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009413.9789 | 2117291.03714 | 37.7942085637169 | -122.41139444529 | (37.7942085637169, -122.41139444529) | |
| 44141 | 44141 | 88407 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009407.88363 | 2117347.72867 | 37.7943638829406 | -122.411419542685 | (37.7943638829406, -122.411419542685) | |
| 51558 | 51558 | 91889 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1112 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5992343.82828 | 2106622.674723 | 37.7639439315835 | -122.46968149954701 | (37.7639439315835, -122.469681499547) | ||
| 53189 | 53189 | 91930 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X IRVING ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2014 12:00:00 AM | 3 | 3x3 | 5992070.0 | 2106573.0 | 37.7637917074669 | -122.470624962715 | (37.7637917074669, -122.470624962715) | ||
| 54134 | 54134 | 91923 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1427 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991353.957672 | 2106548.744029 | 37.763683675450004 | -122.473099740894 | (37.76368367545, -122.473099740894) | ||
| 57041 | 57041 | 98796 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 950@Washington Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 03/16/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768771 | 6010177.18626 | 2117200.01626 | 37.7940014192822 | -122.40874722700701 | (37.7940014192822, -122.408747227007) | |
| 65800 | 65800 | 91919 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1445 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991297.838563 | 2106546.8216959997 | 37.7636751478808 | -122.47329369732799 | (37.7636751478808, -122.473293697328) | ||
| 66520 | 66520 | 100031 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009418.42249 | 2117262.251 | 37.7941297732341 | -122.411377035334 | (37.7941297732341, -122.411377035334) | |
| 73837 | 73837 | 103051 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 400X Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3x3 | 6005072.0 | 2110257.0 | 37.774650355650394 | -122.42591724231501 | (37.7746503556504, -122.425917242315) | |||
| 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) | ||
| 77709 | 77709 | 91916 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1555 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5990949.753071 | 2106534.898314 | 37.763622247809295 | -122.47449673434299 | (37.7636222478093, -122.474496734343) | ||
| 79188 | 79188 | 103042 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005621.8 | 2110912.7 | 37.7764818047314 | -122.424062011758 | (37.7764818047314, -122.424062011758) | |||
| 79576 | 79576 | 89676 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2543 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990695.40247 | 2111954.91498 | 37.778489399756204 | -122.47577226813999 | (37.7784893997562, -122.47577226814) | ||
| 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) | ||
| 79774 | 79774 | 84648 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301X 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/21/2006 12:00:00 AM | 10 | 3x3 | 6004302.0 | 2098976.0 | 37.7436318598049 | -122.427776865938 | (37.7436318598049, -122.427776865938) | ||
| 80455 | 80455 | 91941 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 925 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992928.667696 | 2106602.6844200003 | 37.7639228286278 | -122.467657278128 | (37.7639228286278, -122.467657278128) | ||
| 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) | ||
| 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) | ||
| 81177 | 81177 | 91970 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1350 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993350.61101 | 2106290.929173 | 37.763091183898 | -122.466175257659 | (37.763091183898, -122.466175257659) | ||
| 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) | ||
| 81475 | 81475 | 91983 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1239 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993284.406043 | 2107051.954484 | 37.7651769393996 | -122.46645955171999 | (37.7651769393996, -122.46645955172) | ||
| 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) | ||
| 82005 | 82005 | 52014 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301X 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/12/2005 12:00:00 AM | 9 | 3x3 | Permit Number 48233 | 6004302.0 | 2098976.0 | 37.7436318598049 | -122.427776865938 | (37.7436318598049, -122.427776865938) | |
| 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) | ||
| 83265 | 83265 | 91984 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1243 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993285.31415 | 2107025.55813 | 37.7651045143653 | -122.466454492146 | (37.7651045143653, -122.466454492146) | ||
| 83935 | 83935 | 91902 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1516 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2008 12:00:00 AM | 3 | 3x3 | 5991061.448475 | 2106578.7477680002 | 37.7637491175921 | -122.474113618488 | (37.7637491175921, -122.474113618488) | ||
| 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) | ||
| 84264 | 84264 | 91966 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1376 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993356.433228 | 2106121.691358 | 37.76262683713129 | -122.466142821616 | (37.7626268371313, -122.466142821616) | ||
| 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) | ||
| 84609 | 84609 | 91947 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 827 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993232.703908999 | 2106613.098951 | 37.7639689741056 | -122.466606473793 | (37.7639689741056, -122.466606473793) | ||
| 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) | ||
| 84697 | 84697 | 91953 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 701 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2014 12:00:00 AM | 3 | 3x3 | 5993618.512619 | 2106626.3144610003 | 37.7640275170127 | -122.465273046982 | (37.7640275170127, -122.465273046982) | ||
| 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) | ||
| 85360 | 85360 | 91951 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 751 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993470.629208 | 2106621.248866 | 37.764005078882796 | -122.46578415986299 | (37.7640050788828, -122.465784159863) | ||
| 86154 | 86154 | 91926 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1401 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991435.018606 | 2106551.520732 | 37.7636959924857 | -122.472819581527 | (37.7636959924857, -122.472819581527) | ||
| 86457 | 86457 | 91921 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1437 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991322.7803879995 | 2106547.676066 | 37.763678937950296 | -122.473207494478 | (37.7636789379503, -122.473207494478) | ||
| 86947 | 86947 | 91880 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 840 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2008 12:00:00 AM | 3 | 3x3 | 5993189.659614 | 2106651.6479599997 | 37.7640723354625 | -122.466758152363 | (37.7640723354625, -122.466758152363) | ||
| 87144 | 87144 | 91948 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 823 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993244.611031 | 2106613.506821 | 37.763970781134795 | -122.466565320592 | (37.7639707811348, -122.466565320592) | ||
| 87590 | 87590 | 91928 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X IRVING ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 2 | 3x3 | 5992070.0 | 2106573.0 | 37.7637917074669 | -122.470624962715 | (37.7637917074669, -122.470624962715) | ||
| 88045 | 88045 | 91918 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1523 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991044.965492 | 2106538.159703 | 37.7636367187828 | -122.474167665735 | (37.7636367187828, -122.474167665735) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 88891 | 88891 | 91942 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 917 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992952.377119999 | 2106603.496565 | 37.76392642748271 | -122.467575334102 | (37.7639264274827, -122.467575334102) | ||
| 88917 | 88917 | 91030 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1086 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6009941.213427 | 2111462.810786 | 37.778235204322904 | -122.409158690819 | (37.7782352043229, -122.409158690819) | ||
| 89505 | 89505 | 91955 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 621 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993869.320819 | 2106634.905708 | 37.7640655668897 | -122.46440620597299 | (37.7640655668897, -122.464406205973) | ||
| 89595 | 89595 | 91974 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1332 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993346.580243 | 2106408.0938330004 | 37.7634126547611 | -122.466197713623 | (37.7634126547611, -122.466197713623) | ||
| 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) | ||
| 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) | ||
| 91240 | 91240 | 91969 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1360 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993352.850325 | 2106225.837693 | 37.7629125889584 | -122.466162782208 | (37.7629125889584, -122.466162782208) | ||
| 91526 | 91526 | 91971 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1342 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993348.819558 | 2106343.002353 | 37.7632340598338 | -122.46618523806299 | (37.7632340598338, -122.466185238063) | ||
| 92878 | 92878 | 91982 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1231 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993282.58983 | 2107104.747155 | 37.7653217893633 | -122.466469670891 | (37.7653217893633, -122.466469670891) | ||
| 93715 | 93715 | 91891 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1134 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5992278.307636 | 2106620.430357 | 37.7639339819744 | -122.469907950407 | (37.7639339819744, -122.469907950407) | ||
| 94130 | 94130 | 91875 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 700 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/10/2008 12:00:00 AM | 3 | 3x3 | 5993617.143263 | 2106666.291015 | 37.764137203180205 | -122.465280687147 | (37.7641372031802, -122.465280687147) | ||
| 94183 | 94183 | 91967 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1372 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993355.537502999 | 2106147.727912 | 37.7626982750081 | -122.46614781174499 | (37.7626982750081, -122.466147811745) | ||
| 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) | ||
| 94987 | 94987 | 91968 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1368 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993354.641776999 | 2106173.764513 | 37.762769713012794 | -122.46615280188999 | (37.7627697130128, -122.46615280189) | ||
| 95984 | 95984 | 103790 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.788327510680205 | -122.41938487643999 | (37.7883275106802, -122.41938487644) | ||
| 96954 | 96954 | 91903 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1534 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2008 12:00:00 AM | 3 | 3x3 | 5991007.891482 | 2106576.913236 | 37.7637409778654 | -122.47429871990299 | (37.7637409778654, -122.474298719903) | ||
| 97015 | 97015 | 10703 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130X Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5993684.4832438 | 2089860.5757616002 | 37.717996809726 | -122.46382786766 | (37.717996809726, -122.46382786766) | |||
| 97122 | 97122 | 16435 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1299X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 6016431.7799349995 | 2094795.0104810002 | 37.7328304099415 | -122.385543330143 | (37.7328304099415, -122.385543330143) | ||
| 97673 | 97673 | 91881 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 902 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2008 12:00:00 AM | 3 | 3x3 | 5992992.499251001 | 2106644.894373 | 37.7640424113715 | -122.467439575398 | (37.7640424113715, -122.467439575398) | ||
| 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) | |
| 97774 | 97774 | 91977 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1310 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993341.653751 | 2106551.295076 | 37.763805563541204 | -122.466225160061 | (37.7638055635412, -122.466225160061) | ||
| 98111 | 98111 | 91929 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X IRVING ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2014 12:00:00 AM | 2 | 3x3 | 5992070.0 | 2106573.0 | 37.7637917074669 | -122.470624962715 | (37.7637917074669, -122.470624962715) | ||
| 98625 | 98625 | 91987 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1327 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5993305.2603050005 | 2106445.773422 | 37.7635137289504 | -122.466343363346 | (37.7635137289504, -122.466343363346) | ||
| 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) | ||
| 100006 | 100006 | 86109 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2548 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988950.841471 | 2097988.149582 | 37.7400391325334 | -122.480784510326 | (37.7400391325334, -122.480784510326) | ||
| 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) | ||
| 100305 | 100305 | 103832 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98X Myrtle St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.7906599995 | 2114178.2136 | 37.7855373621017 | -122.41881763042299 | (37.7855373621017, -122.418817630423) | ||
| 100587 | 100587 | 91980 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1256 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993328.468873001 | 2106934.546237 | 37.7648571097371 | -122.466298616883 | (37.7648571097371, -122.466298616883) | ||
| 100903 | 100903 | 91931 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992089.071506 | 2106573.92474 | 37.7637953493605 | -122.470559068172 | (37.7637953493605, -122.470559068172) | ||
| 100962 | 100962 | 91945 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 843 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993185.075419 | 2106611.467471 | 37.763961745844895 | -122.46677108658501 | (37.7639617458449, -122.466771086585) | ||
| 101459 | 101459 | 98790 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 950x CLAY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | Permit Number 768771 | 6010160.0 | 2117472.0 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | ||
| 101983 | 101983 | 16450 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1395 Newcomb Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
| 102711 | 102711 | 91954 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 637 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993821.680813 | 2106633.2738349997 | 37.7640583399586 | -122.464570858995 | (37.7640583399586, -122.464570858995) | ||
| 103123 | 103123 | 103040 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450X Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005621.8 | 2110912.7 | 37.7764818047314 | -122.424062011758 | (37.7764818047314, -122.424062011758) | |||
| 103424 | 103424 | 89679 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2531 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990763.229169999 | 2111957.72376 | 37.7785010440115 | -122.47553783747601 | (37.7785010440115, -122.475537837476) | ||
| 103727 | 103727 | 91901 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1500 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2008 12:00:00 AM | 3 | 3x3 | 5991109.054689 | 2106580.378462 | 37.7637563526576 | -122.473949083869 | (37.7637563526576, -122.473949083869) | ||
| 104440 | 104440 | 91993 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1385 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5993318.248331 | 2106068.242865 | 37.7624778784584 | -122.46627100381201 | (37.7624778784584, -122.466271003812) | ||
| 104677 | 104677 | 91952 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 717 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993571.189928 | 2106624.693471 | 37.7640203370534 | -122.465436603136 | (37.7640203370534, -122.465436603136) | ||
| 104849 | 104849 | 91944 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 845 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993179.121855 | 2106611.263536 | 37.763960842296 | -122.46679166319201 | (37.763960842296, -122.466791663192) |
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");