units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,263 rows where AGNCY_TYP = 3 sorted by MNG_AG_LEV
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, YR_EST, GAP_STS
MNG_AGENCY >30
- Los Angeles, County of 155
- Santa Barbara, County of 117
- San Diego, County of 117
- Orange, County of 91
- Los Angeles - Department of Parks and Recreation, County of 60
- Lake, County of 56
- Sacramento, County of 55
- Butte, County of 53
- Santa Cruz, County of 51
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 42
- Riverside, County of 38
- San Luis Obispo, County of 31
- Placer, County of 28
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- Yolo, County of 18
- Fresno, County of 17
- San Bernardino, County of 17
- Merced, County of 16
- Tulare, County of 15
- Humboldt, County of 12
- Mono, County of 7
- Tehama, County of 7
- Mendocino, County of 7
- Mariposa, County of 6
- Lassen, County of 6
- Imperial, County of 5
- …
DES_TP >30
- Local Park 687
- Local Other or Unknown 214
- Local Recreation Area 126
- Local Conservation Area 98
- Local Historic or Cultural Area 21
- National Forest 2
- National Monument or Landmark 2
- None 1
- State Conservation Area 1
- None 1
- National Recreation Area 1
- None 1
- Local Resource Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 12
ACCESS_TYP 4
- Open Access 1,135
- Restricted Access 63
- Unknown Access 36
- No Public Access 29
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV ▼ | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16430 | 16430 | 16429 | {"type": "MultiPolygon", "coordinates": [[[[-117.09275, 32.55093], [-117.08419, 32.55089], [-117.08418, 32.54718], [-117.0885, 32.54724], [-117.08851, 32.54815], [-117.09275, 32.54817], [-117.09274, 32.54879], [-117.09275, 32.55093]]], [[[-117.10589, 32.55459], [-117.10142, 32.55462], [-117.0993, 32.55461], [-117.09923, 32.55817], [-117.09713, 32.55816], [-117.09714, 32.55461], [-117.09632, 32.5546], [-117.09634, 32.55816], [-117.09383, 32.55815], [-117.09383, 32.55778], [-117.09285, 32.55777], [-117.09287, 32.54879], [-117.09289, 32.5476], [-117.09288, 32.54732], [-117.1016, 32.54732], [-117.10155, 32.54367], [-117.10156, 32.53999], [-117.10318, 32.53998], [-117.10318, 32.54033], [-117.10459, 32.54111], [-117.1046, 32.54365], [-117.10584, 32.54365], [-117.10585, 32.54377], [-117.10576, 32.54378], [-117.10576, 32.54731], [-117.10584, 32.54732], [-117.10583, 32.55098], [-117.10589, 32.55459]]], [[[-117.11232, 32.54729], [-117.11231, 32.55095], [-117.11011, 32.55096], [-117.11016, 32.54731], [-117.11232, 32.54729]]]]} | Open Access 1 | 45291 | Tijuana River Valley Regional Park | 26362 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 451.08 | Tijuana River Valley RP | None 1401 | ||
4017 | 4017 | 4016 | {"type": "Polygon", "coordinates": [[[-120.42732, 34.97528], [-120.42699, 34.97526], [-120.42685, 34.97536], [-120.42682, 34.97661], [-120.42664, 34.97662], [-120.42664, 34.97691], [-120.42404, 34.97697], [-120.42397, 34.97488], [-120.42711, 34.97493], [-120.42732, 34.97528]]]} | Open Access 1 | 48887 | Jim May Park | 33608 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | https://www.cityofsantamaria.org/city-government/departments/recreation-and-parks/visit-your-parks/view-park-photos-descriptions#Jim%20May%20Park | Santa Barbara 7 | 14.607 | Jim May Park | 0 | Local Park 2 | 4 |
7300 | 7300 | 7299 | {"type": "Polygon", "coordinates": [[[-118.19815, 33.85938], [-118.19488, 33.86461], [-118.19471, 33.86483], [-118.19365, 33.86651], [-118.19195, 33.86924], [-118.1908, 33.86927], [-118.19254, 33.86619], [-118.19511, 33.86194], [-118.19574, 33.86094], [-118.19576, 33.86083], [-118.19594, 33.86053], [-118.1961, 33.86064], [-118.19622, 33.86063], [-118.19765, 33.85861], [-118.19767, 33.85857], [-118.19766, 33.85851], [-118.19785, 33.85833], [-118.19815, 33.85938]]]} | Open Access 1 | 6600 | DeForest Park | 18015 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 34.12 | DeForest Park | 2018 | Local Park 2 | 4 | |
7568 | 7568 | 7567 | {"type": "Polygon", "coordinates": [[[-118.553, 34.43747], [-118.55301, 34.43773], [-118.55298, 34.43794], [-118.55289, 34.43823], [-118.5528, 34.43842], [-118.55263, 34.43864], [-118.55245, 34.43883], [-118.55225, 34.43898], [-118.552, 34.43912], [-118.55144, 34.43787], [-118.55267, 34.4375], [-118.553, 34.43747]]]} | Open Access 1 | 7279 | Northbridge Park | 22868 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=811 | Los Angeles 6 | 3.887 | Northbridge Park | 0 | Local Park 2 | 4 |
7572 | 7572 | 7571 | {"type": "Polygon", "coordinates": [[[-118.4899, 34.44767], [-118.48977, 34.44785], [-118.48969, 34.44799], [-118.48943, 34.44865], [-118.48936, 34.44879], [-118.48926, 34.44893], [-118.48911, 34.44908], [-118.48801, 34.45001], [-118.48764, 34.45043], [-118.48749, 34.45034], [-118.48698, 34.44991], [-118.4868, 34.44979], [-118.48819, 34.44735], [-118.48876, 34.44752], [-118.48913, 34.44715], [-118.48988, 34.44762], [-118.4899, 34.44767]]]} | Open Access 1 | 7282 | David March Park | 29048 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 12.312 | David March Park | 0 | Local Park 2 | 4 | |
15381 | 15381 | 15380 | {"type": "Polygon", "coordinates": [[[-118.20463, 33.81903], [-118.20462, 33.81984], [-118.20458, 33.82011], [-118.20441, 33.82001], [-118.20429, 33.81989], [-118.20428, 33.81985], [-118.20429, 33.81892], [-118.20458, 33.81893], [-118.20463, 33.81903]]]} | Open Access 1 | 46593 | 34th St Greenbelt | 29894 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.928 | 34th St Greenbelt | 2007 | Local Recreation Area 3 | 4 | |
15382 | 15382 | 15381 | {"type": "Polygon", "coordinates": [[[-118.34245, 33.8418], [-118.34022, 33.84182], [-118.3402, 33.84072], [-118.34244, 33.8407], [-118.34245, 33.8418]]]} | Restricted Access 2 | 46597 | Toyota Sports Complex | 29898 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/27330.htm | Los Angeles 6 | 6.221 | Toyota Sports Complex | 0 | Local Recreation Area 3 | 4 |
15402 | 15402 | 15401 | {"type": "Polygon", "coordinates": [[[-118.06329, 33.84982], [-118.0591, 33.84985], [-118.05909, 33.84981], [-118.05833, 33.84982], [-118.05826, 33.8482], [-118.05747, 33.84819], [-118.05849, 33.8467], [-118.05885, 33.84651], [-118.05886, 33.84646], [-118.05925, 33.84648], [-118.05965, 33.84672], [-118.05952, 33.84687], [-118.05953, 33.84688], [-118.06124, 33.84794], [-118.06125, 33.84798], [-118.06132, 33.84798], [-118.06328, 33.84919], [-118.06329, 33.84982]]]} | Open Access 1 | 46623 | Cerritos Sports Complex | 29946 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 28.529 | Cerritos Sports Complex | 0 | Local Recreation Area 3 | 4 | |
16308 | 16308 | 16307 | {"type": "MultiPolygon", "coordinates": [[[[-117.0198, 32.82876], [-117.01951, 32.82959], [-117.01936, 32.8301], [-117.01773, 32.83003], [-117.01791, 32.82937], [-117.01801, 32.82935], [-117.01803, 32.82882], [-117.01793, 32.82837], [-117.01781, 32.82808], [-117.01732, 32.82737], [-117.01791, 32.82736], [-117.0198, 32.82876]]], [[[-117.04626, 32.81855], [-117.04598, 32.81888], [-117.04576, 32.81919], [-117.04407, 32.82211], [-117.04113, 32.82749], [-117.04075, 32.82815], [-117.04034, 32.82876], [-117.03996, 32.82928], [-117.03954, 32.82979], [-117.0391, 32.83029], [-117.03793, 32.83145], [-117.03427, 32.83146], [-117.02856, 32.82771], [-117.02747, 32.82882], [-117.02687, 32.82902], [-117.02698, 32.82892], [-117.0266, 32.82839], [-117.02654, 32.82842], [-117.02589, 32.82794], [-117.02548, 32.82847], [-117.02498, 32.82829], [-117.02459, 32.82809], [-117.02386, 32.82757], [-117.02399, 32.82745], [-117.02411, 32.82684], [-117.02346, 32.82662], [-117.02302, 32.82699], [-117.02263, 32.82673], [-117.02249, 32.82686], [-117.02235, 32.82676], [-117.02233, 32.82677], [-117.02208, 32.82659], [-117.01999, 32.82869], [-117.01798, 32.82719], [-117.01706, 32.8272], [-117.01687, 32.82685], [-117.01635, 32.82571], [-117.01586, 32.82388], [-117.01584, 32.82388], [-117.01574, 32.82376], [-117.01563, 32.82364], [-117.01539, 32.82346], [-117.01521, 32.82324], [-117.01505, 32.8231], [-117.01499, 32.823], [-117.01493, 32.82269], [-117.01488, 32.82256], [-117.01458, 32.82224], [-117.01449, 32.82216], [-117.01421, 32.82197], [-117.01183, 32.82066], [-117.01156, 32.82047], [-117.01137, 32.82028], [-117.01119, 32.82005], [-117.01107, 32.81978], [-117.0107, 32.81851], [-117.01061, 32.81816], [-117.0106, 32.81809], [-117.01066, 32.81799], [-117.01075, 32.81793], [-117.01086, 32.81792], [-117.01099, 32.81796], [-117.01107, 32.81805], [-117.01136, 32.81892], [-117.01145, 32.81906], [-117.01158, 32.81921], [-117.01183, 32.81938], [-117.01271, 32.81981], [-117.01289, 32.81988], [-117.01308, 32.81992], [-117.01337, 32.81993], [-117.01361, 32.8199], [-117.01385, 32.81983], [-117.01409, 32.8197], [-117.01425, 32.81957], [-117.01435, 32.81946], [-117.01481, 32.81877], [-117.0147, 32.81871], [-117.01426, 32.81937], [-117.01416, 32.81949], [-117.01399, 32.81963], [-117.01383, 32.81972], [-117.01365, 32.81978], [-117.01341, 32.81982], [-117.01323, 32.81983], [-117.01299, 32.8198], [-117.01277, 32.81972], [-117.0119, 32.81929], [-117.01168, 32.81914], [-117.01156, 32.81899], [-117.01147, 32.81885], [-117.01119, 32.81801], [-117.01113, 32.81792], [-117.01103, 32.81785], [-117.0109, 32.81781], [-117.01075, 32.81782], [-117.01063, 32.81786], [-117.01052, 32.81797], [-117.01048, 32.81805], [-117.01047, 32.81813], [-117.01058, 32.81855], [-117.01023, 32.81751], [-117.00997, 32.81563], [-117.01204, 32.81698], [-117.01391, 32.81818], [-117.0198, 32.8119], [-117.01979, 32.81188], [-117.01937, 32.81159], [-117.01979, 32.81115], [-117.02118, 32.8122], [-117.02174, 32.81214], [-117.02325, 32.81054], [-117.02339, 32.8101], [-117.02316, 32.80969], [-117.02272, 32.80941], [-117.02259, 32.8095], [-117.02245, 32.80957], [-117.02229, 32.80961], [-117.02212, 32.80963], [-117.02193, 32.80962], [-117.02176, 32.80957], [-117.02161, 32.8095], [-117.0215, 32.80942], [-117.0216, 32.80933], [-117.0219, 32.80952], [-117.02312, 32.80816], [-117.02571, 32.80819], [-117.02706, 32.80763], [-117.02759, 32.80851], [-117.02839, 32.80817], [-117.02788, 32.80729], [-117.02849, 32.80704], [-117.02918, 32.80557], [-117.0298, 32.80447], [-117.0313, 32.80375], [-117.03165, 32.80305], [-117.0317, 32.80307], [-117.03622, 32.80401], [-117.03728, 32.80422], [-117.03718, 32.80461], [-117.03774, 32.80471], [-117.0377, 32.80494], [-117.03767, 32.80517], [-117.03767, 32.8054], [-117.03771, 32.80568], [-117.03778, 32.80594], [-117.03785, 32.80614], [-117.03795, 32.80634], [-117.03809, 32.80655], [-117.03832, 32.80684], [-117.03857, 32.80707], [-117.03903, 32.8074], [-117.0394, 32.80757], [-117.03925, 32.80783], [-117.04019, 32.80836], [-117.03971, 32.80914], [-117.03963, 32.80933], [-117.0396, 32.80953], [-117.03959, 32.80986], [-117.03983, 32.81006], [-117.04008, 32.81009], [-117.04005, 32.81052], [-117.04018, 32.81053], [-117.04039, 32.81104], [-117.04042, 32.81119], [-117.04041, 32.81136], [-117.04046, 32.81152], [-117.04087, 32.81226], [-117.04123, 32.81262], [-117.04166, 32.81316], [-117.0432, 32.81475], [-117.04291, 32.8147], [-117.04273, 32.81537], [-117.04315, 32.81545], [-117.0436, 32.81548], [-117.04419, 32.81549], [-117.04512, 32.8158], [-117.04555, 32.8159], [-117.04626, 32.81855]]]]} | Open Access 1 | 1152 | Mission Trails Regional Park | 29248 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.mtrp.org/ | San Diego 4 | 1520.459 | Mission Trails RP | 0 | Local Park 2 | 4 |
7 | 7 | 6 | {"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 | 28 | Richard Vessey Park | 24328 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 0.46 | Richard Vessey Park | 0 | Local Park 2 | 4 | |
9 | 9 | 8 | {"type": "Polygon", "coordinates": [[[-119.48323, 34.37952], [-119.48284, 34.37978], [-119.48215, 34.37935], [-119.48075, 34.37775], [-119.4785, 34.37584], [-119.47796, 34.37557], [-119.47746, 34.37548], [-119.47737, 34.37524], [-119.47812, 34.37527], [-119.47861, 34.37543], [-119.47887, 34.37564], [-119.47904, 34.37573], [-119.47969, 34.37544], [-119.48031, 34.37629], [-119.48123, 34.37728], [-119.48177, 34.37797], [-119.48233, 34.37854], [-119.48323, 34.37952]]]} | Open Access 1 | 36 | Rincon Beach Park | 24367 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 11.623 | Rincon Beach Park | 0 | Local Park 2 | 4 | |
12 | 12 | 11 | {"type": "Polygon", "coordinates": [[[-120.70087, 35.73565], [-120.70026, 35.73762], [-120.70033, 35.73765], [-120.69995, 35.73853], [-120.69975, 35.73891], [-120.69913, 35.73992], [-120.6988, 35.73992], [-120.70087, 35.73565]]]} | Open Access 1 | 48 | Rios Caledonia Adobe | 24392 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 3.26 | Rios Caledonia Adobe | None 5 | |||
24 | 24 | 23 | {"type": "Polygon", "coordinates": [[[-118.15573, 34.02499], [-118.1555, 34.02576], [-118.15546, 34.0258], [-118.15538, 34.02582], [-118.15475, 34.02568], [-118.15469, 34.02564], [-118.15468, 34.02558], [-118.1549, 34.02485], [-118.15494, 34.02481], [-118.15501, 34.02479], [-118.15565, 34.02492], [-118.1557, 34.02495], [-118.15573, 34.02499]]]} | Open Access 1 | 62 | Atlantic Avenue Park | 15674 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 1.951 | Atlantic Avenue Park | 0 | Local Park 2 | 4 | |
31 | 31 | 30 | {"type": "Polygon", "coordinates": [[[-120.44007, 34.65751], [-120.44003, 34.66064], [-120.4377, 34.66062], [-120.43735, 34.65839], [-120.43399, 34.65557], [-120.43409, 34.64948], [-120.43349, 34.64835], [-120.43323, 34.648], [-120.4329, 34.64769], [-120.43272, 34.64755], [-120.43252, 34.64742], [-120.43202, 34.64716], [-120.43205, 34.64698], [-120.43156, 34.64672], [-120.4313, 34.64654], [-120.43107, 34.64633], [-120.43086, 34.64611], [-120.43007, 34.64516], [-120.42988, 34.64496], [-120.42986, 34.6449], [-120.42988, 34.64483], [-120.43012, 34.64467], [-120.43121, 34.64405], [-120.43128, 34.64412], [-120.43217, 34.6436], [-120.43226, 34.6436], [-120.43589, 34.64992], [-120.4396, 34.65676], [-120.44007, 34.65751]]]} | Open Access 1 | 80 | River Park | 24416 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 123.418 | River Park | 0 | Local Park 2 | 4 | |
42 | 42 | 41 | {"type": "Polygon", "coordinates": [[[-121.8696, 36.54123], [-121.86858, 36.54357], [-121.8688, 36.54399], [-121.86843, 36.54483], [-121.86836, 36.54672], [-121.86702, 36.54676], [-121.86669, 36.54657], [-121.86686, 36.54615], [-121.86861, 36.54212], [-121.86807, 36.5408], [-121.86878, 36.54061], [-121.8696, 36.54123]]]} | Open Access 1 | 97 | Roach Canyon Park | 24474 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 15.0 | Roach Canyon Park | 0 | Local Park 2 | 4 | |
128 | 128 | 127 | {"type": "Polygon", "coordinates": [[[-120.6997, 35.75055], [-120.69948, 35.75185], [-120.69912, 35.7518], [-120.6989, 35.75166], [-120.69837, 35.75161], [-120.69849, 35.75083], [-120.69876, 35.75085], [-120.69881, 35.7505], [-120.6997, 35.75055]]]} | Open Access 1 | 394 | San Miguel Community Park | 24955 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 3.196 | San Miguel Community Park | 0 | Local Park 2 | 4 | |
133 | 133 | 132 | {"type": "Polygon", "coordinates": [[[-119.74246, 34.44054], [-119.74244, 34.44072], [-119.74241, 34.44073], [-119.74215, 34.44091], [-119.74194, 34.44113], [-119.74168, 34.44129], [-119.74157, 34.44128], [-119.7414, 34.44128], [-119.74181, 34.44101], [-119.74204, 34.44079], [-119.74227, 34.44062], [-119.74234, 34.44054], [-119.74246, 34.44054]]]} | Unknown Access 4 | 414 | San Roque Creek | 24990 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.477 | San Roque Creek | 0 | Local Other or Unknown 14 | 4 | |
142 | 142 | 141 | {"type": "MultiPolygon", "coordinates": [[[[-120.6245, 35.11002], [-120.62419, 35.11012], [-120.62312, 35.1078], [-120.62286, 35.1073], [-120.62239, 35.10649], [-120.62277, 35.10634], [-120.6229, 35.10654], [-120.62301, 35.10675], [-120.6245, 35.11002]]], [[[-120.62952, 35.12079], [-120.6292, 35.12089], [-120.62657, 35.11519], [-120.62426, 35.11027], [-120.62457, 35.11017], [-120.62699, 35.11532], [-120.62952, 35.12079]]]]} | Open Access 1 | 446 | Sand and Surf County Park | 25009 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 13.006 | Sand and Surf County Park | 0 | Local Park 2 | 4 | |
144 | 144 | 143 | {"type": "Polygon", "coordinates": [[[-121.97587, 36.97007], [-121.9757, 36.97077], [-121.97566, 36.97132], [-121.97552, 36.9716], [-121.97389, 36.9716], [-121.97365, 36.97101], [-121.9733, 36.97101], [-121.97331, 36.97038], [-121.97438, 36.97017], [-121.97457, 36.97011], [-121.97587, 36.97007]]]} | Open Access 1 | 363 | Brommer Park | 16416 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 7.663 | Brommer Park | 0 | Local Park 2 | 4 | |
160 | 160 | 159 | {"type": "Polygon", "coordinates": [[[-120.6906, 35.75373], [-120.68985, 35.75372], [-120.68986, 35.75288], [-120.69045, 35.75267], [-120.6906, 35.75373]]]} | Open Access 1 | 409 | San Miguel Staging Area Park | 24961 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 1.605 | San Miguel Staging Area Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);