superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
73 rows where ACCESS_TYP = 1 and MNG_AGENCY = 87 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
ACCESS_TYP 1
- Open Access · 73 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
164 | 164 | 163 | {"type": "Polygon", "coordinates": [[[-121.74145, 37.61399], [-121.74132, 37.61413], [-121.74116, 37.61418], [-121.74067, 37.61426], [-121.74045, 37.61437], [-121.74047, 37.61426], [-121.74145, 37.61399]]]} | Open Access 1 | Lake Del Valle SRA | http://www.parks.ca.gov/?page_id=537 | 1594 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 0.204 | Lake Del Valle SRA | 2000 |
1514 | 1514 | 1513 | {"type": "Polygon", "coordinates": [[[-121.7508, 38.02106], [-121.75061, 38.02106], [-121.75061, 38.02096], [-121.75065, 38.02095], [-121.75065, 38.01964], [-121.75066, 38.01963], [-121.75067, 38.01953], [-121.75076, 38.01953], [-121.75075, 38.02094], [-121.7508, 38.02096], [-121.7508, 38.02106]]]} | Open Access 1 | Antioch Bridge Fishing Pier | 15522 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 0.397 | Antioch Bridge Fishing Pier | ||
2263 | 2263 | 2262 | {"type": "Polygon", "coordinates": [[[-122.11236, 37.89111], [-122.11234, 37.89111], [-122.11224, 37.89126], [-122.11214, 37.89136], [-122.11187, 37.89147], [-122.11178, 37.89161], [-122.11167, 37.89192], [-122.11167, 37.89221], [-122.1114, 37.89225], [-122.11132, 37.89205], [-122.11155, 37.89177], [-122.11166, 37.89144], [-122.11195, 37.89118], [-122.1122, 37.89108], [-122.1122, 37.89103], [-122.11235, 37.89102], [-122.11236, 37.89111]]]} | Open Access 1 | Briones/Las Trampas Trail | 16396 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 0.767 | Briones/Las Trampas Trail | ||
7893 | 7893 | 7892 | {"type": "Polygon", "coordinates": [[[-122.04279, 37.68931], [-122.04193, 37.68951], [-122.04197, 37.68984], [-122.0417, 37.68988], [-122.04139, 37.69003], [-122.04079, 37.69022], [-122.04108, 37.68972], [-122.04062, 37.6896], [-122.04169, 37.68901], [-122.04204, 37.68905], [-122.04279, 37.68931]]]} | Open Access 1 | Palomares Ridge | 23369 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2.619 | Palomares Ridge | ||
8263 | 8263 | 8262 | {"type": "Polygon", "coordinates": [[[-122.14526, 37.74311], [-122.14524, 37.74315], [-122.14492, 37.74341], [-122.14434, 37.74398], [-122.14423, 37.74406], [-122.1437, 37.74331], [-122.14342, 37.74306], [-122.14482, 37.7425], [-122.14526, 37.74311]]]} | Open Access 1 | Poaks Headquarters | 23819 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 3.418 | Poaks Headquarters | ||
9232 | 9232 | 9231 | {"type": "MultiPolygon", "coordinates": [[[[-121.96304, 37.93978], [-121.96305, 37.93982], [-121.96283, 37.94044], [-121.96271, 37.94113], [-121.96265, 37.94118], [-121.96266, 37.94099], [-121.96275, 37.9405], [-121.96283, 37.9402], [-121.963, 37.93975], [-121.96304, 37.93978]]], [[[-121.967, 37.94522], [-121.96692, 37.94523], [-121.96688, 37.94515], [-121.96662, 37.94479], [-121.9661, 37.94436], [-121.96423, 37.94346], [-121.96462, 37.94293], [-121.96447, 37.94288], [-121.96422, 37.94261], [-121.9641, 37.94241], [-121.96396, 37.94225], [-121.96369, 37.94199], [-121.96305, 37.94148], [-121.96287, 37.94147], [-121.9629, 37.94142], [-121.96307, 37.94142], [-121.96377, 37.94198], [-121.96401, 37.94221], [-121.96416, 37.94238], [-121.96429, 37.94259], [-121.96452, 37.94283], [-121.96475, 37.9429], [-121.96435, 37.94345], [-121.96617, 37.94432], [-121.9667, 37.94476], [-121.96695, 37.94513], [-121.967, 37.94522]]], [[[-121.96407, 37.93824], [-121.96335, 37.93918], [-121.96327, 37.9393], [-121.96312, 37.9396], [-121.96305, 37.93961], [-121.96316, 37.93934], [-121.96329, 37.93915], [-121.96399, 37.93823], [-121.96407, 37.93824]]], [[[-121.96826, 37.93546], [-121.96797, 37.93555], [-121.96726, 37.9357], [-121.96694, 37.93579], [-121.96664, 37.93591], [-121.96636, 37.93605], [-121.9661, 37.93622], [-121.96586, 37.93641], [-121.96569, 37.93657], [-121.96412, 37.93819], [-121.96404, 37.93818], [-121.96563, 37.93653], [-121.96585, 37.93633], [-121.9661, 37.93614], [-121.96637, 37.93598], [-121.96666, 37.93584], [-121.96696, 37.93572], [-121.96728, 37.93563], [-121.96782, 37.93553], [-121.96807, 37.93546], [-121.96826, 37.93546]]], [[[-121.96761, 37.94557], [-121.96754, 37.94563], [-121.96714, 37.94565], [-121.96699, 37.94536], [-121.96707, 37.94535], [-121.9672, 37.94559], [-121.96761, 37.94557]]], [[[-121.97369, 37.93539], [-121.97365, 37.93544], [-121.96855, 37.93551], [-121.96867, 37.93545], [-121.97369, 37.93539]]], [[[-122.08253, 37.97602], [-122.08247, 37.97608], [-122.08181, 37.97609], [-122.08181, 37.97604], [-122.08253, 37.97602]]], [[[-122.08523, 37.97718], [-122.08516, 37.97722], [-122.08511, 37.97722], [-122.08497, 37.97715], [-122.08485, 37.9771], [-122.08446, 37.97706], [-122.08405, 37.97641], [-122.08396, 37.97618], [-122.08386, 37.97606], [-122.08269, 37.97608], [-122.08276, 37.97602], [-122.08396, 37.976], [-122.08396, 37.97605], [-122.08403, 37.97614], [-122.08409, 37.97627], [-122.08413, 37.97639], [-122.08447, 37.97693], [-122.08458, 37.977], [-122.08484, 37.97704], [-122.08507, 37.97712], [-122.08514, 37.97711], [-122.08523, 37.97718]]]]} | Open Access 1 | California Riding and Hiking Trail | https://www.ebparks.org/parks/trails/california/default.htm | 33750 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 3.641 | California Riding and Hiking Trail | 1982 |
15458 | 15458 | 15457 | {"type": "Polygon", "coordinates": [[[-121.71401, 38.0024], [-121.71401, 38.00331], [-121.71393, 38.00334], [-121.7134, 38.00283], [-121.71283, 38.00253], [-121.71206, 38.00177], [-121.71201, 38.00107], [-121.71333, 38.00191], [-121.71401, 38.0024]]]} | Open Access 1 | Big Break Regional Trail | 16075 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 4.138 | Big Break Reg. Trail | ||
1850 | 1850 | 1849 | {"type": "Polygon", "coordinates": [[[-121.70748, 37.99957], [-121.7053, 37.99809], [-121.70531, 37.9979], [-121.70746, 37.99794], [-121.70748, 37.99957]]]} | Open Access 1 | BB Delta Shoreline Trail | 15905 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 4.737 | BB Delta Shoreline Trail | ||
4988 | 4988 | 4987 | {"type": "MultiPolygon", "coordinates": [[[[-122.1451, 37.64851], [-122.1451, 37.64897], [-122.14509, 37.64903], [-122.14501, 37.64917], [-122.14486, 37.64934], [-122.14456, 37.64957], [-122.14429, 37.64973], [-122.14412, 37.64979], [-122.14409, 37.64745], [-122.14507, 37.64744], [-122.1451, 37.64851]]], [[[-122.14586, 37.6471], [-122.14517, 37.64711], [-122.14517, 37.64682], [-122.14586, 37.64682], [-122.14586, 37.6471]]]]} | Open Access 1 | Hayward Shoreline | 19762 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 5.419 | Hayward Shoreline | 1977 | |
3553 | 3553 | 3552 | {"type": "Polygon", "coordinates": [[[-122.0528, 37.99715], [-122.05267, 37.99768], [-122.05079, 37.99735], [-122.05078, 37.99734], [-122.05051, 37.99729], [-122.05017, 37.99726], [-122.05016, 37.99724], [-122.04978, 37.99725], [-122.04887, 37.99733], [-122.04817, 37.99731], [-122.04823, 37.9969], [-122.04863, 37.99694], [-122.04888, 37.99693], [-122.04913, 37.99691], [-122.04957, 37.9968], [-122.04984, 37.99676], [-122.04986, 37.99675], [-122.05003, 37.99674], [-122.0501, 37.99681], [-122.05025, 37.99683], [-122.05029, 37.99673], [-122.05066, 37.99677], [-122.0528, 37.99715]]]} | Open Access 1 | Delta/DeAnza Trail | 18077 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 5.446 | Delta/DeAnza Trail | ||
14198 | 14198 | 14197 | {"type": "MultiPolygon", "coordinates": [[[[-122.03357, 37.90414], [-122.03346, 37.90426], [-122.03345, 37.904], [-122.0335, 37.90405], [-122.03357, 37.90414]]], [[[-122.04019, 37.90842], [-122.03957, 37.90859], [-122.03754, 37.90726], [-122.03826, 37.90623], [-122.03875, 37.90662], [-122.03905, 37.9069], [-122.03939, 37.90741], [-122.03961, 37.90803], [-122.04019, 37.90842]]]]} | Open Access 1 | Briones to Mount Diablo Trail | 33752 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 5.904 | Briones to Mount Diablo Trail | ||
11203 | 11203 | 11202 | {"type": "Polygon", "coordinates": [[[-122.37623, 37.95851], [-122.37478, 37.95896], [-122.37475, 37.95894], [-122.37382, 37.95922], [-122.37381, 37.95841], [-122.37423, 37.95841], [-122.37437, 37.95838], [-122.37437, 37.95836], [-122.37421, 37.95812], [-122.37426, 37.95805], [-122.37534, 37.95758], [-122.3757, 37.95745], [-122.37611, 37.9574], [-122.3762, 37.95742], [-122.37623, 37.95851]]]} | Open Access 1 | Wildcat Creek Trail | 27503 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 6.211 | Wildcat Creek Trail | ||
3019 | 3019 | 3018 | {"type": "Polygon", "coordinates": [[[-122.22124, 37.86457], [-122.22068, 37.86515], [-122.21997, 37.86481], [-122.21728, 37.86206], [-122.21756, 37.8619], [-122.21817, 37.86235], [-122.21846, 37.86264], [-122.21903, 37.86314], [-122.21933, 37.86325], [-122.21963, 37.86351], [-122.22001, 37.86389], [-122.22037, 37.86416], [-122.22067, 37.86434], [-122.22124, 37.86457]]]} | Open Access 1 | Claremont Canyon Regional Preserve | 17381 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 6.336 | Claremont Canyon RPr | 1985 | |
1523 | 1523 | 1522 | {"type": "Polygon", "coordinates": [[[-121.7518, 38.01968], [-121.75091, 38.01969], [-121.7509, 38.01963], [-121.75076, 38.01962], [-121.75075, 38.01954], [-121.75067, 38.01953], [-121.75068, 38.01915], [-121.75068, 38.01845], [-121.75062, 38.01784], [-121.75069, 38.01749], [-121.75069, 38.01643], [-121.75071, 38.01657], [-121.7508, 38.01673], [-121.7509, 38.01684], [-121.75104, 38.01693], [-121.75122, 38.01701], [-121.75137, 38.01703], [-121.75179, 38.01704], [-121.7518, 38.01968]]]} | Open Access 1 | Antioch / Oakley Regional Shoreline | 15521 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 7.376 | Antioch / Oakley Reg. Shoreline | ||
11595 | 11595 | 11594 | {"type": "Polygon", "coordinates": [[[-122.12119, 37.99183], [-122.12094, 37.99183], [-122.12073, 37.99142], [-122.12067, 37.99123], [-122.12053, 37.99101], [-122.12036, 37.99083], [-122.11953, 37.99054], [-122.11898, 37.99054], [-122.11859, 37.9907], [-122.11802, 37.99083], [-122.11755, 37.99121], [-122.11756, 37.99136], [-122.11778, 37.99163], [-122.11775, 37.99168], [-122.11747, 37.99159], [-122.11728, 37.99155], [-122.11673, 37.99148], [-122.11634, 37.99146], [-122.11634, 37.99047], [-122.11127, 37.99041], [-122.11081, 37.9904], [-122.11079, 37.99035], [-122.10885, 37.99033], [-122.10834, 37.98908], [-122.10817, 37.98839], [-122.10786, 37.98789], [-122.10639, 37.98388], [-122.10672, 37.98297], [-122.10679, 37.98298], [-122.10647, 37.98388], [-122.10794, 37.98791], [-122.10823, 37.98838], [-122.10839, 37.98906], [-122.10889, 37.99027], [-122.11086, 37.99029], [-122.11089, 37.99035], [-122.11116, 37.99036], [-122.12051, 37.99046], [-122.12055, 37.99051], [-122.12119, 37.99183]]]} | Open Access 1 | CA State Riding & Hiking Trail | http://www.ebparks.org/Page161.aspx | 28138 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 8.269 | CA State Riding & Hiking Trail | |
3264 | 3264 | 3263 | {"type": "Polygon", "coordinates": [[[-122.06926, 37.5506], [-122.06909, 37.55129], [-122.06477, 37.55292], [-122.06216, 37.55437], [-122.06194, 37.55408], [-122.06177, 37.5539], [-122.06443, 37.5524], [-122.06926, 37.5506]]]} | Open Access 1 | Coyote Hills | 17741 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 11.542 | Coyote Hills | 1967 | |
8895 | 8895 | 8894 | {"type": "Polygon", "coordinates": [[[-122.24593, 38.05452], [-122.24554, 38.05454], [-122.24552, 38.05423], [-122.24558, 38.05421], [-122.24557, 38.05413], [-122.24515, 38.05393], [-122.24465, 38.05396], [-122.24446, 38.05402], [-122.24428, 38.05419], [-122.24387, 38.05422], [-122.24323, 38.05398], [-122.24248, 38.05406], [-122.24266, 38.05471], [-122.24243, 38.05479], [-122.24254, 38.05538], [-122.24273, 38.05569], [-122.24261, 38.05587], [-122.24169, 38.05597], [-122.24148, 38.05639], [-122.23999, 38.05634], [-122.23998, 38.05584], [-122.24021, 38.05586], [-122.24054, 38.05585], [-122.24087, 38.05578], [-122.24117, 38.05566], [-122.24143, 38.0555], [-122.24155, 38.0554], [-122.24225, 38.05455], [-122.24196, 38.0544], [-122.24182, 38.05437], [-122.24148, 38.05361], [-122.24141, 38.05342], [-122.24136, 38.05321], [-122.24134, 38.05301], [-122.24135, 38.0528], [-122.24141, 38.05251], [-122.24376, 38.05319], [-122.24396, 38.05373], [-122.24386, 38.05391], [-122.24393, 38.05396], [-122.24423, 38.05395], [-122.24431, 38.05384], [-122.24459, 38.05375], [-122.24532, 38.05371], [-122.24583, 38.05396], [-122.24584, 38.05419], [-122.24593, 38.05421], [-122.24593, 38.05452]]]} | Open Access 1 | Rodeo Grounds | 24549 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 14.385 | Rodeo Grounds | ||
4763 | 4763 | 4762 | {"type": "MultiPolygon", "coordinates": [[[[-122.09727, 37.88609], [-122.09728, 37.88613], [-122.09719, 37.88664], [-122.09719, 37.88699], [-122.0967, 37.88654], [-122.09593, 37.88668], [-122.09517, 37.88629], [-122.09471, 37.88637], [-122.09407, 37.88659], [-122.09356, 37.88625], [-122.09322, 37.88618], [-122.0933, 37.88612], [-122.0934, 37.8861], [-122.09615, 37.88602], [-122.09669, 37.88602], [-122.09723, 37.88606], [-122.09727, 37.88609]]], [[[-122.10336, 37.88915], [-122.10325, 37.88929], [-122.09952, 37.88684], [-122.09906, 37.88657], [-122.09871, 37.8864], [-122.09832, 37.88626], [-122.09812, 37.88621], [-122.09789, 37.88617], [-122.09798, 37.88599], [-122.09846, 37.88612], [-122.09878, 37.88625], [-122.09907, 37.88638], [-122.09965, 37.88671], [-122.10336, 37.88915]]], [[[-122.1019, 37.86205], [-122.09983, 37.86557], [-122.09945, 37.86633], [-122.09932, 37.86665], [-122.0991, 37.8673], [-122.09905, 37.86718], [-122.09902, 37.86708], [-122.09902, 37.86693], [-122.09904, 37.86683], [-122.09942, 37.86591], [-122.09959, 37.86561], [-122.10171, 37.86198], [-122.1019, 37.86205]]], [[[-122.10312, 37.8574], [-122.10291, 37.8578], [-122.10264, 37.85858], [-122.10249, 37.85922], [-122.10222, 37.86073], [-122.10215, 37.86103], [-122.10202, 37.8614], [-122.10184, 37.86175], [-122.10186, 37.86166], [-122.10185, 37.86153], [-122.10177, 37.86092], [-122.10174, 37.86061], [-122.10175, 37.86053], [-122.1018, 37.86051], [-122.10189, 37.85867], [-122.10206, 37.85862], [-122.1022, 37.85863], [-122.10237, 37.85834], [-122.10243, 37.85805], [-122.10203, 37.85798], [-122.10216, 37.85747], [-122.10262, 37.85738], [-122.10272, 37.85714], [-122.10312, 37.8574]]], [[[-122.11101, 37.89088], [-122.11069, 37.89095], [-122.11037, 37.89099], [-122.11005, 37.89101], [-122.10971, 37.89099], [-122.10651, 37.89056], [-122.10567, 37.89038], [-122.10492, 37.89015], [-122.10424, 37.88986], [-122.10384, 37.88965], [-122.10339, 37.88938], [-122.10349, 37.88924], [-122.10392, 37.88949], [-122.10446, 37.88977], [-122.10501, 37.89], [-122.1057, 37.89022], [-122.1066, 37.8904], [-122.10953, 37.89081], [-122.10981, 37.89083], [-122.1101, 37.89084], [-122.1104, 37.89082], [-122.11069, 37.89078], [-122.11099, 37.89072], [-122.11101, 37.89088]]]]} | Open Access 1 | Lafayette/Moraga Trail | 20836 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 18.38 | Lafayette/Moraga Trail | ||
12229 | 12229 | 12228 | {"type": "Polygon", "coordinates": [[[-122.30225, 37.84721], [-122.30092, 37.84749], [-122.30086, 37.84731], [-122.30077, 37.84713], [-122.30066, 37.84697], [-122.30052, 37.84682], [-122.30027, 37.84663], [-122.29902, 37.84581], [-122.29886, 37.84568], [-122.29873, 37.84553], [-122.29859, 37.84527], [-122.29849, 37.84497], [-122.29858, 37.84494], [-122.29844, 37.84436], [-122.30225, 37.84436], [-122.30225, 37.84721]]]} | Open Access 1 | Point Emery Park | http://www.ebarks.org | 29208 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 20.687 | Point Emery Park | |
6358 | 6358 | 6357 | {"type": "MultiPolygon", "coordinates": [[[[-122.2745, 38.03467], [-122.27444, 38.03503], [-122.27436, 38.03534], [-122.27424, 38.03563], [-122.27403, 38.03599], [-122.27382, 38.03626], [-122.27358, 38.03652], [-122.2733, 38.03675], [-122.27299, 38.03695], [-122.27266, 38.03714], [-122.27231, 38.03729], [-122.27194, 38.03741], [-122.27098, 38.0377], [-122.26857, 38.0384], [-122.26853, 38.03822], [-122.271, 38.0375], [-122.27095, 38.03738], [-122.27083, 38.03724], [-122.27147, 38.03713], [-122.27143, 38.03692], [-122.2718, 38.03685], [-122.27171, 38.0365], [-122.27241, 38.03638], [-122.27232, 38.03602], [-122.27285, 38.03593], [-122.27279, 38.03563], [-122.27332, 38.03554], [-122.27318, 38.03496], [-122.27391, 38.03485], [-122.27386, 38.03459], [-122.27435, 38.03452], [-122.2745, 38.03467]]], [[[-122.27573, 38.03587], [-122.27551, 38.03742], [-122.27477, 38.0383], [-122.27289, 38.03742], [-122.27234, 38.03763], [-122.27226, 38.0376], [-122.27246, 38.03753], [-122.27285, 38.03737], [-122.27321, 38.03717], [-122.27354, 38.03694], [-122.27385, 38.03669], [-122.27411, 38.03641], [-122.27434, 38.03611], [-122.27453, 38.0358], [-122.27461, 38.03562], [-122.27475, 38.0352], [-122.27481, 38.03496], [-122.27573, 38.03587]]]]} | Open Access 1 | Lone Tree Point | 21444 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 21.153 | Lone Tree Point |
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]);