units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
82 rows where DES_TP = 8 and LAYER = 5 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID
MNG_AGENCY 12
- University of California 34
- California Department of Fish and Wildlife 31
- California Department of Parks and Recreation 3
- Other State 2
- Santa Monica Mountains Conservancy 2
- San Diego State University 2
- California Department of Water Resources 2
- Coachella Valley Mountains Conservancy 2
- The Nature Conservancy 1
- California State University Sonoma 1
- Napa Valley College 1
- California State Coastal Conservancy 1
ACCESS_TYP 3
MNG_AG_TYP 2
DES_TP 1
- State Conservation Area · 82 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9251 | 9251 | 9250 | {"type": "Polygon", "coordinates": [[[-116.47394, 33.88857], [-116.47122, 33.88857], [-116.47122, 33.88785], [-116.47129, 33.88596], [-116.47394, 33.88857]]]} | No Public Access 3 | 15407 | Edom Hill-Willow Hole Preserve | 18453 | 214 | Coachella Valley Mountains Conservancy 767 | State 5 | State Agency 5 | http://www.cvmc.ca.gov/ | Other State 5 | 214 | Coachella Valley Mountains Conservancy 748 | State 5 | State Agency 5 | Riverside 10 | 9.085 | Edom Hill-Willow Hole Preserve | 0 | State Conservation Area 8 | 2 | |
15628 | 15628 | 15627 | {"type": "Polygon", "coordinates": [[[-119.87533, 36.85429], [-119.87123, 36.85253], [-119.87062, 36.85148], [-119.87396, 36.85227], [-119.87533, 36.85429]]]} | Restricted Access 2 | 28125 | San Joaquin River Ecological Reserve | 24913 | 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/San-Joaquin-River-ER | Fresno 9 | 10.874 | San Joaquin River ER | 1990 | 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 |
8346 | 8346 | 8345 | {"type": "Polygon", "coordinates": [[[-117.23111, 32.79319], [-117.23107, 32.79326], [-117.23079, 32.7932], [-117.23029, 32.79353], [-117.2303, 32.79356], [-117.23015, 32.79366], [-117.23009, 32.79379], [-117.23005, 32.79383], [-117.23004, 32.79417], [-117.23009, 32.79439], [-117.2301, 32.79484], [-117.23047, 32.79495], [-117.23076, 32.79592], [-117.23007, 32.79609], [-117.2299, 32.79556], [-117.22808, 32.79595], [-117.22756, 32.79426], [-117.22918, 32.79378], [-117.2293, 32.79327], [-117.23017, 32.79269], [-117.23073, 32.79196], [-117.23111, 32.79319]]]} | Restricted Access 2 | 48475 | Kendall Frost Mission Bay Marsh Reserve | 33187 | 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 | https://ucnrs.org/reserves/kendall-frost-mission-bay-marsh-reserve/ | San Diego 4 | 16.556 | Kendall Frost Mission Bay Marsh Reserve | 0 | State Conservation Area 8 | 2 |
15547 | 15547 | 15546 | {"type": "Polygon", "coordinates": [[[-121.27537, 37.70038], [-121.27531, 37.70044], [-121.27489, 37.70053], [-121.27446, 37.70105], [-121.27439, 37.70129], [-121.27435, 37.70153], [-121.2743, 37.70169], [-121.273, 37.70334], [-121.27198, 37.7052], [-121.27185, 37.7052], [-121.27169, 37.70515], [-121.27161, 37.70499], [-121.27158, 37.70481], [-121.27177, 37.70237], [-121.27183, 37.70201], [-121.27198, 37.70166], [-121.2722, 37.70141], [-121.27359, 37.70014], [-121.27383, 37.69976], [-121.27395, 37.69929], [-121.27448, 37.69948], [-121.27471, 37.6995], [-121.27537, 37.70038]]]} | Restricted Access 2 | 47089 | Vernalis Ecological Reserve | 30745 | 219 | Central Valley Flood Protection Board 1027 | State 5 | State Agency 5 | http://www.cvfpb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Joaquin 39 | 20.58 | Vernalis ER | 0 | State Conservation Area 8 | 2 | |
5060 | 5060 | 5059 | {"type": "Polygon", "coordinates": [[[-122.5038, 38.11388], [-122.50155, 38.11561], [-122.50104, 38.11583], [-122.49865, 38.11461], [-122.50105, 38.1126], [-122.50133, 38.11229], [-122.5038, 38.11388]]]} | Open Access 1 | 25328 | Petaluma Marsh Wildlife Area | 30485 | 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/Petaluma-Marsh-WA | Sonoma 16 | 21.886 | Petaluma Marsh Wildlife Area | 1979 | State Conservation Area 8 | 2 |
8349 | 8349 | 8348 | {"type": "Polygon", "coordinates": [[[-116.77797, 33.80726], [-116.77791, 33.81103], [-116.77358, 33.81102], [-116.77357, 33.80908], [-116.77583, 33.80892], [-116.77583, 33.80728], [-116.77797, 33.80726]]]} | Restricted Access 2 | 48473 | James San Jacinto Mountains Reserve | 33184 | 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 | https://ucnrs.org/reserves/james-san-jacinto-mountains-reserve/ | Riverside 10 | 31.718 | James San Jacinto Mtns. Reserve | 0 | State Conservation Area 8 | 2 |
16769 | 16769 | 16768 | {"type": "Polygon", "coordinates": [[[-121.6699, 38.75847], [-121.66966, 38.75881], [-121.66912, 38.75884], [-121.66862, 38.75893], [-121.66828, 38.75904], [-121.66762, 38.75929], [-121.66717, 38.75941], [-121.66663, 38.75977], [-121.66617, 38.76013], [-121.66562, 38.76095], [-121.66491, 38.76228], [-121.66442, 38.76366], [-121.66425, 38.76403], [-121.66402, 38.76472], [-121.66378, 38.76462], [-121.66219, 38.76267], [-121.66228, 38.76192], [-121.66316, 38.76128], [-121.66353, 38.76093], [-121.66406, 38.76012], [-121.66489, 38.75876], [-121.66542, 38.75906], [-121.66683, 38.75878], [-121.66814, 38.7585], [-121.66873, 38.75845], [-121.6694, 38.75842], [-121.66985, 38.75842], [-121.6699, 38.75847]]]} | Open Access 1 | 29012 | Fremont Weir Wildlife Area | 30441 | 219 | Central Valley Flood Protection Board 1027 | State 5 | State Agency 5 | http://www.cvfpb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sutter 47 | 31.784 | Fremont Weir Wildlife Area | 1981 | 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 | ||
11524 | 11524 | 11523 | {"type": "MultiPolygon", "coordinates": [[[[-121.80139, 36.83624], [-121.80041, 36.83633], [-121.80027, 36.83636], [-121.80012, 36.83642], [-121.79995, 36.83655], [-121.79971, 36.83688], [-121.7995, 36.83724], [-121.79925, 36.83777], [-121.79919, 36.83784], [-121.7991, 36.83789], [-121.799, 36.83791], [-121.7982, 36.83791], [-121.79819, 36.83709], [-121.79848, 36.83654], [-121.79868, 36.83586], [-121.79866, 36.83518], [-121.79844, 36.8349], [-121.79817, 36.83491], [-121.79813, 36.83074], [-121.79879, 36.83073], [-121.79899, 36.83093], [-121.79913, 36.83112], [-121.80064, 36.83479], [-121.80093, 36.83538], [-121.80139, 36.83624]]], [[[-121.80217, 36.83804], [-121.80217, 36.83804], [-121.79919, 36.83804], [-121.7993, 36.83798], [-121.7994, 36.83788], [-121.79964, 36.83739], [-121.7998, 36.8371], [-121.80005, 36.83671], [-121.80016, 36.8366], [-121.80029, 36.83654], [-121.80043, 36.8365], [-121.80148, 36.83639], [-121.8017, 36.83677], [-121.80189, 36.83717], [-121.80204, 36.83758], [-121.80217, 36.83804]]]]} | No Public Access 3 | 48235 | McClusky Slough | 32792 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Monterey 14 | 38.897 | McClusky Slough | 1996 | State Conservation Area 8 | 2 | |
14013 | 14013 | 14012 | {"type": "Polygon", "coordinates": [[[-122.11169, 38.50773], [-122.1107, 38.50895], [-122.1103, 38.50914], [-122.10997, 38.50935], [-122.1099, 38.50952], [-122.10976, 38.50999], [-122.10965, 38.51017], [-122.10949, 38.51031], [-122.109, 38.51048], [-122.10868, 38.51068], [-122.1084, 38.51095], [-122.10723, 38.51093], [-122.10585, 38.51011], [-122.10579, 38.51048], [-122.10427, 38.5095], [-122.10452, 38.50932], [-122.10464, 38.50918], [-122.10504, 38.50897], [-122.10518, 38.50894], [-122.10561, 38.50879], [-122.10572, 38.50879], [-122.10582, 38.50877], [-122.10598, 38.5087], [-122.1061, 38.50861], [-122.10619, 38.50846], [-122.10633, 38.50813], [-122.10639, 38.50768], [-122.10648, 38.50743], [-122.11132, 38.5074], [-122.11134, 38.50684], [-122.11148, 38.50691], [-122.11169, 38.50773]]]} | Restricted Access 2 | 37025 | 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 | Napa 11 | 38.968 | Stebbins Cold Canyon Reserve | 0 | State Conservation Area 8 | 2 | |
15957 | 15957 | 15956 | {"type": "Polygon", "coordinates": [[[-122.46077, 37.75819], [-122.46074, 37.7583], [-122.46065, 37.75834], [-122.45926, 37.75863], [-122.45927, 37.75886], [-122.45932, 37.75901], [-122.45962, 37.7597], [-122.45967, 37.75985], [-122.45963, 37.75992], [-122.4595, 37.75996], [-122.45916, 37.75997], [-122.45897, 37.76002], [-122.45887, 37.76017], [-122.45887, 37.76033], [-122.45897, 37.76055], [-122.45897, 37.76059], [-122.45892, 37.76063], [-122.45879, 37.76064], [-122.45873, 37.76067], [-122.45868, 37.76071], [-122.45865, 37.76078], [-122.45866, 37.76086], [-122.45872, 37.76093], [-122.4588, 37.76096], [-122.4589, 37.76096], [-122.459, 37.76092], [-122.45905, 37.76085], [-122.4591, 37.76063], [-122.45909, 37.76051], [-122.46057, 37.76044], [-122.46058, 37.76061], [-122.46041, 37.76074], [-122.46033, 37.76078], [-122.46022, 37.76092], [-122.46016, 37.76104], [-122.46014, 37.76117], [-122.4601, 37.76182], [-122.46007, 37.76197], [-122.45998, 37.76207], [-122.45985, 37.76213], [-122.45962, 37.76218], [-122.45948, 37.76198], [-122.45935, 37.76185], [-122.45934, 37.76172], [-122.45926, 37.76163], [-122.45918, 37.7616], [-122.45903, 37.76157], [-122.45859, 37.76152], [-122.45842, 37.7615], [-122.45814, 37.76151], [-122.45783, 37.76153], [-122.45754, 37.76159], [-122.45728, 37.76167], [-122.45679, 37.76195], [-122.45663, 37.76209], [-122.45637, 37.76241], [-122.45622, 37.76289], [-122.45616, 37.7635], [-122.45606, 37.76371], [-122.45547, 37.7637], [-122.45546, 37.76368], [-122.45546, 37.76226], [-122.45564, 37.76031], [-122.456, 37.75981], [-122.4559, 37.75978], [-122.45483, 37.75976], [-122.45415, 37.76012], [-122.45308, 37.7601], [-122.45288, 37.75995], [-122.45288, 37.75882], [-122.45243, 37.7588], [-122.45244, 37.75835], [-122.45289, 37.7582], [-122.45296, 37.75821], [-122.45304, 37.75866], [-122.45321, 37.75909], [-122.45335, 37.75916], [-122.45355, 37.75918], [-122.45361, 37.75924], [-122.45362, 37.75932], [-122.4536, 37.75939], [-122.45349, 37.75951], [-122.45349, 37.7596], [-122.45354, 37.75967], [-122.45373, 37.75976], [-122.45387, 37.75981], [-122.45398, 37.75974], [-122.45424, 37.75945], [-122.45435, 37.75927], [-122.45437, 37.75897], [-122.45441, 37.75886], [-122.45449, 37.75884], [-122.4552, 37.75877], [-122.45545, 37.75869], [-122.45559, 37.75862], [-122.4558, 37.75845], [-122.4559, 37.75835], [-122.45611, 37.7578], [-122.45626, 37.75755], [-122.45633, 37.75751], [-122.45647, 37.75746], [-122.45658, 37.75727], [-122.4567, 37.75685], [-122.45703, 37.7569], [-122.45719, 37.75689], [-122.45737, 37.75681], [-122.45749, 37.7567], [-122.45754, 37.75657], [-122.45753, 37.75645], [-122.45749, 37.75636], [-122.45736, 37.7562], [-122.45732, 37.75608], [-122.45733, 37.75595], [-122.45738, 37.75582], [-122.45741, 37.7558], [-122.45766, 37.75574], [-122.45785, 37.75566], [-122.45804, 37.7555], [-122.45821, 37.75526], [-122.45831, 37.75521], [-122.4584, 37.75519], [-122.45851, 37.7552], [-122.45862, 37.75523], [-122.45921, 37.75557], [-122.45923, 37.75571], [-122.4592, 37.75598], [-122.45923, 37.75623], [-122.45938, 37.75659], [-122.45949, 37.75703], [-122.45975, 37.75728], [-122.46008, 37.75756], [-122.46033, 37.75789], [-122.46066, 37.75808], [-122.46077, 37.75819]]]} | Open Access 1 | 47868 | Mount Sutro Open Space Reserve | 31812 | 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 | https://www.ucsf.edu/cgr/cgr-projects/mount-sutro-open-space-reserve | San Francisco 13 | 63.473 | Mount Sutro OSR | 1976 | State Conservation Area 8 | 2 |
8373 | 8373 | 8372 | {"type": "Polygon", "coordinates": [[[-117.2527, 32.88267], [-117.25219, 32.88308], [-117.25093, 32.88102], [-117.25092, 32.8805], [-117.25072, 32.87991], [-117.2507, 32.8786], [-117.24819, 32.87836], [-117.2474, 32.87945], [-117.2474, 32.88002], [-117.2469, 32.88002], [-117.24693, 32.87969], [-117.2471, 32.87867], [-117.24607, 32.8791], [-117.24514, 32.87867], [-117.24523, 32.87852], [-117.2461, 32.87869], [-117.24655, 32.87781], [-117.24682, 32.87579], [-117.24672, 32.87495], [-117.24681, 32.87494], [-117.24723, 32.87426], [-117.2517, 32.8743], [-117.25132, 32.87552], [-117.2513, 32.87633], [-117.25175, 32.87822], [-117.25186, 32.8795], [-117.25195, 32.88019], [-117.25209, 32.88089], [-117.25248, 32.88219], [-117.2527, 32.88267]]]} | Restricted Access 2 | 48479 | Scripps Coastal Reserve | 33194 | 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 | https://ucnrs.org/reserves/scripps-coastal-reserve/ | San Diego 4 | 67.619 | Scripps Coastal Reserve | 0 | State Conservation Area 8 | 2 |
6470 | 6470 | 6469 | {"type": "Polygon", "coordinates": [[[-122.06987, 36.9535], [-122.06981, 36.95358], [-122.06949, 36.9538], [-122.06941, 36.95398], [-122.06942, 36.95419], [-122.06937, 36.95429], [-122.06901, 36.95456], [-122.06885, 36.95465], [-122.06873, 36.95472], [-122.06864, 36.95469], [-122.06863, 36.95464], [-122.06886, 36.95406], [-122.06891, 36.95388], [-122.06883, 36.95375], [-122.06855, 36.95346], [-122.06841, 36.95338], [-122.06811, 36.95332], [-122.06804, 36.9533], [-122.06796, 36.95323], [-122.06787, 36.95299], [-122.06775, 36.95281], [-122.06759, 36.95271], [-122.06748, 36.95283], [-122.0673, 36.9535], [-122.06718, 36.95371], [-122.06691, 36.95396], [-122.06662, 36.95409], [-122.06652, 36.95425], [-122.06651, 36.95458], [-122.06646, 36.95465], [-122.06596, 36.95498], [-122.06572, 36.95531], [-122.06541, 36.95567], [-122.06527, 36.9558], [-122.06529, 36.95758], [-122.06435, 36.95765], [-122.06252, 36.95783], [-122.06252, 36.95702], [-122.06409, 36.95687], [-122.06393, 36.95661], [-122.06374, 36.95665], [-122.06365, 36.95663], [-122.06346, 36.95664], [-122.06323, 36.9566], [-122.06311, 36.95649], [-122.063, 36.95647], [-122.06279, 36.95648], [-122.06252, 36.9564], [-122.06252, 36.95528], [-122.06283, 36.95494], [-122.06305, 36.95465], [-122.06253, 36.95452], [-122.06255, 36.94931], [-122.06258, 36.9493], [-122.06257, 36.94913], [-122.06265, 36.94914], [-122.06284, 36.9491], [-122.06294, 36.94905], [-122.06297, 36.94899], [-122.06304, 36.94897], [-122.06311, 36.94898], [-122.06313, 36.94902], [-122.06319, 36.9491], [-122.06346, 36.94912], [-122.06352, 36.94905], [-122.06363, 36.94907], [-122.06369, 36.94913], [-122.06379, 36.94913], [-122.06386, 36.94901], [-122.06397, 36.94895], [-122.06405, 36.94886], [-122.06413, 36.94885], [-122.06417, 36.94886], [-122.06427, 36.94894], [-122.06438, 36.94918], [-122.06449, 36.94936], [-122.06451, 36.94945], [-122.06458, 36.94958], [-122.06463, 36.94959], [-122.06467, 36.94957], [-122.06473, 36.94967], [-122.06484, 36.9498], [-122.06485, 36.94984], [-122.06494, 36.9499], [-122.06502, 36.94993], [-122.06509, 36.94994], [-122.06527, 36.94991], [-122.06535, 36.94993], [-122.06539, 36.94995], [-122.0654, 36.94999], [-122.06542, 36.95011], [-122.06543, 36.95141], [-122.0643, 36.95145], [-122.06423, 36.95149], [-122.06419, 36.95157], [-122.06396, 36.95157], [-122.06383, 36.95151], [-122.06371, 36.9515], [-122.0636, 36.95158], [-122.06358, 36.95203], [-122.06371, 36.9521], [-122.06386, 36.95212], [-122.06403, 36.95223], [-122.06409, 36.95232], [-122.06414, 36.95248], [-122.0641, 36.95272], [-122.06406, 36.95279], [-122.06397, 36.95289], [-122.06379, 36.95299], [-122.06356, 36.95303], [-122.06343, 36.95316], [-122.06344, 36.95323], [-122.06341, 36.9534], [-122.06328, 36.95465], [-122.06329, 36.95469], [-122.06335, 36.95477], [-122.06348, 36.95486], [-122.06387, 36.95499], [-122.06439, 36.9552], [-122.06458, 36.95526], [-122.0647, 36.95528], [-122.06483, 36.95523], [-122.06483, 36.95522], [-122.06471, 36.95513], [-122.06466, 36.95499], [-122.0647, 36.95483], [-122.06476, 36.95477], [-122.06499, 36.9547], [-122.06515, 36.95472], [-122.06516, 36.95456], [-122.06519, 36.9545], [-122.06528, 36.95442], [-122.06534, 36.95441], [-122.06539, 36.95463], [-122.06548, 36.95464], [-122.06553, 36.95459], [-122.06564, 36.95458], [-122.06576, 36.9546], [-122.06599, 36.95469], [-122.06607, 36.95464], [-122.06612, 36.95458], [-122.06611, 36.95448], [-122.06589, 36.95435], [-122.06581, 36.95426], [-122.06579, 36.95411], [-122.06583, 36.954], [-122.0661, 36.95379], [-122.06624, 36.95376], [-122.06639, 36.95369], [-122.0665, 36.9536], [-122.06661, 36.95347], [-122.06663, 36.95328], [-122.0666, 36.95316], [-122.06665, 36.95305], [-122.06671, 36.95299], [-122.06669, 36.95278], [-122.06659, 36.95269], [-122.06619, 36.95268], [-122.06601, 36.95256], [-122.06587, 36.95234], [-122.06581, 36.95213], [-122.06577, 36.95205], [-122.0656, 36.95205], [-122.06559, 36.95199], [-122.06559, 36.95186], [-122.06556, 36.95181], [-122.0655, 36.95178], [-122.0655, 36.95052], [-122.06563, 36.95049], [-122.06624, 36.94994], [-122.06635, 36.94985], [-122.06654, 36.94976], [-122.06661, 36.94967], [-122.06662, 36.94961], [-122.06661, 36.94952], [-122.06649, 36.94938], [-122.0663, 36.94924], [-122.06616, 36.94904], [-122.06604, 36.94882], [-122.06589, 36.94877], [-122.06593, 36.94865], [-122.06599, 36.94859], [-122.06601, 36.94849], [-122.06584, 36.94835], [-122.0657, 36.94827], [-122.06557, 36.9483], [-122.06538, 36.94829], [-122.06547, 36.94823], [-122.06588, 36.94807], [-122.06593, 36.94806], [-122.066, 36.94808], [-122.06611, 36.94822], [-122.06617, 36.9484], [-122.06628, 36.94853], [-122.0663, 36.9486], [-122.06635, 36.9486], [-122.0664, 36.94864], [-122.0664, 36.94868], [-122.06645, 36.94873], [-122.06657, 36.94869], [-122.06662, 36.94873], [-122.0667, 36.94871], [-122.06683, 36.94873], [-122.06703, 36.94882], [-122.06728, 36.9489], [-122.06744, 36.94888], [-122.06746, 36.94882], [-122.06749, 36.94881], [-122.06748, 36.94873], [-122.0676, 36.94904], [-122.06791, 36.94952], [-122.06793, 36.9497], [-122.06792, 36.95008], [-122.06804, 36.95042], [-122.06804, 36.95054], [-122.06795, 36.95066], [-122.06777, 36.9507], [-122.0677, 36.95086], [-122.06779, 36.95095], [-122.06811, 36.95111], [-122.0681, 36.95118], [-122.06805, 36.95125], [-122.06788, 36.95128], [-122.06777, 36.95138], [-122.06771, 36.95153], [-122.06771, 36.95165], [-122.06803, 36.95196], [-122.06811, 36.95216], [-122.06816, 36.95233], [-122.0683, 36.95252], [-122.06871, 36.95279], [-122.06896, 36.953], [-122.06919, 36.95329], [-122.06937, 36.95338], [-122.06947, 36.95339], [-122.06979, 36.95341], [-122.06987, 36.9535]]]} | Restricted Access 2 | 2005 | Younger Lagoon Reserve | 27791 | 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 | Santa Cruz 5 | 69.92 | Younger Lagoon Reserve | 0 | State Conservation Area 8 | 2 | |
9250 | 9250 | 9249 | {"type": "MultiPolygon", "coordinates": [[[[-116.44947, 33.88499], [-116.44723, 33.88499], [-116.44529, 33.88496], [-116.4457, 33.88489], [-116.44596, 33.88482], [-116.44707, 33.88443], [-116.44732, 33.88435], [-116.44773, 33.88427], [-116.44824, 33.8842], [-116.44946, 33.88418], [-116.44947, 33.88499]]], [[[-116.46255, 33.8886], [-116.46251, 33.89218], [-116.45813, 33.89218], [-116.45819, 33.88861], [-116.46255, 33.8886]]], [[[-116.47988, 33.89224], [-116.47985, 33.89496], [-116.47554, 33.89498], [-116.47555, 33.89223], [-116.47988, 33.89224]]]]} | No Public Access 3 | 15404 | Edom Hill-Willow Hole Preserve | 18453 | 214 | Coachella Valley Mountains Conservancy 767 | State 5 | State Agency 5 | http://www.cvmc.ca.gov/ | Other State 5 | 214 | Coachella Valley Mountains Conservancy 748 | State 5 | State Agency 5 | Riverside 10 | 75.092 | Edom Hill-Willow Hole Preserve | 0 | State Conservation Area 8 | 2 | |
8345 | 8345 | 8344 | {"type": "Polygon", "coordinates": [[[-123.76615, 39.28535], [-123.76613, 39.28619], [-123.76623, 39.28837], [-123.76622, 39.29088], [-123.76353, 39.28996], [-123.76354, 39.28536], [-123.76125, 39.28534], [-123.76132, 39.28339], [-123.76129, 39.28146], [-123.7637, 39.2815], [-123.76605, 39.28153], [-123.76615, 39.28535]]]} | Restricted Access 2 | 48474 | Hans Jenny Pygmy Forest Reserve | 33185 | 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 | https://ucnrs.org/reserves/hans-jenny-pygmy-forest-reserve/ | Mendocino 24 | 75.697 | Hans Jenny Pygmy Forest Reserve | 0 | State Conservation Area 8 | 2 |
15956 | 15956 | 15955 | {"type": "MultiPolygon", "coordinates": [[[[-117.84938, 33.6336], [-117.84896, 33.63375], [-117.84877, 33.63393], [-117.84868, 33.63406], [-117.84856, 33.63438], [-117.84843, 33.63446], [-117.84825, 33.63464], [-117.84802, 33.63476], [-117.84778, 33.63508], [-117.8471, 33.63637], [-117.84698, 33.63681], [-117.8468, 33.63794], [-117.84679, 33.63855], [-117.84675, 33.63878], [-117.84668, 33.63946], [-117.84657, 33.64131], [-117.84614, 33.6414], [-117.84598, 33.64145], [-117.84563, 33.64148], [-117.84524, 33.64145], [-117.84426, 33.64157], [-117.84389, 33.64167], [-117.84323, 33.64196], [-117.84338, 33.64163], [-117.84341, 33.64147], [-117.8437, 33.64134], [-117.84361, 33.64116], [-117.84375, 33.64108], [-117.84391, 33.64068], [-117.84403, 33.64028], [-117.84419, 33.63997], [-117.84442, 33.63969], [-117.84465, 33.63918], [-117.84505, 33.63843], [-117.84589, 33.63672], [-117.8455, 33.6364], [-117.84538, 33.63625], [-117.84528, 33.63604], [-117.84469, 33.63555], [-117.84475, 33.63549], [-117.84483, 33.6353], [-117.84484, 33.63475], [-117.84469, 33.63369], [-117.84439, 33.63309], [-117.84426, 33.63301], [-117.84406, 33.63299], [-117.84355, 33.63286], [-117.8429, 33.6324], [-117.84236, 33.63212], [-117.84201, 33.63176], [-117.84219, 33.63164], [-117.84408, 33.63207], [-117.84424, 33.63206], [-117.84428, 33.632], [-117.84479, 33.63213], [-117.84512, 33.63222], [-117.84534, 33.63233], [-117.84606, 33.6325], [-117.84646, 33.63263], [-117.84696, 33.63287], [-117.84718, 33.63294], [-117.84757, 33.63323], [-117.84777, 33.6333], [-117.84832, 33.63331], [-117.84883, 33.63335], [-117.84896, 33.6334], [-117.84895, 33.63345], [-117.84938, 33.6336]]], [[[-117.8551, 33.63794], [-117.85475, 33.63824], [-117.85449, 33.63843], [-117.85462, 33.63811], [-117.85467, 33.63797], [-117.8547, 33.63782], [-117.85469, 33.63758], [-117.85459, 33.63747], [-117.85451, 33.63744], [-117.85426, 33.63722], [-117.85418, 33.63704], [-117.85396, 33.63684], [-117.85368, 33.63669], [-117.85336, 33.63648], [-117.8531, 33.63611], [-117.85277, 33.63603], [-117.8526, 33.63607], [-117.85241, 33.63616], [-117.85222, 33.6363], [-117.85198, 33.6366], [-117.85182, 33.63674], [-117.85166, 33.63682], [-117.85154, 33.63694], [-117.8514, 33.63729], [-117.85131, 33.63741], [-117.85098, 33.6374], [-117.85088, 33.63733], [-117.85086, 33.63724], [-117.8509, 33.63719], [-117.85095, 33.63711], [-117.85114, 33.63695], [-117.8512, 33.63686], [-117.85137, 33.63645], [-117.85161, 33.63616], [-117.85164, 33.63607], [-117.85163, 33.63553], [-117.85159, 33.63535], [-117.85149, 33.63517], [-117.85133, 33.63499], [-117.85078, 33.63453], [-117.85025, 33.63404], [-117.85089, 33.63438], [-117.85227, 33.63535], [-117.85341, 33.63625], [-117.85353, 33.63636], [-117.85349, 33.6364], [-117.85389, 33.6367], [-117.85425, 33.63705], [-117.8544, 33.63723], [-117.8551, 33.63786], [-117.8551, 33.63794]]], [[[-117.85959, 33.64745], [-117.85951, 33.64768], [-117.85942, 33.64783], [-117.85933, 33.64794], [-117.85912, 33.64808], [-117.8588, 33.64825], [-117.85867, 33.64839], [-117.85857, 33.64864], [-117.85845, 33.64914], [-117.85843, 33.64948], [-117.85845, 33.64989], [-117.85811, 33.64992], [-117.85808, 33.64948], [-117.85805, 33.64941], [-117.85812, 33.64907], [-117.85843, 33.64823], [-117.85844, 33.6481], [-117.85843, 33.64771], [-117.85846, 33.64718], [-117.8585, 33.64714], [-117.85854, 33.64704], [-117.85915, 33.64718], [-117.85921, 33.64711], [-117.85926, 33.64697], [-117.85928, 33.64682], [-117.85927, 33.64667], [-117.85919, 33.64615], [-117.85903, 33.64548], [-117.85893, 33.64512], [-117.85871, 33.64449], [-117.8584, 33.64387], [-117.85829, 33.64377], [-117.85771, 33.64334], [-117.85771, 33.64328], [-117.85774, 33.64325], [-117.85788, 33.64321], [-117.858, 33.64311], [-117.85804, 33.64304], [-117.85805, 33.64293], [-117.8579, 33.64259], [-117.85776, 33.6423], [-117.85768, 33.64208], [-117.85745, 33.64163], [-117.85735, 33.64136], [-117.85732, 33.6412], [-117.85729, 33.64119], [-117.85723, 33.64121], [-117.85707, 33.64124], [-117.85648, 33.64124], [-117.85641, 33.64118], [-117.85639, 33.64109], [-117.85654, 33.64107], [-117.85691, 33.64047], [-117.85694, 33.64031], [-117.85689, 33.64], [-117.85673, 33.63954], [-117.85635, 33.63896], [-117.856, 33.6387], [-117.85571, 33.63855], [-117.85535, 33.6385], [-117.85478, 33.63856], [-117.85527, 33.63819], [-117.85542, 33.63837], [-117.85555, 33.63829], [-117.85566, 33.63833], [-117.85675, 33.63929], [-117.85687, 33.63944], [-117.85691, 33.63959], [-117.85692, 33.63967], [-117.85728, 33.64001], [-117.85723, 33.64005], [-117.85732, 33.64048], [-117.85752, 33.64087], [-117.85773, 33.6415], [-117.85783, 33.64175], [-117.85805, 33.64224], [-117.8584, 33.64296], [-117.8584, 33.64298], [-117.85841, 33.64302], [-117.85844, 33.64304], [-117.85856, 33.64336], [-117.85873, 33.64373], [-117.85866, 33.64382], [-117.85868, 33.64387], [-117.85882, 33.64392], [-117.85914, 33.64463], [-117.85924, 33.64491], [-117.85952, 33.64609], [-117.85964, 33.64685], [-117.85965, 33.64701], [-117.85964, 33.64712], [-117.85961, 33.64728], [-117.85954, 33.64751], [-117.85955, 33.64751], [-117.85959, 33.64745]]]]} | Open Access 1 | 14876 | University of California, Irvine Open Space Reserve | 26683 | 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 | Orange 3 | 81.364 | University of California, Irvine OSR | 0 | State Conservation Area 8 | 2 | |
10645 | 10645 | 10644 | {"type": "MultiPolygon", "coordinates": [[[[-122.40304, 38.85665], [-122.39731, 38.86263], [-122.39714, 38.86295], [-122.39704, 38.8611], [-122.39687, 38.85728], [-122.39454, 38.85725], [-122.39218, 38.85724], [-122.39215, 38.8538], [-122.39568, 38.85382], [-122.39686, 38.8538], [-122.39835, 38.85371], [-122.39876, 38.85408], [-122.39926, 38.85447], [-122.39956, 38.85456], [-122.39985, 38.85463], [-122.40005, 38.85475], [-122.40023, 38.85493], [-122.40058, 38.85545], [-122.40104, 38.85604], [-122.40121, 38.85615], [-122.40151, 38.85641], [-122.40304, 38.85665]], [[-122.39929, 38.85638], [-122.39687, 38.85633], [-122.39687, 38.85727], [-122.39929, 38.85729], [-122.39929, 38.85638]]], [[[-122.39926, 38.85396], [-122.39926, 38.85396], [-122.39886, 38.85369], [-122.39924, 38.85364], [-122.39926, 38.85396]]]]} | Restricted Access 2 | 48638 | McLaughlin Natural Reserve | 33195 | 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 | https://ucnrs.org/reserves/mclaughlin-natural-reserve/ | Napa 11 | 102.485 | McLaughlin Natural Reserve | 0 | State Conservation Area 8 | 2 |
6642 | 6642 | 6641 | {"type": "MultiPolygon", "coordinates": [[[[-119.52824, 34.39721], [-119.52817, 34.39735], [-119.52732, 34.39804], [-119.52713, 34.39789], [-119.52812, 34.3971], [-119.52824, 34.39721]]], [[[-119.53867, 34.39858], [-119.53863, 34.40505], [-119.53816, 34.40492], [-119.53775, 34.40478], [-119.53696, 34.40448], [-119.5299, 34.40115], [-119.53026, 34.40061], [-119.52943, 34.40021], [-119.53009, 34.39857], [-119.53025, 34.3983], [-119.53107, 34.39724], [-119.53128, 34.39727], [-119.53248, 34.3973], [-119.53281, 34.39735], [-119.53323, 34.39755], [-119.5335, 34.39773], [-119.53403, 34.39803], [-119.53427, 34.39808], [-119.53464, 34.39818], [-119.53497, 34.39818], [-119.53521, 34.39816], [-119.53545, 34.39819], [-119.53573, 34.39815], [-119.5363, 34.39809], [-119.53663, 34.39814], [-119.53683, 34.39811], [-119.53691, 34.39788], [-119.53704, 34.39764], [-119.53709, 34.39747], [-119.53714, 34.39719], [-119.53711, 34.39711], [-119.53711, 34.39706], [-119.53666, 34.39621], [-119.53655, 34.39595], [-119.53674, 34.396], [-119.53724, 34.39633], [-119.53758, 34.39698], [-119.53758, 34.39805], [-119.53867, 34.39858]]]]} | Restricted Access 2 | 4645 | Carpinteria Salt Marsh Reserve - UC Natural Reserve | 16902 | 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 | Santa Barbara 7 | 120.56 | Carpinteria Salt Marsh Reserve - UC Natural Reserve | 0 | State Conservation Area 8 | 2 | |
11481 | 11481 | 11480 | {"type": "MultiPolygon", "coordinates": [[[[-121.78572, 38.52691], [-121.78568, 38.52895], [-121.78352, 38.52897], [-121.78263, 38.52877], [-121.7824, 38.52859], [-121.78213, 38.52879], [-121.78196, 38.52865], [-121.78187, 38.52868], [-121.78033, 38.52991], [-121.78002, 38.53011], [-121.77969, 38.53029], [-121.7795, 38.53036], [-121.77922, 38.53043], [-121.77871, 38.53051], [-121.77837, 38.53053], [-121.77776, 38.53052], [-121.77775, 38.53054], [-121.77708, 38.53053], [-121.77706, 38.53051], [-121.77707, 38.53043], [-121.77704, 38.53031], [-121.77683, 38.52993], [-121.77683, 38.52983], [-121.77686, 38.52979], [-121.7769, 38.52978], [-121.77791, 38.52975], [-121.77826, 38.5297], [-121.77941, 38.52948], [-121.77985, 38.52932], [-121.78, 38.52925], [-121.78045, 38.52893], [-121.78161, 38.52794], [-121.78208, 38.52757], [-121.78229, 38.52735], [-121.78272, 38.52674], [-121.78285, 38.52671], [-121.78353, 38.52685], [-121.78572, 38.52691]]], [[[-121.80338, 38.52697], [-121.80338, 38.52711], [-121.80305, 38.52714], [-121.80278, 38.52719], [-121.80124, 38.52766], [-121.80093, 38.52773], [-121.8004, 38.52782], [-121.79956, 38.52787], [-121.79879, 38.52795], [-121.79831, 38.52799], [-121.79738, 38.52802], [-121.79678, 38.52799], [-121.79655, 38.52792], [-121.79616, 38.52767], [-121.79591, 38.52757], [-121.79525, 38.52737], [-121.7948, 38.52728], [-121.79447, 38.52719], [-121.79362, 38.52682], [-121.79304, 38.52659], [-121.79264, 38.52639], [-121.79206, 38.52603], [-121.79157, 38.52585], [-121.79099, 38.52556], [-121.79056, 38.52544], [-121.78994, 38.52521], [-121.78863, 38.5247], [-121.78818, 38.52447], [-121.78728, 38.5239], [-121.78697, 38.52374], [-121.7868, 38.52368], [-121.78656, 38.5236], [-121.78636, 38.52356], [-121.7862, 38.52354], [-121.78591, 38.52355], [-121.78507, 38.52365], [-121.7837, 38.52387], [-121.78363, 38.52355], [-121.78397, 38.52325], [-121.78466, 38.52325], [-121.78552, 38.5231], [-121.78601, 38.52309], [-121.7864, 38.52313], [-121.78697, 38.52329], [-121.78751, 38.52346], [-121.78861, 38.52401], [-121.78959, 38.52443], [-121.79037, 38.52473], [-121.79064, 38.5249], [-121.7912, 38.52516], [-121.79159, 38.52539], [-121.79191, 38.52556], [-121.79282, 38.52598], [-121.79328, 38.52622], [-121.79386, 38.5265], [-121.79465, 38.52684], [-121.79635, 38.52738], [-121.79711, 38.52752], [-121.79753, 38.52759], [-121.79791, 38.5276], [-121.79872, 38.52747], [-121.79978, 38.52733], [-121.80174, 38.52715], [-121.80253, 38.52704], [-121.80338, 38.52697]]], [[[-121.81242, 38.52598], [-121.81241, 38.52689], [-121.81218, 38.52689], [-121.81217, 38.52679], [-121.81207, 38.52674], [-121.81198, 38.52677], [-121.81195, 38.5268], [-121.81187, 38.52685], [-121.81139, 38.52696], [-121.8107, 38.5271], [-121.80999, 38.52715], [-121.80873, 38.52729], [-121.80597, 38.52746], [-121.80523, 38.52745], [-121.80473, 38.52727], [-121.80359, 38.52712], [-121.80359, 38.52695], [-121.80387, 38.52693], [-121.80622, 38.52688], [-121.80707, 38.52691], [-121.80756, 38.52687], [-121.80896, 38.52681], [-121.80952, 38.52671], [-121.80997, 38.52651], [-121.81068, 38.5263], [-121.81153, 38.52611], [-121.81242, 38.52598]]], [[[-121.81243, 38.53024], [-121.81236, 38.53025], [-121.81236, 38.5323], [-121.81202, 38.53231], [-121.81201, 38.53204], [-121.81149, 38.53205], [-121.81107, 38.53178], [-121.81049, 38.53209], [-121.80992, 38.53218], [-121.80969, 38.53219], [-121.80817, 38.53216], [-121.80761, 38.53218], [-121.8076, 38.53209], [-121.80761, 38.53181], [-121.80759, 38.53169], [-121.80755, 38.53163], [-121.80757, 38.53143], [-121.80754, 38.53128], [-121.80749, 38.53084], [-121.80722, 38.53078], [-121.807, 38.53071], [-121.80679, 38.53062], [-121.80659, 38.53051], [-121.8063, 38.53032], [-121.80593, 38.52989], [-121.80581, 38.52987], [-121.80529, 38.52989], [-121.80534, 38.52763], [-121.80897, 38.52739], [-121.80914, 38.52733], [-121.80946, 38.52729], [-121.80946, 38.52803], [-121.81072, 38.52803], [-121.81077, 38.52816], [-121.81085, 38.52825], [-121.81099, 38.52834], [-121.81109, 38.52837], [-121.81122, 38.52839], [-121.81242, 38.52839], [-121.81243, 38.53024]]]]} | Restricted Access 2 | 23108 | Putah Creek Riparian Reserve | 24035 | 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 | Yolo 33 | 125.443 | Putah Creek Riparian Reserve | 0 | 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]);