units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
63 rows where ACCESS_TYP = 2 and AGNCY_TYP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY 15
- Sacramento, County of 17
- Los Angeles, County of 5
- Los Angeles - Department of Parks and Recreation, County of 4
- Orange, County of 3
- Santa Cruz, County of 2
- San Luis Obispo, County of 2
- San Diego, County of 2
- Monterey, County of 1
- California Department of Fish and Wildlife 1
- Ventura, County of 1
- Placer, County of 1
- Torrance, City of 1
- Fresno, County of 1
- Kern, County of 1
- National Audubon Society 1
DES_TP 15
- Local Recreation Area 20
- Local Conservation Area 7
- Local Other or Unknown 3
- Local Park 2
- State Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 5
ACCESS_TYP 1
- Restricted Access · 43 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6002 | 6002 | 6001 | {"type": "Polygon", "coordinates": [[[-119.16058, 34.28227], [-119.1606, 34.28232], [-119.16056, 34.28237], [-119.1576, 34.28415], [-119.15733, 34.28384], [-119.15656, 34.2843], [-119.15656, 34.28431], [-119.15682, 34.28462], [-119.15395, 34.28635], [-119.15198, 34.28407], [-119.15254, 34.28373], [-119.15218, 34.28332], [-119.15296, 34.28284], [-119.15581, 34.28113], [-119.15737, 34.28293], [-119.16005, 34.28166], [-119.16058, 34.28227]]]} | Restricted Access 2 | 646 | Saticoy Regional Golf Course | 32989 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 48.962 | Saticoy Reg. GC | 0 | Local Recreation Area 3 | 4 | |
6086 | 6086 | 6085 | {"type": "MultiPolygon", "coordinates": [[[[-117.00116, 33.01884], [-116.99647, 33.01886], [-116.99635, 33.01507], [-117.00112, 33.01494], [-117.00116, 33.01884]]], [[[-117.01695, 33.01451], [-117.01452, 33.01459], [-117.00983, 33.01471], [-117.00983, 33.01458], [-117.01035, 33.01452], [-117.01054, 33.01217], [-117.01092, 33.01197], [-117.01481, 33.01197], [-117.01603, 33.01335], [-117.01695, 33.01451]]]]} | Restricted Access 2 | 891 | Blue Sky Ecological Reserve | 29220 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 83.938 | Blue Sky ER | 1991 | Local Conservation Area 4 | 2 | |
7384 | 7384 | 7383 | {"type": "MultiPolygon", "coordinates": [[[[-117.75565, 34.14631], [-117.75553, 34.14714], [-117.75483, 34.1482], [-117.75272, 34.15092], [-117.75047, 34.15094], [-117.75081, 34.15065], [-117.75101, 34.15053], [-117.75273, 34.14962], [-117.75307, 34.1494], [-117.75341, 34.14911], [-117.7536, 34.14891], [-117.75565, 34.14631]]], [[[-117.75567, 34.14565], [-117.75562, 34.14593], [-117.75555, 34.14608], [-117.75543, 34.1463], [-117.75346, 34.14879], [-117.75329, 34.14898], [-117.75306, 34.14919], [-117.75271, 34.14943], [-117.75105, 34.1503], [-117.75068, 34.15053], [-117.75049, 34.15067], [-117.75008, 34.15106], [-117.74901, 34.1523], [-117.74894, 34.15235], [-117.74876, 34.15247], [-117.74856, 34.15255], [-117.74841, 34.1526], [-117.74818, 34.15264], [-117.74703, 34.15265], [-117.74681, 34.15262], [-117.74662, 34.15256], [-117.74658, 34.15137], [-117.74647, 34.14969], [-117.74586, 34.14597], [-117.75013, 34.14351], [-117.75014, 34.14318], [-117.75037, 34.14309], [-117.75042, 34.14294], [-117.75065, 34.14274], [-117.7508, 34.14274], [-117.75097, 34.14262], [-117.75147, 34.14253], [-117.75189, 34.14258], [-117.75194, 34.14258], [-117.75204, 34.14273], [-117.7528, 34.14244], [-117.75279, 34.14352], [-117.75422, 34.14353], [-117.75379, 34.14549], [-117.75567, 34.14565]]], [[[-117.75033, 34.15136], [-117.74915, 34.15243], [-117.74893, 34.15258], [-117.74874, 34.15267], [-117.74861, 34.15271], [-117.74889, 34.1526], [-117.74919, 34.15238], [-117.75024, 34.15115], [-117.75033, 34.15107], [-117.75033, 34.15136]]]]} | Restricted Access 2 | 6781 | Marshall Canyon Golf Course | 32492 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 157.54 | Marshall Canyon GC | 0 | Local Recreation Area 3 | 4 | |
7496 | 7496 | 7495 | {"type": "Polygon", "coordinates": [[[-118.04347, 34.13092], [-118.04339, 34.13133], [-118.0426, 34.13196], [-118.04287, 34.13232], [-118.04246, 34.13254], [-118.04197, 34.13285], [-118.0416, 34.13314], [-118.04112, 34.13356], [-118.04211, 34.13249], [-118.04222, 34.13228], [-118.04225, 34.13218], [-118.04224, 34.13217], [-118.04223, 34.13217], [-118.03927, 34.13536], [-118.03909, 34.13561], [-118.03898, 34.13586], [-118.0383, 34.1366], [-118.03775, 34.13635], [-118.03681, 34.13613], [-118.03624, 34.13619], [-118.03571, 34.13614], [-118.0349, 34.13614], [-118.03405, 34.13627], [-118.03343, 34.13635], [-118.03292, 34.13634], [-118.03259, 34.13625], [-118.03227, 34.13601], [-118.03198, 34.13576], [-118.03151, 34.13565], [-118.03143, 34.1309], [-118.03583, 34.13086], [-118.04244, 34.13075], [-118.04347, 34.13092]], [[-118.04259, 34.13197], [-118.04251, 34.13188], [-118.04241, 34.13199], [-118.04249, 34.13208], [-118.04259, 34.13197]]]} | Restricted Access 2 | 7018 | Santa Anita Golf Course | 33023 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 130.957 | Santa Anita GC | 0 | Local Recreation Area 3 | 4 | |
8644 | 8644 | 8643 | {"type": "Polygon", "coordinates": [[[-121.62329, 36.69175], [-121.62139, 36.69476], [-121.62267, 36.69557], [-121.62305, 36.69583], [-121.62239, 36.69593], [-121.62224, 36.69599], [-121.62208, 36.69612], [-121.62156, 36.69684], [-121.62114, 36.69815], [-121.61922, 36.69881], [-121.61535, 36.69667], [-121.61887, 36.69401], [-121.61838, 36.69346], [-121.61979, 36.69213], [-121.62135, 36.69028], [-121.623, 36.69156], [-121.62329, 36.69175]]]} | Restricted Access 2 | 1466 | Twin Creeks Golf Course | 32997 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 76.277 | Twin Creeks GC | 0 | Local Recreation Area 3 | 4 | |
9135 | 9135 | 9134 | {"type": "Polygon", "coordinates": [[[-121.8062, 36.9086], [-121.80603, 36.90929], [-121.80576, 36.90997], [-121.80555, 36.91066], [-121.80541, 36.91092], [-121.80506, 36.91124], [-121.8049, 36.9115], [-121.80481, 36.91148], [-121.80472, 36.91147], [-121.80272, 36.91153], [-121.80291, 36.90858], [-121.8062, 36.9086]]]} | Restricted Access 2 | 16765 | Harkins Slough | 28149 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 20.48 | Harkins Slough | 0 | Local Conservation Area 4 | 2 | |
9698 | 9698 | 9697 | {"type": "MultiPolygon", "coordinates": [[[[-121.81062, 36.91], [-121.81032, 36.90991], [-121.81001, 36.91005], [-121.80937, 36.91143], [-121.80919, 36.91137], [-121.8094, 36.9109], [-121.80963, 36.91001], [-121.80983, 36.90957], [-121.80981, 36.90862], [-121.81062, 36.91]]], [[[-121.8208, 36.91677], [-121.81946, 36.91684], [-121.8184, 36.91715], [-121.81784, 36.91788], [-121.81749, 36.91791], [-121.81589, 36.91711], [-121.81536, 36.91645], [-121.8149, 36.91595], [-121.81467, 36.91595], [-121.81398, 36.91524], [-121.81264, 36.91331], [-121.81191, 36.9127], [-121.81154, 36.9117], [-121.81148, 36.91147], [-121.81215, 36.91259], [-121.81332, 36.91179], [-121.8138, 36.91263], [-121.81399, 36.91289], [-121.81422, 36.91312], [-121.81616, 36.91481], [-121.81662, 36.91515], [-121.81714, 36.91542], [-121.8177, 36.91562], [-121.8183, 36.91574], [-121.81892, 36.91578], [-121.81954, 36.91574], [-121.82052, 36.91553], [-121.8208, 36.91677]]]]} | Restricted Access 2 | 16385 | Gallighan Slough | 28152 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 41.877 | Gallighan Slough | 0 | Local Conservation Area 4 | 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 |
11132 | 11132 | 11131 | {"type": "MultiPolygon", "coordinates": [[[[-121.09148, 38.49227], [-121.09125, 38.49243], [-121.09091, 38.49263], [-121.09073, 38.49271], [-121.09048, 38.49267], [-121.09013, 38.49268], [-121.0895, 38.49277], [-121.08916, 38.49278], [-121.08856, 38.49271], [-121.08839, 38.49288], [-121.08806, 38.49299], [-121.08776, 38.49324], [-121.08758, 38.49346], [-121.08736, 38.49369], [-121.08706, 38.49389], [-121.08684, 38.49411], [-121.08668, 38.49447], [-121.08635, 38.49468], [-121.08587, 38.4948], [-121.08548, 38.49497], [-121.08494, 38.49507], [-121.08444, 38.49513], [-121.08401, 38.49522], [-121.08368, 38.4954], [-121.08321, 38.49533], [-121.08263, 38.4952], [-121.08218, 38.49516], [-121.08186, 38.49517], [-121.08155, 38.49514], [-121.08119, 38.49514], [-121.08085, 38.49518], [-121.08048, 38.49518], [-121.07954, 38.49521], [-121.07918, 38.4953], [-121.07885, 38.49527], [-121.07803, 38.49512], [-121.07721, 38.49518], [-121.07672, 38.49507], [-121.07643, 38.49489], [-121.07601, 38.49485], [-121.07561, 38.49479], [-121.07506, 38.49468], [-121.0745, 38.49467], [-121.07387, 38.49457], [-121.07313, 38.4944], [-121.07188, 38.49433], [-121.07136, 38.49445], [-121.0709, 38.49468], [-121.07057, 38.49491], [-121.07008, 38.49571], [-121.06978, 38.49606], [-121.06879, 38.4965], [-121.0684, 38.49662], [-121.06787, 38.4969], [-121.06772, 38.49747], [-121.06745, 38.49789], [-121.06741, 38.4964], [-121.0678, 38.49625], [-121.06829, 38.49619], [-121.0692, 38.4956], [-121.06938, 38.49529], [-121.06934, 38.49511], [-121.06944, 38.49477], [-121.06956, 38.4945], [-121.07004, 38.4941], [-121.07124, 38.49356], [-121.07312, 38.49317], [-121.07514, 38.49348], [-121.07693, 38.49402], [-121.08244, 38.49408], [-121.08245, 38.49418], [-121.08279, 38.49418], [-121.08281, 38.49409], [-121.083, 38.49409], [-121.08466, 38.49399], [-121.08601, 38.4936], [-121.08706, 38.49299], [-121.08713, 38.49306], [-121.08756, 38.49279], [-121.08806, 38.49236], [-121.08926, 38.49218], [-121.0898, 38.49205], [-121.09063, 38.49184], [-121.09106, 38.49171], [-121.09128, 38.49189], [-121.09127, 38.49191], [-121.09133, 38.49195], [-121.09148, 38.49227]]], [[[-121.11462, 38.48233], [-121.11316, 38.48204], [-121.10939, 38.48209], [-121.10861, 38.48241], [-121.10763, 38.483], [-121.10532, 38.48394], [-121.10435, 38.48511], [-121.10083, 38.48719], [-121.10067, 38.48782], [-121.09651, 38.49026], [-121.09674, 38.49053], [-121.09379, 38.49339], [-121.09281, 38.49263], [-121.09319, 38.49205], [-121.09333, 38.49171], [-121.09343, 38.49155], [-121.09393, 38.48993], [-121.09485, 38.48922], [-121.09593, 38.48922], [-121.09595, 38.48641], [-121.09858, 38.48505], [-121.09983, 38.48505], [-121.09985, 38.48438], [-121.10456, 38.4818], [-121.11192, 38.48073], [-121.1122, 38.4807], [-121.1146, 38.48154], [-121.11462, 38.48233]]]]} | Restricted Access 2 | 21421 | Cosumnes River Parkway | 17677 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 188.683 | Cosumnes River Parkway | 0 | Local Recreation Area 3 | 4 | |
11133 | 11133 | 11132 | {"type": "Polygon", "coordinates": [[[-121.51691, 38.25947], [-121.50965, 38.26426], [-121.5083, 38.26215], [-121.50771, 38.26135], [-121.5073, 38.26083], [-121.50498, 38.25966], [-121.50269, 38.25821], [-121.5029, 38.25787], [-121.50312, 38.25794], [-121.50676, 38.25202], [-121.50862, 38.25131], [-121.50878, 38.25131], [-121.50893, 38.25149], [-121.50982, 38.25136], [-121.5103, 38.25196], [-121.51058, 38.25188], [-121.51111, 38.25283], [-121.51144, 38.25331], [-121.5121, 38.2541], [-121.51264, 38.25478], [-121.51317, 38.25533], [-121.51401, 38.25612], [-121.51486, 38.25683], [-121.51562, 38.2574], [-121.51648, 38.25796], [-121.51562, 38.25854], [-121.51691, 38.25947]]]} | Restricted Access 2 | 21424 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 229.043 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
11134 | 11134 | 11133 | {"type": "MultiPolygon", "coordinates": [[[[-121.35455, 38.51709], [-121.3545, 38.51715], [-121.35442, 38.51718], [-121.35373, 38.5172], [-121.35298, 38.51727], [-121.35225, 38.5174], [-121.35179, 38.51751], [-121.3517, 38.51748], [-121.35166, 38.51743], [-121.35166, 38.51736], [-121.35171, 38.51731], [-121.35187, 38.51726], [-121.35204, 38.51726], [-121.35228, 38.51719], [-121.35251, 38.5171], [-121.35272, 38.51697], [-121.35284, 38.51691], [-121.35299, 38.5169], [-121.35312, 38.51694], [-121.35328, 38.517], [-121.35345, 38.51702], [-121.35362, 38.51698], [-121.35365, 38.51696], [-121.35399, 38.51694], [-121.35409, 38.51692], [-121.35441, 38.51693], [-121.3545, 38.51696], [-121.35455, 38.51702], [-121.35455, 38.51709]]], [[[-121.35432, 38.51553], [-121.35427, 38.5156], [-121.3541, 38.51566], [-121.35309, 38.51629], [-121.35292, 38.51649], [-121.35269, 38.51664], [-121.3522, 38.51683], [-121.35209, 38.51683], [-121.35195, 38.51683], [-121.35186, 38.51678], [-121.35182, 38.5167], [-121.35182, 38.51662], [-121.35187, 38.51655], [-121.35249, 38.51617], [-121.35256, 38.51606], [-121.35255, 38.51596], [-121.35248, 38.51586], [-121.35236, 38.5158], [-121.35222, 38.51579], [-121.35213, 38.51583], [-121.35197, 38.51584], [-121.35189, 38.51584], [-121.35181, 38.5158], [-121.35177, 38.51574], [-121.35178, 38.51566], [-121.35183, 38.5156], [-121.35279, 38.51544], [-121.35358, 38.51537], [-121.35418, 38.51535], [-121.35427, 38.51538], [-121.35432, 38.51545], [-121.35432, 38.51553]]], [[[-121.35456, 38.51613], [-121.35451, 38.51619], [-121.35443, 38.51622], [-121.35412, 38.51626], [-121.35381, 38.51634], [-121.35353, 38.51646], [-121.3535, 38.51646], [-121.35367, 38.51628], [-121.35388, 38.51614], [-121.35413, 38.51605], [-121.3544, 38.51601], [-121.35449, 38.51602], [-121.35455, 38.51607], [-121.35456, 38.51613]]], [[[-121.35835, 38.5161], [-121.35832, 38.51617], [-121.35824, 38.51623], [-121.35814, 38.51625], [-121.35804, 38.51623], [-121.35786, 38.51611], [-121.35774, 38.51607], [-121.35751, 38.51606], [-121.35743, 38.5161], [-121.35739, 38.51617], [-121.35749, 38.51636], [-121.35747, 38.51643], [-121.3574, 38.51646], [-121.35734, 38.51646], [-121.35719, 38.51634], [-121.35708, 38.51618], [-121.3567, 38.51597], [-121.35641, 38.51587], [-121.35611, 38.5158], [-121.35601, 38.51579], [-121.35592, 38.51574], [-121.35587, 38.51567], [-121.35588, 38.51558], [-121.35594, 38.51551], [-121.35603, 38.51547], [-121.35614, 38.51548], [-121.35672, 38.51557], [-121.35748, 38.51574], [-121.3582, 38.51595], [-121.35828, 38.51601], [-121.35835, 38.5161]]], [[[-121.35658, 38.51631], [-121.35641, 38.51634], [-121.35628, 38.51633], [-121.35605, 38.51625], [-121.35599, 38.51617], [-121.35599, 38.51608], [-121.35617, 38.51607], [-121.35634, 38.5161], [-121.35649, 38.51619], [-121.35658, 38.51631]]], [[[-121.35831, 38.51766], [-121.35829, 38.51774], [-121.35821, 38.5178], [-121.35813, 38.5178], [-121.35742, 38.51758], [-121.3567, 38.5174], [-121.35624, 38.51732], [-121.35615, 38.51727], [-121.35611, 38.51719], [-121.35613, 38.51711], [-121.35621, 38.51705], [-121.35632, 38.51704], [-121.35648, 38.51708], [-121.35658, 38.51714], [-121.35674, 38.5172], [-121.35709, 38.51725], [-121.35718, 38.51723], [-121.35723, 38.51718], [-121.35723, 38.5171], [-121.35688, 38.51665], [-121.35686, 38.51659], [-121.35686, 38.51657], [-121.35689, 38.51655], [-121.35702, 38.51655], [-121.35718, 38.51665], [-121.35723, 38.51679], [-121.35737, 38.51698], [-121.35747, 38.51717], [-121.35798, 38.51748], [-121.35826, 38.51759], [-121.35831, 38.51766]]]]} | Restricted Access 2 | 21428 | Morrison Creek Mining | 22496 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 10.801 | Morrison Creek Mining | None 972 | |||
11138 | 11138 | 11137 | {"type": "Polygon", "coordinates": [[[-121.29786, 38.49822], [-121.29733, 38.49802], [-121.2969, 38.49796], [-121.29661, 38.49799], [-121.29634, 38.49832], [-121.29629, 38.49874], [-121.29647, 38.49922], [-121.29644, 38.49953], [-121.29651, 38.49982], [-121.29676, 38.49992], [-121.29701, 38.49988], [-121.29784, 38.49901], [-121.29783, 38.50332], [-121.29735, 38.50321], [-121.29714, 38.50313], [-121.29689, 38.50305], [-121.29688, 38.50306], [-121.29691, 38.50315], [-121.29703, 38.50326], [-121.29748, 38.50354], [-121.29428, 38.50352], [-121.29385, 38.50329], [-121.29323, 38.50315], [-121.29275, 38.50326], [-121.29239, 38.50351], [-121.28867, 38.50348], [-121.28869, 38.50214], [-121.2923, 38.50215], [-121.29546, 38.49847], [-121.29544, 38.49627], [-121.29762, 38.49629], [-121.29774, 38.49637], [-121.29785, 38.49753], [-121.29786, 38.49822]], [[-121.29624, 38.50255], [-121.29625, 38.50254], [-121.29618, 38.50232], [-121.29606, 38.50211], [-121.29588, 38.50192], [-121.29566, 38.50176], [-121.29541, 38.50164], [-121.29512, 38.50157], [-121.29483, 38.50154], [-121.29453, 38.50156], [-121.29425, 38.50162], [-121.29398, 38.50173], [-121.29374, 38.50176], [-121.29351, 38.50182], [-121.2933, 38.50192], [-121.29313, 38.50205], [-121.293, 38.50219], [-121.29301, 38.5022], [-121.29326, 38.50215], [-121.29354, 38.50213], [-121.29382, 38.50215], [-121.29409, 38.50221], [-121.29464, 38.50225], [-121.29519, 38.50231], [-121.29572, 38.50242], [-121.29624, 38.50255]]]} | Restricted Access 2 | 21429 | Arroyo Seco (florin Mitigation Bank) | 15628 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 66.229 | Arroyo Seco (florin Mitigation Bank) | 0 | Local Other or Unknown 14 | 4 | |
11141 | 11141 | 11140 | {"type": "Polygon", "coordinates": [[[-121.2683, 38.7177], [-121.26769, 38.71781], [-121.26746, 38.71783], [-121.26736, 38.71789], [-121.26714, 38.71792], [-121.26714, 38.71772], [-121.26729, 38.71769], [-121.26752, 38.71753], [-121.2683, 38.71752], [-121.2683, 38.7177]]]} | Restricted Access 2 | 21443 | Nevinshire | 22705 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.662 | Nevinshire | None 973 | |||
11174 | 11174 | 11173 | {"type": "Polygon", "coordinates": [[[-121.20529, 38.35592], [-121.20528, 38.35682], [-121.20307, 38.35681], [-121.20308, 38.3559], [-121.20529, 38.35592]]]} | Restricted Access 2 | 22245 | Terry Parker Et Al | 26269 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 4.819 | Terry Parker Et Al | None 975 | |||
11194 | 11194 | 11193 | {"type": "Polygon", "coordinates": [[[-121.35327, 38.45636], [-121.35322, 38.45992], [-121.35131, 38.45992], [-121.3513, 38.45977], [-121.35097, 38.45977], [-121.35102, 38.45972], [-121.35104, 38.45966], [-121.35101, 38.45955], [-121.35101, 38.45909], [-121.35105, 38.45881], [-121.35101, 38.45853], [-121.35101, 38.45828], [-121.35103, 38.45815], [-121.35115, 38.45772], [-121.35118, 38.45754], [-121.35122, 38.45751], [-121.35151, 38.45747], [-121.35171, 38.4574], [-121.3519, 38.45729], [-121.35207, 38.45714], [-121.35219, 38.45698], [-121.35227, 38.45677], [-121.35228, 38.45663], [-121.35226, 38.45636], [-121.35327, 38.45636]]]} | Restricted Access 2 | 21470 | D R Horton Inc Sacramento | 17889 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 15.774 | D R Horton Inc Sacramento | None 976 | |||
11202 | 11202 | 11201 | {"type": "Polygon", "coordinates": [[[-121.48774, 38.4088], [-121.48772, 38.40888], [-121.48765, 38.40901], [-121.48756, 38.4091], [-121.48745, 38.40917], [-121.48727, 38.40925], [-121.48678, 38.40939], [-121.48637, 38.40956], [-121.48599, 38.40978], [-121.48562, 38.41006], [-121.48533, 38.41036], [-121.48511, 38.41068], [-121.48492, 38.41107], [-121.48483, 38.4114], [-121.48435, 38.4089], [-121.48598, 38.40887], [-121.48656, 38.40882], [-121.48774, 38.4088]]]} | Restricted Access 2 | 21496 | Stone Lakes | 25873 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 7.901 | Stone Lakes | None 977 | |||
11376 | 11376 | 11375 | {"type": "Polygon", "coordinates": [[[-121.39798, 38.71663], [-121.39679, 38.71662], [-121.39676, 38.71656], [-121.39668, 38.71625], [-121.39666, 38.71594], [-121.39669, 38.71563], [-121.39678, 38.71532], [-121.39678, 38.71519], [-121.39741, 38.71519], [-121.39736, 38.71531], [-121.39736, 38.71543], [-121.39743, 38.71553], [-121.39768, 38.71574], [-121.39785, 38.71583], [-121.39795, 38.71602], [-121.39798, 38.71663]]]} | Restricted Access 2 | 22186 | Atreule Et Al Community Plan | 15676 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 3.539 | Atreule Et Al Community Plan | None 1000 | |||
11385 | 11385 | 11384 | {"type": "Polygon", "coordinates": [[[-121.17077, 38.75418], [-121.16993, 38.75466], [-121.1697, 38.75468], [-121.16948, 38.75447], [-121.1688, 38.75478], [-121.16876, 38.75502], [-121.16861, 38.7552], [-121.16835, 38.75537], [-121.16788, 38.7554], [-121.16753, 38.75571], [-121.16726, 38.75588], [-121.16716, 38.75623], [-121.16677, 38.75661], [-121.16673, 38.75682], [-121.16613, 38.75708], [-121.16599, 38.75725], [-121.16577, 38.75739], [-121.16555, 38.75728], [-121.16531, 38.75748], [-121.16497, 38.75763], [-121.16483, 38.75781], [-121.16452, 38.75776], [-121.16401, 38.7578], [-121.164, 38.75736], [-121.16404, 38.75718], [-121.16409, 38.75705], [-121.16416, 38.7569], [-121.16436, 38.75666], [-121.16713, 38.75422], [-121.16735, 38.75406], [-121.16907, 38.75301], [-121.17077, 38.75418]]]} | Restricted Access 2 | 22191 | Miners Ravine Nature Reserve | 22264 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 24.569 | Miners Ravine Nature Reserve | 0 | Local Conservation Area 4 | 2 | |
11398 | 11398 | 11397 | {"type": "MultiPolygon", "coordinates": [[[[-121.24893, 38.67172], [-121.2489, 38.67173], [-121.24889, 38.67164], [-121.24884, 38.67156], [-121.2486, 38.67133], [-121.24893, 38.67133], [-121.24893, 38.67172]]], [[[-121.25125, 38.67334], [-121.25049, 38.67337], [-121.25043, 38.67336], [-121.24934, 38.67255], [-121.24894, 38.67232], [-121.24893, 38.67184], [-121.24905, 38.67183], [-121.24903, 38.67201], [-121.24906, 38.67206], [-121.24937, 38.67222], [-121.24962, 38.67238], [-121.25057, 38.67308], [-121.25063, 38.67309], [-121.25112, 38.67306], [-121.25117, 38.67304], [-121.25125, 38.67298], [-121.25125, 38.67334]]]]} | Restricted Access 2 | 22206 | Sunrise Recreation/parks District | 26038 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 2.065 | Sunrise Rec./parks District | 0 | Local Recreation Area 3 | 4 | |
11410 | 11410 | 11409 | {"type": "Polygon", "coordinates": [[[-121.45132, 38.38301], [-121.45064, 38.38333], [-121.45063, 38.38332], [-121.45032, 38.38293], [-121.44997, 38.38258], [-121.44967, 38.38233], [-121.44924, 38.38204], [-121.44983, 38.3814], [-121.45112, 38.3813], [-121.45132, 38.38301]]]} | Restricted Access 2 | 22247 | Kenneth Way Drainage | 20610 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 6.273 | Kenneth Way Drainage | None 1008 |
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]);