units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where COUNTY = 4 and DES_TP = 8
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_WEB, LAYER, PARK_URL, YR_EST
MNG_AGENCY 4
ACCESS_TYP 2
- Open Access 19
- Restricted Access 17
MNG_AG_TYP 1
- State Agency 36
DES_TP 1
- State Conservation Area · 36 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1161 | 1161 | 1160 | {"type": "MultiPolygon", "coordinates": [[[[-116.82364, 32.76231], [-116.81892, 32.76235], [-116.81902, 32.7693], [-116.81437, 32.76942], [-116.81441, 32.77293], [-116.80574, 32.77329], [-116.80574, 32.7733], [-116.80577, 32.77342], [-116.80586, 32.77347], [-116.80589, 32.77355], [-116.80587, 32.77362], [-116.80592, 32.77374], [-116.80592, 32.77379], [-116.80588, 32.77391], [-116.80578, 32.77401], [-116.80569, 32.77406], [-116.80552, 32.77407], [-116.80547, 32.77405], [-116.80535, 32.77405], [-116.80522, 32.7741], [-116.8051, 32.7741], [-116.80505, 32.77407], [-116.8049, 32.77405], [-116.8048, 32.774], [-116.80443, 32.77392], [-116.80426, 32.77383], [-116.80423, 32.77379], [-116.80423, 32.77373], [-116.80428, 32.77368], [-116.80431, 32.77361], [-116.80428, 32.77332], [-116.79007, 32.77342], [-116.79004, 32.76975], [-116.78793, 32.76975], [-116.78788, 32.76251], [-116.79214, 32.76249], [-116.79209, 32.75893], [-116.79192, 32.75207], [-116.7978, 32.75196], [-116.79773, 32.74832], [-116.79886, 32.7483], [-116.79884, 32.74683], [-116.79921, 32.74676], [-116.80005, 32.74651], [-116.80006, 32.74669], [-116.80044, 32.7467], [-116.80048, 32.74828], [-116.8048, 32.74822], [-116.80486, 32.74442], [-116.81105, 32.74446], [-116.81105, 32.74444], [-116.81084, 32.7443], [-116.81054, 32.74403], [-116.81032, 32.74374], [-116.81032, 32.7435], [-116.81043, 32.74324], [-116.81074, 32.74325], [-116.81065, 32.74333], [-116.81073, 32.74341], [-116.81056, 32.74341], [-116.81051, 32.74351], [-116.81053, 32.7437], [-116.81074, 32.74398], [-116.81137, 32.74446], [-116.81786, 32.74445], [-116.81812, 32.74805], [-116.82267, 32.74811], [-116.82359, 32.75895], [-116.82364, 32.76231]], [[-116.80495, 32.76969], [-116.80967, 32.76956], [-116.80958, 32.76243], [-116.80951, 32.7589], [-116.80469, 32.75888], [-116.80477, 32.76245], [-116.79641, 32.76249], [-116.79642, 32.76441], [-116.79538, 32.76441], [-116.79541, 32.76612], [-116.80069, 32.76609], [-116.80072, 32.76972], [-116.80495, 32.76969]], [[-116.79974, 32.76984], [-116.79966, 32.76982], [-116.79951, 32.76983], [-116.79928, 32.76997], [-116.79909, 32.76965], [-116.79849, 32.76965], [-116.79823, 32.76901], [-116.79723, 32.76901], [-116.79694, 32.76969], [-116.79726, 32.77034], [-116.7994, 32.77034], [-116.79969, 32.7703], [-116.79982, 32.77023], [-116.79986, 32.77018], [-116.7999, 32.77004], [-116.79984, 32.76992], [-116.7998, 32.76987], [-116.79974, 32.76984]]], [[[-116.84135, 32.7618], [-116.83268, 32.76185], [-116.83252, 32.75816], [-116.82805, 32.75849], [-116.82847, 32.76907], [-116.82386, 32.76911], [-116.82371, 32.76192], [-116.82379, 32.76191], [-116.82378, 32.75869], [-116.82316, 32.75234], [-116.82271, 32.74818], [-116.83622, 32.74819], [-116.83641, 32.75469], [-116.8408, 32.75464], [-116.84131, 32.75758], [-116.84135, 32.7618]]]]} | Open Access 1 | 7361 | Sycuan Peak Ecological Reserve | 32323 | 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/Sycuan-Peak-ER | San Diego 4 | 2347.431 | Sycuan Peak ER | 2000 | 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 | |
5759 | 5759 | 5758 | {"type": "Polygon", "coordinates": [[[-116.91247, 32.61929], [-116.9111, 32.61929], [-116.91125, 32.62294], [-116.90675, 32.62293], [-116.90682, 32.6266], [-116.90221, 32.62659], [-116.90216, 32.62889], [-116.90159, 32.62896], [-116.89947, 32.62917], [-116.8976, 32.62753], [-116.89743, 32.6274], [-116.89707, 32.62769], [-116.89793, 32.63009], [-116.88457, 32.63001], [-116.88455, 32.63627], [-116.88388, 32.63655], [-116.88395, 32.63669], [-116.88456, 32.63645], [-116.88456, 32.63712], [-116.88419, 32.6369], [-116.87995, 32.63794], [-116.88014, 32.6264], [-116.88012, 32.62103], [-116.88238, 32.62103], [-116.88244, 32.62281], [-116.88697, 32.62282], [-116.88698, 32.62281], [-116.88695, 32.62103], [-116.89126, 32.62103], [-116.89127, 32.62102], [-116.89126, 32.61923], [-116.88897, 32.6192], [-116.88905, 32.61191], [-116.88462, 32.61186], [-116.88464, 32.60815], [-116.88021, 32.60808], [-116.8803, 32.60065], [-116.88463, 32.60062], [-116.88467, 32.60441], [-116.88904, 32.60446], [-116.88906, 32.60819], [-116.89345, 32.60825], [-116.8935, 32.61196], [-116.90214, 32.61197], [-116.90219, 32.61926], [-116.90665, 32.61927], [-116.90658, 32.61567], [-116.91094, 32.61568], [-116.91232, 32.61566], [-116.91247, 32.61929]]]} | Open Access 1 | 7374 | Otay Mountain Ecological Reserve | 32253 | 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/Otay-Mountain-ER | San Diego 4 | 1249.798 | Otay Mtn. ER | 2000 | 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 | |
7943 | 7943 | 7942 | {"type": "Polygon", "coordinates": [[[-117.31409, 33.26596], [-117.31244, 33.26727], [-117.30794, 33.27072], [-117.30548, 33.27069], [-117.30547, 33.27033], [-117.30435, 33.26951], [-117.30519, 33.26907], [-117.30555, 33.26881], [-117.30577, 33.26861], [-117.30596, 33.26842], [-117.30613, 33.2682], [-117.3063, 33.26795], [-117.3065, 33.26758], [-117.30663, 33.26721], [-117.30697, 33.26562], [-117.30711, 33.26519], [-117.30724, 33.26491], [-117.30855, 33.26259], [-117.30968, 33.26343], [-117.30968, 33.26348], [-117.31094, 33.26441], [-117.31319, 33.26338], [-117.31318, 33.26336], [-117.31161, 33.26212], [-117.31266, 33.2613], [-117.31338, 33.26127], [-117.31404, 33.26172], [-117.31409, 33.26596]]]} | Open Access 1 | 12835 | Pilgrim Creek Ecological Reserve | 32262 | 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/Pilgrim-Creek-ER | San Diego 4 | 112.058 | Pilgrim Creek ER | 2004 | 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 |
9383 | 9383 | 9382 | {"type": "Polygon", "coordinates": [[[-117.02409, 33.01859], [-117.02405, 33.01935], [-117.02293, 33.01948], [-117.02294, 33.02011], [-117.02331, 33.02046], [-117.02327, 33.02094], [-117.01484, 33.02106], [-117.01495, 33.02313], [-117.00114, 33.02272], [-117.00003, 33.02187], [-116.99656, 33.02181], [-116.99647, 33.01886], [-117.00116, 33.01884], [-117.00113, 33.01494], [-117.00176, 33.01492], [-117.00139, 33.01566], [-117.00152, 33.01603], [-117.00223, 33.01638], [-117.00261, 33.01628], [-117.00335, 33.01606], [-117.00334, 33.01603], [-117.00323, 33.01592], [-117.00268, 33.01605], [-117.00264, 33.01604], [-117.00272, 33.01546], [-117.00243, 33.01541], [-117.00251, 33.0149], [-117.00388, 33.01485], [-117.00394, 33.01295], [-117.00393, 33.01294], [-117.00285, 33.01294], [-117.00251, 33.01231], [-117.00056, 33.01283], [-117.00029, 33.01496], [-116.99635, 33.01507], [-116.99612, 33.00753], [-117.00411, 33.00747], [-117.0041, 33.00787], [-117.00447, 33.0083], [-117.00662, 33.00841], [-117.00625, 33.01481], [-117.01452, 33.01459], [-117.01694, 33.01452], [-117.01747, 33.01518], [-117.01827, 33.0154], [-117.01849, 33.01544], [-117.01867, 33.01545], [-117.01925, 33.0154], [-117.01967, 33.01533], [-117.02092, 33.01516], [-117.02205, 33.0149], [-117.02266, 33.01473], [-117.02288, 33.01469], [-117.02335, 33.01457], [-117.02371, 33.01452], [-117.02372, 33.01475], [-117.02384, 33.01474], [-117.02387, 33.01556], [-117.02391, 33.0158], [-117.02389, 33.01581], [-117.02396, 33.01607], [-117.02353, 33.01605], [-117.02223, 33.01607], [-117.02226, 33.01868], [-117.02227, 33.01869], [-117.02409, 33.01859]]]} | Open Access 1 | 12141 | Blue Sky Ecological Reserve | 32055 | 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/Blue-Sky-ER | San Diego 4 | 615.641 | Blue Sky ER | 1991 | 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 |
10218 | 10218 | 10217 | {"type": "Polygon", "coordinates": [[[-116.24695, 32.6718], [-116.23842, 32.67171], [-116.23847, 32.66811], [-116.24027, 32.66814], [-116.24269, 32.66815], [-116.24274, 32.66648], [-116.24269, 32.66439], [-116.23619, 32.66435], [-116.22572, 32.6643], [-116.22578, 32.66803], [-116.20837, 32.66849], [-116.20828, 32.66138], [-116.20829, 32.66123], [-116.20841, 32.66075], [-116.21057, 32.66133], [-116.21259, 32.66159], [-116.22394, 32.66195], [-116.22397, 32.66228], [-116.22796, 32.66133], [-116.23184, 32.66128], [-116.23457, 32.66132], [-116.23462, 32.66173], [-116.23578, 32.66182], [-116.23586, 32.66158], [-116.24685, 32.66465], [-116.24695, 32.6718]]]} | Open Access 1 | 12830 | Walker Canyon Ecological Reserve | 32345 | 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/Walker-Canyon-ER | San Diego 4 | 524.681 | Walker Canyon ER | 2000 | 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 | |
11156 | 11156 | 11155 | {"type": "Polygon", "coordinates": [[[-116.90441, 32.75514], [-116.9042, 32.75543], [-116.90407, 32.75564], [-116.90348, 32.75678], [-116.90332, 32.757], [-116.90311, 32.75723], [-116.90293, 32.75733], [-116.90145, 32.75802], [-116.90082, 32.75835], [-116.90071, 32.75832], [-116.89885, 32.75829], [-116.89334, 32.75816], [-116.89333, 32.75818], [-116.89296, 32.75819], [-116.88947, 32.75827], [-116.88946, 32.75829], [-116.89038, 32.75989], [-116.89, 32.76006], [-116.88999, 32.76011], [-116.88798, 32.76063], [-116.88761, 32.76115], [-116.88692, 32.76159], [-116.88571, 32.76176], [-116.88486, 32.76206], [-116.88474, 32.76206], [-116.88472, 32.75838], [-116.88911, 32.75827], [-116.88907, 32.75471], [-116.8916, 32.75467], [-116.89339, 32.75461], [-116.89338, 32.7536], [-116.89436, 32.75358], [-116.89434, 32.75303], [-116.89338, 32.75303], [-116.89335, 32.75103], [-116.89764, 32.75105], [-116.8977, 32.75483], [-116.89744, 32.75509], [-116.89744, 32.7551], [-116.90441, 32.75514]]]} | Open Access 1 | 47977 | McGinty Mountain Ecological Reserve | 32353 | 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 | 199.627 | McGinty Mtn. ER | 1993 | 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 |
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]);