units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
321 rows where LAYER = 9 and MNG_AGENCY = 47 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
DES_TP 14
- State Park 182
- State Historic or Cultural Area 58
- State Recreation Area 48
- State Conservation Area 18
- State Other or Unknown 5
- State Wilderness 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
- Open Access 298
- No Public Access 14
- Restricted Access 9
MNG_AG_TYP 1
- State Agency 321
MNG_AGENCY 1
- California Department of Parks and Recreation · 321 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14451 | 14451 | 14450 | {"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 | 47058 | State Indian Museum State Historic Park | 30709 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=486 | Sacramento 41 | 0.153 | State Indian Museum SHP | 1941 | State Historic or Cultural Area 132 | 4 |
10562 | 10562 | 10561 | {"type": "MultiPolygon", "coordinates": [[[[-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.53634], [-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 | 18796 | Point Montara Light Station | 1691 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.lighthousefriends.com/light.asp?ID=78 | San Mateo 15 | 0.227 | Point Montara Light Station | 1982 | State Historic or Cultural Area 132 | 4 |
3191 | 3191 | 3190 | {"type": "Polygon", "coordinates": [[[-122.51877, 37.53612], [-122.51876, 37.53627], [-122.51829, 37.53627], [-122.51828, 37.53634], [-122.51809, 37.53633], [-122.51811, 37.53611], [-122.51877, 37.53612]]]} | Open Access 1 | 22111 | Point Montara Light Station | 1691 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.lighthousefriends.com/light.asp?ID=78 | San Mateo 15 | 0.284 | Point Montara Light Station | 1982 | State Historic or Cultural Area 132 | 4 |
13128 | 13128 | 13127 | {"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 | 35061 | California Mining & Mineral Museum | 1457 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=588 | Mariposa 31 | 0.326 | California Mining & Mineral Museum | 1999 | State Historic or Cultural Area 132 | 4 |
2965 | 2965 | 2964 | {"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 | 20483 | Heilbron Mansion | 1561 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Sacramento 41 | 0.477 | Heilbron Mansion | None 244 | |||
993 | 993 | 992 | {"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 | 6191 | Drum Barracks | 1504 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://ohp.parks.ca.gov/ListedResources/Detail/169 | Los Angeles 6 | 0.539 | Drum Barracks | None 90 | ||
2960 | 2960 | 2959 | {"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 | 20477 | Governor's Mansion State Historic Park | 30653 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=498 | Sacramento 41 | 0.789 | Governor's Mansion SHP | 1903 | State Historic or Cultural Area 132 | 4 |
13135 | 13135 | 13134 | {"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 | 35060 | Benicia Capitol State Historic Park | 1431 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=475 | Solano 26 | 0.863 | Benicia Capitol SHP | 1951 | State Historic or Cultural Area 132 | 4 |
16510 | 16510 | 16509 | {"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 | 20493 | Leland Stanford Mansion State Historic Park | 1600 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=489 | Sacramento 41 | 0.881 | Leland Stanford Mansion SHP | 1978 | State Historic or Cultural Area 132 | 4 |
13171 | 13171 | 13170 | {"type": "Polygon", "coordinates": [[[-122.5099, 38.54123], [-122.50952, 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 | 35129 | Bale Grist Mill State Historic Park | 1428 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=482 | Napa 11 | 0.89 | Bale Grist Mill SHP | 1974 | State Historic or Cultural Area 132 | 4 |
3833 | 3833 | 3832 | {"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 | 45359 | Rancho San Andreas | 24168 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Santa Cruz 5 | 0.999 | Rancho San Andreas | 2002 | None 323 | ||
16460 | 16460 | 16459 | {"type": "Polygon", "coordinates": [[[-118.89209, 34.04019], [-118.89161, 34.04094], [-118.89112, 34.04087], [-118.8916, 34.04012], [-118.89209, 34.04019]]]} | Open Access 1 | 13036 | Robert H. Meyer Memorial State Beach | 1709 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=633 | Los Angeles 6 | 1.018 | Robert H. Meyer Memorial SB | 1978 | State Park 15 | 4 |
10257 | 10257 | 10256 | {"type": "Polygon", "coordinates": [[[-121.89565, 36.59712], [-121.89542, 36.5974], [-121.89492, 36.59766], [-121.89447, 36.59714], [-121.89525, 36.59669], [-121.89528, 36.59673], [-121.8955, 36.59691], [-121.89565, 36.59712]]]} | Open Access 1 | 17953 | Monterey State Historic Park | 1640 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/default.asp?page_id=575 | Monterey 14 | 1.518 | Monterey SHP | 1916 | State Historic or Cultural Area 132 | 4 |
16475 | 16475 | 16474 | {"type": "Polygon", "coordinates": [[[-122.02878, 36.97719], [-122.0287, 36.97779], [-122.0274, 36.97767], [-122.02741, 36.9773], [-122.02744, 36.97729], [-122.02746, 36.97722], [-122.02743, 36.9772], [-122.02743, 36.97719], [-122.02775, 36.97722], [-122.02831, 36.97721], [-122.02833, 36.97714], [-122.02836, 36.97714], [-122.02837, 36.97712], [-122.02858, 36.97713], [-122.02878, 36.97719]]]} | Open Access 1 | 551 | Santa Cruz Mission State Historic Park | 1735 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=548 | Santa Cruz 5 | 1.772 | Santa Cruz Mission SHP | 1959 | State Historic or Cultural Area 132 | 4 |
16515 | 16515 | 16514 | {"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 | 20529 | Weaverville Joss House State Historic Park | 1785 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=457 | Trinity 46 | 2.693 | Weaverville Joss House SHP | 1956 | State Historic or Cultural Area 132 | 4 |
3204 | 3204 | 3203 | {"type": "Polygon", "coordinates": [[[-121.10781, 35.56185], [-121.1078, 35.56195], [-121.10771, 35.56198], [-121.10769, 35.56204], [-121.10771, 35.56215], [-121.1077, 35.56219], [-121.10688, 35.56246], [-121.10656, 35.56097], [-121.10719, 35.56074], [-121.10724, 35.56099], [-121.1074, 35.56121], [-121.10757, 35.56141], [-121.10755, 35.56148], [-121.10748, 35.56154], [-121.10745, 35.56161], [-121.1075, 35.56169], [-121.10774, 35.56174], [-121.10781, 35.56185]]]} | Open Access 1 | 28117 | Hearst San Simeon State Park | 1558 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=590 | San Luis Obispo 1 | 3.12 | Hearst San Simeon SP | 1932 | State Park 15 | 4 |
2855 | 2855 | 2854 | {"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.82179, 39.36046], [-123.82177, 39.36048], [-123.82183, 39.36049], [-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.82384, 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.36164], [-123.82328, 39.36152], [-123.82323, 39.36141], [-123.82319, 39.36134], [-123.8234, 39.36118], [-123.82373, 39.36127], [-123.82371, 39.36132], [-123.8239, 39.36142]]], [[[-123.82509, 39.36092], [-123.825, 39.36098], [-123.82499, 39.36102], [-123.82493, 39.36101], [-123.82473, 39.36109], [-123.82458, 39.36104], [-123.8245, 39.36097], [-123.82444, 39.36087], [-123.82437, 39.36085], [-123.82435, 39.36088], [-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.36045], [-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.36057], [-123.8249, 39.3606], [-123.82495, 39.36063], [-123.825, 39.3607], [-123.82501, 39.36074], [-123.82508, 39.36083], [-123.8251, 39.36086], [-123.82509, 39.36092]]]]} | Open Access 1 | 22153 | Caspar Headlands State Natural Reserve | 1468 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=444 | Mendocino 24 | 3.22 | Caspar Headlands SNR | 1972 | State Conservation Area 8 | 2 |
2143 | 2143 | 2142 | {"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 | 16013 | Gray Whale Cove State Beach | 1549 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=528 | San Mateo 15 | 3.327 | Gray Whale Cove SB | 1966 | State Park 15 | 4 |
14452 | 14452 | 14451 | {"type": "Polygon", "coordinates": [[[-122.51122, 38.46753], [-122.51122, 38.46754], [-122.50786, 38.46768], [-122.50783, 38.46616], [-122.50805, 38.46617], [-122.50804, 38.46635], [-122.50829, 38.46668], [-122.5085, 38.46687], [-122.50879, 38.46703], [-122.50919, 38.46716], [-122.51001, 38.46737], [-122.51041, 38.46735], [-122.51064, 38.46739], [-122.51072, 38.46734], [-122.5108, 38.46743], [-122.51122, 38.46753]]]} | Open Access 1 | 47060 | Sugarloaf Ridge State Park | 1761 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=481 | Napa 11 | 3.946 | Sugarloaf Ridge SP | 1920 | State Park 15 | 4 |
9426 | 9426 | 9425 | {"type": "Polygon", "coordinates": [[[-121.84432, 39.73236], [-121.84376, 39.7326], [-121.84393, 39.73289], [-121.8439, 39.73295], [-121.84378, 39.733], [-121.84382, 39.73307], [-121.84288, 39.73345], [-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.73203], [-121.84376, 39.7319], [-121.84392, 39.73179], [-121.84432, 39.73236]]]} | Open Access 1 | 15756 | Bidwell Mansion State Historic Park | 1435 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=460 | Butte 42 | 5.229 | Bidwell Mansion SHP | 1964 | State Historic or Cultural Area 132 | 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]);