superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13,512 rows where ACCESS_TYP = 1
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 313
- Los Angeles, City of 265
- California Department of Fish and Wildlife 195
- California Department of Parks and Recreation 139
- Ventura, City of 127
- San Jose, City of 104
- Sacramento, City of 98
- San Francisco, City and County of 94
- Mountains Recreation and Conservation Authority 92
- Long Beach, City of 88
- Los Angeles, County of 82
- Roseville, City of 75
- San Diego, County of 72
- Fresno, City of 55
- Poway, City of 52
- Orange, County of 51
- Los Angeles - Department of Parks and Recreation, County of 49
- Davis, City of 46
- Santa Barbara, County of 44
- East Bay Regional Park District 44
- Santa Cruz, City of 43
- Irvine, City of 41
- Oakland, City of 40
- Clovis, City of 39
- Consumnes Community Services District 36
- Napa, City of 35
- Marin County Open Space District 34
- Huntington Beach, City of 34
- Newport Beach, City of 33
- Chula Vista, City of 33
- …
MNG_AG_TYP 28
- City Agency 4,827
- County Agency 492
- Recreation/Parks District 467
- State Agency 394
- County Agency - Parks 123
- Open Space District 119
- Non Profit - Land Trust 109
- Federal Agency 80
- Community Services District 78
- Water District 55
- Non Profit - Conservation 36
- Cemetery District 28
- Flood District 27
- Non Profit - Other 21
- Port/Harbor District 20
- County Agency - Other 10
- Irrigation District 5
- Special District - Other 5
- Non Profit - Cemetery District 4
- Sanitation District 2
- Joint Powers Authority 2
- Other 2
- Conservation District 2
- Non Profit - Education 2
- Airport District 1
- Metropolitan Planning Organization 1
- Utility 1
- Transportation Agency 1
ACCESS_TYP 1
- Open Access · 6,914 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7335 | 7335 | 7334 | {"type": "Polygon", "coordinates": [[[-119.81988, 36.72408], [-119.81985, 36.72531], [-119.81777, 36.72532], [-119.8178, 36.7241], [-119.81988, 36.72408]]]} | Open Access 1 | Neilson Park | 22690 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 6.257 | Neilson Park | ||
7337 | 7337 | 7336 | {"type": "Polygon", "coordinates": [[[-121.36136, 37.98621], [-121.36133, 37.98643], [-121.36097, 37.98725], [-121.36089, 37.98729], [-121.36082, 37.98737], [-121.36084, 37.98748], [-121.36095, 37.9875], [-121.36103, 37.9875], [-121.36116, 37.98745], [-121.36116, 37.98823], [-121.35912, 37.98821], [-121.35913, 37.98797], [-121.3591, 37.98777], [-121.35898, 37.98745], [-121.35879, 37.98715], [-121.35854, 37.98689], [-121.35808, 37.98654], [-121.35827, 37.98636], [-121.35862, 37.98624], [-121.36004, 37.98613], [-121.36036, 37.98613], [-121.36136, 37.98621]]]} | Open Access 1 | Nelson Park | 22697 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 11.881 | Nelson Park | ||
7338 | 7338 | 7337 | {"type": "Polygon", "coordinates": [[[-121.95309, 38.34744], [-121.95188, 38.34744], [-121.95186, 38.34764], [-121.95078, 38.34765], [-121.95044, 38.34751], [-121.95006, 38.3475], [-121.94945, 38.34772], [-121.94916, 38.34773], [-121.94891, 38.34763], [-121.94871, 38.3474], [-121.94869, 38.34696], [-121.94884, 38.34673], [-121.94905, 38.34666], [-121.94932, 38.34661], [-121.94961, 38.34638], [-121.94961, 38.34618], [-121.94918, 38.34605], [-121.94937, 38.34573], [-121.95005, 38.34565], [-121.95035, 38.34515], [-121.95043, 38.34516], [-121.95084, 38.34536], [-121.9512, 38.34559], [-121.9516, 38.34597], [-121.95186, 38.3462], [-121.95216, 38.3463], [-121.95269, 38.34638], [-121.953, 38.3464], [-121.95306, 38.34646], [-121.95309, 38.34669], [-121.95309, 38.34744]]]} | Open Access 1 | Nelson Park | 22698 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 16.695 | Nelson Park | ||
7339 | 7339 | 7338 | {"type": "Polygon", "coordinates": [[[-121.57867, 39.52781], [-121.5776, 39.52782], [-121.5776, 39.52519], [-121.57866, 39.5252], [-121.57867, 39.52781]]]} | Open Access 1 | Nelson Park | 22699 | 2222 | Feather River Recreation and Park District 305 | Special District 4 | Recreation/Parks District 4 | http://www.frrpd.com/ | Special District 4 | 6.582 | Nelson Park | ||
7340 | 7340 | 7339 | {"type": "Polygon", "coordinates": [[[-122.27644, 37.78387], [-122.27625, 37.78369], [-122.27553, 37.78258], [-122.27515, 37.78152], [-122.27638, 37.78152], [-122.27644, 37.78387]]]} | Open Access 1 | Neptune Park | 22700 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 4.139 | Neptune Park | ||
7343 | 7343 | 7342 | {"type": "Polygon", "coordinates": [[[-121.45549, 37.74985], [-121.45549, 37.75012], [-121.45482, 37.75012], [-121.45482, 37.74986], [-121.45489, 37.7498], [-121.45542, 37.7498], [-121.45549, 37.74985]]]} | Open Access 1 | New Harmon Park | 22707 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.505 | New Harmon Park | ||
7344 | 7344 | 7343 | {"type": "Polygon", "coordinates": [[[-118.25416, 34.23366], [-118.25404, 34.23433], [-118.25313, 34.23376], [-118.25314, 34.23305], [-118.25416, 34.23366]]]} | Open Access 1 | New York Park | 22711 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1.78 | New York Park | ||
7345 | 7345 | 7344 | {"type": "Polygon", "coordinates": [[[-117.73254, 33.59302], [-117.73253, 33.59307], [-117.73166, 33.59479], [-117.73144, 33.59562], [-117.73133, 33.59566], [-117.73088, 33.59553], [-117.73023, 33.59525], [-117.72966, 33.59488], [-117.72903, 33.59433], [-117.72888, 33.59414], [-117.72891, 33.59404], [-117.72909, 33.59393], [-117.72931, 33.59375], [-117.72981, 33.59331], [-117.73016, 33.59294], [-117.73055, 33.59246], [-117.73066, 33.59232], [-117.7308, 33.59208], [-117.73132, 33.59105], [-117.73173, 33.59121], [-117.73157, 33.59153], [-117.73144, 33.59197], [-117.73141, 33.59256], [-117.73145, 33.5926], [-117.73154, 33.59264], [-117.73178, 33.59269], [-117.73191, 33.59274], [-117.73212, 33.59284], [-117.73242, 33.59294], [-117.73253, 33.593], [-117.73254, 33.59302]]]} | Open Access 1 | Ridgecrest Park | 24352 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 19.318 | Ridgecrest Park | ||
7346 | 7346 | 7345 | {"type": "Polygon", "coordinates": [[[-122.04309, 37.54756], [-122.04204, 37.54884], [-122.043, 37.54927], [-122.04271, 37.54949], [-122.04272, 37.5495], [-122.04285, 37.54956], [-122.04234, 37.54989], [-122.04175, 37.55019], [-122.04123, 37.5504], [-122.04059, 37.5506], [-122.04075, 37.55038], [-122.03993, 37.54926], [-122.04072, 37.54829], [-122.04156, 37.5465], [-122.04277, 37.54732], [-122.04309, 37.54756]]]} | Open Access 1 | Newark Community Park | 22712 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 16.332 | Newark Community Park | 1973 | |
7347 | 7347 | 7346 | {"type": "Polygon", "coordinates": [[[-122.01182, 37.51583], [-122.01166, 37.51629], [-122.01053, 37.51879], [-122.01011, 37.51977], [-122.00949, 37.51959], [-122.0089, 37.51937], [-122.00863, 37.51996], [-122.00771, 37.51964], [-122.00981, 37.51481], [-122.01051, 37.51513], [-122.01045, 37.51521], [-122.01046, 37.51523], [-122.01182, 37.51583]]]} | Open Access 1 | Newark Sportsfield Park | 22713 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 25.975 | Newark Sportsfield Park | 1984 | |
7348 | 7348 | 7347 | {"type": "Polygon", "coordinates": [[[-117.29528, 34.18298], [-117.29413, 34.18249], [-117.29299, 34.18199], [-117.29314, 34.18175], [-117.29427, 34.18224], [-117.29478, 34.18238], [-117.29482, 34.1824], [-117.29528, 34.18298]]]} | Open Access 1 | Newberry Park | 22714 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1.653 | Newberry Park | ||
7349 | 7349 | 7348 | {"type": "Polygon", "coordinates": [[[-124.13906, 40.59247], [-124.13676, 40.59354], [-124.13602, 40.5939], [-124.13375, 40.59256], [-124.13595, 40.59061], [-124.13772, 40.59169], [-124.13906, 40.59247]]]} | Open Access 1 | Newburg Park | 22715 | 1434 | Fortuna, City of 974 | City 2 | City Agency 2 | http://friendlyfortuna.com/index.aspx?nid=95 | City 2 | 20.167 | Newburg Park | ||
7350 | 7350 | 7349 | {"type": "Polygon", "coordinates": [[[-118.92828, 34.17927], [-118.92827, 34.17981], [-118.9281, 34.18001], [-118.92782, 34.18015], [-118.92755, 34.18041], [-118.92724, 34.18051], [-118.92703, 34.18066], [-118.92722, 34.18095], [-118.92737, 34.18092], [-118.92746, 34.18099], [-118.92741, 34.18111], [-118.92771, 34.18141], [-118.92733, 34.18174], [-118.92674, 34.18145], [-118.92554, 34.18141], [-118.9251, 34.18136], [-118.92529, 34.1803], [-118.92553, 34.1803], [-118.92596, 34.18017], [-118.92604, 34.17943], [-118.92614, 34.17943], [-118.9264, 34.17961], [-118.9263, 34.1797], [-118.92648, 34.18011], [-118.9265, 34.1803], [-118.92672, 34.18048], [-118.92732, 34.18029], [-118.92766, 34.17993], [-118.92792, 34.1794], [-118.92804, 34.17906], [-118.92828, 34.17927]]]} | Open Access 1 | Newbury Gateway Park | 22716 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 8.514 | Newbury Gateway Park | ||
7351 | 7351 | 7350 | {"type": "Polygon", "coordinates": [[[-121.12914, 38.87509], [-121.12851, 38.87524], [-121.12815, 38.87545], [-121.12789, 38.87511], [-121.12762, 38.87489], [-121.12767, 38.87476], [-121.12877, 38.87452], [-121.12914, 38.87509]]]} | Open Access 1 | Newcastle Ball Diamond | 22717 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 1.872 | Newcastle Ball Diamond | ||
7352 | 7352 | 7351 | {"type": "Polygon", "coordinates": [[[-118.03541, 34.14555], [-118.03539, 34.14633], [-118.03528, 34.14666], [-118.03358, 34.14558], [-118.03541, 34.14555]]]} | Open Access 1 | Newcastle Park | 22718 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 2.661 | Newcastle Park | ||
7353 | 7353 | 7352 | {"type": "Polygon", "coordinates": [[[-121.14527, 37.47444], [-121.14472, 37.47469], [-121.14451, 37.47482], [-121.14451, 37.47484], [-121.14457, 37.47488], [-121.14435, 37.47509], [-121.14375, 37.47469], [-121.14375, 37.47462], [-121.14395, 37.47443], [-121.14407, 37.47433], [-121.14432, 37.47419], [-121.14487, 37.47396], [-121.14497, 37.47398], [-121.14527, 37.47444]]]} | Open Access 1 | Newcastle Park | 22719 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 2.055 | Newcastle Park | ||
7354 | 7354 | 7353 | {"type": "Polygon", "coordinates": [[[-117.95924, 33.74856], [-117.95924, 33.74929], [-117.95809, 33.74929], [-117.95808, 33.74857], [-117.95924, 33.74856]]]} | Open Access 1 | Newcastle Park | 22720 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 2.116 | Newcastle Park | ||
7355 | 7355 | 7354 | {"type": "MultiPolygon", "coordinates": [[[[-121.36773, 41.88427], [-121.36702, 41.88492], [-121.36664, 41.88468], [-121.36734, 41.88403], [-121.36773, 41.88427]]], [[[-121.36818, 41.88455], [-121.36747, 41.8852], [-121.36708, 41.88496], [-121.36779, 41.88431], [-121.36818, 41.88455]]]]} | Open Access 1 | Newell Park | 22723 | 341 | Modoc, County of 618 | County 3 | County Agency 3 | http://www.co.modoc.ca.us/departments/parks-recreation | County 3 | 1.922 | Newell Park | ||
7356 | 7356 | 7355 | {"type": "Polygon", "coordinates": [[[-121.80553, 38.24988], [-121.80531, 38.26399], [-121.79679, 38.26386], [-121.79658, 38.2668], [-121.78831, 38.26682], [-121.7878, 38.26664], [-121.78733, 38.26662], [-121.78544, 38.2662], [-121.78491, 38.2661], [-121.78456, 38.26598], [-121.78421, 38.26583], [-121.78289, 38.26446], [-121.77578, 38.26139], [-121.77547, 38.26089], [-121.77623, 38.25992], [-121.7763, 38.25969], [-121.77649, 38.25954], [-121.77664, 38.25937], [-121.7767, 38.25928], [-121.77671, 38.25919], [-121.77643, 38.25875], [-121.77647, 38.25859], [-121.77653, 38.25849], [-121.77668, 38.2584], [-121.77706, 38.25836], [-121.77898, 38.25802], [-121.78341, 38.25586], [-121.78319, 38.24988], [-121.80553, 38.24988]]]} | Open Access 1 | Calhoun Cut Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Calhoun-Cut-ER | 32078 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 927.845 | Calhoun Cut ER | 1993 |
7357 | 7357 | 7356 | {"type": "Polygon", "coordinates": [[[-117.71219, 33.96046], [-117.71194, 33.96077], [-117.71215, 33.96092], [-117.70864, 33.96093], [-117.70864, 33.9609], [-117.7094, 33.96076], [-117.7099, 33.96075], [-117.71016, 33.9607], [-117.71016, 33.96007], [-117.70972, 33.95988], [-117.70972, 33.95969], [-117.70982, 33.95951], [-117.70982, 33.95944], [-117.70995, 33.9594], [-117.71007, 33.95927], [-117.71039, 33.95909], [-117.71086, 33.95968], [-117.71219, 33.96046]]]} | Open Access 1 | Rincon Park | 24368 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 6.754 | Rincon 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]);