units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
109 rows where ACCESS_TYP = 2 and DES_TP = 8 sorted by COUNTY
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, YR_EST
MNG_AGENCY 7
AGNCY_TYP 6 ✖
MNG_AG_TYP 2
DES_TP 1
- State Conservation Area · 109 ✖
ACCESS_TYP 1
- Restricted Access · 109 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15549 | 15549 | 15548 | {"type": "Polygon", "coordinates": [[[-121.08092, 35.57253], [-121.07853, 35.58086], [-121.07824, 35.58086], [-121.07506, 35.56806], [-121.07741, 35.56778], [-121.07727, 35.56735], [-121.0795, 35.5668], [-121.08092, 35.57253]]]} | Restricted Access 2 | 605 | Cambria Pines Ecological Reserve | 30728 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Luis Obispo 1 | 111.579 | Cambria Pines ER | 0 | State Conservation Area 8 | 2 | |
15570 | 15570 | 15569 | {"type": "MultiPolygon", "coordinates": [[[[-120.78423, 35.35484], [-120.78407, 35.35512], [-120.78188, 35.35428], [-120.78066, 35.35491], [-120.77891, 35.35839], [-120.77894, 35.35915], [-120.77833, 35.35929], [-120.77818, 35.35951], [-120.77779, 35.35943], [-120.77772, 35.35931], [-120.77747, 35.35929], [-120.77729, 35.35952], [-120.77685, 35.35978], [-120.77648, 35.35961], [-120.77572, 35.35942], [-120.77514, 35.35971], [-120.77472, 35.35951], [-120.77383, 35.36014], [-120.77382, 35.36038], [-120.77367, 35.36051], [-120.77325, 35.35995], [-120.77254, 35.36024], [-120.77179, 35.36037], [-120.77134, 35.3605], [-120.7713, 35.36079], [-120.77098, 35.36083], [-120.77068, 35.3607], [-120.7699, 35.35921], [-120.76874, 35.3547], [-120.76848, 35.35451], [-120.7687, 35.35423], [-120.76534, 35.35444], [-120.76491, 35.3543], [-120.7642, 35.35361], [-120.76483, 35.35339], [-120.76831, 35.35102], [-120.77096, 35.34875], [-120.77352, 35.35089], [-120.77408, 35.35133], [-120.77452, 35.35163], [-120.77497, 35.35191], [-120.77544, 35.35217], [-120.77592, 35.3524], [-120.77676, 35.35275], [-120.77892, 35.35352], [-120.78125, 35.35414], [-120.78179, 35.35416], [-120.78423, 35.35484]]], [[[-120.78839, 35.35056], [-120.7849, 35.35448], [-120.78472, 35.35418], [-120.78437, 35.35413], [-120.7843, 35.35428], [-120.78204, 35.35366], [-120.78173, 35.35352], [-120.77937, 35.35286], [-120.77904, 35.35288], [-120.77819, 35.35262], [-120.77625, 35.35182], [-120.77603, 35.35178], [-120.77528, 35.3514], [-120.77307, 35.34976], [-120.77275, 35.34935], [-120.77231, 35.34912], [-120.76626, 35.34409], [-120.77364, 35.33965], [-120.7789, 35.34466], [-120.78354, 35.34942], [-120.78839, 35.35056]]]]} | Restricted Access 2 | 6147 | Chorro Creek Ecological Reserve | 17221 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Luis Obispo 1 | 583.097 | Chorro Creek ER | 0 | State Conservation Area 8 | 2 | |
5757 | 5757 | 5756 | {"type": "Polygon", "coordinates": [[[-118.06308, 33.71148], [-118.0591, 33.71135], [-118.05909, 33.71137], [-118.05916, 33.71145], [-118.0591, 33.71145], [-118.0529, 33.70379], [-118.05255, 33.70376], [-118.05209, 33.70383], [-118.05126, 33.7045], [-118.05053, 33.70499], [-118.04992, 33.70528], [-118.04939, 33.70559], [-118.04839, 33.70627], [-118.04758, 33.70679], [-118.04721, 33.70696], [-118.0473, 33.70706], [-118.04645, 33.70713], [-118.0451, 33.7068], [-118.04429, 33.70664], [-118.04277, 33.7066], [-118.04262, 33.70639], [-118.03926, 33.70783], [-118.03874, 33.70808], [-118.03248, 33.7108], [-118.03236, 33.71026], [-118.0385, 33.70771], [-118.03856, 33.70759], [-118.04008, 33.70696], [-118.04008, 33.70694], [-118.03929, 33.70619], [-118.0362, 33.70457], [-118.0348, 33.70349], [-118.0343, 33.70285], [-118.03222, 33.70268], [-118.03233, 33.70084], [-118.03007, 33.70098], [-118.02774, 33.69924], [-118.02442, 33.69685], [-118.02392, 33.69652], [-118.02288, 33.69605], [-118.02167, 33.69532], [-118.02083, 33.69486], [-118.02092, 33.69004], [-118.0209, 33.68917], [-118.02053, 33.68916], [-118.02115, 33.68814], [-118.02114, 33.68806], [-118.02204, 33.68651], [-118.02221, 33.68641], [-118.02252, 33.68592], [-118.02297, 33.68566], [-118.02347, 33.68548], [-118.02404, 33.68539], [-118.02475, 33.68495], [-118.02488, 33.68482], [-118.02499, 33.68461], [-118.02516, 33.68437], [-118.02565, 33.68424], [-118.02733, 33.68355], [-118.02777, 33.68348], [-118.02863, 33.68372], [-118.03085, 33.6841], [-118.03152, 33.68436], [-118.03221, 33.68471], [-118.03276, 33.68458], [-118.03308, 33.68442], [-118.03319, 33.6839], [-118.0338, 33.68341], [-118.03355, 33.68309], [-118.03361, 33.68286], [-118.03424, 33.68245], [-118.03919, 33.68737], [-118.04395, 33.69223], [-118.04773, 33.69635], [-118.05291, 33.70154], [-118.05401, 33.7027], [-118.05549, 33.70404], [-118.05874, 33.70712], [-118.06037, 33.70878], [-118.06086, 33.70921], [-118.06308, 33.71148]]]} | Restricted Access 2 | 6996 | Bolsa Chica Ecological Reserve | 16245 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bolsa-Chica-ER | Orange 3 | 1223.82 | Bolsa Chica ER | 1993 | State Conservation Area 8 | 2 |
7999 | 7999 | 7998 | {"type": "Polygon", "coordinates": [[[-117.85797, 33.6566], [-117.85687, 33.66016], [-117.85439, 33.66093], [-117.85304, 33.66254], [-117.85132, 33.66388], [-117.85077, 33.6635], [-117.85031, 33.66313], [-117.85005, 33.66289], [-117.84982, 33.66264], [-117.84939, 33.6621], [-117.84905, 33.66153], [-117.84883, 33.66102], [-117.84833, 33.65945], [-117.85104, 33.6568], [-117.84759, 33.65285], [-117.8483, 33.65243], [-117.84904, 33.65207], [-117.8495, 33.65186], [-117.85028, 33.65158], [-117.85094, 33.65138], [-117.85193, 33.65114], [-117.85261, 33.65103], [-117.85295, 33.65099], [-117.85572, 33.65361], [-117.85656, 33.65519], [-117.85797, 33.6566]]]} | Restricted Access 2 | 11237 | San Joaquin Marsh Reserve | 33193 | 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/san-joaquin-marsh-reserve/ | Orange 3 | 198.279 | San Joaquin Marsh Reserve | 0 | State Conservation Area 8 | 2 |
1522 | 1522 | 1521 | {"type": "Polygon", "coordinates": [[[-117.23496, 33.27233], [-117.23496, 33.27267], [-117.23179, 33.27604], [-117.23077, 33.27536], [-117.2336, 33.27235], [-117.23496, 33.27233]]]} | Restricted Access 2 | 12834 | San Luis Rey River Ecological Reserve | 24942 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 14.153 | San Luis Rey River ER | 0 | State Conservation Area 8 | 2 | |
2398 | 2398 | 2397 | {"type": "MultiPolygon", "coordinates": [[[[-117.21972, 33.42999], [-117.21971, 33.43008], [-117.21941, 33.43087], [-117.21888, 33.43101], [-117.21852, 33.43096], [-117.21805, 33.43108], [-117.21795, 33.43113], [-117.21774, 33.43153], [-117.21722, 33.43152], [-117.21407, 33.43154], [-117.21414, 33.42781], [-117.21857, 33.4278], [-117.21851, 33.42935], [-117.21925, 33.42978], [-117.21965, 33.42988], [-117.2197, 33.42993], [-117.21972, 33.42999]]], [[[-117.20291, 33.42795], [-117.20281, 33.43006], [-117.19914, 33.43009], [-117.199, 33.43159], [-117.19592, 33.4316], [-117.19604, 33.42917], [-117.19685, 33.429], [-117.19721, 33.42851], [-117.19932, 33.42801], [-117.20077, 33.42797], [-117.20291, 33.42795]]]]} | Restricted Access 2 | 7255 | Santa Margarita Ecological Reserve | 33342 | 3065 | San Diego State University Foundation 524 | Non Profit 6 | Non Profit - Other 22 | http://www.foundation.sdsu.edu/index.html | Non Governmental Organization 10 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | San Diego 4 | 88.83 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
5503 | 5503 | 5502 | {"type": "MultiPolygon", "coordinates": [[[[-117.24645, 33.15192], [-117.24325, 33.15203], [-117.24295, 33.1512], [-117.24431, 33.15105], [-117.24644, 33.15036], [-117.24645, 33.15192]]], [[[-117.26182, 33.14925], [-117.26138, 33.14958], [-117.25936, 33.14941], [-117.25864, 33.14971], [-117.2584, 33.14977], [-117.25816, 33.14977], [-117.25744, 33.14967], [-117.25731, 33.14967], [-117.25716, 33.14971], [-117.25701, 33.14979], [-117.25667, 33.15004], [-117.25655, 33.15019], [-117.25648, 33.15037], [-117.25635, 33.1512], [-117.25631, 33.1513], [-117.25622, 33.15142], [-117.25586, 33.15176], [-117.25562, 33.15211], [-117.25053, 33.15267], [-117.25006, 33.1537], [-117.24851, 33.15389], [-117.24842, 33.1523], [-117.24819, 33.15211], [-117.24806, 33.15211], [-117.24804, 33.15188], [-117.24906, 33.14891], [-117.24789, 33.14895], [-117.24624, 33.14851], [-117.24658, 33.14758], [-117.24459, 33.14705], [-117.24455, 33.14478], [-117.24659, 33.1439], [-117.24672, 33.1458], [-117.26179, 33.1458], [-117.26182, 33.14925]]]]} | Restricted Access 2 | 12865 | Dawson Los Monos Canyon Reserve | 17958 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | San Diego 4 | 231.903 | Dawson Los Monos Canyon Reserve | 0 | State Conservation Area 8 | 2 | |
6676 | 6676 | 6675 | {"type": "Polygon", "coordinates": [[[-117.1779, 33.42839], [-117.1779, 33.43232], [-117.17339, 33.43239], [-117.17327, 33.42847], [-117.1779, 33.42839]]]} | Restricted Access 2 | 5517 | Santa Margarita Ecological Reserve | 33342 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | San Diego 4 | 45.762 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
7602 | 7602 | 7601 | {"type": "Polygon", "coordinates": [[[-117.09082, 32.89483], [-117.08881, 32.89783], [-117.0865, 32.89848], [-117.08509, 32.89881], [-117.08278, 32.89949], [-117.08164, 32.89815], [-117.07952, 32.89829], [-117.07915, 32.89934], [-117.08029, 32.90022], [-117.07721, 32.90112], [-117.07883, 32.90284], [-117.07721, 32.90339], [-117.07527, 32.90178], [-117.07426, 32.90045], [-117.07239, 32.89842], [-117.07523, 32.89837], [-117.07522, 32.89663], [-117.08409, 32.89651], [-117.08416, 32.89467], [-117.08629, 32.8947], [-117.08637, 32.89287], [-117.08828, 32.89286], [-117.0883, 32.89111], [-117.09079, 32.89112], [-117.09082, 32.89483]]]} | Restricted Access 2 | 48471 | Elliott Chaparral Reserve | 33182 | 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/elliott-chaparral-reserve/ | San Diego 4 | 183.016 | Elliott Chaparral Reserve | 0 | State Conservation Area 8 | 2 |
7770 | 7770 | 7769 | {"type": "MultiPolygon", "coordinates": [[[[-117.23873, 32.9777], [-117.23873, 32.97825], [-117.23589, 32.97824], [-117.23589, 32.97769], [-117.23873, 32.9777]]], [[[-117.25998, 32.96757], [-117.25996, 32.96761], [-117.25982, 32.96761], [-117.25966, 32.96764], [-117.25895, 32.96787], [-117.25875, 32.96792], [-117.25836, 32.96797], [-117.25808, 32.96798], [-117.25597, 32.96796], [-117.25596, 32.96753], [-117.24944, 32.96745], [-117.24862, 32.96463], [-117.24826, 32.96383], [-117.25164, 32.96386], [-117.25164, 32.96252], [-117.25179, 32.96252], [-117.25257, 32.96267], [-117.2527, 32.96273], [-117.25298, 32.96294], [-117.25311, 32.96301], [-117.2535, 32.96312], [-117.25362, 32.96313], [-117.25382, 32.96311], [-117.25466, 32.96292], [-117.25492, 32.96291], [-117.25509, 32.96295], [-117.25578, 32.96322], [-117.25651, 32.96401], [-117.25644, 32.96406], [-117.25671, 32.96465], [-117.25696, 32.96493], [-117.2575, 32.96525], [-117.25778, 32.9656], [-117.25788, 32.9657], [-117.25801, 32.96577], [-117.25819, 32.96584], [-117.25856, 32.9661], [-117.25869, 32.96652], [-117.259, 32.96693], [-117.25942, 32.96726], [-117.25998, 32.96757]]]]} | Restricted Access 2 | 29610 | San Dieguito Lagoon Ecological Reserve | 24866 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 102.535 | San Dieguito Lagoon ER | 0 | State Conservation Area 8 | 2 | |
8089 | 8089 | 8088 | {"type": "Polygon", "coordinates": [[[-116.86683, 32.75854], [-116.86219, 32.75853], [-116.86189, 32.75146], [-116.86663, 32.75147], [-116.86683, 32.75854]]]} | Restricted Access 2 | 5008 | McGinty Mountain Ecological Reserve | 22036 | 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/McGinty-Mountain-ER | San Diego 4 | 85.161 | McGinty Mtn. ER | 1993 | 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 |
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 |
9875 | 9875 | 9874 | {"type": "Polygon", "coordinates": [[[-116.92472, 33.30781], [-116.9243, 33.30807], [-116.92002, 33.31102], [-116.91534, 33.31417], [-116.90798, 33.31919], [-116.9001, 33.31615], [-116.90138, 33.31462], [-116.90169, 33.31428], [-116.90255, 33.31327], [-116.90259, 33.31326], [-116.91226, 33.30202], [-116.91289, 33.3024], [-116.9132, 33.30251], [-116.91339, 33.30251], [-116.91357, 33.30246], [-116.9137, 33.3024], [-116.91383, 33.30228], [-116.91391, 33.30216], [-116.91394, 33.30203], [-116.91395, 33.30125], [-116.9139, 33.30096], [-116.91366, 33.30042], [-116.91412, 33.29992], [-116.91452, 33.30019], [-116.91469, 33.30037], [-116.91483, 33.30054], [-116.91525, 33.30125], [-116.91538, 33.3014], [-116.91555, 33.3015], [-116.9157, 33.30152], [-116.9158, 33.30151], [-116.91599, 33.30144], [-116.91708, 33.3031], [-116.91724, 33.30377], [-116.91759, 33.30506], [-116.91361, 33.30706], [-116.91334, 33.3069], [-116.91329, 33.30691], [-116.91257, 33.30685], [-116.91224, 33.30687], [-116.91212, 33.30722], [-116.91201, 33.30831], [-116.91242, 33.30841], [-116.91292, 33.30861], [-116.9133, 33.30875], [-116.91369, 33.30885], [-116.91378, 33.30859], [-116.91457, 33.30832], [-116.91452, 33.30776], [-116.91453, 33.30775], [-116.91491, 33.30756], [-116.91526, 33.30744], [-116.91529, 33.30745], [-116.91544, 33.30741], [-116.91603, 33.30748], [-116.9163, 33.30723], [-116.91691, 33.30711], [-116.91724, 33.30707], [-116.91734, 33.30676], [-116.91757, 33.30649], [-116.91778, 33.30638], [-116.91768, 33.30626], [-116.91788, 33.30613], [-116.91827, 33.30753], [-116.92101, 33.30709], [-116.92362, 33.30718], [-116.92413, 33.30746], [-116.92472, 33.30781]], [[-116.91622, 33.30369], [-116.91648, 33.30389], [-116.91698, 33.30386], [-116.91698, 33.30384], [-116.91676, 33.30355], [-116.91605, 33.30315], [-116.9151, 33.30326], [-116.91509, 33.30331], [-116.91454, 33.30336], [-116.91429, 33.30327], [-116.91332, 33.30301], [-116.913, 33.3028], [-116.91252, 33.30272], [-116.91272, 33.30309], [-116.91295, 33.30328], [-116.91303, 33.30345], [-116.91315, 33.304], [-116.91341, 33.30416], [-116.91438, 33.30421], [-116.91487, 33.3042], [-116.91539, 33.3041], [-116.91542, 33.3038], [-116.91602, 33.30367], [-116.91622, 33.30369]]]} | Restricted Access 2 | 5341 | Plaisted Creek Ecological Reserve | 23767 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 463.609 | Plaisted Creek ER | 0 | State Conservation Area 8 | 2 | |
10083 | 10083 | 10082 | {"type": "MultiPolygon", "coordinates": [[[[-117.27291, 33.00739], [-117.26287, 33.00739], [-117.26203, 33.00689], [-117.26063, 33.00632], [-117.26066, 33.00626], [-117.26003, 33.00589], [-117.25972, 33.00557], [-117.25947, 33.00491], [-117.25957, 33.00483], [-117.25923, 33.00381], [-117.2588, 33.00344], [-117.25859, 33.00253], [-117.2588, 33.00172], [-117.25872, 33.00139], [-117.25829, 33.0005], [-117.25825, 33.0003], [-117.25846, 33.0003], [-117.2604, 33.00252], [-117.26197, 33.00312], [-117.26213, 33.00334], [-117.26214, 33.00387], [-117.26433, 33.00388], [-117.26433, 33.00262], [-117.26471, 33.00262], [-117.26472, 33.00248], [-117.26513, 33.00249], [-117.26513, 33.00208], [-117.26657, 33.00209], [-117.26659, 33.00211], [-117.2669, 33.00284], [-117.26699, 33.00292], [-117.26713, 33.00294], [-117.26724, 33.00291], [-117.2673, 33.00286], [-117.2678, 33.00198], [-117.26806, 33.00198], [-117.26818, 33.00279], [-117.26812, 33.00299], [-117.26835, 33.00318], [-117.26842, 33.0035], [-117.2686, 33.00363], [-117.26861, 33.00391], [-117.27039, 33.00393], [-117.2704, 33.00381], [-117.27061, 33.00383], [-117.27072, 33.00382], [-117.27089, 33.00376], [-117.27131, 33.00356], [-117.27158, 33.00354], [-117.27197, 33.00355], [-117.2721, 33.00359], [-117.27221, 33.0036], [-117.27223, 33.00361], [-117.2724, 33.00364], [-117.27248, 33.0037], [-117.27258, 33.0037], [-117.27269, 33.00406], [-117.27274, 33.00414], [-117.27287, 33.00423], [-117.27291, 33.00739]], [[-117.26716, 33.00301], [-117.26673, 33.00297], [-117.26688, 33.0036], [-117.26733, 33.00348], [-117.26726, 33.00297], [-117.26716, 33.00301]]], [[[-117.25116, 33.00742], [-117.25114, 33.00903], [-117.25115, 33.01098], [-117.24055, 33.01098], [-117.23939, 33.00941], [-117.2428, 33.00937], [-117.2428, 33.0092], [-117.24294, 33.00923], [-117.24295, 33.00922], [-117.24295, 33.00892], [-117.2428, 33.00883], [-117.24281, 33.00747], [-117.24445, 33.00745], [-117.24444, 33.00563], [-117.24552, 33.00564], [-117.24553, 33.00744], [-117.25116, 33.00742]]], [[[-117.27505, 33.0139], [-117.275, 33.01393], [-117.27475, 33.01377], [-117.27434, 33.01359], [-117.27395, 33.01348], [-117.27374, 33.01345], [-117.27352, 33.01343], [-117.27351, 33.01315], [-117.27319, 33.01314], [-117.27309, 33.01322], [-117.27307, 33.01326], [-117.27304, 33.01336], [-117.27305, 33.01344], [-117.27284, 33.01347], [-117.27256, 33.01347], [-117.27231, 33.01344], [-117.272, 33.01337], [-117.27171, 33.01326], [-117.27134, 33.01306], [-117.27104, 33.01279], [-117.27096, 33.01269], [-117.27083, 33.01249], [-117.27404, 33.01107], [-117.27469, 33.01223], [-117.27472, 33.01331], [-117.27505, 33.0139]]], [[[-117.25907, 33.01465], [-117.25889, 33.01488], [-117.25873, 33.01505], [-117.25836, 33.01536], [-117.25815, 33.0155], [-117.25784, 33.01568], [-117.25757, 33.0158], [-117.25711, 33.01597], [-117.25673, 33.01617], [-117.25651, 33.01633], [-117.25568, 33.01708], [-117.25569, 33.01468], [-117.25907, 33.01465]]], [[[-117.24895, 33.02066], [-117.24723, 33.0218], [-117.24698, 33.0218], [-117.24696, 33.02001], [-117.24894, 33.02002], [-117.24895, 33.02066]]]]} | Restricted Access 2 | 1714 | San Elijo Lagoon Ecological Reserve | 24877 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Elijo-Lagoon-ER | San Diego 4 | 268.615 | San Elijo Lagoon ER | 1983 | State Conservation Area 8 | 2 |
10233 | 10233 | 10232 | {"type": "MultiPolygon", "coordinates": [[[[-117.11031, 32.77957], [-117.11031, 32.77985], [-117.11022, 32.77985], [-117.10974, 32.77983], [-117.1093, 32.77979], [-117.10739, 32.77953], [-117.10841, 32.77919], [-117.10972, 32.77926], [-117.11031, 32.77957]]], [[[-117.11031, 32.78139], [-117.10939, 32.78129], [-117.10874, 32.78124], [-117.1081, 32.78124], [-117.10775, 32.78126], [-117.10736, 32.78131], [-117.10694, 32.78141], [-117.10659, 32.78152], [-117.10623, 32.78166], [-117.1059, 32.78182], [-117.10555, 32.78203], [-117.10524, 32.78226], [-117.10493, 32.78253], [-117.10466, 32.78283], [-117.10441, 32.78318], [-117.10419, 32.78357], [-117.10401, 32.78361], [-117.10399, 32.78228], [-117.104, 32.78071], [-117.10652, 32.77982], [-117.10701, 32.77966], [-117.10938, 32.77999], [-117.10979, 32.78019], [-117.11029, 32.78049], [-117.11027, 32.78101], [-117.11031, 32.78139]]]]} | Restricted Access 2 | 12831 | San Diego River Ecological Reserve | 24863 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 30.386 | San Diego River ER | 0 | State Conservation Area 8 | 2 | |
10237 | 10237 | 10236 | {"type": "MultiPolygon", "coordinates": [[[[-117.16249, 32.94601], [-117.16193, 32.94655], [-117.16192, 32.94675], [-117.1617, 32.94675], [-117.16137, 32.94705], [-117.16098, 32.94731], [-117.16097, 32.94751], [-117.16067, 32.94766], [-117.15867, 32.94845], [-117.15687, 32.94843], [-117.15688, 32.94911], [-117.1564, 32.9493], [-117.15598, 32.9494], [-117.15555, 32.94946], [-117.15305, 32.94959], [-117.15308, 32.94837], [-117.16054, 32.94596], [-117.16236, 32.94606], [-117.16249, 32.94601]]], [[[-117.16302, 32.94555], [-117.16283, 32.94568], [-117.16267, 32.94582], [-117.16234, 32.94595], [-117.16052, 32.94585], [-117.15309, 32.94825], [-117.1531, 32.94812], [-117.15431, 32.94641], [-117.15674, 32.94598], [-117.15711, 32.94613], [-117.15848, 32.94538], [-117.16225, 32.94328], [-117.163, 32.94474], [-117.16302, 32.94555]]], [[[-117.16592, 32.94474], [-117.16478, 32.94513], [-117.16443, 32.94477], [-117.16477, 32.9446], [-117.16552, 32.94434], [-117.16592, 32.94474]]], [[[-117.16772, 32.94614], [-117.16715, 32.94642], [-117.16635, 32.94573], [-117.16514, 32.94549], [-117.16488, 32.94522], [-117.16604, 32.94483], [-117.16641, 32.94543], [-117.16748, 32.94568], [-117.16772, 32.94614]]], [[[-117.17456, 32.92332], [-117.17351, 32.92332], [-117.17166, 32.92388], [-117.17167, 32.92357], [-117.17186, 32.92346], [-117.17186, 32.92294], [-117.17158, 32.92262], [-117.17207, 32.92214], [-117.17286, 32.92209], [-117.1733, 32.92236], [-117.1735, 32.92254], [-117.17329, 32.92266], [-117.17329, 32.92268], [-117.17456, 32.92332]]]]} | Restricted Access 2 | 13076 | Del Mar Mesa -- Lopez Ridge Ecological Reserve | 18031 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 84.095 | Del Mar Mesa -- Lopez Ridge ER | 0 | State Conservation Area 8 | 2 | |
11552 | 11552 | 11551 | {"type": "Polygon", "coordinates": [[[-116.66912, 32.98862], [-116.65988, 32.98873], [-116.65991, 32.98773], [-116.66058, 32.98745], [-116.66904, 32.98739], [-116.66912, 32.98862]]]} | Restricted Access 2 | 23593 | Boulder Creek Ecological Reserve | 16294 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 29.218 | Boulder Creek ER | 0 | State Conservation Area 8 | 2 | |
15551 | 15551 | 15550 | {"type": "Polygon", "coordinates": [[[-117.19604, 33.42917], [-117.19589, 33.43216], [-117.18882, 33.43217], [-117.18246, 33.43226], [-117.18253, 33.4283], [-117.19167, 33.42815], [-117.19556, 33.42806], [-117.19537, 33.42845], [-117.19525, 33.42932], [-117.19604, 33.42917]]]} | Restricted Access 2 | 48641 | Santa Margarita Ecological Reserve | 33342 | 221 | San Diego State University 1047 | State 5 | State Agency 5 | http://www.sdsu.edu/ | Other State 5 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | San Diego 4 | 135.503 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
15618 | 15618 | 15617 | {"type": "Polygon", "coordinates": [[[-117.10664, 33.07422], [-117.10657, 33.07428], [-117.10628, 33.07556], [-117.10504, 33.07516], [-117.1052, 33.07405], [-117.10423, 33.07384], [-117.10423, 33.07312], [-117.10319, 33.072], [-117.10339, 33.07187], [-117.10339, 33.07186], [-117.10243, 33.0711], [-117.10269, 33.07041], [-117.10371, 33.07007], [-117.10564, 33.07143], [-117.10596, 33.07398], [-117.10664, 33.07422]]]} | Restricted Access 2 | 23594 | Lake Hodges Ecological Reserve | 20894 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 24.606 | Lake Hodges ER | 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]);