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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
92416 | 92416 | 42186 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 975 Bryant St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42468 | 6010750.56133351 | 2109544.8068813 | 37.7730141185867 | -122.40622367699301 | (37.7730141185867, -122.406223676993) | ||
92443 | 92443 | 46441 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 199X 29TH AVE | 3 | 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) | |||
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) | ||
93389 | 93389 | 94135 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 150 Peralta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53499 | 6009988.7 | 2100136.6 | 37.7471386620606 | -122.40819539283301 | (37.7471386620606, -122.408195392833) | |
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) | ||
94263 | 94263 | 122467 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1351 42nd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | ||||
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) | ||
95898 | 95898 | 45599 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1795 35th Ave | 2 | 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) | ||
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) |
96233 | 96233 | 88824 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 110 Clayton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2008 12:00:00 AM | 3x3 | Permit Number 51710 | 5998275.0 | 2110294.0 | 37.7743654794888 | -122.44943198445 | (37.7743654794888, -122.44943198445) | |||
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) | |||
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) | |||
97950 | 97950 | 45098 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1515 Quintara St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2001 12:00:00 AM | Permit Number 43970 | 5988775.62486061 | 2101011.37824645 | 37.7483299379041 | -122.48161169888 | (37.7483299379041, -122.48161169888) | |||
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) | |
100837 | 100837 | 42191 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 975 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42468 | 6010750.56133351 | 2109544.8068813 | 37.7730141185867 | -122.40622367699301 | (37.7730141185867, -122.406223676993) | ||
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) | ||
101880 | 101880 | 93995 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1572 15th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53417 | 6006987.0 | 2107345.0 | 37.7667627325299 | -122.419086266495 | (37.7667627325299, -122.419086266495) | ||||
102150 | 102150 | 42215 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 200X Dore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 3 | 3X3 | Permit Number 42481 | 6009422.03433075 | 2109152.33438426 | 37.7718620785354 | -122.410791511353 | (37.7718620785354, -122.410791511353) |
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) | ||
104536 | 104536 | 46442 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 199x 29TH AVE | 2 | 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) | |||
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) | ||
105259 | 105259 | 45105 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1515 Quintara St | 4 | 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) | ||
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) |
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) | ||
106925 | 106925 | 30810 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 4 Joost Ave | 4 | 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) | ||
107167 | 107167 | 30808 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 4 Joost Ave | 3 | 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) | ||
108216 | 108216 | 45600 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1795 35th Ave | 3 | 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) | ||
108381 | 108381 | 45100 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1515 Quintara St | 3 | 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) | ||
109126 | 109126 | 45108 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1515 Quintara St | 2 | 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) | ||
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) | ||
109311 | 109311 | 48534 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 500(REVISED) Capp St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | ||
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) | ||
110269 | 110269 | 94577 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3785 21st St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53755 | 6003129.0 | 2103573.0 | 37.7561877160456 | -122.432161032458 | (37.7561877160456, -122.432161032458) | ||
110405 | 110405 | 92470 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1845 Pacheco St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52852 | 5989284.0 | 2101710.0 | 37.750277716574004 | -122.479904887047 | (37.750277716574, -122.479904887047) | |
111564 | 111564 | 30807 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 4 Joost Ave | 2 | 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) | ||
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) | ||
114722 | 114722 | 115267 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1994 29th Ave | 2 | 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) | |||
114749 | 114749 | 45103 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1515 Quintara St | 6 | 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) | ||
115617 | 115617 | 88099 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1500@Kirkham 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51106 | 5982532.2 | 2104857.1 | 37.7585241895731 | -122.503485676426 | (37.7585241895731, -122.503485676426) | ||
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) |
115895 | 115895 | 50034 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 21 University St | 2 | 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) | ||
116085 | 116085 | 39327 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 0 20th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40896 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) | |||
116097 | 116097 | 104831 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3210 Jackson St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 3x3 | 5998893.9 | 2116279.9 | 37.7908365867802 | -122.447722110161 | (37.7908365867802, -122.447722110161) | |||
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) | ||
119326 | 119326 | 107572 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 390x 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 3 | Permit Number 774019 | 5987178.05055 | 2113333.68134 | 37.782070549050395 | -122.488041296595 | (37.7820705490504, -122.488041296595) | ||
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) | |||
122411 | 122411 | 42189 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 975 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42468 | 6010750.56133351 | 2109544.8068813 | 37.7730141185867 | -122.40622367699301 | (37.7730141185867, -122.406223676993) | ||
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) | ||
124251 | 124251 | 93970 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3400 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 53400 | 6006959.5 | 2100632.2 | 37.7483293848143 | -122.41870528613501 | (37.7483293848143, -122.418705286135) | ||
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) | ||
126004 | 126004 | 52374 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 101ON GLADYS Appleton Ave | 3 | 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) | ||
126088 | 126088 | 45097 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1515 Quintara St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2001 12:00:00 AM | Permit Number 43970 | 5988775.62486061 | 2101011.37824645 | 37.7483299379041 | -122.48161169888 | (37.7483299379041, -122.48161169888) | |||
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) | |||
126466 | 126466 | 92469 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1845 Pacheco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52852 | 5989284.0 | 2101710.0 | 37.750277716574004 | -122.479904887047 | (37.750277716574, -122.479904887047) | |
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) | ||
128819 | 128819 | 46689 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1649 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2002 12:00:00 AM | Permit Number 44818 | 5990658.02398175 | 2106518.9018668 | 37.7635614189885 | -122.475504555263 | (37.7635614189885, -122.475504555263) | |||
129380 | 129380 | 108740 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 114 Coleridge St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | 6006642.81745 | 2099018.83265 | 37.743881607568895 | -122.419685912101 | (37.7438816075689, -122.419685912101) | ||
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) | |
130817 | 130817 | 44759 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 761 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52638 | 6009115.4734 | 2110327.7529599997 | 37.775072308961 | -122.411935008006 | (37.775072308961, -122.411935008006) | |
136713 | 136713 | 30694 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 15 Hermann St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 14 | Permit Number 34611 | 6005219.1045699995 | 2108841.90949 | 37.770773171875895 | -122.425307657937 | (37.7707731718759, -122.425307657937) | |
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) | |
139432 | 139432 | 52375 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 101ON GLADYS Appleton Ave | 4 | 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) | ||
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) | |
141046 | 141046 | 30693 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 15 Hermann St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34611 | 6005194.76863479 | 2108838.99262962 | 37.7707637879688 | -122.42539162886801 | (37.7707637879688, -122.425391628868) | ||
141180 | 141180 | 122463 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1351 42nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | ||||
142635 | 142635 | 45101 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1515 Quintara St | 8 | 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) | ||
142714 | 142714 | 39326 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 0 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40896 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) | |||
142796 | 142796 | 45106 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1515 Quintara St | 9 | 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) | ||
143669 | 143669 | 88209 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 45 Cole St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51213 | 5997727.0 | 2110445.0 | 37.7747487235629 | -122.451338502105 | (37.7747487235629, -122.451338502105) | |||
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) | ||
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) | |
149058 | 149058 | 101162 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 375 Connecticut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6013244.85552 | 2105309.86913 | 37.7615251276082 | -122.397298512032 | (37.7615251276082, -122.397298512032) | |||
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) | |
151927 | 151927 | 46785 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 39 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 8 | Permit Number 44876 | 6002707.990259999 | 2093576.368 | 37.7287154095691 | -122.432902881381 | (37.7287154095691, -122.432902881381) | |
157305 | 157305 | 92399 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1919 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52800 | 6012333.07109 | 2103736.18677 | 37.7571533378831 | -122.400341483281 | (37.7571533378831, -122.400341483281) | |
157437 | 157437 | 69304 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1797 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 8 | Permit Number 33383 | 6000588.5684 | 2111327.3438 | 37.777334852873395 | -122.441503108774 | (37.7773348528734, -122.441503108774) | |
159218 | 159218 | 30811 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 62 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1995 12:00:00 AM | 9 | Permit Number 34673 | 6001681.08746 | 2094957.84255 | 37.7324503237283 | -122.436551782541 | (37.7324503237283, -122.436551782541) | |
161275 | 161275 | 46770 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 74 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 11 | Permit Number 44866 | 6002279.18771 | 2093299.47757 | 37.7279308005674 | -122.4343654884 | (37.7279308005674, -122.4343654884) | |
166117 | 166117 | 69161 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1254 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 9 | Permit Number 33198 | 5983381.3386 | 2106589.0591 | 37.763329543798704 | -122.500677091372 | (37.7633295437987, -122.500677091372) | |
169488 | 169488 | 52560 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1742 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 7 | Permit Number 48656 | 5984113.6499 | 2103302.6049 | 37.754348825722396 | -122.497901608629 | (37.7543488257224, -122.497901608629) | |
175204 | 175204 | 92786 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 730 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2009 12:00:00 AM | 7 | 3x3 | Permit Number 53002 | 5993210.673769999 | 2110494.9525099997 | 37.7746262414897 | -122.466964898529 | (37.7746262414897, -122.466964898529) |
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");