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 168
- San Diego, County of 120
- Santa Barbara, County of 87
- Orange, County of 80
- Lake, County of 52
- Santa Cruz, County of 47
- Kern, County of 47
- Sacramento, County of 46
- Riverside, County of 39
- Butte, County of 37
- San Luis Obispo, County of 31
- Monterey, County of 29
- Placer, County of 27
- Stanislaus, County of 24
- San Joaquin, County of 21
- Ventura, County of 20
- San Bernardino, County of 18
- Fresno, County of 17
- Yolo, County of 16
- Tulare, County of 14
- Merced, County of 14
- 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 944
- Restricted Access 57
- Unknown Access 35
- No Public Access 26
MNG_AG_TYP 1
- County Agency · 1,062 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2428 | 2428 | 2427 | {"type": "Polygon", "coordinates": [[[-121.81614, 39.72758], [-121.81561, 39.72764], [-121.8156, 39.7274], [-121.81609, 39.72734], [-121.81614, 39.72758]]]} | Open Access 1 | Butte holding 9 | 16603 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.296 | Butte holding 9 | ||
6633 | 6633 | 6632 | {"type": "Polygon", "coordinates": [[[-118.45957, 33.97626], [-118.45923, 33.97627], [-118.4592, 33.97624], [-118.4591, 33.97585], [-118.45895, 33.97554], [-118.45957, 33.97626]]]} | Open Access 1 | Marina del Rey pocket park | 21821 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.299 | Marina del Rey pocket park | ||
5482 | 5482 | 5481 | {"type": "Polygon", "coordinates": [[[-120.42391, 37.95344], [-120.42385, 37.95358], [-120.42349, 37.95357], [-120.42294, 37.95347], [-120.42298, 37.95335], [-120.42353, 37.95346], [-120.42357, 37.95338], [-120.42391, 37.95344]]]} | Open Access 1 | Jamestown Park | 20357 | 368 | Tuolumne, County of 670 | County 3 | County Agency 3 | http://www.tuolumnecounty.ca.gov/index.aspx?NID=448 | County 3 | 0.305 | Jamestown Park | ||
798 | 798 | 797 | {"type": "Polygon", "coordinates": [[[-121.7975, 39.63935], [-121.79716, 39.63942], [-121.797, 39.63897], [-121.79721, 39.63893], [-121.79729, 39.63902], [-121.7975, 39.63935]]]} | Open Access 1 | Butte holding 29 | 16573 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.324 | Butte holding 29 | ||
2414 | 2414 | 2413 | {"type": "Polygon", "coordinates": [[[-121.16103, 39.53302], [-121.16075, 39.53306], [-121.16074, 39.53253], [-121.16102, 39.53249], [-121.16103, 39.53302]]]} | Open Access 1 | Butte holding 46 | 16590 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.356 | Butte holding 46 | ||
12025 | 12025 | 12024 | {"type": "Polygon", "coordinates": [[[-118.19408, 33.89118], [-118.19324, 33.89119], [-118.19323, 33.89102], [-118.19407, 33.89102], [-118.19408, 33.89118]]]} | Unknown Access 4 | Washington Ave Park | 28912 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 0.359 | Washington Ave Park | ||
9393 | 9393 | 9392 | {"type": "Polygon", "coordinates": [[[-121.25202, 38.40904], [-121.25157, 38.40901], [-121.25157, 38.40891], [-121.25154, 38.40884], [-121.25164, 38.40866], [-121.25175, 38.40863], [-121.25192, 38.40869], [-121.25202, 38.40883], [-121.25202, 38.40904]]]} | Unknown Access 4 | Schnabel Tentative Parcel Map | 25185 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 0.365 | Schnabel Tentative Parcel Map | ||
5727 | 5727 | 5726 | {"type": "Polygon", "coordinates": [[[-118.42526, 35.75506], [-118.42503, 35.75558], [-118.42496, 35.7556], [-118.42486, 35.75555], [-118.42471, 35.75542], [-118.42471, 35.75535], [-118.42484, 35.75527], [-118.42491, 35.75524], [-118.42512, 35.75508], [-118.42521, 35.75502], [-118.42526, 35.75506]]]} | Open Access 1 | Kernville Circle Park | 20633 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 0.366 | Kernville Circle Park | ||
11802 | 11802 | 11801 | {"type": "Polygon", "coordinates": [[[-120.70579, 38.3017], [-120.70573, 38.30198], [-120.70526, 38.30193], [-120.70527, 38.30181], [-120.70536, 38.30152], [-120.70544, 38.30153], [-120.70546, 38.30156], [-120.70552, 38.30157], [-120.70551, 38.30168], [-120.70579, 38.3017]]]} | Open Access 1 | Shutter Tree Park | 28439 | 350 | Calaveras, County of 1086 | County 3 | County Agency 3 | http://co.calaveras.ca.us/ | County 3 | 0.372 | Shutter Tree Park | ||
5915 | 5915 | 5914 | {"type": "Polygon", "coordinates": [[[-122.84377, 39.00039], [-122.84353, 39.00038], [-122.84353, 38.99972], [-122.84377, 38.99973], [-122.84377, 39.00039]]]} | Open Access 1 | Lake holding 33 | 20921 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.38 | Lake holding 33 | ||
8321 | 8321 | 8320 | {"type": "Polygon", "coordinates": [[[-121.95538, 36.98556], [-121.95509, 36.9857], [-121.95498, 36.98583], [-121.95502, 36.98592], [-121.95472, 36.98598], [-121.95477, 36.98571], [-121.9549, 36.98545], [-121.95538, 36.98556]]]} | Open Access 1 | Soquel Lions Park | 25623 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.381 | Soquel Lions Park | ||
2404 | 2404 | 2403 | {"type": "Polygon", "coordinates": [[[-121.85077, 39.77573], [-121.85049, 39.77573], [-121.84981, 39.77506], [-121.84994, 39.77497], [-121.85039, 39.77543], [-121.85077, 39.77573]]]} | Open Access 1 | Butte holding 19 | 16562 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.384 | Butte holding 19 | ||
1781 | 1781 | 1780 | {"type": "Polygon", "coordinates": [[[-121.74737, 39.49534], [-121.74694, 39.49534], [-121.74694, 39.49496], [-121.74736, 39.49496], [-121.74737, 39.49534]]]} | Open Access 1 | Butte holding 23 | 16567 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.385 | Butte holding 23 | ||
3211 | 3211 | 3210 | {"type": "Polygon", "coordinates": [[[-121.09228, 38.49266], [-121.09217, 38.49275], [-121.09165, 38.49255], [-121.09152, 38.49227], [-121.09165, 38.49217], [-121.09228, 38.49266]]]} | Open Access 1 | Cosumnes River Parkway | 17676 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 0.435 | Cosumnes River Parkway | ||
5928 | 5928 | 5927 | {"type": "Polygon", "coordinates": [[[-122.59666, 39.07534], [-122.59641, 39.07554], [-122.59618, 39.07535], [-122.59606, 39.07511], [-122.59631, 39.07494], [-122.59666, 39.07534]]]} | Open Access 1 | Lake holding 41 | 20930 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.441 | Lake holding 41 | ||
13858 | 13858 | 13857 | {"type": "Polygon", "coordinates": [[[-120.8994, 35.44501], [-120.89928, 35.44513], [-120.89917, 35.44528], [-120.8991, 35.44542], [-120.89902, 35.44564], [-120.89897, 35.44571], [-120.89886, 35.44584], [-120.89882, 35.44596], [-120.89867, 35.44589], [-120.89871, 35.44576], [-120.89885, 35.44561], [-120.89897, 35.4453], [-120.89912, 35.44507], [-120.89925, 35.44494], [-120.8994, 35.44501]]]} | Open Access 1 | Paul Andrew Park | https://slocountyparks.com/day-use-parks/paul-andrew-park/ | 33176 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 0.448 | Paul Andrew Park | |
2379 | 2379 | 2378 | {"type": "Polygon", "coordinates": [[[-121.81039, 39.64905], [-121.80925, 39.64906], [-121.80917, 39.64889], [-121.81039, 39.64889], [-121.81039, 39.64905]]]} | Open Access 1 | Butte holding 27 | 16571 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.457 | Butte holding 27 | ||
14432 | 14432 | 14431 | {"type": "Polygon", "coordinates": [[[-121.96932, 38.8863], [-121.9688, 38.88631], [-121.9688, 38.88594], [-121.96932, 38.88593], [-121.96932, 38.8863]]]} | Open Access 1 | Dunnigan Park | 33723 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 0.457 | Dunnigan Park | ||
4820 | 4820 | 4819 | {"type": "Polygon", "coordinates": [[[-119.08056, 37.77893], [-119.08015, 37.77893], [-119.08014, 37.77847], [-119.08056, 37.77847], [-119.08056, 37.77893]]]} | Open Access 1 | Gull Lake Park | 19565 | 309 | Mono, County of 531 | County 3 | County Agency 3 | http://www.monocounty.ca.gov/facilities/page/parks-recreation-areas | County 3 | 0.46 | Gull Lake Park | ||
8670 | 8670 | 8669 | {"type": "Polygon", "coordinates": [[[-121.93881, 36.98905], [-121.93822, 36.98905], [-121.93821, 36.98875], [-121.93824, 36.98871], [-121.93853, 36.9887], [-121.93856, 36.98875], [-121.93875, 36.98872], [-121.93881, 36.98905]]]} | Open Access 1 | Richard Vessey Park | 24328 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 0.46 | Richard Vessey 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]);