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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
81495 | 81495 | 31073 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1700X 15th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34816 | 6005529.95864507 | 2107274.01239209 | 37.7664856587307 | -122.424120885174 | (37.7664856587307, -122.424120885174) | ||
97148 | 97148 | 17813 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1900X Pine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2012 12:00:00 AM | 4 | 3x3 | 6004830.0574482 | 2115432.8862429 | 37.7888483829176 | -122.427122914168 | (37.7888483829176, -122.427122914168) | ||
127526 | 127526 | 14869 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1399 McAllister St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002569.68984 | 2111577.93891 | 37.7781355917554 | -122.434667698155 | (37.7781355917554, -122.434667698155) | ||
143650 | 143650 | 97837 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | ||||
188652 | 188652 | 32989 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013088.2865 | 2113616.3325900002 | 37.784324082736795 | -122.398422883105 | (37.7843240827368, -122.398422883105) | |
32201 | 32201 | 198478 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 800 Minnesota St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6015196.41735 | 2104702.3820599997 | 37.759965557478296 | -122.390506356185 | (37.7599655574783, -122.390506356185) | |||
36409 | 36409 | 198632 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015782.37645 | 2108741.7224 | 37.77108919993629 | -122.38876177932501 | (37.7710891999363, -122.388761779325) | ||||
40762 | 40762 | 198606 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 456 Mission Bay Blvd South | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6016250.47578 | 2108648.85468 | 37.7708601381228 | -122.387136114449 | (37.7708601381228, -122.387136114449) | ||||
47464 | 47464 | 215545 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 90 Santa Paula Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993953.28384 | 2097231.84575 | 37.7382520031164 | -122.46343338275899 | (37.7382520031164, -122.463433382759) | |||
53705 | 53705 | 141759 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 10 HOLLIS ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003937.2446 | 2113390.8375 | 37.7831909022721 | -122.43006619100001 | (37.7831909022721, -122.430066191) | |||
58881 | 58881 | 198617 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015877.04462 | 2108628.30945 | 37.7707830392222 | -122.388426398764 | (37.7707830392222, -122.388426398764) | ||||
60626 | 60626 | 137052 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1221 Jones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008525.03986 | 2116714.30677 | 37.7925751052991 | -122.414429454859 | (37.7925751052991, -122.414429454859) | |||
61711 | 61711 | 198497 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 950 Tennessee St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015478.44281 | 2104579.86448 | 37.759644791788396 | -122.389522401658 | (37.7596447917884, -122.389522401658) | |||
62289 | 62289 | 137024 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2201 Broadway | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6003051.10397 | 2117478.36483 | 37.794363984556796 | -122.433424069968 | (37.7943639845568, -122.433424069968) | |||
68611 | 68611 | 198586 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013678.519180001 | 2107141.48068 | 37.7665784640576 | -122.39592699106001 | (37.7665784640576, -122.39592699106) | |||
70009 | 70009 | 198432 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2233 17th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010814.0242 | 2106448.5389400003 | 37.7645160236153 | -122.40578601041099 | (37.7645160236153, -122.405786010411) | |||
70855 | 70855 | 198568 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 400 01st St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6014772.61549 | 2114134.95579 | 37.7858417885051 | -122.392631938935 | (37.7858417885051, -122.392631938935) | |||
73419 | 73419 | 242502 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2618 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6008245.3225 | 2103001.91157 | 37.754908389924296 | -122.41442658334101 | (37.7549083899243, -122.414426583341) | |||
94187 | 94187 | 105880 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 131X RUSS ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 5x5 | 6010355.0 | 2111553.0 | 37.778506015273706 | -122.407733605583 | (37.7785060152737, -122.407733605583) | |||
98194 | 98194 | 70472 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 450X Banks St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 4 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
131606 | 131606 | 242557 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2355 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008209.56252 | 2104759.1326900003 | 37.7597313092745 | -122.414674599275 | (37.7597313092745, -122.414674599275) | |||
136167 | 136167 | 201911 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013805.76571 | 2093216.36455 | 37.72835012384171 | -122.394511693764 | (37.7283501238417, -122.394511693764) | |||
137967 | 137967 | 198487 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6015204.943 | 2104516.59795 | 37.7594559071887 | -122.39046388839701 | (37.7594559071887, -122.390463888397) | |||
147769 | 147769 | 141753 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2 HOLLIS ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003977.6484 | 2113242.1747 | 37.782784999558395 | -122.429915802437 | (37.7827849995584, -122.429915802437) | |||
153089 | 153089 | 215510 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Santa Paula Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994019.7098199995 | 2096325.7252599997 | 37.73576784809 | -122.463137987822 | (37.73576784809, -122.463137987822) | |||
155342 | 155342 | 198498 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1215 Michigan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6016508.17513 | 2102448.92255 | 37.753850715249 | -122.38581250754801 | (37.753850715249, -122.385812507548) | |||
157638 | 157638 | 198438 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 500 Mariposa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015515.1733099995 | 2106293.1839400004 | 37.764351234542 | -122.389515023625 | (37.764351234542, -122.389515023625) | |||
157928 | 157928 | 198458 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 700 Mariposa St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6014912.11479 | 2106274.08898 | 37.7642653483915 | -122.39159951631399 | (37.7642653483915, -122.391599516314) | |||
165641 | 165641 | 242482 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2675 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6008309.34886 | 2102910.2805 | 37.754660388370105 | -122.41419867894501 | (37.7546603883701, -122.414198678945) | |||
167424 | 167424 | 198655 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6014030.31136 | 2107306.6382299997 | 37.7670515155374 | -122.3947217619 | (37.7670515155374, -122.3947217619) | |||
167461 | 167461 | 198680 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 Russ St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6010306.35372 | 2111595.60808 | 37.7786202837256 | -122.40790489770399 | (37.7786202837256, -122.407904897704) | |||
173024 | 173024 | 198692 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1301 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6016712.13371 | 2094960.30012 | 37.733299770270904 | -122.38458557598601 | (37.7332997702709, -122.384585575986) | |||
173274 | 173274 | 198647 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 421 Mission Bay Blvd North | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6016245.346419999 | 2108770.39329 | 37.7711935725654 | -122.387162335966 | (37.7711935725654, -122.387162335966) | ||||
174581 | 174581 | 198578 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 425 01st St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6014761.290709999 | 2114189.1211599996 | 37.7859898852611 | -122.39267491031299 | (37.7859898852611, -122.392674910313) | |||
185954 | 185954 | 198468 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 707 18th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6015390.71439 | 2105768.72163 | 37.7629042730221 | -122.38990885831801 | (37.7629042730221, -122.389908858318) | |||
187500 | 187500 | 242738 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 115 Corbett Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000793.83368 | 2105649.34692 | 37.7617561832258 | -122.440385717444 | (37.7617561832258, -122.440385717444) | |||
1189 | 1189 | 119798 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
1231 | 1231 | 119833 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
11152 | 11152 | 17582 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003762.13068 | 2090345.22062 | 37.7199031291015 | -122.42902837176202 | (37.7199031291015, -122.429028371762) | |||
15284 | 15284 | 91036 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010688.5143 | 2111227.8126 | 37.7776317911098 | -122.406556926191 | (37.7776317911098, -122.406556926191) | ||
22362 | 22362 | 244426 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005680.8792 | 2109772.4112 | 37.773354183173396 | -122.423776541571 | (37.7733541831734, -122.423776541571) | |||
34812 | 34812 | 244359 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005522.1928 | 2110456.2865 | 37.7752229798737 | -122.42437411128701 | (37.7752229798737, -122.424374111287) | |||
43571 | 43571 | 200600 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016471.5892 | 2094834.3971 | 37.7329407602926 | -122.385408441845 | (37.7329407602926, -122.385408441845) | |||
45981 | 45981 | 244376 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005617.5038 | 2109799.1317 | 37.7734239734056 | -122.423997666684 | (37.7734239734056, -122.423997666684) | |||
51603 | 51603 | 244259 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005631.8198 | 2110120.4535 | 37.7743070536408 | -122.423970999545 | (37.7743070536408, -122.423970999545) | |||
66723 | 66723 | 244358 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005582.6276 | 2110470.923 | 37.775266580631 | -122.42416609455 | (37.775266580631, -122.42416609455) | |||
79145 | 79145 | 17923 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2397X Pine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002488.019783099 | 2115056.9941341 | 37.787683560918495 | -122.435199131446 | (37.7876835609185, -122.435199131446) | |||
81045 | 81045 | 109169 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
101446 | 101446 | 119713 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
102350 | 102350 | 7633 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3255 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008510.8607 | 2099758.97829 | 37.746018935721104 | -122.413278959756 | (37.7460189357211, -122.413278959756) | |||
105222 | 105222 | 18529 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3104X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008391.22062 | 2100547.0534 | 37.748176096662604 | -122.413748394121 | (37.7481760966626, -122.413748394121) | |||
107228 | 107228 | 119786 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
108623 | 108623 | 16443 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
110275 | 110275 | 119680 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
113677 | 113677 | 16437 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1299X Newcomb Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016431.7799349995 | 2094795.0104810002 | 37.7328304099415 | -122.385543330143 | (37.7328304099415, -122.385543330143) | |||
131030 | 131030 | 246540 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6005683.44933 | 2109420.77798 | 37.7723888282128 | -122.423742644211 | (37.7723888282128, -122.423742644211) | |||
143969 | 143969 | 119822 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
144437 | 144437 | 16423 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016393.65878 | 2094869.65123 | 37.73303324923471 | -122.385680326224 | (37.7330332492347, -122.385680326224) | |||
158186 | 158186 | 244477 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005574.5359 | 2110115.107 | 37.77428913922 | -122.424168774988 | (37.77428913922, -122.424168774988) | |||
178300 | 178300 | 246552 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 6005729.77249 | 2109512.91923 | 37.77264444073 | -122.423588959979 | (37.77264444073, -122.423588959979) |
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");