superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,352 rows where MNG_AG_LEV = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 171
- San Diego, County of 120
- Santa Barbara, County of 89
- Orange, County of 82
- Los Angeles - Department of Parks and Recreation, County of 63
- Lake, County of 56
- Butte, County of 53
- Santa Cruz, County of 50
- Sonoma County Regional Parks Dept., County of 48
- Sacramento, County of 48
- Kern, County of 47
- Santa Clara County Parks and Recreation Dept., County of 42
- Riverside, County of 39
- Marin County Parks Department, County of 34
- San Luis Obispo, County of 31
- Monterey, County of 31
- Placer, County of 28
- San Mateo County Parks and Recreation Dept., County of 24
- 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
- San Francisco - Public Utilities Commission, City and County of 12
- Humboldt, County of 12
- Contra Costa County Public Works Dept., County of 11
- El Dorado, County of 9
- …
ACCESS_TYP 4
- Open Access 1,191
- Restricted Access 78
- No Public Access 46
- Unknown Access 37
MNG_AG_TYP 3
- County Agency 1,102
- County Agency - Parks 218
- County Agency - Other 32
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 | ||
4922 | 4922 | 4921 | {"type": "Polygon", "coordinates": [[[-121.23657, 38.39513], [-121.23642, 38.3951], [-121.23642, 38.39505], [-121.23657, 38.39498], [-121.23657, 38.39513]]]} | Unknown Access 4 | Harrison Larry L/Tonya A | 19699 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 0.035 | Harrison Larry L/Tonya A | ||
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 | ||
781 | 781 | 780 | {"type": "Polygon", "coordinates": [[[-122.27841, 37.90357], [-122.27835, 37.9037], [-122.2783, 37.90383], [-122.27824, 37.90357], [-122.27841, 37.90357]]]} | Open Access 1 | Kensington Pocket Park | 32715 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 0.053 | Kensington PP | ||
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 | ||
5150 | 5150 | 5149 | {"type": "Polygon", "coordinates": [[[-122.46654, 37.70822], [-122.46654, 37.70827], [-122.46585, 37.70826], [-122.46585, 37.70822], [-122.46654, 37.70822]]]} | Restricted Access 2 | Hillcrest And Ocean View Lots | 19962 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | http://sfwater.org/ | County 3 | 0.079 | Hillcrest And Ocean View Lots | ||
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 | ||
14203 | 14203 | 14202 | {"type": "Polygon", "coordinates": [[[-118.36175, 33.93255], [-118.36175, 33.93272], [-118.36145, 33.93272], [-118.36146, 33.93255], [-118.36175, 33.93255]]]} | Open Access 1 | Lennox Community Garden | 32666 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 0.127 | Lennox Community Garden | ||
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 | |
2581 | 2581 | 2580 | {"type": "Polygon", "coordinates": [[[-122.51744, 38.01193], [-122.51734, 38.01202], [-122.51708, 38.01218], [-122.51696, 38.01205], [-122.51738, 38.01189], [-122.51744, 38.01193]]]} | Open Access 1 | Candy's Park | 16799 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 0.134 | Candy's Park | ||
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 | ||
13514 | 13514 | 13513 | {"type": "Polygon", "coordinates": [[[-118.49989, 34.28871], [-118.49989, 34.28876], [-118.49978, 34.28895], [-118.49972, 34.28892], [-118.49959, 34.28878], [-118.49971, 34.28866], [-118.49975, 34.28864], [-118.49987, 34.28867], [-118.49989, 34.28871]]]} | Open Access 1 | Knollwood Pool | http://parks.lacounty.gov/knollwood-pool/ | 32669 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 0.139 | Knollwood Pool | |
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 |
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]);