superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
872 rows where MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
MNG_AGENCY 16
- California Department of Fish and Wildlife 267
- California Department of Parks and Recreation 160
- University of California 34
- Other State 24
- California Department of Transportation 14
- Santa Monica Mountains Conservancy 11
- California Department of Water Resources 11
- California State Lands Commission 6
- California Wildlife Conservation Board 5
- California Department of Forestry and Fire Protection 4
- California Department of General Services 3
- Coachella Valley Mountains Conservancy 3
- San Diego State University 2
- California State University 2
- California State Coastal Conservancy 2
- California Tahoe Conservancy 1
ACCESS_TYP 4
- Open Access 394
- Restricted Access 96
- No Public Access 47
- Unknown Access 12
MNG_AG_TYP 1
- State Agency · 549 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
7425 | 7425 | 7424 | {"type": "Polygon", "coordinates": [[[-122.51401, 38.08952], [-122.50961, 38.09217], [-122.5071, 38.09337], [-122.50547, 38.08821], [-122.50462, 38.08689], [-122.50475, 38.08671], [-122.50434, 38.08636], [-122.50461, 38.086], [-122.50537, 38.08538], [-122.50578, 38.08514], [-122.50622, 38.08495], [-122.50736, 38.08466], [-122.50838, 38.08465], [-122.50977, 38.08483], [-122.5107, 38.08507], [-122.51158, 38.08542], [-122.51221, 38.08579], [-122.51271, 38.0862], [-122.51324, 38.08682], [-122.51374, 38.08778], [-122.51391, 38.08855], [-122.51402, 38.08937], [-122.51401, 38.08952]]]} | Open Access 1 | North Antenna Field | 22804 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 128.204 | North Antenna Field | ||
7622 | 7622 | 7621 | {"type": "MultiPolygon", "coordinates": [[[[-121.99494, 36.98782], [-121.99458, 36.98781], [-121.99399, 36.98777], [-121.99412, 36.98737], [-121.99417, 36.98738], [-121.99467, 36.98768], [-121.99482, 36.98772], [-121.99494, 36.98782]]], [[[-121.99677, 36.98791], [-121.99677, 36.98791], [-121.99571, 36.98786], [-121.99615, 36.98769], [-121.99642, 36.98771], [-121.99677, 36.98791]]], [[[-122.01191, 36.97056], [-122.01184, 36.97079], [-122.01121, 36.97116], [-122.0112, 36.97122], [-122.01103, 36.97109], [-122.01178, 36.97054], [-122.0118, 36.97027], [-122.01191, 36.96996], [-122.01196, 36.97022], [-122.01191, 36.97056]]]]} | Open Access 1 | Ocean View Park | 23056 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 1.415 | Ocean View Park | |||
7706 | 7706 | 7705 | {"type": "Polygon", "coordinates": [[[-121.47811, 37.34772], [-121.47387, 37.3477], [-121.46884, 37.34757], [-121.46894, 37.33318], [-121.46053, 37.33314], [-121.46051, 37.33308], [-121.4511, 37.33303], [-121.44221, 37.33311], [-121.44212, 37.3367], [-121.43286, 37.33679], [-121.43288, 37.3363], [-121.43285, 37.33628], [-121.43277, 37.33294], [-121.4237, 37.33291], [-121.42378, 37.32944], [-121.44188, 37.3294], [-121.44188, 37.32584], [-121.43282, 37.32592], [-121.43304, 37.31848], [-121.43306, 37.30399], [-121.44215, 37.30401], [-121.45398, 37.30406], [-121.46945, 37.3042], [-121.46949, 37.31146], [-121.47544, 37.3115], [-121.47528, 37.327], [-121.47514, 37.32718], [-121.4748, 37.3277], [-121.47471, 37.3279], [-121.4747, 37.32801], [-121.47473, 37.32924], [-121.47478, 37.3295], [-121.47473, 37.32952], [-121.47529, 37.33069], [-121.47621, 37.33255], [-121.47626, 37.33392], [-121.47643, 37.33555], [-121.47612, 37.33691], [-121.47647, 37.33844], [-121.477, 37.33945], [-121.47769, 37.3407], [-121.47786, 37.34295], [-121.47808, 37.34527], [-121.47767, 37.34679], [-121.47766, 37.34708], [-121.47811, 37.34772]]]} | Restricted Access 2 | San Antonio Valley | 24836 | 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 | 3259.446 | San Antonio Valley | ||
7708 | 7708 | 7707 | {"type": "MultiPolygon", "coordinates": [[[[-121.16883, 38.65782], [-121.16836, 38.65788], [-121.16795, 38.65796], [-121.1624, 38.65959], [-121.16182, 38.65971], [-121.16065, 38.65986], [-121.16031, 38.65992], [-121.15986, 38.66003], [-121.1592, 38.66024], [-121.15812, 38.66065], [-121.15819, 38.66028], [-121.15832, 38.65994], [-121.15854, 38.65957], [-121.15879, 38.65927], [-121.1591, 38.659], [-121.15945, 38.65877], [-121.15984, 38.65858], [-121.16031, 38.65842], [-121.1607, 38.65833], [-121.16104, 38.65829], [-121.16214, 38.65827], [-121.16277, 38.65822], [-121.1634, 38.65812], [-121.16389, 38.65802], [-121.16461, 38.65781], [-121.16519, 38.65759], [-121.16574, 38.65734], [-121.16634, 38.657], [-121.16673, 38.65684], [-121.1672, 38.6567], [-121.16753, 38.65664], [-121.1678, 38.65661], [-121.16833, 38.65659], [-121.1684, 38.65662], [-121.16854, 38.65713], [-121.16883, 38.65782]]], [[[-121.17581, 38.6616], [-121.17428, 38.66147], [-121.17177, 38.65885], [-121.17157, 38.65867], [-121.1714, 38.65854], [-121.17118, 38.65839], [-121.17093, 38.65825], [-121.17067, 38.65813], [-121.1704, 38.65803], [-121.16989, 38.6579], [-121.16954, 38.65784], [-121.16927, 38.65782], [-121.16894, 38.65702], [-121.16886, 38.65674], [-121.16884, 38.65663], [-121.16885, 38.65659], [-121.16892, 38.65655], [-121.1708, 38.65644], [-121.17123, 38.65639], [-121.17176, 38.65628], [-121.17197, 38.65661], [-121.17204, 38.65701], [-121.17178, 38.65704], [-121.17187, 38.65762], [-121.17193, 38.6577], [-121.17199, 38.65773], [-121.17206, 38.65774], [-121.17272, 38.65767], [-121.17294, 38.65768], [-121.1731, 38.65773], [-121.17393, 38.65813], [-121.17408, 38.65817], [-121.1742, 38.65817], [-121.17434, 38.65815], [-121.17525, 38.65776], [-121.17524, 38.65774], [-121.17491, 38.65778], [-121.17502, 38.65771], [-121.17522, 38.65753], [-121.17547, 38.65753], [-121.17523, 38.65863], [-121.17581, 38.6616]]], [[[-121.1775, 38.65766], [-121.17724, 38.65766], [-121.17681, 38.65767], [-121.17695, 38.6573], [-121.17699, 38.65723], [-121.17727, 38.6573], [-121.1775, 38.65766]]], [[[-121.18181, 38.6564], [-121.18133, 38.65641], [-121.18119, 38.65639], [-121.18154, 38.65764], [-121.17965, 38.65765], [-121.17951, 38.65699], [-121.17964, 38.65691], [-121.17978, 38.6568], [-121.17998, 38.65658], [-121.18023, 38.6566], [-121.18049, 38.65647], [-121.18085, 38.65634], [-121.18106, 38.65628], [-121.18174, 38.65614], [-121.18181, 38.6564]]], [[[-121.18376, 38.65361], [-121.18399, 38.65391], [-121.18416, 38.6543], [-121.18413, 38.65478], [-121.1838, 38.65551], [-121.18292, 38.65658], [-121.18294, 38.65671], [-121.18263, 38.65677], [-121.18258, 38.65676], [-121.18253, 38.65672], [-121.18241, 38.65632], [-121.18252, 38.6563], [-121.18297, 38.65581], [-121.18297, 38.65579], [-121.18327, 38.65543], [-121.18339, 38.65523], [-121.18347, 38.65505], [-121.18351, 38.65489], [-121.18353, 38.65459], [-121.18351, 38.65442], [-121.18347, 38.65426], [-121.18341, 38.65411], [-121.18332, 38.65395], [-121.18376, 38.65361]]]]} | No Public Access 3 | Willow Creek | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Willow-Creek-WA | 32350 | 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 | 78.152 | Willow Creek | |
7710 | 7710 | 7709 | {"type": "MultiPolygon", "coordinates": [[[[-121.43724, 38.17421], [-121.43683, 38.17423], [-121.43624, 38.17432], [-121.43479, 38.17447], [-121.43315, 38.1745], [-121.43247, 38.1745], [-121.43169, 38.17458], [-121.43139, 38.17465], [-121.4312, 38.17473], [-121.43115, 38.17481], [-121.43117, 38.1749], [-121.42737, 38.17498], [-121.42716, 38.17497], [-121.42709, 38.16865], [-121.42627, 38.16535], [-121.42637, 38.1653], [-121.42474, 38.16], [-121.42835, 38.15916], [-121.42996, 38.16576], [-121.43724, 38.17421]]], [[[-121.44896, 38.15733], [-121.44194, 38.15801], [-121.44077, 38.15809], [-121.43734, 38.14524], [-121.43752, 38.1452], [-121.43759, 38.14547], [-121.43773, 38.14546], [-121.4392, 38.15099], [-121.4482, 38.15074], [-121.44896, 38.15733]]]]} | Open Access 1 | Woodbridge Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Woodbridge-ER | 32351 | 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 | 349.62 | Woodbridge ER | 1986 |
7789 | 7789 | 7788 | {"type": "Polygon", "coordinates": [[[-117.0144, 32.5799], [-117.00992, 32.57971], [-117.00998, 32.57781], [-117.0099, 32.57209], [-117.01425, 32.57223], [-117.01413, 32.57247], [-117.01413, 32.57266], [-117.01421, 32.57544], [-117.01423, 32.5755], [-117.01432, 32.57559], [-117.0144, 32.5799]]]} | Open Access 1 | Otay Mesa North TransNet Mitigation | 23240 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 85.222 | Otay Mesa North TransNet Mitigation | ||
7798 | 7798 | 7797 | {"type": "Polygon", "coordinates": [[[-123.67235, 40.14486], [-123.67136, 40.14484], [-123.67139, 40.14413], [-123.67233, 40.14419], [-123.67235, 40.14486]]]} | Open Access 1 | Other State 11 | 23251 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 1.561 | Other State 11 | |||
7799 | 7799 | 7798 | {"type": "Polygon", "coordinates": [[[-123.67237, 40.14091], [-123.67235, 40.14147], [-123.67148, 40.1415], [-123.6715, 40.14089], [-123.67237, 40.14091]]]} | Open Access 1 | Other State 14 | 23252 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 1.203 | Other State 14 | |||
7800 | 7800 | 7799 | {"type": "Polygon", "coordinates": [[[-122.82002, 41.67891], [-122.82001, 41.68248], [-122.81502, 41.6825], [-122.815, 41.67891], [-122.82002, 41.67891]]]} | Open Access 1 | Other State 17 | 23253 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 40.982 | Other State 17 | |||
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 | |||
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 | |||
7803 | 7803 | 7802 | {"type": "Polygon", "coordinates": [[[-119.21361, 38.30059], [-119.21338, 38.30059], [-119.21339, 38.29848], [-119.21349, 38.29872], [-119.21356, 38.29909], [-119.21361, 38.30059]]]} | Open Access 1 | Other State 26 | 23258 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 0.864 | Other State 26 | |||
7804 | 7804 | 7803 | {"type": "Polygon", "coordinates": [[[-121.07477, 38.99285], [-121.07367, 38.9929], [-121.07067, 38.99298], [-121.07064, 38.98937], [-121.07472, 38.98924], [-121.07477, 38.99285]]]} | Open Access 1 | Other State 31 | 23259 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 35.201 | Other State 31 | |||
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 | |||
7806 | 7806 | 7805 | {"type": "Polygon", "coordinates": [[[-122.18624, 37.13506], [-122.18623, 37.13512], [-122.18606, 37.13501], [-122.18556, 37.13484], [-122.18456, 37.13439], [-122.18391, 37.13379], [-122.18339, 37.13353], [-122.18225, 37.13281], [-122.18232, 37.13094], [-122.1818, 37.1305], [-122.18216, 37.13004], [-122.18218, 37.12981], [-122.17623, 37.13003], [-122.17622, 37.13004], [-122.17628, 37.13022], [-122.17015, 37.13295], [-122.16845, 37.13183], [-122.16708, 37.13008], [-122.16652, 37.12959], [-122.1658, 37.12917], [-122.16478, 37.12861], [-122.16458, 37.12846], [-122.1644, 37.12829], [-122.16522, 37.12841], [-122.17376, 37.12442], [-122.17542, 37.12787], [-122.17618, 37.12993], [-122.18257, 37.1297], [-122.18258, 37.12968], [-122.18248, 37.12937], [-122.18309, 37.12927], [-122.18335, 37.13025], [-122.18278, 37.13035], [-122.18261, 37.1298], [-122.18228, 37.12981], [-122.18223, 37.13005], [-122.1819, 37.13048], [-122.18236, 37.1309], [-122.18229, 37.13277], [-122.18343, 37.13349], [-122.18395, 37.13375], [-122.18461, 37.13435], [-122.18557, 37.13479], [-122.1861, 37.13497], [-122.18624, 37.13506]]]} | Open Access 1 | Other State 38 | 23261 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 130.86 | Other State 38 | |||
7807 | 7807 | 7806 | {"type": "Polygon", "coordinates": [[[-117.23496, 33.27233], [-117.23496, 33.27267], [-117.23179, 33.27604], [-117.23077, 33.27536], [-117.2336, 33.27235], [-117.23496, 33.27233]]]} | Restricted Access 2 | San Luis Rey River Ecological Reserve | 24942 | 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 | 14.152 | San Luis Rey River ER | ||
7808 | 7808 | 7807 | {"type": "Polygon", "coordinates": [[[-119.79203, 36.87905], [-119.79109, 36.87905], [-119.79022, 36.87875], [-119.79018, 36.87791], [-119.7879, 36.87794], [-119.7874, 36.87857], [-119.78724, 36.87929], [-119.78642, 36.87929], [-119.78673, 36.87858], [-119.78817, 36.87701], [-119.79199, 36.87641], [-119.79203, 36.87905]]]} | Open Access 1 | Other State 39 | 23262 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 19.325 | Other State 39 | |||
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 | |||
7810 | 7810 | 7809 | {"type": "Polygon", "coordinates": [[[-123.78183, 40.4786], [-123.78172, 40.47967], [-123.78083, 40.47987], [-123.78082, 40.47937], [-123.78064, 40.47893], [-123.78183, 40.4786]]]} | Open Access 1 | Other State 43 | 23264 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 2.359 | Other State 43 |
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]);