superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
202 rows where LAYER = 5 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY 17
- University of California 50
- Other State 26
- California Department of Transportation 24
- California Department of Water Resources 18
- Santa Monica Mountains Conservancy 16
- California State Lands Commission 10
- California Department of Forestry and Fire Protection 10
- California Wildlife Conservation Board 6
- California State Coastal Conservancy 5
- Coachella Valley Mountains Conservancy 4
- California Department of General Services 3
- California Department of Veterans Affairs 2
- Napa Valley College 2
- San Diego State University 2
- California State University 2
- California State University Sonoma 1
- California Tahoe Conservancy 1
ACCESS_TYP 4
- Open Access 85
- Restricted Access 48
- No Public Access 29
- Unknown Access 20
MNG_AG_TYP 1
- State Agency 182
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7801 | 7801 | 7800 | {"type": "Polygon", "coordinates": [[[-123.62865, 40.48836], [-123.62865, 40.48852], [-123.62837, 40.48861], [-123.62769, 40.48868], [-123.62714, 40.48877], [-123.62629, 40.48945], [-123.62628, 40.48822], [-123.62671, 40.48819], [-123.62692, 40.48819], [-123.62683, 40.48844], [-123.62684, 40.48846], [-123.62714, 40.48835], [-123.62753, 40.4883], [-123.62865, 40.48836]]]} | Open Access 1 | Other State 18 | 23254 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 2.877 | Other State 18 | |||
6113 | 6113 | 6112 | {"type": "Polygon", "coordinates": [[[-120.50114, 37.29562], [-120.50068, 37.29642], [-120.49943, 37.29596], [-120.49989, 37.29516], [-120.50114, 37.29562]]]} | Open Access 1 | Leonard Park | 21174 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 2.938 | Leonard Park | |||
7811 | 7811 | 7810 | {"type": "Polygon", "coordinates": [[[-123.84468, 40.46319], [-123.84303, 40.46319], [-123.84302, 40.4623], [-123.8433, 40.46219], [-123.84379, 40.4621], [-123.84428, 40.46233], [-123.8444, 40.46257], [-123.84445, 40.46277], [-123.84468, 40.46319]]]} | Open Access 1 | Other State 5 | 23265 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 3.303 | Other State 5 | |||
6542 | 6542 | 6541 | {"type": "Polygon", "coordinates": [[[-120.42474, 37.3656], [-120.42449, 37.36582], [-120.42441, 37.36581], [-120.42305, 37.36682], [-120.42243, 37.36627], [-120.42297, 37.36589], [-120.42245, 37.36543], [-120.4224, 37.36528], [-120.42241, 37.36525], [-120.42279, 37.36529], [-120.42327, 37.36541], [-120.42393, 37.3657], [-120.42422, 37.36574], [-120.42447, 37.3657], [-120.42474, 37.3656]]]} | Open Access 1 | Carol Tomlinson-Keasey Quad | https://www.ucmerced.edu/catcams | 33646 | 217 | University of California 51 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 3.78 | Carol Tomlinson-Keasey Quad | |
7830 | 7830 | 7829 | {"type": "Polygon", "coordinates": [[[-122.38409, 37.66344], [-122.38388, 37.66372], [-122.38364, 37.66373], [-122.38343, 37.66386], [-122.38284, 37.66322], [-122.38239, 37.66304], [-122.38262, 37.6625], [-122.38292, 37.66223], [-122.38313, 37.66237], [-122.38329, 37.66223], [-122.38382, 37.66262], [-122.38391, 37.66314], [-122.38409, 37.66344]]]} | Open Access 1 | Oyster Point Park | 23284 | 212 | California Wildlife Conservation Board 747 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 3.878 | Oyster Point Park | ||
3451 | 3451 | 3450 | {"type": "Polygon", "coordinates": [[[-122.21602, 37.02342], [-122.21509, 37.02378], [-122.2149, 37.02335], [-122.21472, 37.02237], [-122.21561, 37.02182], [-122.21602, 37.02342]]]} | Open Access 1 | Davenport Landing Beach | 17938 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 3.923 | Davenport Landing Beach | |||
7805 | 7805 | 7804 | {"type": "Polygon", "coordinates": [[[-123.84302, 40.46142], [-123.84302, 40.4623], [-123.84241, 40.46266], [-123.84217, 40.46286], [-123.84184, 40.46272], [-123.84171, 40.46257], [-123.84194, 40.46247], [-123.84193, 40.46233], [-123.84169, 40.46226], [-123.84173, 40.46216], [-123.84179, 40.46206], [-123.84179, 40.46192], [-123.84166, 40.46178], [-123.84133, 40.46157], [-123.84123, 40.46146], [-123.84168, 40.46116], [-123.8422, 40.4614], [-123.84302, 40.46142]]]} | Open Access 1 | Other State 37 | 23260 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 4.071 | Other State 37 | |||
10503 | 10503 | 10502 | {"type": "Polygon", "coordinates": [[[-120.46492, 37.66834], [-120.46421, 37.66774], [-120.4619, 37.66728], [-120.4618, 37.66725], [-120.46168, 37.66715], [-120.46163, 37.66704], [-120.46164, 37.66696], [-120.4617, 37.66675], [-120.46266, 37.66675], [-120.4649, 37.66747], [-120.46492, 37.66834]]]} | Open Access 1 | Tuolumne River Restoration Center | 26580 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 4.72 | Tuolumne River Restoration Ctr. | |||
3572 | 3572 | 3571 | {"type": "Polygon", "coordinates": [[[-122.22476, 38.22438], [-122.22475, 38.22525], [-122.2237, 38.22526], [-122.2237, 38.22472], [-122.22307, 38.22433], [-122.2222, 38.22245], [-122.22221, 38.22188], [-122.22324, 38.22127], [-122.22322, 38.22152], [-122.22316, 38.22152], [-122.22316, 38.22161], [-122.22261, 38.22185], [-122.22242, 38.2221], [-122.22241, 38.22244], [-122.22307, 38.22385], [-122.22384, 38.22431], [-122.22415, 38.22431], [-122.22452, 38.22437], [-122.22476, 38.22438]]]} | No Public Access 3 | Department Of Water Resourses | 18099 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 4.799 | Department Of Water Resourses | ||
4420 | 4420 | 4419 | {"type": "Polygon", "coordinates": [[[-119.71275, 36.9916], [-119.71191, 36.99249], [-119.7112, 36.99207], [-119.71091, 36.99196], [-119.71085, 36.99186], [-119.71077, 36.99183], [-119.71053, 36.99176], [-119.71044, 36.99178], [-119.71062, 36.99139], [-119.71109, 36.99063], [-119.71154, 36.99058], [-119.71275, 36.9916]]]} | Open Access 1 | Friant Cove | 19113 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 5.884 | Friant Cove | |||
8436 | 8436 | 8435 | {"type": "Polygon", "coordinates": [[[-122.1072, 38.49368], [-122.10672, 38.49336], [-122.10649, 38.49316], [-122.10637, 38.49012], [-122.10659, 38.49004], [-122.10674, 38.48989], [-122.10698, 38.4896], [-122.10718, 38.48928], [-122.1072, 38.49368]]]} | Restricted Access 2 | Quail Ridge | 24047 | 217 | University of California 51 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 6.615 | Quail Ridge | 1991 | |
6484 | 6484 | 6483 | {"type": "Polygon", "coordinates": [[[-120.42797, 37.3633], [-120.42768, 37.36342], [-120.42686, 37.36405], [-120.426, 37.36465], [-120.42585, 37.36455], [-120.42573, 37.36444], [-120.42547, 37.36426], [-120.42491, 37.36408], [-120.42488, 37.36386], [-120.42505, 37.3635], [-120.42556, 37.36309], [-120.42571, 37.36305], [-120.42593, 37.36306], [-120.42633, 37.36292], [-120.42657, 37.36301], [-120.42687, 37.36309], [-120.42717, 37.36303], [-120.42733, 37.36312], [-120.42767, 37.36302], [-120.42786, 37.363], [-120.42794, 37.36314], [-120.42797, 37.3633]]]} | Open Access 1 | Kelley Grove | 33645 | 217 | University of California 51 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 7.21 | Kelley Grove | ||
12104 | 12104 | 12103 | {"type": "Polygon", "coordinates": [[[-118.65109, 34.03761], [-118.65102, 34.03789], [-118.65008, 34.03771], [-118.64961, 34.03764], [-118.64922, 34.03765], [-118.64889, 34.0377], [-118.64882, 34.03758], [-118.64861, 34.03759], [-118.64839, 34.0377], [-118.64783, 34.03813], [-118.64748, 34.03823], [-118.64702, 34.03832], [-118.64694, 34.0382], [-118.64591, 34.03819], [-118.64439, 34.03805], [-118.64366, 34.03796], [-118.64298, 34.03782], [-118.64224, 34.03772], [-118.63951, 34.03714], [-118.6382, 34.03681], [-118.63828, 34.0365], [-118.63964, 34.03684], [-118.64039, 34.03708], [-118.64171, 34.03736], [-118.64261, 34.03748], [-118.64325, 34.03763], [-118.64555, 34.03791], [-118.64655, 34.03796], [-118.64744, 34.03791], [-118.64803, 34.03772], [-118.64845, 34.03742], [-118.64906, 34.0373], [-118.64975, 34.03736], [-118.65109, 34.03761]]]} | Open Access 1 | La Costa Beach | 29045 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 9.124 | La Costa Beach | |||
1175 | 1175 | 1174 | {"type": "Polygon", "coordinates": [[[-117.00555, 32.56025], [-117.00555, 32.56116], [-117.00126, 32.56109], [-117.00126, 32.56018], [-117.00555, 32.56025]]]} | Unknown Access 4 | Anderprizes Mitigation Site | 15474 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 10.022 | Anderprizes Mitigation Site | ||
1097 | 1097 | 1096 | {"type": "Polygon", "coordinates": [[[-117.97916, 33.9094], [-117.97859, 33.91001], [-117.97804, 33.91048], [-117.9775, 33.91087], [-117.97591, 33.91182], [-117.97546, 33.91214], [-117.96943, 33.91722], [-117.96887, 33.91721], [-117.97303, 33.91372], [-117.97303, 33.9137], [-117.97384, 33.91309], [-117.9751, 33.91199], [-117.97561, 33.91162], [-117.97741, 33.91054], [-117.97802, 33.91008], [-117.97805, 33.91001], [-117.97841, 33.90968], [-117.9788, 33.90926], [-117.97904, 33.90937], [-117.97916, 33.9094]]]} | Open Access 1 | Coyote Creek Bikeway | http://www.lhcm.org/386/Bikeways | 32861 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 11.01 | Coyote Creek Bikeway | 2011 |
14660 | 14660 | 14659 | {"type": "Polygon", "coordinates": [[[-118.42051, 34.12846], [-118.4152, 34.12824], [-118.41504, 34.12722], [-118.41468, 34.12719], [-118.41468, 34.12714], [-118.41474, 34.12701], [-118.41491, 34.12675], [-118.41499, 34.12667], [-118.41509, 34.1266], [-118.41521, 34.12656], [-118.41534, 34.12654], [-118.41546, 34.12656], [-118.41614, 34.12678], [-118.41626, 34.12687], [-118.4164, 34.12711], [-118.4165, 34.1272], [-118.41662, 34.12728], [-118.41675, 34.12733], [-118.41698, 34.12736], [-118.41804, 34.12725], [-118.41814, 34.12728], [-118.41837, 34.1274], [-118.41913, 34.12761], [-118.41941, 34.12776], [-118.42051, 34.12846]]]} | Open Access 1 | Beverly Park Estates Open Space | 16057 | 215 | Santa Monica Mountains Conservancy 303 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 13.744 | Beverly Park Estates OS | ||
13249 | 13249 | 13248 | {"type": "Polygon", "coordinates": [[[-124.11238, 40.99977], [-124.11173, 41.00363], [-124.1111, 41.00601], [-124.11088, 41.00673], [-124.10992, 41.00671], [-124.11008, 41.00583], [-124.11159, 41.00045], [-124.11204, 40.99978], [-124.11238, 40.99977]]]} | Unknown Access 4 | Clam Beach Ponds | 30554 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 14.52 | Clam Beach Ponds | |||
7809 | 7809 | 7808 | {"type": "Polygon", "coordinates": [[[-123.83901, 40.46367], [-123.839, 40.46751], [-123.83762, 40.46759], [-123.83761, 40.46748], [-123.83744, 40.46699], [-123.83691, 40.46742], [-123.83606, 40.46793], [-123.83527, 40.46801], [-123.83421, 40.46791], [-123.83495, 40.46784], [-123.83542, 40.46767], [-123.83587, 40.46725], [-123.83707, 40.46639], [-123.83754, 40.46561], [-123.8379, 40.46507], [-123.83813, 40.46474], [-123.83856, 40.46406], [-123.83884, 40.46367], [-123.83901, 40.46367]]]} | Open Access 1 | Other State 4 | 23263 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 14.858 | Other State 4 | |||
13880 | 13880 | 13879 | {"type": "Polygon", "coordinates": [[[-117.23111, 32.79319], [-117.23107, 32.79326], [-117.23078, 32.7932], [-117.2303, 32.79353], [-117.2303, 32.79356], [-117.23015, 32.79366], [-117.23009, 32.79379], [-117.23005, 32.79383], [-117.23004, 32.79417], [-117.23009, 32.79439], [-117.2301, 32.79484], [-117.23047, 32.79495], [-117.23076, 32.79592], [-117.23007, 32.79609], [-117.2299, 32.79556], [-117.22808, 32.79595], [-117.22756, 32.79426], [-117.22918, 32.79378], [-117.2293, 32.79327], [-117.23017, 32.79269], [-117.23073, 32.79196], [-117.23111, 32.79319]]]} | Restricted Access 2 | Kendall Frost Mission Bay Marsh Reserve | https://ucnrs.org/reserves/kendall-frost-mission-bay-marsh-reserve/ | 33187 | 217 | University of California 51 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 16.568 | Kendall Frost Mission Bay Marsh Reserve | |
7802 | 7802 | 7801 | {"type": "Polygon", "coordinates": [[[-121.0547, 39.80881], [-121.05325, 39.80955], [-121.05329, 39.80949], [-121.04991, 39.8062], [-121.05152, 39.80559], [-121.0547, 39.80881]]]} | Open Access 1 | Other State 23 | 23256 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 16.582 | Other State 23 |
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]);