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 275
- California Department of Fish and Wildlife 186
- Los Angeles, City of 178
- California Department of Parks and Recreation 137
- Ventura, City of 119
- Mountains Recreation and Conservation Authority 80
- Long Beach, City of 69
- Los Angeles, County of 66
- San Diego, County of 62
- Los Angeles - Department of Parks and Recreation, County of 49
- San Francisco, City and County of 42
- East Bay Regional Park District 39
- San Jose, City of 35
- Marin County Open Space District 31
- Davis, City of 30
- Sacramento, City of 29
- Santa Clarita, City of 27
- Napa, City of 26
- Clovis, City of 26
- Santa Cruz, City of 25
- Midpeninsula Regional Open Space District 23
- Newport Beach, City of 22
- San Jacinto, City of 22
- Consumnes Community Services District 22
- Glendale, City of 21
- Santa Barbara, County of 20
- Brentwood, City of 20
- Conejo Open Space Conservation Agency 20
- Orange, County of 19
- Fresno, City of 18
- …
MNG_AG_TYP 26
- City Agency 2,591
- State Agency 358
- County Agency 310
- Recreation/Parks District 258
- Open Space District 104
- County Agency - Parks 100
- Non Profit - Land Trust 94
- Federal Agency 62
- Community Services District 49
- Water District 33
- Non Profit - Conservation 28
- Non Profit - Other 19
- Flood District 17
- Cemetery District 13
- Port/Harbor District 13
- County Agency - Other 6
- Irrigation District 5
- Special District - Other 3
- Sanitation District 2
- Joint Powers Authority 2
- Other 2
- Non Profit - Education 2
- Metropolitan Planning Organization 1
- Non Profit - Cemetery District 1
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 1
- Open Access · 4,075 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10467 | 10467 | 10466 | {"type": "Polygon", "coordinates": [[[-121.98272, 38.36571], [-121.98118, 38.36563], [-121.9812, 38.36528], [-121.98124, 38.36513], [-121.98126, 38.36473], [-121.98231, 38.36477], [-121.98241, 38.3648], [-121.98251, 38.36487], [-121.98263, 38.36502], [-121.9827, 38.36517], [-121.98273, 38.36528], [-121.98274, 38.36538], [-121.98272, 38.36571]]]} | Open Access 1 | Trower Park | 26551 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 3.155 | Trower Park | ||
10468 | 10468 | 10467 | {"type": "Polygon", "coordinates": [[[-121.55654, 39.08626], [-121.55575, 39.08624], [-121.55525, 39.08369], [-121.55507, 39.08357], [-121.55476, 39.0835], [-121.55436, 39.08348], [-121.55395, 39.08341], [-121.55384, 39.08347], [-121.55381, 39.08352], [-121.55367, 39.08406], [-121.55346, 39.08402], [-121.5532, 39.08393], [-121.55249, 39.08393], [-121.55247, 39.08387], [-121.55245, 39.08371], [-121.55323, 39.08371], [-121.55352, 39.08366], [-121.55361, 39.08346], [-121.55368, 39.08309], [-121.5535, 39.08293], [-121.55322, 39.0829], [-121.55247, 39.0829], [-121.55251, 39.08149], [-121.55253, 39.08144], [-121.55264, 39.08142], [-121.55278, 39.08142], [-121.55293, 39.08143], [-121.55308, 39.08148], [-121.55313, 39.08256], [-121.55362, 39.08251], [-121.55359, 39.08164], [-121.55378, 39.08167], [-121.55427, 39.08162], [-121.55433, 39.08163], [-121.55437, 39.08167], [-121.5544, 39.08181], [-121.55395, 39.08187], [-121.55393, 39.08254], [-121.55506, 39.08254], [-121.55465, 39.0804], [-121.55438, 39.07923], [-121.55421, 39.07835], [-121.55419, 39.07818], [-121.55421, 39.07722], [-121.55484, 39.07717], [-121.55499, 39.07849], [-121.55539, 39.08055], [-121.55609, 39.08428], [-121.55617, 39.0843], [-121.55654, 39.08626]]]} | Open Access 1 | Neighborhood Open Space/Common Area | 22685 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 23.737 | Neighborhood OS/Common Area | ||
10469 | 10469 | 10468 | {"type": "Polygon", "coordinates": [[[-118.20273, 33.82355], [-118.20253, 33.8243], [-118.20239, 33.82419], [-118.20128, 33.82355], [-118.20273, 33.82355]]]} | Open Access 1 | Baker Street Park | 28945 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.331 | Baker Street Park | ||
10470 | 10470 | 10469 | {"type": "MultiPolygon", "coordinates": [[[[-118.82675, 34.12934], [-118.82656, 34.12946], [-118.82635, 34.12956], [-118.82613, 34.12963], [-118.82589, 34.12968], [-118.82553, 34.1297], [-118.82456, 34.1296], [-118.82428, 34.1296], [-118.82403, 34.12963], [-118.82379, 34.12969], [-118.82343, 34.12983], [-118.82322, 34.12995], [-118.82301, 34.13011], [-118.82286, 34.13026], [-118.82272, 34.13044], [-118.82257, 34.13074], [-118.82231, 34.13161], [-118.82228, 34.13162], [-118.82224, 34.13174], [-118.81988, 34.13063], [-118.81916, 34.13037], [-118.81818, 34.13017], [-118.81791, 34.13015], [-118.81748, 34.13015], [-118.8143, 34.13024], [-118.814, 34.13027], [-118.81353, 34.13034], [-118.81297, 34.13047], [-118.81251, 34.13063], [-118.81006, 34.13159], [-118.80968, 34.13178], [-118.8079, 34.13278], [-118.80384, 34.13634], [-118.80183, 34.13618], [-118.80669, 34.13186], [-118.80064, 34.13125], [-118.79957, 34.13104], [-118.79939, 34.13094], [-118.79929, 34.13086], [-118.79921, 34.13075], [-118.79906, 34.13032], [-118.79849, 34.12942], [-118.79825, 34.12891], [-118.80312, 34.12892], [-118.81084, 34.12888], [-118.81074, 34.12532], [-118.81948, 34.12532], [-118.81948, 34.12167], [-118.82382, 34.12168], [-118.82384, 34.1236], [-118.82257, 34.12433], [-118.82397, 34.12477], [-118.82675, 34.12934]]], [[[-118.83083, 34.13356], [-118.83074, 34.1336], [-118.83079, 34.13377], [-118.83079, 34.13389], [-118.83075, 34.13401], [-118.83065, 34.13419], [-118.83055, 34.13415], [-118.82913, 34.13415], [-118.82912, 34.13332], [-118.82751, 34.13241], [-118.82695, 34.13309], [-118.82629, 34.1332], [-118.82576, 34.13253], [-118.82454, 34.1332], [-118.82418, 34.1328], [-118.82376, 34.13244], [-118.82329, 34.13212], [-118.82296, 34.13193], [-118.82258, 34.13175], [-118.82256, 34.13171], [-118.8228, 34.13089], [-118.82291, 34.13062], [-118.82303, 34.13045], [-118.82317, 34.13029], [-118.82334, 34.13016], [-118.82352, 34.13004], [-118.82373, 34.12995], [-118.82395, 34.12988], [-118.82429, 34.12982], [-118.82464, 34.12983], [-118.82551, 34.12991], [-118.82575, 34.12991], [-118.82599, 34.12989], [-118.82623, 34.12984], [-118.82646, 34.12976], [-118.82667, 34.12966], [-118.82687, 34.12954], [-118.82807, 34.13151], [-118.82925, 34.133], [-118.83083, 34.13356]]]]} | Open Access 1 | Truinfo Creek Park | 26554 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 377.359 | Truinfo Creek Park | ||
10471 | 10471 | 10470 | {"type": "Polygon", "coordinates": [[[-117.91753, 33.86783], [-117.9174, 33.86783], [-117.91739, 33.86746], [-117.91753, 33.86746], [-117.91753, 33.86783]]]} | Open Access 1 | Truslow Park | 26555 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 0.132 | Truslow Park | ||
10472 | 10472 | 10471 | {"type": "MultiPolygon", "coordinates": [[[[-120.11204, 39.18469], [-120.11176, 39.1848], [-120.11195, 39.18517], [-120.11054, 39.18565], [-120.11053, 39.18732], [-120.10894, 39.18731], [-120.10892, 39.18738], [-120.10783, 39.18743], [-120.10791, 39.18368], [-120.10919, 39.18328], [-120.10947, 39.18378], [-120.11025, 39.18353], [-120.11056, 39.18408], [-120.11153, 39.18376], [-120.11204, 39.18469]]], [[[-120.11717, 39.18101], [-120.11706, 39.18367], [-120.11653, 39.18367], [-120.11661, 39.18203], [-120.11608, 39.182], [-120.11613, 39.18078], [-120.1164, 39.18079], [-120.11666, 39.18083], [-120.11675, 39.18086], [-120.11717, 39.18101]]]]} | Open Access 1 | TSRA Outliers - Skylandia | 26556 | 2260 | Tahoe City Public Utilities District 658 | Special District 4 | Water District 13 | http://www.tahoecitypud.com/parksrec.shtml | Special District 4 | 33.484 | TSRA Outliers - Skylandia | ||
10473 | 10473 | 10472 | {"type": "Polygon", "coordinates": [[[-124.14507, 41.05769], [-124.14489, 41.05781], [-124.14479, 41.05795], [-124.14489, 41.05811], [-124.14453, 41.05839], [-124.14421, 41.05841], [-124.14377, 41.0584], [-124.1432, 41.05837], [-124.14317, 41.05823], [-124.14302, 41.05823], [-124.14301, 41.05837], [-124.14057, 41.05836], [-124.14054, 41.05825], [-124.13974, 41.05835], [-124.1395, 41.05884], [-124.13923, 41.05903], [-124.13892, 41.05909], [-124.13916, 41.05822], [-124.14054, 41.05772], [-124.14055, 41.05731], [-124.14186, 41.05739], [-124.14207, 41.0573], [-124.1432, 41.05748], [-124.14409, 41.05757], [-124.1448, 41.05732], [-124.14507, 41.05769]]]} | Open Access 1 | Tsurai Village | 26557 | 1664 | Trinidad, City of 701 | City 2 | City Agency 2 | http://www.trinidad.ca.gov/ | City 2 | 11.487 | Tsurai Village | ||
10474 | 10474 | 10473 | {"type": "MultiPolygon", "coordinates": [[[[-119.77498, 34.46477], [-119.77385, 34.46839], [-119.7732, 34.46839], [-119.7732, 34.46911], [-119.77251, 34.46862], [-119.77253, 34.46829], [-119.77206, 34.46758], [-119.77217, 34.46752], [-119.77276, 34.46791], [-119.77294, 34.46775], [-119.77232, 34.46728], [-119.77183, 34.46712], [-119.77177, 34.46676], [-119.77187, 34.46645], [-119.77169, 34.46605], [-119.77173, 34.46528], [-119.7717, 34.46476], [-119.77498, 34.46477]]], [[[-119.79223, 34.45174], [-119.79173, 34.45211], [-119.79156, 34.45238], [-119.79156, 34.45359], [-119.78801, 34.45358], [-119.788, 34.45266], [-119.78748, 34.45287], [-119.78717, 34.4529], [-119.78634, 34.45255], [-119.78598, 34.45255], [-119.78535, 34.4528], [-119.78534, 34.45312], [-119.78542, 34.45332], [-119.78466, 34.45356], [-119.78362, 34.45418], [-119.78415, 34.45508], [-119.7842, 34.4555], [-119.78334, 34.45629], [-119.78311, 34.4564], [-119.78266, 34.45669], [-119.78256, 34.45746], [-119.78194, 34.45821], [-119.78088, 34.45805], [-119.78023, 34.45787], [-119.77977, 34.45846], [-119.77982, 34.45869], [-119.77911, 34.4591], [-119.77894, 34.45964], [-119.77866, 34.46029], [-119.77817, 34.46051], [-119.7779, 34.46108], [-119.77607, 34.4611], [-119.77626, 34.46179], [-119.77563, 34.46273], [-119.77529, 34.46339], [-119.77525, 34.46378], [-119.7736, 34.46379], [-119.77361, 34.46204], [-119.77404, 34.46191], [-119.77526, 34.46129], [-119.77528, 34.46109], [-119.77689, 34.46017], [-119.77698, 34.45946], [-119.77737, 34.45886], [-119.77807, 34.45828], [-119.77827, 34.458], [-119.7784, 34.45778], [-119.77877, 34.45692], [-119.77871, 34.45682], [-119.77868, 34.45673], [-119.77881, 34.45668], [-119.77931, 34.45642], [-119.77996, 34.45631], [-119.7799, 34.45591], [-119.78001, 34.45558], [-119.78025, 34.45532], [-119.78111, 34.4551], [-119.78261, 34.45501], [-119.78226, 34.45446], [-119.78221, 34.45401], [-119.78235, 34.45374], [-119.78277, 34.45323], [-119.78296, 34.45324], [-119.7834, 34.45314], [-119.78403, 34.45269], [-119.78538, 34.45218], [-119.78598, 34.45216], [-119.78801, 34.45231], [-119.78803, 34.45225], [-119.78817, 34.4522], [-119.78839, 34.45202], [-119.78885, 34.45196], [-119.78908, 34.45179], [-119.78916, 34.45158], [-119.78939, 34.45148], [-119.78985, 34.45147], [-119.79014, 34.45163], [-119.79023, 34.45147], [-119.79093, 34.45169], [-119.79135, 34.45177], [-119.79223, 34.45174]]]]} | Open Access 1 | Tuckers Grove Park | 26558 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 111.524 | Tuckers Grove Park | ||
10475 | 10475 | 10474 | {"type": "Polygon", "coordinates": [[[-119.77525, 34.46378], [-119.77515, 34.46411], [-119.77508, 34.46423], [-119.77513, 34.46436], [-119.77498, 34.46477], [-119.77422, 34.46477], [-119.77427, 34.4643], [-119.77438, 34.46379], [-119.77525, 34.46378]]]} | Open Access 1 | Tuckers Grove Park | 26559 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2.064 | Tuckers Grove Park | ||
10476 | 10476 | 10475 | {"type": "Polygon", "coordinates": [[[-117.86891, 33.90185], [-117.86741, 33.90185], [-117.8674, 33.90018], [-117.86789, 33.90018], [-117.86791, 33.90004], [-117.86887, 33.90003], [-117.86891, 33.90185]]]} | Open Access 1 | Tuffree Hill Park | 26560 | 1255 | Placentia, City of 237 | City 2 | City Agency 2 | http://www.placentia.org/ | City 2 | 6.627 | Tuffree Hill Park | ||
10477 | 10477 | 10476 | {"type": "Polygon", "coordinates": [[[-118.34268, 34.26987], [-118.34212, 34.26999], [-118.34206, 34.26981], [-118.34091, 34.26925], [-118.33938, 34.26836], [-118.33771, 34.26708], [-118.33809, 34.26706], [-118.33825, 34.26717], [-118.33934, 34.26732], [-118.33934, 34.26743], [-118.34229, 34.26782], [-118.34195, 34.26956], [-118.34268, 34.26987]]]} | Open Access 1 | Tujunga Ponds Wildlife Sanctuary | 26562 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 12.893 | Tujunga Ponds Wildlife Sanctuary | ||
10478 | 10478 | 10477 | {"type": "Polygon", "coordinates": [[[-119.3355, 36.20739], [-119.33118, 36.20737], [-119.33122, 36.2057], [-119.33122, 36.20386], [-119.33545, 36.20385], [-119.3355, 36.20739]]]} | Open Access 1 | Tulare Cemetery | 26563 | 2167 | Tulare Cemetery District 219 | Special District 4 | Cemetery District 11 | Special District 4 | 37.019 | Tulare Cemetery | |||
10480 | 10480 | 10479 | {"type": "Polygon", "coordinates": [[[-118.09898, 33.80692], [-118.09897, 33.80754], [-118.09893, 33.80755], [-118.09861, 33.80755], [-118.09855, 33.80754], [-118.0985, 33.80752], [-118.09845, 33.80743], [-118.09845, 33.807], [-118.09847, 33.80695], [-118.09853, 33.80691], [-118.0986, 33.8069], [-118.09893, 33.8069], [-118.09898, 33.80692]]]} | Open Access 1 | Good Neighbor Park | http://www.longbeach.gov/Park/Park-and-Facilities/Directory/Good-Neighbor-Park/ | 28968 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.84 | Good Neighbor Park | |
10481 | 10481 | 10480 | {"type": "Polygon", "coordinates": [[[-118.19153, 33.77061], [-118.19153, 33.77074], [-118.19112, 33.77074], [-118.1911, 33.77071], [-118.19105, 33.77071], [-118.19104, 33.77074], [-118.19091, 33.77074], [-118.19091, 33.77061], [-118.19153, 33.77061]]]} | Open Access 1 | Harvey Milk Promenade | 28969 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.205 | Harvey Milk Promenade | ||
10482 | 10482 | 10481 | {"type": "Polygon", "coordinates": [[[-118.17048, 33.8517], [-118.17048, 33.8517], [-118.16998, 33.8517], [-118.17048, 33.85153], [-118.17048, 33.8517]]]} | Open Access 1 | Jackson Street Dog Park | 28971 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.111 | Jackson Street Dog Park | ||
10483 | 10483 | 10482 | {"type": "Polygon", "coordinates": [[[-118.17621, 33.79705], [-118.17208, 33.79435], [-118.17208, 33.79407], [-118.1762, 33.79673], [-118.17621, 33.79705]]]} | Open Access 1 | Jenni Rivera Memorial Park | 28972 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 3.154 | Jenni Rivera Memorial Park | ||
10484 | 10484 | 10483 | {"type": "Polygon", "coordinates": [[[-118.19355, 33.77787], [-118.19355, 33.77801], [-118.19333, 33.77801], [-118.19333, 33.77787], [-118.19355, 33.77787]]]} | Open Access 1 | K-9 Corner Dog Park | http://www.longbeach.gov/Park/Park-and-Facilities/Directory/K-9-Corner-Dog-Park/ | 28973 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.076 | K-9 Corner Dog Park | |
10485 | 10485 | 10484 | {"type": "Polygon", "coordinates": [[[-118.1198, 33.76062], [-118.11979, 33.76069], [-118.11975, 33.76074], [-118.11964, 33.7608], [-118.11701, 33.75838], [-118.11694, 33.75835], [-118.1168, 33.75835], [-118.11667, 33.7584], [-118.1165, 33.75853], [-118.1164, 33.75854], [-118.11633, 33.75852], [-118.11608, 33.75832], [-118.11531, 33.75762], [-118.11527, 33.75757], [-118.11514, 33.75749], [-118.11501, 33.75745], [-118.11529, 33.7574], [-118.11572, 33.75726], [-118.11599, 33.75708], [-118.11976, 33.76053], [-118.1198, 33.76062]]]} | Open Access 1 | Davies Launch Ramp | 28975 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 6.062 | Davies Launch Ramp | ||
10487 | 10487 | 10486 | {"type": "Polygon", "coordinates": [[[-118.20065, 33.78135], [-118.20033, 33.78157], [-118.20014, 33.78173], [-118.20008, 33.78169], [-118.20031, 33.7815], [-118.2005, 33.78127], [-118.20065, 33.78135]]]} | Open Access 1 | Loma Vista Park | 28977 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.143 | Loma Vista Park | ||
10488 | 10488 | 10487 | {"type": "Polygon", "coordinates": [[[-119.37747, 36.18538], [-119.37486, 36.1854], [-119.37481, 36.1819], [-119.37744, 36.18188], [-119.37747, 36.18538]]]} | Open Access 1 | Tulare Cycle Park | 26564 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 22.657 | Tulare Cycle 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]);