Data source: data.sfgov.org
This data as json, CSV (advanced)
qCareAssistant ✖
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||
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 | |||||||||
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 | |||||||||
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) | |
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) | |
161275 | 161275 | 46770 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 74 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 11 | Permit Number 44866 | 6002279.18771 | 2093299.47757 | 37.7279308005674 | -122.4343654884 | (37.7279308005674, -122.4343654884) | |
178167 | 178167 | 46782 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 86 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 11 | Permit Number 44873 | 6002371.043380001 | 2093537.4408599997 | 37.7285894073556 | -122.434064944849 | (37.7285894073556, -122.434064944849) | |
151927 | 151927 | 46785 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 39 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 8 | Permit Number 44876 | 6002707.990259999 | 2093576.368 | 37.7287154095691 | -122.432902881381 | (37.7287154095691, -122.432902881381) | |
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) | |
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) | |
10543 | 10543 | 46845 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 135 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 9 | 4x4 | Permit Number 44915 | 6004431.15972 | 2092720.1112 | 37.726461904584 | -122.426884817887 | (37.726461904584, -122.426884817887) |
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) | ||
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) | |||
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) | ||
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) | ||
144365 | 144365 | 47345 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 733 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45271 | 5992127.57575512 | 2090471.77540526 | 37.71958517270679 | -122.469253830769 | (37.7195851727068, -122.469253830769) | ||
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) | ||
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) | |
122787 | 122787 | 47542 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 453 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45409 | 6003598.72403802 | 2099787.33509963 | 37.745819789565104 | -122.430266493752 | (37.7458197895651, -122.430266493752) | ||
30077 | 30077 | 47685 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 375 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | 9 | 9x5 | Permit Number 45480 | 6013248.64993 | 2105253.57777 | 37.7613707751535 | -122.39728144108 | (37.7613707751535, -122.39728144108) |
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) | |
24911 | 24911 | 47896 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 639 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2002 12:00:00 AM | 3 | 3x3 | Permit Number 45640 | 6001064.0564 | 2110917.2604 | 37.7762359450792 | -122.439828836132 | (37.7762359450792, -122.439828836132) |
100210 | 100210 | 47897 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 641 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50499 | 6001064.62263779 | 2110863.06627467 | 37.77608717392229 | -122.439822990908 | (37.7760871739223, -122.439822990908) | |
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) | ||
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) | ||
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) | ||
185729 | 185729 | 49778 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 183 Tioga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | 14 | Permit Number 46564 | 6009996.28583 | 2089168.57309 | 37.7170232148362 | -122.40739605408702 | (37.7170232148362, -122.407396054087) | |
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) | |||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
169488 | 169488 | 52560 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1742 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 7 | Permit Number 48656 | 5984113.6499 | 2103302.6049 | 37.754348825722396 | -122.497901608629 | (37.7543488257224, -122.497901608629) | |
148373 | 148373 | 52563 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1275 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 4 | Permit Number 48660 | 5983651.2644 | 2106493.3098 | 37.7630824862581 | -122.49973644381399 | (37.7630824862581, -122.499736443814) | |
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) | |
137543 | 137543 | 55814 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1471 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2002 12:00:00 AM | 5 | Permit Number 11861 | 5982145.0874 | 2105106.6766 | 37.7591866900991 | -122.50484295630501 | (37.7591866900991, -122.504842956305) | |
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) | ||
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) | |
81450 | 81450 | 61675 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2037 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2010 12:00:00 AM | 3x3 | Permit Number 53364 | 6003935.46106067 | 2107133.46440575 | 37.7660095916974 | -122.42962593922701 | (37.7660095916974, -122.429625939227) | ||
106584 | 106584 | 64304 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1610 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50559 | 6003959.54374293 | 2098890.96044294 | 37.7433789825316 | -122.428954934478 | (37.7433789825316, -122.428954934478) | ||
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) | ||
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) | ||
128716 | 128716 | 69031 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1295 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | Permit Number 33037 | 5984271.37541102 | 2106373.05880115 | 37.762788679322 | -122.49758284403299 | (37.762788679322, -122.497582844033) | ||
176386 | 176386 | 69036 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1413 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 0 | Permit Number 33042 | 5984299.72076872 | 2105549.13339253 | 37.7605280731461 | -122.497423979021 | (37.7605280731461, -122.497423979021) | |
138228 | 138228 | 69038 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1458 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 8 | Permit Number 33044 | 5984359.7211 | 2105241.4653 | 37.7596868192975 | -122.497193756865 | (37.7596868192975, -122.497193756865) | |
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) | ||
166117 | 166117 | 69161 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1254 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 9 | Permit Number 33198 | 5983381.3386 | 2106589.0591 | 37.763329543798704 | -122.500677091372 | (37.7633295437987, -122.500677091372) | |
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) | |
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) | |
157437 | 157437 | 69304 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1797 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 8 | Permit Number 33383 | 6000588.5684 | 2111327.3438 | 37.777334852873395 | -122.441503108774 | (37.7773348528734, -122.441503108774) | |
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) | |
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) | ||
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) | ||
189011 | 189011 | 80586 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1919 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5985971.2412 | 2102145.8827 | 37.7512815105045 | -122.49139254176599 | (37.7512815105045, -122.491392541766) | |||
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) | |
98434 | 98434 | 83774 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 439 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50860 | 5993553.67824135 | 2105258.69385087 | 37.7602686491328 | -122.46539793460899 | (37.7602686491328, -122.465397934609) | ||
127672 | 127672 | 83923 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 433 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50861 | 5993571.485212901 | 2105259.30286396 | 37.7602713482766 | -122.465336393395 | (37.7602713482766, -122.465336393395) | ||
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) | |
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) | |
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) | ||
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) | |
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) | ||
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) | ||
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) | ||
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) | |||
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) | |||
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) | |||
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) | ||
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) | |
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) |
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) | |
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) | |
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) | |
124251 | 124251 | 93970 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3400 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 53400 | 6006959.5 | 2100632.2 | 37.7483293848143 | -122.41870528613501 | (37.7483293848143, -122.418705286135) | ||
101880 | 101880 | 93995 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1572 15th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53417 | 6006987.0 | 2107345.0 | 37.7667627325299 | -122.419086266495 | (37.7667627325299, -122.419086266495) | ||||
93389 | 93389 | 94135 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 150 Peralta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53499 | 6009988.7 | 2100136.6 | 37.7471386620606 | -122.40819539283301 | (37.7471386620606, -122.408195392833) | |
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) | ||
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) | |
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) |
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) | |
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) | |
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) | |
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) | |
116015 | 116015 | 97497 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1520 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2010 12:00:00 AM | 3 | 3x3 | 6015724.7 | 2096772.7 | 37.7382215976335 | -122.388125873954 | (37.7382215976335, -122.388125873954) | |
119065 | 119065 | 98218 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1501X 42nd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 3 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | ||
120505 | 120505 | 98220 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1501X 42nd Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | ||
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) | ||
79730 | 79730 | 99039 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 200X Bartlett St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6006692.0 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | ||
70942 | 70942 | 101160 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 375 Connecticut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6x5 | 6013245.35442 | 2105273.6114 | 37.7614255996257 | -122.39729424385901 | (37.7614255996257, -122.397294243859) |
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");