units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
256 rows where DES_TP = 8 and LAYER = 6 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID
MNG_AGENCY 3
ACCESS_TYP 3
- Open Access 195
- Restricted Access 49
- No Public Access 12
MNG_AG_TYP 1
- State Agency 256
DES_TP 1
- State Conservation Area · 256 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
213 | 213 | 212 | {"type": "Polygon", "coordinates": [[[-121.44057, 41.00434], [-121.44008, 41.00444], [-121.44004, 41.00437], [-121.43945, 41.00437], [-121.43934, 41.00404], [-121.43939, 41.00396], [-121.44023, 41.00367], [-121.44032, 41.00373], [-121.44038, 41.00381], [-121.44057, 41.00434]]]} | Open Access 1 | 663 | Fall River Mills Ecological Reserve | 32163 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Fall-River-Mills-ER | Shasta 27 | 1.448 | Fall River Mills ER | 1998 | State Conservation Area 8 | 2 |
12282 | 12282 | 12281 | {"type": "Polygon", "coordinates": [[[-120.19869, 39.31522], [-120.19868, 39.31633], [-120.19754, 39.31634], [-120.19813, 39.31576], [-120.19869, 39.31522]]]} | Open Access 1 | 25911 | Truckee River Wildlife Area | 12543 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Truckee-River-WA | Placer 35 | 1.505 | Truckee River Wildlife Area | 1996 | State Conservation Area 8 | 2 |
7537 | 7537 | 7536 | {"type": "Polygon", "coordinates": [[[-122.76295, 38.34753], [-122.76209, 38.34714], [-122.76092, 38.34616], [-122.76059, 38.34615], [-122.76022, 38.34574], [-122.76118, 38.34575], [-122.76295, 38.34753]]]} | Restricted Access 2 | 9392 | Theiller Sebastopol Meadowfoam Ecological Reserve | 26298 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sonoma 16 | 2.51 | Theiller Sebastopol Meadowfoam ER | 0 | State Conservation Area 8 | 2 | |
402 | 402 | 401 | {"type": "Polygon", "coordinates": [[[-118.76991, 36.21538], [-118.76991, 36.21538], [-118.76726, 36.21538], [-118.76735, 36.21517], [-118.76842, 36.21452], [-118.76948, 36.21436], [-118.76989, 36.21437], [-118.76991, 36.21538]]]} | Restricted Access 2 | 1556 | Springville Ecological Reserve | 25751 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Tulare 29 | 4.947 | Springville ER | 0 | State Conservation Area 8 | 2 | |
6527 | 6527 | 6526 | {"type": "Polygon", "coordinates": [[[-121.21611, 38.65634], [-121.21517, 38.65635], [-121.2144, 38.65533], [-121.21395, 38.65428], [-121.21608, 38.65427], [-121.21611, 38.65634]]]} | No Public Access 3 | 2848 | Phoenix Field Ecological Reserve | 32261 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sacramento 41 | 8.007 | Phoenix Field ER | 0 | State Conservation Area 8 | 2 | |
10777 | 10777 | 10776 | {"type": "Polygon", "coordinates": [[[-121.86483, 36.60512], [-121.86235, 36.60664], [-121.86185, 36.60613], [-121.86192, 36.60536], [-121.86232, 36.60488], [-121.86287, 36.60459], [-121.86434, 36.60427], [-121.86483, 36.60512]]]} | Restricted Access 2 | 23364 | Del Monte Dunes Ecological Reserve | 18040 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Monterey 14 | 9.592 | Del Monte Dunes ER | 0 | State Conservation Area 8 | 2 | |
7043 | 7043 | 7042 | {"type": "Polygon", "coordinates": [[[-120.45049, 34.69233], [-120.44937, 34.69162], [-120.44841, 34.69135], [-120.44665, 34.69339], [-120.44259, 34.70021], [-120.44243, 34.70013], [-120.44787, 34.69066], [-120.44845, 34.69086], [-120.44961, 34.69143], [-120.45049, 34.69233]]]} | Open Access 1 | 29179 | Burton Mesa Ecological Reserve | 32070 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Burton-Mesa-ER | Santa Barbara 7 | 10.747 | Burton Mesa ER | 2004 | State Conservation Area 8 | 2 |
15631 | 15631 | 15630 | {"type": "MultiPolygon", "coordinates": [[[[-118.42515, 33.98022], [-118.42488, 33.98042], [-118.42427, 33.98031], [-118.42454, 33.98011], [-118.42515, 33.98022]]], [[[-118.42921, 33.98035], [-118.42898, 33.98059], [-118.42873, 33.9809], [-118.42783, 33.98073], [-118.42828, 33.9807], [-118.42866, 33.98064], [-118.42887, 33.98056], [-118.42921, 33.98035]]], [[[-118.42901, 33.97746], [-118.42859, 33.97776], [-118.42826, 33.97724], [-118.42875, 33.97693], [-118.42887, 33.97722], [-118.42901, 33.97746]]], [[[-118.43285, 33.97662], [-118.43006, 33.98007], [-118.43, 33.9803], [-118.43002, 33.9806], [-118.4301, 33.98081], [-118.43018, 33.98095], [-118.43027, 33.98105], [-118.43049, 33.98123], [-118.43191, 33.9815], [-118.43208, 33.98162], [-118.43187, 33.98175], [-118.42892, 33.98119], [-118.43269, 33.97653], [-118.43285, 33.97662]], [[-118.43028, 33.98119], [-118.43029, 33.98117], [-118.43018, 33.98107], [-118.43009, 33.98096], [-118.42999, 33.98077], [-118.42993, 33.98058], [-118.42991, 33.98041], [-118.42992, 33.98028], [-118.42991, 33.98027], [-118.42941, 33.98086], [-118.42931, 33.981], [-118.43028, 33.98119]]], [[[-118.4323, 33.97539], [-118.42949, 33.97712], [-118.42928, 33.97727], [-118.42915, 33.97702], [-118.42904, 33.97676], [-118.42915, 33.97666], [-118.43197, 33.97484], [-118.4323, 33.97539]]]]} | Restricted Access 2 | 44627 | Ballona Wetlands Ecological Reserve | 15789 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Los Angeles 6 | 11.92 | Ballona Wetlands ER | 0 | State Conservation Area 8 | 2 | |
16757 | 16757 | 16756 | {"type": "Polygon", "coordinates": [[[-121.80689, 38.88866], [-121.8054, 38.89105], [-121.80515, 38.89074], [-121.80516, 38.89056], [-121.8047, 38.88988], [-121.80428, 38.88934], [-121.80363, 38.88908], [-121.80241, 38.88865], [-121.80166, 38.88837], [-121.8014, 38.88823], [-121.80146, 38.88809], [-121.80169, 38.88805], [-121.80187, 38.888], [-121.80312, 38.88824], [-121.80392, 38.88848], [-121.80462, 38.88863], [-121.80528, 38.88858], [-121.80616, 38.88858], [-121.80689, 38.88866]]]} | Restricted Access 2 | 25313 | Collins Eddy Wildlife Area | 17521 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sutter 47 | 12.4 | Collins Eddy Wildlife Area | 0 | State Conservation Area 8 | 2 | |
16787 | 16787 | 16786 | {"type": "Polygon", "coordinates": [[[-121.58877, 39.1692], [-121.58617, 39.16924], [-121.5864, 39.16725], [-121.58707, 39.16749], [-121.58709, 39.16749], [-121.58741, 39.16502], [-121.58877, 39.1692]]]} | Restricted Access 2 | 47980 | Feather River Wildlife Area | 18861 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Yuba 25 | 12.64 | Feather River Wildlife Area | 1991 | State Conservation Area 8 | 2 | |
15563 | 15563 | 15562 | {"type": "Polygon", "coordinates": [[[-122.7187, 38.86399], [-122.71867, 38.86334], [-122.71873, 38.86325], [-122.72002, 38.86389], [-122.72002, 38.86471], [-122.72031, 38.86555], [-122.72055, 38.8663], [-122.72092, 38.86613], [-122.72154, 38.86716], [-122.71933, 38.86718], [-122.71936, 38.86682], [-122.71935, 38.86664], [-122.7193, 38.86639], [-122.71919, 38.86608], [-122.7188, 38.86524], [-122.7187, 38.86399]]]} | Open Access 1 | 1765 | Loch Lomond Vernal Pool Ecological Reserve | 32205 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Loch-Lomond-Vernal-Pool-ER | Lake 40 | 12.758 | Loch Lomond Vernal Pool ER | 1993 | State Conservation Area 8 | 2 |
1522 | 1522 | 1521 | {"type": "Polygon", "coordinates": [[[-117.23496, 33.27233], [-117.23496, 33.27267], [-117.23179, 33.27604], [-117.23077, 33.27536], [-117.2336, 33.27235], [-117.23496, 33.27233]]]} | Restricted Access 2 | 12834 | San Luis Rey River Ecological Reserve | 24942 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 14.153 | San Luis Rey River ER | 0 | State Conservation Area 8 | 2 | |
5955 | 5955 | 5954 | {"type": "Polygon", "coordinates": [[[-120.98655, 37.40316], [-120.98645, 37.4037], [-120.9858, 37.40327], [-120.98326, 37.4014], [-120.98204, 37.40081], [-120.98154, 37.40063], [-120.98443, 37.39949], [-120.98456, 37.39989], [-120.98467, 37.40012], [-120.98472, 37.40027], [-120.98493, 37.40061], [-120.98501, 37.40078], [-120.98513, 37.40095], [-120.98522, 37.40114], [-120.98557, 37.40154], [-120.98567, 37.40168], [-120.98599, 37.40248], [-120.98621, 37.40281], [-120.98643, 37.40306], [-120.98655, 37.40316]]]} | Open Access 1 | 518 | West Hilmar Wildlife Area | 30516 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/West-Hilmar-WA | Stanislaus 2 | 16.656 | West Hilmar Wildlife Area | 1994 | State Conservation Area 8 | 2 |
16557 | 16557 | 16556 | {"type": "Polygon", "coordinates": [[[-122.2306, 40.38874], [-122.22987, 40.38907], [-122.22946, 40.38917], [-122.22924, 40.3892], [-122.22906, 40.38924], [-122.22887, 40.38924], [-122.22864, 40.38928], [-122.22825, 40.38928], [-122.22806, 40.38936], [-122.22743, 40.38935], [-122.22724, 40.38932], [-122.22611, 40.38921], [-122.22589, 40.38912], [-122.2257, 40.38901], [-122.22555, 40.38888], [-122.22542, 40.38868], [-122.22521, 40.38819], [-122.22507, 40.38776], [-122.23041, 40.38739], [-122.2306, 40.38874]]]} | Open Access 1 | 7678 | Mouth of Cottonwood Creek Wildlife Area | 30477 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Mouth-of-Cottonwood-Creek-WA | Tehama 18 | 19.746 | Mouth of Cottonwood Creek Wildlife Area | 1982 | State Conservation Area 8 | 2 |
6554 | 6554 | 6553 | {"type": "Polygon", "coordinates": [[[-121.58605, 38.59505], [-121.57671, 38.5975], [-121.57669, 38.59709], [-121.57651, 38.59671], [-121.58026, 38.59567], [-121.58339, 38.59485], [-121.58581, 38.59418], [-121.58605, 38.59505]]]} | Open Access 1 | 3275 | Sacramento Bypass Wildlife Area | 30493 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Sacramento-Bypass-WA | Yolo 33 | 19.773 | Sacramento Bypass Wildlife Area | 1988 | State Conservation Area 8 | 2 |
15618 | 15618 | 15617 | {"type": "Polygon", "coordinates": [[[-117.10664, 33.07422], [-117.10657, 33.07428], [-117.10628, 33.07556], [-117.10504, 33.07516], [-117.1052, 33.07405], [-117.10423, 33.07384], [-117.10423, 33.07312], [-117.10319, 33.072], [-117.10339, 33.07187], [-117.10339, 33.07186], [-117.10243, 33.0711], [-117.10269, 33.07041], [-117.10371, 33.07007], [-117.10564, 33.07143], [-117.10596, 33.07398], [-117.10664, 33.07422]]]} | Restricted Access 2 | 23594 | Lake Hodges Ecological Reserve | 20894 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 24.606 | Lake Hodges ER | 0 | State Conservation Area 8 | 2 | |
10567 | 10567 | 10566 | {"type": "MultiPolygon", "coordinates": [[[[-122.894, 39.1212], [-122.89308, 39.12185], [-122.89194, 39.12219], [-122.89128, 39.1222], [-122.89021, 39.12184], [-122.88849, 39.12032], [-122.88977, 39.12034], [-122.88992, 39.12051], [-122.89027, 39.12077], [-122.89092, 39.12103], [-122.89157, 39.1211], [-122.89231, 39.12097], [-122.89397, 39.12022], [-122.894, 39.1212]]], [[[-122.89329, 39.12034], [-122.89301, 39.12048], [-122.89198, 39.12092], [-122.89106, 39.12094], [-122.89006, 39.12042], [-122.89, 39.12032], [-122.89329, 39.12034]]], [[[-122.89936, 39.11659], [-122.89935, 39.11744], [-122.89898, 39.11734], [-122.89857, 39.11771], [-122.89813, 39.11829], [-122.89772, 39.11866], [-122.897, 39.11895], [-122.89675, 39.11917], [-122.89663, 39.11936], [-122.89628, 39.11934], [-122.89625, 39.1193], [-122.89611, 39.11918], [-122.89711, 39.1183], [-122.8978, 39.11752], [-122.89827, 39.1171], [-122.89936, 39.11659]]], [[[-122.90101, 39.12068], [-122.8989, 39.11997], [-122.8971, 39.11987], [-122.8968, 39.12012], [-122.89684, 39.11999], [-122.89671, 39.11994], [-122.89671, 39.11955], [-122.89736, 39.1196], [-122.89888, 39.1199], [-122.89976, 39.12005], [-122.90037, 39.12009], [-122.90048, 39.11993], [-122.90044, 39.11981], [-122.90052, 39.1195], [-122.901, 39.11915], [-122.90101, 39.12068]]], [[[-122.90099, 39.11847], [-122.90099, 39.11871], [-122.89992, 39.11855], [-122.89967, 39.11832], [-122.89955, 39.11808], [-122.90099, 39.11847]]]]} | Open Access 1 | 18818 | Clear Lake Wildlife Area | 30426 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Clear-Lake-WA | Lake 40 | 26.063 | Clear Lake Wildlife Area | 2004 | State Conservation Area 8 | 2 |
15608 | 15608 | 15607 | {"type": "Polygon", "coordinates": [[[-121.73917, 36.77633], [-121.73883, 36.77674], [-121.73879, 36.7767], [-121.73768, 36.77747], [-121.73567, 36.77625], [-121.7328, 36.77533], [-121.73114, 36.774], [-121.73155, 36.77394], [-121.73199, 36.77418], [-121.73246, 36.77422], [-121.73301, 36.77408], [-121.73332, 36.77373], [-121.73363, 36.7736], [-121.73394, 36.77357], [-121.73432, 36.77363], [-121.73454, 36.77375], [-121.73491, 36.77431], [-121.73498, 36.77446], [-121.73489, 36.77465], [-121.73521, 36.77482], [-121.73553, 36.77494], [-121.73565, 36.775], [-121.73578, 36.77509], [-121.73598, 36.77528], [-121.73613, 36.77533], [-121.7363, 36.77531], [-121.73711, 36.77488], [-121.73721, 36.77486], [-121.73732, 36.77487], [-121.7374, 36.77491], [-121.73745, 36.77496], [-121.73808, 36.77615], [-121.73816, 36.77625], [-121.73825, 36.77634], [-121.73838, 36.77641], [-121.73853, 36.77647], [-121.73865, 36.77654], [-121.73867, 36.77653], [-121.73805, 36.77568], [-121.7391, 36.77612], [-121.73917, 36.77633]]]} | Restricted Access 2 | 17998 | Moro Cojo Ecological Reserve | 22492 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Monterey 14 | 26.613 | Moro Cojo ER | 0 | State Conservation Area 8 | 2 | |
11250 | 11250 | 11249 | {"type": "Polygon", "coordinates": [[[-124.03457, 41.5002], [-124.03347, 41.50137], [-124.03228, 41.50308], [-124.03218, 41.50354], [-124.032, 41.50523], [-124.03178, 41.50607], [-124.03145, 41.50667], [-124.03084, 41.50734], [-124.02997, 41.50822], [-124.02922, 41.50901], [-124.02868, 41.5098], [-124.02808, 41.51081], [-124.02789, 41.51051], [-124.02779, 41.50915], [-124.02794, 41.50887], [-124.02829, 41.50848], [-124.02972, 41.50711], [-124.03017, 41.50643], [-124.03052, 41.5057], [-124.03061, 41.50508], [-124.03064, 41.50441], [-124.03086, 41.50372], [-124.03209, 41.50204], [-124.03318, 41.50091], [-124.03382, 41.50047], [-124.03457, 41.5002]]]} | Open Access 1 | 21620 | Waukell Creek Wildlife Area | 30515 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Waukell-Creek-WA | Del Norte 50 | 26.779 | Waukell Creek Wildlife Area | 1993 | State Conservation Area 8 | 2 |
16765 | 16765 | 16764 | {"type": "Polygon", "coordinates": [[[-121.67267, 38.23526], [-121.67199, 38.23538], [-121.67109, 38.23548], [-121.66964, 38.23586], [-121.66748, 38.23658], [-121.66657, 38.23705], [-121.66669, 38.23662], [-121.66671, 38.23622], [-121.66645, 38.23594], [-121.66624, 38.23551], [-121.66629, 38.23528], [-121.66642, 38.23505], [-121.66671, 38.23485], [-121.6682, 38.23457], [-121.66951, 38.23415], [-121.67, 38.2338], [-121.67045, 38.23344], [-121.67149, 38.233], [-121.67267, 38.23526]]]} | Open Access 1 | 23602 | Miner Slough Wildlife Area | 30473 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Miner-Slough-WA | Solano 26 | 27.122 | Miner Slough Wildlife Area | 1981 | State Conservation Area 8 | 2 |
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]);