units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
145 rows where ACCESS_TYP = 2 and AGNCY_TYP = 5 sorted by DES_TP
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_ID, AGNCY_NAME, LAYER, MNG_AG_ID, MNG_AG_LEV, PARK_URL, COUNTY, LABEL_NAME, YR_EST, GAP_STS
DES_TP 37
- State Conservation Area 96
- State Resource Management Area 7
- State Recreation Area 4
- State Park 3
- Local Recreation Area 2
- National Wildlife Refuge 2
- Local Park 1
- None 1
- State Other or Unknown 1
- State Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 15
- California Department of Fish and Wildlife 64
- University of California 43
- California Department of Parks and Recreation 10
- East Bay Regional Park District 5
- California State Coastal Conservancy 4
- California State Lands Commission 3
- Other State 3
- California Department of Water Resources 3
- San Luis Obispo, City of 2
- United States Fish and Wildlife Service 2
- San Diego State University 2
- The Nature Conservancy 1
- California State University Sonoma 1
- National Audubon Society 1
- Santa Barbara Trust for Historic Preservation 1
MNG_AG_TYP 7
ACCESS_TYP 1
- Restricted Access · 145 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16836 | 16836 | 16835 | {"type": "Polygon", "coordinates": [[[-121.88013, 38.03876], [-121.8799, 38.03947], [-121.87888, 38.03985], [-121.87938, 38.04057], [-121.87831, 38.04152], [-121.87674, 38.04095], [-121.8754, 38.04202], [-121.87585, 38.04277], [-121.87563, 38.04308], [-121.87538, 38.04357], [-121.87321, 38.04374], [-121.87163, 38.04436], [-121.86986, 38.04524], [-121.86868, 38.04556], [-121.86677, 38.04663], [-121.86586, 38.04647], [-121.86463, 38.04548], [-121.86456, 38.04549], [-121.86457, 38.04022], [-121.869, 38.04023], [-121.86901, 38.03651], [-121.86606, 38.03563], [-121.85991, 38.03561], [-121.85989, 38.04021], [-121.8644, 38.04022], [-121.86438, 38.04552], [-121.8629, 38.0458], [-121.86169, 38.04609], [-121.86089, 38.04681], [-121.86099, 38.04761], [-121.86205, 38.04829], [-121.86179, 38.04832], [-121.86114, 38.04802], [-121.86065, 38.04767], [-121.86064, 38.04741], [-121.86029, 38.04715], [-121.85877, 38.04615], [-121.85643, 38.04435], [-121.85513, 38.04328], [-121.85323, 38.04205], [-121.85256, 38.04052], [-121.85138, 38.03899], [-121.85147, 38.03731], [-121.85092, 38.03582], [-121.85024, 38.03499], [-121.85207, 38.03389], [-121.85368, 38.03368], [-121.85526, 38.03272], [-121.85876, 38.03221], [-121.8607, 38.03229], [-121.86306, 38.03258], [-121.86702, 38.03277], [-121.86921, 38.03335], [-121.87099, 38.03432], [-121.87408, 38.03568], [-121.87734, 38.03749], [-121.87896, 38.03836], [-121.88013, 38.03876]]]} | Restricted Access 2 | 3883 | Browns Island Regional Shoreline | 16445 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 600.69 | Browns Island Reg. Shoreline | 0 | Local Park 2 | 4 | |
4160 | 4160 | 4159 | {"type": "Polygon", "coordinates": [[[-120.88662, 35.44856], [-120.88637, 35.45027], [-120.88645, 35.45032], [-120.88642, 35.4505], [-120.88586, 35.45105], [-120.88586, 35.45146], [-120.88525, 35.45142], [-120.88432, 35.45064], [-120.88407, 35.45064], [-120.88393, 35.45085], [-120.88399, 35.45208], [-120.88455, 35.45256], [-120.88418, 35.45304], [-120.88415, 35.45371], [-120.8839, 35.45439], [-120.88401, 35.45467], [-120.88424, 35.45492], [-120.88421, 35.45504], [-120.88376, 35.45517], [-120.88362, 35.45533], [-120.8834, 35.45535], [-120.88331, 35.45503], [-120.88303, 35.45467], [-120.88301, 35.45368], [-120.88275, 35.45334], [-120.88275, 35.45295], [-120.88194, 35.45233], [-120.88186, 35.45206], [-120.88152, 35.45174], [-120.88105, 35.4519], [-120.88038, 35.45242], [-120.87968, 35.45347], [-120.8799, 35.45437], [-120.87906, 35.45428], [-120.87895, 35.45419], [-120.87878, 35.45309], [-120.87901, 35.45229], [-120.8792, 35.45201], [-120.87923, 35.45156], [-120.87886, 35.45137], [-120.87705, 35.45132], [-120.87688, 35.45142], [-120.87671, 35.45221], [-120.87649, 35.45251], [-120.87599, 35.4526], [-120.87548, 35.45263], [-120.87517, 35.45288], [-120.87456, 35.45298], [-120.87445, 35.45309], [-120.87433, 35.45364], [-120.87372, 35.45389], [-120.87347, 35.4538], [-120.87299, 35.45394], [-120.8728, 35.45449], [-120.87207, 35.45554], [-120.87193, 35.45584], [-120.87196, 35.45686], [-120.87224, 35.45712], [-120.87232, 35.45737], [-120.8721, 35.45788], [-120.87235, 35.45902], [-120.87246, 35.45911], [-120.87235, 35.45989], [-120.87221, 35.46014], [-120.8721, 35.46064], [-120.87196, 35.4608], [-120.87199, 35.46101], [-120.87249, 35.46145], [-120.8728, 35.46193], [-120.87275, 35.46245], [-120.87213, 35.46328], [-120.87213, 35.46352], [-120.87255, 35.46362], [-120.87263, 35.46371], [-120.87263, 35.46422], [-120.87247, 35.46431], [-120.8718, 35.46419], [-120.87138, 35.4638], [-120.87124, 35.46378], [-120.8704, 35.46435], [-120.87003, 35.46447], [-120.86979, 35.46441], [-120.86964, 35.46413], [-120.86987, 35.46408], [-120.87003, 35.46392], [-120.87006, 35.46374], [-120.86975, 35.4636], [-120.86953, 35.46305], [-120.86969, 35.46262], [-120.8695, 35.46245], [-120.86955, 35.46099], [-120.87, 35.46051], [-120.87003, 35.45989], [-120.86905, 35.459], [-120.86894, 35.45849], [-120.86849, 35.45829], [-120.86804, 35.45776], [-120.86782, 35.45758], [-120.86734, 35.45756], [-120.86703, 35.45772], [-120.86684, 35.45771], [-120.86687, 35.45751], [-120.86698, 35.45737], [-120.86748, 35.45714], [-120.86776, 35.45671], [-120.86785, 35.45618], [-120.8681, 35.45584], [-120.86874, 35.45584], [-120.86899, 35.45561], [-120.86924, 35.4549], [-120.86924, 35.45431], [-120.86905, 35.4541], [-120.86905, 35.45373], [-120.86924, 35.45339], [-120.86941, 35.45215], [-120.86997, 35.45099], [-120.87061, 35.45085], [-120.87114, 35.45041], [-120.87226, 35.4489], [-120.87237, 35.44762], [-120.87251, 35.44739], [-120.87324, 35.44691], [-120.87374, 35.44675], [-120.87486, 35.44663], [-120.87562, 35.44682], [-120.87599, 35.44713], [-120.87683, 35.44766], [-120.87803, 35.44766], [-120.8787, 35.44789], [-120.87918, 35.44787], [-120.87965, 35.44771], [-120.88021, 35.44775], [-120.88192, 35.44819], [-120.8827, 35.44819], [-120.88343, 35.44796], [-120.88662, 35.44856]]]} | Restricted Access 2 | 44743 | Whale Rock Reservoir | 27446 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 282.826 | Whale Rock Reservoir | 0 | Local Recreation Area 3 | 4 | |
6410 | 6410 | 6409 | {"type": "MultiPolygon", "coordinates": [[[[-120.85781, 35.47038], [-120.8576, 35.47052], [-120.85741, 35.47067], [-120.85723, 35.47086], [-120.8571, 35.47104], [-120.85699, 35.47122], [-120.85691, 35.47142], [-120.85681, 35.47178], [-120.85678, 35.47199], [-120.85565, 35.47199], [-120.85497, 35.47201], [-120.85379, 35.47197], [-120.8534, 35.47197], [-120.85344, 35.47036], [-120.85781, 35.47038]]], [[[-120.86826, 35.4694], [-120.86824, 35.47331], [-120.85682, 35.47326], [-120.85741, 35.47321], [-120.85761, 35.47316], [-120.85778, 35.47306], [-120.85828, 35.47261], [-120.85842, 35.47254], [-120.85857, 35.4725], [-120.85953, 35.47248], [-120.86111, 35.47272], [-120.86124, 35.47273], [-120.86386, 35.47235], [-120.86401, 35.47228], [-120.86412, 35.4722], [-120.86534, 35.47097], [-120.86548, 35.47086], [-120.86571, 35.47079], [-120.86695, 35.4706], [-120.8672, 35.47052], [-120.86744, 35.47039], [-120.86758, 35.47029], [-120.86772, 35.47015], [-120.86816, 35.46951], [-120.86826, 35.4694]]], [[[-120.88945, 35.45158], [-120.88818, 35.45144], [-120.88838, 35.45703], [-120.88624, 35.45705], [-120.88624, 35.4588], [-120.88128, 35.45883], [-120.87823, 35.46], [-120.87683, 35.45728], [-120.87511, 35.45676], [-120.87526, 35.46117], [-120.8775, 35.46112], [-120.87771, 35.46723], [-120.87532, 35.46729], [-120.87531, 35.4673], [-120.87557, 35.47469], [-120.87588, 35.47622], [-120.87722, 35.47508], [-120.87721, 35.47908], [-120.8759, 35.47975], [-120.87565, 35.47989], [-120.87539, 35.47989], [-120.87537, 35.47973], [-120.87514, 35.47898], [-120.87509, 35.47819], [-120.87504, 35.47807], [-120.87487, 35.47783], [-120.87482, 35.47768], [-120.87482, 35.47754], [-120.87491, 35.47734], [-120.87494, 35.47718], [-120.87493, 35.47704], [-120.87487, 35.47688], [-120.87474, 35.47671], [-120.87457, 35.47659], [-120.87438, 35.47654], [-120.87411, 35.47653], [-120.87405, 35.47651], [-120.874, 35.47647], [-120.87384, 35.47606], [-120.87366, 35.47572], [-120.87348, 35.47545], [-120.8729, 35.47469], [-120.87233, 35.47337], [-120.87221, 35.47316], [-120.87208, 35.47299], [-120.87195, 35.47286], [-120.87108, 35.47216], [-120.87052, 35.47141], [-120.87047, 35.47132], [-120.87046, 35.47124], [-120.87035, 35.46989], [-120.8703, 35.46968], [-120.87019, 35.46948], [-120.87003, 35.46929], [-120.86978, 35.46912], [-120.86953, 35.46901], [-120.86934, 35.46897], [-120.86918, 35.46895], [-120.86892, 35.46896], [-120.86862, 35.46902], [-120.86835, 35.46914], [-120.86819, 35.46926], [-120.86805, 35.4694], [-120.86762, 35.47002], [-120.86752, 35.47013], [-120.86733, 35.47029], [-120.8671, 35.47041], [-120.86682, 35.47049], [-120.86564, 35.47066], [-120.86539, 35.47075], [-120.86521, 35.47088], [-120.86402, 35.47209], [-120.86392, 35.47217], [-120.86379, 35.47222], [-120.86123, 35.47259], [-120.86113, 35.47259], [-120.85956, 35.47235], [-120.85857, 35.47236], [-120.85837, 35.47241], [-120.85818, 35.4725], [-120.85766, 35.47296], [-120.85755, 35.47303], [-120.85738, 35.47308], [-120.85686, 35.47312], [-120.85691, 35.47285], [-120.85694, 35.47257], [-120.85694, 35.47207], [-120.85696, 35.4719], [-120.85707, 35.47146], [-120.85718, 35.47122], [-120.85734, 35.47097], [-120.85759, 35.47071], [-120.85783, 35.47054], [-120.85806, 35.47042], [-120.85832, 35.47032], [-120.85864, 35.47026], [-120.8589, 35.47024], [-120.85915, 35.47025], [-120.86032, 35.47052], [-120.86065, 35.47058], [-120.86112, 35.4706], [-120.86141, 35.47058], [-120.86171, 35.47054], [-120.86194, 35.47047], [-120.86212, 35.47039], [-120.86231, 35.47027], [-120.86245, 35.47014], [-120.86254, 35.47002], [-120.86269, 35.46954], [-120.86271, 35.46939], [-120.86271, 35.46928], [-120.86268, 35.46913], [-120.86264, 35.469], [-120.86251, 35.46881], [-120.86227, 35.46857], [-120.86216, 35.46842], [-120.86209, 35.46828], [-120.86204, 35.46809], [-120.86203, 35.46792], [-120.86206, 35.46778], [-120.86233, 35.46702], [-120.86237, 35.46683], [-120.86238, 35.4667], [-120.86236, 35.46654], [-120.86228, 35.46627], [-120.86219, 35.46612], [-120.8621, 35.466], [-120.85959, 35.46311], [-120.85948, 35.46296], [-120.85933, 35.46265], [-120.85926, 35.46246], [-120.85924, 35.46231], [-120.85923, 35.46197], [-120.85927, 35.46173], [-120.86041, 35.45914], [-120.86057, 35.45894], [-120.8615, 35.45803], [-120.86159, 35.4579], [-120.86191, 35.45736], [-120.86203, 35.45721], [-120.86221, 35.45707], [-120.86294, 35.45662], [-120.86308, 35.45652], [-120.86421, 35.45532], [-120.86577, 35.45403], [-120.86593, 35.45386], [-120.86605, 35.4537], [-120.86614, 35.4535], [-120.86668, 35.45126], [-120.86676, 35.45107], [-120.86688, 35.45089], [-120.86819, 35.44942], [-120.86849, 35.44915], [-120.8689, 35.4489], [-120.86862, 35.44885], [-120.86915, 35.44846], [-120.86948, 35.44897], [-120.86973, 35.449], [-120.87005, 35.44868], [-120.87066, 35.44904], [-120.8713, 35.44837], [-120.87072, 35.448], [-120.87483, 35.44385], [-120.87733, 35.44296], [-120.87844, 35.44296], [-120.88138, 35.44564], [-120.88726, 35.44384], [-120.88744, 35.44401], [-120.88666, 35.44476], [-120.88671, 35.44593], [-120.88675, 35.44609], [-120.88685, 35.44609], [-120.88701, 35.44604], [-120.88715, 35.44596], [-120.88727, 35.44585], [-120.88734, 35.4457], [-120.88738, 35.44549], [-120.88738, 35.44535], [-120.88743, 35.44522], [-120.88749, 35.44511], [-120.88773, 35.44489], [-120.8882, 35.44523], [-120.88945, 35.45158]], [[-120.88637, 35.45027], [-120.88661, 35.44856], [-120.88343, 35.44796], [-120.8827, 35.44819], [-120.88192, 35.44819], [-120.88021, 35.44775], [-120.87965, 35.44771], [-120.87918, 35.44787], [-120.8787, 35.44789], [-120.87803, 35.44766], [-120.87683, 35.44766], [-120.87599, 35.44713], [-120.87562, 35.44682], [-120.87486, 35.44663], [-120.87374, 35.44675], [-120.87324, 35.44691], [-120.87251, 35.44739], [-120.87237, 35.44762], [-120.87226, 35.4489], [-120.87114, 35.45041], [-120.87061, 35.45085], [-120.86997, 35.45099], [-120.86941, 35.45215], [-120.86924, 35.45339], [-120.86905, 35.45373], [-120.86905, 35.4541], [-120.86924, 35.4543], [-120.86924, 35.4549], [-120.86899, 35.45561], [-120.86874, 35.45584], [-120.86809, 35.45584], [-120.86785, 35.45618], [-120.86776, 35.45671], [-120.86748, 35.45714], [-120.86698, 35.45737], [-120.86687, 35.45751], [-120.86684, 35.4577], [-120.86685, 35.45772], [-120.86703, 35.45772], [-120.86734, 35.45756], [-120.86782, 35.45758], [-120.86804, 35.45776], [-120.86849, 35.45829], [-120.86894, 35.45849], [-120.86905, 35.459], [-120.87003, 35.45989], [-120.87, 35.46051], [-120.86955, 35.46099], [-120.8695, 35.46245], [-120.86969, 35.46261], [-120.86953, 35.46305], [-120.86975, 35.4636], [-120.87006, 35.46374], [-120.87003, 35.46392], [-120.86987, 35.46408], [-120.86965, 35.46413], [-120.86979, 35.46441], [-120.87003, 35.46447], [-120.87039, 35.46435], [-120.87124, 35.46378], [-120.87137, 35.4638], [-120.8718, 35.46419], [-120.87247, 35.46431], [-120.87263, 35.46421], [-120.87263, 35.46371], [-120.87255, 35.46362], [-120.87213, 35.46353], [-120.87213, 35.46328], [-120.87275, 35.46245], [-120.8728, 35.46193], [-120.87249, 35.46145], [-120.87199, 35.46101], [-120.87196, 35.4608], [-120.8721, 35.46064], [-120.87221, 35.46014], [-120.87235, 35.45989], [-120.87246, 35.45911], [-120.87235, 35.45902], [-120.8721, 35.45787], [-120.87232, 35.45737], [-120.87224, 35.45712], [-120.87196, 35.45687], [-120.87193, 35.45584], [-120.87207, 35.45554], [-120.8728, 35.45449], [-120.87299, 35.45394], [-120.87347, 35.4538], [-120.87372, 35.45389], [-120.87433, 35.45364], [-120.87445, 35.45309], [-120.87456, 35.45298], [-120.87517, 35.45288], [-120.87548, 35.45263], [-120.87599, 35.4526], [-120.87649, 35.45251], [-120.87671, 35.45221], [-120.87688, 35.45141], [-120.87705, 35.45132], [-120.87887, 35.45137], [-120.87923, 35.45155], [-120.8792, 35.45201], [-120.87901, 35.45229], [-120.87878, 35.45309], [-120.87895, 35.45419], [-120.87906, 35.45428], [-120.87989, 35.45436], [-120.87968, 35.45347], [-120.88038, 35.45242], [-120.88105, 35.4519], [-120.88152, 35.45174], [-120.88186, 35.45206], [-120.88195, 35.45233], [-120.88275, 35.45295], [-120.88275, 35.45334], [-120.88301, 35.45368], [-120.88303, 35.45467], [-120.88331, 35.45503], [-120.8834, 35.45535], [-120.88362, 35.45533], [-120.88376, 35.45517], [-120.88421, 35.45503], [-120.88423, 35.45492], [-120.88401, 35.45467], [-120.8839, 35.4544], [-120.88415, 35.45371], [-120.88418, 35.45304], [-120.88454, 35.45256], [-120.88399, 35.45208], [-120.88393, 35.45085], [-120.88407, 35.45064], [-120.88432, 35.45064], [-120.88525, 35.45142], [-120.88585, 35.45146], [-120.88586, 35.45105], [-120.88642, 35.4505], [-120.88645, 35.45032], [-120.88637, 35.45027]]], [[[-120.86618, 35.45263], [-120.86596, 35.4535], [-120.8659, 35.45364], [-120.86578, 35.4538], [-120.86565, 35.45393], [-120.8641, 35.45522], [-120.86296, 35.45642], [-120.86284, 35.45652], [-120.86209, 35.45697], [-120.86188, 35.45714], [-120.86175, 35.45731], [-120.86143, 35.45786], [-120.86135, 35.45797], [-120.86044, 35.45885], [-120.86029, 35.45902], [-120.8602, 35.45918], [-120.85971, 35.4603], [-120.85972, 35.45707], [-120.86166, 35.45708], [-120.86208, 35.45655], [-120.86321, 35.45569], [-120.86444, 35.45449], [-120.86519, 35.45416], [-120.86614, 35.45262], [-120.86618, 35.45263]]], [[[-120.87522, 35.47989], [-120.87432, 35.4799], [-120.87421, 35.47782], [-120.87294, 35.47949], [-120.87296, 35.47504], [-120.87333, 35.47552], [-120.87351, 35.47578], [-120.87365, 35.47605], [-120.87383, 35.47648], [-120.87387, 35.47656], [-120.87396, 35.47663], [-120.87406, 35.47666], [-120.87436, 35.47667], [-120.87447, 35.4767], [-120.8746, 35.47679], [-120.87472, 35.47695], [-120.87476, 35.47707], [-120.87477, 35.47718], [-120.87474, 35.47731], [-120.87466, 35.47752], [-120.87465, 35.47772], [-120.87471, 35.47786], [-120.8749, 35.47815], [-120.87493, 35.47823], [-120.87497, 35.47898], [-120.8752, 35.47976], [-120.87522, 35.47989]]], [[[-120.88888, 35.44363], [-120.8874, 35.44494], [-120.8872, 35.44475], [-120.88722, 35.44433], [-120.88762, 35.44398], [-120.88832, 35.4437], [-120.8887, 35.44344], [-120.88888, 35.44363]]]]} | Restricted Access 2 | 1848 | Whale Rock Reservoir | 27446 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1098.807 | Whale Rock Reservoir | 0 | Local Recreation Area 3 | 4 | |
402 | 402 | 401 | {"type": "Polygon", "coordinates": [[[-118.76991, 36.21538], [-118.76991, 36.21538], [-118.76726, 36.21538], [-118.76735, 36.21517], [-118.76842, 36.21452], [-118.76948, 36.21436], [-118.76989, 36.21437], [-118.76991, 36.21538]]]} | Restricted Access 2 | 1556 | Springville Ecological Reserve | 25751 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Tulare 29 | 4.947 | Springville ER | 0 | State Conservation Area 8 | 2 | |
467 | 467 | 466 | {"type": "Polygon", "coordinates": [[[-122.16678, 41.6422], [-122.16586, 41.64234], [-122.15522, 41.64335], [-122.15336, 41.64329], [-122.15338, 41.6426], [-122.15402, 41.64246], [-122.15464, 41.64228], [-122.15675, 41.64146], [-122.15726, 41.64123], [-122.15778, 41.64105], [-122.15814, 41.64095], [-122.15861, 41.64084], [-122.15908, 41.64077], [-122.15956, 41.64072], [-122.16013, 41.64069], [-122.16071, 41.64071], [-122.16118, 41.64076], [-122.16164, 41.64083], [-122.16305, 41.64119], [-122.16522, 41.64179], [-122.16586, 41.64201], [-122.16678, 41.6422]]]} | Restricted Access 2 | 921 | Grass Lake Wildlife Area | 19448 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 44.169 | Grass Lake Wildlife Area | 0 | State Conservation Area 8 | 2 | |
631 | 631 | 630 | {"type": "Polygon", "coordinates": [[[-122.25462, 39.99416], [-122.2544, 40.00129], [-122.25096, 40.00128], [-122.24748, 40.00133], [-122.24757, 39.99403], [-122.24456, 39.99402], [-122.23507, 39.99405], [-122.23535, 39.98688], [-122.23987, 39.98679], [-122.2466, 39.98672], [-122.25062, 39.98668], [-122.25422, 39.9867], [-122.25416, 39.99039], [-122.25416, 39.99414], [-122.25462, 39.99416]]]} | Restricted Access 2 | 4792 | Thomes Creek Ecological Reserve | 26310 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Tehama 18 | 442.371 | Thomes Creek ER | 0 | State Conservation Area 8 | 2 | |
655 | 655 | 654 | {"type": "Polygon", "coordinates": [[[-122.60188, 38.34223], [-122.60099, 38.34219], [-122.59824, 38.34219], [-122.59784, 38.34221], [-122.59674, 38.34238], [-122.59579, 38.34284], [-122.59514, 38.34423], [-122.59427, 38.34493], [-122.59333, 38.34522], [-122.59334, 38.34582], [-122.59113, 38.34633], [-122.5913, 38.34768], [-122.59135, 38.34828], [-122.5912, 38.3487], [-122.59122, 38.34925], [-122.59128, 38.34926], [-122.5913, 38.34965], [-122.59261, 38.35027], [-122.59275, 38.35752], [-122.58592, 38.35768], [-122.58582, 38.35554], [-122.5836, 38.35559], [-122.58354, 38.34758], [-122.58768, 38.34758], [-122.58754, 38.34322], [-122.5927, 38.34315], [-122.59271, 38.33808], [-122.59176, 38.33786], [-122.59079, 38.33744], [-122.58972, 38.33705], [-122.58885, 38.33685], [-122.588, 38.3368], [-122.58729, 38.33644], [-122.5869, 38.33609], [-122.58626, 38.33575], [-122.58571, 38.33561], [-122.58518, 38.33551], [-122.58545, 38.33521], [-122.58614, 38.33528], [-122.58697, 38.33561], [-122.58767, 38.33622], [-122.58824, 38.33643], [-122.58911, 38.33648], [-122.58974, 38.33662], [-122.5905, 38.33687], [-122.59169, 38.33743], [-122.5927, 38.33768], [-122.59271, 38.33767], [-122.59272, 38.33589], [-122.60179, 38.33588], [-122.60186, 38.34013], [-122.60188, 38.34223]], [[-122.5906, 38.3493], [-122.59059, 38.34928], [-122.59046, 38.34931], [-122.59053, 38.34931], [-122.5906, 38.3493]]]} | Restricted Access 2 | 3269 | Fairfield Osborn Preserve | 18798 | 211 | California State University Sonoma 232 | State 5 | State Agency 5 | http://www.sonoma.edu/ | Other State 5 | 211 | California State University Sonoma 228 | State 5 | State Agency 5 | Sonoma 16 | 414.364 | Fairfield Osborn Preserve | 2004 | State Conservation Area 8 | 2 | |
1522 | 1522 | 1521 | {"type": "Polygon", "coordinates": [[[-117.23496, 33.27233], [-117.23496, 33.27267], [-117.23179, 33.27604], [-117.23077, 33.27536], [-117.2336, 33.27235], [-117.23496, 33.27233]]]} | Restricted Access 2 | 12834 | San Luis Rey River Ecological Reserve | 24942 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 14.153 | San Luis Rey River ER | 0 | State Conservation Area 8 | 2 | |
1947 | 1947 | 1946 | {"type": "MultiPolygon", "coordinates": [[[[-118.98159, 36.05067], [-118.98137, 36.05079], [-118.9727, 36.05085], [-118.9718, 36.05081], [-118.97127, 36.05076], [-118.9708, 36.0507], [-118.97091, 36.0439], [-118.98041, 36.04394], [-118.98036, 36.04846], [-118.98039, 36.04883], [-118.98043, 36.04901], [-118.98052, 36.04928], [-118.98064, 36.04953], [-118.98074, 36.0497], [-118.98091, 36.04994], [-118.98105, 36.05009], [-118.98123, 36.05026], [-118.98148, 36.05046], [-118.98159, 36.05067]]], [[[-118.98205, 36.04396], [-118.98203, 36.04531], [-118.98196, 36.05048], [-118.98172, 36.05031], [-118.98148, 36.05012], [-118.98129, 36.04993], [-118.9811, 36.0497], [-118.98094, 36.04945], [-118.98084, 36.04924], [-118.98075, 36.04901], [-118.98068, 36.04874], [-118.98065, 36.04846], [-118.9807, 36.04394], [-118.98205, 36.04396]]]]} | Restricted Access 2 | 29177 | Yaudanchi Ecological Reserve | 27765 | 220 | California Department of Health Services 459 | State 5 | State Agency 5 | http://www.dhcs.ca.gov/Pages/default.aspx | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Tulare 29 | 184.306 | Yaudanchi ER | 0 | State Conservation Area 8 | 2 | |
2637 | 2637 | 2636 | {"type": "Polygon", "coordinates": [[[-122.93426, 38.43681], [-122.93107, 38.43684], [-122.92903, 38.43689], [-122.92899, 38.4368], [-122.92897, 38.4367], [-122.92903, 38.43623], [-122.92908, 38.43609], [-122.92928, 38.43568], [-122.92964, 38.43476], [-122.92971, 38.43446], [-122.92971, 38.43416], [-122.92954, 38.43343], [-122.92954, 38.43324], [-122.93106, 38.43321], [-122.93269, 38.43323], [-122.93271, 38.43595], [-122.93425, 38.43597], [-122.93426, 38.43681]]]} | Restricted Access 2 | 3289 | Harrison Grade Ecological Reserve | 19698 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sonoma 16 | 31.802 | Harrison Grade ER | 0 | State Conservation Area 8 | 2 | |
2782 | 2782 | 2781 | {"type": "Polygon", "coordinates": [[[-123.95018, 40.54432], [-123.95, 40.54774], [-123.95168, 40.56229], [-123.94988, 40.57504], [-123.93142, 40.57538], [-123.91977, 40.57531], [-123.91927, 40.56181], [-123.91363, 40.56177], [-123.91412, 40.55814], [-123.91933, 40.55809], [-123.91986, 40.5472], [-123.92568, 40.54733], [-123.92481, 40.53266], [-123.92997, 40.53268], [-123.94513, 40.53325], [-123.94448, 40.54416], [-123.95018, 40.54432]]]} | Restricted Access 2 | 21606 | Owl Creek Ecological Reserve | 23278 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Humboldt 45 | 2772.208 | Owl Creek ER | 0 | State Conservation Area 8 | 2 | |
2891 | 2891 | 2890 | {"type": "Polygon", "coordinates": [[[-122.27421, 40.4766], [-122.26995, 40.47661], [-122.27039, 40.47569], [-122.26864, 40.47525], [-122.26863, 40.47425], [-122.26907, 40.47419], [-122.26994, 40.47387], [-122.27012, 40.47395], [-122.27418, 40.4704], [-122.27421, 40.4766]]]} | Restricted Access 2 | 18920 | Clover Creek Ecological Reserve | 17434 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Shasta 27 | 46.643 | Clover Creek ER | 0 | State Conservation Area 8 | 2 | |
3108 | 3108 | 3107 | {"type": "MultiPolygon", "coordinates": [[[[-121.46234, 38.2686], [-121.46231, 38.26876], [-121.46161, 38.26911], [-121.46002, 38.26922], [-121.45923, 38.26938], [-121.45839, 38.2697], [-121.45775, 38.26965], [-121.45753, 38.26953], [-121.45774, 38.2673], [-121.45781, 38.26714], [-121.4579, 38.2664], [-121.45801, 38.26606], [-121.4583, 38.26581], [-121.45862, 38.26576], [-121.45932, 38.26588], [-121.46083, 38.2659], [-121.46118, 38.26624], [-121.46112, 38.26713], [-121.46132, 38.26782], [-121.46167, 38.26823], [-121.46211, 38.2684], [-121.46234, 38.2686]]], [[[-121.68459, 38.14478], [-121.68456, 38.14487], [-121.68445, 38.14505], [-121.68418, 38.14541], [-121.68404, 38.14611], [-121.68393, 38.14638], [-121.68387, 38.14656], [-121.68386, 38.14674], [-121.68389, 38.14684], [-121.6838, 38.14733], [-121.68366, 38.14777], [-121.68363, 38.148], [-121.68355, 38.14839], [-121.68327, 38.14912], [-121.68318, 38.14929], [-121.68312, 38.1493], [-121.68345, 38.14644], [-121.68406, 38.14476], [-121.68459, 38.14478]]]]} | Restricted Access 2 | 25288 | Cosumnes River Preserve | 17678 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 35.364 | Cosumnes River Preserve | 0 | State Conservation Area 8 | 2 | ||
3143 | 3143 | 3142 | {"type": "Polygon", "coordinates": [[[-123.31692, 41.78208], [-123.31238, 41.78212], [-123.31239, 41.78306], [-123.31239, 41.78456], [-123.31192, 41.78442], [-123.31147, 41.78461], [-123.31048, 41.78493], [-123.30981, 41.7853], [-123.30965, 41.78553], [-123.30965, 41.78579], [-123.30984, 41.78586], [-123.31041, 41.78733], [-123.31076, 41.7877], [-123.31092, 41.78773], [-123.31167, 41.78838], [-123.3121, 41.7889], [-123.31224, 41.78911], [-123.3121, 41.79128], [-123.30773, 41.79128], [-123.30674, 41.7913], [-123.30302, 41.79125], [-123.30307, 41.78826], [-123.30306, 41.78463], [-123.30294, 41.78141], [-123.30779, 41.78136], [-123.30782, 41.78299], [-123.31011, 41.78297], [-123.31011, 41.78135], [-123.31238, 41.78128], [-123.31236, 41.77967], [-123.31684, 41.77957], [-123.31692, 41.78208]]]} | Restricted Access 2 | 21593 | China Point Ecological Reserve | 17203 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 209.418 | China Point ER | 0 | State Conservation Area 8 | 2 | |
3672 | 3672 | 3671 | {"type": "MultiPolygon", "coordinates": [[[[-120.44871, 34.6888], [-120.44792, 34.69026], [-120.4478, 34.69035], [-120.44763, 34.69033], [-120.44725, 34.69018], [-120.44662, 34.68998], [-120.44669, 34.6899], [-120.44679, 34.6897], [-120.44724, 34.68935], [-120.44815, 34.68888], [-120.44871, 34.6888]]], [[[-120.4499, 34.69128], [-120.44987, 34.69127], [-120.44986, 34.69126], [-120.44856, 34.69068], [-120.44826, 34.69059], [-120.44812, 34.69043], [-120.44817, 34.69018], [-120.44916, 34.6887], [-120.44971, 34.68869], [-120.44982, 34.68905], [-120.45004, 34.69], [-120.45006, 34.69067], [-120.4499, 34.69128]]]]} | Restricted Access 2 | 29691 | Burton Mesa Ecological Reserve | 16533 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Burton-Mesa-ER | Santa Barbara 7 | 11.989 | Burton Mesa ER | 2004 | State Conservation Area 8 | 2 |
3803 | 3803 | 3802 | {"type": "MultiPolygon", "coordinates": [[[[-122.10658, 38.5004], [-122.09761, 38.50035], [-122.09774, 38.50434], [-122.09775, 38.50723], [-122.09305, 38.50723], [-122.093, 38.50397], [-122.09232, 38.49092], [-122.09697, 38.4909], [-122.09687, 38.4893], [-122.09688, 38.48804], [-122.0969, 38.48794], [-122.09688, 38.4865], [-122.09693, 38.48236], [-122.10164, 38.48238], [-122.10165, 38.48207], [-122.10631, 38.48211], [-122.10633, 38.48923], [-122.1065, 38.49317], [-122.10655, 38.49628], [-122.10658, 38.5004]]], [[[-122.1064, 38.50769], [-122.10633, 38.50813], [-122.10619, 38.50846], [-122.1061, 38.5086], [-122.10598, 38.5087], [-122.10582, 38.50877], [-122.10572, 38.50879], [-122.10561, 38.50879], [-122.10518, 38.50894], [-122.10504, 38.50897], [-122.10464, 38.50918], [-122.10452, 38.50932], [-122.10427, 38.5095], [-122.1042, 38.50947], [-122.10212, 38.50969], [-122.10231, 38.50753], [-122.10582, 38.50758], [-122.1064, 38.50769]]]]} | Restricted Access 2 | 35111 | Stebbins Cold Canyon Reserve | 25816 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Solano 26 | 606.446 | Stebbins Cold Canyon Reserve | 0 | State Conservation Area 8 | 2 | |
4262 | 4262 | 4261 | {"type": "Polygon", "coordinates": [[[-121.62968, 39.20461], [-121.62981, 39.20619], [-121.62965, 39.20795], [-121.62916, 39.20791], [-121.62904, 39.20973], [-121.62892, 39.21023], [-121.6284, 39.21125], [-121.62609, 39.21031], [-121.62113, 39.20758], [-121.62141, 39.20654], [-121.62161, 39.20636], [-121.62186, 39.20629], [-121.62207, 39.20629], [-121.62247, 39.20646], [-121.62262, 39.20647], [-121.62275, 39.20645], [-121.62321, 39.20669], [-121.62321, 39.2069], [-121.62365, 39.20717], [-121.62403, 39.2072], [-121.62491, 39.20722], [-121.62613, 39.20712], [-121.62637, 39.20707], [-121.62787, 39.20585], [-121.62845, 39.2055], [-121.6291, 39.20513], [-121.62953, 39.20457], [-121.62968, 39.20461]]]} | Restricted Access 2 | 47979 | Feather River Wildlife Area | 18861 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sutter 47 | 61.666 | Feather River Wildlife Area | 1991 | State Conservation Area 8 | 2 | |
5503 | 5503 | 5502 | {"type": "MultiPolygon", "coordinates": [[[[-117.24645, 33.15192], [-117.24325, 33.15203], [-117.24295, 33.1512], [-117.24431, 33.15105], [-117.24644, 33.15036], [-117.24645, 33.15192]]], [[[-117.26182, 33.14925], [-117.26138, 33.14958], [-117.25936, 33.14941], [-117.25864, 33.14971], [-117.2584, 33.14977], [-117.25816, 33.14977], [-117.25744, 33.14967], [-117.25731, 33.14967], [-117.25716, 33.14971], [-117.25701, 33.14979], [-117.25667, 33.15004], [-117.25655, 33.15019], [-117.25648, 33.15037], [-117.25635, 33.1512], [-117.25631, 33.1513], [-117.25622, 33.15142], [-117.25586, 33.15176], [-117.25562, 33.15211], [-117.25053, 33.15267], [-117.25006, 33.1537], [-117.24851, 33.15389], [-117.24842, 33.1523], [-117.24819, 33.15211], [-117.24806, 33.15211], [-117.24804, 33.15188], [-117.24906, 33.14891], [-117.24789, 33.14895], [-117.24624, 33.14851], [-117.24658, 33.14758], [-117.24459, 33.14705], [-117.24455, 33.14478], [-117.24659, 33.1439], [-117.24672, 33.1458], [-117.26179, 33.1458], [-117.26182, 33.14925]]]]} | Restricted Access 2 | 12865 | Dawson Los Monos Canyon Reserve | 17958 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | San Diego 4 | 231.903 | Dawson Los Monos Canyon Reserve | 0 | State Conservation Area 8 | 2 | |
5616 | 5616 | 5615 | {"type": "Polygon", "coordinates": [[[-121.98643, 41.98971], [-121.98471, 41.98982], [-121.98397, 41.98981], [-121.98405, 41.98862], [-121.98362, 41.98838], [-121.98299, 41.98775], [-121.98219, 41.98654], [-121.98206, 41.9848], [-121.98209, 41.98398], [-121.98344, 41.98364], [-121.98392, 41.98368], [-121.98459, 41.98424], [-121.98537, 41.98492], [-121.98567, 41.98547], [-121.98574, 41.9857], [-121.98581, 41.98656], [-121.98605, 41.98813], [-121.98625, 41.98891], [-121.98643, 41.98971]]]} | Restricted Access 2 | 2421 | Mud Lake Wildlife Area | 22583 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 40.351 | Mud Lake Wildlife Area | 0 | State Conservation Area 8 | 2 | |
5757 | 5757 | 5756 | {"type": "Polygon", "coordinates": [[[-118.06308, 33.71148], [-118.0591, 33.71135], [-118.05909, 33.71137], [-118.05916, 33.71145], [-118.0591, 33.71145], [-118.0529, 33.70379], [-118.05255, 33.70376], [-118.05209, 33.70383], [-118.05126, 33.7045], [-118.05053, 33.70499], [-118.04992, 33.70528], [-118.04939, 33.70559], [-118.04839, 33.70627], [-118.04758, 33.70679], [-118.04721, 33.70696], [-118.0473, 33.70706], [-118.04645, 33.70713], [-118.0451, 33.7068], [-118.04429, 33.70664], [-118.04277, 33.7066], [-118.04262, 33.70639], [-118.03926, 33.70783], [-118.03874, 33.70808], [-118.03248, 33.7108], [-118.03236, 33.71026], [-118.0385, 33.70771], [-118.03856, 33.70759], [-118.04008, 33.70696], [-118.04008, 33.70694], [-118.03929, 33.70619], [-118.0362, 33.70457], [-118.0348, 33.70349], [-118.0343, 33.70285], [-118.03222, 33.70268], [-118.03233, 33.70084], [-118.03007, 33.70098], [-118.02774, 33.69924], [-118.02442, 33.69685], [-118.02392, 33.69652], [-118.02288, 33.69605], [-118.02167, 33.69532], [-118.02083, 33.69486], [-118.02092, 33.69004], [-118.0209, 33.68917], [-118.02053, 33.68916], [-118.02115, 33.68814], [-118.02114, 33.68806], [-118.02204, 33.68651], [-118.02221, 33.68641], [-118.02252, 33.68592], [-118.02297, 33.68566], [-118.02347, 33.68548], [-118.02404, 33.68539], [-118.02475, 33.68495], [-118.02488, 33.68482], [-118.02499, 33.68461], [-118.02516, 33.68437], [-118.02565, 33.68424], [-118.02733, 33.68355], [-118.02777, 33.68348], [-118.02863, 33.68372], [-118.03085, 33.6841], [-118.03152, 33.68436], [-118.03221, 33.68471], [-118.03276, 33.68458], [-118.03308, 33.68442], [-118.03319, 33.6839], [-118.0338, 33.68341], [-118.03355, 33.68309], [-118.03361, 33.68286], [-118.03424, 33.68245], [-118.03919, 33.68737], [-118.04395, 33.69223], [-118.04773, 33.69635], [-118.05291, 33.70154], [-118.05401, 33.7027], [-118.05549, 33.70404], [-118.05874, 33.70712], [-118.06037, 33.70878], [-118.06086, 33.70921], [-118.06308, 33.71148]]]} | Restricted Access 2 | 6996 | Bolsa Chica Ecological Reserve | 16245 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bolsa-Chica-ER | Orange 3 | 1223.82 | Bolsa Chica ER | 1993 | State Conservation Area 8 | 2 |
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]);