units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
250 rows where ACCESS_TYP = 1 and DES_TP = 8 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 250 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
213 | 213 | 212 | {"type": "Polygon", "coordinates": [[[-121.44057, 41.00434], [-121.44008, 41.00444], [-121.44004, 41.00437], [-121.43945, 41.00437], [-121.43934, 41.00404], [-121.43939, 41.00396], [-121.44023, 41.00367], [-121.44032, 41.00373], [-121.44038, 41.00381], [-121.44057, 41.00434]]]} | Open Access 1 | 663 | Fall River Mills Ecological Reserve | 32163 | 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/Fall-River-Mills-ER | Shasta 27 | 1.448 | Fall River Mills ER | 1998 | State Conservation Area 8 | 2 |
12282 | 12282 | 12281 | {"type": "Polygon", "coordinates": [[[-120.19869, 39.31522], [-120.19868, 39.31633], [-120.19754, 39.31634], [-120.19813, 39.31576], [-120.19869, 39.31522]]]} | Open Access 1 | 25911 | Truckee River Wildlife Area | 12543 | 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/Truckee-River-WA | Placer 35 | 1.505 | Truckee River Wildlife Area | 1996 | State Conservation Area 8 | 2 |
2855 | 2855 | 2854 | {"type": "MultiPolygon", "coordinates": [[[[-123.82187, 39.36052], [-123.82181, 39.36061], [-123.82169, 39.36065], [-123.82162, 39.36078], [-123.82155, 39.36082], [-123.82145, 39.36074], [-123.82141, 39.36068], [-123.82133, 39.36064], [-123.82131, 39.36057], [-123.82132, 39.36051], [-123.82158, 39.36028], [-123.82186, 39.36045], [-123.82179, 39.36046], [-123.82177, 39.36048], [-123.82183, 39.36049], [-123.82187, 39.36052]]], [[[-123.8228, 39.36144], [-123.82276, 39.36146], [-123.82269, 39.36143], [-123.82259, 39.36148], [-123.82258, 39.36155], [-123.82252, 39.36153], [-123.82241, 39.36153], [-123.8221, 39.3613], [-123.82218, 39.36104], [-123.82217, 39.36096], [-123.82219, 39.36093], [-123.82217, 39.36088], [-123.82209, 39.36082], [-123.82276, 39.36083], [-123.8228, 39.36144]]], [[[-123.8239, 39.36142], [-123.82384, 39.36148], [-123.82388, 39.36153], [-123.82388, 39.36156], [-123.82384, 39.36163], [-123.82363, 39.3617], [-123.82356, 39.36169], [-123.82352, 39.36164], [-123.82328, 39.36152], [-123.82323, 39.36141], [-123.82319, 39.36134], [-123.8234, 39.36118], [-123.82373, 39.36127], [-123.82371, 39.36132], [-123.8239, 39.36142]]], [[[-123.82509, 39.36092], [-123.825, 39.36098], [-123.82499, 39.36102], [-123.82493, 39.36101], [-123.82473, 39.36109], [-123.82458, 39.36104], [-123.8245, 39.36097], [-123.82444, 39.36087], [-123.82437, 39.36085], [-123.82435, 39.36088], [-123.82436, 39.36092], [-123.82433, 39.36095], [-123.82424, 39.36095], [-123.82419, 39.36096], [-123.82414, 39.3609], [-123.8241, 39.36079], [-123.8241, 39.36073], [-123.82405, 39.36071], [-123.82401, 39.36072], [-123.82397, 39.36082], [-123.82387, 39.36069], [-123.82396, 39.36045], [-123.824, 39.36045], [-123.82406, 39.36037], [-123.82415, 39.36036], [-123.82422, 39.36032], [-123.82435, 39.36035], [-123.82449, 39.36041], [-123.82471, 39.36049], [-123.82476, 39.36057], [-123.8249, 39.3606], [-123.82495, 39.36063], [-123.825, 39.3607], [-123.82501, 39.36074], [-123.82508, 39.36083], [-123.8251, 39.36086], [-123.82509, 39.36092]]]]} | Open Access 1 | 22153 | Caspar Headlands State Natural Reserve | 1468 | 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 | http://www.parks.ca.gov/?page_id=444 | Mendocino 24 | 3.22 | Caspar Headlands SNR | 1972 | State Conservation Area 8 | 2 |
7043 | 7043 | 7042 | {"type": "Polygon", "coordinates": [[[-120.45049, 34.69233], [-120.44937, 34.69162], [-120.44841, 34.69135], [-120.44665, 34.69339], [-120.44259, 34.70021], [-120.44243, 34.70013], [-120.44787, 34.69066], [-120.44845, 34.69086], [-120.44961, 34.69143], [-120.45049, 34.69233]]]} | Open Access 1 | 29179 | Burton Mesa Ecological Reserve | 32070 | 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/Burton-Mesa-ER | Santa Barbara 7 | 10.747 | Burton Mesa ER | 2004 | State Conservation Area 8 | 2 |
15563 | 15563 | 15562 | {"type": "Polygon", "coordinates": [[[-122.7187, 38.86399], [-122.71867, 38.86334], [-122.71873, 38.86325], [-122.72002, 38.86389], [-122.72002, 38.86471], [-122.72031, 38.86555], [-122.72055, 38.8663], [-122.72092, 38.86613], [-122.72154, 38.86716], [-122.71933, 38.86718], [-122.71936, 38.86682], [-122.71935, 38.86664], [-122.7193, 38.86639], [-122.71919, 38.86608], [-122.7188, 38.86524], [-122.7187, 38.86399]]]} | Open Access 1 | 1765 | Loch Lomond Vernal Pool Ecological Reserve | 32205 | 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/Loch-Lomond-Vernal-Pool-ER | Lake 40 | 12.758 | Loch Lomond Vernal Pool ER | 1993 | State Conservation Area 8 | 2 |
5955 | 5955 | 5954 | {"type": "Polygon", "coordinates": [[[-120.98655, 37.40316], [-120.98645, 37.4037], [-120.9858, 37.40327], [-120.98326, 37.4014], [-120.98204, 37.40081], [-120.98154, 37.40063], [-120.98443, 37.39949], [-120.98456, 37.39989], [-120.98467, 37.40012], [-120.98472, 37.40027], [-120.98493, 37.40061], [-120.98501, 37.40078], [-120.98513, 37.40095], [-120.98522, 37.40114], [-120.98557, 37.40154], [-120.98567, 37.40168], [-120.98599, 37.40248], [-120.98621, 37.40281], [-120.98643, 37.40306], [-120.98655, 37.40316]]]} | Open Access 1 | 518 | West Hilmar Wildlife Area | 30516 | 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/West-Hilmar-WA | Stanislaus 2 | 16.656 | West Hilmar Wildlife Area | 1994 | State Conservation Area 8 | 2 |
16557 | 16557 | 16556 | {"type": "Polygon", "coordinates": [[[-122.2306, 40.38874], [-122.22987, 40.38907], [-122.22946, 40.38917], [-122.22924, 40.3892], [-122.22906, 40.38924], [-122.22887, 40.38924], [-122.22864, 40.38928], [-122.22825, 40.38928], [-122.22806, 40.38936], [-122.22743, 40.38935], [-122.22724, 40.38932], [-122.22611, 40.38921], [-122.22589, 40.38912], [-122.2257, 40.38901], [-122.22555, 40.38888], [-122.22542, 40.38868], [-122.22521, 40.38819], [-122.22507, 40.38776], [-122.23041, 40.38739], [-122.2306, 40.38874]]]} | Open Access 1 | 7678 | Mouth of Cottonwood Creek Wildlife Area | 30477 | 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/Mouth-of-Cottonwood-Creek-WA | Tehama 18 | 19.746 | Mouth of Cottonwood Creek Wildlife Area | 1982 | State Conservation Area 8 | 2 |
6554 | 6554 | 6553 | {"type": "Polygon", "coordinates": [[[-121.58605, 38.59505], [-121.57671, 38.5975], [-121.57669, 38.59709], [-121.57651, 38.59671], [-121.58026, 38.59567], [-121.58339, 38.59485], [-121.58581, 38.59418], [-121.58605, 38.59505]]]} | Open Access 1 | 3275 | Sacramento Bypass Wildlife Area | 30493 | 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/Sacramento-Bypass-WA | Yolo 33 | 19.773 | Sacramento Bypass Wildlife Area | 1988 | 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 |
2225 | 2225 | 2224 | {"type": "MultiPolygon", "coordinates": [[[[-121.63488, 36.12197], [-121.63295, 36.12197], [-121.6328, 36.12189], [-121.63274, 36.12187], [-121.63134, 36.12101], [-121.63133, 36.11973], [-121.63116, 36.1198], [-121.63081, 36.12004], [-121.6306, 36.12014], [-121.63054, 36.11998], [-121.63051, 36.11981], [-121.63027, 36.11826], [-121.63128, 36.11827], [-121.63131, 36.11695], [-121.63182, 36.11695], [-121.63177, 36.11708], [-121.63184, 36.11719], [-121.63185, 36.11725], [-121.63189, 36.1173], [-121.63193, 36.11745], [-121.63205, 36.11756], [-121.63222, 36.1178], [-121.63231, 36.11787], [-121.6326, 36.11799], [-121.63271, 36.11813], [-121.63281, 36.11833], [-121.63286, 36.1185], [-121.63288, 36.1187], [-121.63285, 36.11919], [-121.63285, 36.11988], [-121.63293, 36.12014], [-121.63304, 36.12033], [-121.63314, 36.12044], [-121.63326, 36.12064], [-121.6333, 36.12097], [-121.63345, 36.12113], [-121.63361, 36.12125], [-121.63367, 36.12127], [-121.63377, 36.12133], [-121.63381, 36.12139], [-121.6342, 36.12164], [-121.63488, 36.12197]]], [[[-121.63247, 36.12198], [-121.63134, 36.12198], [-121.63134, 36.12131], [-121.63246, 36.12197], [-121.63247, 36.12198]]]]} | Open Access 1 | 16614 | John Little State Reserve | 1582 | 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 | http://www.parks.ca.gov/?page_id=568 | Monterey 14 | 23.093 | John Little SR | 1953 | State Conservation Area 8 | 2 |
11472 | 11472 | 11471 | {"type": "Polygon", "coordinates": [[[-121.0343, 37.08628], [-121.03425, 37.08903], [-121.02759, 37.08656], [-121.02759, 37.08625], [-121.0343, 37.08628]]]} | Open Access 1 | 29207 | O'Neill Forebay Wildlife Area | 30483 | 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 | Merced 37 | 25.025 | O'Neill Forebay Wildlife Area | 1974 | State Conservation Area 8 | 2 | |
10567 | 10567 | 10566 | {"type": "MultiPolygon", "coordinates": [[[[-122.894, 39.1212], [-122.89308, 39.12185], [-122.89194, 39.12219], [-122.89128, 39.1222], [-122.89021, 39.12184], [-122.88849, 39.12032], [-122.88977, 39.12034], [-122.88992, 39.12051], [-122.89027, 39.12077], [-122.89092, 39.12103], [-122.89157, 39.1211], [-122.89231, 39.12097], [-122.89397, 39.12022], [-122.894, 39.1212]]], [[[-122.89329, 39.12034], [-122.89301, 39.12048], [-122.89198, 39.12092], [-122.89106, 39.12094], [-122.89006, 39.12042], [-122.89, 39.12032], [-122.89329, 39.12034]]], [[[-122.89936, 39.11659], [-122.89935, 39.11744], [-122.89898, 39.11734], [-122.89857, 39.11771], [-122.89813, 39.11829], [-122.89772, 39.11866], [-122.897, 39.11895], [-122.89675, 39.11917], [-122.89663, 39.11936], [-122.89628, 39.11934], [-122.89625, 39.1193], [-122.89611, 39.11918], [-122.89711, 39.1183], [-122.8978, 39.11752], [-122.89827, 39.1171], [-122.89936, 39.11659]]], [[[-122.90101, 39.12068], [-122.8989, 39.11997], [-122.8971, 39.11987], [-122.8968, 39.12012], [-122.89684, 39.11999], [-122.89671, 39.11994], [-122.89671, 39.11955], [-122.89736, 39.1196], [-122.89888, 39.1199], [-122.89976, 39.12005], [-122.90037, 39.12009], [-122.90048, 39.11993], [-122.90044, 39.11981], [-122.90052, 39.1195], [-122.901, 39.11915], [-122.90101, 39.12068]]], [[[-122.90099, 39.11847], [-122.90099, 39.11871], [-122.89992, 39.11855], [-122.89967, 39.11832], [-122.89955, 39.11808], [-122.90099, 39.11847]]]]} | Open Access 1 | 18818 | Clear Lake Wildlife Area | 30426 | 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/Clear-Lake-WA | Lake 40 | 26.063 | Clear Lake Wildlife Area | 2004 | State Conservation Area 8 | 2 |
11250 | 11250 | 11249 | {"type": "Polygon", "coordinates": [[[-124.03457, 41.5002], [-124.03347, 41.50137], [-124.03228, 41.50308], [-124.03218, 41.50354], [-124.032, 41.50523], [-124.03178, 41.50607], [-124.03145, 41.50667], [-124.03084, 41.50734], [-124.02997, 41.50822], [-124.02922, 41.50901], [-124.02868, 41.5098], [-124.02808, 41.51081], [-124.02789, 41.51051], [-124.02779, 41.50915], [-124.02794, 41.50887], [-124.02829, 41.50848], [-124.02972, 41.50711], [-124.03017, 41.50643], [-124.03052, 41.5057], [-124.03061, 41.50508], [-124.03064, 41.50441], [-124.03086, 41.50372], [-124.03209, 41.50204], [-124.03318, 41.50091], [-124.03382, 41.50047], [-124.03457, 41.5002]]]} | Open Access 1 | 21620 | Waukell Creek Wildlife Area | 30515 | 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/Waukell-Creek-WA | Del Norte 50 | 26.779 | Waukell Creek Wildlife Area | 1993 | State Conservation Area 8 | 2 |
16765 | 16765 | 16764 | {"type": "Polygon", "coordinates": [[[-121.67267, 38.23526], [-121.67199, 38.23538], [-121.67109, 38.23548], [-121.66964, 38.23586], [-121.66748, 38.23658], [-121.66657, 38.23705], [-121.66669, 38.23662], [-121.66671, 38.23622], [-121.66645, 38.23594], [-121.66624, 38.23551], [-121.66629, 38.23528], [-121.66642, 38.23505], [-121.66671, 38.23485], [-121.6682, 38.23457], [-121.66951, 38.23415], [-121.67, 38.2338], [-121.67045, 38.23344], [-121.67149, 38.233], [-121.67267, 38.23526]]]} | Open Access 1 | 23602 | Miner Slough Wildlife Area | 30473 | 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/Miner-Slough-WA | Solano 26 | 27.122 | Miner Slough Wildlife Area | 1981 | 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 | |
10810 | 10810 | 10809 | {"type": "Polygon", "coordinates": [[[-121.71529, 38.10019], [-121.71529, 38.10019], [-121.71017, 38.10389], [-121.71003, 38.1021], [-121.71, 38.10142], [-121.70992, 38.10079], [-121.70982, 38.09949], [-121.70988, 38.0985], [-121.71529, 38.10019]]]} | Open Access 1 | 23598 | Decker Island Wildlife Area | 30432 | 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/Decker-Island-WA | Solano 26 | 35.275 | Decker Island Wildlife Area | 1988 | State Conservation Area 8 | 2 |
11430 | 11430 | 11429 | {"type": "Polygon", "coordinates": [[[-124.08242, 40.91964], [-124.08176, 40.91965], [-124.07689, 40.91964], [-124.07679, 40.91709], [-124.07902, 40.91719], [-124.079, 40.91686], [-124.07903, 40.91671], [-124.07915, 40.91655], [-124.07941, 40.9163], [-124.07967, 40.91593], [-124.07971, 40.91594], [-124.07946, 40.91631], [-124.07956, 40.91628], [-124.07984, 40.91636], [-124.08013, 40.9164], [-124.07994, 40.91672], [-124.07995, 40.91673], [-124.08054, 40.91687], [-124.08055, 40.91686], [-124.08171, 40.91715], [-124.08172, 40.91714], [-124.08171, 40.91657], [-124.08231, 40.91674], [-124.08242, 40.91964]]]} | Open Access 1 | 23080 | Azalea State Natural Reserve | 1424 | 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 | http://www.parks.ca.gov/?page_id=420 | Humboldt 45 | 35.278 | Azalea SNR | 1943 | State Conservation Area 8 | 2 |
10272 | 10272 | 10271 | {"type": "MultiPolygon", "coordinates": [[[[-119.85959, 34.42431], [-119.85959, 34.42431], [-119.85139, 34.42427], [-119.85215, 34.42266], [-119.8523, 34.42272], [-119.85262, 34.42276], [-119.85358, 34.42308], [-119.85439, 34.42325], [-119.85578, 34.42336], [-119.85624, 34.42347], [-119.85654, 34.42346], [-119.85693, 34.42341], [-119.85731, 34.42333], [-119.85769, 34.42322], [-119.85921, 34.42285], [-119.85947, 34.42256], [-119.85958, 34.42256], [-119.85959, 34.42431]]], [[[-119.86507, 34.42432], [-119.85987, 34.42432], [-119.85988, 34.42258], [-119.86004, 34.42288], [-119.86132, 34.4232], [-119.8618, 34.42336], [-119.86229, 34.42347], [-119.86278, 34.42353], [-119.86409, 34.42364], [-119.86506, 34.42364], [-119.86507, 34.42432]]]]} | Open Access 1 | 16630 | Goleta Slough Ecological Reserve | 32170 | 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/Goleta-Slough-ER | Santa Barbara 7 | 35.471 | Goleta Slough ER | 1983 | State Conservation Area 8 | 2 |
15559 | 15559 | 15558 | {"type": "Polygon", "coordinates": [[[-122.89111, 38.45184], [-122.88969, 38.45207], [-122.88942, 38.45154], [-122.88873, 38.45123], [-122.88857, 38.45091], [-122.88842, 38.45081], [-122.88785, 38.45026], [-122.88738, 38.45022], [-122.88712, 38.44951], [-122.88676, 38.44908], [-122.88597, 38.44848], [-122.88479, 38.44833], [-122.88386, 38.44855], [-122.88374, 38.44861], [-122.88334, 38.44818], [-122.88169, 38.44884], [-122.88158, 38.44869], [-122.88028, 38.4488], [-122.87915, 38.44716], [-122.87778, 38.44774], [-122.8769, 38.44434], [-122.87757, 38.44425], [-122.87824, 38.44495], [-122.87907, 38.44517], [-122.87952, 38.44546], [-122.88075, 38.44702], [-122.88233, 38.44744], [-122.883, 38.44747], [-122.88311, 38.44786], [-122.88594, 38.44781], [-122.88619, 38.44799], [-122.88671, 38.44842], [-122.8869, 38.44855], [-122.88703, 38.44873], [-122.88734, 38.44894], [-122.88752, 38.44916], [-122.88813, 38.44964], [-122.8884, 38.45002], [-122.8885, 38.45011], [-122.88873, 38.45047], [-122.88915, 38.45077], [-122.88953, 38.45094], [-122.88956, 38.45097], [-122.88992, 38.45114], [-122.8905, 38.45151], [-122.89094, 38.45169], [-122.89111, 38.45184]]]} | Open Access 1 | 17413 | Atascadero Creek Marsh Ecological Reserve | 32029 | 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/Atascadero-Creek-Marsh-ER | Sonoma 16 | 40.259 | Atascadero Creek Marsh ER | 1998 | State Conservation Area 8 | 2 |
9764 | 9764 | 9763 | {"type": "MultiPolygon", "coordinates": [[[[-122.77929, 38.89026], [-122.77004, 38.89005], [-122.76995, 38.88925], [-122.76949, 38.88924], [-122.76949, 38.88295], [-122.77003, 38.88295], [-122.77003, 38.88386], [-122.77094, 38.8841], [-122.77094, 38.88206], [-122.77262, 38.88206], [-122.77318, 38.88256], [-122.7732, 38.8842], [-122.77256, 38.8848], [-122.77195, 38.8836], [-122.77156, 38.88428], [-122.7713, 38.88488], [-122.77001, 38.88564], [-122.77, 38.88636], [-122.77079, 38.88756], [-122.77094, 38.88785], [-122.77186, 38.88911], [-122.77411, 38.8901], [-122.77754, 38.88952], [-122.77825, 38.8897], [-122.77831, 38.88934], [-122.77928, 38.88935], [-122.77929, 38.89026]]], [[[-122.77318, 38.88244], [-122.77318, 38.88244], [-122.77277, 38.88206], [-122.77317, 38.88206], [-122.77318, 38.88244]]]]} | Open Access 1 | 17928 | Boggs Lake Ecological Reserve | 32060 | 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/Boggs-Lake-ER | Lake 40 | 42.42 | Boggs Lake ER | 1998 | 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]);