superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,102 rows where MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 103
- San Diego, County of 91
- Orange, County of 58
- Santa Barbara, County of 54
- Santa Cruz, County of 28
- Placer, County of 23
- Kern, County of 22
- Sacramento, County of 22
- San Luis Obispo, County of 21
- Monterey, County of 16
- Riverside, County of 13
- Lake, County of 12
- San Joaquin, County of 12
- Stanislaus, County of 12
- Ventura, County of 11
- San Bernardino, County of 11
- Tulare, County of 9
- Merced, County of 9
- Yolo, County of 7
- Humboldt, County of 7
- Tehama, County of 7
- Fresno, County of 5
- Imperial, County of 5
- San Benito, County of 4
- Mendocino, County of 4
- Lassen, County of 4
- Mariposa, County of 3
- El Dorado, County of 3
- Napa, County of 3
- Contra Costa, County of 3
- …
ACCESS_TYP 4
- Open Access 521
- Restricted Access 37
- No Public Access 24
- Unknown Access 21
MNG_AG_TYP 1
- County Agency · 603 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6685 | 6685 | 6684 | {"type": "Polygon", "coordinates": [[[-119.9714, 37.48113], [-119.97153, 37.48192], [-119.97136, 37.48254], [-119.97118, 37.48288], [-119.9704, 37.48403], [-119.96782, 37.48146], [-119.96715, 37.48176], [-119.96667, 37.48206], [-119.96618, 37.48252], [-119.96609, 37.48262], [-119.96527, 37.48336], [-119.96479, 37.48305], [-119.96404, 37.48223], [-119.9637, 37.48241], [-119.96364, 37.48222], [-119.96397, 37.48205], [-119.96427, 37.4817], [-119.96411, 37.48152], [-119.96543, 37.48071], [-119.96544, 37.48069], [-119.96395, 37.47936], [-119.96285, 37.47879], [-119.96107, 37.47861], [-119.96034, 37.47643], [-119.9654, 37.47635], [-119.96717, 37.47867], [-119.96701, 37.47956], [-119.96881, 37.48108], [-119.971, 37.48013], [-119.971, 37.4802], [-119.97087, 37.48104], [-119.9714, 37.48113]]]} | Open Access 1 | Mariposa Park | 21865 | 307 | Mariposa, County of 107 | County 3 | County Agency 3 | https://www.mariposacounty.org/index.aspx?NID=207 | County 3 | 80.611 | Mariposa Park | ||
6711 | 6711 | 6710 | {"type": "Polygon", "coordinates": [[[-118.22632, 33.89521], [-118.22505, 33.89528], [-118.22499, 33.89426], [-118.22563, 33.89422], [-118.22561, 33.89372], [-118.22622, 33.89369], [-118.22632, 33.89521]]]} | Open Access 1 | Martin Luther King Jr. Memorial | 21909 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 4.072 | Martin Luther King Jr. Memorial | ||
6751 | 6751 | 6750 | {"type": "Polygon", "coordinates": [[[-116.59188, 32.61847], [-116.59183, 32.62191], [-116.5879, 32.62185], [-116.57535, 32.62173], [-116.57533, 32.6218], [-116.57501, 32.62179], [-116.57504, 32.61913], [-116.5737, 32.61912], [-116.57357, 32.61185], [-116.5833, 32.61188], [-116.58331, 32.61473], [-116.58772, 32.61475], [-116.58772, 32.61842], [-116.59188, 32.61847]]]} | No Public Access 3 | Mason Wildlife Refuge | 21944 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 353.935 | Mason Wildlife Refuge | ||
6779 | 6779 | 6778 | {"type": "Polygon", "coordinates": [[[-114.53743, 33.67682], [-114.53197, 33.67681], [-114.53248, 33.67467], [-114.53295, 33.67313], [-114.53327, 33.67189], [-114.53329, 33.67168], [-114.53329, 33.67139], [-114.53305, 33.66978], [-114.53407, 33.66976], [-114.53408, 33.66975], [-114.53406, 33.66967], [-114.53489, 33.66965], [-114.53488, 33.66951], [-114.53726, 33.66945], [-114.53743, 33.67682]]]} | Open Access 1 | Mayflower Park | 21976 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 83.856 | Mayflower Park | ||
6857 | 6857 | 6856 | {"type": "Polygon", "coordinates": [[[-118.05463, 33.98259], [-118.05463, 33.98262], [-118.05459, 33.98263], [-118.05399, 33.98263], [-118.0539, 33.9826], [-118.05387, 33.98256], [-118.05386, 33.98251], [-118.05397, 33.98223], [-118.05403, 33.98219], [-118.05411, 33.98218], [-118.05417, 33.9822], [-118.05456, 33.98246], [-118.05462, 33.98252], [-118.05463, 33.98259]]]} | Open Access 1 | McNees Park | 22064 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.604 | McNees Park | ||
6906 | 6906 | 6905 | {"type": "Polygon", "coordinates": [[[-117.77409, 34.77926], [-117.77404, 34.78659], [-117.76531, 34.78638], [-117.76533, 34.77908], [-117.77409, 34.77926]]]} | Open Access 1 | Phacelia Wildlife Sanctuary | 23638 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 160.492 | Phacelia Wildlife Sanctuary | ||
6909 | 6909 | 6908 | {"type": "Polygon", "coordinates": [[[-121.53256, 38.56557], [-121.53187, 38.56634], [-121.53047, 38.56554], [-121.53114, 38.56477], [-121.53256, 38.56557]]]} | Open Access 1 | Memorial Park | 22120 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 3.928 | Memorial Park | ||
6930 | 6930 | 6929 | {"type": "Polygon", "coordinates": [[[-117.39052, 34.48855], [-117.39052, 34.49046], [-117.38809, 34.49044], [-117.38811, 34.48868], [-117.38875, 34.48868], [-117.38877, 34.48854], [-117.39052, 34.48855]]]} | Open Access 1 | Mesa Linda Park | 22174 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 11.379 | Mesa Linda Park | ||
6941 | 6941 | 6940 | {"type": "Polygon", "coordinates": [[[-120.3761, 36.7807], [-120.37597, 36.7808], [-120.37571, 36.78105], [-120.37517, 36.78076], [-120.37455, 36.7806], [-120.37395, 36.78049], [-120.37328, 36.78048], [-120.37283, 36.78069], [-120.37246, 36.78082], [-120.3733, 36.78465], [-120.37122, 36.78455], [-120.37122, 36.78516], [-120.37026, 36.78491], [-120.36982, 36.78438], [-120.36952, 36.78373], [-120.36934, 36.78279], [-120.36939, 36.7821], [-120.36868, 36.78201], [-120.36858, 36.78167], [-120.36872, 36.78118], [-120.36855, 36.78059], [-120.36844, 36.78032], [-120.3689, 36.77975], [-120.36951, 36.7788], [-120.37032, 36.77791], [-120.37101, 36.77764], [-120.37204, 36.77738], [-120.37287, 36.77708], [-120.37248, 36.77796], [-120.37307, 36.77821], [-120.37357, 36.77857], [-120.37421, 36.77948], [-120.3754, 36.78023], [-120.3761, 36.7807]]]} | Open Access 1 | Mendota Pool Park | 22152 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 72.286 | Mendota Pool Park | ||
6945 | 6945 | 6944 | {"type": "MultiPolygon", "coordinates": [[[[-120.51236, 35.03141], [-120.51151, 35.03142], [-120.50616, 35.0315], [-120.50672, 35.03036], [-120.50677, 35.03033], [-120.50812, 35.0308], [-120.50814, 35.03123], [-120.51014, 35.03122], [-120.5108, 35.03095], [-120.51138, 35.03074], [-120.51225, 35.03007], [-120.51225, 35.02818], [-120.5119, 35.02817], [-120.5119, 35.02787], [-120.51192, 35.02784], [-120.51196, 35.02782], [-120.51235, 35.02782], [-120.51236, 35.03141]]], [[[-120.50742, 35.03009], [-120.50724, 35.03034], [-120.50686, 35.03021], [-120.50683, 35.03017], [-120.50683, 35.03014], [-120.50708, 35.02961], [-120.50714, 35.02943], [-120.50717, 35.0294], [-120.50723, 35.0294], [-120.50741, 35.02947], [-120.50715, 35.02999], [-120.50742, 35.03009]]], [[[-120.50768, 35.02852], [-120.50733, 35.02929], [-120.50726, 35.02926], [-120.50723, 35.02921], [-120.50728, 35.02905], [-120.50756, 35.02853], [-120.50761, 35.0285], [-120.50768, 35.02852]]], [[[-120.51174, 35.02817], [-120.51118, 35.02818], [-120.51117, 35.02918], [-120.5108, 35.02919], [-120.51056, 35.02923], [-120.51033, 35.02932], [-120.51011, 35.02947], [-120.50951, 35.02885], [-120.50923, 35.02904], [-120.50905, 35.02889], [-120.50882, 35.02877], [-120.50771, 35.02838], [-120.50767, 35.02833], [-120.50791, 35.02787], [-120.50797, 35.02784], [-120.50911, 35.02784], [-120.51168, 35.02782], [-120.51172, 35.02784], [-120.51174, 35.02787], [-120.51174, 35.02817]]]]} | Open Access 1 | Mesa Meadows Natural Area | 22177 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 21.104 | Mesa Meadows Natural Area | ||
6967 | 6967 | 6966 | {"type": "Polygon", "coordinates": [[[-122.0518, 37.04316], [-122.05171, 37.04325], [-122.05136, 37.04307], [-122.05098, 37.04293], [-122.05, 37.04275], [-122.05026, 37.04347], [-122.04925, 37.04494], [-122.0486, 37.04622], [-122.04469, 37.04114], [-122.04518, 37.04088], [-122.04547, 37.04119], [-122.04567, 37.04136], [-122.04589, 37.04151], [-122.04612, 37.04165], [-122.04637, 37.04178], [-122.04663, 37.04188], [-122.04719, 37.04204], [-122.05101, 37.04281], [-122.05123, 37.04287], [-122.05152, 37.04299], [-122.0518, 37.04316]]]} | Open Access 1 | Michael Gray Field Park | 22195 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 27.916 | Michael Gray Field Park | ||
6972 | 6972 | 6971 | {"type": "Polygon", "coordinates": [[[-118.0711, 34.1307], [-118.0711, 34.13084], [-118.07107, 34.13097], [-118.07101, 34.13109], [-118.0709, 34.13121], [-118.07078, 34.1313], [-118.07065, 34.13137], [-118.07052, 34.13141], [-118.07035, 34.13143], [-118.07018, 34.13143], [-118.07004, 34.1314], [-118.06991, 34.13135], [-118.06977, 34.13128], [-118.06965, 34.13117], [-118.06958, 34.13107], [-118.06952, 34.13097], [-118.06949, 34.13082], [-118.0711, 34.1307]]]} | Open Access 1 | Michillinda Park | 22201 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 2.162 | Michillinda Park | ||
6976 | 6976 | 6975 | {"type": "Polygon", "coordinates": [[[-122.61613, 38.75511], [-122.61574, 38.75571], [-122.61516, 38.75555], [-122.61543, 38.75493], [-122.61613, 38.75511]]]} | Open Access 1 | Middletown Park | 22209 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 1.072 | Middletown Park | ||
6978 | 6978 | 6977 | {"type": "MultiPolygon", "coordinates": [[[[-120.46427, 34.59959], [-120.46406, 34.60047], [-120.46387, 34.60048], [-120.46389, 34.60024], [-120.46393, 34.60008], [-120.46404, 34.59976], [-120.46412, 34.59961], [-120.46427, 34.59959]]], [[[-120.46586, 34.59723], [-120.46532, 34.59812], [-120.46507, 34.59806], [-120.46561, 34.59718], [-120.46586, 34.59723]]], [[[-120.47151, 34.59209], [-120.4715, 34.59302], [-120.4694, 34.59376], [-120.46933, 34.59299], [-120.47003, 34.59241], [-120.47066, 34.59232], [-120.47151, 34.59209]]]]} | Open Access 1 | Miguelito County Park | 22211 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 6.448 | Miguelito County Park | ||
6984 | 6984 | 6983 | {"type": "Polygon", "coordinates": [[[-119.29489, 35.98035], [-119.29292, 35.98036], [-119.2929, 35.97877], [-119.2929, 35.97629], [-119.29461, 35.97627], [-119.29478, 35.9767], [-119.29488, 35.977], [-119.29489, 35.98035]]]} | Open Access 1 | Pixley Park | 23756 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 19.727 | Pixley Park | ||
6986 | 6986 | 6985 | {"type": "Polygon", "coordinates": [[[-122.11797, 40.03123], [-122.11791, 40.03135], [-122.11783, 40.03163], [-122.11781, 40.03191], [-122.11764, 40.03247], [-122.11763, 40.03275], [-122.11756, 40.03306], [-122.11552, 40.03307], [-122.11426, 40.03337], [-122.11309, 40.03337], [-122.11307, 40.0296], [-122.11571, 40.02933], [-122.11667, 40.0312], [-122.11797, 40.03123]]]} | Open Access 1 | Mill Creek Park | 22224 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 34.403 | Mill Creek Park | ||
7007 | 7007 | 7006 | {"type": "Polygon", "coordinates": [[[-122.22656, 38.37413], [-122.20765, 38.37399], [-122.20771, 38.35953], [-122.21237, 38.35957], [-122.21238, 38.36317], [-122.22173, 38.36325], [-122.22177, 38.36686], [-122.22646, 38.3669], [-122.22656, 38.37413]]]} | No Public Access 3 | Milliken Reservoir Property | 22251 | 311 | Napa, County of 489 | County 3 | County Agency 3 | http://www.napaoutdoors.org/ | County 3 | 489.169 | Milliken Reservoir Property | 2000 | |
7016 | 7016 | 7015 | {"type": "Polygon", "coordinates": [[[-121.17077, 38.75418], [-121.16993, 38.75466], [-121.1697, 38.75468], [-121.16948, 38.75447], [-121.16881, 38.75478], [-121.16876, 38.75502], [-121.16861, 38.7552], [-121.16835, 38.75537], [-121.16788, 38.7554], [-121.16753, 38.75571], [-121.16726, 38.75588], [-121.16716, 38.75623], [-121.16677, 38.75661], [-121.16673, 38.75682], [-121.16613, 38.75708], [-121.16599, 38.75725], [-121.16577, 38.75739], [-121.16554, 38.75728], [-121.16531, 38.75748], [-121.16497, 38.75763], [-121.16483, 38.75781], [-121.16452, 38.75776], [-121.16401, 38.7578], [-121.164, 38.75736], [-121.16404, 38.75718], [-121.16409, 38.75705], [-121.16416, 38.75691], [-121.16436, 38.75666], [-121.16713, 38.75422], [-121.16735, 38.75406], [-121.16907, 38.75301], [-121.17077, 38.75418]]]} | Restricted Access 2 | Miners Ravine Nature Reserve | 22264 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 24.574 | Miners Ravine Nature Reserve | ||
7085 | 7085 | 7084 | {"type": "Polygon", "coordinates": [[[-117.64606, 33.71715], [-117.64569, 33.71705], [-117.6455, 33.71693], [-117.64478, 33.71604], [-117.64591, 33.71499], [-117.64598, 33.71518], [-117.64608, 33.71555], [-117.64612, 33.7158], [-117.64612, 33.71618], [-117.64606, 33.71715]]]} | Open Access 1 | Modjeska Home and Garden | 22342 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 4.244 | Modjeska Home and Garden | ||
7094 | 7094 | 7093 | {"type": "Polygon", "coordinates": [[[-118.16724, 35.04691], [-118.16723, 35.04813], [-118.16709, 35.04817], [-118.1671, 35.04939], [-118.16668, 35.04939], [-118.16666, 35.04886], [-118.16569, 35.04886], [-118.16566, 35.04657], [-118.16724, 35.04691]]]} | Open Access 1 | Mojave East Park | 22351 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 8.57 | Mojave East Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);