superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
254 rows where ACCESS_TYP = 4 sorted by MNG_AG_LEV
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Yuba County Water Agency 48
- Mountains Recreation and Conservation Authority 35
- National Audubon Society 22
- California Department of Transportation 15
- Santa Barbara, County of 13
- San Joaquin River Parkway and Conservation Trust 8
- Sacramento, County of 7
- Riverside, County of 6
- Save the Redwoods League 5
- Santa Barbara, City of 4
- Santa Barbara Flood Control and Water Conserv. District 4
- North County Transit District 4
- Los Angeles, County of 3
- Monterey, County of 3
- Los Angeles, City of 3
- Sierra Foothill Conservancy 3
- Sacramento and San Joaquin Drainage District 3
- Wildlands Inc 3
- Northcoast Regional Land Trust 3
- Orange, County of 2
- Back Country Land Trust 2
- California Wildlife Conservation Board 2
- San Diego, City of 1
- Monterey Peninsula Regional Park District 1
- Carpinteria, City of 1
- California State Lands Commission 1
- Center for Natural Lands Management 1
- San Diego, County of 1
- Other State 1
- Dana Point, City of 1
- …
MNG_AG_TYP 14
ACCESS_TYP 1
- Unknown Access · 234 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9294 | 9294 | 9293 | {"type": "Polygon", "coordinates": [[[-119.67454, 34.43385], [-119.6741, 34.43428], [-119.67275, 34.43326], [-119.67318, 34.43286], [-119.67454, 34.43385]]]} | Unknown Access 4 | Santa Barbara holding 8 | 25050 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 2.519 | Santa Barbara holding 8 | ||
9295 | 9295 | 9294 | {"type": "Polygon", "coordinates": [[[-119.67034, 34.43903], [-119.67034, 34.4395], [-119.66917, 34.4395], [-119.66941, 34.43903], [-119.67034, 34.43903]]]} | Unknown Access 4 | Santa Barbara holding 9 | 25051 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1.233 | Santa Barbara holding 9 | ||
9334 | 9334 | 9333 | {"type": "Polygon", "coordinates": [[[-119.52773, 34.40703], [-119.52713, 34.40837], [-119.52698, 34.40879], [-119.52686, 34.40923], [-119.52678, 34.40968], [-119.52672, 34.40966], [-119.52675, 34.4094], [-119.52682, 34.40907], [-119.52689, 34.40883], [-119.52701, 34.40848], [-119.52766, 34.40701], [-119.52773, 34.40703]]]} | Unknown Access 4 | Santa Monica Creek | 25117 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 0.489 | Santa Monica Creek | ||
9563 | 9563 | 9562 | {"type": "MultiPolygon", "coordinates": [[[[-119.69069, 34.44329], [-119.69064, 34.4434], [-119.69065, 34.44355], [-119.69068, 34.44362], [-119.69097, 34.44402], [-119.69099, 34.44413], [-119.69098, 34.44422], [-119.69094, 34.4443], [-119.69087, 34.44436], [-119.69029, 34.44464], [-119.69015, 34.44481], [-119.69014, 34.44384], [-119.68972, 34.44402], [-119.68956, 34.44406], [-119.68939, 34.44408], [-119.68783, 34.44396], [-119.68772, 34.44393], [-119.6876, 34.44389], [-119.68726, 34.44363], [-119.68703, 34.44354], [-119.68683, 34.44349], [-119.68629, 34.44347], [-119.68596, 34.4434], [-119.68596, 34.44324], [-119.68632, 34.44331], [-119.6869, 34.44334], [-119.6871, 34.44338], [-119.6873, 34.44346], [-119.68745, 34.44355], [-119.68767, 34.44372], [-119.68782, 34.44378], [-119.68937, 34.44392], [-119.68964, 34.44387], [-119.69015, 34.44364], [-119.69013, 34.44286], [-119.69069, 34.44329]]], [[[-119.69482, 34.44571], [-119.69452, 34.44628], [-119.69438, 34.44643], [-119.69253, 34.44663], [-119.69154, 34.4466], [-119.69056, 34.44614], [-119.69014, 34.44596], [-119.69015, 34.44498], [-119.69037, 34.44471], [-119.69094, 34.44446], [-119.69102, 34.4444], [-119.69109, 34.44429], [-119.69113, 34.44416], [-119.6911, 34.444], [-119.6908, 34.44353], [-119.69078, 34.44345], [-119.6908, 34.44337], [-119.69144, 34.44386], [-119.69193, 34.44417], [-119.69239, 34.44438], [-119.6932, 34.44461], [-119.69391, 34.4449], [-119.69482, 34.44571]]]]} | Unknown Access 4 | Sheffield Reservoir | 25382 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 26.257 | Sheffield Reservoir | ||
9869 | 9869 | 9868 | {"type": "Polygon", "coordinates": [[[-121.72875, 38.64797], [-121.72864, 38.65335], [-121.72639, 38.65334], [-121.72638, 38.65153], [-121.71966, 38.65152], [-121.71964, 38.65159], [-121.7104, 38.65156], [-121.7105, 38.64787], [-121.72282, 38.64792], [-121.72283, 38.649], [-121.72589, 38.649], [-121.72593, 38.64795], [-121.72875, 38.64797]]]} | Unknown Access 4 | Spring Lake | 25739 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 160.736 | Spring Lake | ||
10172 | 10172 | 10171 | {"type": "Polygon", "coordinates": [[[-119.67342, 34.42333], [-119.67318, 34.42356], [-119.67274, 34.42324], [-119.67299, 34.42301], [-119.67342, 34.42333]]]} | Unknown Access 4 | Sycamore Creek | 26121 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.446 | Sycamore Creek | ||
10409 | 10409 | 10408 | {"type": "Polygon", "coordinates": [[[-118.57142, 34.12782], [-118.57142, 34.12931], [-118.56528, 34.12931], [-118.5662, 34.12783], [-118.57142, 34.12782]]]} | Unknown Access 4 | Steers Property | 28848 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 21.35 | Steers Property | ||
11219 | 11219 | 11218 | {"type": "Polygon", "coordinates": [[[-121.80876, 39.76798], [-121.80871, 39.76806], [-121.80871, 39.76814], [-121.80873, 39.76815], [-121.80863, 39.76821], [-121.80864, 39.76851], [-121.80763, 39.76852], [-121.8071, 39.76788], [-121.80738, 39.76769], [-121.8079, 39.76741], [-121.8081, 39.76735], [-121.80827, 39.76733], [-121.80829, 39.76733], [-121.8083, 39.76746], [-121.80846, 39.76763], [-121.80856, 39.76768], [-121.80866, 39.76792], [-121.80876, 39.76798]]]} | Unknown Access 4 | Wildwood Estate Preserve | 27518 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 3.111 | Wildwood Estate Preserve | ||
11551 | 11551 | 11550 | {"type": "Polygon", "coordinates": [[[-124.06854, 40.86404], [-124.0684, 40.86406], [-124.06846, 40.86466], [-124.06734, 40.86467], [-124.06703, 40.86377], [-124.06672, 40.86309], [-124.06685, 40.86302], [-124.06697, 40.86298], [-124.06725, 40.86295], [-124.06737, 40.86291], [-124.06748, 40.86283], [-124.06753, 40.86276], [-124.06754, 40.86269], [-124.06804, 40.86252], [-124.06795, 40.8623], [-124.0683, 40.86229], [-124.06839, 40.86331], [-124.06844, 40.86361], [-124.06854, 40.86404]]]} | Unknown Access 4 | Arcata Ridge Trail | 30248 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 6.435 | Arcata Ridge Trail | ||
11999 | 11999 | 11998 | {"type": "Polygon", "coordinates": [[[-118.47207, 33.99034], [-118.47192, 33.99044], [-118.47173, 33.99025], [-118.47189, 33.99014], [-118.47207, 33.99034]]]} | Unknown Access 4 | San Juan Garage | 28845 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.124 | San Juan Garage | ||
12087 | 12087 | 12086 | {"type": "Polygon", "coordinates": [[[-124.10344, 40.4928], [-124.10326, 40.49301], [-124.10325, 40.49313], [-124.10297, 40.49313], [-124.10296, 40.49296], [-124.103, 40.49297], [-124.10313, 40.4928], [-124.10344, 40.4928]]]} | Unknown Access 4 | Unnamed site - Rio Dell, City of | 30545 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 0.236 | |||
14330 | 14330 | 14329 | {"type": "Polygon", "coordinates": [[[-118.28418, 34.23377], [-118.28386, 34.23376], [-118.28045, 34.23393], [-118.27981, 34.23393], [-118.27975, 34.22908], [-118.27539, 34.22911], [-118.27538, 34.22816], [-118.28411, 34.2281], [-118.28418, 34.23377]]]} | Unknown Access 4 | Unnamed site - Los Angeles, City of | 29809 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 73.678 | |||
14637 | 14637 | 14636 | {"type": "MultiPolygon", "coordinates": [[[[-121.75791, 36.68606], [-121.75595, 36.68696], [-121.75593, 36.68608], [-121.75451, 36.68365], [-121.75257, 36.68073], [-121.75146, 36.6801], [-121.74911, 36.6779], [-121.75195, 36.67676], [-121.75214, 36.67632], [-121.75247, 36.67453], [-121.75354, 36.67429], [-121.75391, 36.67753], [-121.75535, 36.67855], [-121.75536, 36.68165], [-121.75539, 36.682], [-121.75791, 36.68606]]], [[[-121.77964, 36.68834], [-121.7669, 36.69278], [-121.76637, 36.69229], [-121.76571, 36.69188], [-121.76504, 36.69157], [-121.76357, 36.68898], [-121.76719, 36.68783], [-121.76848, 36.68844], [-121.76912, 36.68756], [-121.77161, 36.68874], [-121.77355, 36.68598], [-121.77129, 36.68474], [-121.77174, 36.68425], [-121.77964, 36.68834]]]]} | Unknown Access 4 | Fort Ord National Monument | 19010 | 1197 | Marina, City of 212 | City 2 | City Agency 2 | http://www.ci.marina.ca.us/index.aspx?NID=25 | City 2 | 205.588 | Fort Ord NM | 2012 | |
14789 | 14789 | 14788 | {"type": "Polygon", "coordinates": [[[-116.9793, 33.00015], [-116.97875, 33.00754], [-116.96993, 33.00757], [-116.96172, 33.00767], [-116.9618, 33.00385], [-116.96605, 33.00387], [-116.9661, 33.0001], [-116.97037, 33.00014], [-116.9793, 33.00015]], [[-116.96341, 33.00537], [-116.96341, 33.00535], [-116.96301, 33.00517], [-116.96283, 33.00519], [-116.96283, 33.00535], [-116.9626, 33.00539], [-116.96258, 33.00528], [-116.96209, 33.00531], [-116.96211, 33.0057], [-116.96243, 33.0057], [-116.96285, 33.00559], [-116.96301, 33.00552], [-116.96317, 33.00548], [-116.96341, 33.00537]]]} | Unknown Access 4 | City of San Diego Open Space | 17331 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 287.287 | City of San Diego OS | ||
14944 | 14944 | 14943 | {"type": "Polygon", "coordinates": [[[-117.69372, 33.47577], [-117.69372, 33.47621], [-117.69164, 33.47621], [-117.69155, 33.4761], [-117.69185, 33.47517], [-117.69271, 33.47517], [-117.69279, 33.47543], [-117.69307, 33.47559], [-117.69326, 33.47577], [-117.69372, 33.47577]]]} | Unknown Access 4 | Stonehill Open Space | 25889 | 1079 | Dana Point, City of 131 | City 2 | City Agency 2 | http://www.danapoint.org/index.aspx?page=170 | City 2 | 4.155 | Stonehill OS | ||
1125 | 1125 | 1124 | {"type": "Polygon", "coordinates": [[[-117.31018, 33.69849], [-117.30588, 33.69858], [-117.30592, 33.70216], [-117.30153, 33.70223], [-117.30155, 33.69866], [-117.2974, 33.69872], [-117.29732, 33.68915], [-117.30424, 33.68905], [-117.3043, 33.69122], [-117.31014, 33.69113], [-117.31018, 33.69849]]]} | Unknown Access 4 | Alberhill Conservation Area, Expansion 1 | 15335 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 318.034 | Alberhill Conservation Area, Expansion 1 | ||
1431 | 1431 | 1430 | {"type": "MultiPolygon", "coordinates": [[[[-117.31639, 33.6953], [-117.31635, 33.69561], [-117.31633, 33.69569], [-117.3163, 33.69571], [-117.31632, 33.6955], [-117.3163, 33.69534], [-117.31595, 33.69537], [-117.31592, 33.69538], [-117.31574, 33.69537], [-117.31571, 33.69539], [-117.31553, 33.69534], [-117.3153, 33.6952], [-117.31512, 33.69522], [-117.31503, 33.69526], [-117.31476, 33.69552], [-117.31443, 33.69569], [-117.31383, 33.6958], [-117.31368, 33.69593], [-117.31364, 33.69608], [-117.31361, 33.69625], [-117.31355, 33.6964], [-117.31344, 33.69654], [-117.31328, 33.69667], [-117.31326, 33.69671], [-117.31313, 33.69668], [-117.31304, 33.69689], [-117.31324, 33.69696], [-117.31297, 33.69761], [-117.31285, 33.69777], [-117.31286, 33.69781], [-117.31274, 33.69796], [-117.31275, 33.69801], [-117.31267, 33.6982], [-117.31269, 33.69825], [-117.31261, 33.69844], [-117.31263, 33.69849], [-117.31232, 33.6985], [-117.31228, 33.69878], [-117.31228, 33.69934], [-117.31217, 33.69939], [-117.3121, 33.69984], [-117.31209, 33.70031], [-117.31159, 33.70037], [-117.31143, 33.70065], [-117.31153, 33.70092], [-117.31154, 33.7013], [-117.31183, 33.70143], [-117.31253, 33.70148], [-117.31263, 33.70165], [-117.31269, 33.70186], [-117.31269, 33.70201], [-117.31283, 33.70211], [-117.31017, 33.70213], [-117.31015, 33.70437], [-117.30948, 33.70421], [-117.30905, 33.70422], [-117.30873, 33.70414], [-117.30802, 33.70393], [-117.30754, 33.70366], [-117.30723, 33.70357], [-117.30706, 33.70356], [-117.30739, 33.70329], [-117.3083, 33.70347], [-117.30818, 33.70272], [-117.30938, 33.70245], [-117.31079, 33.7014], [-117.31122, 33.70029], [-117.31185, 33.7001], [-117.31177, 33.69849], [-117.31161, 33.69851], [-117.31168, 33.70001], [-117.31109, 33.70018], [-117.31064, 33.70131], [-117.3093, 33.70232], [-117.308, 33.70261], [-117.3081, 33.70329], [-117.30733, 33.70314], [-117.3056, 33.70454], [-117.30572, 33.70516], [-117.30515, 33.70516], [-117.30516, 33.70542], [-117.30443, 33.70565], [-117.30445, 33.70582], [-117.3015, 33.70585], [-117.30154, 33.70315], [-117.30153, 33.70223], [-117.30591, 33.70216], [-117.30588, 33.69857], [-117.31017, 33.69849], [-117.31016, 33.69487], [-117.31638, 33.69484], [-117.31639, 33.6953]]], [[[-117.31014, 33.69113], [-117.30429, 33.69122], [-117.30424, 33.68907], [-117.30415, 33.68905], [-117.30405, 33.6841], [-117.3101, 33.68401], [-117.31014, 33.69113]]], [[[-117.30638, 33.70411], [-117.30631, 33.70476], [-117.30632, 33.7049], [-117.30627, 33.70497], [-117.30595, 33.70515], [-117.30589, 33.70515], [-117.30578, 33.70459], [-117.30638, 33.70411]]], [[[-117.32739, 33.71393], [-117.32716, 33.72027], [-117.31862, 33.7203], [-117.31839, 33.72757], [-117.31126, 33.7276], [-117.31118, 33.72583], [-117.31162, 33.72582], [-117.31163, 33.7258], [-117.31115, 33.725], [-117.31105, 33.72502], [-117.31013, 33.72438], [-117.30997, 33.72377], [-117.31012, 33.71407], [-117.3188, 33.71403], [-117.32739, 33.71393]]], [[[-117.36159, 33.71668], [-117.35971, 33.71664], [-117.35975, 33.7135], [-117.36052, 33.71444], [-117.36112, 33.71589], [-117.36129, 33.71621], [-117.36152, 33.71654], [-117.36159, 33.71668]]], [[[-117.45455, 33.74791], [-117.45432, 33.74847], [-117.45404, 33.74872], [-117.45382, 33.74846], [-117.45382, 33.74819], [-117.45451, 33.74787], [-117.45455, 33.74791]]], [[[-117.46108, 33.7505], [-117.46077, 33.75067], [-117.46048, 33.7509], [-117.45889, 33.75254], [-117.45869, 33.75269], [-117.45844, 33.75282], [-117.45841, 33.75283], [-117.4583, 33.75281], [-117.45827, 33.75277], [-117.45859, 33.75261], [-117.45884, 33.75242], [-117.45899, 33.7524], [-117.45962, 33.75175], [-117.45961, 33.75163], [-117.46014, 33.75107], [-117.46029, 33.75106], [-117.46051, 33.75084], [-117.46072, 33.75067], [-117.46107, 33.75048], [-117.46108, 33.7505]]]]} | Unknown Access 4 | Alberhill Conservation Area | 15333 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 685.756 | Alberhill Conservation Area | ||
1432 | 1432 | 1431 | {"type": "Polygon", "coordinates": [[[-117.30415, 33.68905], [-117.29734, 33.68915], [-117.29734, 33.69144], [-117.29287, 33.69151], [-117.29287, 33.69102], [-117.29327, 33.69128], [-117.29388, 33.69128], [-117.29399, 33.69136], [-117.29427, 33.69138], [-117.29456, 33.69129], [-117.29451, 33.69066], [-117.29452, 33.69039], [-117.29447, 33.69031], [-117.2946, 33.69005], [-117.29429, 33.68946], [-117.2946, 33.68922], [-117.29464, 33.68853], [-117.29508, 33.68828], [-117.29535, 33.68806], [-117.29568, 33.68802], [-117.29627, 33.6878], [-117.29667, 33.688], [-117.29688, 33.68832], [-117.29685, 33.68857], [-117.29726, 33.68882], [-117.29762, 33.68881], [-117.29775, 33.68866], [-117.29759, 33.68829], [-117.29711, 33.68815], [-117.29686, 33.68785], [-117.2964, 33.68762], [-117.29645, 33.68722], [-117.29662, 33.687], [-117.29678, 33.68667], [-117.29715, 33.68644], [-117.29761, 33.68597], [-117.29777, 33.68545], [-117.29782, 33.68494], [-117.29802, 33.68467], [-117.29801, 33.68457], [-117.29769, 33.68419], [-117.30405, 33.6841], [-117.30415, 33.68905]]]} | Unknown Access 4 | Alberhill Conservation Area, Expansion 2 | 15336 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 109.586 | Alberhill Conservation Area, Expansion 2 | ||
1640 | 1640 | 1639 | {"type": "MultiPolygon", "coordinates": [[[[-119.78388, 34.43248], [-119.78388, 34.43252], [-119.78345, 34.43278], [-119.78231, 34.43354], [-119.78143, 34.43378], [-119.78052, 34.4337], [-119.78052, 34.43358], [-119.78135, 34.43364], [-119.78158, 34.43361], [-119.78213, 34.43346], [-119.78241, 34.43332], [-119.78376, 34.43242], [-119.78381, 34.43241], [-119.78385, 34.43243], [-119.78388, 34.43248]]], [[[-119.79498, 34.42774], [-119.79162, 34.42959], [-119.7874, 34.43078], [-119.78626, 34.43109], [-119.78624, 34.43108], [-119.78589, 34.43127], [-119.78408, 34.43239], [-119.78411, 34.4321], [-119.78448, 34.43201], [-119.78536, 34.43149], [-119.78544, 34.43143], [-119.7857, 34.43115], [-119.7862, 34.43068], [-119.78689, 34.43049], [-119.78695, 34.43058], [-119.79145, 34.42935], [-119.79202, 34.42903], [-119.79202, 34.42901], [-119.79462, 34.42757], [-119.79483, 34.42761], [-119.79498, 34.42774]]]]} | Unknown Access 4 | Atascadero Creek | 15661 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 9.641 | Atascadero Creek | ||
2648 | 2648 | 2647 | {"type": "MultiPolygon", "coordinates": [[[[-119.50852, 34.39516], [-119.50697, 34.39588], [-119.50689, 34.39577], [-119.5075, 34.3955], [-119.50841, 34.395], [-119.50852, 34.39516]]], [[[-119.50986, 34.39487], [-119.50965, 34.39489], [-119.50944, 34.39484], [-119.50927, 34.39472], [-119.50912, 34.39454], [-119.50904, 34.39446], [-119.50888, 34.39438], [-119.50873, 34.39436], [-119.5086, 34.39437], [-119.50821, 34.39482], [-119.50804, 34.39483], [-119.50784, 34.39456], [-119.50791, 34.39452], [-119.50809, 34.39428], [-119.50817, 34.39415], [-119.50814, 34.39411], [-119.50831, 34.39392], [-119.50859, 34.39368], [-119.50859, 34.3931], [-119.50876, 34.39344], [-119.50894, 34.39363], [-119.50973, 34.39477], [-119.5098, 34.39476], [-119.50986, 34.39487]]]]} | Unknown Access 4 | Carpinteria Creek | 16896 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 3.636 | Carpinteria Creek |
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]);