Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
951 | 951 | 248015 | DPW Maintained 3 | Casuarina cunninghamiana :: Horsetail pine 123 | 525 Franconia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 4ft | 6009932.57505 | 2098116.0025400002 | 37.741587399748894 | -122.408246979117 | (37.7415873997489, -122.408246979117) | |||
1789 | 1789 | 251698 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 700 Jamestown Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6015296.9798 | 2088405.4002 | 37.71522295028 | -122.389020693471 | (37.71522295028, -122.389020693471) | ||||
3495 | 3495 | 82708 | Permitted Site 1 | Casuarina cunninghamiana :: Horsetail pine 123 | 728 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 14 | 3x3 | Permit Number 52492 | 6015291.25471 | 2088404.66417 | 37.7152206119305 | -122.38904043068399 | (37.7152206119305, -122.389040430684) | |
9444 | 9444 | 173598 | Significant Tree 6 | Casuarina cunninghamiana :: Horsetail pine 123 | 1771 11th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 5992768.0 | 2103420.0 | 37.7551747322674 | -122.467981458634 | (37.7551747322674, -122.467981458634) | |||
23780 | 23780 | 126447 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2656 Broderick St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6000161.293869999 | 2117775.76551 | 37.795016194482706 | -122.44344449519 | (37.7950161944827, -122.44344449519) | |||
27783 | 27783 | 126443 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2601 Vallejo St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001049.1036 | 2117561.90352 | 37.7944795753318 | -122.440357204422 | (37.7944795753318, -122.440357204422) | |||
30428 | 30428 | 204704 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 1701 Irving St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990371.2577599995 | 2106504.61857 | 37.7635055732383 | -122.47649533489701 | (37.7635055732383, -122.476495334897) | |||
33543 | 33543 | 126448 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2401 Broadway | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6002040.59654 | 2117340.69483 | 37.7939285966777 | -122.43691067858299 | (37.7939285966777, -122.436910678583) | |||
33603 | 33603 | 126442 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 1601 Beach St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6002503.29983 | 2121235.66202 | 37.8046494462659 | -122.435588461158 | (37.8046494462659, -122.435588461158) | |||
35889 | 35889 | 185557 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2201 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984925.3425 | 2099814.4466 | 37.744818850863794 | -122.494837444262 | (37.7448188508638, -122.494837444262) | |||
36122 | 36122 | 248019 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 525 Franconia St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6009962.41848 | 2098212.02892 | 37.741852738408 | -122.408150561002 | (37.741852738408, -122.408150561002) | |||
38528 | 38528 | 185435 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2300 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985116.6315 | 2099415.327 | 37.7437341719949 | -122.49414660134899 | (37.7437341719949, -122.494146601349) | |||
39390 | 39390 | 200797 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 700 Jamestown Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015309.1382 | 2088387.6302 | 37.715174831256704 | -122.388977428453 | (37.7151748312567, -122.388977428453) | |||
39395 | 39395 | 223872 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 310 Liberty St | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6004160.81529 | 2103945.20592 | 37.7572681525309 | -122.428619194619 | (37.7572681525309, -122.428619194619) | |||
42613 | 42613 | 191031 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 601 Wisconsin St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6012727.00633 | 2104624.78835 | 37.7596152022936 | -122.399041463801 | (37.7596152022936, -122.399041463801) | |||
43228 | 43228 | 200140 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 700 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015344.6781 | 2088315.6151 | 37.714979061664295 | -122.388849561469 | (37.7149790616643, -122.388849561469) | |||
47389 | 47389 | 40047 | Permitted Site 1 | Casuarina cunninghamiana :: Horsetail pine 123 | 1748 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1999 12:00:00 AM | 15 | Permit Number 41284 | 6014490.89885 | 2095235.14935 | 37.733931362340705 | -122.392284274492 | (37.7339313623407, -122.392284274492) | |
47680 | 47680 | 184086 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 1600 Sunset Blvd | 87 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984957.3486 | 2104087.5098 | 37.7565533840583 | -122.495041800117 | (37.7565533840583, -122.495041800117) | |||
48770 | 48770 | 200139 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 700 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015356.8365 | 2088295.9747 | 37.7149258068198 | -122.388806166206 | (37.7149258068198, -122.388806166206) | |||
49290 | 49290 | 78320 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 830 Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 14 | 6009222.3521300005 | 2090505.2073099997 | 37.7206499863841 | -122.41016549563999 | (37.7206499863841, -122.41016549564) | ||
49987 | 49987 | 223870 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 310 Liberty St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6004165.7339 | 2103945.48087 | 37.757269185837295 | -122.428602203741 | (37.7572691858373, -122.428602203741) | |||
52982 | 52982 | 223871 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 310 Liberty St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6004161.87105 | 2103941.4208299997 | 37.7572578193179 | -122.42861527358299 | (37.7572578193179, -122.428615273583) | |||
57337 | 57337 | 204700 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 1708 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5990418.27546 | 2106568.79929 | 37.763684523058 | -122.47633740584101 | (37.763684523058, -122.476337405841) | |||
59768 | 59768 | 187346 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2200 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985099.3282 | 2099721.0758 | 37.7445726628756 | -122.494228962515 | (37.7445726628756, -122.494228962515) | |||
62162 | 62162 | 248012 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 525 Franconia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6009917.55831 | 2098055.52867 | 37.7414205107404 | -122.40829463781401 | (37.7414205107404, -122.408294637814) | |||
62269 | 62269 | 126450 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2401 Broadway | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6002086.73219 | 2117346.5512599996 | 37.793947298979504 | -122.436751464412 | (37.7939472989795, -122.436751464412) | |||
62347 | 62347 | 126446 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2656 Broderick St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6000160.0682 | 2117773.16546 | 37.795008985534395 | -122.443448549322 | (37.7950089855344, -122.443448549322) | |||
66545 | 66545 | 126444 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2601 Vallejo St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6001059.38792 | 2117563.4406 | 37.7944843813066 | -122.440321729778 | (37.7944843813066, -122.440321729778) | |||
67538 | 67538 | 248010 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 525 Franconia St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6009913.14391 | 2098013.75729 | 37.741305568398104 | -122.408306955813 | (37.7413055683981, -122.408306955813) | |||
68751 | 68751 | 184077 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 1600 Sunset Blvd | 78 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984949.117000001 | 2104038.1203 | 37.7564172922771 | -122.495066625722 | (37.7564172922771, -122.495066625722) | |||
69650 | 69650 | 204699 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 1325 18th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 6ft | 5990483.27142 | 2106360.56489 | 37.7631165364244 | -122.476097397488 | (37.7631165364244, -122.476097397488) | |||
74060 | 74060 | 223873 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 310 Liberty St | 53 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003827.49895 | 2103926.48833 | 37.757197889383 | -122.429770597528 | (37.757197889383, -122.429770597528) | |||
74309 | 74309 | 248017 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 525 Franconia St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 6ft | 6009948.88401 | 2098163.6400900004 | 37.7417191153415 | -122.408193947005 | (37.7417191153415, -122.408193947005) | |||
75695 | 75695 | 126441 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 1601 Beach St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6002491.85461 | 2121233.39773 | 37.8046425790601 | -122.435627906308 | (37.8046425790601, -122.435627906308) | |||
76116 | 76116 | 204702 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 1701 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5990288.33301 | 2106501.46876 | 37.763492114902206 | -122.47678191195 | (37.7634921149022, -122.47678191195) | |||
76797 | 76797 | 184436 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 3832 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5981489.6965 | 2100816.3891 | 37.7473681966369 | -122.506791353844 | (37.7473681966369, -122.506791353844) | |||
76970 | 76970 | 126445 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2601 Vallejo St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6001071.40482 | 2117563.77475 | 37.7944859829844 | -122.44028017389499 | (37.7944859829844, -122.440280173895) | |||
130070 | 130070 | 73785 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 1342 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1997 12:00:00 AM | 15 | 5988676.4118 | 2106176.1706 | 37.7625053013705 | -122.48233313043801 | (37.7625053013705, -122.482333130438) | ||
131592 | 131592 | 204701 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 1708 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5990405.41807 | 2106567.82065 | 37.7636810903261 | -122.476381803596 | (37.7636810903261, -122.476381803596) | |||
150521 | 150521 | 185561 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2201 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984873.8699 | 2099777.8321 | 37.744715304246604 | -122.495012724857 | (37.7447153042466, -122.495012724857) | |||
151915 | 151915 | 222621 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 275 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007804.561840001 | 2106235.52037 | 37.763762365669606 | -122.41617986380501 | (37.7637623656696, -122.416179863805) | |||
155827 | 155827 | 187359 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2200 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985046.8536 | 2099804.0196 | 37.744797333195294 | -122.49441651949199 | (37.7447973331953, -122.494416519492) | |||
159266 | 159266 | 222618 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 100 Alemany Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009365.793430001 | 2095894.2189 | 37.7354551097631 | -122.41004991207599 | (37.7354551097631, -122.410049912076) | |||
162738 | 162738 | 200798 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 700 Jamestown Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015296.9798 | 2088405.4002 | 37.71522295028 | -122.389020693471 | (37.71522295028, -122.389020693471) | |||
164740 | 164740 | 222619 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2070 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6008053.49701 | 2106456.27126 | 37.7643824904803 | -122.415334499301 | (37.7643824904803, -122.415334499301) | |||
164988 | 164988 | 82707 | Permitted Site 1 | Casuarina cunninghamiana :: Horsetail pine 123 | 728 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 10 | 3x3 | Permit Number 52492 | 6015289.4977 | 2088419.4291 | 37.715261056172 | -122.389047534015 | (37.715261056172, -122.389047534015) | |
168529 | 168529 | 187347 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2200 Sunset Blvd | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985050.239 | 2099735.2948 | 37.7446088316551 | -122.49439974859 | (37.7446088316551, -122.49439974859) | |||
170706 | 170706 | 222622 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 1403 Douglass St | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6001405.60814 | 2099658.97548 | 37.7453428786853 | -122.437840770053 | (37.7453428786853, -122.437840770053) | |||
170963 | 170963 | 200141 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 700 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015336.2607 | 2088334.3204 | 37.7150299562444 | -122.388879960947 | (37.7150299562444, -122.388879960947) | |||
171772 | 171772 | 222620 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2080 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008061.85014 | 2106305.07413 | 37.763967807681496 | -122.41529490396002 | (37.7639678076815, -122.41529490396) | |||
173981 | 173981 | 204703 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 1701 Irving St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5990335.67224 | 2106502.91932 | 37.7634988436072 | -122.476618288403 | (37.7634988436072, -122.476618288403) | |||
174575 | 174575 | 126449 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2401 Broadway | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6002081.41043 | 2117344.80364 | 37.7939421980234 | -122.436769753035 | (37.7939421980234, -122.436769753035) | |||
174707 | 174707 | 222616 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 100 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009648.8071099995 | 2096248.24649 | 37.7364430518981 | -122.409096395993 | (37.7364430518981, -122.409096395993) | |||
175205 | 175205 | 126439 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 3700 Webster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6002595.71169 | 2121316.79455 | 37.804877463081205 | -122.43527446824 | (37.8048774630812, -122.43527446824) | |||
178171 | 178171 | 126440 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 3700 Webster St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6002594.85565 | 2121336.78528 | 37.8049323037346 | -122.435278861456 | (37.8049323037346, -122.435278861456) | |||
182586 | 182586 | 72595 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 1342 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1997 12:00:00 AM | 8 | 5988674.2474 | 2106188.616 | 37.7625393471524 | -122.482341528113 | (37.7625393471524, -122.482341528113) | ||
183889 | 183889 | 188396 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 760 De Haro St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 9ft | 6012087.53124 | 2104906.41164 | 37.760352821738 | -122.401272892241 | (37.760352821738, -122.401272892241) | |||
185681 | 185681 | 222617 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 100 Alemany Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6009476.82637 | 2095975.18511 | 37.7356836481774 | -122.409671740872 | (37.7356836481774, -122.409671740872) |
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");