units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
323 rows where COUNTY = 35 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, YR_EST, GAP_STS
MNG_AGENCY 30
- Roseville, City of 130
- Rocklin, City of 56
- Placer, County of 28
- Lincoln, City of 23
- California Department of Parks and Recreation 13
- Auburn Area Recreation and Park District 11
- Auburn, City of 11
- United States Forest Service 7
- Tahoe City Public Utilities District 6
- Truckee Donner Land Trust 6
- Loomis, Town of 5
- Placer Land Trust 3
- North Tahoe Public Utilities District 3
- United States Bureau of Land Management 2
- California Department of Fish and Wildlife 2
- Johnson Ranch Community Association 2
- Nevada Irrigation District 2
- California State Lands Commission 1
- Other State 1
- United States Army Corps of Engineers 1
- Other Federal 1
- American River Conservancy 1
- Truckee Tahoe Airport District 1
- North Fork Association 1
- Sun City Lincoln Hills Community Association 1
- Lake Tahoe Park Association 1
- Placer Legacy 1
- Colfax, City of 1
- California Tahoe Conservancy 1
- Winchester Owners Association 1
DES_TP >30
- Local Park 157
- Local Other or Unknown 80
- Local Recreation Area 19
- Private Conservation 12
- State Recreation Area 9
- Local Conservation Area 5
- Private Recreation or Education 5
- National Forest 4
- State Park 4
- Recreation Management Area 3
- State Other or Unknown 2
- National Public Lands 1
- State Conservation Area 1
- State Resource Management Area 1
- Federal Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 12
ACCESS_TYP 3
- Open Access 291
- Restricted Access 16
- No Public Access 16
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST ▼ | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2641 | 2641 | 2640 | {"type": "Polygon", "coordinates": [[[-121.3441, 38.77738], [-121.34408, 38.77766], [-121.34393, 38.77766], [-121.34396, 38.77738], [-121.3441, 38.77738]]]} | Open Access 1 | 20860 | Diamond Oaks | 18143 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.102 | Diamond Oaks | None 218 | |||
3105 | 3105 | 3104 | {"type": "Polygon", "coordinates": [[[-121.07628, 38.89266], [-121.07612, 38.89269], [-121.07591, 38.89206], [-121.07581, 38.89192], [-121.07522, 38.89193], [-121.07519, 38.89128], [-121.07542, 38.89125], [-121.07618, 38.89131], [-121.07614, 38.89251], [-121.07628, 38.89266]]]} | Open Access 1 | 21440 | Bernhard House | 16030 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 1.81 | Bernhard House | None 254 | |||
4155 | 4155 | 4154 | {"type": "Polygon", "coordinates": [[[-120.4371, 39.25133], [-120.43698, 39.25857], [-120.41847, 39.25868], [-120.41863, 39.25142], [-120.42787, 39.25136], [-120.4371, 39.25133]]]} | Open Access 1 | 44724 | Devil's Peak | 14015 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | Placer 35 | 317.682 | Devil's Peak | None 359 | |||
4621 | 4621 | 4620 | {"type": "Polygon", "coordinates": [[[-121.07477, 38.99285], [-121.07367, 38.9929], [-121.07067, 38.99298], [-121.07064, 38.98937], [-121.07472, 38.98924], [-121.07477, 38.99285]]]} | Open Access 1 | 36160 | Other State 31 | 23259 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Placer 35 | 35.203 | Other State 31 | None 402 | ||||
6414 | 6414 | 6413 | {"type": "Polygon", "coordinates": [[[-121.08079, 38.90513], [-121.08065, 38.9053], [-121.08045, 38.90543], [-121.08021, 38.90551], [-121.07995, 38.90554], [-121.07996, 38.90466], [-121.08079, 38.90502], [-121.08079, 38.90513]]]} | Open Access 1 | 47531 | Auburn Library Garden Theater | 31236 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks/parks-content/parks/auburn-garden-theater | Placer 35 | 1.153 | Auburn Library Garden Theater | None 521 | ||
10052 | 10052 | 10051 | {"type": "Polygon", "coordinates": [[[-121.2806, 38.8345], [-121.2806, 38.83473], [-121.28056, 38.83502], [-121.28025, 38.83498], [-121.28023, 38.83503], [-121.2799, 38.83498], [-121.27959, 38.83491], [-121.27928, 38.83482], [-121.27948, 38.83453], [-121.27856, 38.83415], [-121.27835, 38.83443], [-121.27754, 38.83414], [-121.27771, 38.83382], [-121.27721, 38.83365], [-121.27696, 38.83359], [-121.27685, 38.83363], [-121.27616, 38.8336], [-121.27605, 38.83389], [-121.2758, 38.83384], [-121.27561, 38.8339], [-121.27557, 38.83384], [-121.27549, 38.8338], [-121.27557, 38.83355], [-121.27553, 38.8335], [-121.27455, 38.83342], [-121.27431, 38.83343], [-121.27408, 38.83347], [-121.27385, 38.83353], [-121.27315, 38.83378], [-121.27279, 38.83383], [-121.27279, 38.83413], [-121.27239, 38.83417], [-121.2703, 38.83454], [-121.27029, 38.8345], [-121.27092, 38.83433], [-121.27114, 38.83421], [-121.27181, 38.83408], [-121.27269, 38.8337], [-121.27304, 38.83368], [-121.27321, 38.83342], [-121.27367, 38.83342], [-121.27472, 38.83329], [-121.2752, 38.83321], [-121.27569, 38.83345], [-121.27759, 38.83348], [-121.27893, 38.83392], [-121.28017, 38.83423], [-121.28034, 38.83441], [-121.28052, 38.83452], [-121.2806, 38.8345]]]} | Open Access 1 | 49027 | Pernu Park Trails | 33728 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 7.897 | Pernu Park Trails | None 868 | |||
10080 | 10080 | 10079 | {"type": "MultiPolygon", "coordinates": [[[[-120.15427, 39.14], [-120.15424, 39.14001], [-120.15311, 39.14001], [-120.15316, 39.13982], [-120.15318, 39.13962], [-120.15416, 39.13964], [-120.15427, 39.14]]], [[[-120.16126, 39.1384], [-120.16124, 39.13992], [-120.15447, 39.13998], [-120.15444, 39.13988], [-120.15437, 39.13959], [-120.15525, 39.13957], [-120.15526, 39.13825], [-120.16126, 39.1384]]]]} | Open Access 1 | 49031 | William Kent Campground and Beach | 33731 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | https://www.fs.usda.gov/wps/portal/fsinternet/cs/recarea?ss=110519&navtype=BROWSEBYSUBJECT&cid=FSE_003738&navid=110240000000000&pnavid=110000000000000&position=generalinfo&recid=11818&ttype=recarea&pname=William%20Kent%20Campground | Placer 35 | 24.743 | William Kent Campground and Beach | None 874 | ||
10901 | 10901 | 10900 | {"type": "Polygon", "coordinates": [[[-121.31804, 38.75775], [-121.31713, 38.75822], [-121.31682, 38.75837], [-121.31629, 38.75858], [-121.31573, 38.75875], [-121.31504, 38.75891], [-121.31443, 38.759], [-121.31396, 38.75904], [-121.31348, 38.75905], [-121.31343, 38.75904], [-121.31339, 38.759], [-121.31341, 38.75865], [-121.31345, 38.7585], [-121.3135, 38.75837], [-121.31358, 38.75823], [-121.31369, 38.75809], [-121.31397, 38.75784], [-121.31458, 38.75829], [-121.31596, 38.7574], [-121.31702, 38.75682], [-121.31804, 38.75775]]]} | Open Access 1 | 20892 | JAMES W. WANISH PARK | 20354 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 11.213 | JAMES W. WANISH PARK | None 950 | |||
10904 | 10904 | 10903 | {"type": "MultiPolygon", "coordinates": [[[[-121.29959, 38.76962], [-121.2993, 38.7698], [-121.29923, 38.76987], [-121.29918, 38.76996], [-121.29916, 38.77015], [-121.29909, 38.77023], [-121.29902, 38.77026], [-121.29895, 38.77027], [-121.29852, 38.77021], [-121.29834, 38.77026], [-121.29781, 38.77063], [-121.29753, 38.77099], [-121.29743, 38.77103], [-121.2973, 38.77105], [-121.29728, 38.77091], [-121.29738, 38.77088], [-121.29763, 38.77055], [-121.2982, 38.77014], [-121.29832, 38.77009], [-121.29848, 38.77006], [-121.29861, 38.77006], [-121.29888, 38.7701], [-121.29892, 38.7701], [-121.29896, 38.77006], [-121.29897, 38.76993], [-121.29901, 38.76983], [-121.29912, 38.76971], [-121.29946, 38.76949], [-121.29959, 38.76962]]], [[[-121.30131, 38.76977], [-121.30109, 38.7698], [-121.30087, 38.76974], [-121.30077, 38.77001], [-121.30059, 38.76995], [-121.30061, 38.7699], [-121.30055, 38.76978], [-121.30029, 38.76952], [-121.30004, 38.76946], [-121.29992, 38.76945], [-121.29981, 38.76947], [-121.29971, 38.76953], [-121.29926, 38.76909], [-121.29925, 38.76904], [-121.29938, 38.76892], [-121.2995, 38.76884], [-121.29964, 38.76879], [-121.2998, 38.76875], [-121.29992, 38.76929], [-121.30018, 38.76932], [-121.30025, 38.76925], [-121.30036, 38.76927], [-121.30039, 38.76931], [-121.30056, 38.76939], [-121.30083, 38.76944], [-121.30096, 38.76948], [-121.30126, 38.76949], [-121.30131, 38.76977]]], [[[-121.30185, 38.76993], [-121.3015, 38.76993], [-121.30142, 38.76957], [-121.30177, 38.76954], [-121.30185, 38.76993]]], [[[-121.30413, 38.77028], [-121.30379, 38.77055], [-121.30374, 38.77063], [-121.30374, 38.77072], [-121.30321, 38.77073], [-121.30284, 38.77079], [-121.30276, 38.77077], [-121.30273, 38.77074], [-121.30268, 38.77062], [-121.30253, 38.77014], [-121.3024, 38.76965], [-121.30229, 38.7691], [-121.30254, 38.76925], [-121.30251, 38.76928], [-121.30251, 38.7693], [-121.30256, 38.76932], [-121.3026, 38.76928], [-121.30314, 38.76959], [-121.30365, 38.76993], [-121.30413, 38.77028]]], [[[-121.31662, 38.77171], [-121.31619, 38.77188], [-121.31577, 38.77201], [-121.31578, 38.77177], [-121.31574, 38.77155], [-121.31561, 38.77139], [-121.31544, 38.77098], [-121.31523, 38.77076], [-121.31513, 38.77063], [-121.31501, 38.77051], [-121.31481, 38.77039], [-121.31453, 38.77035], [-121.31411, 38.77017], [-121.31393, 38.77022], [-121.31359, 38.77046], [-121.3134, 38.7704], [-121.31309, 38.76999], [-121.31309, 38.76967], [-121.31335, 38.76963], [-121.31368, 38.76973], [-121.31377, 38.76979], [-121.3139, 38.76983], [-121.3141, 38.76979], [-121.31416, 38.76971], [-121.31426, 38.76966], [-121.31466, 38.76978], [-121.31496, 38.76993], [-121.31529, 38.77021], [-121.31581, 38.77084], [-121.31587, 38.77099], [-121.3163, 38.77142], [-121.31639, 38.77154], [-121.31662, 38.77171]]], [[[-121.33001, 38.76511], [-121.32991, 38.76563], [-121.32982, 38.76636], [-121.32569, 38.76637], [-121.32568, 38.76502], [-121.32375, 38.76509], [-121.32375, 38.76473], [-121.32414, 38.76503], [-121.32558, 38.76498], [-121.32561, 38.76492], [-121.3256, 38.76477], [-121.32609, 38.76474], [-121.3261, 38.7649], [-121.32612, 38.76496], [-121.32932, 38.76485], [-121.32934, 38.76513], [-121.33001, 38.76511]]]]} | Open Access 1 | 20881 | Welands | 27335 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 26.924 | Welands | None 951 | |||
10917 | 10917 | 10916 | {"type": "Polygon", "coordinates": [[[-121.28958, 38.73527], [-121.2895, 38.73568], [-121.28937, 38.73609], [-121.28927, 38.73609], [-121.28931, 38.73527], [-121.28958, 38.73527]]]} | Open Access 1 | 20922 | SAUGSTAD PARK | 25170 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.397 | SAUGSTAD PARK | None 952 | |||
11417 | 11417 | 11416 | {"type": "Polygon", "coordinates": [[[-121.14098, 38.78809], [-121.14088, 38.78839], [-121.14077, 38.78865], [-121.14032, 38.7885], [-121.14058, 38.78796], [-121.14065, 38.78802], [-121.14098, 38.78809]]]} | Open Access 1 | 22228 | Placer | 23762 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 0.628 | Placer | None 1009 | |||
12643 | 12643 | 12642 | {"type": "Polygon", "coordinates": [[[-121.22468, 38.76733], [-121.22222, 38.76843], [-121.22123, 38.7689], [-121.22088, 38.7691], [-121.22075, 38.76896], [-121.22106, 38.76875], [-121.2214, 38.76847], [-121.22171, 38.76816], [-121.22193, 38.76789], [-121.22212, 38.7676], [-121.22231, 38.76724], [-121.22242, 38.76693], [-121.22251, 38.76659], [-121.2246, 38.76659], [-121.22461, 38.7671], [-121.22468, 38.76733]]]} | Open Access 1 | 29471 | Welands | 27335 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 8.755 | Welands | None 1096 | |||
13067 | 13067 | 13066 | {"type": "MultiPolygon", "coordinates": [[[[-120.11204, 39.18469], [-120.11175, 39.18479], [-120.11195, 39.18517], [-120.11053, 39.18564], [-120.11053, 39.18732], [-120.10893, 39.18731], [-120.10892, 39.18738], [-120.10783, 39.18743], [-120.10791, 39.18368], [-120.10919, 39.18328], [-120.10947, 39.18378], [-120.11025, 39.18353], [-120.11056, 39.18408], [-120.11153, 39.18376], [-120.11204, 39.18469]]], [[[-120.11717, 39.18101], [-120.11706, 39.18367], [-120.11653, 39.18367], [-120.11661, 39.18202], [-120.11608, 39.182], [-120.11613, 39.18078], [-120.1164, 39.18079], [-120.11666, 39.18083], [-120.11675, 39.18085], [-120.11717, 39.18101]]]]} | Open Access 1 | 34943 | TSRA Outliers - Skylandia | 26556 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2260 | Tahoe City Public Utilities District 658 | Special District 4 | Water District 13 | Placer 35 | 33.462 | TSRA Outliers - Skylandia | None 1133 | |||
14463 | 14463 | 14462 | {"type": "Polygon", "coordinates": [[[-121.17924, 38.82165], [-121.17897, 38.82199], [-121.17788, 38.82204], [-121.17754, 38.82218], [-121.17709, 38.82256], [-121.17663, 38.82287], [-121.17633, 38.82297], [-121.17611, 38.82317], [-121.17596, 38.82379], [-121.17568, 38.82401], [-121.17573, 38.82444], [-121.1755, 38.8246], [-121.17504, 38.82483], [-121.17493, 38.82518], [-121.17369, 38.82519], [-121.17358, 38.82174], [-121.17323, 38.82173], [-121.17317, 38.81905], [-121.17784, 38.81901], [-121.17787, 38.82079], [-121.17785, 38.82168], [-121.17924, 38.82165]]]} | Open Access 1 | 47081 | Loomis Basin Community Park - South | 30735 | 1354 | Loomis, Town of 415 | City 2 | City Agency 2 | http://www.loomis.ca.gov/ | City 2 | 1354 | Loomis, Town of 409 | City 2 | City Agency 2 | http://www.placer.ca.gov/departments/facility/parks/parks-content/parks/loomis-basin-community-park-south | Placer 35 | 52.712 | Loomis Basin Community Park - South | None 1230 | ||
14464 | 14464 | 14463 | {"type": "Polygon", "coordinates": [[[-121.17686, 38.8261], [-121.17569, 38.82704], [-121.17568, 38.82713], [-121.17454, 38.82713], [-121.17454, 38.82638], [-121.17335, 38.82639], [-121.17424, 38.82606], [-121.17424, 38.8254], [-121.17589, 38.82539], [-121.17671, 38.82545], [-121.17686, 38.8261]]]} | Open Access 1 | 47082 | Loomis Basin Community Park - North | 30736 | 1354 | Loomis, Town of 415 | City 2 | City Agency 2 | http://www.loomis.ca.gov/ | City 2 | 1354 | Loomis, Town of 409 | City 2 | City Agency 2 | http://www.placer.ca.gov/departments/facility/parks/parks-content/parks/loomis-basin-community-park-north | Placer 35 | 8.895 | Loomis Basin Community Park - North | None 1231 | ||
14465 | 14465 | 14464 | {"type": "Polygon", "coordinates": [[[-121.1883, 38.72061], [-121.18821, 38.72077], [-121.18793, 38.72141], [-121.18783, 38.72158], [-121.18709, 38.72158], [-121.18709, 38.72083], [-121.1883, 38.72061]]]} | Open Access 1 | 47083 | Baldwin Reservoir Trailhead | 30737 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks/parks-content/trails/baldwin-reservoir-trail | Placer 35 | 1.941 | Baldwin Reservoir Trailhead | None 1232 | ||
566 | 566 | 565 | {"type": "Polygon", "coordinates": [[[-121.21475, 38.85021], [-121.21011, 38.85029], [-121.21013, 38.85379], [-121.20562, 38.85391], [-121.20569, 38.84673], [-121.21023, 38.84669], [-121.21012, 38.84946], [-121.21102, 38.84945], [-121.21472, 38.84938], [-121.21475, 38.85021]]]} | Open Access 1 | 47530 | Traylor Ranch Bird Sanctuary and Nature Reserve | 31235 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks/parks-content/parks/traylor-ranch-nature-reserve | Placer 35 | 85.371 | Traylor Ranch Bird Sanctuary and Nature Reserve | 0 | Local Conservation Area 4 | 2 |
1725 | 1725 | 1724 | {"type": "Polygon", "coordinates": [[[-121.19542, 38.82059], [-121.19429, 38.82183], [-121.19403, 38.82168], [-121.19516, 38.82045], [-121.19542, 38.82059]]]} | Open Access 1 | 49001 | Blue Anchor Park | 33700 | 1354 | Loomis, Town of 415 | City 2 | City Agency 2 | http://www.loomis.ca.gov/ | City 2 | 1354 | Loomis, Town of 409 | City 2 | City Agency 2 | https://loomis.ca.gov/how-do-i/find-2/parks-recreation/ | Placer 35 | 1.147 | Blue Anchor Park | 0 | Local Park 2 | 4 |
1917 | 1917 | 1916 | {"type": "Polygon", "coordinates": [[[-121.07745, 38.89517], [-121.07673, 38.89522], [-121.07619, 38.89551], [-121.07584, 38.8954], [-121.07647, 38.89454], [-121.07666, 38.89464], [-121.07666, 38.89501], [-121.07744, 38.89496], [-121.07745, 38.89517]]]} | Open Access 1 | 47553 | Bicentennial Park | 31270 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://www.auburnrec.com/parks_bicentennial.php | Placer 35 | 1.453 | Bicentennial Park | 0 | Local Park 2 | 4 |
1918 | 1918 | 1917 | {"type": "Polygon", "coordinates": [[[-121.37811, 38.98221], [-121.37734, 38.98263], [-121.3769, 38.98212], [-121.37695, 38.98208], [-121.37666, 38.98175], [-121.37721, 38.98145], [-121.37722, 38.98119], [-121.37811, 38.98221]]]} | Open Access 1 | 47555 | Sheridan Park | 31272 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks/parks-content/parks/sheridan-park | Placer 35 | 2.255 | Sheridan Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);