units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
386 rows where ACCESS_TYP = 4 sorted by YR_EST
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 144
- Yuba County Water Agency 48
- National Audubon Society 23
- California Department of Transportation 15
- Santa Barbara, County of 12
- Santa Barbara, City of 12
- Save the Redwoods League 10
- California State Lands Commission 7
- San Joaquin River Parkway and Conservation Trust 7
- Riverside, County of 5
- Sacramento, County of 5
- Santa Barbara Flood Control and Water Conserv. District 4
- Wilderness Land Trust 4
- North County Transit District 4
- United States Fish and Wildlife Service 3
- Sierra Foothill Conservancy 3
- Sacramento and San Joaquin Drainage District 3
- California Wildlife Conservation Board 3
- Wildlands Inc 3
- Northcoast Regional Land Trust 3
- Los Angeles, County of 2
- Monterey, County of 2
- Los Angeles, City of 2
- Carpinteria, City of 2
- Back Country Land Trust 2
- Ramona Municipal Water District 2
- San Diego, City of 1
- United States Forest Service 1
- United States National Park Service 1
- Center for Natural Lands Management 1
- …
DES_TP >30
- Local Other or Unknown 204
- Private Conservation 52
- State Other or Unknown 18
- Local Recreation Area 16
- Local Conservation Area 11
- Private Other or Unknown 10
- State Resource Management Area 7
- Local Park 5
- National Monument or Landmark 3
- Recreation Management Area 1
- Private Recreation or Education 1
- Local Resource Management Area 1
- Federal Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 14
ACCESS_TYP 1
- Unknown Access · 366 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5597 | 5597 | 5596 | {"type": "Polygon", "coordinates": [[[-120.49458, 34.67098], [-120.49431, 34.67124], [-120.49306, 34.67174], [-120.493, 34.6711], [-120.49457, 34.67081], [-120.49458, 34.67098]]]} | Unknown Access 4 | 631 | Santa Ynez River | 25145 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.884 | Santa Ynez River | None 451 | |||
5644 | 5644 | 5643 | {"type": "Polygon", "coordinates": [[[-124.11238, 40.99977], [-124.11173, 41.00363], [-124.1111, 41.00601], [-124.11088, 41.00673], [-124.10992, 41.00671], [-124.11008, 41.00583], [-124.11159, 41.00045], [-124.11204, 40.99978], [-124.11238, 40.99977]]]} | Unknown Access 4 | 46935 | Clam Beach Ponds | 30554 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Humboldt 45 | 14.521 | Clam Beach Ponds | None 458 | ||||
5920 | 5920 | 5919 | {"type": "MultiPolygon", "coordinates": [[[[-121.53785, 38.99012], [-121.53571, 38.99016], [-121.53505, 38.98682], [-121.53318, 38.97686], [-121.53261, 38.97452], [-121.53228, 38.97439], [-121.52906, 38.974], [-121.52845, 38.97401], [-121.52772, 38.97407], [-121.52694, 38.97429], [-121.52603, 38.97461], [-121.52466, 38.97549], [-121.52472, 38.97146], [-121.53415, 38.97196], [-121.53419, 38.9722], [-121.53437, 38.97219], [-121.53521, 38.97686], [-121.53623, 38.98263], [-121.53785, 38.99012]]], [[[-121.54307, 38.97419], [-121.53827, 38.97526], [-121.53632, 38.97537], [-121.5361, 38.97451], [-121.53695, 38.97474], [-121.53768, 38.97467], [-121.53863, 38.97446], [-121.5393, 38.97412], [-121.54233, 38.97348], [-121.54302, 38.97266], [-121.54307, 38.97419]]], [[[-121.5693, 38.94626], [-121.56559, 38.95156], [-121.56466, 38.95274], [-121.56398, 38.95341], [-121.5629, 38.95417], [-121.56164, 38.95474], [-121.56038, 38.95508], [-121.55862, 38.95546], [-121.55738, 38.95588], [-121.55666, 38.95633], [-121.55608, 38.95694], [-121.55575, 38.95752], [-121.55566, 38.95751], [-121.55566, 38.95777], [-121.55556, 38.95767], [-121.55525, 38.9583], [-121.55289, 38.96098], [-121.55118, 38.96232], [-121.55065, 38.96278], [-121.55031, 38.96313], [-121.54971, 38.96387], [-121.54949, 38.9638], [-121.54995, 38.96284], [-121.55104, 38.96187], [-121.55287, 38.96042], [-121.55366, 38.95939], [-121.555, 38.95758], [-121.55531, 38.95677], [-121.55611, 38.95602], [-121.5573, 38.95535], [-121.55905, 38.95497], [-121.56076, 38.95466], [-121.5618, 38.95423], [-121.56279, 38.95374], [-121.56346, 38.95316], [-121.56433, 38.95229], [-121.56908, 38.94541], [-121.5693, 38.94626]]]]} | Unknown Access 4 | 418 | Bear River | 15929 | 2127 | Sacramento and San Joaquin Drainage District 681 | Special District 4 | Flood District 8 | Special District 4 | 2127 | Sacramento and San Joaquin Drainage District 671 | Special District 4 | Flood District 9 | Yuba 25 | 185.752 | Bear River | None 473 | ||||
6628 | 6628 | 6627 | {"type": "Polygon", "coordinates": [[[-118.6131, 34.15759], [-118.61284, 34.15773], [-118.6126, 34.15756], [-118.61257, 34.1575], [-118.61278, 34.15736], [-118.6131, 34.15759]]]} | Unknown Access 4 | 4323 | Llano | 21388 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.253 | Llano | None 535 | |||
6649 | 6649 | 6648 | {"type": "MultiPolygon", "coordinates": [[[[-118.29844, 34.44508], [-118.29404, 34.44509], [-118.29401, 34.44186], [-118.29504, 34.44221], [-118.2953, 34.44234], [-118.29557, 34.44244], [-118.2959, 34.44251], [-118.29627, 34.44254], [-118.29669, 34.44251], [-118.29719, 34.44244], [-118.29749, 34.44236], [-118.29796, 34.44218], [-118.29818, 34.44207], [-118.2984, 34.44193], [-118.29841, 34.44299], [-118.29831, 34.4431], [-118.29828, 34.44322], [-118.2983, 34.44331], [-118.29842, 34.44357], [-118.29842, 34.44367], [-118.29836, 34.44368], [-118.29816, 34.44362], [-118.29804, 34.44363], [-118.29796, 34.44367], [-118.29791, 34.44371], [-118.29788, 34.44377], [-118.29786, 34.44384], [-118.29788, 34.4444], [-118.29792, 34.44455], [-118.29799, 34.44466], [-118.29827, 34.44495], [-118.29835, 34.445], [-118.29844, 34.44502], [-118.29844, 34.44508]]], [[[-118.29807, 34.44144], [-118.29789, 34.44157], [-118.29769, 34.44168], [-118.29739, 34.44177], [-118.29685, 34.44187], [-118.29629, 34.4419], [-118.29592, 34.44188], [-118.29555, 34.44183], [-118.29557, 34.44176], [-118.29537, 34.44172], [-118.29486, 34.44142], [-118.29807, 34.44144]]], [[[-118.29843, 34.44485], [-118.29815, 34.44456], [-118.29809, 34.44445], [-118.29806, 34.44383], [-118.29808, 34.4438], [-118.29811, 34.44378], [-118.29815, 34.44378], [-118.29831, 34.44384], [-118.29842, 34.44384], [-118.29843, 34.44485]]]]} | Unknown Access 4 | 4665 | Long-Nellus Canyon | 21446 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 32.557 | Long-Nellus Canyon | None 538 | |||
6803 | 6803 | 6802 | {"type": "Polygon", "coordinates": [[[-118.57899, 34.14891], [-118.57845, 34.14895], [-118.57849, 34.14866], [-118.57892, 34.14859], [-118.57899, 34.14891]]]} | Unknown Access 4 | 5319 | MGP Entrance | 22194 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.379 | MGP Entrance | None 553 | |||
7590 | 7590 | 7589 | {"type": "Polygon", "coordinates": [[[-118.58536, 34.37309], [-118.58501, 34.3731], [-118.58501, 34.37384], [-118.58474, 34.37372], [-118.58451, 34.37352], [-118.58428, 34.3737], [-118.58414, 34.37367], [-118.58393, 34.37354], [-118.58391, 34.37323], [-118.58372, 34.3731], [-118.58347, 34.37331], [-118.58335, 34.37347], [-118.58331, 34.37362], [-118.58326, 34.37363], [-118.5832, 34.37367], [-118.58317, 34.37372], [-118.58317, 34.37376], [-118.58271, 34.37408], [-118.58263, 34.37427], [-118.58266, 34.37444], [-118.5827, 34.37452], [-118.58287, 34.37454], [-118.58286, 34.37458], [-118.58273, 34.37456], [-118.58215, 34.37455], [-118.58214, 34.37467], [-118.58277, 34.37507], [-118.58274, 34.3754], [-118.58194, 34.37539], [-118.58193, 34.37574], [-118.5814, 34.37587], [-118.58139, 34.37426], [-118.58108, 34.37426], [-118.58101, 34.37074], [-118.58532, 34.37075], [-118.58536, 34.37309]]]} | Unknown Access 4 | 7299 | Laing - Brookfield | 20873 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 37.175 | Laing - Brookfield | None 630 | |||
7591 | 7591 | 7590 | {"type": "Polygon", "coordinates": [[[-118.59396, 34.37062], [-118.59325, 34.37056], [-118.59308, 34.3706], [-118.59305, 34.37054], [-118.59297, 34.3705], [-118.5929, 34.3705], [-118.59285, 34.37052], [-118.59275, 34.37046], [-118.59255, 34.37043], [-118.59241, 34.37045], [-118.59231, 34.37057], [-118.59228, 34.37085], [-118.59228, 34.37129], [-118.59226, 34.37143], [-118.59063, 34.37142], [-118.58965, 34.37239], [-118.58961, 34.36807], [-118.58962, 34.36713], [-118.59392, 34.36708], [-118.59396, 34.37062]]]} | Unknown Access 4 | 7300 | Laing - Brookfield | 20873 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 44.522 | Laing - Brookfield | None 631 | |||
8101 | 8101 | 8100 | {"type": "Polygon", "coordinates": [[[-117.31018, 33.69849], [-117.30588, 33.69858], [-117.30592, 33.70216], [-117.30153, 33.70223], [-117.30156, 33.69865], [-117.2974, 33.69872], [-117.29732, 33.68915], [-117.30424, 33.68905], [-117.30429, 33.69122], [-117.31014, 33.69113], [-117.31018, 33.69849]]]} | Unknown Access 4 | 12138 | Alberhill Conservation Area, Expansion 1 | 15335 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 317.959 | Alberhill Conservation Area, Expansion 1 | None 674 | |||
8102 | 8102 | 8101 | {"type": "Polygon", "coordinates": [[[-117.30415, 33.68905], [-117.29733, 33.68915], [-117.29734, 33.69144], [-117.29287, 33.69151], [-117.29287, 33.69102], [-117.29327, 33.69128], [-117.29388, 33.69128], [-117.29399, 33.69136], [-117.29428, 33.69138], [-117.29457, 33.69129], [-117.29451, 33.69066], [-117.29452, 33.69039], [-117.29447, 33.69031], [-117.2946, 33.69005], [-117.29429, 33.68946], [-117.2946, 33.68922], [-117.29464, 33.68853], [-117.29508, 33.68828], [-117.29535, 33.68806], [-117.29568, 33.68802], [-117.29627, 33.6878], [-117.29667, 33.688], [-117.29688, 33.68832], [-117.29685, 33.68857], [-117.29726, 33.68882], [-117.29762, 33.68881], [-117.29775, 33.68866], [-117.29759, 33.68829], [-117.29711, 33.68815], [-117.29686, 33.68785], [-117.2964, 33.68762], [-117.29645, 33.68722], [-117.29662, 33.687], [-117.29678, 33.68667], [-117.29714, 33.68644], [-117.29761, 33.68597], [-117.29777, 33.68545], [-117.29782, 33.68494], [-117.29802, 33.68468], [-117.29801, 33.68457], [-117.29769, 33.68419], [-117.30405, 33.6841], [-117.30415, 33.68905]]]} | Unknown Access 4 | 12139 | Alberhill Conservation Area, Expansion 2 | 15336 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 109.553 | Alberhill Conservation Area, Expansion 2 | None 675 | |||
8968 | 8968 | 8967 | {"type": "MultiPolygon", "coordinates": [[[[-118.60299, 34.07904], [-118.60282, 34.07928], [-118.60279, 34.07931], [-118.60269, 34.07918], [-118.60291, 34.07891], [-118.60298, 34.07897], [-118.60299, 34.07904]]], [[[-118.6063, 34.08091], [-118.60629, 34.08167], [-118.60523, 34.08168], [-118.60535, 34.08091], [-118.6063, 34.08091]]]]} | Unknown Access 4 | 14796 | Topanga Canyon - Fernwood | 26405 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 2.097 | Topanga Canyon - Fernwood | None 747 | |||
9008 | 9008 | 9007 | {"type": "Polygon", "coordinates": [[[-118.67703, 34.11763], [-118.67637, 34.11763], [-118.67637, 34.11811], [-118.67199, 34.11812], [-118.67201, 34.11443], [-118.67371, 34.11443], [-118.67372, 34.11417], [-118.67636, 34.11416], [-118.67637, 34.11576], [-118.67703, 34.11577], [-118.67703, 34.11763]]]} | Unknown Access 4 | 14913 | Upper Stokes | 26736 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 45.58 | Upper Stokes | None 751 | |||
9431 | 9431 | 9430 | {"type": "Polygon", "coordinates": [[[-121.81231, 36.23946], [-121.8123, 36.24002], [-121.81077, 36.23999], [-121.81078, 36.23944], [-121.81113, 36.23944], [-121.81114, 36.23898], [-121.81198, 36.23899], [-121.81197, 36.23945], [-121.81231, 36.23946]]]} | Unknown Access 4 | 15771 | Falotico | 18839 | 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 | 3.051 | Falotico | None 778 | |||
10584 | 10584 | 10583 | {"type": "Polygon", "coordinates": [[[-117.58905, 33.80079], [-117.58905, 33.8152], [-117.58045, 33.81519], [-117.57179, 33.81523], [-117.57182, 33.80086], [-117.58905, 33.80079]]]} | Unknown Access 4 | 18844 | Eagle Canyon | 27903 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | http://www.fs.usda.gov/cleveland/ | Riverside 10 | 629.255 | Eagle Canyon | None 932 | ||
11085 | 11085 | 11084 | {"type": "Polygon", "coordinates": [[[-121.5949, 38.15797], [-121.59472, 38.15807], [-121.592, 38.16102], [-121.59186, 38.16102], [-121.58624, 38.15878], [-121.58673, 38.15797], [-121.5871, 38.1577], [-121.58783, 38.15763], [-121.58864, 38.15775], [-121.59014, 38.15777], [-121.59087, 38.15761], [-121.59142, 38.15729], [-121.59198, 38.15656], [-121.5949, 38.15797]]]} | Unknown Access 4 | 21327 | Delta Protection | 18076 | 1150 | Isleton, City of 964 | City 2 | City Agency 2 | http://www.isletoncoc.org/ | City 2 | 1150 | Isleton, City of 932 | City 2 | City Agency 2 | Sacramento 41 | 46.487 | Delta Protection | None 962 | |||
11211 | 11211 | 11210 | {"type": "Polygon", "coordinates": [[[-122.00988, 39.37037], [-122.00979, 39.37066], [-122.0097, 39.37115], [-122.0097, 39.37136], [-122.00983, 39.37214], [-122.00983, 39.37238], [-122.00981, 39.37268], [-122.00976, 39.37283], [-122.00973, 39.37319], [-122.00952, 39.37372], [-122.00936, 39.37406], [-122.0092, 39.37447], [-122.00886, 39.37507], [-122.00858, 39.3755], [-122.0054, 39.37516], [-122.00264, 39.37469], [-122.00243, 39.37458], [-122.00064, 39.37455], [-122.00064, 39.37442], [-122.00076, 39.37415], [-122.00108, 39.37372], [-122.00124, 39.37345], [-122.00131, 39.37315], [-122.00119, 39.37253], [-122.00128, 39.36984], [-122.00988, 39.37037]]]} | Unknown Access 4 | 21521 | Jensen | 28209 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Colusa 49 | 98.685 | Jensen | None 978 | |||
11284 | 11284 | 11283 | {"type": "MultiPolygon", "coordinates": [[[[-121.23771, 38.39477], [-121.23757, 38.39462], [-121.23747, 38.39463], [-121.23734, 38.39473], [-121.23716, 38.39492], [-121.23692, 38.39511], [-121.23671, 38.39514], [-121.23657, 38.39513], [-121.23657, 38.39498], [-121.23684, 38.39482], [-121.2369, 38.39472], [-121.23691, 38.39464], [-121.23685, 38.3946], [-121.23657, 38.39463], [-121.23657, 38.39415], [-121.23771, 38.39416], [-121.23771, 38.39477]]], [[[-121.23771, 38.39567], [-121.23728, 38.39532], [-121.23731, 38.39527], [-121.2374, 38.39523], [-121.23758, 38.3952], [-121.23771, 38.39516], [-121.23771, 38.39567]]]]} | Unknown Access 4 | 21836 | Poole Tina/gary M | 23892 | 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.148 | Poole Tina/gary M | None 987 | |||
11392 | 11392 | 11391 | {"type": "Polygon", "coordinates": [[[-121.06665, 38.48801], [-121.0665, 38.48803], [-121.06649, 38.4883], [-121.06662, 38.48833], [-121.0666, 38.48893], [-121.06601, 38.48906], [-121.06516, 38.48893], [-121.0642, 38.48821], [-121.06273, 38.4882], [-121.06281, 38.48584], [-121.06337, 38.48587], [-121.06379, 38.48587], [-121.06455, 38.48582], [-121.06477, 38.48646], [-121.06523, 38.48658], [-121.06538, 38.4864], [-121.06538, 38.48637], [-121.06577, 38.48631], [-121.06577, 38.48628], [-121.06593, 38.48617], [-121.06631, 38.48611], [-121.06638, 38.48641], [-121.06637, 38.48651], [-121.06643, 38.48659], [-121.06639, 38.48663], [-121.06635, 38.48686], [-121.06632, 38.48713], [-121.06623, 38.48716], [-121.06618, 38.48722], [-121.06619, 38.48727], [-121.06624, 38.48732], [-121.06619, 38.48737], [-121.06622, 38.48762], [-121.06642, 38.48761], [-121.06644, 38.48781], [-121.06663, 38.4878], [-121.06665, 38.48801]]]} | Unknown Access 4 | 22200 | Rancho Murieta Association | 24158 | 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 | 21.798 | Rancho Murieta Association | None 1003 | |||
11405 | 11405 | 11404 | {"type": "MultiPolygon", "coordinates": [[[[-121.12189, 38.448], [-121.12205, 38.44809], [-121.12216, 38.44818], [-121.12227, 38.44831], [-121.12236, 38.44848], [-121.12238, 38.44862], [-121.12238, 38.4488], [-121.12234, 38.44893], [-121.12227, 38.44905], [-121.12217, 38.44916], [-121.12199, 38.44928], [-121.12184, 38.44934], [-121.12163, 38.44939], [-121.12143, 38.44941], [-121.12126, 38.44939], [-121.12109, 38.44935], [-121.12094, 38.44929], [-121.12081, 38.4492], [-121.12068, 38.44908], [-121.12056, 38.44893], [-121.1205, 38.44881], [-121.12047, 38.4486], [-121.1205, 38.44842], [-121.12058, 38.44827], [-121.12071, 38.44812], [-121.12055, 38.44804], [-121.12043, 38.44795], [-121.12031, 38.44782], [-121.12023, 38.4477], [-121.12017, 38.44754], [-121.12015, 38.4474], [-121.12018, 38.44722], [-121.12023, 38.44709], [-121.12032, 38.44698], [-121.12047, 38.44684], [-121.12066, 38.44674], [-121.12087, 38.44667], [-121.1211, 38.44665], [-121.12132, 38.44667], [-121.12154, 38.44672], [-121.12169, 38.44679], [-121.12186, 38.44691], [-121.12201, 38.44709], [-121.12208, 38.44721], [-121.12212, 38.44734], [-121.12212, 38.44748], [-121.12209, 38.44763], [-121.122, 38.4478], [-121.12183, 38.44796], [-121.12189, 38.448]]], [[[-121.12616, 38.44975], [-121.12493, 38.44976], [-121.12493, 38.44977], [-121.12538, 38.45016], [-121.12535, 38.45016], [-121.12506, 38.45015], [-121.12485, 38.45009], [-121.12463, 38.44997], [-121.12455, 38.44991], [-121.12445, 38.4498], [-121.1244, 38.44972], [-121.12435, 38.44959], [-121.12433, 38.44947], [-121.12434, 38.44932], [-121.12438, 38.44919], [-121.12447, 38.44901], [-121.12463, 38.44882], [-121.12446, 38.44867], [-121.12437, 38.44854], [-121.12431, 38.44837], [-121.12429, 38.44824], [-121.12431, 38.4481], [-121.12438, 38.44793], [-121.12446, 38.44781], [-121.12457, 38.44771], [-121.12475, 38.4476], [-121.12497, 38.44753], [-121.12537, 38.44747], [-121.1255, 38.44744], [-121.12581, 38.44739], [-121.12598, 38.44738], [-121.1262, 38.4474], [-121.12663, 38.44751], [-121.12682, 38.44761], [-121.12698, 38.44776], [-121.1271, 38.44795], [-121.12713, 38.44804], [-121.12714, 38.44817], [-121.12711, 38.44835], [-121.12701, 38.44854], [-121.12694, 38.44861], [-121.12681, 38.44872], [-121.12662, 38.44882], [-121.1264, 38.44888], [-121.12612, 38.44889], [-121.12627, 38.44913], [-121.12632, 38.44931], [-121.12631, 38.44944], [-121.12628, 38.44954], [-121.12624, 38.44963], [-121.12616, 38.44975]]]]} | Unknown Access 4 | 22224 | River City Aggragates | 24408 | 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 | 23.425 | River City Aggragates | None 1006 | |||
11422 | 11422 | 11421 | {"type": "Polygon", "coordinates": [[[-121.23657, 38.39513], [-121.23642, 38.3951], [-121.23642, 38.39505], [-121.23657, 38.39498], [-121.23657, 38.39513]]]} | Unknown Access 4 | 22242 | Harrison Larry L/Tonya A | 19699 | 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.036 | Harrison Larry L/Tonya A | None 1012 |
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]);