units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
444 rows where LAYER = 5 sorted by MNG_AG_LEV descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_LEV
MNG_AGENCY >30
- California State Lands Commission 86
- Mountains Recreation and Conservation Authority 56
- University of California 52
- Other State 43
- California Department of Fish and Wildlife 32
- California Department of Transportation 27
- California Department of Parks and Recreation 23
- California Department of Water Resources 20
- Santa Monica Mountains Conservancy 18
- California Department of General Services 14
- East Bay Regional Park District 11
- California Department of Forestry and Fire Protection 10
- California Wildlife Conservation Board 9
- California State Coastal Conservancy 7
- Coachella Valley Mountains Conservancy 5
- United States Fish and Wildlife Service 3
- San Diego, City of 2
- San Luis Obispo, City of 2
- California Department of Veterans Affairs 2
- Napa Valley College 2
- San Diego State University 2
- San Joaquin River Parkway and Conservation Trust 2
- California State University 2
- California Tahoe Conservancy 2
- The Nature Conservancy 1
- Napa County Regional Park and Open Space District 1
- Rosemead, City of 1
- California State University Sonoma 1
- San Fernando, City of 1
- Los Angeles - Department of Parks and Recreation, County of 1
- …
DES_TP >30
- State Resource Management Area 88
- State Conservation Area 82
- State Other or Unknown 55
- Local Park 32
- State Recreation Area 22
- Local Other or Unknown 21
- State Park 15
- Local Recreation Area 9
- Local Conservation Area 4
- National Wildlife Refuge 4
- National Monument or Landmark 2
- 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
- State Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 9
ACCESS_TYP 4
- Open Access 279
- Restricted Access 74
- No Public Access 51
- Unknown Access 40
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6138 | 6138 | 6137 | {"type": "MultiPolygon", "coordinates": [[[[-119.81139, 36.85174], [-119.80965, 36.85279], [-119.80958, 36.85524], [-119.80919, 36.85524], [-119.80918, 36.85525], [-119.80934, 36.85555], [-119.80965, 36.85584], [-119.8098, 36.85603], [-119.81001, 36.8564], [-119.81053, 36.85718], [-119.81052, 36.85757], [-119.81058, 36.85775], [-119.81056, 36.85798], [-119.81032, 36.8589], [-119.81027, 36.85962], [-119.8101, 36.86002], [-119.80955, 36.8605], [-119.80919, 36.86204], [-119.80844, 36.86293], [-119.80636, 36.86382], [-119.80577, 36.8641], [-119.8056, 36.86425], [-119.80474, 36.86484], [-119.80363, 36.8651], [-119.80253, 36.86561], [-119.80219, 36.86584], [-119.80205, 36.86614], [-119.80199, 36.86632], [-119.80175, 36.86632], [-119.80176, 36.86678], [-119.80174, 36.86702], [-119.80158, 36.86727], [-119.80115, 36.86778], [-119.80104, 36.86782], [-119.8008, 36.86795], [-119.80046, 36.86824], [-119.8003, 36.86851], [-119.80023, 36.86891], [-119.8002, 36.86931], [-119.80015, 36.86954], [-119.79995, 36.86991], [-119.79971, 36.87027], [-119.79948, 36.87058], [-119.79916, 36.87082], [-119.79884, 36.87118], [-119.7985, 36.87152], [-119.79837, 36.87158], [-119.79807, 36.8718], [-119.79783, 36.87189], [-119.79749, 36.87211], [-119.79717, 36.87237], [-119.79685, 36.8726], [-119.79671, 36.87276], [-119.7966, 36.87282], [-119.7962, 36.87288], [-119.79596, 36.87301], [-119.79588, 36.87324], [-119.79577, 36.87342], [-119.79537, 36.87362], [-119.79509, 36.87385], [-119.79479, 36.87406], [-119.79409, 36.87471], [-119.79402, 36.8741], [-119.79381, 36.86984], [-119.79435, 36.86947], [-119.79484, 36.86895], [-119.79528, 36.86836], [-119.79634, 36.86631], [-119.79728, 36.86631], [-119.79729, 36.86374], [-119.79741, 36.86334], [-119.79812, 36.86223], [-119.79822, 36.86156], [-119.79828, 36.86147], [-119.79838, 36.86148], [-119.79846, 36.86137], [-119.79916, 36.86075], [-119.79957, 36.86022], [-119.79979, 36.85985], [-119.80008, 36.85919], [-119.80056, 36.85848], [-119.80065, 36.85813], [-119.80064, 36.85809], [-119.80081, 36.85745], [-119.8008, 36.85741], [-119.80117, 36.85692], [-119.80182, 36.85633], [-119.80242, 36.85586], [-119.80241, 36.85583], [-119.80253, 36.85578], [-119.8026, 36.85572], [-119.80321, 36.85532], [-119.80371, 36.85506], [-119.80397, 36.85494], [-119.80419, 36.85478], [-119.80453, 36.85434], [-119.80485, 36.85465], [-119.80484, 36.85469], [-119.80507, 36.85479], [-119.80512, 36.8547], [-119.80511, 36.85464], [-119.80503, 36.85452], [-119.80472, 36.85422], [-119.80545, 36.85374], [-119.80631, 36.85323], [-119.80719, 36.85267], [-119.80743, 36.85307], [-119.80951, 36.85256], [-119.81014, 36.85204], [-119.81072, 36.85175], [-119.81139, 36.85174]]], [[[-119.81549, 36.85967], [-119.81481, 36.86091], [-119.81419, 36.8616], [-119.8121, 36.86351], [-119.81095, 36.86565], [-119.81041, 36.86422], [-119.80935, 36.86353], [-119.81125, 36.85939], [-119.81234, 36.85837], [-119.81252, 36.85743], [-119.81541, 36.8596], [-119.81545, 36.85967], [-119.81549, 36.85967]]]]} | No Public Access 3 | 1129 | Spano River Ranch | 25715 | 233 | San Joaquin River Conservancy 827 | State 5 | State Agency 5 | http://sjrc.ca.gov/ | Other State 5 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Fresno 9 | 412.564 | Spano River Ranch | 0 | State Other or Unknown 104 | 4 | |
9133 | 9133 | 9132 | {"type": "Polygon", "coordinates": [[[-123.67793, 38.88158], [-123.67779, 38.88178], [-123.67736, 38.88184], [-123.67704, 38.88184], [-123.67604, 38.88162], [-123.67615, 38.88209], [-123.67607, 38.88208], [-123.67596, 38.88214], [-123.67593, 38.88221], [-123.67594, 38.88229], [-123.67596, 38.88231], [-123.67584, 38.88241], [-123.6752, 38.88217], [-123.67489, 38.88312], [-123.67478, 38.88317], [-123.67461, 38.88321], [-123.6744, 38.8832], [-123.67327, 38.88249], [-123.6732, 38.88249], [-123.67262, 38.88206], [-123.67226, 38.88183], [-123.67086, 38.88065], [-123.67085, 38.88052], [-123.6709, 38.88046], [-123.67115, 38.88027], [-123.67134, 38.88016], [-123.67138, 38.88014], [-123.67143, 38.88015], [-123.67147, 38.88017], [-123.67166, 38.88041], [-123.67226, 38.88107], [-123.67263, 38.88129], [-123.67283, 38.88138], [-123.67289, 38.88139], [-123.67295, 38.88137], [-123.67302, 38.8813], [-123.67304, 38.88121], [-123.67301, 38.88117], [-123.67296, 38.88113], [-123.67285, 38.8811], [-123.67278, 38.88112], [-123.67261, 38.88111], [-123.6725, 38.88106], [-123.67233, 38.88093], [-123.6706, 38.87897], [-123.67134, 38.87867], [-123.67118, 38.87854], [-123.67097, 38.87846], [-123.67085, 38.87838], [-123.67078, 38.87826], [-123.67076, 38.87818], [-123.67066, 38.87809], [-123.67056, 38.87788], [-123.6704, 38.87779], [-123.67032, 38.87786], [-123.67031, 38.87769], [-123.67045, 38.87772], [-123.67068, 38.87788], [-123.67088, 38.87807], [-123.67096, 38.87827], [-123.67122, 38.87844], [-123.67138, 38.87857], [-123.67158, 38.87864], [-123.67166, 38.87882], [-123.67181, 38.87896], [-123.67196, 38.87903], [-123.67202, 38.87914], [-123.67253, 38.87988], [-123.67272, 38.88007], [-123.67286, 38.88031], [-123.67307, 38.88042], [-123.67389, 38.8807], [-123.67458, 38.88089], [-123.67499, 38.88116], [-123.67527, 38.88127], [-123.67704, 38.88176], [-123.67736, 38.88174], [-123.67793, 38.88158]]]} | Open Access 1 | 48997 | Moat Creek Coastal Access | 33692 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 3398 | Moat Creek Managing Agency 878 | Non Profit 6 | Non Profit - Conservation 12 | http://visitredwoodcoast.com/content/moat-creek-coastal-access-and-trail/nco9B9343306A4C803A6 | Mendocino 24 | 23.541 | Moat Creek Coastal Access | 0 | None 755 | ||
11209 | 11209 | 11208 | {"type": "MultiPolygon", "coordinates": [[[[-122.12348, 40.17101], [-122.10649, 40.17085], [-122.08771, 40.17078], [-122.07364, 40.17066], [-122.06924, 40.16662], [-122.0518, 40.15108], [-122.05107, 40.15026], [-122.05077, 40.15003], [-122.05066, 40.14987], [-122.05036, 40.14957], [-122.04226, 40.14263], [-122.03385, 40.14261], [-122.01491, 40.14243], [-122.01424, 40.15688], [-121.99527, 40.15697], [-121.99525, 40.15697], [-121.99568, 40.14267], [-121.9503, 40.14391], [-121.93706, 40.14345], [-121.9309, 40.14319], [-121.86075, 40.14298], [-121.86107, 40.1284], [-121.86114, 40.12481], [-121.86586, 40.12484], [-121.86594, 40.12125], [-121.87068, 40.12127], [-121.87078, 40.11768], [-121.87554, 40.11768], [-121.87565, 40.11409], [-121.87245, 40.11408], [-121.87246, 40.11406], [-121.8725, 40.11267], [-121.87307, 40.11149], [-121.87339, 40.11048], [-121.88056, 40.11046], [-121.88522, 40.11047], [-121.88535, 40.10687], [-121.89003, 40.10686], [-121.89015, 40.10325], [-121.89952, 40.10325], [-121.89965, 40.09963], [-121.90434, 40.09963], [-121.90447, 40.09602], [-121.91853, 40.09602], [-121.91867, 40.0924], [-121.9286, 40.09225], [-121.92873, 40.08874], [-121.93898, 40.08853], [-121.94827, 40.08837], [-121.94807, 40.08484], [-121.94817, 40.08139], [-121.95763, 40.08126], [-121.96236, 40.08116], [-121.96256, 40.07767], [-121.96743, 40.07768], [-121.96749, 40.07412], [-121.97778, 40.07406], [-121.9778, 40.07032], [-121.98617, 40.07021], [-121.98626, 40.06655], [-121.9909, 40.06654], [-121.99086, 40.05929], [-122.01503, 40.05905], [-122.01493, 40.05535], [-122.03035, 40.05533], [-122.03036, 40.05532], [-122.03035, 40.05488], [-122.03135, 40.05496], [-122.03254, 40.055], [-122.03321, 40.05506], [-122.03343, 40.05505], [-122.03412, 40.05516], [-122.03456, 40.05527], [-122.03849, 40.05522], [-122.03855, 40.05894], [-122.05253, 40.05871], [-122.05258, 40.0624], [-122.07144, 40.06219], [-122.07142, 40.06352], [-122.07143, 40.06353], [-122.0872, 40.06346], [-122.08715, 40.06719], [-122.08721, 40.07257], [-122.08715, 40.07645], [-122.08709, 40.08904], [-122.08842, 40.08904], [-122.08944, 40.08909], [-122.09028, 40.08909], [-122.08715, 40.09122], [-122.0872, 40.09864], [-122.07605, 40.09863], [-122.07597, 40.09876], [-122.07598, 40.09877], [-122.07851, 40.09877], [-122.08041, 40.10105], [-122.08045, 40.10164], [-122.08072, 40.10327], [-122.081, 40.10432], [-122.08126, 40.10515], [-122.08134, 40.10608], [-122.08087, 40.10685], [-122.08057, 40.1076], [-122.08053, 40.10799], [-122.08108, 40.10981], [-122.08071, 40.1101], [-122.08046, 40.11077], [-122.08036, 40.11196], [-122.08058, 40.11326], [-122.06826, 40.11322], [-122.06291, 40.10752], [-122.06261, 40.10768], [-122.06769, 40.11283], [-122.09369, 40.14002], [-122.08995, 40.1421], [-122.08994, 40.14212], [-122.09072, 40.14286], [-122.0929, 40.14504], [-122.10678, 40.15947], [-122.11045, 40.15741], [-122.12348, 40.17101]]], [[[-122.13427, 40.16059], [-122.13335, 40.16119], [-122.12524, 40.16506], [-122.12055, 40.16769], [-122.10943, 40.15604], [-122.11687, 40.15178], [-122.1132, 40.14796], [-122.12017, 40.1479], [-122.12066, 40.14926], [-122.12061, 40.14922], [-122.12072, 40.14958], [-122.12095, 40.15023], [-122.12157, 40.15063], [-122.12248, 40.15109], [-122.12324, 40.15114], [-122.12415, 40.15059], [-122.12535, 40.1509], [-122.12654, 40.15098], [-122.1274, 40.15145], [-122.12754, 40.15169], [-122.12897, 40.1534], [-122.12907, 40.15355], [-122.12913, 40.15378], [-122.12913, 40.15407], [-122.12917, 40.15424], [-122.12927, 40.15448], [-122.12936, 40.15464], [-122.1295, 40.1548], [-122.12959, 40.15497], [-122.12964, 40.15516], [-122.12967, 40.15538], [-122.12964, 40.15557], [-122.12958, 40.15567], [-122.12943, 40.15614], [-122.12936, 40.15652], [-122.12933, 40.15683], [-122.12936, 40.15713], [-122.12944, 40.15743], [-122.12955, 40.15767], [-122.12971, 40.15793], [-122.12992, 40.15816], [-122.13013, 40.15832], [-122.13029, 40.15842], [-122.13054, 40.15851], [-122.13068, 40.15852], [-122.13088, 40.15851], [-122.1313, 40.15838], [-122.13155, 40.15833], [-122.13176, 40.15832], [-122.13288, 40.15959], [-122.13427, 40.16059]]]]} | Restricted Access 2 | 21518 | Gray Davis Dye Creek Preserve | 19452 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | Tehama 18 | 37918.76 | Gray Davis Dye Creek Preserve | 0 | State Conservation Area 8 | 2 | ||
12592 | 12592 | 12591 | {"type": "Polygon", "coordinates": [[[-122.39117, 37.78541], [-122.39071, 37.78573], [-122.39028, 37.78609], [-122.39017, 37.78649], [-122.38985, 37.78623], [-122.39103, 37.78533], [-122.39117, 37.78541]]]} | Open Access 1 | 48777 | Rincon Hill Dog Park | 33503 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.rinconhilldogpark.org/about | San Francisco 13 | 0.621 | Rincon Hill Dog Park | 2007 | None 1091 | |
14676 | 14676 | 14675 | {"type": "MultiPolygon", "coordinates": [[[[-122.48358, 37.87496], [-122.47846, 37.88316], [-122.47745, 37.88485], [-122.47656, 37.88639], [-122.47606, 37.886], [-122.48271, 37.87462], [-122.48358, 37.87496]]], [[[-122.49182, 37.87837], [-122.48654, 37.88697], [-122.4843, 37.8909], [-122.4841, 37.89121], [-122.48364, 37.89071], [-122.4838, 37.89047], [-122.48632, 37.88604], [-122.48737, 37.88444], [-122.48776, 37.88368], [-122.49119, 37.8781], [-122.49182, 37.87837]]], [[[-122.49639, 37.88427], [-122.49453, 37.88741], [-122.4931, 37.88965], [-122.49261, 37.8905], [-122.4923, 37.89097], [-122.49188, 37.89166], [-122.49167, 37.89196], [-122.49029, 37.89432], [-122.48955, 37.89554], [-122.48881, 37.89557], [-122.48979, 37.89388], [-122.49252, 37.88934], [-122.4939, 37.88719], [-122.49609, 37.88349], [-122.49639, 37.88427]]]]} | Restricted Access 2 | 44954 | Richardson Bay Audubon Center & Sanctuary | 24330 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 68.678 | Richardson Bay Audubon Ctr. & Sanctuary | None 1252 | |||
14744 | 14744 | 14743 | {"type": "Polygon", "coordinates": [[[-119.83687, 36.85657], [-119.83636, 36.85653], [-119.83406, 36.8556], [-119.83382, 36.85617], [-119.83164, 36.85548], [-119.82956, 36.85467], [-119.82958, 36.85894], [-119.82911, 36.85877], [-119.82676, 36.85836], [-119.82546, 36.85798], [-119.82482, 36.85787], [-119.82444, 36.85787], [-119.82146, 36.85849], [-119.82124, 36.85821], [-119.82014, 36.85846], [-119.82014, 36.85839], [-119.82013, 36.85838], [-119.81682, 36.85918], [-119.8161, 36.85969], [-119.81549, 36.85966], [-119.81521, 36.85915], [-119.8137, 36.85798], [-119.8133, 36.85721], [-119.8141, 36.85621], [-119.81385, 36.85511], [-119.81452, 36.85355], [-119.81774, 36.85268], [-119.81816, 36.85175], [-119.81874, 36.85089], [-119.81827, 36.85053], [-119.81819, 36.84968], [-119.82062, 36.84889], [-119.82609, 36.8502], [-119.82888, 36.85138], [-119.82982, 36.85209], [-119.83077, 36.85256], [-119.83253, 36.85338], [-119.8334, 36.85372], [-119.83687, 36.85657]]]} | Open Access 1 | 45120 | Sycamore Island | 26131 | 233 | San Joaquin River Conservancy 827 | State 5 | State Agency 5 | http://sjrc.ca.gov/ | Other State 5 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Madera 48 | 328.657 | Sycamore Island | None 1264 | |||
25 | 25 | 24 | {"type": "Polygon", "coordinates": [[[-122.27747, 38.29885], [-122.27706, 38.29891], [-122.27702, 38.29871], [-122.27743, 38.29865], [-122.27747, 38.29885]]]} | No Public Access 3 | 64 | Real Estate Services Division | 24211 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 0.203 | Real Estate Services Division | None 6 | |||
125 | 125 | 124 | {"type": "Polygon", "coordinates": [[[-122.16054, 37.91443], [-122.15949, 37.91447], [-122.15824, 37.91493], [-122.15833, 37.91517], [-122.15835, 37.9154], [-122.15843, 37.91558], [-122.15855, 37.91562], [-122.1591, 37.91596], [-122.15923, 37.916], [-122.15932, 37.91606], [-122.15944, 37.9161], [-122.15978, 37.91678], [-122.15987, 37.91706], [-122.15989, 37.91733], [-122.15981, 37.91743], [-122.15968, 37.9175], [-122.15952, 37.91752], [-122.1583, 37.91752], [-122.15781, 37.91755], [-122.15781, 37.9177], [-122.15682, 37.91818], [-122.15556, 37.91921], [-122.15437, 37.92001], [-122.15249, 37.92204], [-122.15111, 37.92218], [-122.14987, 37.92221], [-122.14886, 37.92159], [-122.14828, 37.92145], [-122.14816, 37.92139], [-122.14803, 37.92129], [-122.14763, 37.92077], [-122.14752, 37.92071], [-122.14689, 37.92039], [-122.14573, 37.91988], [-122.14487, 37.91881], [-122.14368, 37.91819], [-122.14285, 37.91769], [-122.14266, 37.9176], [-122.14226, 37.91738], [-122.14209, 37.91701], [-122.14195, 37.91666], [-122.14182, 37.91621], [-122.14211, 37.9161], [-122.14325, 37.91561], [-122.14391, 37.91541], [-122.14487, 37.91524], [-122.14541, 37.91512], [-122.14599, 37.91505], [-122.14652, 37.91488], [-122.14719, 37.91472], [-122.14806, 37.91437], [-122.14828, 37.91418], [-122.14845, 37.91387], [-122.14876, 37.91372], [-122.14919, 37.91365], [-122.14961, 37.91369], [-122.14986, 37.91367], [-122.15009, 37.91362], [-122.15051, 37.91345], [-122.15067, 37.91336], [-122.1508, 37.91331], [-122.15093, 37.9132], [-122.15112, 37.91294], [-122.15129, 37.91276], [-122.15141, 37.91268], [-122.15173, 37.91256], [-122.15298, 37.91254], [-122.15334, 37.91257], [-122.15363, 37.91257], [-122.15418, 37.9127], [-122.15462, 37.91292], [-122.15559, 37.91319], [-122.15586, 37.91333], [-122.15636, 37.91343], [-122.15653, 37.91344], [-122.15685, 37.9134], [-122.15756, 37.9135], [-122.15813, 37.9136], [-122.15841, 37.91372], [-122.15882, 37.91396], [-122.15901, 37.91397], [-122.15914, 37.91394], [-122.1593, 37.91388], [-122.15958, 37.91383], [-122.15976, 37.91392], [-122.1601, 37.91419], [-122.16054, 37.91443]]]} | Restricted Access 2 | 315 | Russell Research Station (UC) | 24744 | 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 | Contra Costa 12 | 247.32 | Russell Research Station (UC) | None 17 | |||
190 | 190 | 189 | {"type": "Polygon", "coordinates": [[[-119.54817, 34.40521], [-119.54802, 34.4054], [-119.54792, 34.40532], [-119.54714, 34.40436], [-119.54706, 34.40429], [-119.54684, 34.40419], [-119.54661, 34.40416], [-119.54636, 34.40425], [-119.54631, 34.40432], [-119.54628, 34.40444], [-119.5462, 34.40436], [-119.54604, 34.40426], [-119.54606, 34.40336], [-119.54817, 34.40521]]]} | Open Access 1 | 524 | Santa Claus Lane Beach | 25061 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Santa Barbara 7 | 1.665 | Santa Claus Lane Beach | None 20 | |||
325 | 325 | 324 | {"type": "Polygon", "coordinates": [[[-122.0502, 36.9496], [-122.04978, 36.94953], [-122.04949, 36.94929], [-122.04942, 36.94927], [-122.04942, 36.94924], [-122.04951, 36.94925], [-122.04961, 36.94935], [-122.04967, 36.94936], [-122.04979, 36.94944], [-122.04993, 36.94948], [-122.05019, 36.9495], [-122.0502, 36.9496]]]} | Open Access 1 | 1106 | Stockton Avenue Beach | 25857 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Cruz 5 | 0.139 | Stockton Avenue Beach | None 33 | ||||
374 | 374 | 373 | {"type": "Polygon", "coordinates": [[[-122.51401, 38.08952], [-122.50961, 38.09217], [-122.5071, 38.09337], [-122.50547, 38.08821], [-122.50462, 38.08689], [-122.50476, 38.08671], [-122.50434, 38.08636], [-122.50461, 38.086], [-122.50537, 38.08538], [-122.50578, 38.08514], [-122.50622, 38.08495], [-122.50736, 38.08466], [-122.50838, 38.08465], [-122.50977, 38.08483], [-122.5107, 38.08507], [-122.51158, 38.08542], [-122.51221, 38.08579], [-122.51271, 38.0862], [-122.51324, 38.08682], [-122.51374, 38.08778], [-122.51391, 38.08855], [-122.51402, 38.08937], [-122.51401, 38.08952]]]} | Open Access 1 | 1105 | North Antenna Field | 22804 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Marin 23 | 128.205 | North Antenna Field | None 38 | |||
426 | 426 | 425 | {"type": "MultiPolygon", "coordinates": [[[[-122.54467, 38.63634], [-122.54012, 38.63646], [-122.54006, 38.65103], [-122.53546, 38.65099], [-122.53551, 38.64373], [-122.52645, 38.64367], [-122.52656, 38.64004], [-122.52204, 38.64003], [-122.52219, 38.63641], [-122.5214, 38.6255], [-122.52598, 38.62553], [-122.52577, 38.62209], [-122.52841, 38.62192], [-122.53977, 38.62201], [-122.54003, 38.62199], [-122.54431, 38.62189], [-122.5444, 38.62378], [-122.54448, 38.62912], [-122.54467, 38.63634]], [[-122.54011, 38.63644], [-122.54012, 38.63643], [-122.53988, 38.62923], [-122.52622, 38.62917], [-122.52645, 38.63279], [-122.53549, 38.63283], [-122.53564, 38.63643], [-122.54008, 38.63642], [-122.54011, 38.63644]]], [[[-122.56278, 38.61434], [-122.55805, 38.61443], [-122.5534, 38.6145], [-122.55346, 38.61809], [-122.54883, 38.61821], [-122.54419, 38.6183], [-122.54405, 38.61108], [-122.54868, 38.611], [-122.54863, 38.60741], [-122.55798, 38.6073], [-122.56112, 38.60719], [-122.5627, 38.60725], [-122.56278, 38.61434]]]]} | Open Access 1 | 1318 | Swartz Canyon | 1994 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Napa 11 | 1307.545 | Swartz Canyon | None 43 | |||
434 | 434 | 433 | {"type": "Polygon", "coordinates": [[[-122.3521, 38.44442], [-122.34572, 38.4492], [-122.34565, 38.44615], [-122.3358, 38.44548], [-122.3314, 38.44557], [-122.33138, 38.4492], [-122.3184, 38.44966], [-122.29917, 38.448], [-122.29908, 38.44438], [-122.31821, 38.44584], [-122.31804, 38.44201], [-122.33143, 38.44194], [-122.33145, 38.43832], [-122.32239, 38.43823], [-122.32228, 38.43447], [-122.33607, 38.43482], [-122.34065, 38.43479], [-122.34065, 38.43521], [-122.34066, 38.43522], [-122.3429, 38.43515], [-122.34817, 38.43528], [-122.34848, 38.43602], [-122.34809, 38.44201], [-122.3521, 38.44442]]]} | Open Access 1 | 837 | Silverado Trail Rector Dam Watershed | 1818 | 206 | California Department of Veterans Affairs 170 | State 5 | State Agency 5 | http://www.cdva.ca.gov/ | Other State 5 | 206 | California Department of Veterans Affairs 166 | State 5 | State Agency 5 | Napa 11 | 959.679 | Silverado Trail Rector Dam Watershed | None 44 | |||
655 | 655 | 654 | {"type": "Polygon", "coordinates": [[[-122.60188, 38.34223], [-122.60099, 38.34219], [-122.59824, 38.34219], [-122.59784, 38.34221], [-122.59674, 38.34238], [-122.59579, 38.34284], [-122.59514, 38.34423], [-122.59427, 38.34493], [-122.59333, 38.34522], [-122.59334, 38.34582], [-122.59113, 38.34633], [-122.5913, 38.34768], [-122.59135, 38.34828], [-122.5912, 38.3487], [-122.59122, 38.34925], [-122.59128, 38.34926], [-122.5913, 38.34965], [-122.59261, 38.35027], [-122.59275, 38.35752], [-122.58592, 38.35768], [-122.58582, 38.35554], [-122.5836, 38.35559], [-122.58354, 38.34758], [-122.58768, 38.34758], [-122.58754, 38.34322], [-122.5927, 38.34315], [-122.59271, 38.33808], [-122.59176, 38.33786], [-122.59079, 38.33744], [-122.58972, 38.33705], [-122.58885, 38.33685], [-122.588, 38.3368], [-122.58729, 38.33644], [-122.5869, 38.33609], [-122.58626, 38.33575], [-122.58571, 38.33561], [-122.58518, 38.33551], [-122.58545, 38.33521], [-122.58614, 38.33528], [-122.58697, 38.33561], [-122.58767, 38.33622], [-122.58824, 38.33643], [-122.58911, 38.33648], [-122.58974, 38.33662], [-122.5905, 38.33687], [-122.59169, 38.33743], [-122.5927, 38.33768], [-122.59271, 38.33767], [-122.59272, 38.33589], [-122.60179, 38.33588], [-122.60186, 38.34013], [-122.60188, 38.34223]], [[-122.5906, 38.3493], [-122.59059, 38.34928], [-122.59046, 38.34931], [-122.59053, 38.34931], [-122.5906, 38.3493]]]} | Restricted Access 2 | 3269 | Fairfield Osborn Preserve | 18798 | 211 | California State University Sonoma 232 | State 5 | State Agency 5 | http://www.sonoma.edu/ | Other State 5 | 211 | California State University Sonoma 228 | State 5 | State Agency 5 | Sonoma 16 | 414.364 | Fairfield Osborn Preserve | 2004 | State Conservation Area 8 | 2 | |
820 | 820 | 819 | {"type": "Polygon", "coordinates": [[[-122.46024, 38.4015], [-122.45904, 38.40373], [-122.45593, 38.40443], [-122.45662, 38.40573], [-122.45384, 38.40685], [-122.45383, 38.40697], [-122.45093, 38.40569], [-122.45012, 38.40836], [-122.44677, 38.40831], [-122.44613, 38.40284], [-122.44659, 38.40275], [-122.44716, 38.40269], [-122.44742, 38.40261], [-122.44761, 38.40251], [-122.44766, 38.40247], [-122.44768, 38.40235], [-122.44764, 38.4023], [-122.44757, 38.40227], [-122.44797, 38.40183], [-122.44828, 38.40157], [-122.46024, 38.4015]]]} | Open Access 1 | 4582 | Bumpy Camp Nature Preserve | 16503 | 223 | Napa Valley College 268 | State 5 | State Agency 5 | http://www.napavalley.edu/ | Other State 5 | 223 | Napa Valley College 263 | State 5 | State Agency 5 | Napa 11 | 148.027 | Bumpy Camp Nature Preserve | 0 | State Conservation Area 8 | 2 | |
909 | 909 | 908 | {"type": "MultiPolygon", "coordinates": [[[[-116.98194, 32.66387], [-116.98012, 32.66389], [-116.98006, 32.66252], [-116.98113, 32.66321], [-116.98194, 32.66387]]], [[[-116.99533, 32.66736], [-116.9952, 32.6671], [-116.99494, 32.66669], [-116.9947, 32.66636], [-116.99446, 32.6661], [-116.99404, 32.6657], [-116.99371, 32.66545], [-116.99336, 32.66523], [-116.99305, 32.66506], [-116.99253, 32.66482], [-116.99242, 32.66479], [-116.99241, 32.66479], [-116.9924, 32.66481], [-116.98955, 32.66381], [-116.98915, 32.66383], [-116.98534, 32.66471], [-116.98442, 32.66526], [-116.98444, 32.66385], [-116.98299, 32.66386], [-116.98277, 32.66357], [-116.98191, 32.66274], [-116.98083, 32.66182], [-116.98012, 32.66126], [-116.98162, 32.66028], [-116.99252, 32.66025], [-116.99312, 32.66169], [-116.99324, 32.66166], [-116.99346, 32.66211], [-116.99359, 32.6624], [-116.99369, 32.66237], [-116.99393, 32.6629], [-116.99407, 32.66325], [-116.9942, 32.66361], [-116.9944, 32.66434], [-116.99449, 32.66471], [-116.99456, 32.66515], [-116.99455, 32.66531], [-116.99458, 32.66546], [-116.99462, 32.66554], [-116.9947, 32.66567], [-116.99489, 32.66587], [-116.99513, 32.66618], [-116.99523, 32.66641], [-116.99531, 32.66663], [-116.99536, 32.66698], [-116.99535, 32.66725], [-116.99533, 32.66736]]], [[[-117.00156, 32.67463], [-116.99849, 32.67546], [-116.99657, 32.67064], [-116.99567, 32.66833], [-116.9957, 32.66831], [-116.99555, 32.66794], [-116.99562, 32.6678], [-116.99568, 32.66754], [-116.99571, 32.66723], [-116.99569, 32.66683], [-116.99561, 32.66648], [-116.99551, 32.66623], [-116.99533, 32.66591], [-116.99522, 32.66576], [-116.99497, 32.66549], [-116.99488, 32.66534], [-116.99485, 32.66493], [-116.99477, 32.66442], [-116.99459, 32.66368], [-116.9944, 32.66315], [-116.99369, 32.66154], [-116.99617, 32.66084], [-116.99614, 32.66208], [-116.99667, 32.66343], [-116.99675, 32.66451], [-116.99781, 32.66579], [-116.99839, 32.6665], [-116.99859, 32.66701], [-116.99879, 32.66746], [-116.99892, 32.66874], [-117.00005, 32.6695], [-117.00038, 32.67013], [-117.00035, 32.67151], [-117.00156, 32.67463]]]]} | Open Access 1 | 5809 | Blue-Bonita Meadows | 1797 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 240.067 | Blue-Bonita Meadows | None 81 | |||
1041 | 1041 | 1040 | {"type": "Polygon", "coordinates": [[[-118.42426, 34.13667], [-118.4242, 34.13642], [-118.42398, 34.13639], [-118.42387, 34.13567], [-118.42373, 34.13499], [-118.42361, 34.13458], [-118.42363, 34.13425], [-118.42376, 34.13401], [-118.42374, 34.13394], [-118.42342, 34.13373], [-118.42341, 34.13374], [-118.42341, 34.13384], [-118.42315, 34.13384], [-118.42288, 34.13459], [-118.42283, 34.13517], [-118.42249, 34.13506], [-118.42249, 34.13323], [-118.4226, 34.13311], [-118.42266, 34.13301], [-118.4227, 34.13274], [-118.4228, 34.13262], [-118.42292, 34.13241], [-118.42306, 34.13231], [-118.42347, 34.1322], [-118.42374, 34.13209], [-118.42389, 34.132], [-118.42401, 34.1319], [-118.42405, 34.13183], [-118.42406, 34.13177], [-118.424, 34.13167], [-118.424, 34.13163], [-118.42418, 34.1315], [-118.42433, 34.13143], [-118.42462, 34.13136], [-118.42518, 34.13136], [-118.42524, 34.1314], [-118.42525, 34.13148], [-118.42521, 34.13154], [-118.4251, 34.13164], [-118.42508, 34.13171], [-118.42508, 34.13178], [-118.42516, 34.13194], [-118.42515, 34.13207], [-118.42524, 34.13217], [-118.42525, 34.13221], [-118.42522, 34.13226], [-118.42512, 34.1323], [-118.42507, 34.13235], [-118.42506, 34.13241], [-118.42509, 34.13257], [-118.42506, 34.13266], [-118.42499, 34.13278], [-118.42498, 34.13287], [-118.42501, 34.13294], [-118.42513, 34.13297], [-118.42515, 34.13302], [-118.42502, 34.13334], [-118.42497, 34.13352], [-118.42457, 34.13439], [-118.42426, 34.13667]]]} | Open Access 1 | 6864 | Dixie Canyon Park | 18170 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 215 | Santa Monica Mountains Conservancy 303 | State 5 | State Agency 5 | Los Angeles 6 | 18.289 | Dixie Canyon Park | None 94 | |||
1157 | 1157 | 1156 | {"type": "Polygon", "coordinates": [[[-116.91384, 32.82128], [-116.9136, 32.82217], [-116.91351, 32.82247], [-116.91325, 32.82312], [-116.91306, 32.82352], [-116.91285, 32.82388], [-116.91253, 32.82436], [-116.91234, 32.8246], [-116.91137, 32.82546], [-116.91041, 32.8248], [-116.9096, 32.82296], [-116.90946, 32.82252], [-116.90948, 32.82219], [-116.91047, 32.82103], [-116.91059, 32.82076], [-116.91384, 32.82128]]]} | Open Access 1 | 7356 | CalTrans TransNet Environmental Mitigation | 16740 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 33.902 | CalTrans TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
1165 | 1165 | 1164 | {"type": "Polygon", "coordinates": [[[-116.90615, 32.72851], [-116.90484, 32.7283], [-116.90399, 32.72803], [-116.90394, 32.72518], [-116.90608, 32.72533], [-116.90615, 32.72851]]]} | Open Access 1 | 7381 | San Diego National Wildlife Refuge | 24858 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | San Diego 4 | 16.779 | San Diego NWR | 1996 | National Wildlife Refuge 105 | 2 | ||
1278 | 1278 | 1277 | {"type": "Polygon", "coordinates": [[[-118.6782, 34.06005], [-118.67818, 34.06166], [-118.67738, 34.06166], [-118.67739, 34.06315], [-118.67624, 34.06312], [-118.67625, 34.06492], [-118.67606, 34.06492], [-118.67361, 34.06522], [-118.67342, 34.06526], [-118.6733, 34.06532], [-118.67235, 34.06588], [-118.67225, 34.06598], [-118.67216, 34.06609], [-118.67203, 34.0664], [-118.67183, 34.06641], [-118.67177, 34.06417], [-118.67225, 34.06392], [-118.67224, 34.06325], [-118.67223, 34.06324], [-118.67156, 34.06326], [-118.67146, 34.06003], [-118.6782, 34.06005]]]} | Open Access 1 | 7228 | Piuma Ridge Park | 23752 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 215 | Santa Monica Mountains Conservancy 303 | State 5 | State Agency 5 | Los Angeles 6 | 73.241 | Piuma Ridge Park | 0 | None 111 |
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]);