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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 69000 | 69000 | 56086 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 751 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/1993 12:00:00 AM | 10 | Permit Number 31549 | 5981328.96574 | 2110619.12567 | 37.774274230915 | -122.508074577218 | (37.774274230915, -122.508074577218) | ||
| 70120 | 70120 | 231143 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2857 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010376.44019 | 2100661.4980599997 | 37.7486016206723 | -122.406891600982 | (37.7486016206723, -122.406891600982) | |||
| 70501 | 70501 | 201446 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018203.56195 | 2095942.2457299998 | 37.7360783651123 | -122.37949743215599 | (37.7360783651123, -122.379497432156) | |||
| 71212 | 71212 | 183611 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1922 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986017.7787 | 2102119.0416 | 37.7512105314609 | -122.49122963690701 | (37.7512105314609, -122.491229636907) | |||
| 71542 | 71542 | 182034 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1322 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989910.492000001 | 2106348.2383 | 37.7630494610028 | -122.478077525469 | (37.7630494610028, -122.478077525469) | |||
| 72915 | 72915 | 208528 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2574 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991762.28899 | 2097924.21103 | 37.7400265849559 | -122.471059114781 | (37.7400265849559, -122.471059114781) | |||
| 73172 | 73172 | 208520 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 515 Wildwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995057.027969999 | 2093308.395 | 37.727542695432795 | -122.459333157701 | (37.7275426954328, -122.459333157701) | |||
| 73257 | 73257 | 192778 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1190 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017805.41834 | 2096342.2173900001 | 37.7371546413706 | -122.380901787387 | (37.7371546413706, -122.380901787387) | |||
| 73678 | 73678 | 208533 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1245 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5992969.96959 | 2106979.3295 | 37.764959381307605 | -122.467541820422 | (37.7649593813076, -122.467541820422) | |||
| 74838 | 74838 | 37341 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 143 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 12 | Permit Number 42166 | 6000578.2746 | 2087350.98915 | 37.711500903515294 | -122.439819265071 | (37.7115009035153, -122.439819265071) | |
| 75848 | 75848 | 192774 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1188 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017787.76265 | 2096258.7278599998 | 37.736924421218205 | -122.380957029157 | (37.7369244212182, -122.380957029157) | |||
| 76773 | 76773 | 31146 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 500 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 3 | Permit Number 34853 | 5998061.9745 | 2094408.9527900002 | 37.73073687780529 | -122.44902432803002 | (37.7307368778053, -122.44902432803) | |
| 77018 | 77018 | 47438 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 754 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 6 | Permit Number 45349 | 5982933.06329 | 2110647.13754 | 37.7744455330351 | -122.502527876502 | (37.7744455330351, -122.502527876502) | |
| 77732 | 77732 | 6962 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 679 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004187.88701 | 2110434.988 | 37.7750890628147 | -122.428988258507 | (37.7750890628147, -122.428988258507) | |||
| 78232 | 78232 | 50516 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 5 Ankeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | Permit Number 47154 | 6011081.17415635 | 2089639.60650981 | 37.7183772392501 | -122.403679220586 | (37.7183772392501, -122.403679220586) | ||
| 79302 | 79302 | 4285 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 4310X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 2X3 | 6001895.2244565 | 2100336.5410682997 | 37.747231143218606 | -122.43619623965799 | (37.7472311432186, -122.436196239658) | ||
| 80836 | 80836 | 103465 | Section 143 8 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 890X Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012118.0 | 2118740.5 | 37.7983397318906 | -122.402140129264 | (37.7983397318906, -122.402140129264) | |||||
| 81013 | 81013 | 69159 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1351 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | Permit Number 33196 | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | ||
| 81450 | 81450 | 61675 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2037 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2010 12:00:00 AM | 3x3 | Permit Number 53364 | 6003935.46106067 | 2107133.46440575 | 37.7660095916974 | -122.42962593922701 | (37.7660095916974, -122.429625939227) | ||
| 81765 | 81765 | 40485 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 449 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51469 | 6003623.22789826 | 2099788.66893303 | 37.745824839871204 | -122.430181858048 | (37.7458248398712, -122.430181858048) | ||
| 82842 | 82842 | 39838 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3151 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 84226 | 84226 | 46132 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 348 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2001 12:00:00 AM | Permit Number 44482 | 5996430.36096198 | 2106978.42208567 | 37.7651560683716 | -122.455573201236 | (37.7651560683716, -122.455573201236) | ||
| 85001 | 85001 | 115266 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1994 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775693 | 5987297.6 | 2101721.1 | 37.7501925881489 | -122.486774714257 | (37.7501925881489, -122.486774714257) | |||
| 85368 | 85368 | 107344 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 390 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 3 | Permit Number 774019 | 5987178.52527 | 2113313.79878 | 37.7820159849006 | -122.488038192901 | (37.7820159849006, -122.488038192901) | ||
| 86482 | 86482 | 31085 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1899 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34821 | 6006797.73950174 | 2107335.90835979 | 37.7667271093004 | -122.419740243053 | (37.7667271093004, -122.419740243053) | ||
| 87084 | 87084 | 39491 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 4028 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 2 | 3x3 | Permit Number 773152 | 6003658.31087799 | 2101306.87444184 | 37.7499954653433 | -122.430168836007 | (37.7499954653433, -122.430168836007) | |
| 87664 | 87664 | 49863 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1223@ LINCOLN 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | Permit Number 46632 | 5995133.46719385 | 2107213.08915879 | 37.765725896972704 | -122.460075813738 | (37.7657258969727, -122.460075813738) | |||
| 89502 | 89502 | 48642 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1443 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45935 | 5993635.01411905 | 2105673.08820779 | 37.7614111585604 | -122.465146733416 | (37.7614111585604, -122.465146733416) | ||
| 90249 | 90249 | 45102 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1515 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | Permit Number 43970 | 5988775.62486061 | 2101011.37824645 | 37.7483299379041 | -122.48161169888 | (37.7483299379041, -122.48161169888) | ||
| 91383 | 91383 | 115221 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 667 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 775510 | 5989384.2 | 2110805.2 | 37.7752564954525 | -122.48022399244499 | (37.7752564954525, -122.480223992445) | |||
| 92455 | 92455 | 45269 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 495 Benton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44115 | 6006960.22646946 | 2095436.5214698997 | 37.7340632510606 | -122.418334438437 | (37.7340632510606, -122.418334438437) | ||
| 93007 | 93007 | 50913 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2054 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47416 | 5990700.21989371 | 2101411.09480317 | 37.749539178873604 | -122.474985739909 | (37.7495391788736, -122.474985739909) | ||
| 93589 | 93589 | 46688 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1649 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2002 12:00:00 AM | Permit Number 44818 | 5990658.02398175 | 2106518.9018668 | 37.7635614189885 | -122.475504555263 | (37.7635614189885, -122.475504555263) | ||
| 93682 | 93682 | 47333 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 136 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45264 | 5993671.62971533 | 2090537.36096084 | 37.719854358339 | -122.463921395432 | (37.719854358339, -122.463921395432) | ||
| 94313 | 94313 | 52399 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 35@ MISSION Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/2005 12:00:00 AM | Permit Number 48520 | 6005854.7767833 | 2097770.27806094 | 37.7404089356736 | -122.422322085613 | (37.7404089356736, -122.422322085613) | ||
| 95487 | 95487 | 115964 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599x 30TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | 3x3 | 5986686.0 | 2104596.0 | 37.7580506061519 | -122.489100968136 | (37.7580506061519, -122.489100968136) | |||
| 95933 | 95933 | 109388 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 172X Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774502 | 6006834.59164 | 2098690.08898 | 37.74298975220871 | -122.418999487845 | (37.7429897522087, -122.418999487845) |
| 96245 | 96245 | 46443 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 199x 29TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2002 12:00:00 AM | Permit Number 44659 | 5986803.0 | 2114652.0 | 37.7856683878416 | -122.48943575012501 | (37.7856683878416, -122.489435750125) | |||
| 97265 | 97265 | 115371 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 86 FREDERICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | 3x3 | 5999609.0 | 2107783.0 | 37.767547127962104 | -122.444636930271 | (37.7675471279621, -122.444636930271) | ||
| 97477 | 97477 | 105742 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 410 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 4x4 | Permit Number 771648 | 6002709.0 | 2109944.0 | 37.773657109816206 | -122.434068943261 | (37.7736571098162, -122.434068943261) | ||
| 97658 | 97658 | 122709 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3092 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6009072.0 | 2100607.0 | 37.7483789037457 | -122.41139850646002 | (37.7483789037457, -122.41139850646) | |||
| 97847 | 97847 | 115021 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1347 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 12:00:00 AM | Permit Number 777267 | 5985200.1 | 2106030.1 | 37.7619014051397 | -122.49434547853399 | (37.7619014051397, -122.494345478534) | |||
| 98004 | 98004 | 109841 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 431 PIERCE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774456 | 6002625.0 | 2110137.0 | 37.7741822723418 | -122.434373313194 | (37.7741822723418, -122.434373313194) | |
| 98364 | 98364 | 48646 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1447 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45939 | 5992087.44190313 | 2105594.10249769 | 37.7611049225491 | -122.470493338959 | (37.7611049225491, -122.470493338959) | ||
| 98434 | 98434 | 83774 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 439 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50860 | 5993553.67824135 | 2105258.69385087 | 37.7602686491328 | -122.46539793460899 | (37.7602686491328, -122.465397934609) | ||
| 99510 | 99510 | 47331 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 124 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45262 | 5993700.96357793 | 2090548.13923706 | 37.719885643336 | -122.46382078123501 | (37.719885643336, -122.463820781235) | ||
| 100210 | 100210 | 47897 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 641 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50499 | 6001064.62263779 | 2110863.06627467 | 37.77608717392229 | -122.439822990908 | (37.7760871739223, -122.439822990908) | |
| 101048 | 101048 | 67103 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1233 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2008 12:00:00 AM | 3x3 | Permit Number 51780 | 5992966.70484562 | 2107080.63599542 | 37.7652373537014 | -122.46756048006 | (37.7652373537014, -122.46756048006) | ||
| 102235 | 102235 | 45172 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1632 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/2001 12:00:00 AM | Permit Number 44020 | 6009655.50292779 | 2100210.97889112 | 37.7473242274109 | -122.40935281451 | (37.7473242274109, -122.40935281451) | ||
| 102805 | 102805 | 92264 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2471 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52712 | 5991677.5 | 2098618.2 | 37.741927197179706 | -122.471402831349 | (37.7419271971797, -122.471402831349) | ||
| 104460 | 104460 | 47940 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 458 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2002 12:00:00 AM | Permit Number 45674 | 5999050.40091291 | 2094998.55837804 | 37.7324122768682 | -122.44564957990299 | (37.7324122768682, -122.445649579903) | ||
| 104970 | 104970 | 95873 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1401 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767592 | 6011001.0 | 2119672.0 | 37.800834994148296 | -122.406070966213 | (37.8008349941483, -122.406070966213) | |
| 105193 | 105193 | 117299 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 66 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778517 | 5996255.6 | 2088726.3 | 37.7150301835094 | -122.454858780509 | (37.7150301835094, -122.454858780509) | ||
| 105231 | 105231 | 67363 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2766 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32339 | 6010168.96138205 | 2102835.43950197 | 37.7545591709601 | -122.407762331272 | (37.7545591709601, -122.407762331272) | ||
| 105476 | 105476 | 46067 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 665 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/2001 12:00:00 AM | 14 | 6x12 | Permit Number 44452 | 5993766.27932 | 2110973.25673 | 37.7759715897859 | -122.465077710575 | (37.7759715897859, -122.465077710575) |
| 105713 | 105713 | 40250 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3351X 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/13/1999 12:00:00 AM | 3 | 3x3 | Permit Number 41415 | 6006702.84210434 | 2102592.14346256 | 37.7536964884672 | -122.419731851285 | (37.7536964884672, -122.419731851285) |
| 106584 | 106584 | 64304 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1610 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50559 | 6003959.54374293 | 2098890.96044294 | 37.7433789825316 | -122.428954934478 | (37.7433789825316, -122.428954934478) | ||
| 106658 | 106658 | 116379 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1398x MINNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6006958.0 | 2107364.0 | 37.7668132689247 | -122.419187920752 | (37.7668132689247, -122.419187920752) | |||
| 107774 | 107774 | 116080 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2854 CESAR CHAVEZ ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010430.0 | 2100760.0 | 37.748875082227705 | -122.40671333173 | (37.7488750822277, -122.40671333173) | ||||
| 109185 | 109185 | 84655 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1500@Kirkham 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51106 | 5982511.66372627 | 2104885.6069527 | 37.7586012542431 | -122.503558809888 | (37.7586012542431, -122.503558809888) | ||
| 109887 | 109887 | 47051 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 20 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2003 12:00:00 AM | Permit Number 47185 | 6002726.22730877 | 2096267.53991314 | 37.7361057892564 | -122.433032030002 | (37.7361057892564, -122.433032030002) | |||
| 110057 | 110057 | 114901 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1715 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2015 12:00:00 AM | Permit Number 776029 | 5993685.8 | 2103804.5 | 37.756283428586705 | -122.464835383865 | (37.7562834285867, -122.464835383865) | |||
| 110257 | 110257 | 30809 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 4 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | Permit Number 34672 | 6002099.96529537 | 2094932.19655677 | 37.73240370004571 | -122.435101791398 | (37.7324037000457, -122.435101791398) | ||
| 111755 | 111755 | 109373 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2936 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/2016 12:00:00 AM | 1 | 3X3 | 6009926.0 | 2100644.0 | 37.7485283598064 | -122.40844799036199 | (37.7485283598064, -122.408447990362) | ||
| 112745 | 112745 | 45598 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1795 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2001 12:00:00 AM | Permit Number 44333 | 5985317.30118679 | 2103007.24322679 | 37.753608335545394 | -122.49371737271099 | (37.7536083355454, -122.493717372711) | ||
| 113209 | 113209 | 47384 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 106(REVISED) Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2002 12:00:00 AM | Permit Number 45300 | 6004694.24949425 | 2103041.30514174 | 37.7548164276068 | -122.426710002393 | (37.7548164276068, -122.426710002393) | ||
| 115049 | 115049 | 108819 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2850 CESAR CHAVEZ ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/2015 12:00:00 AM | 3 | 3x3 | 6010441.0 | 2100764.0 | 37.7488866808005 | -122.40667557539301 | (37.7488866808005, -122.406675575393) | ||
| 115862 | 115862 | 108506 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1351 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773651 | 5991435.99283 | 2106225.38034 | 37.762800554258206 | -122.47279242987 | (37.7628005542582, -122.47279242987) |
| 116015 | 116015 | 97497 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1520 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2010 12:00:00 AM | 3 | 3x3 | 6015724.7 | 2096772.7 | 37.7382215976335 | -122.388125873954 | (37.7382215976335, -122.388125873954) | |
| 117823 | 117823 | 52372 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 101ON GLADYS Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | Permit Number 48504 | 6005559.90759854 | 2097139.01278452 | 37.7386589857488 | -122.423296765333 | (37.7386589857488, -122.423296765333) | ||
| 121746 | 121746 | 42180 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 610 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42464 | 6013056.99146058 | 2111821.77502572 | 37.7793948976102 | -122.398405193211 | (37.7793948976102, -122.398405193211) | ||
| 122084 | 122084 | 439 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2606X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008239.9535300005 | 2103244.59604 | 37.7555744447599 | -122.41446232215701 | (37.7555744447599, -122.414462322157) | |||
| 122787 | 122787 | 47542 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 453 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45409 | 6003598.72403802 | 2099787.33509963 | 37.745819789565104 | -122.430266493752 | (37.7458197895651, -122.430266493752) | ||
| 125104 | 125104 | 39835 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2034 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41157 | 5981216.95216217 | 2101218.11125367 | 37.7484551479521 | -122.507764274182 | (37.7484551479521, -122.507764274182) | ||
| 126188 | 126188 | 32264 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1617 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/1996 12:00:00 AM | Permit Number 36850 | 5982176.21892429 | 2104089.17289697 | 37.7563947450211 | -122.504659900262 | (37.7563947450211, -122.504659900262) | |||
| 127672 | 127672 | 83923 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 433 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50861 | 5993571.485212901 | 2105259.30286396 | 37.7602713482766 | -122.465336393395 | (37.7602713482766, -122.465336393395) | ||
| 128716 | 128716 | 69031 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1295 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | Permit Number 33037 | 5984271.37541102 | 2106373.05880115 | 37.762788679322 | -122.49758284403299 | (37.762788679322, -122.497582844033) | ||
| 130082 | 130082 | 130424 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 842 Sansome St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012129.23244 | 2118685.48448 | 37.7981892994573 | -122.40209739158999 | (37.7981892994573, -122.40209739159) | |||
| 130129 | 130129 | 231146 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2891 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010152.40627 | 2100564.88075 | 37.748323792227204 | -122.40765949968201 | (37.7483237922272, -122.407659499682) | |||
| 130688 | 130688 | 30722 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 440 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 11 | Permit Number 34622 | 6004437.7336 | 2109825.5331 | 37.7734297877263 | -122.428080542915 | (37.7734297877263, -122.428080542915) | |
| 130736 | 130736 | 61074 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2659 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1983 12:00:00 AM | 12 | Permit Number 20910 | 5999471.9883 | 2113589.9393 | 37.7834836805516 | -122.445528446504 | (37.7834836805516, -122.445528446504) | |
| 131395 | 131395 | 183037 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2523 43rd Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5983009.062000001 | 2097931.9719 | 37.7395377337872 | -122.50132425344299 | (37.7395377337872, -122.501324253443) | |||
| 134563 | 134563 | 192745 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3429 Jennings St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6013179.5796 | 2089589.99773 | 37.71835802098379 | -122.396422384394 | (37.7183580209838, -122.396422384394) | ||||
| 137543 | 137543 | 55814 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1471 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2002 12:00:00 AM | 5 | Permit Number 11861 | 5982145.0874 | 2105106.6766 | 37.7591866900991 | -122.50484295630501 | (37.7591866900991, -122.504842956305) | |
| 138081 | 138081 | 44758 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 761 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52638 | 6009105.645769999 | 2110316.6850799997 | 37.7750413677944 | -122.411968221753 | (37.7750413677944, -122.411968221753) | |
| 138228 | 138228 | 69038 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1458 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 8 | Permit Number 33044 | 5984359.7211 | 2105241.4653 | 37.7596868192975 | -122.497193756865 | (37.7596868192975, -122.497193756865) | |
| 139970 | 139970 | 107452 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 150 CARMEL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773425 | 5998064.4 | 2105394.7 | 37.760901199172295 | -122.449807340042 | (37.7609011991723, -122.449807340042) | |
| 144365 | 144365 | 47345 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 733 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45271 | 5992127.57575512 | 2090471.77540526 | 37.71958517270679 | -122.469253830769 | (37.7195851727068, -122.469253830769) | ||
| 145432 | 145432 | 95914 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1900 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767613 | 5988155.0 | 2102402.0 | 37.75211210611629 | -122.48385972943501 | (37.7521121061163, -122.483859729435) | |
| 146036 | 146036 | 50033 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 21 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46765 | 6007742.80980171 | 2094024.776055 | 37.7302309265394 | -122.41552887966002 | (37.7302309265394, -122.41552887966) | ||
| 146130 | 146130 | 115811 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 399X CONNECTICUT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6013409.0 | 2105275.0 | 37.761438521882205 | -122.396728355206 | (37.7614385218822, -122.396728355206) | |||
| 147495 | 147495 | 231151 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3101 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009109.901219999 | 2100538.836 | 37.7481938662608 | -122.411262629885 | (37.7481938662608, -122.411262629885) | |||
| 148004 | 148004 | 103468 | Section 143 8 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 799X Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 6012421.85953 | 2118740.3114 | 37.798356169556605 | -122.401088663417 | (37.7983561695566, -122.401088663417) | ||||
| 148373 | 148373 | 52563 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1275 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 4 | Permit Number 48660 | 5983651.2644 | 2106493.3098 | 37.7630824862581 | -122.49973644381399 | (37.7630824862581, -122.499736443814) | |
| 148980 | 148980 | 231155 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 237 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007169.551419999 | 2097548.06755 | 37.739872871922 | -122.41776035486299 | (37.739872871922, -122.417760354863) | |||
| 149114 | 149114 | 177270 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 216 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6004605.9461900005 | 2092064.93241 | 37.7246728094864 | -122.426233963246 | (37.7246728094864, -122.426233963246) | |||
| 149475 | 149475 | 184486 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1835 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5984093.5138 | 2102639.4673 | 37.7525268533295 | -122.497922277622 | (37.7525268533295, -122.497922277622) | |||
| 149519 | 149519 | 46646 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 380 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | 9 | Permit Number 44778 | 5990924.10175 | 2112863.2261200002 | 37.780996628175394 | -122.47504744177799 | (37.7809966281754, -122.475047441778) | |
| 149559 | 149559 | 229189 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3281 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007838.5569 | 2100529.3417599997 | 37.748096413035796 | -122.415658239036 | (37.7480964130358, -122.415658239036) | |||
| 151671 | 151671 | 201368 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 175 Middle Point Rd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 6018226.9732800005 | 2095256.66698 | 37.734197192029704 | -122.379368881264 | (37.7341971920297, -122.379368881264) |
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");