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_LEV = 1 sorted by MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |
8199 | 8199 | 8198 | {"type": "MultiPolygon", "coordinates": [[[[-118.41192, 34.30466], [-118.41068, 34.30557], [-118.40898, 34.30398], [-118.40892, 34.30416], [-118.41053, 34.30568], [-118.40755, 34.30785], [-118.40753, 34.3079], [-118.40684, 34.30791], [-118.40702, 34.30699], [-118.40687, 34.30638], [-118.40668, 34.30644], [-118.40655, 34.30641], [-118.40685, 34.30618], [-118.40733, 34.30605], [-118.40767, 34.3052], [-118.40766, 34.30519], [-118.40753, 34.30518], [-118.40761, 34.30442], [-118.40774, 34.30388], [-118.40879, 34.30236], [-118.40906, 34.30219], [-118.40936, 34.30229], [-118.40954, 34.30196], [-118.40968, 34.30176], [-118.41031, 34.30204], [-118.41001, 34.30253], [-118.41191, 34.30338], [-118.4117, 34.30415], [-118.41192, 34.30466]]], [[[-118.41297, 34.30697], [-118.41202, 34.30909], [-118.41195, 34.30938], [-118.41166, 34.30947], [-118.4113, 34.30955], [-118.41094, 34.3096], [-118.41057, 34.30961], [-118.40749, 34.3094], [-118.40745, 34.30938], [-118.40743, 34.30868], [-118.40746, 34.30848], [-118.4076, 34.30811], [-118.40756, 34.30807], [-118.41066, 34.3058], [-118.41184, 34.30691], [-118.41185, 34.30691], [-118.41187, 34.30669], [-118.41081, 34.30569], [-118.41208, 34.30477], [-118.4123, 34.30503], [-118.4125, 34.30531], [-118.41297, 34.30697]]], [[[-118.412, 34.31043], [-118.41147, 34.31141], [-118.4113, 34.31165], [-118.41041, 34.31081], [-118.4119, 34.30973], [-118.412, 34.31043]]], [[[-118.41175, 34.30962], [-118.4109, 34.31024], [-118.40853, 34.31197], [-118.40856, 34.30964], [-118.41057, 34.30978], [-118.41115, 34.30974], [-118.41141, 34.3097], [-118.41175, 34.30962]]], [[[-118.4089, 34.31192], [-118.40887, 34.31212], [-118.40862, 34.31212], [-118.4089, 34.31192], [-118.4089, 34.31192]]]]} | No Public Access 3 | 12454 | Lopez Reservoir and Dam | 21465 | 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 | 92.431 | Lopez Reservoir and Dam | 0 | Resource Management Area 82 | 3 | |
10037 | 10037 | 10036 | {"type": "Polygon", "coordinates": [[[-121.66722, 38.31411], [-121.65589, 38.31399], [-121.6561, 38.31289], [-121.65713, 38.30805], [-121.65856, 38.30184], [-121.6597, 38.29795], [-121.6597, 38.29787], [-121.66153, 38.28986], [-121.66267, 38.28866], [-121.66359, 38.28633], [-121.66466, 38.28568], [-121.66479, 38.28461], [-121.66689, 38.29213], [-121.66711, 38.29214], [-121.66704, 38.30674], [-121.66722, 38.31411]]]} | No Public Access 3 | 17394 | Little Holland Tract | 21338 | 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 | Solano 26 | 515.191 | Little Holland Tract | None 865 | |||
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 | |
911 | 911 | 910 | {"type": "Polygon", "coordinates": [[[-118.51445, 34.12995], [-118.51442, 34.13004], [-118.51434, 34.1301], [-118.51426, 34.13013], [-118.51414, 34.13012], [-118.51299, 34.12951], [-118.51312, 34.12943], [-118.5133, 34.12937], [-118.51381, 34.12933], [-118.51442, 34.12983], [-118.51445, 34.12991], [-118.51445, 34.12995]]]} | No Public Access 3 | 6367 | Encino Reservoir - Federal | 18670 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 1.48 | Encino Reservoir - Federal | 0 | Resource Management Area 82 | 3 | ||
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 | ||
11425 | 11425 | 11424 | {"type": "MultiPolygon", "coordinates": [[[[-121.3675, 38.67299], [-121.36388, 38.67606], [-121.36391, 38.67519], [-121.36103, 38.6752], [-121.36093, 38.67293], [-121.3675, 38.67299]]], [[[-121.38686, 38.71035], [-121.38621, 38.71061], [-121.38139, 38.71218], [-121.3813, 38.71244], [-121.38071, 38.71244], [-121.38078, 38.71216], [-121.38077, 38.71215], [-121.37652, 38.71218], [-121.37402, 38.71051], [-121.37491, 38.70982], [-121.37505, 38.70977], [-121.37599, 38.70985], [-121.37658, 38.71005], [-121.37976, 38.71], [-121.38052, 38.71011], [-121.38227, 38.71018], [-121.38356, 38.71001], [-121.38466, 38.70975], [-121.38501, 38.70956], [-121.38548, 38.70963], [-121.38581, 38.70997], [-121.38634, 38.71026], [-121.38686, 38.71035]]]]} | No Public Access 3 | 22268 | Other Federal | 23247 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Sacramento 41 | 79.009 | Other Federal | 0 | Federal Other or Unknown 87 | 4 | ||
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 |
10521 | 10521 | 10520 | {"type": "Polygon", "coordinates": [[[-120.47183, 34.44883], [-120.47144, 34.449], [-120.47129, 34.44918], [-120.47118, 34.44978], [-120.47079, 34.44977], [-120.47012, 34.45043], [-120.47039, 34.45085], [-120.47049, 34.45177], [-120.47094, 34.45243], [-120.47112, 34.45313], [-120.46995, 34.45295], [-120.4682, 34.45177], [-120.46784, 34.45151], [-120.46608, 34.44961], [-120.46763, 34.44895], [-120.46846, 34.44987], [-120.46939, 34.44969], [-120.46952, 34.44942], [-120.47003, 34.44924], [-120.47062, 34.44831], [-120.47106, 34.4485], [-120.4716, 34.44826], [-120.47177, 34.44827], [-120.47173, 34.44864], [-120.47183, 34.44883]]]} | No Public Access 3 | 18691 | Point Conception Lighthouse | 23846 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | Santa Barbara 7 | 29.617 | Point Conception Lighthouse | None 919 | |||
15783 | 15783 | 15782 | {"type": "Polygon", "coordinates": [[[-121.81021, 36.58246], [-121.8126, 36.58687], [-121.81296, 36.5874], [-121.81345, 36.58801], [-121.81381, 36.5884], [-121.81409, 36.58868], [-121.81471, 36.58921], [-121.81785, 36.59146], [-121.8184, 36.59189], [-121.81871, 36.59217], [-121.8191, 36.59255], [-121.81947, 36.59295], [-121.81981, 36.59336], [-121.82012, 36.59379], [-121.82034, 36.59412], [-121.82059, 36.59457], [-121.82082, 36.59504], [-121.82102, 36.5955], [-121.82118, 36.59598], [-121.82132, 36.59647], [-121.82141, 36.59693], [-121.82148, 36.59745], [-121.8215, 36.59772], [-121.82152, 36.59803], [-121.82151, 36.59851], [-121.82149, 36.59883], [-121.82143, 36.5993], [-121.82134, 36.59977], [-121.82127, 36.60008], [-121.82108, 36.6007], [-121.81926, 36.60546], [-121.81909, 36.60605], [-121.81897, 36.60664], [-121.81893, 36.60712], [-121.81893, 36.6076], [-121.81918, 36.61176], [-121.81918, 36.612], [-121.81914, 36.61248], [-121.81908, 36.61283], [-121.81899, 36.61319], [-121.81881, 36.61376], [-121.81861, 36.61422], [-121.81832, 36.61477], [-121.81804, 36.61519], [-121.81763, 36.6157], [-121.81711, 36.61625], [-121.81672, 36.61662], [-121.81629, 36.61695], [-121.81593, 36.6172], [-121.81555, 36.61742], [-121.81515, 36.61762], [-121.81474, 36.61779], [-121.81438, 36.61792], [-121.81016, 36.61926], [-121.80948, 36.61953], [-121.80884, 36.61984], [-121.80847, 36.62005], [-121.80811, 36.62028], [-121.80766, 36.6206], [-121.80734, 36.62085], [-121.80704, 36.62112], [-121.80675, 36.62141], [-121.80611, 36.62215], [-121.80572, 36.62254], [-121.8053, 36.62291], [-121.80484, 36.62324], [-121.80434, 36.62353], [-121.80371, 36.62384], [-121.80327, 36.62402], [-121.80189, 36.62449], [-121.80068, 36.6241], [-121.80006, 36.62373], [-121.79873, 36.62307], [-121.79847, 36.62287], [-121.79853, 36.62218], [-121.79819, 36.62198], [-121.79672, 36.62149], [-121.79488, 36.62077], [-121.79166, 36.61907], [-121.79075, 36.61837], [-121.7897, 36.61791], [-121.78774, 36.61868], [-121.7872, 36.61959], [-121.78678, 36.62097], [-121.78633, 36.62165], [-121.78623, 36.62231], [-121.78634, 36.62294], [-121.78627, 36.62426], [-121.78591, 36.62572], [-121.78632, 36.62625], [-121.78614, 36.62659], [-121.78584, 36.62705], [-121.78536, 36.62719], [-121.78235, 36.62871], [-121.77948, 36.63016], [-121.77929, 36.63025], [-121.77948, 36.63015], [-121.77931, 36.62978], [-121.7792, 36.62957], [-121.77912, 36.62947], [-121.77895, 36.62928], [-121.77832, 36.62874], [-121.7777, 36.62824], [-121.77636, 36.62728], [-121.77569, 36.62677], [-121.77546, 36.62663], [-121.77523, 36.62651], [-121.77447, 36.62622], [-121.77359, 36.6258], [-121.77335, 36.6257], [-121.773, 36.62559], [-121.77158, 36.62529], [-121.77125, 36.62525], [-121.77076, 36.62522], [-121.77052, 36.62524], [-121.77032, 36.62524], [-121.77011, 36.62519], [-121.76989, 36.6251], [-121.7696, 36.62502], [-121.76929, 36.62497], [-121.76894, 36.62495], [-121.76838, 36.62497], [-121.76819, 36.62503], [-121.76802, 36.62513], [-121.76791, 36.62526], [-121.76778, 36.62571], [-121.76767, 36.62619], [-121.7676, 36.62628], [-121.76752, 36.62631], [-121.76747, 36.62637], [-121.76741, 36.62648], [-121.76733, 36.62655], [-121.76718, 36.62664], [-121.7667, 36.62697], [-121.7662, 36.62728], [-121.76569, 36.62756], [-121.76506, 36.62787], [-121.76419, 36.62851], [-121.76375, 36.62879], [-121.76341, 36.62904], [-121.76257, 36.62991], [-121.76224, 36.63053], [-121.7618, 36.63145], [-121.76146, 36.63145], [-121.76104, 36.6315], [-121.76028, 36.63167], [-121.75872, 36.63174], [-121.75825, 36.63177], [-121.75799, 36.63176], [-121.7577, 36.63168], [-121.75743, 36.63158], [-121.7571, 36.63152], [-121.75674, 36.63149], [-121.75639, 36.63151], [-121.75594, 36.63166], [-121.75588, 36.63169], [-121.75571, 36.6322], [-121.75563, 36.63232], [-121.7556, 36.63239], [-121.75547, 36.63235], [-121.75542, 36.63231], [-121.75527, 36.63211], [-121.75516, 36.63202], [-121.75502, 36.63196], [-121.75486, 36.63194], [-121.75471, 36.63195], [-121.75427, 36.63204], [-121.75412, 36.63205], [-121.75398, 36.63204], [-121.75354, 36.63193], [-121.75242, 36.63176], [-121.75162, 36.63149], [-121.75133, 36.63143], [-121.75103, 36.63139], [-121.75052, 36.63138], [-121.75052, 36.6314], [-121.75063, 36.63163], [-121.74979, 36.63185], [-121.74936, 36.6319], [-121.74902, 36.63197], [-121.74874, 36.63207], [-121.7483, 36.63226], [-121.74799, 36.63237], [-121.74772, 36.63244], [-121.74725, 36.63271], [-121.74712, 36.63276], [-121.74623, 36.63292], [-121.74598, 36.633], [-121.74563, 36.63317], [-121.74541, 36.63331], [-121.74521, 36.63346], [-121.74504, 36.63356], [-121.74489, 36.63362], [-121.7445, 36.63365], [-121.74426, 36.63369], [-121.74411, 36.63374], [-121.74398, 36.63382], [-121.74368, 36.6341], [-121.74352, 36.6342], [-121.74278, 36.63452], [-121.74259, 36.63461], [-121.7424, 36.63468], [-121.74159, 36.63483], [-121.7415, 36.63488], [-121.74143, 36.63495], [-121.74126, 36.63525], [-121.74117, 36.63532], [-121.73969, 36.636], [-121.73962, 36.636], [-121.73945, 36.63594], [-121.73933, 36.63595], [-121.73892, 36.63609], [-121.73881, 36.63611], [-121.73705, 36.63605], [-121.73656, 36.63602], [-121.73595, 36.63568], [-121.73613, 36.63522], [-121.73618, 36.63498], [-121.73619, 36.6348], [-121.73616, 36.63449], [-121.73593, 36.63357], [-121.73592, 36.6333], [-121.73582, 36.63327], [-121.73588, 36.633], [-121.73596, 36.63283], [-121.73611, 36.63264], [-121.73629, 36.63246], [-121.73737, 36.63171], [-121.73757, 36.63153], [-121.7377, 36.63137], [-121.73779, 36.63125], [-121.73792, 36.63092], [-121.738, 36.63078], [-121.73816, 36.6306], [-121.73833, 36.63046], [-121.73893, 36.63012], [-121.73906, 36.63], [-121.73917, 36.62988], [-121.73929, 36.62967], [-121.73942, 36.62928], [-121.73956, 36.62896], [-121.74201, 36.62446], [-121.74207, 36.62447], [-121.74241, 36.62384], [-121.74264, 36.62352], [-121.74352, 36.62264], [-121.74369, 36.62244], [-121.74384, 36.62218], [-121.74404, 36.62162], [-121.74446, 36.62097], [-121.74449, 36.62087], [-121.74449, 36.62078], [-121.7444, 36.62016], [-121.74441, 36.61984], [-121.74446, 36.61953], [-121.74468, 36.61885], [-121.7447, 36.61861], [-121.74468, 36.61828], [-121.74464, 36.61801], [-121.74464, 36.6179], [-121.74485, 36.61709], [-121.74498, 36.61644], [-121.745, 36.61621], [-121.74499, 36.6159], [-121.74487, 36.61538], [-121.74471, 36.61448], [-121.74471, 36.61429], [-121.74479, 36.6139], [-121.74496, 36.61355], [-121.74505, 36.6134], [-121.74532, 36.61304], [-121.74539, 36.61288], [-121.74543, 36.61272], [-121.74549, 36.61213], [-121.74573, 36.6114], [-121.7459, 36.6111], [-121.74603, 36.61093], [-121.74633, 36.6106], [-121.74643, 36.61045], [-121.74651, 36.61029], [-121.74659, 36.61002], [-121.74661, 36.6095], [-121.74658, 36.60918], [-121.74637, 36.60843], [-121.74628, 36.60817], [-121.74613, 36.60789], [-121.74536, 36.6067], [-121.74506, 36.60614], [-121.74494, 36.60588], [-121.74461, 36.60498], [-121.74454, 36.60473], [-121.74448, 36.60418], [-121.74459, 36.60363], [-121.74481, 36.60299], [-121.7449, 36.60282], [-121.74502, 36.60268], [-121.74642, 36.60143], [-121.74746, 36.60069], [-121.74763, 36.60055], [-121.74776, 36.6004], [-121.74785, 36.60023], [-121.74792, 36.60005], [-121.74803, 36.59934], [-121.74833, 36.5983], [-121.74843, 36.59807], [-121.74854, 36.59784], [-121.74867, 36.59763], [-121.74886, 36.59737], [-121.74908, 36.59713], [-121.74943, 36.59681], [-121.75035, 36.59612], [-121.75096, 36.59577], [-121.75109, 36.59565], [-121.75119, 36.59552], [-121.75128, 36.59531], [-121.75147, 36.59411], [-121.75148, 36.5938], [-121.75145, 36.59287], [-121.75146, 36.59217], [-121.75149, 36.59199], [-121.75158, 36.5918], [-121.75174, 36.59162], [-121.75191, 36.5915], [-121.75227, 36.59129], [-121.75245, 36.59114], [-121.75258, 36.59096], [-121.75265, 36.59077], [-121.75266, 36.59058], [-121.75265, 36.59045], [-121.75261, 36.59033], [-121.75252, 36.59017], [-121.75226, 36.58987], [-121.75223, 36.58982], [-121.75222, 36.58972], [-121.75224, 36.58966], [-121.75234, 36.58955], [-121.75256, 36.58948], [-121.75535, 36.58961], [-121.75629, 36.59088], [-121.76021, 36.59295], [-121.76094, 36.59242], [-121.76146, 36.59215], [-121.76159, 36.592], [-121.76181, 36.59165], [-121.76202, 36.59151], [-121.76216, 36.59139], [-121.76225, 36.59128], [-121.76232, 36.59115], [-121.76252, 36.59052], [-121.76283, 36.59004], [-121.76287, 36.58989], [-121.76286, 36.58977], [-121.76277, 36.58953], [-121.76282, 36.58918], [-121.76284, 36.58872], [-121.76278, 36.58818], [-121.76271, 36.58797], [-121.76262, 36.5878], [-121.76252, 36.58766], [-121.76226, 36.5874], [-121.76195, 36.58719], [-121.76121, 36.58686], [-121.76115, 36.58682], [-121.76108, 36.58675], [-121.76085, 36.58628], [-121.76077, 36.58616], [-121.76059, 36.58596], [-121.76077, 36.58579], [-121.76098, 36.58564], [-121.7611, 36.58562], [-121.76135, 36.5856], [-121.76159, 36.58563], [-121.76245, 36.58594], [-121.76477, 36.5867], [-121.76504, 36.58678], [-121.76536, 36.58684], [-121.76688, 36.58698], [-121.76765, 36.58702], [-121.76838, 36.58707], [-121.76868, 36.58707], [-121.76947, 36.58702], [-121.76992, 36.58695], [-121.77039, 36.5868], [-121.77062, 36.58671], [-121.77087, 36.58657], [-121.7711, 36.58642], [-121.77146, 36.58614], [-121.77159, 36.58601], [-121.77168, 36.58587], [-121.77175, 36.58571], [-121.77179, 36.58555], [-121.77179, 36.58538], [-121.77156, 36.58407], [-121.77158, 36.5839], [-121.77168, 36.58372], [-121.7718, 36.58361], [-121.77271, 36.583], [-121.77309, 36.58279], [-121.77355, 36.58261], [-121.77392, 36.58251], [-121.77429, 36.58243], [-121.77689, 36.58216], [-121.77854, 36.58193], [-121.78318, 36.58083], [-121.78423, 36.58059], [-121.78444, 36.58055], [-121.78804, 36.58053], [-121.78838, 36.58051], [-121.78862, 36.58047], [-121.78886, 36.58041], [-121.78915, 36.58031], [-121.78965, 36.58008], [-121.79091, 36.57934], [-121.79113, 36.57923], [-121.79137, 36.57914], [-121.79178, 36.57903], [-121.7945, 36.57856], [-121.79506, 36.57859], [-121.79602, 36.57867], [-121.79743, 36.57883], [-121.79838, 36.57898], [-121.79931, 36.57915], [-121.80069, 36.57945], [-121.80205, 36.57981], [-121.80339, 36.58023], [-121.80835, 36.58205], [-121.80877, 36.58218], [-121.80934, 36.58232], [-121.81021, 36.58246]], [[-121.75407, 36.61906], [-121.75442, 36.61836], [-121.75513, 36.61766], [-121.75567, 36.61706], [-121.75618, 36.61659], [-121.75679, 36.61597], [-121.75645, 36.61577], [-121.75601, 36.61535], [-121.75539, 36.61584], [-121.75372, 36.61647], [-121.75347, 36.61505], [-121.75313, 36.61481], [-121.75304, 36.61471], [-121.75291, 36.61464], [-121.75275, 36.6146], [-121.75255, 36.61461], [-121.75239, 36.61466], [-121.75228, 36.61474], [-121.75219, 36.61485], [-121.75199, 36.61524], [-121.75183, 36.61565], [-121.75174, 36.61627], [-121.75169, 36.61637], [-121.75191, 36.61697], [-121.75166, 36.61763], [-121.75175, 36.61868], [-121.75156, 36.61895], [-121.75146, 36.61911], [-121.7513, 36.61928], [-121.75114, 36.61935], [-121.75095, 36.61933], [-121.75079, 36.61923], [-121.75009, 36.61932], [-121.74871, 36.61914], [-121.74854, 36.61918], [-121.74817, 36.61949], [-121.74805, 36.61934], [-121.74795, 36.61952], [-121.748, 36.61973], [-121.74806, 36.61988], [-121.74771, 36.62024], [-121.74788, 36.62116], [-121.74878, 36.6217], [-121.74932, 36.62134], [-121.75037, 36.6207], [-121.75122, 36.6201], [-121.75143, 36.61998], [-121.75169, 36.61989], [-121.75192, 36.61984], [-121.75229, 36.61981], [-121.75286, 36.6198], [-121.75312, 36.61976], [-121.7535, 36.61961], [-121.75366, 36.61952], [-121.75381, 36.6194], [-121.75392, 36.61928], [-121.75407, 36.61906]]]} | No Public Access 3 | 44545 | Fort Ord National Monument | 19008 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 198 | United States Department of Defense 504 | Federal 1 | Federal Agency 1 | Monterey 14 | 7393.654 | Fort Ord NM | 2012 | National Monument or Landmark 80 | 3 | |
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 |
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]);