units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
137 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 5 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_WEB, LAYER, YR_EST
DES_TP 30
- State Resource Management Area 64
- State Conservation Area 22
- State Other or Unknown 18
- State Park 5
- State Historic or Cultural Area 3
- None 1
- None 1
- State Recreation 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
MNG_AGENCY 16
- California Department of Fish and Wildlife 79
- California Department of Parks and Recreation 15
- California Department of Water Resources 11
- California Department of General Services 10
- California Department of Transportation 5
- University of California 3
- California Department of Forestry and Fire Protection 2
- California Wildlife Conservation Board 2
- Coachella Valley Mountains Conservancy 2
- California Tahoe Conservancy 2
- California State Lands Commission 1
- Other State 1
- Napa Valley College 1
- San Diego State University 1
- California State University 1
- California State Coastal Conservancy 1
MNG_AG_TYP 1
- State Agency · 137 ✖
ACCESS_TYP 1
- No Public Access · 137 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25 | 25 | 24 | {"type": "Polygon", "coordinates": [[[-122.27747, 38.29885], [-122.27706, 38.29891], [-122.27702, 38.29871], [-122.27743, 38.29865], [-122.27747, 38.29885]]]} | No Public Access 3 | 64 | Real Estate Services Division | 24211 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 0.203 | Real Estate Services Division | None 6 | |||
228 | 228 | 227 | {"type": "Polygon", "coordinates": [[[-122.33028, 41.31414], [-122.32908, 41.31415], [-122.32909, 41.31022], [-122.32966, 41.31067], [-122.33018, 41.31094], [-122.33021, 41.31196], [-122.33028, 41.31197], [-122.33028, 41.31414]]]} | No Public Access 3 | 621 | Elsa Rupp Natural Area | 32160 | 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 | 9.475 | Elsa Rupp Natural Area | None 26 | |||
3155 | 3155 | 3154 | {"type": "Polygon", "coordinates": [[[-121.52015, 38.36105], [-121.52, 38.36138], [-121.51988, 38.36172], [-121.51976, 38.36228], [-121.51967, 38.36299], [-121.51968, 38.36374], [-121.51983, 38.36443], [-121.51986, 38.3652], [-121.51994, 38.36596], [-121.52002, 38.3666], [-121.51995, 38.36694], [-121.51977, 38.3671], [-121.51892, 38.36686], [-121.51857, 38.36669], [-121.51813, 38.36655], [-121.51157, 38.3651], [-121.51168, 38.35783], [-121.51938, 38.36011], [-121.51901, 38.36077], [-121.52015, 38.36105]]]} | No Public Access 3 | 21762 | Hood Test Facilities | 30565 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Sacramento 41 | 136.958 | Hood Test Facilities | None 257 | |||
3159 | 3159 | 3158 | {"type": "Polygon", "coordinates": [[[-121.50125, 38.31704], [-121.50005, 38.31773], [-121.49878, 38.31973], [-121.49852, 38.31959], [-121.4985, 38.3196], [-121.49847, 38.31958], [-121.4946, 38.31753], [-121.49279, 38.31453], [-121.50082, 38.31445], [-121.50125, 38.31704]]]} | No Public Access 3 | 21834 | Stone Lakes | 25871 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 68.284 | Stone Lakes | None 259 | ||||
3312 | 3312 | 3311 | {"type": "Polygon", "coordinates": [[[-117.05061, 34.06564], [-117.05016, 34.06761], [-117.04942, 34.06795], [-117.04771, 34.06692], [-117.04766, 34.06428], [-117.04902, 34.06452], [-117.05061, 34.06564]]]} | No Public Access 3 | 29659 | Crafton Hills Reservoir | 17748 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | San Bernardino 22 | 19.391 | Crafton Hills Reservoir | None 270 | |||
4180 | 4180 | 4179 | {"type": "Polygon", "coordinates": [[[-121.7562, 37.72355], [-121.75619, 37.73783], [-121.75386, 37.73785], [-121.7539, 37.7308], [-121.7516, 37.73078], [-121.75166, 37.72355], [-121.7562, 37.72355]]]} | No Public Access 3 | 1793 | Livermore Monitoring Station | 21382 | 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 | Alameda 17 | 119.329 | Livermore Monitoring Station | None 362 | |||
4997 | 4997 | 4996 | {"type": "MultiPolygon", "coordinates": [[[[-121.75097, 38.02973], [-121.75096, 38.02988], [-121.75091, 38.02999], [-121.7508, 38.03011], [-121.75067, 38.03021], [-121.75066, 38.03348], [-121.75049, 38.03373], [-121.75057, 38.03399], [-121.75066, 38.0345], [-121.75057, 38.03485], [-121.75042, 38.03525], [-121.75026, 38.03557], [-121.75002, 38.03593], [-121.74656, 38.0404], [-121.7461, 38.04058], [-121.74559, 38.04097], [-121.74501, 38.04152], [-121.74449, 38.04205], [-121.74346, 38.04297], [-121.74298, 38.04337], [-121.74281, 38.04355], [-121.74204, 38.04416], [-121.74186, 38.04425], [-121.73988, 38.04576], [-121.73894, 38.04643], [-121.7379, 38.04731], [-121.73753, 38.04778], [-121.73726, 38.04824], [-121.73706, 38.04872], [-121.73702, 38.04908], [-121.73702, 38.04932], [-121.73707, 38.04961], [-121.73724, 38.04981], [-121.73741, 38.0499], [-121.73743, 38.04996], [-121.73779, 38.05011], [-121.73799, 38.04995], [-121.73886, 38.04963], [-121.73922, 38.04953], [-121.73953, 38.04947], [-121.73916, 38.04998], [-121.73891, 38.05038], [-121.7386, 38.051], [-121.73844, 38.05143], [-121.73831, 38.05186], [-121.73822, 38.05231], [-121.73816, 38.05275], [-121.73814, 38.05344], [-121.73788, 38.05344], [-121.73767, 38.05363], [-121.7378, 38.05375], [-121.73792, 38.05388], [-121.73805, 38.0541], [-121.73811, 38.05434], [-121.73811, 38.05494], [-121.73825, 38.05494], [-121.73825, 38.05799], [-121.73816, 38.05853], [-121.73841, 38.05872], [-121.73807, 38.05932], [-121.73721, 38.06113], [-121.73259, 38.07805], [-121.73245, 38.07843], [-121.73224, 38.07878], [-121.73196, 38.07909], [-121.73173, 38.07929], [-121.73136, 38.07953], [-121.73108, 38.07967], [-121.72021, 38.07867], [-121.71656, 38.07513], [-121.71372, 38.07532], [-121.71361, 38.08124], [-121.71069, 38.08124], [-121.71068, 38.08379], [-121.71044, 38.0839], [-121.70998, 38.08416], [-121.70968, 38.08435], [-121.70937, 38.0846], [-121.70892, 38.08505], [-121.70865, 38.08537], [-121.70844, 38.08575], [-121.70806, 38.08617], [-121.70793, 38.08641], [-121.70767, 38.08675], [-121.70736, 38.08729], [-121.70728, 38.08746], [-121.70724, 38.08777], [-121.70699, 38.08838], [-121.70697, 38.08857], [-121.70687, 38.08892], [-121.70673, 38.08912], [-121.70658, 38.08936], [-121.70651, 38.08979], [-121.70643, 38.0901], [-121.70639, 38.09101], [-121.70638, 38.0929], [-121.70493, 38.0929], [-121.70492, 38.09425], [-121.70516, 38.09425], [-121.70516, 38.09497], [-121.70638, 38.09498], [-121.70638, 38.09524], [-121.70643, 38.09554], [-121.70642, 38.09646], [-121.7064, 38.09694], [-121.70641, 38.09761], [-121.70653, 38.09918], [-121.70652, 38.09959], [-121.70629, 38.09956], [-121.70634, 38.09807], [-121.70627, 38.09806], [-121.70633, 38.09752], [-121.70632, 38.09682], [-121.70603, 38.09684], [-121.70603, 38.09754], [-121.70599, 38.09792], [-121.70592, 38.09829], [-121.70368, 38.09802], [-121.70362, 38.09925], [-121.70546, 38.09947], [-121.70514, 38.09997], [-121.70289, 38.10309], [-121.70043, 38.1031], [-121.70034, 38.10497], [-121.70017, 38.10487], [-121.69922, 38.10449], [-121.6986, 38.10431], [-121.69775, 38.10415], [-121.69723, 38.10409], [-121.69694, 38.10408], [-121.69613, 38.10412], [-121.69572, 38.10425], [-121.69528, 38.10441], [-121.69511, 38.10424], [-121.69417, 38.10424], [-121.69485, 38.10104], [-121.69699, 38.09521], [-121.68982, 38.09513], [-121.68989, 38.09282], [-121.68676, 38.0928], [-121.68675, 38.09213], [-121.68677, 38.09161], [-121.68676, 38.09107], [-121.68675, 38.09087], [-121.68669, 38.09043], [-121.68668, 38.09024], [-121.68673, 38.08974], [-121.68675, 38.0892], [-121.68673, 38.08897], [-121.68676, 38.08854], [-121.6867, 38.08832], [-121.6867, 38.08786], [-121.68674, 38.08761], [-121.68674, 38.08721], [-121.6867, 38.08699], [-121.68668, 38.08675], [-121.68663, 38.08652], [-121.68652, 38.08613], [-121.68628, 38.08551], [-121.68828, 38.08552], [-121.68829, 38.08551], [-121.68557, 38.08016], [-121.68513, 38.07479], [-121.68361, 38.07478], [-121.68365, 38.07467], [-121.68367, 38.07432], [-121.68365, 38.07369], [-121.68352, 38.07232], [-121.68338, 38.0712], [-121.68336, 38.07081], [-121.68331, 38.07045], [-121.68327, 38.07001], [-121.68321, 38.06969], [-121.68305, 38.0681], [-121.68292, 38.06711], [-121.68292, 38.06708], [-121.68467, 38.06738], [-121.68551, 38.06563], [-121.68669, 38.06415], [-121.68771, 38.0628], [-121.68899, 38.06169], [-121.68899, 38.06168], [-121.68638, 38.06103], [-121.6878, 38.05985], [-121.68915, 38.05893], [-121.68977, 38.05854], [-121.69028, 38.05819], [-121.69106, 38.05756], [-121.69278, 38.05839], [-121.69445, 38.05699], [-121.69313, 38.05592], [-121.69428, 38.05498], [-121.69539, 38.05387], [-121.69598, 38.05331], [-121.69675, 38.05266], [-121.69717, 38.05235], [-121.69778, 38.05195], [-121.69879, 38.05122], [-121.69941, 38.05256], [-121.7018, 38.05183], [-121.70182, 38.05005], [-121.7024, 38.05], [-121.70344, 38.04993], [-121.70369, 38.04987], [-121.70409, 38.04973], [-121.70451, 38.04953], [-121.70566, 38.04868], [-121.70639, 38.04817], [-121.70694, 38.04786], [-121.70746, 38.04752], [-121.70808, 38.04719], [-121.70883, 38.04686], [-121.70959, 38.04657], [-121.70958, 38.0486], [-121.71085, 38.04861], [-121.71088, 38.04614], [-121.71197, 38.04568], [-121.71292, 38.04533], [-121.71368, 38.04506], [-121.71489, 38.04471], [-121.71556, 38.04449], [-121.71681, 38.04411], [-121.71801, 38.04364], [-121.71846, 38.04344], [-121.71847, 38.0441], [-121.72007, 38.0441], [-121.72007, 38.04444], [-121.72075, 38.04445], [-121.72077, 38.04222], [-121.72141, 38.0419], [-121.72237, 38.04149], [-121.7225, 38.0414], [-121.72267, 38.04131], [-121.72348, 38.041], [-121.72391, 38.04076], [-121.72416, 38.0406], [-121.72468, 38.04016], [-121.72469, 38.04025], [-121.72597, 38.04026], [-121.72598, 38.04008], [-121.72613, 38.04006], [-121.72624, 38.03963], [-121.72617, 38.03923], [-121.72641, 38.03906], [-121.72691, 38.03875], [-121.72691, 38.03853], [-121.72712, 38.03844], [-121.72806, 38.03787], [-121.72843, 38.03766], [-121.72906, 38.03722], [-121.72985, 38.03676], [-121.73036, 38.0365], [-121.73025, 38.05199], [-121.73027, 38.052], [-121.73033, 38.05197], [-121.73055, 38.03639], [-121.73147, 38.03584], [-121.73265, 38.03525], [-121.7334, 38.03495], [-121.73381, 38.03471], [-121.73439, 38.03442], [-121.73438, 38.0365], [-121.73611, 38.03651], [-121.73601, 38.04899], [-121.735, 38.04918], [-121.73499, 38.04986], [-121.73481, 38.04981], [-121.7337, 38.05019], [-121.7337, 38.05043], [-121.73371, 38.05043], [-121.73475, 38.04996], [-121.73619, 38.05009], [-121.73632, 38.03515], [-121.74491, 38.03218], [-121.74492, 38.0305], [-121.7452, 38.0304], [-121.7462, 38.03032], [-121.74657, 38.03032], [-121.74687, 38.0303], [-121.74726, 38.03023], [-121.74832, 38.03015], [-121.74865, 38.03011], [-121.7492, 38.02999], [-121.74976, 38.02994], [-121.75006, 38.02987], [-121.7505, 38.0298], [-121.75097, 38.02973]], [[-121.70718, 38.08676], [-121.70717, 38.08675], [-121.70696, 38.08668], [-121.70656, 38.08697], [-121.7065, 38.08708], [-121.70692, 38.08723], [-121.70718, 38.08676]], [[-121.73709, 38.05029], [-121.73688, 38.05021], [-121.7362, 38.0502], [-121.73619, 38.05055], [-121.73736, 38.05056], [-121.73737, 38.05029], [-121.73709, 38.05029]]], [[[-121.78398, 38.05752], [-121.78397, 38.06143], [-121.78055, 38.06307], [-121.7793, 38.0636], [-121.77906, 38.06366], [-121.77868, 38.0638], [-121.77587, 38.06499], [-121.77514, 38.06531], [-121.77454, 38.06563], [-121.7717, 38.067], [-121.7706, 38.06756], [-121.76971, 38.06809], [-121.76876, 38.06871], [-121.768, 38.06928], [-121.7677, 38.06955], [-121.76709, 38.0702], [-121.76608, 38.07105], [-121.76589, 38.07117], [-121.76565, 38.07033], [-121.76281, 38.07112], [-121.76286, 38.07203], [-121.76334, 38.07226], [-121.76321, 38.07227], [-121.76253, 38.07238], [-121.76267, 38.07204], [-121.76261, 38.07118], [-121.75933, 38.07209], [-121.75933, 38.07182], [-121.75932, 38.07181], [-121.75793, 38.07243], [-121.75759, 38.07197], [-121.7574, 38.07207], [-121.75772, 38.07253], [-121.75751, 38.07262], [-121.75718, 38.07218], [-121.75699, 38.07228], [-121.7573, 38.07271], [-121.75625, 38.07318], [-121.75597, 38.0728], [-121.7527, 38.07449], [-121.75189, 38.07138], [-121.75188, 38.07137], [-121.75175, 38.07149], [-121.75285, 38.07574], [-121.74713, 38.07856], [-121.7403, 38.0824], [-121.73591, 38.07985], [-121.7359, 38.07973], [-121.73571, 38.07972], [-121.73564, 38.08233], [-121.73558, 38.0823], [-121.73558, 38.07961], [-121.73262, 38.0796], [-121.73264, 38.07949], [-121.73264, 38.07938], [-121.73259, 38.07928], [-121.73251, 38.07916], [-121.73251, 38.07912], [-121.73278, 38.07877], [-121.73298, 38.07841], [-121.73312, 38.07804], [-121.73332, 38.07729], [-121.73353, 38.07732], [-121.73558, 38.06981], [-121.73604, 38.06988], [-121.73633, 38.06882], [-121.73587, 38.06874], [-121.73849, 38.05915], [-121.73888, 38.05851], [-121.73918, 38.05811], [-121.73952, 38.05772], [-121.74007, 38.05716], [-121.74068, 38.05664], [-121.74111, 38.05633], [-121.74156, 38.05603], [-121.74553, 38.05371], [-121.74605, 38.05337], [-121.74653, 38.05302], [-121.74698, 38.05268], [-121.74741, 38.05232], [-121.74741, 38.05243], [-121.74743, 38.05243], [-121.74788, 38.05203], [-121.74842, 38.05149], [-121.74892, 38.05093], [-121.74939, 38.05035], [-121.74982, 38.04975], [-121.75021, 38.04913], [-121.75056, 38.0485], [-121.75086, 38.04785], [-121.75112, 38.04719], [-121.75134, 38.04652], [-121.75146, 38.04607], [-121.75156, 38.04562], [-121.75167, 38.04494], [-121.75173, 38.04448], [-121.75175, 38.04402], [-121.75177, 38.04264], [-121.75119, 38.04265], [-121.75117, 38.04394], [-121.75114, 38.04438], [-121.75107, 38.04504], [-121.75099, 38.04548], [-121.75084, 38.04614], [-121.75065, 38.04679], [-121.75042, 38.04742], [-121.75014, 38.04805], [-121.74971, 38.04887], [-121.74921, 38.04966], [-121.74879, 38.05024], [-121.74833, 38.05079], [-121.748, 38.05116], [-121.74741, 38.05174], [-121.74741, 38.05196], [-121.74692, 38.05239], [-121.7464, 38.0528], [-121.74586, 38.05319], [-121.74534, 38.05353], [-121.74481, 38.05385], [-121.74162, 38.0557], [-121.74092, 38.05614], [-121.74048, 38.05647], [-121.73986, 38.05699], [-121.73929, 38.05756], [-121.73894, 38.05797], [-121.73845, 38.05772], [-121.73844, 38.05494], [-121.73858, 38.05493], [-121.73858, 38.05433], [-121.73855, 38.05416], [-121.73855, 38.0532], [-121.73858, 38.05277], [-121.73867, 38.05214], [-121.73878, 38.05172], [-121.73891, 38.05131], [-121.73918, 38.05071], [-121.73953, 38.05014], [-121.74005, 38.04944], [-121.74021, 38.04943], [-121.74071, 38.04945], [-121.74144, 38.04953], [-121.74203, 38.04961], [-121.74257, 38.04977], [-121.74287, 38.04993], [-121.74316, 38.05023], [-121.74329, 38.05045], [-121.74332, 38.05065], [-121.74326, 38.05101], [-121.74313, 38.05144], [-121.743, 38.05175], [-121.74282, 38.052], [-121.74265, 38.05213], [-121.7424, 38.05225], [-121.74184, 38.05242], [-121.74054, 38.05264], [-121.73993, 38.05269], [-121.73926, 38.05281], [-121.73904, 38.05287], [-121.73889, 38.05297], [-121.73879, 38.05312], [-121.73878, 38.0532], [-121.73891, 38.05319], [-121.739, 38.05304], [-121.73911, 38.05297], [-121.7393, 38.05292], [-121.73995, 38.0528], [-121.74056, 38.05275], [-121.74188, 38.05252], [-121.74246, 38.05235], [-121.74274, 38.05222], [-121.74293, 38.05206], [-121.74313, 38.05179], [-121.74326, 38.05147], [-121.7434, 38.05103], [-121.74346, 38.05065], [-121.74342, 38.05042], [-121.74328, 38.05018], [-121.74297, 38.04985], [-121.74264, 38.04968], [-121.74206, 38.04951], [-121.74146, 38.04942], [-121.74072, 38.04934], [-121.74014, 38.04932], [-121.74727, 38.04012], [-121.74727, 38.04003], [-121.74735, 38.03992], [-121.74814, 38.03992], [-121.74834, 38.03996], [-121.74864, 38.03996], [-121.7488, 38.03998], [-121.74918, 38.03997], [-121.74934, 38.04], [-121.74972, 38.04001], [-121.75061, 38.0401], [-121.75132, 38.04015], [-121.75136, 38.04024], [-121.75255, 38.0403], [-121.75324, 38.04042], [-121.75505, 38.0405], [-121.75565, 38.04051], [-121.75679, 38.04021], [-121.75754, 38.04025], [-121.75901, 38.04064], [-121.75938, 38.04087], [-121.75997, 38.04118], [-121.76039, 38.04161], [-121.76086, 38.04204], [-121.76128, 38.04252], [-121.76194, 38.04303], [-121.76246, 38.04346], [-121.76264, 38.04357], [-121.76259, 38.05329], [-121.76269, 38.05328], [-121.76275, 38.04351], [-121.76505, 38.04494], [-121.76606, 38.04549], [-121.76884, 38.04711], [-121.77018, 38.04783], [-121.77185, 38.04882], [-121.77331, 38.04963], [-121.77569, 38.05065], [-121.77675, 38.05134], [-121.77787, 38.05222], [-121.779, 38.05282], [-121.78043, 38.05324], [-121.78112, 38.0531], [-121.78113, 38.05744], [-121.78398, 38.05752]]], [[[-121.74639, 38.04062], [-121.73962, 38.04935], [-121.73951, 38.04936], [-121.73918, 38.04943], [-121.7388, 38.04953], [-121.73815, 38.04978], [-121.73799, 38.0498], [-121.73766, 38.04977], [-121.73747, 38.04974], [-121.73739, 38.0497], [-121.73727, 38.04955], [-121.73723, 38.04931], [-121.73723, 38.04909], [-121.73727, 38.04876], [-121.73746, 38.0483], [-121.73771, 38.04786], [-121.73806, 38.04742], [-121.73909, 38.04655], [-121.74002, 38.04588], [-121.74144, 38.0448], [-121.74195, 38.04434], [-121.74213, 38.04424], [-121.74291, 38.04363], [-121.74308, 38.04344], [-121.74356, 38.04304], [-121.7446, 38.04212], [-121.74511, 38.04159], [-121.74569, 38.04105], [-121.74618, 38.04067], [-121.74625, 38.04064], [-121.74639, 38.04062]]], [[[-121.75161, 38.02968], [-121.75157, 38.03314], [-121.75143, 38.03951], [-121.75125, 38.03946], [-121.75088, 38.03945], [-121.75047, 38.03941], [-121.74926, 38.03938], [-121.7489, 38.03935], [-121.74849, 38.03928], [-121.74835, 38.03927], [-121.74824, 38.03932], [-121.74808, 38.03942], [-121.74806, 38.03949], [-121.74808, 38.03963], [-121.74819, 38.03979], [-121.74801, 38.03986], [-121.74746, 38.03986], [-121.75038, 38.0361], [-121.75064, 38.0357], [-121.75088, 38.03522], [-121.75102, 38.03479], [-121.75117, 38.03411], [-121.75134, 38.03386], [-121.75134, 38.03373], [-121.75118, 38.03349], [-121.75119, 38.02971], [-121.75161, 38.02968]]], [[[-121.78448, 38.0395], [-121.78211, 38.04102], [-121.78376, 38.04636], [-121.78383, 38.04714], [-121.78037, 38.04977], [-121.78037, 38.04979], [-121.78067, 38.05004], [-121.7804, 38.05028], [-121.78006, 38.05001], [-121.77783, 38.0517], [-121.77717, 38.05116], [-121.77638, 38.05056], [-121.7749, 38.04988], [-121.77353, 38.04911], [-121.77176, 38.04825], [-121.77011, 38.04728], [-121.76864, 38.0464], [-121.76674, 38.04544], [-121.76611, 38.04508], [-121.76522, 38.04465], [-121.76385, 38.04385], [-121.76352, 38.04364], [-121.76333, 38.04346], [-121.76235, 38.04266], [-121.76072, 38.04105], [-121.76013, 38.04066], [-121.75956, 38.04035], [-121.75838, 38.03997], [-121.75701, 38.03985], [-121.75636, 38.03988], [-121.75507, 38.03977], [-121.75352, 38.03971], [-121.75333, 38.03969], [-121.75368, 38.02963], [-121.75475, 38.02963], [-121.75508, 38.0296], [-121.75597, 38.0296], [-121.75691, 38.02974], [-121.75736, 38.02976], [-121.75762, 38.02981], [-121.75789, 38.02983], [-121.75817, 38.02985], [-121.75842, 38.02982], [-121.75858, 38.02982], [-121.75928, 38.0299], [-121.75953, 38.0299], [-121.76003, 38.02996], [-121.76026, 38.02997], [-121.76044, 38.03], [-121.76086, 38.03015], [-121.76117, 38.03022], [-121.76151, 38.03032], [-121.76199, 38.0305], [-121.76227, 38.03064], [-121.76261, 38.03074], [-121.76269, 38.03085], [-121.76275, 38.03113], [-121.76288, 38.03125], [-121.76288, 38.03131], [-121.76281, 38.03144], [-121.76278, 38.03176], [-121.76273, 38.03181], [-121.76272, 38.03192], [-121.76281, 38.03196], [-121.76281, 38.03206], [-121.76293, 38.03224], [-121.76314, 38.03245], [-121.76335, 38.03259], [-121.76352, 38.03266], [-121.76378, 38.03281], [-121.76419, 38.03294], [-121.76471, 38.03306], [-121.76568, 38.03311], [-121.76651, 38.03311], [-121.7676, 38.03306], [-121.76851, 38.03294], [-121.76923, 38.03282], [-121.77002, 38.03261], [-121.77168, 38.03221], [-121.77202, 38.03214], [-121.77255, 38.03206], [-121.77271, 38.03211], [-121.77286, 38.0322], [-121.77299, 38.03234], [-121.77311, 38.03256], [-121.7733, 38.033], [-121.77356, 38.03339], [-121.77369, 38.03364], [-121.77438, 38.03428], [-121.7749, 38.03469], [-121.77575, 38.03532], [-121.77685, 38.0361], [-121.77927, 38.03746], [-121.78166, 38.03816], [-121.78238, 38.03842], [-121.78367, 38.03892], [-121.78424, 38.0392], [-121.78448, 38.0395]]]]} | No Public Access 3 | 21753 | Sherman Island | 25396 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Sacramento 41 | 9160.25 | Sherman Island | None 414 | |||
6462 | 6462 | 6461 | {"type": "Polygon", "coordinates": [[[-116.18721, 33.15378], [-116.18628, 33.1536], [-116.18497, 33.1533], [-116.18496, 33.15281], [-116.18721, 33.15378]]]} | No Public Access 3 | 2055 | Hwy 78 scenic corridor | 20163 | 3004 | Anza-Borrego Foundation 836 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.theabf.org/ | Non Governmental Organization 10 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | San Diego 4 | 1.475 | Hwy 78 scenic corridor | None 522 | |||
6493 | 6493 | 6492 | {"type": "Polygon", "coordinates": [[[-120.12173, 36.2483], [-120.12148, 36.2483], [-120.12147, 36.24807], [-120.10457, 36.24812], [-120.10456, 36.24822], [-120.10395, 36.24822], [-120.10394, 36.2482], [-120.10338, 36.24816], [-120.10321, 36.24807], [-120.08575, 36.24814], [-120.08572, 36.25219], [-120.08397, 36.25081], [-120.08324, 36.25055], [-120.08275, 36.25016], [-120.08242, 36.2498], [-120.07876, 36.24666], [-120.07738, 36.24531], [-120.07628, 36.2438], [-120.07409, 36.24039], [-120.07219, 36.23723], [-120.06988, 36.23366], [-120.06783, 36.23367], [-120.06784, 36.23047], [-120.06518, 36.22639], [-120.06119, 36.22002], [-120.05967, 36.22059], [-120.05947, 36.22022], [-120.06106, 36.2196], [-120.06106, 36.21959], [-120.05979, 36.21789], [-120.05716, 36.21086], [-120.05712, 36.21066], [-120.05696, 36.21019], [-120.05185, 36.1961], [-120.05042, 36.19239], [-120.04902, 36.18883], [-120.0482, 36.18882], [-120.0484, 36.18167], [-120.05002, 36.18159], [-120.05751, 36.18176], [-120.05747, 36.18776], [-120.05533, 36.18777], [-120.05526, 36.18884], [-120.05085, 36.18883], [-120.05084, 36.18884], [-120.05225, 36.19238], [-120.05722, 36.19239], [-120.05722, 36.196], [-120.05384, 36.19606], [-120.05383, 36.19608], [-120.05892, 36.21036], [-120.0594, 36.21066], [-120.06768, 36.21071], [-120.06771, 36.21712], [-120.08038, 36.21218], [-120.08246, 36.21139], [-120.08563, 36.21136], [-120.08582, 36.22637], [-120.091, 36.22637], [-120.10353, 36.22642], [-120.12169, 36.22629], [-120.12169, 36.2408], [-120.12173, 36.2483]]]} | No Public Access 3 | 2352 | Arroyo Pasajero Westside Detention Basin | 15624 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Fresno 9 | 3819.876 | Arroyo Pasajero Westside Detention Basin | None 524 | |||
6759 | 6759 | 6758 | {"type": "Polygon", "coordinates": [[[-122.22476, 38.22438], [-122.22475, 38.22525], [-122.2237, 38.22526], [-122.2237, 38.22472], [-122.22307, 38.22433], [-122.2222, 38.22245], [-122.22221, 38.22188], [-122.22324, 38.22127], [-122.22322, 38.22152], [-122.22316, 38.22152], [-122.22316, 38.22161], [-122.22261, 38.22185], [-122.22242, 38.22209], [-122.22241, 38.22244], [-122.22307, 38.22385], [-122.22384, 38.22431], [-122.22415, 38.22431], [-122.22452, 38.22437], [-122.22476, 38.22438]]]} | No Public Access 3 | 5145 | Department Of Water Resourses | 18099 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Napa 11 | 4.793 | Department Of Water Resourses | None 549 | |||
6778 | 6778 | 6777 | {"type": "Polygon", "coordinates": [[[-122.25654, 38.2078], [-122.25633, 38.20788], [-122.2563, 38.20749], [-122.2564, 38.20753], [-122.25652, 38.20754], [-122.25654, 38.2078]]]} | No Public Access 3 | 5258 | Dept Of Transportation/Paul Kenny | 18103 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | Napa 11 | 0.163 | Dept Of Transportation/Paul Kenny | None 551 | |||
7312 | 7312 | 7311 | {"type": "Polygon", "coordinates": [[[-122.27901, 38.29895], [-122.27868, 38.299], [-122.27861, 38.29876], [-122.27894, 38.2987], [-122.27901, 38.29895]]]} | No Public Access 3 | 6623 | 575 Third St | 15206 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 0.21 | 575 Third St | None 604 | |||
7841 | 7841 | 7840 | {"type": "Polygon", "coordinates": [[[-116.95835, 32.58995], [-116.95155, 32.59194], [-116.94918, 32.59009], [-116.947, 32.58786], [-116.94582, 32.58582], [-116.94542, 32.58527], [-116.94808, 32.58424], [-116.94748, 32.58333], [-116.94716, 32.58293], [-116.94705, 32.58296], [-116.94672, 32.58291], [-116.94635, 32.58283], [-116.94603, 32.58271], [-116.94582, 32.58248], [-116.9458, 32.58217], [-116.94581, 32.58211], [-116.94962, 32.58217], [-116.95013, 32.5831], [-116.95155, 32.5844], [-116.95157, 32.58584], [-116.9523, 32.58586], [-116.95595, 32.58857], [-116.95639, 32.58888], [-116.95835, 32.58995]]]} | No Public Access 3 | 47716 | Otay Valley Regional Park | 31498 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.sdparks.org/content/sdparks/en/park-pages/OVRP.html | San Diego 4 | 146.674 | Otay Valley RP | None 656 | ||
8625 | 8625 | 8624 | {"type": "Polygon", "coordinates": [[[-120.1217, 34.50899], [-120.1215, 34.51982], [-120.12123, 34.53056], [-120.11243, 34.53048], [-120.11238, 34.5342], [-120.10805, 34.53417], [-120.108, 34.53779], [-120.10865, 34.5378], [-120.09496, 34.53782], [-120.095, 34.53396], [-120.09499, 34.53395], [-120.09504, 34.53037], [-120.09508, 34.5298], [-120.09469, 34.52938], [-120.0943, 34.529], [-120.09418, 34.52877], [-120.09451, 34.52685], [-120.09508, 34.52678], [-120.09515, 34.52404], [-120.09518, 34.52331], [-120.09512, 34.51591], [-120.11291, 34.516], [-120.11298, 34.50877], [-120.1217, 34.50899]]]} | No Public Access 3 | 13788 | Rancho Dos Vistas | 24143 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | Santa Barbara 7 | 1402.81 | Rancho Dos Vistas | None 721 | |||
9163 | 9163 | 9162 | {"type": "Polygon", "coordinates": [[[-122.46839, 38.40869], [-122.46606, 38.40871], [-122.46603, 38.40487], [-122.46579, 38.40181], [-122.46609, 38.40194], [-122.46628, 38.402], [-122.46661, 38.40209], [-122.46676, 38.4021], [-122.4669, 38.40215], [-122.46726, 38.40233], [-122.4675, 38.40235], [-122.46761, 38.40231], [-122.46771, 38.40225], [-122.46801, 38.40199], [-122.46819, 38.40193], [-122.46832, 38.40179], [-122.46839, 38.40869]]]} | No Public Access 3 | 15212 | Dale Peters Clyde | 17895 | 223 | Napa Valley College 268 | State 5 | State Agency 5 | http://www.napavalley.edu/ | Other State 5 | 223 | Napa Valley College 263 | State 5 | State Agency 5 | Napa 11 | 37.395 | Dale Peters Clyde | None 758 | |||
9361 | 9361 | 9360 | {"type": "MultiPolygon", "coordinates": [[[[-122.29969, 38.27466], [-122.29947, 38.27466], [-122.29946, 38.27356], [-122.29948, 38.27356], [-122.29969, 38.27466]]], [[[-122.46397, 38.50119], [-122.46394, 38.50121], [-122.46301, 38.50039], [-122.46304, 38.50037], [-122.46397, 38.50119]]]]} | No Public Access 3 | 15638 | Department of Transportation | 18097 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | Napa 11 | 0.423 | Department of Transportation | None 770 | |||
13068 | 13068 | 13067 | {"type": "MultiPolygon", "coordinates": [[[[-121.99945, 39.45642], [-121.99894, 39.45698], [-121.99638, 39.45713], [-121.9963, 39.45659], [-121.99606, 39.45657], [-121.99602, 39.45688], [-121.99611, 39.45714], [-121.99595, 39.45715], [-121.99595, 39.45706], [-121.99599, 39.45693], [-121.99602, 39.45668], [-121.99608, 39.45639], [-121.99612, 39.45579], [-121.99625, 39.45526], [-121.99627, 39.45507], [-121.99628, 39.45472], [-121.99622, 39.45459], [-121.99612, 39.45419], [-121.99608, 39.454], [-121.99608, 39.45386], [-121.99602, 39.45371], [-121.99603, 39.45339], [-121.99602, 39.45321], [-121.996, 39.45303], [-121.99601, 39.45283], [-121.996, 39.4526], [-121.99589, 39.45218], [-121.99581, 39.45172], [-121.99565, 39.45129], [-121.99553, 39.45117], [-121.99539, 39.45097], [-121.9953, 39.4499], [-121.99614, 39.44991], [-121.99593, 39.45068], [-121.99785, 39.45334], [-121.99798, 39.45443], [-121.99945, 39.45642]]], [[[-121.99896, 39.45721], [-121.9974, 39.45877], [-121.99654, 39.45958], [-121.9966, 39.45826], [-121.99648, 39.45806], [-121.99647, 39.4578], [-121.99634, 39.45749], [-121.99624, 39.45732], [-121.99896, 39.45721]]]]} | No Public Access 3 | 34944 | Butte City Project | 16549 | 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 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Glenn 55 | 35.952 | Butte City Project | None 1134 | |||
13160 | 13160 | 13159 | {"type": "Polygon", "coordinates": [[[-121.90786, 38.13955], [-121.90727, 38.13934], [-121.90599, 38.13665], [-121.90645, 38.13653], [-121.90641, 38.13642], [-121.9066, 38.13638], [-121.90648, 38.13613], [-121.90629, 38.13619], [-121.90601, 38.1357], [-121.9056, 38.13583], [-121.904, 38.13379], [-121.90321, 38.13336], [-121.89865, 38.13299], [-121.89825, 38.13297], [-121.89221, 38.13481], [-121.89275, 38.12979], [-121.89314, 38.12688], [-121.89373, 38.1269], [-121.89445, 38.12691], [-121.89521, 38.12686], [-121.8961, 38.12668], [-121.89703, 38.12634], [-121.89754, 38.12611], [-121.8983, 38.12565], [-121.89897, 38.12516], [-121.89966, 38.12462], [-121.90019, 38.1241], [-121.90056, 38.12365], [-121.901, 38.12305], [-121.90135, 38.12252], [-121.90163, 38.12216], [-121.90213, 38.12141], [-121.90248, 38.12095], [-121.9029, 38.12054], [-121.90329, 38.12021], [-121.9037, 38.1199], [-121.90423, 38.11965], [-121.90473, 38.11946], [-121.90576, 38.11926], [-121.90643, 38.11921], [-121.90724, 38.11922], [-121.90808, 38.1192], [-121.90927, 38.11932], [-121.90966, 38.11945], [-121.91014, 38.11955], [-121.911, 38.11989], [-121.91209, 38.12055], [-121.91256, 38.12094], [-121.91307, 38.12148], [-121.91323, 38.12171], [-121.9135, 38.12227], [-121.91378, 38.1227], [-121.91396, 38.1231], [-121.91408, 38.12356], [-121.91416, 38.12413], [-121.9145, 38.12563], [-121.91463, 38.12636], [-121.91485, 38.12827], [-121.91495, 38.12932], [-121.9148, 38.13117], [-121.91446, 38.13232], [-121.91387, 38.13336], [-121.91373, 38.13379], [-121.91316, 38.13454], [-121.91215, 38.13564], [-121.91157, 38.13636], [-121.91074, 38.13713], [-121.90906, 38.13887], [-121.90842, 38.13935], [-121.90786, 38.13955]]]} | No Public Access 3 | 35104 | Meins Landing | 22105 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Solano 26 | 661.018 | Meins Landing | None 1141 | |||
14736 | 14736 | 14735 | {"type": "Polygon", "coordinates": [[[-121.66547, 38.25301], [-121.65784, 38.27952], [-121.65776, 38.28611], [-121.65774, 38.28623], [-121.65775, 38.28717], [-121.65651, 38.28739], [-121.65577, 38.28739], [-121.65452, 38.28716], [-121.65185, 38.28768], [-121.65006, 38.28854], [-121.64923, 38.28922], [-121.64715, 38.29046], [-121.64641, 38.29019], [-121.64593, 38.29003], [-121.64574, 38.28989], [-121.64567, 38.28959], [-121.64567, 38.2895], [-121.6457, 38.28947], [-121.64578, 38.28837], [-121.64553, 38.28744], [-121.64535, 38.28725], [-121.64506, 38.28706], [-121.64451, 38.28681], [-121.64417, 38.28657], [-121.64394, 38.28622], [-121.64397, 38.2857], [-121.64424, 38.28442], [-121.64416, 38.28388], [-121.64416, 38.28331], [-121.64399, 38.28219], [-121.64378, 38.28162], [-121.64352, 38.28133], [-121.64305, 38.28104], [-121.64206, 38.28081], [-121.64169, 38.28074], [-121.64141, 38.28053], [-121.64099, 38.27963], [-121.64044, 38.27917], [-121.63937, 38.27855], [-121.63859, 38.27785], [-121.63844, 38.27758], [-121.63847, 38.27702], [-121.63881, 38.27658], [-121.63929, 38.27616], [-121.63982, 38.27591], [-121.64067, 38.2757], [-121.64126, 38.27532], [-121.64162, 38.27496], [-121.64196, 38.27407], [-121.64196, 38.27346], [-121.64193, 38.27321], [-121.6427, 38.27188], [-121.64269, 38.27126], [-121.64273, 38.27098], [-121.6425, 38.27022], [-121.64223, 38.26996], [-121.64193, 38.2695], [-121.64139, 38.26888], [-121.64114, 38.26829], [-121.64122, 38.26795], [-121.64136, 38.26777], [-121.6418, 38.26737], [-121.64236, 38.26671], [-121.64284, 38.26622], [-121.64321, 38.26593], [-121.64348, 38.26582], [-121.64382, 38.2656], [-121.6444, 38.26544], [-121.64482, 38.26523], [-121.64551, 38.26487], [-121.64577, 38.26469], [-121.64602, 38.26459], [-121.64643, 38.26431], [-121.64692, 38.26406], [-121.64746, 38.26383], [-121.64828, 38.26327], [-121.64878, 38.26279], [-121.64895, 38.26267], [-121.64913, 38.26257], [-121.64949, 38.2623], [-121.64973, 38.26226], [-121.64977, 38.26223], [-121.6512, 38.26231], [-121.65177, 38.26216], [-121.65211, 38.26187], [-121.65223, 38.2616], [-121.65225, 38.26102], [-121.65216, 38.26063], [-121.6522, 38.2598], [-121.65216, 38.25942], [-121.65228, 38.25722], [-121.65248, 38.25661], [-121.65242, 38.25654], [-121.65233, 38.25632], [-121.6523, 38.25611], [-121.65227, 38.2558], [-121.65227, 38.25554], [-121.65235, 38.25528], [-121.65248, 38.25513], [-121.65272, 38.25504], [-121.65281, 38.25503], [-121.65466, 38.2551], [-121.65519, 38.25499], [-121.65558, 38.25472], [-121.65595, 38.25441], [-121.65617, 38.25417], [-121.65634, 38.25382], [-121.65649, 38.25302], [-121.66547, 38.25301]]]} | No Public Access 3 | 45113 | Prospect Island | 24019 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Solano 26 | 1283.124 | Prospect Island | None 1262 | |||
14856 | 14856 | 14855 | {"type": "Polygon", "coordinates": [[[-124.18903, 40.79066], [-124.18902, 40.79082], [-124.18514, 40.7908], [-124.1852, 40.79064], [-124.18903, 40.79066]]]} | No Public Access 3 | 45366 | Del Norte Street Pier | 18042 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | Humboldt 45 | 1.467 | Del Norte Street Pier | None 1279 |
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]);