Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25963 | 25963 | 179311 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 427 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6006943.30245 | 2092535.62338 | 37.7260970640242 | -122.418187352968 | (37.7260970640242, -122.418187352968) | |||
26025 | 26025 | 136191 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6002535.252730001 | 2118218.14981 | 37.7963659626655 | -122.435261914602 | (37.7963659626655, -122.435261914602) | |||
26848 | 26848 | 239353 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 333 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003763.4516900005 | 2098632.19433 | 37.7426573690441 | -122.429614519315 | (37.7426573690441, -122.429614519315) | |||
27611 | 27611 | 239367 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 17 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6004711.71138 | 2103517.26847 | 37.756124298509896 | -122.42668350644101 | (37.7561242985099, -122.426683506441) | |||
30247 | 30247 | 179306 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 272 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003680.49546 | 2092115.04602 | 37.7247580571263 | -122.429436701757 | (37.7247580571263, -122.429436701757) | |||
36489 | 36489 | 213993 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 95 Martha Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000354.21561 | 2095866.7572 | 37.7348705009689 | -122.441204268679 | (37.7348705009689, -122.441204268679) | |||
38945 | 38945 | 239368 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 7 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6004707.84944 | 2103578.58278 | 37.7562924348615 | -122.426701228489 | (37.7562924348615, -122.426701228489) | |||
40711 | 40711 | 179300 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 318 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003594.26211 | 2092734.45611 | 37.7264539365874 | -122.42977895945499 | (37.7264539365874, -122.429778959455) | |||
40842 | 40842 | 197113 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2030 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012295.98887 | 2102846.65042 | 37.7547087979762 | -122.40040724889299 | (37.7547087979762, -122.400407248893) | |||
41318 | 41318 | 240143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998171.35185 | 2106192.58759 | 37.763098116497204 | -122.449494935145 | (37.7630981164972, -122.449494935145) | |||
45337 | 45337 | 213911 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1767 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5990895.24857 | 2103389.01356 | 37.754981325851205 | -122.474455655417 | (37.7549813258512, -122.474455655417) | |||
48649 | 48649 | 240191 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 31 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004293.70696 | 2098089.97952 | 37.7411985814464 | -122.427742424874 | (37.7411985814464, -122.427742424874) | |||
49804 | 49804 | 239345 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3869 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6004701.96435 | 2101317.0101799998 | 37.7500823517234 | -122.42656054755399 | (37.7500823517234, -122.426560547554) | |||
51010 | 51010 | 136194 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002528.73575 | 2118269.03723 | 37.7965053162169 | -122.43528810647699 | (37.7965053162169, -122.435288106477) | |||
53227 | 53227 | 179288 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002296.73031 | 2094454.79419 | 37.7311040332072 | -122.434387409368 | (37.7311040332072, -122.434387409368) | |||
54021 | 54021 | 248025 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 443 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6009980.9710099995 | 2098457.93236 | 37.7425289746384 | -122.408103750406 | (37.7425289746384, -122.408103750406) | |||
56189 | 56189 | 240144 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1207 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998176.37667 | 2106172.1274099997 | 37.7630422254456 | -122.449476081756 | (37.7630422254456, -122.449476081756) | |||
56406 | 56406 | 179294 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 187 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004035.67978 | 2092592.11371 | 37.7260880824925 | -122.428242857139 | (37.7260880824925, -122.428242857139) | |||
67011 | 67011 | 239372 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3531 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6004798.380530001 | 2103661.55417 | 37.756525372754 | -122.426394047952 | (37.756525372754, -122.426394047952) | |||
68615 | 68615 | 240151 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1526 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5998354.70751 | 2105195.37647 | 37.760370512299 | -122.448788941261 | (37.760370512299, -122.448788941261) | |||
69560 | 69560 | 239354 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 187 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6004748.91753 | 2098687.71701 | 37.742865571999104 | -122.42621101343201 | (37.7428655719991, -122.426211013432) | |||
70600 | 70600 | 239346 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3865 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6004726.2235 | 2101319.72445 | 37.7500911758897 | -122.426476851246 | (37.7500911758897, -122.426476851246) | |||
70907 | 70907 | 197139 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 139 Venus St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012870.02823 | 2094155.1374099997 | 37.730875736712704 | -122.39781242511101 | (37.7308757367127, -122.397812425111) | |||
70956 | 70956 | 240142 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 137 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5997839.49621 | 2106779.6286400002 | 37.7646909930258 | -122.450685033183 | (37.7646909930258, -122.450685033183) | |||
72140 | 72140 | 239356 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 111 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6005135.00311 | 2098711.3374 | 37.7429522432585 | -122.42487771633101 | (37.7429522432585, -122.424877716331) | |||
72873 | 72873 | 213944 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 98 Westwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5995156.984180001 | 2093277.67362 | 37.7274640883802 | -122.458985387177 | (37.7274640883802, -122.458985387177) | |||
74659 | 74659 | 240186 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 76 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6004876.9244 | 2097755.23098 | 37.740312411980206 | -122.425702045734 | (37.7403124119802, -122.425702045734) | |||
74866 | 74866 | 240196 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 406 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004000.46579 | 2096134.03404 | 37.735811408553296 | -122.42861695621 | (37.7358114085533, -122.42861695621) | |||
75524 | 75524 | 120438 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 123 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5988956.31634 | 2114501.1697400003 | 37.7853797200377 | -122.48197492857099 | (37.7853797200377, -122.481974928571) | |||
76255 | 76255 | 240134 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 71 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6004662.60035 | 2101609.9701400003 | 37.7508845263036 | -122.42671753050301 | (37.7508845263036, -122.426717530503) | |||
130001 | 130001 | 240156 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 507 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998563.13557 | 2106225.25844 | 37.7632102269035 | -122.448142245984 | (37.7632102269035, -122.448142245984) | |||
132548 | 132548 | 136193 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002531.20881 | 2118254.41346 | 37.79646530358411 | -122.43527850261002 | (37.7964653035841, -122.43527850261) | |||
132617 | 132617 | 240206 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 81 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003903.54766 | 2097252.3303400003 | 37.7388765103369 | -122.429031747817 | (37.7388765103369, -122.429031747817) | |||
134770 | 134770 | 179307 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 263 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6003768.55013 | 2092162.8049599999 | 37.724894177618 | -122.429135711245 | (37.724894177618, -122.429135711245) | |||
137886 | 137886 | 179289 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002308.41253 | 2094461.38463 | 37.7311227921608 | -122.43434749296101 | (37.7311227921608, -122.434347492961) | |||
146977 | 146977 | 136192 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002533.36728 | 2118236.78125 | 37.796417012690505 | -122.43526977200199 | (37.7964170126905, -122.435269772002) | |||
147100 | 147100 | 240138 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 470 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003459.77034 | 2100123.18676 | 37.7467340885186 | -122.430770938652 | (37.7467340885186, -122.430770938652) | |||
149382 | 149382 | 213986 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5996577.00096 | 2089023.1695 | 37.7158637494767 | -122.45376931301399 | (37.7158637494767, -122.453769313014) | |||
149420 | 149420 | 136190 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002538.23525 | 2118203.76672 | 37.7963266398053 | -122.43525056515499 | (37.7963266398053, -122.435250565155) | |||
150546 | 150546 | 213943 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 98 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995156.25779 | 2093258.2613099997 | 37.727410745106 | -122.45898649333799 | (37.727410745106, -122.458986493338) | |||
150726 | 150726 | 239269 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 27 Woodward St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6006491.50571 | 2108328.68595 | 37.7694357855487 | -122.420869947001 | (37.7694357855487, -122.420869947001) | |||
151453 | 151453 | 239348 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 514 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6003174.42252 | 2098938.53683 | 37.7434651446005 | -122.43167307734899 | (37.7434651446005, -122.431673077349) | |||
157489 | 157489 | 179290 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002318.3672 | 2094465.3447 | 37.7311342306478 | -122.43431336098601 | (37.7311342306478, -122.434313360986) | |||
160986 | 160986 | 240145 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1209 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998178.05243 | 2106154.45126 | 37.7629937870534 | -122.44946901220301 | (37.7629937870534, -122.449469012203) | |||
161356 | 161356 | 179312 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 407 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6006926.51281 | 2092590.5645700002 | 37.726246975603 | -122.41824928748001 | (37.726246975603, -122.41824928748) | |||
166360 | 166360 | 179310 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 433 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6006956.6621199995 | 2092492.35946 | 37.725979022613295 | -122.41813810341101 | (37.7259790226133, -122.418138103411) | |||
166740 | 166740 | 239355 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 117 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6005097.05649 | 2098708.2685700003 | 37.7429416735155 | -122.425008707103 | (37.7429416735155, -122.425008707103) | |||
169247 | 169247 | 239359 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6003915.03036 | 2100651.96891 | 37.7482117843565 | -122.42923439386699 | (37.7482117843565, -122.429234393867) | |||
169324 | 169324 | 118185 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 435 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5985597.25903 | 2112945.4232900003 | 37.7809121598048 | -122.493481422073 | (37.7809121598048, -122.493481422073) | |||
169456 | 169456 | 136189 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6002539.896000001 | 2118184.5507 | 37.7962739719132 | -122.435243443451 | (37.7962739719132, -122.435243443451) | |||
171759 | 171759 | 240146 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1217 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998179.2817400005 | 2106131.69521 | 37.7629313749956 | -122.449463120725 | (37.7629313749956, -122.449463120725) | |||
174223 | 174223 | 179286 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002271.23579 | 2094443.82332 | 37.7310724625286 | -122.43447476411801 | (37.7310724625286, -122.434474764118) | |||
174826 | 174826 | 213987 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 6 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5996535.27353 | 2089022.9105 | 37.7158606459376 | -122.45391352290599 | (37.7158606459376, -122.453913522906) | |||
175096 | 175096 | 239364 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3995 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003953.0649 | 2100692.52563 | 37.7483252967888 | -122.429105762915 | (37.7483252967888, -122.429105762915) | |||
176770 | 176770 | 239360 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6003913.69662 | 2100667.88359 | 37.7482554068595 | -122.429240140544 | (37.7482554068595, -122.429240140544) | |||
178942 | 178942 | 239347 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 527 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6003128.434719999 | 2098886.3113700002 | 37.7433191387728 | -122.431828363289 | (37.7433191387728, -122.431828363289) | |||
179989 | 179989 | 136255 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1422 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6006750.35587 | 2118407.27559 | 37.797123718848 | -122.42069017253999 | (37.797123718848, -122.42069017254) | |||
180134 | 180134 | 240152 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1520 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998350.81999 | 2105225.15153 | 37.7604520448521 | -122.448804531031 | (37.7604520448521, -122.448804531031) | |||
182525 | 182525 | 179291 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 65 Badger St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002393.53271 | 2094418.30005 | 37.731009322903 | -122.434050139316 | (37.731009322903, -122.434050139316) | |||
182814 | 182814 | 240185 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 42 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001017.63107 | 2106166.1197099998 | 37.76318785445999 | -122.439648742804 | (37.76318785446, -122.439648742804) | |||
183076 | 183076 | 179287 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002285.23223 | 2094449.03286 | 37.7310875612396 | -122.43442674840799 | (37.7310875612396, -122.434426748408) |
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");