units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 1 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15837 | 15837 | 15836 | {"type": "Polygon", "coordinates": [[[-122.19174, 39.37079], [-122.19168, 39.37488], [-122.19166, 39.38527], [-122.13607, 39.38546], [-122.13599, 39.37821], [-122.13601, 39.37718], [-122.13599, 39.37178], [-122.13594, 39.37175], [-122.13594, 39.37106], [-122.15454, 39.37089], [-122.15462, 39.36501], [-122.1546, 39.36372], [-122.17338, 39.36362], [-122.17326, 39.37092], [-122.19174, 39.37079]]]} | No Public Access 3 | 24455 | Sacramento River National Wildlife Refuge | 24770 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Colusa 49 | 2223.203 | Sacramento River NWR | 1989 | National Wildlife Refuge 105 | 2 | |
15846 | 15846 | 15845 | {"type": "MultiPolygon", "coordinates": [[[[-122.19365, 39.41663], [-122.19259, 39.41662], [-122.1926, 39.41509], [-122.19257, 39.4127], [-122.19286, 39.41004], [-122.19291, 39.40937], [-122.19291, 39.40713], [-122.19352, 39.40712], [-122.19387, 39.40745], [-122.1947, 39.40842], [-122.19506, 39.40936], [-122.19506, 39.40977], [-122.19493, 39.41059], [-122.19488, 39.41125], [-122.19465, 39.41219], [-122.19365, 39.41663]]], [[[-122.00865, 39.41919], [-122.00773, 39.41956], [-122.00761, 39.41956], [-122.00723, 39.41991], [-122.00383, 39.42133], [-122.00351, 39.42133], [-122.0027, 39.42194], [-122.0027, 39.42232], [-122.00189, 39.42357], [-122.00196, 39.42407], [-122.00155, 39.42434], [-121.99968, 39.42461], [-121.99888, 39.42512], [-121.99895, 39.42522], [-121.99767, 39.42601], [-121.99697, 39.42568], [-121.99605, 39.42558], [-121.99539, 39.42539], [-121.99507, 39.42534], [-121.99506, 39.4253], [-121.99478, 39.42522], [-121.99348, 39.4249], [-121.99322, 39.42472], [-121.9927, 39.42445], [-121.9922, 39.42404], [-121.99147, 39.42386], [-121.99166, 39.42352], [-121.99178, 39.42326], [-121.99183, 39.42308], [-121.99191, 39.42257], [-121.99231, 39.4191], [-121.99231, 39.4183], [-121.99232, 39.41258], [-121.99092, 39.41257], [-121.98999, 39.40997], [-121.99233, 39.40997], [-121.99233, 39.4119], [-122.00733, 39.41168], [-122.00744, 39.41175], [-122.0079, 39.41307], [-122.00618, 39.41351], [-122.00181, 39.41373], [-121.9993, 39.41447], [-121.99703, 39.41439], [-121.99702, 39.4144], [-121.99719, 39.41451], [-121.9983, 39.41459], [-121.99959, 39.41451], [-122.00194, 39.41382], [-122.00547, 39.41364], [-122.00653, 39.41355], [-122.00807, 39.4132], [-122.00844, 39.41433], [-122.00845, 39.41461], [-122.00827, 39.41463], [-122.00822, 39.41543], [-122.00855, 39.41622], [-122.00849, 39.41686], [-122.00881, 39.4183], [-122.00865, 39.41919]], [[-121.99745, 39.41496], [-121.99745, 39.41494], [-121.99698, 39.41491], [-121.99608, 39.41436], [-121.99605, 39.41436], [-121.99704, 39.41497], [-121.99745, 39.41496]], [[-121.99418, 39.41349], [-121.99418, 39.41351], [-121.99432, 39.41358], [-121.99461, 39.41359], [-121.99532, 39.4134], [-121.99514, 39.41329], [-121.99418, 39.41349]], [[-121.99339, 39.41311], [-121.99338, 39.41313], [-121.99373, 39.4133], [-121.99394, 39.41339], [-121.99339, 39.41311]], [[-121.99234, 39.41217], [-121.99232, 39.41217], [-121.99232, 39.41224], [-121.99242, 39.41226], [-121.99242, 39.41224], [-121.99234, 39.41217]]], [[[-122.00771, 39.43378], [-122.00759, 39.43395], [-122.00754, 39.43401], [-122.00765, 39.43375], [-122.00771, 39.43378]]], [[[-122.19222, 39.45106], [-122.15541, 39.45123], [-122.1366, 39.45121], [-122.13641, 39.4367], [-122.13643, 39.43552], [-122.13629, 39.42078], [-122.13626, 39.41463], [-122.13607, 39.41462], [-122.13618, 39.41461], [-122.13616, 39.40624], [-122.13609, 39.39468], [-122.136, 39.3855], [-122.15517, 39.38546], [-122.19167, 39.38531], [-122.19166, 39.38533], [-122.192, 39.40708], [-122.19196, 39.41087], [-122.19209, 39.43666], [-122.19216, 39.4386], [-122.19222, 39.45106]]], [[[-122.01729, 39.44905], [-122.01406, 39.44897], [-122.01268, 39.44927], [-122.01268, 39.44929], [-122.01729, 39.44978], [-122.01724, 39.45059], [-122.01697, 39.45129], [-122.01681, 39.45316], [-122.01508, 39.45432], [-122.01408, 39.45546], [-122.01247, 39.45611], [-122.00967, 39.4562], [-122.00966, 39.45667], [-122.0087, 39.45661], [-122.00589, 39.45653], [-122.00302, 39.45673], [-122.00105, 39.45692], [-121.99935, 39.45696], [-121.99895, 39.45698], [-121.99945, 39.45642], [-121.99798, 39.45443], [-121.99785, 39.45334], [-121.99593, 39.45068], [-121.99613, 39.44992], [-121.996, 39.44991], [-121.99592, 39.44594], [-121.99705, 39.44339], [-121.99853, 39.44241], [-121.99989, 39.44057], [-122.0006, 39.43923], [-122.00086, 39.43913], [-122.0022, 39.43891], [-122.0032, 39.43883], [-122.00306, 39.43712], [-122.01159, 39.43731], [-122.01276, 39.44151], [-122.01353, 39.44228], [-122.01405, 39.44274], [-122.01449, 39.44354], [-122.01729, 39.44905]]], [[[-122.01144, 39.47612], [-122.00951, 39.47537], [-122.00697, 39.47478], [-122.00646, 39.47497], [-122.00535, 39.47499], [-122.00511, 39.47502], [-122.00219, 39.47567], [-121.99899, 39.47573], [-121.99887, 39.47434], [-121.99891, 39.47393], [-121.99872, 39.47367], [-121.99856, 39.47292], [-121.9982, 39.47263], [-121.99716, 39.47086], [-121.9964, 39.46985], [-121.99586, 39.46894], [-121.99571, 39.46861], [-121.99555, 39.46756], [-121.99599, 39.46614], [-121.99642, 39.46523], [-121.9967, 39.46539], [-121.99701, 39.46445], [-121.99713, 39.46199], [-121.99664, 39.46059], [-121.99648, 39.46018], [-121.99598, 39.46044], [-121.99511, 39.46008], [-121.99681, 39.45985], [-121.99931, 39.45737], [-122.00931, 39.45722], [-122.00978, 39.45843], [-122.01052, 39.45954], [-122.01067, 39.4598], [-122.01051, 39.4599], [-122.01101, 39.46099], [-122.01119, 39.46288], [-122.01087, 39.46459], [-122.01012, 39.46654], [-122.0102, 39.4671], [-122.01012, 39.46745], [-122.0093, 39.46869], [-122.00775, 39.47005], [-122.00814, 39.47042], [-122.00847, 39.47047], [-122.00907, 39.47034], [-122.00977, 39.47066], [-122.00993, 39.47095], [-122.01033, 39.47098], [-122.0107, 39.47121], [-122.01085, 39.47224], [-122.01102, 39.47227], [-122.01144, 39.47612]]]]} | No Public Access 3 | 25348 | Sacramento River National Wildlife Refuge | 24770 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Glenn 55 | 10475.622 | Sacramento River NWR | 1989 | National Wildlife Refuge 105 | 2 | |
1162 | 1162 | 1161 | {"type": "Polygon", "coordinates": [[[-117.68625, 34.15373], [-117.68578, 34.15427], [-117.68557, 34.15448], [-117.68493, 34.15499], [-117.6846, 34.15528], [-117.6843, 34.15564], [-117.68412, 34.15595], [-117.684, 34.15622], [-117.6839, 34.1566], [-117.68388, 34.15675], [-117.68382, 34.15766], [-117.68376, 34.15794], [-117.68368, 34.15812], [-117.68357, 34.15832], [-117.68344, 34.15847], [-117.68287, 34.15907], [-117.68274, 34.15924], [-117.68258, 34.15954], [-117.68245, 34.15995], [-117.68242, 34.16023], [-117.68245, 34.16069], [-117.68245, 34.16105], [-117.68208, 34.16106], [-117.68184, 34.16148], [-117.68206, 34.16189], [-117.68218, 34.16224], [-117.68202, 34.16262], [-117.6817, 34.16279], [-117.68157, 34.16302], [-117.68115, 34.16313], [-117.68121, 34.16295], [-117.68133, 34.1628], [-117.68117, 34.1626], [-117.68101, 34.16231], [-117.68074, 34.16231], [-117.68054, 34.16287], [-117.6798, 34.16408], [-117.6797, 34.16453], [-117.67949, 34.16491], [-117.67921, 34.16514], [-117.67876, 34.1658], [-117.67853, 34.1662], [-117.67814, 34.16752], [-117.67796, 34.16804], [-117.67739, 34.17048], [-117.67647, 34.17048], [-117.67648, 34.17002], [-117.67851, 34.16199], [-117.68171, 34.15583], [-117.68322, 34.15063], [-117.68362, 34.15063], [-117.68354, 34.15367], [-117.68625, 34.15373]]]} | No Public Access 3 | 6785 | San Antonio Channel & Dam | 24827 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 102.402 | San Antonio Channel & Dam | 0 | Resource Management Area 82 | 3 | |
15824 | 15824 | 15823 | {"type": "MultiPolygon", "coordinates": [[[[-116.88012, 32.62274], [-116.88014, 32.6264], [-116.87995, 32.63794], [-116.87422, 32.63936], [-116.86639, 32.64508], [-116.86637, 32.64162], [-116.8663, 32.63756], [-116.8707, 32.63761], [-116.87073, 32.63033], [-116.87565, 32.63036], [-116.87572, 32.62635], [-116.87571, 32.62268], [-116.88012, 32.62274]]], [[[-116.93242, 32.71398], [-116.92784, 32.7145], [-116.92785, 32.71073], [-116.93235, 32.7104], [-116.93242, 32.71398]]]]} | No Public Access 3 | 47738 | San Diego National Wildlife Refuge | 31541 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | San Diego 4 | 412.524 | San Diego NWR | 1996 | National Wildlife Refuge 105 | 2 | |
15539 | 15539 | 15538 | {"type": "Polygon", "coordinates": [[[-121.45281, 36.81548], [-121.44951, 36.81827], [-121.45206, 36.82029], [-121.45168, 36.82097], [-121.44825, 36.82238], [-121.44786, 36.82617], [-121.44667, 36.82857], [-121.45008, 36.82903], [-121.44932, 36.83003], [-121.44877, 36.83058], [-121.44768, 36.83141], [-121.44442, 36.83059], [-121.44261, 36.8296], [-121.44256, 36.82816], [-121.4406, 36.82749], [-121.4363, 36.82466], [-121.43536, 36.82021], [-121.43324, 36.81847], [-121.43417, 36.81602], [-121.43598, 36.81561], [-121.43922, 36.81527], [-121.44188, 36.81378], [-121.44228, 36.81358], [-121.44972, 36.81478], [-121.44982, 36.8147], [-121.45066, 36.8154], [-121.45255, 36.81527], [-121.45281, 36.81548]], [[-121.44867, 36.81812], [-121.4488, 36.818], [-121.4488, 36.81777], [-121.44678, 36.81613], [-121.44618, 36.81566], [-121.44504, 36.81584], [-121.44509, 36.81601], [-121.44509, 36.8161], [-121.44517, 36.81636], [-121.44515, 36.81653], [-121.44509, 36.8166], [-121.44485, 36.81675], [-121.44454, 36.81683], [-121.44435, 36.81683], [-121.44423, 36.81677], [-121.44376, 36.81639], [-121.4437, 36.81632], [-121.44361, 36.81629], [-121.44356, 36.8163], [-121.44353, 36.81634], [-121.44351, 36.81652], [-121.44342, 36.81666], [-121.44324, 36.81675], [-121.44303, 36.81678], [-121.44242, 36.81655], [-121.44233, 36.81666], [-121.44235, 36.81682], [-121.44242, 36.81706], [-121.44241, 36.81722], [-121.44226, 36.81734], [-121.44215, 36.81739], [-121.44167, 36.81747], [-121.44133, 36.81742], [-121.44115, 36.81742], [-121.44066, 36.81751], [-121.44039, 36.81766], [-121.44015, 36.81767], [-121.43983, 36.81759], [-121.43977, 36.81754], [-121.43972, 36.81756], [-121.43966, 36.81752], [-121.43964, 36.81741], [-121.4397, 36.81735], [-121.43972, 36.81729], [-121.43982, 36.81713], [-121.43959, 36.81694], [-121.43947, 36.81681], [-121.43939, 36.81667], [-121.43936, 36.81656], [-121.43936, 36.81627], [-121.4392, 36.81615], [-121.43915, 36.81605], [-121.43915, 36.816], [-121.43908, 36.81594], [-121.43896, 36.81591], [-121.43887, 36.81595], [-121.43885, 36.81602], [-121.43891, 36.8161], [-121.43892, 36.81614], [-121.43885, 36.8162], [-121.43885, 36.81625], [-121.43889, 36.81634], [-121.43889, 36.81647], [-121.43886, 36.81653], [-121.43878, 36.8166], [-121.43872, 36.81662], [-121.43863, 36.8166], [-121.43856, 36.81661], [-121.43857, 36.81666], [-121.43854, 36.81673], [-121.43846, 36.81676], [-121.43837, 36.81673], [-121.43814, 36.81682], [-121.43793, 36.81681], [-121.4377, 36.81668], [-121.43765, 36.81655], [-121.43763, 36.81646], [-121.43764, 36.81629], [-121.43746, 36.81642], [-121.43736, 36.81641], [-121.43727, 36.8163], [-121.43716, 36.81628], [-121.43655, 36.81658], [-121.43637, 36.8167], [-121.43628, 36.81672], [-121.43618, 36.81672], [-121.43609, 36.8167], [-121.43598, 36.81666], [-121.43583, 36.81657], [-121.43555, 36.81646], [-121.43518, 36.81661], [-121.43501, 36.81677], [-121.43496, 36.81684], [-121.43499, 36.81693], [-121.435, 36.81714], [-121.43499, 36.81722], [-121.43485, 36.81746], [-121.43457, 36.81777], [-121.43435, 36.81797], [-121.43398, 36.81821], [-121.43385, 36.81834], [-121.43383, 36.81844], [-121.43394, 36.81849], [-121.43409, 36.81845], [-121.43415, 36.81845], [-121.4342, 36.81847], [-121.43423, 36.81853], [-121.4343, 36.81876], [-121.43435, 36.81869], [-121.43439, 36.81852], [-121.43449, 36.81846], [-121.43469, 36.81839], [-121.43501, 36.81833], [-121.43523, 36.81832], [-121.43536, 36.8183], [-121.43546, 36.8183], [-121.43553, 36.81834], [-121.43578, 36.81853], [-121.436, 36.81867], [-121.43613, 36.81874], [-121.4363, 36.81879], [-121.43639, 36.81878], [-121.43646, 36.81871], [-121.43657, 36.81836], [-121.4366, 36.81822], [-121.43669, 36.81818], [-121.43691, 36.81824], [-121.43701, 36.8183], [-121.43767, 36.8188], [-121.43778, 36.81892], [-121.43786, 36.81905], [-121.4379, 36.81919], [-121.43787, 36.81925], [-121.43769, 36.81945], [-121.43736, 36.81956], [-121.43732, 36.81962], [-121.43737, 36.81974], [-121.43745, 36.81986], [-121.43746, 36.82], [-121.43757, 36.82027], [-121.43773, 36.82038], [-121.43841, 36.8204], [-121.43853, 36.82022], [-121.43874, 36.8201], [-121.43897, 36.82], [-121.43915, 36.81998], [-121.43923, 36.81991], [-121.43929, 36.81978], [-121.43944, 36.81963], [-121.43953, 36.81957], [-121.43974, 36.81958], [-121.44037, 36.81974], [-121.4407, 36.8198], [-121.44076, 36.81995], [-121.44096, 36.82018], [-121.44143, 36.82046], [-121.44153, 36.8206], [-121.44153, 36.82073], [-121.44141, 36.82087], [-121.44112, 36.82098], [-121.44082, 36.82111], [-121.44061, 36.82123], [-121.44023, 36.82126], [-121.43986, 36.82141], [-121.4396, 36.82142], [-121.43923, 36.82131], [-121.43894, 36.82128], [-121.43885, 36.82131], [-121.43857, 36.82123], [-121.43772, 36.82093], [-121.43755, 36.82079], [-121.43742, 36.82074], [-121.43726, 36.82076], [-121.43689, 36.821], [-121.43626, 36.82113], [-121.43608, 36.8212], [-121.43609, 36.82128], [-121.43626, 36.82134], [-121.43648, 36.82137], [-121.43663, 36.82147], [-121.43699, 36.82159], [-121.43718, 36.82169], [-121.43722, 36.82184], [-121.4372, 36.82197], [-121.4372, 36.82211], [-121.43735, 36.82211], [-121.43753, 36.82214], [-121.43803, 36.82239], [-121.43814, 36.8225], [-121.43816, 36.82261], [-121.43785, 36.82289], [-121.43772, 36.82312], [-121.43767, 36.82319], [-121.43767, 36.82329], [-121.43776, 36.8234], [-121.43786, 36.82347], [-121.43799, 36.82344], [-121.43812, 36.82337], [-121.43836, 36.82328], [-121.43857, 36.82324], [-121.43864, 36.82324], [-121.4387, 36.82327], [-121.43879, 36.82337], [-121.43902, 36.82371], [-121.43905, 36.82397], [-121.43905, 36.82403], [-121.43908, 36.8241], [-121.43914, 36.82414], [-121.43927, 36.82409], [-121.43966, 36.82409], [-121.43972, 36.82407], [-121.43979, 36.824], [-121.44082, 36.82373], [-121.44091, 36.82373], [-121.44104, 36.82378], [-121.44121, 36.82392], [-121.44146, 36.82409], [-121.44159, 36.82421], [-121.44173, 36.82429], [-121.44185, 36.82428], [-121.44208, 36.82423], [-121.44223, 36.82418], [-121.44235, 36.82413], [-121.44244, 36.82403], [-121.4425, 36.82393], [-121.44259, 36.82393], [-121.44289, 36.82454], [-121.44263, 36.825], [-121.44263, 36.82513], [-121.44265, 36.82519], [-121.44282, 36.82546], [-121.44278, 36.82567], [-121.44256, 36.82588], [-121.44242, 36.82597], [-121.44238, 36.82611], [-121.4425, 36.82615], [-121.44275, 36.8262], [-121.44295, 36.82632], [-121.44295, 36.82639], [-121.44293, 36.82651], [-121.44278, 36.82682], [-121.44266, 36.82702], [-121.44266, 36.82708], [-121.44302, 36.8271], [-121.44443, 36.82707], [-121.44666, 36.82701], [-121.44655, 36.82691], [-121.44656, 36.8267], [-121.4466, 36.82652], [-121.44661, 36.8262], [-121.44652, 36.82611], [-121.44642, 36.82604], [-121.44635, 36.82594], [-121.44615, 36.82549], [-121.44609, 36.82527], [-121.44607, 36.82512], [-121.44611, 36.82499], [-121.44609, 36.82486], [-121.44608, 36.82456], [-121.44612, 36.82449], [-121.44619, 36.82445], [-121.44628, 36.82444], [-121.4466, 36.82445], [-121.44688, 36.82443], [-121.44697, 36.82437], [-121.44699, 36.82425], [-121.44692, 36.82416], [-121.44685, 36.82402], [-121.44679, 36.82378], [-121.44673, 36.82365], [-121.44663, 36.82353], [-121.4466, 36.82343], [-121.44656, 36.82324], [-121.44649, 36.82309], [-121.44637, 36.82298], [-121.44634, 36.82277], [-121.44628, 36.82257], [-121.44614, 36.82242], [-121.44578, 36.82214], [-121.44571, 36.82207], [-121.44565, 36.82199], [-121.44562, 36.8218], [-121.44566, 36.82172], [-121.44571, 36.82155], [-121.44578, 36.82137], [-121.44585, 36.82124], [-121.44598, 36.82103], [-121.44602, 36.82099], [-121.44608, 36.82096], [-121.44631, 36.82091], [-121.44636, 36.82096], [-121.44644, 36.82096], [-121.44672, 36.82106], [-121.44734, 36.82137], [-121.44757, 36.82144], [-121.44782, 36.82142], [-121.44801, 36.82134], [-121.44825, 36.82131], [-121.44842, 36.82118], [-121.44852, 36.82108], [-121.44842, 36.821], [-121.44839, 36.82094], [-121.44837, 36.8208], [-121.4484, 36.82073], [-121.44868, 36.82059], [-121.44876, 36.82057], [-121.44883, 36.82049], [-121.44879, 36.82044], [-121.44847, 36.8202], [-121.44839, 36.82007], [-121.44837, 36.81967], [-121.44833, 36.81947], [-121.44829, 36.81938], [-121.4482, 36.81928], [-121.44819, 36.81921], [-121.44821, 36.819], [-121.44819, 36.81872], [-121.44851, 36.81842], [-121.44867, 36.81824], [-121.44867, 36.81812]]]} | No Public Access 3 | 48968 | San Justo Reservoir | 33666 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | https://www.cosb.us/county-departments/public-works/parks-recreation/regional-parks/san-justo/ | San Benito 38 | 281.271 | San Justo Reservoir | 0 | Resource Management Area 82 | 3 |
15851 | 15851 | 15850 | {"type": "Polygon", "coordinates": [[[-122.41973, 38.18637], [-122.41959, 38.18658], [-122.41933, 38.18683], [-122.41915, 38.18696], [-122.41892, 38.18707], [-122.41877, 38.18711], [-122.41845, 38.18716], [-122.41745, 38.18726], [-122.41494, 38.18742], [-122.41318, 38.18755], [-122.41097, 38.18769], [-122.4086, 38.18787], [-122.40807, 38.18789], [-122.40735, 38.18789], [-122.40637, 38.18787], [-122.40491, 38.18781], [-122.40366, 38.18775], [-122.40194, 38.18778], [-122.40183, 38.18781], [-122.40135, 38.18802], [-122.39969, 38.18868], [-122.39879, 38.189], [-122.39836, 38.18913], [-122.39776, 38.18928], [-122.39627, 38.18956], [-122.39572, 38.18969], [-122.3952, 38.18986], [-122.39494, 38.18996], [-122.39439, 38.19022], [-122.39395, 38.19045], [-122.39182, 38.1918], [-122.39144, 38.19208], [-122.39119, 38.19233], [-122.39095, 38.1926], [-122.3906, 38.19243], [-122.38982, 38.19296], [-122.38817, 38.19228], [-122.38616, 38.19298], [-122.38601, 38.19282], [-122.38598, 38.19276], [-122.38565, 38.19247], [-122.38493, 38.19193], [-122.38447, 38.19167], [-122.38408, 38.1915], [-122.38351, 38.19132], [-122.38295, 38.19122], [-122.3825, 38.19119], [-122.38227, 38.19116], [-122.38218, 38.19114], [-122.38207, 38.19116], [-122.38076, 38.19126], [-122.38071, 38.19128], [-122.38037, 38.19132], [-122.38027, 38.19136], [-122.37986, 38.19136], [-122.37964, 38.19132], [-122.37958, 38.19135], [-122.37943, 38.19137], [-122.37892, 38.19131], [-122.37825, 38.19116], [-122.37758, 38.19104], [-122.37725, 38.19094], [-122.377, 38.19081], [-122.37616, 38.19057], [-122.37546, 38.19026], [-122.37538, 38.19024], [-122.37442, 38.18977], [-122.37392, 38.18947], [-122.37341, 38.18887], [-122.37335, 38.18883], [-122.3732, 38.18864], [-122.37307, 38.18842], [-122.37293, 38.18804], [-122.37287, 38.18753], [-122.37287, 38.18716], [-122.37297, 38.18695], [-122.37312, 38.18672], [-122.37332, 38.1866], [-122.37359, 38.18648], [-122.37389, 38.18642], [-122.37424, 38.1864], [-122.375, 38.18631], [-122.37553, 38.1862], [-122.37626, 38.1859], [-122.37695, 38.18557], [-122.37742, 38.18525], [-122.37776, 38.18496], [-122.37869, 38.18401], [-122.37888, 38.18372], [-122.37898, 38.18364], [-122.37906, 38.1835], [-122.37907, 38.18345], [-122.37916, 38.18335], [-122.37947, 38.18275], [-122.37968, 38.18229], [-122.37968, 38.1822], [-122.37975, 38.18205], [-122.3798, 38.1819], [-122.37976, 38.18146], [-122.37969, 38.18124], [-122.37966, 38.18107], [-122.37959, 38.18101], [-122.37933, 38.18089], [-122.37891, 38.18063], [-122.37846, 38.18052], [-122.37819, 38.18049], [-122.37793, 38.1805], [-122.37782, 38.18054], [-122.37766, 38.18056], [-122.3769, 38.18083], [-122.37675, 38.18092], [-122.37647, 38.18102], [-122.37637, 38.18107], [-122.37616, 38.18115], [-122.37615, 38.18118], [-122.37595, 38.18128], [-122.37587, 38.18129], [-122.37582, 38.18134], [-122.37448, 38.18177], [-122.37424, 38.18181], [-122.37416, 38.18185], [-122.37381, 38.18186], [-122.37377, 38.18187], [-122.37333, 38.18193], [-122.3729, 38.18197], [-122.37282, 38.18195], [-122.37269, 38.182], [-122.37118, 38.18212], [-122.37012, 38.18227], [-122.36991, 38.18239], [-122.36965, 38.18249], [-122.36936, 38.18266], [-122.36884, 38.1831], [-122.3687, 38.18318], [-122.36858, 38.1832], [-122.3689, 38.18289], [-122.3693, 38.18234], [-122.3694, 38.182], [-122.36948, 38.18182], [-122.36956, 38.18151], [-122.36994, 38.18033], [-122.36999, 38.18013], [-122.37006, 38.17967], [-122.3702, 38.17839], [-122.37023, 38.17713], [-122.37018, 38.17621], [-122.37015, 38.17569], [-122.36997, 38.17417], [-122.36962, 38.17294], [-122.36911, 38.17188], [-122.36829, 38.17032], [-122.36792, 38.16953], [-122.36747, 38.16845], [-122.3673, 38.16794], [-122.36713, 38.16719], [-122.36703, 38.1666], [-122.36699, 38.16602], [-122.36698, 38.1646], [-122.36702, 38.16357], [-122.36704, 38.1633], [-122.36712, 38.16277], [-122.36722, 38.16237], [-122.3673, 38.16214], [-122.3674, 38.16191], [-122.36777, 38.1612], [-122.36806, 38.16079], [-122.36846, 38.1603], [-122.36869, 38.16005], [-122.36881, 38.15993], [-122.3691, 38.15973], [-122.36937, 38.1596], [-122.36997, 38.15938], [-122.37035, 38.15925], [-122.37082, 38.15914], [-122.37126, 38.15905], [-122.37175, 38.159], [-122.37199, 38.15899], [-122.37266, 38.159], [-122.37307, 38.15903], [-122.37369, 38.15914], [-122.37409, 38.15925], [-122.37505, 38.15958], [-122.3759, 38.15991], [-122.37673, 38.16017], [-122.37767, 38.1605], [-122.37957, 38.16118], [-122.38064, 38.16151], [-122.38197, 38.16184], [-122.3824, 38.16193], [-122.38282, 38.162], [-122.38308, 38.16202], [-122.38406, 38.16207], [-122.38439, 38.16205], [-122.38511, 38.16194], [-122.3857, 38.16192], [-122.38648, 38.16194], [-122.3873, 38.16202], [-122.38766, 38.16209], [-122.38828, 38.16224], [-122.38878, 38.16231], [-122.38946, 38.16236], [-122.39058, 38.1624], [-122.3916, 38.16239], [-122.39335, 38.16243], [-122.39441, 38.16242], [-122.39704, 38.16231], [-122.39805, 38.16225], [-122.39852, 38.1622], [-122.39947, 38.16206], [-122.40071, 38.16191], [-122.40177, 38.16173], [-122.40238, 38.1616], [-122.4033, 38.16136], [-122.40404, 38.16113], [-122.40566, 38.16051], [-122.40605, 38.16042], [-122.40646, 38.16039], [-122.40687, 38.16041], [-122.40722, 38.1605], [-122.40742, 38.16059], [-122.40758, 38.16071], [-122.40801, 38.1612], [-122.40852, 38.16164], [-122.40917, 38.16217], [-122.40951, 38.16235], [-122.41023, 38.1627], [-122.41097, 38.16299], [-122.41131, 38.16309], [-122.41231, 38.16333], [-122.41268, 38.16339], [-122.41309, 38.16342], [-122.41394, 38.1634], [-122.41433, 38.16334], [-122.41541, 38.16315], [-122.41642, 38.16292], [-122.41684, 38.16285], [-122.41712, 38.16285], [-122.41737, 38.16291], [-122.41746, 38.16297], [-122.41754, 38.16305], [-122.41759, 38.16313], [-122.41761, 38.16321], [-122.41761, 38.16342], [-122.41749, 38.1637], [-122.4174, 38.16383], [-122.41709, 38.16417], [-122.41627, 38.16498], [-122.41579, 38.16553], [-122.41526, 38.16631], [-122.41516, 38.16651], [-122.4149, 38.16694], [-122.41473, 38.16726], [-122.41444, 38.16789], [-122.41427, 38.16844], [-122.41416, 38.16892], [-122.41409, 38.16932], [-122.41403, 38.16988], [-122.414, 38.17051], [-122.414, 38.1711], [-122.41402, 38.17164], [-122.41416, 38.17237], [-122.4143, 38.17295], [-122.41442, 38.17369], [-122.41451, 38.17395], [-122.41457, 38.17411], [-122.41492, 38.17464], [-122.41512, 38.17523], [-122.41526, 38.17554], [-122.41567, 38.17674], [-122.41573, 38.17695], [-122.41597, 38.17753], [-122.41622, 38.17821], [-122.4169, 38.18035], [-122.41729, 38.18141], [-122.41756, 38.18205], [-122.41807, 38.18299], [-122.41855, 38.18375], [-122.41959, 38.1852], [-122.41983, 38.18559], [-122.41988, 38.18573], [-122.41991, 38.18584], [-122.4199, 38.18602], [-122.41985, 38.18618], [-122.41973, 38.18637]]]} | No Public Access 3 | 35054 | San Pablo Bay National Wildlife Refuge | 24962 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Sonoma 16 | 3078.154 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
16180 | 16180 | 16179 | {"type": "MultiPolygon", "coordinates": [[[[-117.97757, 34.12178], [-117.9774, 34.12192], [-117.9774, 34.12228], [-117.97719, 34.12242], [-117.9761, 34.12331], [-117.97597, 34.12347], [-117.97592, 34.12364], [-117.97592, 34.12496], [-117.97572, 34.12497], [-117.97572, 34.12361], [-117.97575, 34.12354], [-117.97573, 34.12353], [-117.97033, 34.12796], [-117.96982, 34.1286], [-117.96965, 34.12872], [-117.96884, 34.12872], [-117.96882, 34.13217], [-117.96572, 34.13217], [-117.96003, 34.1322], [-117.96003, 34.13218], [-117.95996, 34.13218], [-117.96081, 34.1308], [-117.9616, 34.12962], [-117.96161, 34.12952], [-117.96156, 34.12944], [-117.96209, 34.12877], [-117.96263, 34.12815], [-117.96318, 34.1276], [-117.96388, 34.12695], [-117.96407, 34.12708], [-117.96439, 34.12694], [-117.96447, 34.12642], [-117.96487, 34.12604], [-117.96506, 34.12602], [-117.96533, 34.12589], [-117.96635, 34.12499], [-117.96642, 34.12485], [-117.9666, 34.1247], [-117.96674, 34.12462], [-117.96994, 34.12141], [-117.97081, 34.12057], [-117.97169, 34.1198], [-117.9724, 34.11927], [-117.97292, 34.11891], [-117.97492, 34.11765], [-117.97707, 34.11638], [-117.97706, 34.1163], [-117.97756, 34.11602], [-117.97757, 34.12178]]], [[[-117.97438, 34.11716], [-117.9726, 34.11814], [-117.9704, 34.11989], [-117.9693, 34.12103], [-117.96627, 34.12393], [-117.96607, 34.12416], [-117.96466, 34.1255], [-117.96411, 34.12566], [-117.96337, 34.12638], [-117.9635, 34.12667], [-117.96095, 34.12911], [-117.96088, 34.12909], [-117.96081, 34.12909], [-117.96069, 34.12915], [-117.95848, 34.13159], [-117.95825, 34.1318], [-117.958, 34.13199], [-117.95766, 34.13221], [-117.95635, 34.13223], [-117.95357, 34.12911], [-117.94874, 34.13115], [-117.94872, 34.13114], [-117.94869, 34.13117], [-117.94872, 34.13114], [-117.95015, 34.13], [-117.95053, 34.12906], [-117.95066, 34.12822], [-117.95091, 34.12769], [-117.95132, 34.12694], [-117.95196, 34.12641], [-117.9525, 34.12614], [-117.95266, 34.1252], [-117.95313, 34.12443], [-117.95388, 34.12367], [-117.95497, 34.12298], [-117.95542, 34.12235], [-117.95639, 34.12138], [-117.95755, 34.12058], [-117.95858, 34.11969], [-117.95943, 34.11891], [-117.9599, 34.11834], [-117.95999, 34.10704], [-117.96089, 34.10702], [-117.9612, 34.10704], [-117.96166, 34.10709], [-117.96227, 34.10722], [-117.96281, 34.10741], [-117.96315, 34.10756], [-117.96341, 34.1077], [-117.96384, 34.10799], [-117.96462, 34.10857], [-117.96743, 34.11078], [-117.96841, 34.11146], [-117.97068, 34.11327], [-117.97102, 34.11352], [-117.97138, 34.11376], [-117.97188, 34.11404], [-117.97216, 34.11418], [-117.97288, 34.1153], [-117.97296, 34.11554], [-117.9731, 34.11575], [-117.97327, 34.11607], [-117.97332, 34.11632], [-117.97332, 34.11662], [-117.97328, 34.1169], [-117.97438, 34.11716]]], [[[-117.95056, 34.13285], [-117.95008, 34.13335], [-117.94879, 34.13434], [-117.94783, 34.1352], [-117.94707, 34.13546], [-117.94578, 34.13636], [-117.94447, 34.13772], [-117.94261, 34.1365], [-117.94298, 34.13616], [-117.94331, 34.13575], [-117.94405, 34.13496], [-117.94468, 34.13451], [-117.9457, 34.13373], [-117.94647, 34.1332], [-117.94681, 34.1329], [-117.94725, 34.13264], [-117.9477, 34.13231], [-117.94819, 34.13192], [-117.95011, 34.13262], [-117.95024, 34.13273], [-117.95056, 34.13285]]]]} | No Public Access 3 | 48161 | Santa Fe Dam Open Space | 32700 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 950.067 | Santa Fe Dam OS | 0 | Recreation Management Area 49 | 4 | |
16495 | 16495 | 16494 | {"type": "Polygon", "coordinates": [[[-117.16473, 32.66737], [-117.16316, 32.66872], [-117.16032, 32.66552], [-117.15991, 32.66503], [-117.1595, 32.66449], [-117.15649, 32.6603], [-117.15592, 32.65948], [-117.15535, 32.6586], [-117.15511, 32.65827], [-117.1549, 32.6579], [-117.15469, 32.65759], [-117.15381, 32.65642], [-117.15356, 32.65605], [-117.1533, 32.65555], [-117.15302, 32.65509], [-117.15274, 32.65456], [-117.15243, 32.65395], [-117.15204, 32.65331], [-117.15173, 32.65276], [-117.15042, 32.65008], [-117.15011, 32.64955], [-117.14975, 32.64907], [-117.14901, 32.64826], [-117.14839, 32.64751], [-117.1481, 32.64718], [-117.14787, 32.64688], [-117.14766, 32.64656], [-117.14744, 32.64616], [-117.14311, 32.63735], [-117.14449, 32.63689], [-117.14454, 32.63704], [-117.14467, 32.63727], [-117.14503, 32.63777], [-117.14512, 32.63797], [-117.1452, 32.63826], [-117.14545, 32.63873], [-117.14562, 32.63901], [-117.14614, 32.64002], [-117.14626, 32.64031], [-117.14644, 32.64064], [-117.14656, 32.64096], [-117.14691, 32.64169], [-117.14732, 32.6424], [-117.14779, 32.64331], [-117.14802, 32.64365], [-117.14816, 32.64397], [-117.14842, 32.64437], [-117.14861, 32.64471], [-117.1489, 32.64538], [-117.14897, 32.64562], [-117.14918, 32.64598], [-117.14982, 32.64691], [-117.15012, 32.64743], [-117.15027, 32.64776], [-117.15043, 32.64805], [-117.15066, 32.64835], [-117.1509, 32.64872], [-117.15173, 32.65013], [-117.15201, 32.65045], [-117.15258, 32.6512], [-117.15283, 32.65174], [-117.153, 32.65202], [-117.15319, 32.65226], [-117.15368, 32.65306], [-117.15389, 32.65331], [-117.15427, 32.65402], [-117.15477, 32.65474], [-117.15498, 32.65501], [-117.15564, 32.65609], [-117.15578, 32.6564], [-117.15593, 32.65663], [-117.15621, 32.65698], [-117.15658, 32.65739], [-117.15677, 32.65757], [-117.15694, 32.65776], [-117.1571, 32.65799], [-117.15739, 32.65851], [-117.15755, 32.65871], [-117.15793, 32.65906], [-117.15812, 32.65921], [-117.15889, 32.66005], [-117.15929, 32.66077], [-117.15946, 32.66097], [-117.15963, 32.66114], [-117.15988, 32.66144], [-117.16003, 32.66169], [-117.16021, 32.66217], [-117.16029, 32.66237], [-117.16043, 32.66261], [-117.16064, 32.66286], [-117.16114, 32.66336], [-117.16165, 32.66393], [-117.16187, 32.66422], [-117.1621, 32.66445], [-117.1626, 32.66505], [-117.16307, 32.66571], [-117.16331, 32.66598], [-117.16363, 32.66625], [-117.16425, 32.66694], [-117.16448, 32.66717], [-117.16473, 32.66737]]]} | No Public Access 3 | 47044 | Silver Strand State Beach | 30694 | 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 | 198 | United States Department of Defense 504 | Federal 1 | Federal Agency 1 | http://www.parks.ca.gov/?page_id=654 | San Diego 4 | 158.394 | Silver Strand SB | 1932 | None 1409 | |
710 | 710 | 709 | {"type": "Polygon", "coordinates": [[[-122.49778, 38.11503], [-122.49513, 38.11705], [-122.49391, 38.11801], [-122.49231, 38.1192], [-122.49241, 38.1189], [-122.49275, 38.11856], [-122.49311, 38.11825], [-122.49339, 38.11787], [-122.49376, 38.11735], [-122.49389, 38.11699], [-122.49396, 38.11668], [-122.49396, 38.11519], [-122.49778, 38.11503]]]} | No Public Access 3 | 4004 | Sonoma Baylands | 25607 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Sonoma 16 | 14.555 | Sonoma Baylands | None 66 | |||
10878 | 10878 | 10877 | {"type": "MultiPolygon", "coordinates": [[[[-117.32716, 33.72027], [-117.32689, 33.72752], [-117.31839, 33.72757], [-117.31861, 33.7203], [-117.32716, 33.72027]]], [[[-117.31039, 33.7568], [-117.31032, 33.76045], [-117.30592, 33.76048], [-117.30594, 33.76415], [-117.30605, 33.76754], [-117.3103, 33.76747], [-117.31035, 33.77178], [-117.29745, 33.77181], [-117.29721, 33.76415], [-117.30165, 33.76414], [-117.30158, 33.76048], [-117.30157, 33.75686], [-117.29276, 33.7569], [-117.29272, 33.74989], [-117.30152, 33.74969], [-117.30148, 33.74227], [-117.30804, 33.7422], [-117.30816, 33.75315], [-117.31035, 33.75315], [-117.31039, 33.7568]]], [[[-117.33067, 33.779], [-117.33066, 33.78626], [-117.32959, 33.78627], [-117.32811, 33.78507], [-117.32677, 33.78628], [-117.32084, 33.78632], [-117.32084, 33.78506], [-117.31976, 33.78471], [-117.31977, 33.78633], [-117.31324, 33.78638], [-117.31322, 33.78508], [-117.31808, 33.78576], [-117.31809, 33.78575], [-117.31806, 33.78409], [-117.31321, 33.7834], [-117.3131, 33.77177], [-117.32611, 33.77174], [-117.3262, 33.77901], [-117.33067, 33.779]], [[-117.32398, 33.78262], [-117.32374, 33.78426], [-117.32848, 33.78436], [-117.3287, 33.78277], [-117.32398, 33.78262]], [[-117.32069, 33.77822], [-117.32128, 33.77763], [-117.3213, 33.77652], [-117.31982, 33.77677], [-117.32008, 33.77765], [-117.31962, 33.77767], [-117.31961, 33.7781], [-117.31906, 33.77812], [-117.31907, 33.77938], [-117.32013, 33.77939], [-117.32014, 33.77905], [-117.32069, 33.77904], [-117.32069, 33.77822]], [[-117.31975, 33.77446], [-117.3146, 33.77509], [-117.31459, 33.7751], [-117.31522, 33.77664], [-117.32036, 33.77601], [-117.32037, 33.77599], [-117.31975, 33.77446]], [[-117.32307, 33.77281], [-117.3212, 33.77332], [-117.32272, 33.77724], [-117.32458, 33.77672], [-117.32307, 33.77281]]], [[[-117.30888, 33.78636], [-117.30887, 33.80084], [-117.30457, 33.80084], [-117.30459, 33.78635], [-117.30888, 33.78636]]]]} | No Public Access 3 | 48554 | Steele Peak Reserve | 33271 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://rchca.us/159/Reserves | Riverside 10 | 1538.966 | Steele Peak Reserve | 0 | None 949 | |
15844 | 15844 | 15843 | {"type": "MultiPolygon", "coordinates": [[[[-121.50142, 38.43053], [-121.50116, 38.4307], [-121.50116, 38.43311], [-121.49772, 38.43419], [-121.49635, 38.43742], [-121.49086, 38.43957], [-121.48897, 38.43056], [-121.48891, 38.43054], [-121.50142, 38.43053]]], [[[-121.50288, 38.31759], [-121.50237, 38.31765], [-121.50282, 38.32038], [-121.50191, 38.32038], [-121.50147, 38.31774], [-121.50137, 38.31774], [-121.49836, 38.29949], [-121.49887, 38.29944], [-121.49888, 38.29943], [-121.49573, 38.28032], [-121.49674, 38.28031], [-121.50288, 38.31759]]]]} | No Public Access 3 | 44499 | Stone Lakes National Wildlife Refuge | 31515 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/refuge/stone_lakes/ | Sacramento 41 | 288.103 | Stone Lakes NWR | 1994 | National Wildlife Refuge 105 | 2 |
2768 | 2768 | 2767 | {"type": "Polygon", "coordinates": [[[-121.39863, 38.87619], [-121.38647, 38.87621], [-121.3864, 38.87334], [-121.38634, 38.86807], [-121.39569, 38.86804], [-121.39849, 38.86801], [-121.39863, 38.87619]]]} | No Public Access 3 | 21550 | US Air Force | 26741 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Placer 35 | 236.307 | US Air Force | 0 | Federal Other or Unknown 87 | 4 | ||
9848 | 9848 | 9847 | {"type": "Polygon", "coordinates": [[[-119.62642, 36.59749], [-119.62573, 36.5975], [-119.62574, 36.5981], [-119.62256, 36.59811], [-119.62256, 36.59635], [-119.62389, 36.59572], [-119.62388, 36.59489], [-119.6232, 36.59416], [-119.62192, 36.59418], [-119.62191, 36.59289], [-119.62419, 36.59288], [-119.6242, 36.59467], [-119.62497, 36.59528], [-119.62541, 36.59616], [-119.62639, 36.59616], [-119.62642, 36.59749]]]} | No Public Access 3 | 16838 | Young Pond Federal Wetlands/Selma Pres | 27789 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Fresno 9 | 29.786 | Young Pond Federal Wetlands/Selma Pres | 0 | Federal Other or Unknown 87 | 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]);