Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 41700 | 41700 | 87109 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1358 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50058 | 5985264.3746 | 2105978.0640000002 | 37.761762290042704 | -122.49411934585301 | (37.7617622900427, -122.494119345853) | |
| 86711 | 86711 | 95127 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 21 Theresa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54054 | 6002720.0 | 2093275.0 | 37.7278886022627 | -122.432839842367 | (37.7278886022627, -122.432839842367) | |
| 181699 | 181699 | 95126 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 21 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54054 | 6002704.6754 | 2093281.40937 | 37.727905331764 | -122.43289327752701 | (37.727905331764, -122.432893277527) |
| 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) | |
| 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) | ||
| 13561 | 13561 | 44761 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 761 Tehama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/2014 12:00:00 AM | 3 | Permit Number 773697 | 6009135.35285 | 2110344.07901 | 37.775118251745 | -122.411867394277 | (37.775118251745, -122.411867394277) | ||
| 16583 | 16583 | 44760 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 761 Tehama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773697 | 6009127.693419999 | 2110338.43035 | 37.7751023121433 | -122.41189349079399 | (37.7751023121433, -122.411893490794) | |
| 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) |
| 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) | |||
| 86560 | 86560 | 39325 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 0 20th St | 4 | 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 88043 | 88043 | 52373 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 101ON GLADYS Appleton Ave | 2 | 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) |
| 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) | ||
| 137949 | 137949 | 75807 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1360 43rd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1993 12:00:00 AM | 4 | 5982781.2778 | 2105905.2346 | 37.761416710141894 | -122.502701850909 | (37.7614167101419, -122.502701850909) | ||
| 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) | |||
| 10 | 10 | 122670 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 301x Hickory St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 11197 | 11197 | 122672 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 301x Hickory St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 18308 | 18308 | 122668 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 301x Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 18309 | 18309 | 122669 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 301x Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 18311 | 18311 | 122671 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 301x Hickory St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 18313 | 18313 | 122673 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 301x Hickory St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 18322 | 18322 | 122675 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 301x Hickory St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 18323 | 18323 | 122674 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 301x Hickory St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 66245 | 66245 | 30695 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 15 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 4 | Permit Number 34611 | 6005182.95707 | 2108838.8706099996 | 37.7707627855907 | -122.425432476641 | (37.7707627855907, -122.425432476641) | |
| 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) | ||
| 4743 | 4743 | 148019 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 605 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:12:00 PM | 3 | Width 3ft | 6002175.19846 | 2088993.45658 | 37.7161015284444 | -122.43441724168301 | (37.7161015284444, -122.434417241683) | |
| 4744 | 4744 | 161281 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 587 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:04:00 PM | 3 | Width 0ft | 6002852.8609 | 2090206.41919 | 37.719470499446395 | -122.432161491969 | (37.7194704994464, -122.432161491969) | |
| 4780 | 4780 | 161285 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 523 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2017 03:51:00 PM | 3 | Width 0ft | 6003073.26111 | 2090557.89007 | 37.7204480544147 | -122.431424726881 | (37.7204480544147, -122.431424726881) | ||
| 4828 | 4828 | 161283 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 571 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 03:40:00 PM | 3 | Width 0ft | 6002905.32345 | 2090290.85572 | 37.719705317820896 | -122.431986174531 | (37.7197053178209, -122.431986174531) | |
| 4749 | 4749 | 161284 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 567 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 03:30:00 PM | 3 | Width 0ft | 6002918.80865 | 2090311.02788 | 37.7197614706043 | -122.43194100068199 | (37.7197614706043, -122.431941000682) | |
| 4766 | 4766 | 161282 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 579 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 03:28:00 PM | 3 | Width 0ft | 6002876.7147 | 2090246.5176400002 | 37.7195819533337 | -122.432081900155 | (37.7195819533337, -122.432081900155) | |
| 74394 | 74394 | 42694 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2500 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2005 12:00:00 AM | Permit Number 42711 | 6006694.5506045995 | 2119774.0082852 | 37.8008732765742 | -122.42098036158701 | (37.8008732765742, -122.420980361587) | ||
| 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) | |
| 4650 | 4650 | 160596 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 762 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:30:00 PM | 3 | Width 0ft | 6002428.15191 | 2089106.63112 | 37.71642663607071 | -122.43355099850599 | (37.7164266360707, -122.433550998506) | |
| 4646 | 4646 | 160597 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 766 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:25:00 PM | 3 | Width 0ft | 6002414.55284 | 2089084.1537799998 | 37.716364146664205 | -122.433596398053 | (37.7163641466642, -122.433596398053) | |
| 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) | ||
| 44797 | 44797 | 94604 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1045 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53774 | 6001884.2634 | 2112097.0876 | 37.7795221073771 | -122.437076010522 | (37.7795221073771, -122.437076010522) | |
| 4301 | 4301 | 139643 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1100 DIVISADERO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 09:46:00 AM | 3 | Width 0ft | 6001420.8793 | 2112266.7216 | 37.779961529168204 | -122.43869120897 | (37.7799615291682, -122.43869120897) | ||
| 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) | |
| 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) | ||
| 23101 | 23101 | 4130 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3550 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/27/1995 12:00:00 AM | 4 | 3x3 | 6006437.45796 | 2100604.55432 | 37.748224069995295 | -122.42050853554501 | (37.7482240699953, -122.420508535545) | ||
| 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) | ||
| 180405 | 180405 | 70659 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 322 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 7 | 6010583.10819 | 2106749.61081 | 37.7653297823641 | -122.406605907945 | (37.7653297823641, -122.406605907945) | ||
| 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) | |
| 113366 | 113366 | 4172 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3795 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/15/2014 08:17:00 AM | 3 | 4X4 | 6005296.67379 | 2100472.2695 | 37.7477964909484 | -122.424443928769 | (37.7477964909484, -122.424443928769) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 20851 | 20851 | 32167 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 434 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35509 | 6004474.73230352 | 2109832.86168631 | 37.773452003453 | -122.427953081401 | (37.773452003453, -122.427953081401) | ||
| 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) | |||
| 23041 | 23041 | 6763 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1275 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2016 12:00:00 AM | 2 | 3x3 | 6017251.5649 | 2096932.76019 | 37.7387455690451 | -122.38285781466298 | (37.7387455690451, -122.382857814663) | ||
| 41161 | 41161 | 84474 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 620 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51566 | 5995351.39424 | 2111282.86028 | 37.776912953730104 | -122.459616850165 | (37.7769129537301, -122.459616850165) | |
| 21510 | 21510 | 4053 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2934 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/2016 12:00:00 AM | 1 | 3X3 | 6009951.6651099995 | 2100626.39211 | 37.74848144967 | -122.40835799863999 | (37.74848144967, -122.40835799864) | ||
| 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) | ||
| 65083 | 65083 | 45627 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2525 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/01/2001 12:00:00 AM | 6 | Permit Number 44337 | 5986426.1598 | 2103650.8116 | 37.7554402080729 | -122.48993007778601 | (37.7554402080729, -122.489930077786) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 32759 | 32759 | 92466 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1845 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52852 | 5989152.3472 | 2101703.8633 | 37.7502532171777 | -122.48035969668501 | (37.7502532171777, -122.480359696685) |
| 53103 | 53103 | 92467 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1845 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52852 | 5989160.9577 | 2101704.6461 | 37.7502558669031 | -122.480329978654 | (37.7502558669031, -122.480329978654) |
| 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) | |
| 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) | |
| 81309 | 81309 | 95874 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1401 Kearny St | 2 | 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) | |
| 88910 | 88910 | 95875 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1401 Kearny St | 3 | 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 45974 | 45974 | 34719 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 726 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 1 | Permit Number 3834 | 5981068.63905 | 2110748.84496 | 37.7746150589051 | -122.50898471253299 | (37.7746150589051, -122.508984712533) | |
| 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) | |
| 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) | ||
| 36610 | 36610 | 45590 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1759 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 7 | Permit Number 44326 | 5985623.3689 | 2103238.9812 | 37.7542625256334 | -122.492676004521 | (37.7542625256334, -122.492676004521) | |
| 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) | ||
| 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) | |
| 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) | |
| 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) | |||
| 14981 | 14981 | 42923 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42829 | |||||||||
| 16931 | 16931 | 42924 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42829 | |||||||||
| 19648 | 19648 | 88109 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1305 48th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51113 | 5981150.4 | 2106141.9 | 37.7619705488895 | -122.50835984594299 | (37.7619705488895, -122.508359845943) | |||
| 65673 | 65673 | 81165 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1467 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51101 | 5983077.2683 | 2105157.8512 | 37.759381996820395 | -122.50162286583999 | (37.7593819968204, -122.50162286584) | |
| 79098 | 79098 | 88101 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1500@Kirkham 44th Ave | 4 | 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) | ||
| 83113 | 83113 | 88100 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1500@Kirkham 44th Ave | 3 | 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) | ||
| 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) | ||
| 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) | ||
| 179148 | 179148 | 84066 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1958 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51105 | 5983243.228999999 | 2101802.5502 | 37.750179025863105 | -122.500800774645 | (37.7501790258631, -122.500800774645) | |
| 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) | ||
| 61630 | 61630 | 42600 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2226 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42670 | 6003830.77571 | 2116325.44496 | 37.7912425636483 | -122.430644005628 | (37.7912425636483, -122.430644005628) | |
| 180205 | 180205 | 42599 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2222 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 4 | Permit Number 42669 | 6003877.92614 | 2116329.40578 | 37.7912561101206 | -122.43048114921301 | (37.7912561101206, -122.430481149213) | |
| 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) |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) |
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");