superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,102 rows where MNG_AG_TYP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 170
- San Diego, County of 120
- Santa Barbara, County of 88
- Orange, County of 82
- Lake, County of 54
- Santa Cruz, County of 48
- Kern, County of 47
- Sacramento, County of 47
- Butte, County of 42
- Riverside, County of 39
- San Luis Obispo, County of 31
- Monterey, County of 30
- Placer, County of 28
- Stanislaus, County of 24
- San Joaquin, County of 21
- Ventura, County of 20
- San Bernardino, County of 18
- Fresno, County of 17
- Merced, County of 16
- Yolo, County of 16
- Tulare, County of 15
- Humboldt, County of 12
- El Dorado, County of 9
- Mono, County of 7
- Tehama, County of 7
- Mendocino, County of 7
- Mariposa, County of 6
- Imperial, County of 5
- Napa, County of 5
- Modoc, County of 5
- …
ACCESS_TYP 4
- Open Access 964
- Restricted Access 57
- Unknown Access 35
- No Public Access 26
MNG_AG_TYP 1
- County Agency · 1,082 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
1309 | 1309 | 1308 | {"type": "Polygon", "coordinates": [[[-121.54043, 39.47302], [-121.54011, 39.47302], [-121.54015, 39.47297], [-121.54015, 39.47262], [-121.54037, 39.47262], [-121.54038, 39.47297], [-121.54043, 39.47302]]]} | Open Access 1 | Butte holding 33 | 16577 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.222 | Butte holding 33 | ||
7719 | 7719 | 7718 | {"type": "Polygon", "coordinates": [[[-117.62881, 33.68711], [-117.62823, 33.68765], [-117.62818, 33.6877], [-117.62837, 33.68738], [-117.62838, 33.68717], [-117.62881, 33.68711]]]} | Open Access 1 | Orange holding 2 | 23167 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 0.227 | Orange holding 2 | ||
11869 | 11869 | 11868 | {"type": "Polygon", "coordinates": [[[-121.64339, 36.88847], [-121.64319, 36.88849], [-121.64313, 36.88847], [-121.6431, 36.88843], [-121.64306, 36.88816], [-121.64333, 36.88813], [-121.64339, 36.88847]]]} | Open Access 1 | Aromas Community Park | 28587 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 0.229 | Aromas Community Park | ||
14433 | 14433 | 14432 | {"type": "Polygon", "coordinates": [[[-121.09452, 38.93839], [-121.09416, 38.93839], [-121.09416, 38.93785], [-121.09416, 38.93785], [-121.09452, 38.93839]]]} | Open Access 1 | Auburn Plaza Park | https://www.placer.ca.gov/6005/Plaza-Park | 33724 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 0.231 | Auburn Plaza Park | |
11771 | 11771 | 11770 | {"type": "Polygon", "coordinates": [[[-122.03078, 38.03015], [-122.03061, 38.03021], [-122.03036, 38.02969], [-122.03052, 38.02965], [-122.03078, 38.03015]]]} | Open Access 1 | Big Oak Tree Park | http://www.contracosta.ca.gov/4398/Clyde | 28387 | 369 | Contra Costa, County of 1060 | County 3 | County Agency 3 | http://www.co.contra-costa.ca.us/446/Parks-and-Recreation | County 3 | 0.241 | Big Oak Tree Park | |
11734 | 11734 | 11733 | {"type": "Polygon", "coordinates": [[[-120.43799, 37.52002], [-120.43772, 37.5201], [-120.43759, 37.51977], [-120.43784, 37.51968], [-120.43799, 37.52002]]]} | Open Access 1 | Snelling Courthouse Park | 28338 | 308 | Merced, County of 469 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 0.242 | Snelling Courthouse Park | ||
186 | 186 | 185 | {"type": "Polygon", "coordinates": [[[-121.20472, 38.7035], [-121.2046, 38.70349], [-121.20457, 38.70342], [-121.20458, 38.70338], [-121.20455, 38.70317], [-121.20444, 38.70303], [-121.2044, 38.70283], [-121.20439, 38.70266], [-121.2044, 38.70262], [-121.20442, 38.7026], [-121.20446, 38.70223], [-121.20448, 38.7022], [-121.20452, 38.70221], [-121.20453, 38.70223], [-121.20449, 38.70252], [-121.20448, 38.70283], [-121.20455, 38.70304], [-121.20463, 38.70314], [-121.20463, 38.7033], [-121.20464, 38.70339], [-121.20472, 38.7035]]]} | Open Access 1 | 9101 Sunset Ave | 15222 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 0.246 | 9101 Sunset Ave | ||
2395 | 2395 | 2394 | {"type": "Polygon", "coordinates": [[[-121.53726, 39.64644], [-121.53646, 39.64655], [-121.53638, 39.64653], [-121.53648, 39.6463], [-121.53726, 39.64644]]]} | Open Access 1 | Butte holding 10 | 16553 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.247 | Butte holding 10 | ||
12016 | 12016 | 12015 | {"type": "Polygon", "coordinates": [[[-117.8205, 34.09105], [-117.82051, 34.09113], [-117.82049, 34.09123], [-117.82036, 34.09135], [-117.82033, 34.09142], [-117.82026, 34.09145], [-117.82024, 34.09087], [-117.82037, 34.09095], [-117.8205, 34.09105]]]} | Open Access 1 | San Dimas Staging Area | http://parks.lacounty.gov/wps/portal/dpr/Parks/San_Dimas_Staging_Area | 28895 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.247 | San Dimas Staging Area | |
9445 | 9445 | 9444 | {"type": "MultiPolygon", "coordinates": [[[[-121.89604, 36.96303], [-121.8959, 36.96315], [-121.89565, 36.96297], [-121.89579, 36.96284], [-121.89604, 36.96303]]], [[[-121.89601, 36.96337], [-121.89594, 36.96344], [-121.89597, 36.96347], [-121.89591, 36.96352], [-121.89585, 36.96371], [-121.89574, 36.96366], [-121.89573, 36.96365], [-121.89581, 36.96344], [-121.89591, 36.96334], [-121.89601, 36.96337]]]]} | Open Access 1 | Seacliff State Beach | http://www.parks.ca.gov/?page_id=543 | 25238 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.25 | Seacliff SB | 1931 |
14397 | 14397 | 14396 | {"type": "Polygon", "coordinates": [[[-119.31269, 36.05787], [-119.31226, 36.05793], [-119.31221, 36.0577], [-119.31261, 36.05762], [-119.31269, 36.05787]]]} | Open Access 1 | Unknown park - Tulare, County of | 33611 | 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 | 0.259 | |||
1117 | 1117 | 1116 | {"type": "Polygon", "coordinates": [[[-120.11686, 34.66391], [-120.11686, 34.66443], [-120.11666, 34.66443], [-120.11667, 34.6639], [-120.11686, 34.66391]]]} | Open Access 1 | Alamo Pintado Creek | 15318 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.262 | Alamo Pintado Creek | ||
5907 | 5907 | 5906 | {"type": "Polygon", "coordinates": [[[-122.7831, 39.06946], [-122.78298, 39.06985], [-122.78268, 39.06984], [-122.78283, 39.06946], [-122.7831, 39.06946]]]} | Open Access 1 | Lake holding 30 | 20918 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.262 | Lake holding 30 | ||
2399 | 2399 | 2398 | {"type": "Polygon", "coordinates": [[[-121.62744, 39.74865], [-121.62744, 39.74881], [-121.62673, 39.74875], [-121.62673, 39.74859], [-121.62744, 39.74865]]]} | Open Access 1 | Butte holding 14 | 16557 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.271 | Butte holding 14 | ||
975 | 975 | 974 | {"type": "Polygon", "coordinates": [[[-121.80908, 39.70888], [-121.80893, 39.70884], [-121.80835, 39.70799], [-121.80846, 39.70795], [-121.80908, 39.70888]]]} | Open Access 1 | Butte holding 31 | 16575 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.274 | Butte holding 31 | ||
6155 | 6155 | 6154 | {"type": "Polygon", "coordinates": [[[-121.0023, 37.25798], [-121.00198, 37.25807], [-121.00186, 37.25773], [-121.00217, 37.25766], [-121.0023, 37.25798]]]} | Open Access 1 | Library | 21216 | 308 | Merced, County of 469 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 0.28 | Library | ||
5200 | 5200 | 5199 | {"type": "Polygon", "coordinates": [[[-117.81409, 33.75983], [-117.81374, 33.7598], [-117.81367, 33.75975], [-117.81366, 33.75914], [-117.81378, 33.75944], [-117.81391, 33.75962], [-117.81409, 33.75983]]]} | Open Access 1 | Holderman Park | 20027 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 0.282 | Holderman Park | ||
2420 | 2420 | 2419 | {"type": "Polygon", "coordinates": [[[-121.57946, 39.50391], [-121.57904, 39.50395], [-121.57906, 39.50363], [-121.57941, 39.5036], [-121.57946, 39.50391]]]} | Open Access 1 | Butte holding 51 | 16596 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.284 | Butte holding 51 | ||
5932 | 5932 | 5931 | {"type": "Polygon", "coordinates": [[[-122.78298, 39.06985], [-122.78285, 39.07024], [-122.78253, 39.07024], [-122.78268, 39.06984], [-122.78298, 39.06985]]]} | Open Access 1 | Lake holding 49 | 20938 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.292 | Lake holding 49 |
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]);