superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
983 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 149
- San Diego, County of 102
- Santa Barbara, County of 75
- Orange, County of 75
- Lake, County of 56
- Butte, County of 53
- Santa Cruz, County of 48
- Kern, County of 46
- Riverside, County of 32
- San Luis Obispo, County of 29
- Placer, County of 27
- Monterey, County of 25
- Stanislaus, County of 23
- San Joaquin, County of 21
- Sacramento, County of 20
- Ventura, County of 18
- San Bernardino, County of 18
- Fresno, County of 16
- Merced, County of 16
- Yolo, County of 16
- Tulare, County of 14
- Humboldt, County of 11
- El Dorado, County of 9
- Mono, County of 7
- Tehama, County of 7
- Mendocino, County of 7
- Mariposa, County of 6
- Lassen, County of 6
- Imperial, County of 5
- Modoc, County of 5
- …
MNG_AG_TYP 1
- County Agency · 983 ✖
ACCESS_TYP 1
- Open Access · 983 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5663 | 5663 | 5662 | {"type": "Polygon", "coordinates": [[[-122.87408, 39.00329], [-122.87407, 39.0034], [-122.87395, 39.0034], [-122.874, 39.00329], [-122.87408, 39.00329]]]} | Open Access 1 | Lake holding 44 | 20933 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.025 | Lake holding 44 | ||
1551 | 1551 | 1550 | {"type": "Polygon", "coordinates": [[[-121.53081, 39.5272], [-121.53065, 39.5272], [-121.53066, 39.52703], [-121.53072, 39.5271], [-121.53081, 39.5272]]]} | Open Access 1 | Butte holding 35 | 16579 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.031 | Butte holding 35 | ||
2637 | 2637 | 2636 | {"type": "Polygon", "coordinates": [[[-121.92514, 36.53043], [-121.92439, 36.53053], [-121.92438, 36.5305], [-121.92514, 36.53041], [-121.92514, 36.53043]]]} | Open Access 1 | Carmel River Lagoon & Wetlands Natural Preserve | 16874 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 0.044 | Carmel River Lagoon & Wetlands Natural Preserve | ||
2398 | 2398 | 2397 | {"type": "Polygon", "coordinates": [[[-121.86042, 39.7738], [-121.86037, 39.77383], [-121.86008, 39.77354], [-121.86013, 39.77351], [-121.86042, 39.7738]]]} | Open Access 1 | Butte holding 13 | 16556 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.054 | Butte holding 13 | ||
2403 | 2403 | 2402 | {"type": "Polygon", "coordinates": [[[-121.8607, 39.77408], [-121.86065, 39.77411], [-121.86037, 39.77383], [-121.86042, 39.7738], [-121.8607, 39.77408]]]} | Open Access 1 | Butte holding 18 | 16561 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.054 | Butte holding 18 | ||
2695 | 2695 | 2694 | {"type": "Polygon", "coordinates": [[[-122.14918, 37.24376], [-122.14914, 37.24377], [-122.14907, 37.24375], [-122.14904, 37.24355], [-122.14916, 37.24355], [-122.14919, 37.2437], [-122.14918, 37.24376]]]} | Open Access 1 | Castle Rock State Park | http://www.parks.ca.gov/?page_id=538 | 16955 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.065 | Castle Rock SP | 1968 |
1362 | 1362 | 1361 | {"type": "Polygon", "coordinates": [[[-121.85722, 39.77066], [-121.85717, 39.77069], [-121.8568, 39.77032], [-121.85685, 39.77029], [-121.85722, 39.77066]]]} | Open Access 1 | Butte holding 34 | 16578 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.07 | Butte holding 34 | ||
2419 | 2419 | 2418 | {"type": "Polygon", "coordinates": [[[-121.79187, 39.75561], [-121.79161, 39.75549], [-121.79176, 39.75526], [-121.7918, 39.75541], [-121.79187, 39.75561]]]} | Open Access 1 | Butte holding 50 | 16595 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.088 | Butte holding 50 | ||
6245 | 6245 | 6244 | {"type": "Polygon", "coordinates": [[[-119.82652, 34.43735], [-119.82651, 34.43749], [-119.82615, 34.43748], [-119.82615, 34.43734], [-119.82652, 34.43735]]]} | Open Access 1 | Nectarine Mini Park | 22682 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.13 | Nectarine MP | ||
1757 | 1757 | 1756 | {"type": "Polygon", "coordinates": [[[-121.58711, 39.81342], [-121.58621, 39.81385], [-121.58619, 39.81385], [-121.58633, 39.81373], [-121.58677, 39.81349], [-121.58711, 39.81342]]]} | Open Access 1 | Butte holding 21 | 16565 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.131 | Butte holding 21 | ||
12057 | 12057 | 12056 | {"type": "Polygon", "coordinates": [[[-118.23999, 33.92472], [-118.23998, 33.92479], [-118.23922, 33.9248], [-118.23925, 33.92475], [-118.2393, 33.92473], [-118.23999, 33.92472]]]} | Open Access 1 | Martin Luther King Jr. Fitness Garden | http://parks.lacounty.gov/wps/portal/dpr/Parks/Martin_Luther_King_Jr_Fitness_Park | 28949 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.133 | Martin Luther King Jr. Fitness Garden | |
6598 | 6598 | 6597 | {"type": "Polygon", "coordinates": [[[-121.85358, 36.92094], [-121.85322, 36.92159], [-121.85317, 36.92157], [-121.85338, 36.92119], [-121.85334, 36.92115], [-121.85347, 36.92092], [-121.85358, 36.92094]]]} | Open Access 1 | Manresa State Beach Access | http://www.parks.ca.gov/?page_id=545 | 21760 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.136 | Manresa SB Access | |
2400 | 2400 | 2399 | {"type": "Polygon", "coordinates": [[[-121.62648, 39.76336], [-121.62653, 39.76339], [-121.62657, 39.76346], [-121.6266, 39.76354], [-121.62661, 39.76365], [-121.6266, 39.76373], [-121.62657, 39.76383], [-121.62646, 39.76397], [-121.62648, 39.76336]]]} | Open Access 1 | Butte holding 15 | 16558 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.139 | Butte holding 15 | ||
2409 | 2409 | 2408 | {"type": "Polygon", "coordinates": [[[-121.79721, 39.63893], [-121.797, 39.63897], [-121.79677, 39.63834], [-121.79719, 39.6389], [-121.79721, 39.63893]]]} | Open Access 1 | Butte holding 40 | 16585 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.167 | Butte holding 40 | ||
11772 | 11772 | 11771 | {"type": "Polygon", "coordinates": [[[-120.74524, 40.43205], [-120.7452, 40.43213], [-120.74515, 40.43217], [-120.74508, 40.43219], [-120.74501, 40.43218], [-120.74495, 40.43216], [-120.7449, 40.43211], [-120.74489, 40.43206], [-120.7449, 40.432], [-120.74494, 40.43195], [-120.745, 40.43192], [-120.74507, 40.43191], [-120.74514, 40.43193], [-120.7452, 40.43197], [-120.74524, 40.43205]]]} | Open Access 1 | Lake Forest Park | 28418 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 0.17 | Lake Forest Park | ||
1772 | 1772 | 1771 | {"type": "Polygon", "coordinates": [[[-121.60388, 39.85695], [-121.60385, 39.85697], [-121.60383, 39.857], [-121.60382, 39.85735], [-121.60364, 39.85735], [-121.60365, 39.857], [-121.60362, 39.85695], [-121.60388, 39.85695]]]} | Open Access 1 | Butte holding 22 | 16566 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.177 | Butte holding 22 | ||
2412 | 2412 | 2411 | {"type": "Polygon", "coordinates": [[[-121.60142, 39.85063], [-121.60119, 39.85063], [-121.60122, 39.85058], [-121.60124, 39.85016], [-121.60141, 39.85016], [-121.6014, 39.85058], [-121.60142, 39.85063]]]} | Open Access 1 | Butte holding 43 | 16588 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.199 | Butte holding 43 | ||
5929 | 5929 | 5928 | {"type": "Polygon", "coordinates": [[[-122.84342, 38.97848], [-122.84318, 38.97845], [-122.843, 38.97792], [-122.84307, 38.97802], [-122.84336, 38.97826], [-122.84341, 38.97837], [-122.84342, 38.97848]]]} | Open Access 1 | Lake holding 45 | 20934 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.209 | Lake holding 45 | ||
2396 | 2396 | 2395 | {"type": "Polygon", "coordinates": [[[-121.80054, 39.64365], [-121.8001, 39.64376], [-121.80003, 39.64358], [-121.80048, 39.64347], [-121.80054, 39.64365]]]} | Open Access 1 | Butte holding 11 | 16554 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.215 | Butte holding 11 | ||
12026 | 12026 | 12025 | {"type": "MultiPolygon", "coordinates": [[[[-118.15919, 34.01886], [-118.15904, 34.01936], [-118.15896, 34.01951], [-118.15899, 34.0193], [-118.15913, 34.01885], [-118.15916, 34.01883], [-118.15918, 34.01884], [-118.15919, 34.01886]]], [[[-118.15947, 34.01784], [-118.15947, 34.01795], [-118.15928, 34.01858], [-118.15923, 34.0186], [-118.15921, 34.01856], [-118.1594, 34.01795], [-118.15947, 34.01784]]]]} | Open Access 1 | Woods Avenue Park | http://parks.lacounty.gov/wps/portal/dpr/Parks/Woods_Avenue_Park | 28914 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.218 | Woods Avenue 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]);