units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where COUNTY = 9, MNG_AGENCY = 25 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, LABEL_NAME, YR_EST
DES_TP 4
ACCESS_TYP 3
MNG_AG_TYP 1
- State Agency · 15 ✖
MNG_AGENCY 1
- California Department of Fish and Wildlife · 15 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1362 | 1362 | 1361 | {"type": "MultiPolygon", "coordinates": [[[[-120.54592, 36.6911], [-120.53904, 36.69108], [-120.53903, 36.68751], [-120.53931, 36.68748], [-120.53932, 36.67661], [-120.53965, 36.67662], [-120.54592, 36.6911]]], [[[-120.54644, 36.69054], [-120.54632, 36.69071], [-120.54625, 36.69074], [-120.54003, 36.67662], [-120.54028, 36.67664], [-120.54644, 36.69054]]]]} | No Public Access 3 | 8074 | Pilobos | 32263 | 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 | Fresno 9 | 134.36 | Pilobos | 0 | State Resource Management Area 55 | 3 | |
4066 | 4066 | 4065 | {"type": "Polygon", "coordinates": [[[-119.73129, 36.97793], [-119.7303, 36.97877], [-119.72525, 36.98164], [-119.72042, 36.98537], [-119.72043, 36.98505], [-119.72124, 36.98436], [-119.72154, 36.98342], [-119.72122, 36.98287], [-119.72074, 36.98281], [-119.72075, 36.98168], [-119.72235, 36.9798], [-119.72305, 36.97932], [-119.72304, 36.97794], [-119.73031, 36.97791], [-119.73129, 36.97793]]]} | Open Access 1 | 44427 | Lost Lake Fishing Access | 32207 | 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 | Fresno 9 | 73.033 | Lost Lake FA | 0 | State Recreation Area 39 | 4 | |
5107 | 5107 | 5106 | {"type": "Polygon", "coordinates": [[[-119.60553, 37.05469], [-119.60449, 37.05425], [-119.60262, 37.05784], [-119.6015, 37.05775], [-119.60101, 37.05784], [-119.601, 37.05774], [-119.59373, 37.05756], [-119.59561, 37.0567], [-119.59483, 37.05542], [-119.59485, 37.05373], [-119.59626, 37.05219], [-119.59418, 37.05221], [-119.59292, 37.05383], [-119.5928, 37.05544], [-119.5945, 37.05547], [-119.59074, 37.05716], [-119.59078, 37.05737], [-119.59075, 37.0575], [-119.58847, 37.05744], [-119.58843, 37.05385], [-119.58744, 37.05382], [-119.58743, 37.0538], [-119.58334, 37.05371], [-119.58328, 37.05365], [-119.58311, 37.05364], [-119.58327, 37.05066], [-119.58333, 37.04666], [-119.58338, 37.03919], [-119.58348, 37.03198], [-119.58438, 37.03198], [-119.58772, 37.03206], [-119.58766, 37.03928], [-119.59636, 37.03951], [-119.59663, 37.04673], [-119.60149, 37.04675], [-119.60149, 37.05056], [-119.60536, 37.05068], [-119.60538, 37.05426], [-119.60553, 37.05469]], [[-119.59199, 37.05068], [-119.59107, 37.04986], [-119.58966, 37.05296], [-119.59067, 37.05392], [-119.59199, 37.05068]]]} | Open Access 1 | 6874 | Big Table Mountain Ecological Reserve | 32054 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Big-Table-Mountain-ER | Fresno 9 | 759.911 | Big Table Mtn. ER | 2007 | State Conservation Area 8 | 2 |
5458 | 5458 | 5457 | {"type": "MultiPolygon", "coordinates": [[[[-120.21831, 36.13041], [-120.20929, 36.13044], [-120.20922, 36.12334], [-120.21828, 36.12324], [-120.21831, 36.13041]]], [[[-120.22847, 36.13753], [-120.22846, 36.152], [-120.21955, 36.15197], [-120.21952, 36.13764], [-120.22847, 36.13753]]], [[[-120.2647, 36.16611], [-120.24662, 36.16626], [-120.24645, 36.15181], [-120.25101, 36.15175], [-120.25101, 36.14812], [-120.25997, 36.14809], [-120.26001, 36.14443], [-120.26441, 36.14437], [-120.2645, 36.15162], [-120.26454, 36.15215], [-120.26466, 36.153], [-120.2647, 36.16611]]]]} | Open Access 1 | 8159 | Pleasant Valley Ecological Reserve | 32267 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Pleasant-Valley-ER | Fresno 9 | 1284.087 | Pleasant Valley ER | 2000 | State Conservation Area 8 | 2 |
5838 | 5838 | 5837 | {"type": "MultiPolygon", "coordinates": [[[[-120.19624, 36.73443], [-120.18674, 36.73448], [-120.17316, 36.73451], [-120.17319, 36.71998], [-120.19608, 36.71999], [-120.19624, 36.73443]]], [[[-120.20506, 36.73468], [-120.2048, 36.74922], [-120.18653, 36.74912], [-120.17739, 36.74918], [-120.17765, 36.73475], [-120.18677, 36.73478], [-120.20506, 36.73468]]]]} | Open Access 1 | 21960 | Kerman Ecological Reserve | 32193 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Kerman-ER | Fresno 9 | 1784.445 | Kerman ER | 1990 | State Conservation Area 8 | 2 |
7078 | 7078 | 7077 | {"type": "MultiPolygon", "coordinates": [[[[-120.28787, 36.71631], [-120.28778, 36.71975], [-120.28782, 36.72559], [-120.27868, 36.72398], [-120.26909, 36.72268], [-120.26219, 36.7218], [-120.26174, 36.72161], [-120.26129, 36.72122], [-120.26084, 36.72073], [-120.26064, 36.72029], [-120.2604, 36.71992], [-120.26045, 36.7166], [-120.27884, 36.7165], [-120.28787, 36.71631]], [[-120.27446, 36.71977], [-120.27446, 36.71975], [-120.26911, 36.71978], [-120.26427, 36.71987], [-120.27446, 36.71977]]], [[[-120.30576, 36.73425], [-120.29255, 36.73428], [-120.2923, 36.73425], [-120.29235, 36.72953], [-120.28779, 36.72947], [-120.28778, 36.72948], [-120.28774, 36.73423], [-120.27866, 36.73422], [-120.2787, 36.72438], [-120.28783, 36.72592], [-120.29689, 36.72721], [-120.30569, 36.7285], [-120.30576, 36.73425]]], [[[-120.30568, 36.7282], [-120.30568, 36.7282], [-120.29684, 36.72692], [-120.30563, 36.72689], [-120.30568, 36.7282]]]]} | Open Access 1 | 6618 | Alkali Sink Ecological Reserve | 32014 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Alkali-Sink-ER | Fresno 9 | 935.85 | Alkali Sink ER | 1979 | State Conservation Area 8 | 2 |
7132 | 7132 | 7131 | {"type": "MultiPolygon", "coordinates": [[[[-119.41323, 36.78389], [-119.41298, 36.78429], [-119.41297, 36.78478], [-119.41308, 36.78757], [-119.41299, 36.78847], [-119.41167, 36.78916], [-119.4116, 36.78454], [-119.40887, 36.78451], [-119.40928, 36.78346], [-119.41097, 36.78354], [-119.411, 36.7831], [-119.41, 36.78308], [-119.41079, 36.78223], [-119.41154, 36.78298], [-119.41323, 36.78389]]], [[[-119.41291, 36.78956], [-119.41289, 36.7902], [-119.41169, 36.79021], [-119.41169, 36.79009], [-119.41163, 36.79008], [-119.41163, 36.78953], [-119.41265, 36.78953], [-119.41266, 36.78957], [-119.41291, 36.78956]]]]} | Open Access 1 | 6750 | Avocado Lake | 32030 | 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 | Fresno 9 | 29.362 | Avocado Lake | 0 | State Resource Management Area 55 | 3 | |
7436 | 7436 | 7435 | {"type": "Polygon", "coordinates": [[[-120.55936, 36.14655], [-120.55484, 36.14658], [-120.55048, 36.14653], [-120.54144, 36.14651], [-120.54142, 36.13932], [-120.55041, 36.13938], [-120.55925, 36.13938], [-120.55932, 36.14295], [-120.55936, 36.14655]]]} | Open Access 1 | 6994 | Coalinga Mineral Springs Public Access | 32124 | 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 | Fresno 9 | 316.828 | Coalinga Mineral Springs PA | 0 | State Recreation Area 39 | 4 | |
7536 | 7536 | 7535 | {"type": "MultiPolygon", "coordinates": [[[[-120.4594, 36.09525], [-120.45884, 36.09971], [-120.45356, 36.09967], [-120.454, 36.096], [-120.45465, 36.09599], [-120.45495, 36.09613], [-120.45535, 36.09628], [-120.4556, 36.09628], [-120.45586, 36.09634], [-120.45597, 36.09635], [-120.45623, 36.09634], [-120.45653, 36.09626], [-120.45684, 36.09612], [-120.45705, 36.096], [-120.45847, 36.09601], [-120.45855, 36.09539], [-120.4594, 36.09525]]], [[[-120.4602, 36.08884], [-120.45943, 36.09501], [-120.45866, 36.09511], [-120.45891, 36.09249], [-120.45453, 36.09211], [-120.45494, 36.08881], [-120.4602, 36.08884]]]]} | Open Access 1 | 7116 | Curry Mountain Public Access | 32142 | 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 | Fresno 9 | 98.979 | Curry Mtn. PA | 0 | State Recreation Area 39 | 4 | |
7674 | 7674 | 7673 | {"type": "Polygon", "coordinates": [[[-119.72154, 36.98342], [-119.72124, 36.98436], [-119.72043, 36.98505], [-119.72041, 36.98576], [-119.72081, 36.98612], [-119.71504, 36.98955], [-119.71421, 36.98877], [-119.71461, 36.98852], [-119.71382, 36.98803], [-119.71385, 36.98732], [-119.71406, 36.98693], [-119.71412, 36.9868], [-119.71485, 36.98589], [-119.7156, 36.98567], [-119.71653, 36.98603], [-119.71687, 36.98603], [-119.71851, 36.98504], [-119.7193, 36.98381], [-119.72074, 36.98281], [-119.72122, 36.98286], [-119.72154, 36.98342]]]} | Open Access 1 | 7583 | San Joaquin Fish Hatchery | 32294 | 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 | Fresno 9 | 49.554 | San Joaquin Fish Hatchery | 0 | State Other or Unknown 104 | 4 | |
15578 | 15578 | 15577 | {"type": "Polygon", "coordinates": [[[-120.79972, 36.68843], [-120.79051, 36.68826], [-120.79072, 36.68476], [-120.78171, 36.68455], [-120.78187, 36.67755], [-120.78639, 36.67756], [-120.78647, 36.66694], [-120.79072, 36.66697], [-120.79095, 36.67402], [-120.79963, 36.67422], [-120.79959, 36.68136], [-120.79972, 36.68843]]]} | Open Access 1 | 7984 | Panoche Hills Ecological Reserve | 32255 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Panoche-Hills-ER | Fresno 9 | 580.503 | Panoche Hills ER | 1990 | State Conservation Area 8 | 2 |
15580 | 15580 | 15579 | {"type": "MultiPolygon", "coordinates": [[[[-119.75149, 36.93449], [-119.75004, 36.93665], [-119.74807, 36.93775], [-119.7476, 36.93775], [-119.74664, 36.93813], [-119.74654, 36.93847], [-119.74512, 36.93902], [-119.74305, 36.94171], [-119.7421, 36.94133], [-119.74269, 36.94065], [-119.7424, 36.93959], [-119.74382, 36.93938], [-119.74593, 36.93776], [-119.74592, 36.93775], [-119.74577, 36.93775], [-119.74638, 36.93737], [-119.74673, 36.93674], [-119.74919, 36.93511], [-119.74916, 36.93178], [-119.74932, 36.93147], [-119.74951, 36.9313], [-119.74939, 36.93079], [-119.74911, 36.93064], [-119.74862, 36.93047], [-119.74793, 36.93041], [-119.7478, 36.93035], [-119.7472, 36.93076], [-119.74686, 36.93149], [-119.74685, 36.93201], [-119.74447, 36.93198], [-119.74333, 36.93159], [-119.74307, 36.93144], [-119.74177, 36.93195], [-119.73788, 36.93198], [-119.73781, 36.93219], [-119.73633, 36.93306], [-119.73427, 36.93358], [-119.73336, 36.93373], [-119.73044, 36.93311], [-119.73041, 36.93239], [-119.73061, 36.9316], [-119.73124, 36.9316], [-119.73126, 36.93255], [-119.73127, 36.93256], [-119.73161, 36.93254], [-119.73234, 36.93241], [-119.73304, 36.93225], [-119.73373, 36.93202], [-119.73406, 36.9319], [-119.73472, 36.9316], [-119.73979, 36.93156], [-119.74062, 36.93058], [-119.74138, 36.92971], [-119.74139, 36.9284], [-119.73931, 36.92732], [-119.73829, 36.92685], [-119.73672, 36.92627], [-119.73336, 36.92534], [-119.73339, 36.92527], [-119.73343, 36.9251], [-119.73343, 36.92504], [-119.73346, 36.92494], [-119.73358, 36.92405], [-119.7336, 36.92358], [-119.7341, 36.92354], [-119.73415, 36.92309], [-119.73918, 36.92306], [-119.73922, 36.92508], [-119.74372, 36.92507], [-119.74824, 36.92503], [-119.74827, 36.92686], [-119.75016, 36.92688], [-119.74997, 36.9272], [-119.74985, 36.92744], [-119.74977, 36.92779], [-119.74975, 36.92803], [-119.74978, 36.92809], [-119.74976, 36.92817], [-119.74967, 36.92829], [-119.74964, 36.9285], [-119.74964, 36.92858], [-119.74971, 36.92881], [-119.74987, 36.92909], [-119.74996, 36.92922], [-119.75003, 36.9294], [-119.75013, 36.92954], [-119.75019, 36.92969], [-119.75029, 36.92983], [-119.75034, 36.92994], [-119.75092, 36.93166], [-119.75089, 36.93182], [-119.75148, 36.93286], [-119.75149, 36.93449]]], [[[-119.77586, 36.91001], [-119.77555, 36.91048], [-119.77537, 36.91107], [-119.77446, 36.91292], [-119.7743, 36.91345], [-119.7743, 36.91431], [-119.77434, 36.91462], [-119.77429, 36.91505], [-119.77468, 36.91557], [-119.77477, 36.9159], [-119.77478, 36.91651], [-119.77441, 36.91741], [-119.77414, 36.91775], [-119.77314, 36.91823], [-119.77191, 36.91894], [-119.77042, 36.91939], [-119.76929, 36.91916], [-119.76793, 36.91875], [-119.76641, 36.91867], [-119.76577, 36.91878], [-119.76381, 36.91944], [-119.76246, 36.91996], [-119.76108, 36.91989], [-119.75946, 36.92006], [-119.75867, 36.92023], [-119.75865, 36.91991], [-119.75717, 36.91859], [-119.75586, 36.91748], [-119.75488, 36.91848], [-119.75433, 36.91911], [-119.75368, 36.91952], [-119.75344, 36.91935], [-119.75444, 36.91854], [-119.75504, 36.91767], [-119.75617, 36.91681], [-119.75693, 36.91639], [-119.75802, 36.91625], [-119.75862, 36.91606], [-119.75941, 36.91527], [-119.76011, 36.91496], [-119.7616, 36.91462], [-119.76287, 36.91421], [-119.76437, 36.91389], [-119.76516, 36.91395], [-119.76595, 36.91382], [-119.76732, 36.91341], [-119.76817, 36.91294], [-119.76874, 36.91139], [-119.76938, 36.91059], [-119.76964, 36.91015], [-119.77586, 36.91001]]], [[[-119.87928, 36.85578], [-119.87603, 36.85449], [-119.87533, 36.85429], [-119.87396, 36.85226], [-119.87062, 36.85148], [-119.86577, 36.85146], [-119.86576, 36.85122], [-119.86509, 36.85136], [-119.86496, 36.85146], [-119.86358, 36.85295], [-119.86216, 36.85392], [-119.86103, 36.85445], [-119.86019, 36.85415], [-119.85874, 36.85339], [-119.85886, 36.85305], [-119.86222, 36.85338], [-119.86251, 36.85301], [-119.86385, 36.85146], [-119.86576, 36.85078], [-119.86576, 36.84991], [-119.86568, 36.84623], [-119.86566, 36.84345], [-119.86698, 36.84314], [-119.86842, 36.84288], [-119.86992, 36.84279], [-119.87089, 36.84285], [-119.87165, 36.84313], [-119.87233, 36.84359], [-119.87239, 36.84365], [-119.87268, 36.84386], [-119.87294, 36.84402], [-119.87323, 36.84413], [-119.8736, 36.84431], [-119.87451, 36.84449], [-119.87477, 36.84458], [-119.8748, 36.84467], [-119.87606, 36.84495], [-119.87648, 36.845], [-119.87669, 36.8449], [-119.87925, 36.84684], [-119.87928, 36.85578]]], [[[-119.93262, 36.84369], [-119.93119, 36.84553], [-119.92798, 36.84853], [-119.92581, 36.84638], [-119.92803, 36.84555], [-119.93144, 36.84307], [-119.93262, 36.84369]]]]} | Open Access 1 | 8353 | San Joaquin River Ecological Reserve | 32295 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Joaquin-River-ER | Fresno 9 | 875.667 | San Joaquin River ER | 1990 | 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 |
16554 | 16554 | 16553 | {"type": "Polygon", "coordinates": [[[-120.82603, 36.77763], [-120.82308, 36.77759], [-120.81894, 36.77774], [-120.81895, 36.78132], [-120.81219, 36.7815], [-120.80999, 36.78344], [-120.81, 36.78518], [-120.81227, 36.78511], [-120.81452, 36.78872], [-120.80996, 36.78696], [-120.80555, 36.78534], [-120.80551, 36.78535], [-120.8055, 36.78533], [-120.80322, 36.78605], [-120.80101, 36.78668], [-120.79853, 36.78658], [-120.79774, 36.78693], [-120.79423, 36.78744], [-120.78738, 36.78753], [-120.78295, 36.78844], [-120.78296, 36.7853], [-120.78743, 36.78359], [-120.79187, 36.7818], [-120.79418, 36.78183], [-120.79414, 36.77818], [-120.79658, 36.77818], [-120.79658, 36.77614], [-120.80104, 36.77616], [-120.80544, 36.77625], [-120.80544, 36.77534], [-120.8055, 36.77441], [-120.80857, 36.77443], [-120.81001, 36.77343], [-120.81451, 36.77276], [-120.81896, 36.77272], [-120.82292, 36.77271], [-120.82306, 36.77201], [-120.82519, 36.77203], [-120.82517, 36.77356], [-120.8254, 36.77356], [-120.82541, 36.77362], [-120.82589, 36.77366], [-120.82603, 36.77763]]]} | Open Access 1 | 7474 | Little Ponoche Reservoir Wildlife Area | 30466 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Fresno 9 | 828.561 | Little Ponoche Reservoir Wildlife Area | 0 | State Conservation Area 8 | 2 | |
16726 | 16726 | 16725 | {"type": "MultiPolygon", "coordinates": [[[[-120.28698, 36.68854], [-120.28691, 36.68867], [-120.28649, 36.68864], [-120.28477, 36.68764], [-120.28466, 36.68675], [-120.28477, 36.68653], [-120.28495, 36.68645], [-120.28518, 36.68639], [-120.28545, 36.68647], [-120.28588, 36.68647], [-120.2865, 36.68675], [-120.2866, 36.68773], [-120.28698, 36.68854]]], [[[-120.29687, 36.693], [-120.29687, 36.693], [-120.29589, 36.69329], [-120.29586, 36.69313], [-120.29609, 36.69292], [-120.29683, 36.69292], [-120.29687, 36.693]]], [[[-120.30974, 36.69817], [-120.30964, 36.69822], [-120.30829, 36.69828], [-120.30802, 36.69816], [-120.30784, 36.69818], [-120.30793, 36.69932], [-120.308, 36.69965], [-120.30792, 36.6998], [-120.30775, 36.69983], [-120.30633, 36.69878], [-120.30596, 36.69822], [-120.30559, 36.69797], [-120.30544, 36.69797], [-120.30491, 36.69821], [-120.3044, 36.6983], [-120.30405, 36.69818], [-120.30374, 36.69798], [-120.30301, 36.69795], [-120.30269, 36.69816], [-120.30167, 36.69825], [-120.30093, 36.69808], [-120.29881, 36.69613], [-120.2982, 36.69582], [-120.29706, 36.69564], [-120.29644, 36.69536], [-120.29627, 36.69515], [-120.29639, 36.69498], [-120.29765, 36.6947], [-120.29772, 36.69445], [-120.29738, 36.69429], [-120.29671, 36.69409], [-120.29652, 36.69381], [-120.29659, 36.69359], [-120.29666, 36.69347], [-120.29753, 36.69329], [-120.29774, 36.6932], [-120.29784, 36.693], [-120.3001, 36.69253], [-120.30044, 36.69255], [-120.30354, 36.69441], [-120.3055, 36.69485], [-120.3062, 36.69497], [-120.30646, 36.69509], [-120.3071, 36.69564], [-120.30722, 36.69604], [-120.30861, 36.69681], [-120.30859, 36.69768], [-120.30888, 36.69794], [-120.30957, 36.69809], [-120.30974, 36.69817]]], [[[-120.36036, 36.70528], [-120.35157, 36.70523], [-120.35154, 36.70524], [-120.35136, 36.71225], [-120.3511, 36.71941], [-120.33576, 36.71952], [-120.33577, 36.71954], [-120.35105, 36.71958], [-120.35086, 36.73184], [-120.34305, 36.73267], [-120.34306, 36.73242], [-120.34276, 36.73218], [-120.34273, 36.73181], [-120.34321, 36.73175], [-120.3434, 36.73036], [-120.34386, 36.7306], [-120.34423, 36.73071], [-120.34466, 36.73052], [-120.34497, 36.73016], [-120.34506, 36.72991], [-120.34512, 36.7293], [-120.34508, 36.72857], [-120.34481, 36.72797], [-120.34384, 36.72789], [-120.34286, 36.72799], [-120.34214, 36.72781], [-120.34083, 36.72775], [-120.33935, 36.72759], [-120.3383, 36.7277], [-120.3375, 36.72799], [-120.33729, 36.72801], [-120.33714, 36.72788], [-120.33703, 36.72624], [-120.33715, 36.72604], [-120.33738, 36.72555], [-120.33743, 36.72337], [-120.33726, 36.72326], [-120.33686, 36.72318], [-120.33657, 36.72339], [-120.3363, 36.72332], [-120.33603, 36.72293], [-120.3353, 36.72225], [-120.3346, 36.72219], [-120.3341, 36.7222], [-120.33355, 36.72187], [-120.33318, 36.72149], [-120.33328, 36.71958], [-120.33367, 36.71953], [-120.3338, 36.71872], [-120.33341, 36.71847], [-120.33311, 36.71817], [-120.33315, 36.71787], [-120.3347, 36.71674], [-120.3349, 36.71539], [-120.33434, 36.71488], [-120.33407, 36.71426], [-120.33395, 36.7129], [-120.33358, 36.71259], [-120.3323, 36.71183], [-120.33011, 36.71179], [-120.32913, 36.71103], [-120.32648, 36.71012], [-120.32504, 36.70835], [-120.32435, 36.70795], [-120.32103, 36.70811], [-120.31944, 36.7068], [-120.31942, 36.70603], [-120.3195, 36.70514], [-120.31924, 36.7046], [-120.316, 36.70005], [-120.31588, 36.69915], [-120.31507, 36.69784], [-120.31387, 36.69738], [-120.31138, 36.69507], [-120.31044, 36.69409], [-120.3083, 36.69409], [-120.30832, 36.69363], [-120.30622, 36.69361], [-120.30567, 36.69346], [-120.30083, 36.69133], [-120.30052, 36.6916], [-120.29978, 36.69162], [-120.29954, 36.6916], [-120.29877, 36.69179], [-120.2985, 36.69174], [-120.29811, 36.69177], [-120.29744, 36.692], [-120.29606, 36.69213], [-120.29474, 36.69099], [-120.29464, 36.69048], [-120.29425, 36.69049], [-120.29392, 36.69029], [-120.2924, 36.69004], [-120.29168, 36.68998], [-120.29059, 36.6902], [-120.2904, 36.69016], [-120.28939, 36.68983], [-120.28845, 36.68968], [-120.28796, 36.68909], [-120.28763, 36.68824], [-120.28739, 36.68749], [-120.28729, 36.68661], [-120.28659, 36.68603], [-120.28579, 36.68589], [-120.28532, 36.68597], [-120.28502, 36.68575], [-120.28494, 36.68528], [-120.28511, 36.68437], [-120.2847, 36.68411], [-120.28268, 36.6838], [-120.28265, 36.68396], [-120.28258, 36.68413], [-120.28245, 36.68422], [-120.28225, 36.68427], [-120.28209, 36.6842], [-120.28191, 36.68393], [-120.28194, 36.68367], [-120.28202, 36.68219], [-120.28212, 36.68197], [-120.28245, 36.6818], [-120.2829, 36.68176], [-120.28342, 36.68176], [-120.28369, 36.68165], [-120.29051, 36.66852], [-120.29466, 36.66859], [-120.29747, 36.66857], [-120.2975, 36.66139], [-120.3158, 36.66142], [-120.33484, 36.66136], [-120.35203, 36.69043], [-120.35244, 36.69044], [-120.36025, 36.70453], [-120.36029, 36.70489], [-120.36036, 36.70528]]], [[[-120.27812, 36.70296], [-120.28293, 36.70287], [-120.28276, 36.69939], [-120.28387, 36.69873], [-120.28465, 36.69837], [-120.28524, 36.69817], [-120.28638, 36.6982], [-120.28688, 36.69811], [-120.28851, 36.69647], [-120.28931, 36.69578], [-120.29032, 36.69546], [-120.29063, 36.69547], [-120.29486, 36.69645], [-120.29617, 36.69689], [-120.29696, 36.69736], [-120.2998, 36.69732], [-120.30006, 36.69932], [-120.30106, 36.69956], [-120.30191, 36.69956], [-120.30265, 36.69947], [-120.30332, 36.69927], [-120.30373, 36.69918], [-120.30553, 36.69948], [-120.30608, 36.69959], [-120.30618, 36.69991], [-120.30616, 36.70008], [-120.30632, 36.70033], [-120.30647, 36.70093], [-120.30655, 36.70135], [-120.30689, 36.70167], [-120.30738, 36.70177], [-120.30972, 36.70186], [-120.31083, 36.70204], [-120.31107, 36.69988], [-120.31244, 36.70039], [-120.31442, 36.70081], [-120.3152, 36.70086], [-120.3151, 36.70259], [-120.31533, 36.70261], [-120.31774, 36.70521], [-120.31786, 36.70542], [-120.31794, 36.70608], [-120.3182, 36.70704], [-120.31896, 36.70806], [-120.32092, 36.70882], [-120.32123, 36.70912], [-120.32168, 36.70925], [-120.32358, 36.70947], [-120.3328, 36.71417], [-120.33296, 36.71464], [-120.33303, 36.71521], [-120.33275, 36.71649], [-120.33217, 36.71814], [-120.33226, 36.7185], [-120.33222, 36.71891], [-120.33189, 36.71946], [-120.33181, 36.71969], [-120.3314, 36.71982], [-120.33068, 36.72261], [-120.33098, 36.7231], [-120.33149, 36.72354], [-120.33217, 36.72383], [-120.33339, 36.72371], [-120.33406, 36.7235], [-120.33451, 36.72347], [-120.33584, 36.72448], [-120.33584, 36.72468], [-120.3357, 36.72501], [-120.33542, 36.72871], [-120.33538, 36.72889], [-120.33561, 36.72929], [-120.33604, 36.72956], [-120.33669, 36.72959], [-120.33786, 36.72921], [-120.33799, 36.72897], [-120.33834, 36.72854], [-120.33864, 36.72848], [-120.34155, 36.72866], [-120.34198, 36.72887], [-120.34239, 36.72886], [-120.34287, 36.729], [-120.34314, 36.72941], [-120.34131, 36.72968], [-120.34038, 36.73006], [-120.34002, 36.73057], [-120.33996, 36.73163], [-120.34023, 36.73198], [-120.34138, 36.73238], [-120.34161, 36.73253], [-120.34226, 36.73256], [-120.3424, 36.73275], [-120.3378, 36.73322], [-120.33693, 36.73278], [-120.33303, 36.73201], [-120.30568, 36.7282], [-120.30562, 36.72689], [-120.29684, 36.72692], [-120.29678, 36.71979], [-120.30565, 36.71979], [-120.30572, 36.712], [-120.30604, 36.71199], [-120.30621, 36.70516], [-120.30005, 36.7052], [-120.29998, 36.7109], [-120.29992, 36.71241], [-120.29701, 36.71243], [-120.29675, 36.71928], [-120.29547, 36.71926], [-120.29544, 36.71976], [-120.28785, 36.71975], [-120.28786, 36.71631], [-120.27884, 36.7165], [-120.26045, 36.71659], [-120.26091, 36.68498], [-120.26166, 36.68501], [-120.26239, 36.68306], [-120.26422, 36.68238], [-120.26658, 36.6819], [-120.26785, 36.67924], [-120.26771, 36.67834], [-120.26774, 36.67776], [-120.26813, 36.67729], [-120.26999, 36.67698], [-120.27023, 36.67714], [-120.27099, 36.67853], [-120.27366, 36.68017], [-120.27435, 36.68137], [-120.27613, 36.68248], [-120.27684, 36.68259], [-120.27816, 36.68255], [-120.27934, 36.68236], [-120.28121, 36.68257], [-120.28065, 36.68433], [-120.28075, 36.6847], [-120.28094, 36.68492], [-120.28132, 36.68497], [-120.28366, 36.68468], [-120.28389, 36.68475], [-120.2842, 36.68616], [-120.28352, 36.68742], [-120.2863, 36.69057], [-120.28696, 36.69054], [-120.28723, 36.69027], [-120.28841, 36.6905], [-120.2895, 36.6905], [-120.28982, 36.69076], [-120.28986, 36.69102], [-120.2897, 36.69117], [-120.28804, 36.6909], [-120.28786, 36.69106], [-120.28746, 36.69123], [-120.28711, 36.69127], [-120.28696, 36.69114], [-120.28659, 36.6911], [-120.28642, 36.69321], [-120.28487, 36.69773], [-120.28283, 36.69903], [-120.28116, 36.69951], [-120.27905, 36.70125], [-120.27667, 36.70159], [-120.27525, 36.70246], [-120.27442, 36.70314], [-120.27442, 36.70316], [-120.27812, 36.70296]], [[-120.29479, 36.71241], [-120.29477, 36.70971], [-120.2949, 36.70518], [-120.28771, 36.70518], [-120.28774, 36.70657], [-120.28798, 36.71246], [-120.29479, 36.71241]], [[-120.29526, 36.69789], [-120.29525, 36.69787], [-120.29447, 36.69787], [-120.29443, 36.6991], [-120.29521, 36.69912], [-120.29526, 36.69789]]]]} | Open Access 1 | 7783 | Mendota Wildlife Area | 30471 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Mendota-WA | Fresno 9 | 11286.241 | Mendota Wildlife Area | 1956 | 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]);