superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where ACCESS_TYP = 3 and LAYER = 5 sorted by PARK_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, AGNCY_WEB
MNG_AGENCY 14
- California Department of Water Resources 11
- California Department of Transportation 5
- California Department of General Services 3
- University of California 3
- California Department of Forestry and Fire Protection 2
- California Wildlife Conservation Board 2
- California State Lands Commission 1
- Other State 1
- Napa Valley College 1
- San Diego State University 1
- Coachella Valley Mountains Conservancy 1
- California State University 1
- California State Coastal Conservancy 1
- California Tahoe Conservancy 1
MNG_AG_TYP 1
- State Agency 34
ACCESS_TYP 1
- No Public Access · 34 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME ▼ | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1079 | 1079 | 1078 | {"type": "Polygon", "coordinates": [[[-122.27901, 38.29895], [-122.27868, 38.299], [-122.27861, 38.29876], [-122.27894, 38.2987], [-122.27901, 38.29895]]]} | No Public Access 3 | 575 Third St | 15206 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 0.209 | 575 Third St | ||
4333 | 4333 | 4332 | {"type": "Polygon", "coordinates": [[[-117.00555, 32.56116], [-117.00554, 32.56472], [-117.00446, 32.56471], [-117.00445, 32.56601], [-117.00443, 32.56603], [-117.00418, 32.566], [-117.004, 32.56588], [-117.00338, 32.56582], [-117.00337, 32.56469], [-117.00123, 32.56466], [-117.00126, 32.56109], [-117.00555, 32.56116]]]} | No Public Access 3 | Anderprises TransNet Environmental Mitigation | 32283 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 42.9 | Anderprises TransNet Environmental Mitigation | ||
1605 | 1605 | 1604 | {"type": "Polygon", "coordinates": [[[-120.12173, 36.2483], [-120.12148, 36.2483], [-120.12146, 36.24807], [-120.10458, 36.24812], [-120.10456, 36.24822], [-120.10395, 36.24822], [-120.10393, 36.2482], [-120.10338, 36.24816], [-120.10321, 36.24807], [-120.08575, 36.24814], [-120.08572, 36.25219], [-120.08397, 36.25081], [-120.08324, 36.25055], [-120.08275, 36.25016], [-120.08242, 36.2498], [-120.07876, 36.24666], [-120.07738, 36.24531], [-120.07628, 36.2438], [-120.07409, 36.24039], [-120.07219, 36.23723], [-120.06988, 36.23366], [-120.06783, 36.23367], [-120.06783, 36.23047], [-120.06518, 36.22639], [-120.0612, 36.22003], [-120.05967, 36.22059], [-120.05947, 36.22022], [-120.06105, 36.2196], [-120.06106, 36.21958], [-120.05979, 36.21789], [-120.05716, 36.21086], [-120.05712, 36.21066], [-120.05696, 36.21019], [-120.05185, 36.1961], [-120.05042, 36.19239], [-120.04902, 36.18884], [-120.0482, 36.18882], [-120.0484, 36.18167], [-120.05002, 36.18159], [-120.05751, 36.18176], [-120.05747, 36.18776], [-120.05533, 36.18777], [-120.05526, 36.18884], [-120.05086, 36.18883], [-120.05085, 36.18885], [-120.05226, 36.19238], [-120.05722, 36.19239], [-120.05722, 36.196], [-120.05384, 36.19606], [-120.05383, 36.19608], [-120.05892, 36.21035], [-120.05941, 36.21066], [-120.06768, 36.21071], [-120.06771, 36.21711], [-120.08038, 36.21218], [-120.08246, 36.21139], [-120.08563, 36.21136], [-120.08583, 36.22637], [-120.091, 36.22637], [-120.10353, 36.22642], [-120.12169, 36.22629], [-120.12169, 36.2408], [-120.12173, 36.2483]]]} | No Public Access 3 | Arroyo Pasajero Westside Detention Basin | 15624 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 3820.213 | Arroyo Pasajero Westside Detention Basin | ||
13620 | 13620 | 13619 | {"type": "Polygon", "coordinates": [[[-117.30505, 33.97199], [-117.30066, 33.97196], [-117.30065, 33.97556], [-117.29645, 33.97552], [-117.2965, 33.96463], [-117.30083, 33.96465], [-117.30087, 33.96814], [-117.30505, 33.96813], [-117.30505, 33.97199]]]} | No Public Access 3 | Box Springs Reserve | http://www.ucnrs.org/reserves/box-springs-reserve.html | 31388 | 217 | University of California 51 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 159.883 | Box Springs Reserve | |
13839 | 13839 | 13838 | {"type": "Polygon", "coordinates": [[[-116.45768, 34.14968], [-116.45335, 34.1497], [-116.45333, 34.15015], [-116.45115, 34.15016], [-116.45114, 34.14929], [-116.44898, 34.1493], [-116.44892, 34.13524], [-116.45764, 34.13534], [-116.45767, 34.14247], [-116.45768, 34.14968]], [[-116.45762, 34.14812], [-116.45761, 34.14811], [-116.45654, 34.14811], [-116.45653, 34.14608], [-116.45332, 34.1461], [-116.45334, 34.147], [-116.45654, 34.14833], [-116.4576, 34.14833], [-116.45762, 34.14812]]]} | No Public Access 3 | Burns Piñon Ridge Reserve | http://www.ucnrs.org/reserves/burns-pinon-ridge-reserve.html | 31389 | 217 | University of California 51 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 304.485 | Burns Piñon Ridge Reserve | |
2523 | 2523 | 2522 | {"type": "Polygon", "coordinates": [[[-122.53034, 38.61119], [-122.52573, 38.61122], [-122.52574, 38.61484], [-122.52112, 38.61486], [-122.52091, 38.61402], [-122.52089, 38.61401], [-122.52101, 38.61821], [-122.51659, 38.61803], [-122.51647, 38.6144], [-122.51625, 38.60714], [-122.52067, 38.60732], [-122.52401, 38.60734], [-122.53031, 38.60743], [-122.53034, 38.61119]]]} | No Public Access 3 | California State Lands Commission | 16723 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 245.304 | SLC | ||
3276 | 3276 | 3275 | {"type": "Polygon", "coordinates": [[[-117.05061, 34.06564], [-117.05016, 34.06761], [-117.04942, 34.06795], [-117.04771, 34.06692], [-117.04766, 34.06428], [-117.04902, 34.06452], [-117.05061, 34.06564]]]} | No Public Access 3 | Crafton Hills Reservoir | 17748 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 19.389 | Crafton Hills Reservoir | ||
3758 | 3758 | 3757 | {"type": "Polygon", "coordinates": [[[-121.70681, 38.27679], [-121.69559, 38.279], [-121.69594, 38.27864], [-121.69605, 38.27822], [-121.69594, 38.27777], [-121.69591, 38.27776], [-121.69526, 38.27319], [-121.69496, 38.27168], [-121.6945, 38.26631], [-121.69503, 38.266], [-121.69541, 38.26585], [-121.69632, 38.26585], [-121.69693, 38.26661], [-121.69714, 38.2671], [-121.69799, 38.2678], [-121.69895, 38.26831], [-121.69965, 38.26846], [-121.69988, 38.26865], [-121.70056, 38.26926], [-121.70453, 38.27349], [-121.70503, 38.27408], [-121.70574, 38.27512], [-121.70586, 38.27551], [-121.70622, 38.27614], [-121.70681, 38.27679]]]} | No Public Access 3 | DWR Mitigation | 18327 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 213.261 | DWR Mitigation | ||
3407 | 3407 | 3406 | {"type": "Polygon", "coordinates": [[[-122.46839, 38.40869], [-122.46606, 38.40871], [-122.46603, 38.40487], [-122.46579, 38.40181], [-122.46609, 38.40194], [-122.46628, 38.402], [-122.46661, 38.40209], [-122.46676, 38.4021], [-122.4669, 38.40215], [-122.46726, 38.40233], [-122.4675, 38.40235], [-122.46761, 38.40231], [-122.46771, 38.40225], [-122.46801, 38.40199], [-122.46819, 38.40193], [-122.46832, 38.40179], [-122.46839, 38.40869]]]} | No Public Access 3 | Dale Peters Clyde | 17895 | 223 | Napa Valley College 263 | State 5 | State Agency 5 | http://www.napavalley.edu/ | Other State 5 | 37.393 | Dale Peters Clyde | ||
3529 | 3529 | 3528 | {"type": "Polygon", "coordinates": [[[-124.18903, 40.79066], [-124.18902, 40.79082], [-124.18514, 40.7908], [-124.1852, 40.79064], [-124.18903, 40.79066]]]} | No Public Access 3 | Del Norte Street Pier | 18042 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 1.467 | Del Norte Street Pier | ||
3572 | 3572 | 3571 | {"type": "Polygon", "coordinates": [[[-122.22476, 38.22438], [-122.22475, 38.22525], [-122.2237, 38.22526], [-122.2237, 38.22472], [-122.22307, 38.22433], [-122.2222, 38.22245], [-122.22221, 38.22188], [-122.22324, 38.22127], [-122.22322, 38.22152], [-122.22316, 38.22152], [-122.22316, 38.22161], [-122.22261, 38.22185], [-122.22242, 38.2221], [-122.22241, 38.22244], [-122.22307, 38.22385], [-122.22384, 38.22431], [-122.22415, 38.22431], [-122.22452, 38.22437], [-122.22476, 38.22438]]]} | No Public Access 3 | Department Of Water Resourses | 18099 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 4.799 | Department Of Water Resourses | ||
3570 | 3570 | 3569 | {"type": "MultiPolygon", "coordinates": [[[[-122.29969, 38.27466], [-122.29947, 38.27466], [-122.29946, 38.27356], [-122.29948, 38.27356], [-122.29969, 38.27466]]], [[[-122.46397, 38.50119], [-122.46394, 38.50121], [-122.46301, 38.50039], [-122.46304, 38.50037], [-122.46397, 38.50119]]]]} | No Public Access 3 | Department of Transportation | 18097 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 0.423 | Department of Transportation | ||
3576 | 3576 | 3575 | {"type": "Polygon", "coordinates": [[[-122.25654, 38.2078], [-122.25633, 38.20788], [-122.2563, 38.20749], [-122.2564, 38.20753], [-122.25652, 38.20754], [-122.25654, 38.2078]]]} | No Public Access 3 | Dept Of Transportation/Paul Kenny | 18103 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 0.163 | Dept Of Transportation/Paul Kenny | ||
3747 | 3747 | 3746 | {"type": "Polygon", "coordinates": [[[-121.69523, 37.99864], [-121.69516, 37.99875], [-121.69492, 37.99898], [-121.69489, 37.99899], [-121.69479, 37.99908], [-121.6946, 37.99933], [-121.69451, 37.99949], [-121.69412, 38.00034], [-121.69357, 38.00137], [-121.69349, 38.00155], [-121.69341, 38.00178], [-121.69332, 38.00199], [-121.69256, 38.00334], [-121.69235, 38.00375], [-121.69214, 38.00408], [-121.69172, 38.00498], [-121.69157, 38.0052], [-121.6915, 38.00533], [-121.69134, 38.00615], [-121.6913, 38.00678], [-121.69131, 38.00698], [-121.69117, 38.00802], [-121.69114, 38.00835], [-121.69102, 38.00912], [-121.691, 38.00932], [-121.69101, 38.01008], [-121.69106, 38.01024], [-121.69104, 38.01035], [-121.69121, 38.01057], [-121.69102, 38.01082], [-121.69092, 38.01111], [-121.6909, 38.01129], [-121.69083, 38.01153], [-121.69057, 38.01168], [-121.69041, 38.01184], [-121.69042, 38.01202], [-121.69037, 38.01241], [-121.68974, 38.01329], [-121.68931, 38.01338], [-121.68885, 38.01329], [-121.68808, 38.0132], [-121.68616, 38.01353], [-121.68476, 38.01351], [-121.68233, 38.012], [-121.6797, 38.01151], [-121.6779, 38.01073], [-121.67466, 38.01191], [-121.6744, 38.01196], [-121.67438, 38.01228], [-121.66372, 38.01239], [-121.66372, 38.01234], [-121.66361, 38.01228], [-121.66332, 38.01219], [-121.66305, 38.01222], [-121.66269, 38.0124], [-121.66098, 38.01241], [-121.66075, 38.01191], [-121.66066, 38.01165], [-121.6605, 38.0114], [-121.65932, 38.0089], [-121.65922, 38.00863], [-121.65914, 38.00835], [-121.65911, 38.00795], [-121.65919, 37.99845], [-121.66012, 37.99845], [-121.66014, 37.99792], [-121.66012, 37.9979], [-121.6592, 37.9979], [-121.65925, 37.99124], [-121.66028, 37.99208], [-121.66047, 37.99221], [-121.66068, 37.99233], [-121.6609, 37.99243], [-121.66357, 37.99352], [-121.66415, 37.99377], [-121.67363, 37.99756], [-121.67366, 37.99754], [-121.67405, 37.99767], [-121.67431, 37.99772], [-121.67459, 37.99775], [-121.6759, 37.99776], [-121.67585, 37.99946], [-121.67687, 38.0005], [-121.67805, 38.00051], [-121.67798, 38.00067], [-121.67805, 38.00087], [-121.67806, 38.00179], [-121.67965, 38.00178], [-121.67966, 38.00051], [-121.68253, 38.00051], [-121.68379, 38.0001], [-121.68381, 37.99788], [-121.68397, 37.99792], [-121.6859, 37.99855], [-121.6862, 37.99862], [-121.68641, 37.99865], [-121.68662, 37.99866], [-121.69523, 37.99864]]]} | No Public Access 3 | Dutch Slough | 18320 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 1185.223 | Dutch Slough | ||
3865 | 3865 | 3864 | {"type": "MultiPolygon", "coordinates": [[[[-116.44947, 33.88499], [-116.44723, 33.88499], [-116.44529, 33.88496], [-116.4457, 33.88489], [-116.44596, 33.88482], [-116.44707, 33.88443], [-116.44732, 33.88435], [-116.44773, 33.88427], [-116.44824, 33.8842], [-116.44946, 33.88418], [-116.44947, 33.88499]]], [[[-116.46255, 33.8886], [-116.46251, 33.89218], [-116.45813, 33.89218], [-116.45819, 33.88861], [-116.46255, 33.8886]]], [[[-116.47394, 33.88857], [-116.47122, 33.88857], [-116.47122, 33.88785], [-116.47129, 33.88596], [-116.47394, 33.88857]]], [[[-116.47988, 33.89224], [-116.47985, 33.89496], [-116.47554, 33.89498], [-116.47555, 33.89223], [-116.47988, 33.89224]]]]} | No Public Access 3 | Edom Hill-Willow Hole Preserve | 18453 | 214 | Coachella Valley Mountains Conservancy 748 | State 5 | State Agency 5 | http://www.cvmc.ca.gov/ | Other State 5 | 84.172 | Edom Hill-Willow Hole Preserve | ||
13254 | 13254 | 13253 | {"type": "Polygon", "coordinates": [[[-121.41367, 38.23999], [-121.41393, 38.24073], [-121.41403, 38.24115], [-121.41401, 38.24182], [-121.41387, 38.2422], [-121.41372, 38.24252], [-121.41349, 38.24274], [-121.4134, 38.24305], [-121.41338, 38.24337], [-121.41318, 38.24429], [-121.41301, 38.24479], [-121.41253, 38.2454], [-121.41205, 38.2458], [-121.41183, 38.24594], [-121.41149, 38.2461], [-121.41107, 38.24659], [-121.41077, 38.24686], [-121.41051, 38.24724], [-121.41014, 38.24789], [-121.40986, 38.24824], [-121.4098, 38.24835], [-121.40967, 38.24845], [-121.40943, 38.24856], [-121.40929, 38.24867], [-121.40924, 38.24878], [-121.40917, 38.24913], [-121.40828, 38.25009], [-121.40789, 38.25041], [-121.40766, 38.25056], [-121.40722, 38.25103], [-121.40677, 38.25159], [-121.40616, 38.25214], [-121.40585, 38.25266], [-121.40583, 38.25277], [-121.40585, 38.25291], [-121.40612, 38.25307], [-121.40671, 38.25329], [-121.4067, 38.25337], [-121.4064, 38.25349], [-121.40605, 38.25369], [-121.40588, 38.2538], [-121.4057, 38.25401], [-121.40568, 38.25411], [-121.40595, 38.25412], [-121.40522, 38.25423], [-121.40433, 38.25417], [-121.4041, 38.25411], [-121.40216, 38.2541], [-121.40127, 38.25383], [-121.40146, 38.25112], [-121.40144, 38.25103], [-121.40136, 38.25096], [-121.40126, 38.25093], [-121.39906, 38.25089], [-121.39863, 38.25068], [-121.3983, 38.25048], [-121.39765, 38.24996], [-121.39734, 38.24974], [-121.39617, 38.24779], [-121.39663, 38.24661], [-121.39638, 38.24624], [-121.39618, 38.24599], [-121.39563, 38.24543], [-121.39533, 38.24509], [-121.39504, 38.24486], [-121.39473, 38.24467], [-121.39269, 38.24467], [-121.39251, 38.2447], [-121.39178, 38.24494], [-121.39059, 38.24485], [-121.39026, 38.24475], [-121.38955, 38.24426], [-121.38627, 38.24134], [-121.38819, 38.24132], [-121.3925, 38.24131], [-121.39949, 38.24126], [-121.39985, 38.24123], [-121.40024, 38.24113], [-121.40047, 38.24103], [-121.40227, 38.2402], [-121.40258, 38.24009], [-121.40298, 38.24003], [-121.41367, 38.23999]]]} | No Public Access 3 | Grizzly Slough | 30567 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 487.053 | Grizzly Slough | ||
4860 | 4860 | 4859 | {"type": "Polygon", "coordinates": [[[-122.52495, 38.06971], [-122.52293, 38.06978], [-122.52096, 38.07133], [-122.51104, 38.06343], [-122.5006, 38.06098], [-122.49657, 38.06008], [-122.49222, 38.05907], [-122.49669, 38.05127], [-122.498, 38.04907], [-122.49842, 38.0494], [-122.49892, 38.04861], [-122.4989, 38.04859], [-122.49831, 38.04855], [-122.49847, 38.04828], [-122.49848, 38.04785], [-122.50667, 38.04784], [-122.50668, 38.04742], [-122.50731, 38.04741], [-122.50732, 38.0474], [-122.50668, 38.04689], [-122.50851, 38.04693], [-122.50972, 38.04814], [-122.51013, 38.04801], [-122.51102, 38.04913], [-122.51148, 38.05001], [-122.51052, 38.05012], [-122.51044, 38.05017], [-122.5105, 38.05049], [-122.50943, 38.05062], [-122.50805, 38.05113], [-122.50669, 38.0522], [-122.50669, 38.05222], [-122.5098, 38.05469], [-122.51448, 38.06081], [-122.51477, 38.06197], [-122.51638, 38.06325], [-122.51678, 38.06343], [-122.51743, 38.06392], [-122.51755, 38.06389], [-122.51761, 38.06395], [-122.5176, 38.06405], [-122.51799, 38.06436], [-122.51828, 38.06465], [-122.51843, 38.0647], [-122.51859, 38.06467], [-122.52495, 38.06971]]]} | No Public Access 3 | Hamilton Wetlands | 19625 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 632.984 | Hamilton Wetlands | ||
13239 | 13239 | 13238 | {"type": "Polygon", "coordinates": [[[-121.52015, 38.36105], [-121.52, 38.36138], [-121.51988, 38.36172], [-121.51976, 38.36228], [-121.51967, 38.36299], [-121.51968, 38.36373], [-121.51983, 38.36443], [-121.51986, 38.3652], [-121.51994, 38.36596], [-121.52002, 38.3666], [-121.51995, 38.36694], [-121.51977, 38.3671], [-121.51892, 38.36686], [-121.51857, 38.36669], [-121.51813, 38.36655], [-121.51157, 38.3651], [-121.51168, 38.35783], [-121.51938, 38.36011], [-121.51902, 38.36077], [-121.52015, 38.36105]]]} | No Public Access 3 | Hood Test Facilities | 30565 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 136.964 | Hood Test Facilities | ||
5787 | 5787 | 5786 | {"type": "Polygon", "coordinates": [[[-116.74116, 32.57636], [-116.74114, 32.58363], [-116.73714, 32.58342], [-116.73291, 32.5834], [-116.73278, 32.58732], [-116.72048, 32.58718], [-116.72045, 32.58913], [-116.70751, 32.5894], [-116.69094, 32.5893], [-116.69082, 32.58084], [-116.69077, 32.57124], [-116.73696, 32.56738], [-116.73704, 32.56906], [-116.74116, 32.5691], [-116.74116, 32.5727], [-116.73707, 32.57263], [-116.73709, 32.57623], [-116.74116, 32.57636]]]} | No Public Access 3 | Kuchamaa Experimental Forest | 20729 | 202 | California Department of Forestry and Fire Protection 343 | State 5 | State Agency 5 | http://www.fire.ca.gov/ | Other State 5 | 2363.81 | Kuchamaa Experimental Forest | ||
6024 | 6024 | 6023 | {"type": "Polygon", "coordinates": [[[-122.42431, 38.57076], [-122.40797, 38.56535], [-122.40763, 38.56593], [-122.40441, 38.56433], [-122.40436, 38.56388], [-122.39965, 38.56388], [-122.39938, 38.56003], [-122.39765, 38.56007], [-122.39459, 38.56008], [-122.3945, 38.55878], [-122.3939, 38.55243], [-122.38916, 38.55225], [-122.38901, 38.54848], [-122.39374, 38.54861], [-122.40827, 38.54845], [-122.40883, 38.55601], [-122.41284, 38.55633], [-122.41247, 38.55706], [-122.41819, 38.55884], [-122.41876, 38.55979], [-122.4195, 38.56112], [-122.42027, 38.56235], [-122.4221, 38.56629], [-122.42372, 38.56906], [-122.42377, 38.56909], [-122.42384, 38.56927], [-122.4243, 38.57012], [-122.42431, 38.57076]]]} | No Public Access 3 | Las Posadas State Forest | 21064 | 202 | California Department of Forestry and Fire Protection 343 | State 5 | State Agency 5 | http://www.fire.ca.gov/ | Other State 5 | 843.093 | Las Posadas State Forest |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);