units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where COUNTY = 10, MNG_AGENCY = 47 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_LEV, LAYER, PARK_URL, LABEL_NAME
DES_TP 5
ACCESS_TYP 2
MNG_AG_TYP 1
- State Agency · 10 ✖
MNG_AGENCY 1
- California Department of Parks and Recreation · 10 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5306 | 5306 | 5305 | {"type": "Polygon", "coordinates": [[[-117.12552, 33.99331], [-117.12126, 33.99328], [-117.11256, 33.99348], [-117.11249, 33.98994], [-117.11245, 33.98023], [-117.11095, 33.97863], [-117.1105, 33.97829], [-117.10978, 33.9779], [-117.10945, 33.97776], [-117.10864, 33.97754], [-117.10816, 33.97747], [-117.10379, 33.97714], [-117.1038, 33.97554], [-117.10311, 33.9613], [-117.12114, 33.96103], [-117.12106, 33.97547], [-117.11887, 33.97549], [-117.11892, 33.97888], [-117.11702, 33.97902], [-117.11725, 33.98106], [-117.11679, 33.98109], [-117.11681, 33.98163], [-117.11762, 33.98158], [-117.11875, 33.98146], [-117.11944, 33.98136], [-117.12249, 33.98086], [-117.12289, 33.98081], [-117.12321, 33.98079], [-117.12326, 33.98622], [-117.12121, 33.98622], [-117.12124, 33.98976], [-117.12548, 33.98977], [-117.12552, 33.99331]], [[-117.1118, 33.97551], [-117.11183, 33.97539], [-117.11181, 33.97527], [-117.11161, 33.97497], [-117.11154, 33.97471], [-117.1115, 33.97466], [-117.11143, 33.97461], [-117.11132, 33.97458], [-117.11082, 33.97459], [-117.11052, 33.97453], [-117.11042, 33.97447], [-117.11014, 33.97416], [-117.11005, 33.97412], [-117.10995, 33.97411], [-117.10938, 33.97423], [-117.10928, 33.9742], [-117.10915, 33.97407], [-117.1089, 33.97423], [-117.10856, 33.97458], [-117.10841, 33.97491], [-117.10771, 33.97497], [-117.10783, 33.97519], [-117.10765, 33.97529], [-117.10752, 33.97541], [-117.10664, 33.97665], [-117.10653, 33.97672], [-117.10639, 33.97671], [-117.10638, 33.97672], [-117.10643, 33.97679], [-117.10689, 33.97686], [-117.10837, 33.97694], [-117.10878, 33.97699], [-117.10954, 33.97714], [-117.11031, 33.97741], [-117.11039, 33.97735], [-117.11049, 33.97733], [-117.11082, 33.97745], [-117.11095, 33.97745], [-117.11105, 33.97742], [-117.11114, 33.97738], [-117.11126, 33.97724], [-117.11128, 33.97716], [-117.11128, 33.97682], [-117.1114, 33.97631], [-117.11146, 33.97618], [-117.11157, 33.97605], [-117.11168, 33.97586], [-117.1118, 33.97551]]]} | No Public Access 3 | 5782 | San Timoteo Canyon | 24994 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Riverside 10 | 1079.444 | San Timoteo Canyon | 2002 | None 428 | ||
| 5314 | 5314 | 5313 | {"type": "MultiPolygon", "coordinates": [[[[-117.65112, 33.88518], [-117.65112, 33.88524], [-117.65075, 33.88593], [-117.65062, 33.88625], [-117.65052, 33.88655], [-117.65042, 33.88697], [-117.64996, 33.88712], [-117.65026, 33.88744], [-117.65022, 33.88756], [-117.64951, 33.88762], [-117.64971, 33.88805], [-117.65006, 33.88838], [-117.65009, 33.88856], [-117.64724, 33.88851], [-117.64703, 33.88828], [-117.64638, 33.88801], [-117.64634, 33.88727], [-117.64664, 33.88709], [-117.64661, 33.8869], [-117.64631, 33.88677], [-117.64626, 33.886], [-117.64657, 33.88589], [-117.64655, 33.88574], [-117.64946, 33.88479], [-117.65112, 33.88518]]], [[[-117.66475, 33.88794], [-117.66435, 33.88796], [-117.66385, 33.88794], [-117.66335, 33.88789], [-117.66296, 33.88782], [-117.64961, 33.88474], [-117.65126, 33.8842], [-117.65132, 33.88153], [-117.65332, 33.88116], [-117.65394, 33.88103], [-117.65442, 33.88088], [-117.65496, 33.88066], [-117.65584, 33.88018], [-117.65592, 33.87992], [-117.65677, 33.8801], [-117.65704, 33.88023], [-117.65688, 33.88018], [-117.65666, 33.88016], [-117.65645, 33.88019], [-117.65625, 33.88026], [-117.65518, 33.88095], [-117.65454, 33.88129], [-117.65438, 33.88143], [-117.65416, 33.8817], [-117.65462, 33.88199], [-117.65475, 33.88204], [-117.65492, 33.88208], [-117.65506, 33.88208], [-117.65524, 33.88205], [-117.65537, 33.88201], [-117.65555, 33.88192], [-117.65575, 33.88187], [-117.65675, 33.8819], [-117.65732, 33.88213], [-117.65918, 33.88354], [-117.66028, 33.88397], [-117.66078, 33.88439], [-117.66107, 33.88458], [-117.66139, 33.8847], [-117.66169, 33.88473], [-117.662, 33.88469], [-117.66227, 33.88458], [-117.66284, 33.88544], [-117.66475, 33.88794]]], [[[-117.67653, 33.88889], [-117.66341, 33.88881], [-117.65497, 33.88863], [-117.65026, 33.88856], [-117.65021, 33.88835], [-117.64987, 33.88803], [-117.64973, 33.88774], [-117.65041, 33.88767], [-117.65047, 33.8874], [-117.65024, 33.88717], [-117.6506, 33.88705], [-117.65069, 33.88662], [-117.65077, 33.88633], [-117.65104, 33.88572], [-117.65125, 33.88538], [-117.65252, 33.88568], [-117.65252, 33.88575], [-117.65347, 33.88596], [-117.65351, 33.88577], [-117.65127, 33.88526], [-117.65128, 33.88521], [-117.66304, 33.88792], [-117.66374, 33.88801], [-117.66435, 33.88804], [-117.66476, 33.88802], [-117.66516, 33.88798], [-117.66576, 33.88788], [-117.66615, 33.88779], [-117.66662, 33.88764], [-117.66699, 33.88749], [-117.66734, 33.88732], [-117.66768, 33.88714], [-117.66816, 33.88682], [-117.66845, 33.88659], [-117.66873, 33.88634], [-117.66898, 33.88607], [-117.66921, 33.8858], [-117.66942, 33.8855], [-117.6696, 33.8852], [-117.66976, 33.88488], [-117.67055, 33.88312], [-117.67106, 33.88362], [-117.67079, 33.88357], [-117.67079, 33.88359], [-117.67274, 33.88539], [-117.67276, 33.88671], [-117.67291, 33.88679], [-117.67292, 33.88705], [-117.6757, 33.88837], [-117.67653, 33.88889]]]]} | Open Access 1 | 5614 | Chino Hills State Park | 1478 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=648 | Riverside 10 | 292.456 | Chino Hills SP | 1981 | State Park 15 | 4 |
| 5632 | 5632 | 5631 | {"type": "MultiPolygon", "coordinates": [[[[-116.26591, 33.78761], [-116.26581, 33.80202], [-116.24858, 33.80208], [-116.23121, 33.80199], [-116.23116, 33.80026], [-116.24855, 33.80022], [-116.24856, 33.79477], [-116.23987, 33.79477], [-116.23986, 33.78758], [-116.24859, 33.78763], [-116.26591, 33.78761]]], [[[-116.30145, 33.86017], [-116.30142, 33.86747], [-116.30141, 33.87496], [-116.30074, 33.87495], [-116.30067, 33.87492], [-116.30005, 33.87492], [-116.30005, 33.87493], [-116.30008, 33.87495], [-116.29317, 33.87494], [-116.29102, 33.87491], [-116.29016, 33.87493], [-116.2834, 33.87491], [-116.28341, 33.88941], [-116.26792, 33.8894], [-116.25517, 33.88941], [-116.25461, 33.88877], [-116.25311, 33.88748], [-116.25301, 33.8873], [-116.25284, 33.88729], [-116.25094, 33.88578], [-116.25002, 33.88512], [-116.24954, 33.88478], [-116.24936, 33.88439], [-116.24922, 33.88418], [-116.24895, 33.8839], [-116.2486, 33.88367], [-116.24863, 33.87494], [-116.25703, 33.87492], [-116.25715, 33.86038], [-116.26604, 33.86033], [-116.26604, 33.85931], [-116.26614, 33.85775], [-116.26614, 33.85746], [-116.26611, 33.84611], [-116.27925, 33.85227], [-116.27926, 33.85226], [-116.27926, 33.85211], [-116.2661, 33.84595], [-116.2661, 33.84566], [-116.27921, 33.84574], [-116.28358, 33.84571], [-116.28368, 33.85948], [-116.2837, 33.86045], [-116.29236, 33.86028], [-116.30145, 33.86017]], [[-116.27672, 33.86041], [-116.27673, 33.8604], [-116.27672, 33.85966], [-116.27412, 33.85964], [-116.27413, 33.86039], [-116.27672, 33.86041]], [[-116.27929, 33.85664], [-116.27928, 33.85586], [-116.2767, 33.85585], [-116.27672, 33.85813], [-116.27931, 33.85814], [-116.27929, 33.85664]]], [[[-116.30986, 33.82114], [-116.30135, 33.82377], [-116.29663, 33.8238], [-116.29664, 33.82745], [-116.28792, 33.82751], [-116.28791, 33.82386], [-116.28355, 33.82389], [-116.28353, 33.824], [-116.28358, 33.83119], [-116.27488, 33.83114], [-116.27483, 33.82386], [-116.26613, 33.82383], [-116.25736, 33.82385], [-116.25735, 33.8166], [-116.25734, 33.81658], [-116.26606, 33.81656], [-116.2835, 33.81659], [-116.28347, 33.81289], [-116.29217, 33.81283], [-116.29237, 33.81661], [-116.3013, 33.81648], [-116.30554, 33.81132], [-116.3098, 33.8137], [-116.30974, 33.81656], [-116.30986, 33.82114]]]]} | Open Access 1 | 2099 | Indio Hills Palms | 1577 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=640 | Riverside 10 | 5703.211 | Indio Hills Palms | 1983 | None 455 | |
| 14612 | 14612 | 14611 | {"type": "MultiPolygon", "coordinates": [[[[-115.85227, 33.45336], [-115.85225, 33.45601], [-115.84339, 33.45573], [-115.84342, 33.44822], [-115.83486, 33.44796], [-115.83482, 33.44686], [-115.83471, 33.44137], [-115.83467, 33.44135], [-115.83467, 33.44132], [-115.8347, 33.44131], [-115.8347, 33.44126], [-115.83518, 33.44132], [-115.8375, 33.44131], [-115.84217, 33.44138], [-115.84249, 33.44141], [-115.84378, 33.44134], [-115.84467, 33.44136], [-115.85209, 33.44124], [-115.85217, 33.44525], [-115.85227, 33.45336]]], [[[-115.86954, 33.4268], [-115.86954, 33.42685], [-115.86943, 33.42686], [-115.8695, 33.44092], [-115.86815, 33.44098], [-115.85237, 33.44124], [-115.85237, 33.43948], [-115.85247, 33.42767], [-115.8523, 33.42677], [-115.85568, 33.42683], [-115.85569, 33.42686], [-115.86954, 33.4268]]], [[[-115.90464, 33.45563], [-115.90459, 33.47015], [-115.88726, 33.47025], [-115.88714, 33.47491], [-115.88438, 33.47362], [-115.88275, 33.47133], [-115.88276, 33.47016], [-115.88724, 33.4701], [-115.8871, 33.46767], [-115.88727, 33.45568], [-115.87012, 33.45559], [-115.86993, 33.4594], [-115.8697, 33.46293], [-115.86941, 33.46292], [-115.8694, 33.4628], [-115.86545, 33.46062], [-115.8655, 33.45934], [-115.86343, 33.45939], [-115.86122, 33.45801], [-115.86131, 33.45576], [-115.8638, 33.45578], [-115.87011, 33.45558], [-115.87012, 33.44116], [-115.87582, 33.44116], [-115.88726, 33.44099], [-115.88727, 33.45568], [-115.90464, 33.45563]]], [[[-115.90481, 33.48469], [-115.90471, 33.49104], [-115.90464, 33.49502], [-115.90447, 33.49485], [-115.90369, 33.494], [-115.90293, 33.49311], [-115.89935, 33.48832], [-115.90043, 33.4883], [-115.90028, 33.48473], [-115.90481, 33.48469]]], [[[-115.92191, 33.47016], [-115.92185, 33.48464], [-115.91746, 33.48465], [-115.91749, 33.48103], [-115.91321, 33.48096], [-115.91304, 33.48468], [-115.90881, 33.48469], [-115.90883, 33.48116], [-115.90454, 33.48114], [-115.90459, 33.47021], [-115.92191, 33.47016]]], [[[-115.92198, 33.49937], [-115.92182, 33.51089], [-115.91969, 33.51088], [-115.91784, 33.50922], [-115.91728, 33.50874], [-115.91664, 33.50809], [-115.91607, 33.5074], [-115.91549, 33.50657], [-115.91397, 33.50449], [-115.91353, 33.50392], [-115.91307, 33.50337], [-115.91249, 33.50273], [-115.90904, 33.4993], [-115.92198, 33.49937]]]]} | Open Access 1 | 44826 | Salton Sea State Recreation Area | 13840 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/default.asp?page_id=639 | Riverside 10 | 3392.068 | Salton Sea SRA | 1951 | State Recreation Area 39 | 4 |
| 16504 | 16504 | 16503 | {"type": "MultiPolygon", "coordinates": [[[[-117.41584, 33.89039], [-117.41541, 33.89094], [-117.41511, 33.89107], [-117.41508, 33.89095], [-117.41518, 33.89085], [-117.41511, 33.8908], [-117.4151, 33.89068], [-117.41509, 33.89068], [-117.415, 33.89084], [-117.41493, 33.89086], [-117.41483, 33.89098], [-117.41473, 33.89083], [-117.41472, 33.89067], [-117.41463, 33.89057], [-117.41449, 33.89053], [-117.41431, 33.89018], [-117.41429, 33.89018], [-117.41437, 33.89054], [-117.41453, 33.89069], [-117.41447, 33.89082], [-117.41431, 33.89083], [-117.41431, 33.89089], [-117.41443, 33.89103], [-117.41441, 33.89119], [-117.41446, 33.89129], [-117.41441, 33.89148], [-117.41442, 33.89158], [-117.41432, 33.8916], [-117.41451, 33.89196], [-117.4144, 33.89203], [-117.41404, 33.89198], [-117.41377, 33.89199], [-117.4135, 33.89186], [-117.41354, 33.89164], [-117.4134, 33.89163], [-117.4133, 33.89157], [-117.41336, 33.89147], [-117.41333, 33.89099], [-117.41341, 33.89088], [-117.4133, 33.8907], [-117.41332, 33.89056], [-117.41309, 33.89036], [-117.413, 33.89022], [-117.41287, 33.89013], [-117.41285, 33.88996], [-117.41272, 33.89], [-117.41254, 33.89021], [-117.41235, 33.89029], [-117.41194, 33.89031], [-117.41195, 33.88993], [-117.41184, 33.88988], [-117.41186, 33.88968], [-117.41174, 33.88961], [-117.41173, 33.88952], [-117.41159, 33.88956], [-117.41158, 33.88938], [-117.41133, 33.88943], [-117.41144, 33.88925], [-117.4112, 33.88913], [-117.41128, 33.88888], [-117.41085, 33.88867], [-117.41085, 33.88845], [-117.4106, 33.88852], [-117.41048, 33.88846], [-117.41045, 33.88823], [-117.41044, 33.88823], [-117.41021, 33.88855], [-117.40998, 33.88863], [-117.40985, 33.88821], [-117.40949, 33.88808], [-117.40925, 33.88786], [-117.4093, 33.88773], [-117.40977, 33.88755], [-117.40989, 33.88734], [-117.4097, 33.88701], [-117.40964, 33.88694], [-117.41085, 33.88738], [-117.41231, 33.88798], [-117.41291, 33.88834], [-117.41352, 33.88872], [-117.41408, 33.88914], [-117.41462, 33.88949], [-117.41584, 33.89039]]], [[[-117.42825, 33.89828], [-117.42551, 33.89984], [-117.42507, 33.89982], [-117.42447, 33.89968], [-117.42413, 33.89972], [-117.42387, 33.89991], [-117.42313, 33.90089], [-117.42295, 33.9013], [-117.42102, 33.9024], [-117.41746, 33.90445], [-117.41221, 33.89813], [-117.41103, 33.89667], [-117.41409, 33.89496], [-117.41445, 33.89493], [-117.41478, 33.89496], [-117.41517, 33.89544], [-117.41526, 33.89538], [-117.41851, 33.89932], [-117.42036, 33.89826], [-117.41811, 33.89551], [-117.41837, 33.89535], [-117.4186, 33.89529], [-117.41899, 33.89581], [-117.42006, 33.89559], [-117.42029, 33.89534], [-117.42021, 33.89448], [-117.42012, 33.89439], [-117.41995, 33.89439], [-117.42013, 33.89428], [-117.42019, 33.89428], [-117.42026, 33.89429], [-117.4205, 33.8944], [-117.42072, 33.89443], [-117.42092, 33.89442], [-117.42108, 33.89436], [-117.42117, 33.8943], [-117.42124, 33.89421], [-117.42129, 33.89411], [-117.42141, 33.89401], [-117.42153, 33.89405], [-117.42195, 33.89414], [-117.42262, 33.89437], [-117.42282, 33.89463], [-117.42312, 33.89445], [-117.42341, 33.8946], [-117.42361, 33.89468], [-117.42387, 33.89474], [-117.4243, 33.89469], [-117.42455, 33.89476], [-117.42507, 33.89494], [-117.42563, 33.89526], [-117.426, 33.89556], [-117.4265, 33.89614], [-117.42825, 33.89828]]], [[[-117.4211, 33.89413], [-117.42104, 33.89421], [-117.42094, 33.89427], [-117.42079, 33.8943], [-117.42061, 33.89428], [-117.4203, 33.89417], [-117.42015, 33.89415], [-117.42014, 33.8941], [-117.41976, 33.89373], [-117.4193, 33.89373], [-117.41907, 33.89345], [-117.41869, 33.89345], [-117.41845, 33.89311], [-117.41809, 33.8932], [-117.41755, 33.89264], [-117.41759, 33.89239], [-117.418, 33.89201], [-117.41868, 33.89265], [-117.41885, 33.89297], [-117.4192, 33.8931], [-117.41938, 33.89329], [-117.41972, 33.89351], [-117.41991, 33.89358], [-117.42044, 33.89369], [-117.42069, 33.89379], [-117.42107, 33.89392], [-117.4211, 33.89413]]]]} | Open Access 1 | 13493 | California Citrus State Historic Park | 1455 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=649 | Riverside 10 | 252.338 | California Citrus SHP | 1984 | State Historic or Cultural Area 132 | 4 |
| 16539 | 16539 | 16538 | {"type": "MultiPolygon", "coordinates": [[[[-116.7519, 33.78651], [-116.75086, 33.78637], [-116.74932, 33.78637], [-116.74929, 33.78674], [-116.74496, 33.78678], [-116.74496, 33.78634], [-116.74165, 33.78631], [-116.74183, 33.78623], [-116.74187, 33.78459], [-116.7364, 33.78454], [-116.73635, 33.78688], [-116.71926, 33.78706], [-116.71977, 33.80146], [-116.71963, 33.80817], [-116.71952, 33.81444], [-116.71949, 33.82201], [-116.71979, 33.82505], [-116.71947, 33.82582], [-116.71945, 33.83129], [-116.70167, 33.83132], [-116.63232, 33.83094], [-116.61542, 33.83094], [-116.61456, 33.8295], [-116.61455, 33.827], [-116.61537, 33.82512], [-116.61546, 33.82329], [-116.61551, 33.81597], [-116.61556, 33.78749], [-116.64935, 33.78757], [-116.67558, 33.78774], [-116.68391, 33.78738], [-116.70177, 33.78764], [-116.70178, 33.78732], [-116.70287, 33.77307], [-116.70282, 33.7694], [-116.70278, 33.76939], [-116.70253, 33.76276], [-116.7027, 33.76275], [-116.7027, 33.76252], [-116.70684, 33.76261], [-116.7069, 33.76201], [-116.70687, 33.75907], [-116.71122, 33.75894], [-116.71123, 33.75716], [-116.71198, 33.75715], [-116.71199, 33.75635], [-116.7114, 33.75615], [-116.71139, 33.75608], [-116.71124, 33.75603], [-116.71124, 33.75535], [-116.71142, 33.75534], [-116.71143, 33.75505], [-116.71188, 33.75504], [-116.71191, 33.75173], [-116.71228, 33.75172], [-116.71228, 33.75229], [-116.71513, 33.75225], [-116.71515, 33.75533], [-116.71746, 33.75525], [-116.71748, 33.75607], [-116.72003, 33.75598], [-116.72, 33.75869], [-116.72003, 33.76226], [-116.71567, 33.7659], [-116.71571, 33.76943], [-116.72006, 33.76931], [-116.72008, 33.77278], [-116.73138, 33.77267], [-116.73139, 33.7756], [-116.73126, 33.77583], [-116.73127, 33.77609], [-116.73213, 33.77594], [-116.73253, 33.77593], [-116.73407, 33.77636], [-116.73496, 33.7764], [-116.73604, 33.77635], [-116.736, 33.77667], [-116.73605, 33.77679], [-116.73609, 33.77695], [-116.73636, 33.77716], [-116.73683, 33.77731], [-116.73726, 33.77737], [-116.73771, 33.77749], [-116.73823, 33.77771], [-116.73863, 33.7779], [-116.73909, 33.77816], [-116.73969, 33.77884], [-116.74005, 33.77913], [-116.7405, 33.77928], [-116.74078, 33.77936], [-116.74123, 33.77939], [-116.74187, 33.7793], [-116.7427, 33.77893], [-116.74314, 33.77876], [-116.7436, 33.7788], [-116.74416, 33.77904], [-116.74589, 33.78], [-116.74644, 33.78028], [-116.74704, 33.78066], [-116.7487, 33.7824], [-116.74917, 33.78269], [-116.74968, 33.78286], [-116.75069, 33.78295], [-116.7511, 33.78309], [-116.75139, 33.78338], [-116.75148, 33.78366], [-116.75146, 33.78407], [-116.75131, 33.78442], [-116.7509, 33.78482], [-116.7508, 33.78515], [-116.75083, 33.78544], [-116.75108, 33.78579], [-116.75154, 33.78615], [-116.75189, 33.78649], [-116.7519, 33.78651]]], [[[-116.71671, 33.74859], [-116.71626, 33.75015], [-116.71593, 33.75002], [-116.71568, 33.74996], [-116.71473, 33.74989], [-116.71452, 33.74981], [-116.71443, 33.74975], [-116.7143, 33.7496], [-116.71425, 33.7495], [-116.71422, 33.74941], [-116.71409, 33.74827], [-116.7141, 33.74804], [-116.71417, 33.74784], [-116.7143, 33.74764], [-116.71444, 33.74749], [-116.71477, 33.74725], [-116.71493, 33.74705], [-116.71563, 33.74746], [-116.71543, 33.74785], [-116.71671, 33.74859]]]]} | Open Access 1 | 5529 | Mount San Jacinto State Park | 1652 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=636 | Riverside 10 | 13572.357 | Mount San Jacinto SP | 1930 | State Park 15 | 4 |
| 16583 | 16583 | 16582 | {"type": "MultiPolygon", "coordinates": [[[[-116.61118, 33.4274], [-116.60579, 33.42736], [-116.60799, 33.42737], [-116.61118, 33.4274]]], [[[-116.41969, 33.42686], [-116.41969, 33.42686], [-116.41969, 33.427], [-116.41969, 33.42686], [-116.41969, 33.42686]]], [[[-116.55266, 33.51641], [-116.55266, 33.52006], [-116.54848, 33.52005], [-116.5485, 33.5164], [-116.55266, 33.51641]]], [[[-116.62157, 33.52643], [-116.61264, 33.52653], [-116.61257, 33.52261], [-116.62152, 33.52261], [-116.62157, 33.52643]]], [[[-116.55266, 33.52188], [-116.55266, 33.52553], [-116.54846, 33.52553], [-116.54846, 33.5237], [-116.55064, 33.5237], [-116.55065, 33.52188], [-116.55266, 33.52188]]], [[[-116.61694, 33.4853], [-116.60506, 33.48526], [-116.60504, 33.48914], [-116.58766, 33.48917], [-116.58768, 33.48651], [-116.60003, 33.48655], [-116.60005, 33.48528], [-116.60504, 33.48526], [-116.60505, 33.48525], [-116.60484, 33.47093], [-116.58754, 33.47083], [-116.58753, 33.47084], [-116.5875, 33.48173], [-116.58317, 33.48174], [-116.58314, 33.48282], [-116.58262, 33.48283], [-116.58257, 33.48526], [-116.57021, 33.48525], [-116.57019, 33.50011], [-116.5877, 33.50026], [-116.5877, 33.50374], [-116.58753, 33.51462], [-116.60481, 33.51477], [-116.60455, 33.52584], [-116.60453, 33.52929], [-116.58699, 33.52924], [-116.58692, 33.54343], [-116.56993, 33.54342], [-116.56992, 33.54373], [-116.56985, 33.54374], [-116.57008, 33.52907], [-116.55288, 33.52905], [-116.55288, 33.51462], [-116.54418, 33.51459], [-116.54411, 33.52901], [-116.53979, 33.52901], [-116.53986, 33.51458], [-116.53557, 33.51456], [-116.53556, 33.51458], [-116.53553, 33.51818], [-116.53766, 33.51818], [-116.53761, 33.52901], [-116.53547, 33.52901], [-116.53546, 33.52899], [-116.51824, 33.52893], [-116.51818, 33.51454], [-116.50117, 33.51431], [-116.50116, 33.51453], [-116.49687, 33.51452], [-116.49687, 33.5109], [-116.49259, 33.51089], [-116.49258, 33.51452], [-116.46684, 33.51448], [-116.46682, 33.49997], [-116.45017, 33.49995], [-116.44953, 33.49989], [-116.44978, 33.48558], [-116.4324, 33.48557], [-116.43249, 33.47115], [-116.41531, 33.47093], [-116.4153, 33.4704], [-116.41512, 33.47039], [-116.41518, 33.44193], [-116.39755, 33.44177], [-116.38829, 33.44181], [-116.38859, 33.44138], [-116.38863, 33.4269], [-116.4024, 33.42687], [-116.40241, 33.42751], [-116.4238, 33.42739], [-116.45415, 33.42737], [-116.4639, 33.42734], [-116.50776, 33.4271], [-116.52744, 33.42712], [-116.52745, 33.42702], [-116.54249, 33.42708], [-116.54814, 33.42712], [-116.55293, 33.42712], [-116.56649, 33.42719], [-116.57997, 33.42722], [-116.58753, 33.42727], [-116.58754, 33.42728], [-116.59048, 33.4273], [-116.59801, 33.42729], [-116.59802, 33.42732], [-116.60485, 33.42736], [-116.60479, 33.44177], [-116.61671, 33.44173], [-116.61672, 33.44182], [-116.61682, 33.44183], [-116.61685, 33.45634], [-116.60497, 33.45631], [-116.60484, 33.47092], [-116.61675, 33.47098], [-116.61694, 33.4853]], [[-116.58753, 33.51464], [-116.58752, 33.51463], [-116.57021, 33.51468], [-116.57008, 33.52906], [-116.58699, 33.52923], [-116.58753, 33.51464]], [[-116.57019, 33.50012], [-116.56154, 33.49972], [-116.5615, 33.50339], [-116.56099, 33.50416], [-116.56081, 33.50504], [-116.56137, 33.50648], [-116.56117, 33.5076], [-116.56114, 33.50922], [-116.56222, 33.5146], [-116.56988, 33.51461], [-116.56989, 33.51467], [-116.5702, 33.51467], [-116.57019, 33.50012]], [[-116.49258, 33.50727], [-116.48829, 33.50726], [-116.48829, 33.51088], [-116.49258, 33.51089], [-116.49258, 33.50727]], [[-116.48829, 33.50364], [-116.48401, 33.50363], [-116.484, 33.50544], [-116.48615, 33.50544], [-116.48615, 33.50726], [-116.48828, 33.50726], [-116.48829, 33.50364]], [[-116.50115, 33.50365], [-116.50116, 33.50002], [-116.49687, 33.50002], [-116.49687, 33.50364], [-116.50115, 33.50365]], [[-116.48381, 33.4856], [-116.48382, 33.48546], [-116.48381, 33.48545], [-116.46712, 33.48539], [-116.46711, 33.4854], [-116.46712, 33.48555], [-116.48381, 33.4856]], [[-116.60484, 33.44534], [-116.60483, 33.45628], [-116.60359, 33.45628], [-116.60359, 33.4563], [-116.60497, 33.4563], [-116.60489, 33.4454], [-116.60482, 33.44313], [-116.60484, 33.44534]], [[-116.58756, 33.44893], [-116.58743, 33.44892], [-116.58742, 33.44893], [-116.58753, 33.45369], [-116.58756, 33.44893]], [[-116.59796, 33.44177], [-116.60235, 33.44177], [-116.59837, 33.44172], [-116.58751, 33.44168], [-116.58746, 33.44535], [-116.58831, 33.44536], [-116.59376, 33.44524], [-116.58758, 33.44519], [-116.5876, 33.44175], [-116.59796, 33.44177]], [[-116.57027, 33.44165], [-116.57028, 33.44164], [-116.57023, 33.43742], [-116.57022, 33.44164], [-116.57027, 33.44165]], [[-116.58171, 33.43313], [-116.5817, 33.43312], [-116.57595, 33.43312], [-116.57591, 33.43724], [-116.58167, 33.43727], [-116.58171, 33.43313]]]]} | Open Access 1 | 17930 | Anza-Borrego Desert State Park | 1413 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=638 | Riverside 10 | 40107.224 | Anza-Borrego Desert SP | 1933 | State Park 15 | 4 |
| 16646 | 16646 | 16645 | {"type": "MultiPolygon", "coordinates": [[[[-117.17847, 33.89281], [-117.17814, 33.89402], [-117.1769, 33.89573], [-117.17682, 33.8954], [-117.17714, 33.89469], [-117.1773, 33.89349], [-117.17659, 33.893], [-117.17615, 33.89279], [-117.17464, 33.89301], [-117.1743, 33.89289], [-117.17286, 33.89362], [-117.17216, 33.89486], [-117.17205, 33.89556], [-117.17171, 33.89569], [-117.17168, 33.89608], [-117.17119, 33.89657], [-117.1703, 33.89715], [-117.16969, 33.89751], [-117.16894, 33.89778], [-117.16867, 33.89757], [-117.16833, 33.89762], [-117.16825, 33.89791], [-117.16809, 33.89821], [-117.16783, 33.89839], [-117.16708, 33.89865], [-117.16685, 33.89878], [-117.16657, 33.89875], [-117.16652, 33.89846], [-117.16619, 33.89839], [-117.16595, 33.89876], [-117.16533, 33.89929], [-117.16471, 33.90018], [-117.16376, 33.90079], [-117.16304, 33.90113], [-117.16284, 33.9015], [-117.16243, 33.90184], [-117.16184, 33.90284], [-117.16187, 33.90356], [-117.16145, 33.90426], [-117.16157, 33.90454], [-117.16131, 33.90482], [-117.16, 33.90474], [-117.15935, 33.90581], [-117.15865, 33.90602], [-117.15765, 33.9054], [-117.15578, 33.90596], [-117.15551, 33.90635], [-117.15429, 33.90616], [-117.15406, 33.90698], [-117.15255, 33.90918], [-117.15078, 33.9095], [-117.15015, 33.9102], [-117.15023, 33.90942], [-117.14969, 33.90953], [-117.14958, 33.91014], [-117.13744, 33.91018], [-117.13704, 33.91021], [-117.13648, 33.91046], [-117.13319, 33.90869], [-117.13287, 33.90769], [-117.13196, 33.90812], [-117.13158, 33.90747], [-117.13455, 33.90498], [-117.13367, 33.90293], [-117.13663, 33.89569], [-117.13481, 33.88996], [-117.13453, 33.88949], [-117.13484, 33.88948], [-117.13933, 33.89582], [-117.14318, 33.90033], [-117.1464, 33.90524], [-117.14739, 33.90585], [-117.14959, 33.90282], [-117.14994, 33.90053], [-117.15635, 33.89779], [-117.1577, 33.89462], [-117.16679, 33.89444], [-117.17471, 33.89251], [-117.1766, 33.89049], [-117.17707, 33.89068], [-117.1768, 33.89097], [-117.1768, 33.89098], [-117.17761, 33.89141], [-117.17824, 33.89204], [-117.17847, 33.89281]]], [[[-117.20824, 33.86836], [-117.20787, 33.86908], [-117.20755, 33.86948], [-117.20744, 33.8705], [-117.20745, 33.87084], [-117.20685, 33.87126], [-117.20707, 33.87182], [-117.20711, 33.87233], [-117.20682, 33.87252], [-117.20655, 33.87319], [-117.20673, 33.87345], [-117.2068, 33.87455], [-117.20673, 33.87467], [-117.206, 33.87521], [-117.2061, 33.87571], [-117.20602, 33.8758], [-117.20622, 33.87741], [-117.20611, 33.87742], [-117.20602, 33.87758], [-117.20608, 33.87769], [-117.20555, 33.87801], [-117.20495, 33.87816], [-117.20501, 33.87841], [-117.20421, 33.87866], [-117.20367, 33.87909], [-117.2035, 33.88043], [-117.20171, 33.88131], [-117.20072, 33.88086], [-117.20038, 33.88095], [-117.20041, 33.88117], [-117.20027, 33.88117], [-117.2001, 33.88106], [-117.19976, 33.88121], [-117.1998, 33.88144], [-117.1997, 33.88191], [-117.19953, 33.88192], [-117.19946, 33.88213], [-117.19946, 33.88244], [-117.19927, 33.88265], [-117.19898, 33.88248], [-117.19825, 33.88278], [-117.19821, 33.88285], [-117.19799, 33.88294], [-117.19752, 33.88367], [-117.19724, 33.88446], [-117.19695, 33.88473], [-117.1969, 33.88491], [-117.19646, 33.88491], [-117.1958, 33.88499], [-117.19561, 33.88509], [-117.19551, 33.88518], [-117.19532, 33.8853], [-117.19511, 33.88553], [-117.1949, 33.886], [-117.1934, 33.88746], [-117.19464, 33.88864], [-117.19442, 33.88895], [-117.19445, 33.88918], [-117.19424, 33.88931], [-117.19407, 33.88918], [-117.19391, 33.88925], [-117.19397, 33.88942], [-117.19383, 33.88972], [-117.19375, 33.88963], [-117.19355, 33.88978], [-117.19357, 33.88993], [-117.19317, 33.89016], [-117.19301, 33.88997], [-117.19279, 33.89002], [-117.19264, 33.88967], [-117.19234, 33.8896], [-117.19207, 33.88876], [-117.19202, 33.88844], [-117.19182, 33.8884], [-117.19176, 33.88824], [-117.1916, 33.8882], [-117.1915, 33.88836], [-117.1906, 33.88817], [-117.19005, 33.88905], [-117.18998, 33.88892], [-117.1897, 33.88917], [-117.18988, 33.88965], [-117.19006, 33.89], [-117.19003, 33.89078], [-117.18883, 33.89115], [-117.18783, 33.8907], [-117.18805, 33.89001], [-117.18775, 33.88946], [-117.18721, 33.88932], [-117.18739, 33.8888], [-117.18809, 33.8881], [-117.18763, 33.88764], [-117.18662, 33.88865], [-117.18654, 33.8892], [-117.18608, 33.88948], [-117.18569, 33.88934], [-117.18497, 33.89012], [-117.1828, 33.88902], [-117.18224, 33.88942], [-117.18169, 33.88758], [-117.18195, 33.88719], [-117.18172, 33.88693], [-117.18222, 33.88636], [-117.18206, 33.88593], [-117.18191, 33.88588], [-117.18192, 33.88576], [-117.18187, 33.88551], [-117.18143, 33.88526], [-117.1857, 33.88067], [-117.19013, 33.88114], [-117.20216, 33.87048], [-117.20438, 33.86581], [-117.20546, 33.86584], [-117.20548, 33.86557], [-117.20629, 33.86559], [-117.20631, 33.86543], [-117.20652, 33.86544], [-117.20678, 33.86544], [-117.20766, 33.86604], [-117.20777, 33.86622], [-117.20759, 33.86727], [-117.20824, 33.86836]]]]} | Open Access 1 | 3470 | Lake Perris State Recreation Area | 1834 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=651 | Riverside 10 | 1469.067 | Lake Perris SRA | 1974 | State Recreation Area 39 | 4 |
| 16647 | 16647 | 16646 | {"type": "MultiPolygon", "coordinates": [[[[-115.8344, 33.43118], [-115.83165, 33.427], [-115.83165, 33.427], [-115.83435, 33.427], [-115.8344, 33.43118]]], [[[-115.84342, 33.44822], [-115.84339, 33.45573], [-115.83501, 33.4554], [-115.83485, 33.44796], [-115.84342, 33.44822]]], [[[-115.88269, 33.47021], [-115.88142, 33.47022], [-115.87835, 33.46824], [-115.87832, 33.4667], [-115.88262, 33.46664], [-115.88269, 33.47021]]], [[[-115.8873, 33.48096], [-115.88722, 33.48097], [-115.88726, 33.4847], [-115.88416, 33.48469], [-115.87797, 33.48463], [-115.87796, 33.4775], [-115.86931, 33.47729], [-115.86922, 33.46998], [-115.86898, 33.47003], [-115.85186, 33.47042], [-115.85242, 33.45963], [-115.86084, 33.45965], [-115.86079, 33.46327], [-115.86941, 33.46292], [-115.86923, 33.46997], [-115.87816, 33.47019], [-115.87797, 33.4775], [-115.88725, 33.47773], [-115.8873, 33.48096]]], [[[-115.90043, 33.48831], [-115.89853, 33.48832], [-115.89607, 33.4883], [-115.89576, 33.48472], [-115.89439, 33.48472], [-115.88727, 33.47618], [-115.88733, 33.47413], [-115.89145, 33.47413], [-115.89149, 33.47779], [-115.89543, 33.47805], [-115.89576, 33.48471], [-115.89999, 33.48472], [-115.90028, 33.48473], [-115.90043, 33.48831]]], [[[-115.93924, 33.47013], [-115.93918, 33.4846], [-115.92186, 33.48464], [-115.92182, 33.49937], [-115.90447, 33.49927], [-115.90464, 33.49502], [-115.90481, 33.48469], [-115.90455, 33.48114], [-115.90883, 33.48116], [-115.90881, 33.48469], [-115.91303, 33.48468], [-115.9132, 33.48096], [-115.9175, 33.48103], [-115.91747, 33.48465], [-115.92185, 33.48464], [-115.92191, 33.47017], [-115.92139, 33.47016], [-115.90459, 33.47021], [-115.90465, 33.45563], [-115.92196, 33.45559], [-115.92192, 33.47016], [-115.93924, 33.47013]]]]} | Open Access 1 | 4590 | Salton Sea State Recreation Area | 13840 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/default.asp?page_id=639 | Riverside 10 | 3074.445 | Salton Sea SRA | 1951 | State Recreation Area 39 | 4 |
| 16673 | 16673 | 16672 | {"type": "Polygon", "coordinates": [[[-117.21268, 33.84474], [-117.21262, 33.84527], [-117.20436, 33.84533], [-117.20439, 33.85874], [-117.20875, 33.86762], [-117.20875, 33.86766], [-117.20732, 33.86549], [-117.20628, 33.86504], [-117.20638, 33.86522], [-117.20411, 33.86399], [-117.20408, 33.86508], [-117.20438, 33.86581], [-117.20216, 33.87048], [-117.19012, 33.88115], [-117.1857, 33.88067], [-117.18144, 33.88525], [-117.18144, 33.88527], [-117.18187, 33.88551], [-117.18192, 33.88576], [-117.18191, 33.88588], [-117.18172, 33.88582], [-117.18148, 33.88615], [-117.18144, 33.88614], [-117.1813, 33.88604], [-117.18102, 33.88595], [-117.18092, 33.88595], [-117.18072, 33.88602], [-117.18056, 33.88602], [-117.18039, 33.88614], [-117.17988, 33.88671], [-117.18065, 33.88694], [-117.17708, 33.89068], [-117.1766, 33.89049], [-117.17471, 33.89251], [-117.16679, 33.89444], [-117.1577, 33.89462], [-117.15636, 33.89779], [-117.14994, 33.90053], [-117.14959, 33.90282], [-117.14739, 33.90585], [-117.14641, 33.90524], [-117.14318, 33.90033], [-117.13933, 33.89582], [-117.13484, 33.88948], [-117.13453, 33.88948], [-117.1299, 33.88164], [-117.13017, 33.87373], [-117.13855, 33.86702], [-117.13878, 33.86045], [-117.14801, 33.8537], [-117.15153, 33.85099], [-117.15337, 33.84523], [-117.15642, 33.84274], [-117.15642, 33.84178], [-117.15952, 33.83955], [-117.1618, 33.84036], [-117.16611, 33.83781], [-117.18056, 33.83751], [-117.17887, 33.83865], [-117.17866, 33.83994], [-117.19222, 33.85061], [-117.19702, 33.86233], [-117.20013, 33.86116], [-117.2025, 33.86005], [-117.20364, 33.85905], [-117.2038, 33.85877], [-117.20406, 33.8575], [-117.20371, 33.85291], [-117.20374, 33.85038], [-117.20398, 33.84758], [-117.20405, 33.84654], [-117.20399, 33.84571], [-117.204, 33.8448], [-117.21268, 33.84474]]]} | Open Access 1 | 28046 | Lake Perris State Recreation Area | 1834 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=651 | Riverside 10 | 7434.978 | Lake Perris SRA | 1974 | State Recreation Area 39 | 4 |
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]);