superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
276 rows where MNG_AGENCY = 47 sorted by ACRES
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
- Open Access 250
- No Public Access 15
- Restricted Access 11
MNG_AG_TYP 1
- State Agency 276
MNG_AGENCY 1
- California Department of Parks and Recreation · 276 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13361 | 13361 | 13360 | {"type": "Polygon", "coordinates": [[[-121.47196, 38.57297], [-121.4719, 38.5731], [-121.47185, 38.57309], [-121.47183, 38.57313], [-121.47145, 38.57303], [-121.4715, 38.57291], [-121.47179, 38.57299], [-121.47182, 38.57294], [-121.47196, 38.57297]]]} | Open Access 1 | State Indian Museum State Historic Park | http://www.parks.ca.gov/?page_id=486 | 30709 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 0.153 | State Indian Museum SHP | 1941 |
82 | 82 | 81 | {"type": "Polygon", "coordinates": [[[-119.94847, 37.46489], [-119.94784, 37.46489], [-119.94783, 37.46473], [-119.94799, 37.46473], [-119.94799, 37.46463], [-119.94829, 37.46463], [-119.9483, 37.46472], [-119.94846, 37.46472], [-119.94847, 37.46489]]]} | Open Access 1 | California Mining & Mineral Museum | http://www.parks.ca.gov/?page_id=588 | 1457 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 0.327 | California Mining & Mineral Museum | 1999 |
180 | 180 | 179 | {"type": "Polygon", "coordinates": [[[-121.49995, 38.57528], [-121.49977, 38.5757], [-121.49934, 38.57558], [-121.49952, 38.57517], [-121.49995, 38.57528]]]} | Open Access 1 | Heilbron Mansion | 1561 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 0.477 | Heilbron Mansion | ||
265 | 265 | 264 | {"type": "MultiPolygon", "coordinates": [[[[-122.51877, 37.53612], [-122.51876, 37.53627], [-122.5183, 37.53627], [-122.51828, 37.53634], [-122.51809, 37.53633], [-122.51811, 37.53611], [-122.51877, 37.53612]]], [[[-122.51916, 37.53641], [-122.51915, 37.53651], [-122.51888, 37.5365], [-122.51888, 37.53641], [-122.51916, 37.53641]]], [[[-122.51937, 37.53613], [-122.51935, 37.53634], [-122.51927, 37.53635], [-122.51926, 37.53641], [-122.51918, 37.53641], [-122.51918, 37.53635], [-122.5191, 37.53634], [-122.5191, 37.53611], [-122.5192, 37.53612], [-122.51922, 37.53605], [-122.51927, 37.53605], [-122.51928, 37.53612], [-122.51937, 37.53613]]]]} | Open Access 1 | Point Montara Light Station | http://www.lighthousefriends.com/light.asp?ID=78 | 1691 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 0.513 | Point Montara Light Station | 1982 |
92 | 92 | 91 | {"type": "Polygon", "coordinates": [[[-118.25813, 33.78468], [-118.25775, 33.7847], [-118.25773, 33.78459], [-118.2574, 33.78461], [-118.25738, 33.78437], [-118.2581, 33.78433], [-118.25813, 33.78468]]]} | Open Access 1 | Drum Barracks | http://ohp.parks.ca.gov/ListedResources/Detail/169 | 1504 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 0.539 | Drum Barracks | |
12232 | 12232 | 12231 | {"type": "Polygon", "coordinates": [[[-121.48533, 38.57999], [-121.48515, 38.58041], [-121.48444, 38.58023], [-121.48463, 38.57981], [-121.48533, 38.57999]]]} | No Public Access 3 | Governor's Mansion State Historic Park | http://www.parks.ca.gov/?page_id=498 | 30653 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 0.789 | Governor's Mansion SHP | 1903 |
59 | 59 | 58 | {"type": "Polygon", "coordinates": [[[-122.15956, 38.05035], [-122.15934, 38.05064], [-122.15844, 38.05023], [-122.15866, 38.04993], [-122.15956, 38.05035]]]} | Open Access 1 | Benicia Capitol State Historic Park | http://www.parks.ca.gov/?page_id=475 | 1431 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 0.863 | Benicia Capitol SHP | 1951 |
15196 | 15196 | 15195 | {"type": "Polygon", "coordinates": [[[-121.49815, 38.57602], [-121.49797, 38.57644], [-121.49718, 38.57622], [-121.49736, 38.57581], [-121.49815, 38.57602]]]} | Open Access 1 | Leland Stanford Mansion State Historic Park | http://www.parks.ca.gov/?page_id=489 | 1600 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 0.881 | Leland Stanford Mansion SHP | 1978 |
85 | 85 | 84 | {"type": "Polygon", "coordinates": [[[-122.5099, 38.54123], [-122.50953, 38.54126], [-122.5096, 38.54147], [-122.50894, 38.54153], [-122.50889, 38.54131], [-122.5088, 38.54108], [-122.50918, 38.54103], [-122.50948, 38.54101], [-122.50983, 38.54111], [-122.5099, 38.54123]]]} | Open Access 1 | Bale Grist Mill State Historic Park | http://www.parks.ca.gov/?page_id=482 | 1428 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 0.893 | Bale Grist Mill SHP | 1974 |
8537 | 8537 | 8536 | {"type": "Polygon", "coordinates": [[[-121.81298, 36.94641], [-121.81273, 36.94671], [-121.81211, 36.94655], [-121.81235, 36.94589], [-121.81273, 36.94612], [-121.81298, 36.94641]]]} | Open Access 1 | Rancho San Andreas | 24168 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 0.998 | Rancho San Andreas | 2002 | |
5312 | 5312 | 5311 | {"type": "Polygon", "coordinates": [[[-116.18721, 33.15378], [-116.18628, 33.1536], [-116.18497, 33.1533], [-116.18496, 33.15281], [-116.18721, 33.15378]]]} | No Public Access 3 | Hwy 78 scenic corridor | 20163 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1.474 | Hwy 78 scenic corridor | ||
246 | 246 | 245 | {"type": "Polygon", "coordinates": [[[-122.02878, 36.97719], [-122.0287, 36.97779], [-122.0274, 36.97767], [-122.02741, 36.9773], [-122.02744, 36.97729], [-122.02745, 36.97722], [-122.02743, 36.9772], [-122.02743, 36.97719], [-122.02775, 36.97722], [-122.0283, 36.97721], [-122.02833, 36.97714], [-122.02837, 36.97712], [-122.02858, 36.97713], [-122.02878, 36.97719]]]} | Open Access 1 | Santa Cruz Mission State Historic Park | http://www.parks.ca.gov/?page_id=548 | 1735 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1.774 | Santa Cruz Mission SHP | 1959 |
341 | 341 | 340 | {"type": "Polygon", "coordinates": [[[-122.9416, 40.73137], [-122.94103, 40.73173], [-122.94081, 40.73182], [-122.94073, 40.73192], [-122.9404, 40.732], [-122.94016, 40.73124], [-122.9403, 40.73119], [-122.94045, 40.73107], [-122.94051, 40.73097], [-122.94057, 40.73069], [-122.94068, 40.73084], [-122.94135, 40.73068], [-122.9416, 40.73137]]]} | Open Access 1 | Weaverville Joss House State Historic Park | http://www.parks.ca.gov/?page_id=457 | 1785 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2.694 | Weaverville Joss House SHP | 1956 |
14130 | 14130 | 14129 | {"type": "MultiPolygon", "coordinates": [[[[-118.58004, 34.11729], [-118.57961, 34.11728], [-118.57961, 34.1172], [-118.57942, 34.11719], [-118.57942, 34.11703], [-118.57963, 34.11702], [-118.57965, 34.11711], [-118.57997, 34.11712], [-118.57999, 34.11721], [-118.58004, 34.11729]]], [[[-118.58026, 34.11707], [-118.57996, 34.11707], [-118.57993, 34.11699], [-118.58026, 34.11699], [-118.58026, 34.11707]]], [[[-118.59209, 34.11758], [-118.59199, 34.11758], [-118.592, 34.11732], [-118.59205, 34.11731], [-118.59209, 34.11758]]], [[[-118.59243, 34.11621], [-118.59243, 34.11664], [-118.59225, 34.11664], [-118.5922, 34.1162], [-118.59243, 34.11621]]], [[[-118.60509, 34.13834], [-118.60509, 34.1393], [-118.60406, 34.13931], [-118.60406, 34.13835], [-118.60509, 34.13834]]]]} | Open Access 1 | Santa Monica Mountains National Recreation Area | http://www.nps.gov/samo/index.htm | 32641 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 3.089 | Santa Monica Mtns. NRA | |
94 | 94 | 93 | {"type": "MultiPolygon", "coordinates": [[[[-123.82187, 39.36052], [-123.82181, 39.36061], [-123.82169, 39.36065], [-123.82162, 39.36078], [-123.82155, 39.36082], [-123.82145, 39.36074], [-123.82141, 39.36068], [-123.82133, 39.36064], [-123.82131, 39.36057], [-123.82132, 39.36051], [-123.82158, 39.36028], [-123.82186, 39.36045], [-123.8218, 39.36046], [-123.82178, 39.36047], [-123.82187, 39.36052]]], [[[-123.8228, 39.36144], [-123.82276, 39.36146], [-123.82269, 39.36143], [-123.82259, 39.36148], [-123.82258, 39.36155], [-123.82252, 39.36153], [-123.82241, 39.36153], [-123.8221, 39.3613], [-123.82218, 39.36104], [-123.82217, 39.36096], [-123.82219, 39.36093], [-123.82217, 39.36088], [-123.82209, 39.36082], [-123.82276, 39.36083], [-123.8228, 39.36144]]], [[[-123.8239, 39.36142], [-123.82385, 39.36148], [-123.82388, 39.36153], [-123.82388, 39.36156], [-123.82384, 39.36163], [-123.82363, 39.3617], [-123.82356, 39.36169], [-123.82352, 39.36163], [-123.82328, 39.36152], [-123.82324, 39.36141], [-123.82319, 39.36134], [-123.8234, 39.36118], [-123.82373, 39.36127], [-123.82371, 39.36132], [-123.8239, 39.36142]]], [[[-123.8251, 39.36086], [-123.82509, 39.36092], [-123.825, 39.36097], [-123.82499, 39.36102], [-123.82492, 39.36101], [-123.82473, 39.36109], [-123.82458, 39.36104], [-123.8245, 39.36097], [-123.82444, 39.36087], [-123.82438, 39.36085], [-123.82435, 39.36087], [-123.82436, 39.36092], [-123.82433, 39.36095], [-123.82424, 39.36095], [-123.82419, 39.36096], [-123.82414, 39.3609], [-123.8241, 39.36079], [-123.8241, 39.36073], [-123.82405, 39.36071], [-123.82401, 39.36072], [-123.82397, 39.36082], [-123.82387, 39.36069], [-123.82396, 39.36045], [-123.824, 39.36044], [-123.82406, 39.36037], [-123.82415, 39.36036], [-123.82422, 39.36032], [-123.82435, 39.36035], [-123.82449, 39.36041], [-123.82471, 39.36049], [-123.82476, 39.36056], [-123.8249, 39.3606], [-123.82495, 39.36063], [-123.8251, 39.36086]]]]} | Open Access 1 | Caspar Headlands State Natural Reserve | http://www.parks.ca.gov/?page_id=444 | 1468 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 3.222 | Caspar Headlands SNR | 1972 |
143 | 143 | 142 | {"type": "Polygon", "coordinates": [[[-122.51428, 37.56488], [-122.51316, 37.56487], [-122.51295, 37.56471], [-122.51289, 37.56417], [-122.51309, 37.56379], [-122.51423, 37.5638], [-122.51426, 37.56398], [-122.51421, 37.56425], [-122.51424, 37.56453], [-122.51423, 37.56467], [-122.51428, 37.56488]]]} | Open Access 1 | Gray Whale Cove State Beach | http://www.parks.ca.gov/?page_id=528 | 1549 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 3.327 | Gray Whale Cove SB | 1966 |
63 | 63 | 62 | {"type": "Polygon", "coordinates": [[[-121.84432, 39.73236], [-121.84377, 39.7326], [-121.84393, 39.73289], [-121.8439, 39.73295], [-121.84379, 39.733], [-121.84382, 39.73307], [-121.84289, 39.73344], [-121.8429, 39.73355], [-121.84275, 39.73333], [-121.84219, 39.73229], [-121.84207, 39.73196], [-121.84218, 39.73192], [-121.84285, 39.7319], [-121.84302, 39.73192], [-121.84338, 39.73185], [-121.84354, 39.73202], [-121.84376, 39.7319], [-121.84392, 39.73179], [-121.84432, 39.73236]]]} | Open Access 1 | Bidwell Mansion State Historic Park | http://www.parks.ca.gov/?page_id=460 | 1435 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 5.235 | Bidwell Mansion SHP | 1964 |
203 | 203 | 202 | {"type": "Polygon", "coordinates": [[[-118.49995, 34.15915], [-118.49971, 34.15988], [-118.49972, 34.16071], [-118.49902, 34.16071], [-118.49874, 34.16068], [-118.49841, 34.16058], [-118.49801, 34.16039], [-118.49819, 34.16014], [-118.49834, 34.15987], [-118.49847, 34.15959], [-118.49859, 34.15928], [-118.49911, 34.15939], [-118.4993, 34.15931], [-118.4994, 34.15902], [-118.49995, 34.15915]]]} | Open Access 1 | Los Encinos State Historic Park | http://www.parks.ca.gov/?page_id=619 | 1609 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 5.269 | Los Encinos SHP | 1949 |
11575 | 11575 | 11574 | {"type": "Polygon", "coordinates": [[[-118.0723, 33.99322], [-118.07164, 33.99441], [-118.07148, 33.99431], [-118.07119, 33.99461], [-118.07001, 33.99381], [-118.07085, 33.99295], [-118.07123, 33.9932], [-118.07165, 33.99278], [-118.0723, 33.99322]]]} | Open Access 1 | Pío Pico State Historic Park | http://www.parks.ca.gov/?page_id=621 | 28083 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 5.714 | Pío Pico SHP | 1917 |
15205 | 15205 | 15204 | {"type": "MultiPolygon", "coordinates": [[[[-122.22671, 40.19604], [-122.22644, 40.19618], [-122.22578, 40.19664], [-122.22536, 40.19732], [-122.22521, 40.19765], [-122.22498, 40.19793], [-122.22428, 40.19761], [-122.22436, 40.19745], [-122.22445, 40.19735], [-122.22459, 40.19723], [-122.22462, 40.19718], [-122.22463, 40.19708], [-122.22472, 40.19696], [-122.22477, 40.19678], [-122.22485, 40.19664], [-122.22514, 40.19628], [-122.22549, 40.1957], [-122.22566, 40.1955], [-122.2257, 40.19543], [-122.22618, 40.19592], [-122.22644, 40.19578], [-122.22671, 40.19604]]], [[[-122.22771, 40.19558], [-122.22711, 40.19584], [-122.22682, 40.19598], [-122.22654, 40.19569], [-122.22708, 40.19538], [-122.22715, 40.19544], [-122.22742, 40.19529], [-122.22771, 40.19558]]]]} | Open Access 1 | William B. Ide Adobe State Historic Park | http://www.parks.ca.gov/?page_id=458 | 1791 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 5.798 | William B. Ide Adobe SHP | 1951 |
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]);