Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9016 | 9016 | 46728 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 10538 | 10538 | 46725 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 12797 | 12797 | 46726 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 13015 | 13015 | 46727 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 13131 | 13131 | 46724 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 13318 | 13318 | 187687 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 399X Ash St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2017 12:00:00 AM | 3 | ||||||||
| 13330 | 13330 | 187688 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 399X Ash St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2017 12:00:00 AM | 3 | ||||||||
| 13333 | 13333 | 187689 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 399X Ash St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2017 12:00:00 AM | 3 | ||||||||
| 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) | ||
| 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 | |||||||||
| 15062 | 15062 | 46723 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 15845 | 15845 | 46733 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 16083 | 16083 | 30613 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1286 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775151 | 6009246.0909 | 2109942.5257 | 37.774021892488 | -122.411455949977 | (37.774021892488, -122.411455949977) | |
| 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 | |||||||||
| 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) | ||
| 24733 | 24733 | 50832 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 886 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2004 12:00:00 AM | 6 | Permit Number 47351 | 6012122.31213 | 2104263.6699599996 | 37.7585899355868 | -122.401107436752 | (37.7585899355868, -122.401107436752) | ||
| 28990 | 28990 | 104830 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3210 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2014 12:00:00 AM | 3 | Permit Number 771109 | 5998850.28087 | 2116282.3685 | 37.790840871551296 | -122.44787320750099 | (37.7908408715513, -122.447873207501) | ||
| 33814 | 33814 | 208538 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 500 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5998751.21 | 2094997.85295 | 37.732393253641 | -122.44668389814801 | (37.732393253641, -122.446683898148) | ||||
| 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) | |
| 38776 | 38776 | 69163 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1235 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 9 | Permit Number 33200 | 5982710.0929 | 2106691.2272 | 37.763570638355105 | -122.50300623618999 | (37.7635706383551, -122.50300623619) | |
| 38888 | 38888 | 46764 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 40 Admiral Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 7 | Permit Number 44861 | 6003334.72757 | 2094151.57207 | 37.7303303185895 | -122.43077724377399 | (37.7303303185895, -122.430777243774) | |
| 40553 | 40553 | 47792 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2466 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2002 12:00:00 AM | 11 | Permit Number 45564 | 5988315.495 | 2098517.9974 | 37.741457006412396 | -122.483020075133 | (37.7414570064124, -122.483020075133) | |
| 40555 | 40555 | 46823 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 224 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 10 | Permit Number 44901 | 6003360.874919999 | 2092823.60752 | 37.7266855075134 | -122.430592127338 | (37.7266855075134, -122.430592127338) | |
| 42990 | 42990 | 45095 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1515 Quintara St | 14 | 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) | |||
| 44171 | 44171 | 69165 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1246 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 7 | Permit Number 33202 | 5982759.4384 | 2106618.0454 | 37.7633726021974 | -122.50283015088002 | (37.7633726021974, -122.50283015088) | |
| 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) | |
| 48958 | 48958 | 30696 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 15 Hermann St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 14 | Permit Number 34611 | 6005200.484759999 | 2108841.53601 | 37.770771094428504 | -122.42537203769 | (37.7707710944285, -122.42537203769) | |
| 49353 | 49353 | 46844 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 129 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 7 | Permit Number 44914 | 6004453.14766 | 2092754.8383099998 | 37.72655850077339 | -122.426811278527 | (37.7265585007734, -122.426811278527) | |
| 52673 | 52673 | 46763 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 40 Admiral Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 5 | Permit Number 44861 | 6003341.12048 | 2094139.8266200002 | 37.7302984304313 | -122.430754304762 | (37.7302984304313, -122.430754304762) | |
| 56449 | 56449 | 52564 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1275 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 6 | Permit Number 48660 | 5983650.9916 | 2106470.941 | 37.763021051858104 | -122.499735733929 | (37.7630210518581, -122.499735733929) | |
| 57809 | 57809 | 45092 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1895X 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 6 | Permit Number 43969 | 5988136.1945 | 2102427.0445 | 37.7521797768379 | -122.48392659715401 | (37.7521797768379, -122.483926597154) | |
| 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) | |
| 63205 | 63205 | 98683 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 5224 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2012 12:00:00 AM | 3 | Permit Number 768705 | 5991362.651930001 | 2114124.744 | 37.784485814122895 | -122.473622344489 | (37.7844858141229, -122.473622344489) | ||
| 64712 | 64712 | 69313 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1599 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | 4 | Permit Number 33392 | 5986810.4893 | 2104771.5308 | 37.758539831018 | -122.488683338527 | (37.758539831018, -122.488683338527) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 77847 | 77847 | 103466 | Section 143 8 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 890X Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012118.0 | 2118740.5 | 37.7983397318906 | -122.402140129264 | (37.7983397318906, -122.402140129264) | |||||
| 78077 | 78077 | 45099 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1515 Quintara St | 7 | 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) | ||
| 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) | ||
| 78934 | 78934 | 122469 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1351 42nd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | ||||
| 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) | ||
| 82502 | 82502 | 45107 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1515 Quintara St | 10 | 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) | ||
| 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) | ||
| 83092 | 83092 | 46846 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 135 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44915 | 6004442.24152802 | 2092728.35088175 | 37.7264851555148 | -122.426847095083 | (37.7264851555148, -122.426847095083) | ||
| 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) | ||
| 84879 | 84879 | 122460 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1351 42nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | ||||
| 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) | ||
| 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) | |||
| 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) | |||
| 87887 | 87887 | 45104 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1515 Quintara St | 5 | 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) | ||
| 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) | ||
| 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) | ||
| 90508 | 90508 | 45096 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1515 Quintara St | 13 | 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) | |||
| 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) | |||
| 91807 | 91807 | 45094 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1515 Quintara St | 15 | 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) |
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");