units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
397 rows where COUNTY = 14 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV, GAP_STS
MNG_AGENCY >30
- Monterey, County of 46
- Salinas, City of 45
- Seaside, City of 37
- Monterey, City of 32
- Monterey Peninsula Regional Park District 25
- California Department of Parks and Recreation 23
- Big Sur Land Trust 21
- Greenfield, City of 19
- Pacific Grove, City of 17
- Marina, City of 11
- Soledad, City of 11
- Del Monte Forest Foundation 10
- Gonzales, City of 9
- Elkhorn Slough Foundation 9
- California Department of Fish and Wildlife 8
- Other State 8
- King City, City of 8
- Carmel-by-the-Sea, City of 6
- North County Recreation and Park District 6
- United States Department of Defense 4
- United States Bureau of Land Management 3
- United States Forest Service 3
- University of California 3
- California State Lands Commission 2
- Santa Lucia Conservancy 2
- United States Coast Guard 2
- Sand City, City of 2
- Del Rey Oaks, City of 2
- Moss Landing Harbor District 2
- Monterey County Water Resources Agency 2
- …
DES_TP >30
- Local Park 166
- Local Other or Unknown 51
- Private Conservation 39
- Local Recreation Area 33
- State Park 17
- State Conservation Area 14
- Local Conservation Area 10
- Local Historic or Cultural Area 8
- State Other or Unknown 7
- National Monument or Landmark 5
- Private Other or Unknown 5
- State Historic or Cultural Area 3
- Recreation Management Area 2
- Private Recreation or Education 2
- National Public Lands 1
- National Forest 1
- National Park 1
- None 1
- State Resource Management Area 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- Private Agricultural 1
- None 1
- …
MNG_AG_TYP 12
ACCESS_TYP 4
- Open Access 327
- Restricted Access 39
- No Public Access 23
- Unknown Access 8
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13346 | 13346 | 13345 | {"type": "Polygon", "coordinates": [[[-121.82508, 36.6128], [-121.82474, 36.61287], [-121.82474, 36.61287], [-121.82474, 36.61284], [-121.82507, 36.61277], [-121.82508, 36.6128]]]} | Open Access 1 | 35425 | Seaside holding 7 | 25263 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.023 | Seaside holding 7 | 0 | Local Other or Unknown 14 | 4 | |
679 | 679 | 678 | {"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 | 3434 | 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 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 0.044 | Carmel River Lagoon & Wetlands Natural Preserve | 0 | Local Conservation Area 4 | 2 | |
13215 | 13215 | 13214 | {"type": "Polygon", "coordinates": [[[-121.8525, 36.60939], [-121.85222, 36.60957], [-121.85222, 36.60957], [-121.85222, 36.60939], [-121.8525, 36.60939]]]} | Open Access 1 | 35253 | Seaside holding 5 | 25261 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.062 | Seaside holding 5 | 0 | Local Other or Unknown 14 | 4 | |
2740 | 2740 | 2739 | {"type": "Polygon", "coordinates": [[[-121.82582, 36.6117], [-121.8252, 36.61169], [-121.8252, 36.61165], [-121.82581, 36.61166], [-121.82582, 36.6117]]]} | Open Access 1 | 18402 | park access 2 | 23424 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.063 | park access 2 | None 226 | |||
280 | 280 | 279 | {"type": "Polygon", "coordinates": [[[-121.85612, 36.61199], [-121.8561, 36.6123], [-121.85602, 36.6123], [-121.85604, 36.61196], [-121.85607, 36.61194], [-121.85612, 36.61199]]]} | Restricted Access 2 | 956 | South Monterey Dunes | 25664 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.07 | South Monterey Dunes | None 30 | |||
5720 | 5720 | 5719 | {"type": "Polygon", "coordinates": [[[-121.25117, 36.31304], [-121.25116, 36.31307], [-121.25106, 36.31311], [-121.25103, 36.3131], [-121.25093, 36.31297], [-121.25094, 36.31294], [-121.25104, 36.3129], [-121.25117, 36.31304]]]} | Open Access 1 | 47107 | Lexington Park | 30774 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.07 | Lexington Park | 0 | Local Park 2 | 4 | |
7910 | 7910 | 7909 | {"type": "Polygon", "coordinates": [[[-121.6483, 36.67085], [-121.648, 36.67068], [-121.648, 36.67068], [-121.64825, 36.6706], [-121.6483, 36.67085]]]} | Open Access 1 | 10245 | Cornell Park | 17639 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 0.084 | Cornell Park | 0 | Local Park 2 | 4 | |
13280 | 13280 | 13279 | {"type": "Polygon", "coordinates": [[[-121.83311, 36.6034], [-121.83311, 36.6036], [-121.83284, 36.6036], [-121.83284, 36.60357], [-121.83291, 36.60355], [-121.83295, 36.6035], [-121.83293, 36.60345], [-121.83285, 36.6034], [-121.83311, 36.6034]]]} | Open Access 1 | 35334 | Seaside holding 15 | 25257 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.102 | Seaside holding 15 | 0 | Local Other or Unknown 14 | 4 | |
5914 | 5914 | 5913 | {"type": "Polygon", "coordinates": [[[-121.92311, 36.55441], [-121.92311, 36.55455], [-121.92277, 36.55455], [-121.92277, 36.55441], [-121.92311, 36.55441]]]} | Open Access 1 | 48679 | Picadilly Park | 33420 | 1046 | Carmel-by-the-Sea, City of 535 | City 2 | City Agency 2 | http://www.carmelcalifornia.com/ | City 2 | 1046 | Carmel-by-the-Sea, City of 528 | City 2 | City Agency 2 | Monterey 14 | 0.116 | Picadilly Park | 0 | Local Park 2 | 4 | |
13214 | 13214 | 13213 | {"type": "Polygon", "coordinates": [[[-121.85017, 36.60253], [-121.84983, 36.60253], [-121.84975, 36.60252], [-121.85014, 36.60232], [-121.85018, 36.60235], [-121.85017, 36.60253]]]} | Open Access 1 | 35252 | Seaside holding 8 | 25264 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.116 | Seaside holding 8 | 0 | Local Other or Unknown 14 | 4 | |
4641 | 4641 | 4640 | {"type": "Polygon", "coordinates": [[[-121.75081, 36.90111], [-121.75066, 36.90121], [-121.75048, 36.90119], [-121.75054, 36.90103], [-121.75057, 36.90098], [-121.75061, 36.90096], [-121.75067, 36.90097], [-121.75081, 36.90111]]]} | Open Access 1 | 36490 | Unnamed site - Monterey, County of | 28641 | 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 | 0.126 | 0 | Local Other or Unknown 14 | 4 | ||
442 | 442 | 441 | {"type": "Polygon", "coordinates": [[[-121.93363, 36.54329], [-121.93317, 36.54325], [-121.93307, 36.54313], [-121.93323, 36.54306], [-121.93329, 36.54312], [-121.93337, 36.54317], [-121.93363, 36.54329]]]} | Restricted Access 2 | 1381 | Tor House | 26411 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 0.129 | Tor House | 0 | Private Conservation 16 | 2 | |
2859 | 2859 | 2858 | {"type": "Polygon", "coordinates": [[[-121.24939, 36.3241], [-121.24918, 36.32421], [-121.24905, 36.32407], [-121.24905, 36.32404], [-121.24907, 36.324], [-121.24924, 36.32392], [-121.24939, 36.3241]]]} | Open Access 1 | 18833 | Primavera Park | 24000 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.14 | Primavera Park | 0 | Local Park 2 | 4 | |
3762 | 3762 | 3761 | {"type": "Polygon", "coordinates": [[[-121.23523, 36.33374], [-121.23509, 36.33358], [-121.235, 36.33363], [-121.23489, 36.3335], [-121.23508, 36.33339], [-121.2353, 36.33364], [-121.2353, 36.33369], [-121.23523, 36.33374]]]} | Open Access 1 | 34924 | Barolo Circle Park | 30772 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.152 | Barolo Circle Park | 0 | Local Park 2 | 4 | |
13263 | 13263 | 13262 | {"type": "Polygon", "coordinates": [[[-121.82474, 36.61274], [-121.82474, 36.61301], [-121.82449, 36.613], [-121.82449, 36.61273], [-121.82474, 36.61274]]]} | Open Access 1 | 35311 | Seaside holding 13 | 25255 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.167 | Seaside holding 13 | 0 | Local Other or Unknown 14 | 4 | |
10256 | 10256 | 10255 | {"type": "Polygon", "coordinates": [[[-121.86014, 36.60946], [-121.85999, 36.60944], [-121.85981, 36.60945], [-121.85968, 36.60949], [-121.85951, 36.60957], [-121.85989, 36.6092], [-121.86014, 36.60946]]]} | Open Access 1 | 17950 | Monterey State Beach | 22432 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | http://www.parks.ca.gov/?page_id=576 | Monterey 14 | 0.171 | Monterey SB | 1960 | None 893 | |
14732 | 14732 | 14731 | {"type": "Polygon", "coordinates": [[[-121.12757, 36.21951], [-121.12715, 36.21972], [-121.12706, 36.21957], [-121.12747, 36.21935], [-121.1275, 36.2194], [-121.1275, 36.21944], [-121.12752, 36.21948], [-121.12757, 36.21951]]]} | Open Access 1 | 45097 | King Street Pocket Park | 28031 | 1152 | King City, City of 481 | City 2 | City Agency 2 | http://www.kingcity.com/ | City 2 | 1152 | King City, City of 473 | City 2 | City Agency 2 | http://www.kingcity.com/city-departments/recreation-department/parks/ | Monterey 14 | 0.204 | King Street PP | 0 | Local Park 2 | 4 |
4682 | 4682 | 4681 | {"type": "Polygon", "coordinates": [[[-121.68569, 36.44484], [-121.68518, 36.44573], [-121.68502, 36.44565], [-121.68518, 36.44552], [-121.68529, 36.44539], [-121.68537, 36.44527], [-121.68545, 36.44508], [-121.6855, 36.44499], [-121.68558, 36.44491], [-121.68569, 36.44484]]]} | Open Access 1 | 43073 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 0.221 | 0 | State Other or Unknown 104 | 4 | |||
16464 | 16464 | 16463 | {"type": "Polygon", "coordinates": [[[-121.89454, 36.5976], [-121.89449, 36.59761], [-121.89418, 36.59759], [-121.89428, 36.59721], [-121.89431, 36.59721], [-121.89457, 36.59751], [-121.89457, 36.59756], [-121.89454, 36.5976]]]} | Open Access 1 | 17961 | Monterey State Historic Park | 22433 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 0.229 | Monterey SHP | 1916 | None 1406 | ||
13926 | 13926 | 13925 | {"type": "Polygon", "coordinates": [[[-121.64339, 36.88847], [-121.64319, 36.88849], [-121.64313, 36.88847], [-121.6431, 36.88843], [-121.64306, 36.88816], [-121.64333, 36.88813], [-121.64339, 36.88847]]]} | Open Access 1 | 36553 | Aromas Community Park | 28587 | 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 | 0.23 | Aromas Community 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]);