Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, DBH, PlotSize
qSiteInfo ✖
qCareAssistant ✖
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | ||
20218 | 20218 | 4065 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3075 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009147.76851 | 2100538.02687 | 37.748193768248704 | -122.411131628336 | (37.7481937682487, -122.411131628336) | |||
22240 | 22240 | 4066 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3075 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009164.81651 | 2100538.0301200002 | 37.7481947332136 | -122.41107267688999 | (37.7481947332136, -122.41107267689) | |||
17477 | 17477 | 4067 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3096 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6009129.76815 | 2100619.82183 | 37.7484173495801 | -122.411199650344 | (37.7484173495801, -122.411199650344) | ||
21690 | 21690 | 4077 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3200X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6008348.6867 | 2100615.53254 | 37.7483617364081 | -122.413900318962 | (37.7483617364081, -122.413900318962) | |||
88090 | 88090 | 4078 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3200X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6008412.1891644 | 2100602.6212259 | 37.7483298510109 | -122.413679815119 | (37.7483298510109, -122.413679815119) | |||
21978 | 21978 | 4079 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3200X Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/1998 12:00:00 AM | 3 | 3X3 | 6008309.37499 | 2100615.3209700002 | 37.7483589476023 | -122.414036243399 | (37.7483589476023, -122.414036243399) | ||
1302 | 1302 | 4080 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3200X Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3X6 | 6008284.97439 | 2100614.30528 | 37.7483547882437 | -122.414120548517 | (37.7483547882437, -122.414120548517) | ||
20537 | 20537 | 4114 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3405 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006963.52964 | 2100524.30588 | 37.7480333588561 | -122.418683701415 | (37.7480333588561, -122.418683701415) | |||
20947 | 20947 | 4116 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3425 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 12 | 3X3 | 6006570.52935 | 2100520.79948 | 37.7480015966124 | -122.420042434916 | (37.7480015966124, -122.420042434916) | ||
19317 | 19317 | 4117 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3425 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 12 | 3X3 | 6006587.39221 | 2100520.66079 | 37.7480021658686 | -122.419984113875 | (37.7480021658686, -122.419984113875) | ||
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) | ||
21261 | 21261 | 4131 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3550 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006413.7316 | 2100602.86847 | 37.7482181038987 | -122.420590461077 | (37.7482181038987, -122.420590461077) | |||
1275 | 1275 | 4132 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3550 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3x3 | 6006390.9849 | 2100603.33536 | 37.7482181038931 | -122.420669151754 | (37.7482181038931, -122.420669151754) | ||
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) | ||
79302 | 79302 | 4285 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 4310X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 2X3 | 6001895.2244565 | 2100336.5410682997 | 37.747231143218606 | -122.43619623965799 | (37.7472311432186, -122.436196239658) | ||
146201 | 146201 | 4286 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 4310X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 2X3 | 6001895.2244565 | 2100336.5410682997 | 37.747231143218606 | -122.43619623965799 | (37.7472311432186, -122.436196239658) | ||
98439 | 98439 | 4287 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 4310X Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/27/1998 12:00:00 AM | 3 | 2X3 | 6001895.2244565 | 2100336.5410682997 | 37.747231143218606 | -122.43619623965799 | (37.7472311432186, -122.436196239658) | ||
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) | ||
519 | 519 | 6766 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1275 Fairfax Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:39:00 PM | 3 | 3x3 | 6017299.75412 | 2096896.40625 | 37.7386484107882 | -122.38268866835199 | (37.7386484107882, -122.382688668352) | ||
77732 | 77732 | 6962 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 679 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004187.88701 | 2110434.988 | 37.7750890628147 | -122.428988258507 | (37.7750890628147, -122.428988258507) | |||
17164 | 17164 | 14572 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1108 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 5999419.871 | 2109022.8342 | 37.770940605612005 | -122.445380257614 | (37.770940605612, -122.445380257614) | |||
85607 | 85607 | 25976 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2065 Oakdale Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2016 12:00:00 AM | 3 | 2x3 | 6012647.581347 | 2097234.3690945 | 37.739318274919896 | -122.398797486611 | (37.7393182749199, -122.398797486611) | ||
17922 | 17922 | 26420 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1492 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005205.18394 | 2099681.3110700003 | 37.7456195335093 | -122.424704037463 | (37.7456195335093, -122.424704037463) | |||
23301 | 23301 | 26453 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 401X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1998 12:00:00 AM | 3 | 3X3 | 6017690.9643 | 2096738.1132099999 | 37.7382353746521 | -122.381325031738 | (37.7382353746521, -122.381325031738) | ||
23347 | 23347 | 26555 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3795 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6005295.67635 | 2100471.79281 | 37.7477951257409 | -122.424447343969 | (37.7477951257409, -122.424447343969) | |||
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) | |
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) | ||
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) | |
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) | |
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) | |
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) | |
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) | ||
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) | ||
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) | ||
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) | ||
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) | |
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) | ||
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) | |
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) | |||
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) | |
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) | |
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) | |||
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) | |||
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) | |||
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) | |
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) | ||
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) | ||
105713 | 105713 | 40250 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3351X 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/13/1999 12:00:00 AM | 3 | 3x3 | Permit Number 41415 | 6006702.84210434 | 2102592.14346256 | 37.7536964884672 | -122.419731851285 | (37.7536964884672, -122.419731851285) |
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) |
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) | |
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) | |
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) | ||
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 | |||||||||
26307 | 26307 | 43624 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2166 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767454 | 5985452.8396 | 2100473.0701 | 37.74665811619779 | -122.493061992867 | (37.7466581161978, -122.493061992867) |
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) | |
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) | |
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) | |
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) | ||
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) | |
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | |
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) | ||
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) | ||
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) | |
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) |
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) | ||
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) | |||
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) | |||
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) | |||
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) | |
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) | ||
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) | |||
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 | |||||||||
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 |
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");