superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_URL = "http://www.parks.ca.gov/default.asp?page_id=646"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
313 | 313 | 312 | {"type": "MultiPolygon", "coordinates": [[[[-117.60618, 33.40503], [-117.60418, 33.40561], [-117.60383, 33.40574], [-117.60373, 33.40583], [-117.60367, 33.40592], [-117.60365, 33.40596], [-117.60373, 33.40638], [-117.60372, 33.40646], [-117.60368, 33.40655], [-117.60355, 33.40667], [-117.60337, 33.40674], [-117.6033, 33.4068], [-117.60325, 33.40687], [-117.60287, 33.40754], [-117.60269, 33.40778], [-117.60249, 33.40797], [-117.60234, 33.40809], [-117.60213, 33.40821], [-117.60167, 33.40839], [-117.60163, 33.40839], [-117.6016, 33.40837], [-117.60158, 33.40816], [-117.60185, 33.40788], [-117.60168, 33.40767], [-117.60181, 33.40765], [-117.60186, 33.40756], [-117.60169, 33.40735], [-117.60174, 33.40722], [-117.60139, 33.40712], [-117.60106, 33.40699], [-117.60076, 33.4069], [-117.60037, 33.40699], [-117.59972, 33.40719], [-117.59912, 33.40596], [-117.59829, 33.40436], [-117.59749, 33.40296], [-117.59735, 33.40267], [-117.60024, 33.40162], [-117.60007, 33.40125], [-117.60044, 33.40091], [-117.60035, 33.40072], [-117.60041, 33.40066], [-117.60041, 33.40059], [-117.60034, 33.40052], [-117.60059, 33.39996], [-117.60071, 33.4], [-117.60104, 33.39983], [-117.60161, 33.39941], [-117.6027, 33.40073], [-117.60332, 33.40139], [-117.60395, 33.40219], [-117.60535, 33.40404], [-117.60618, 33.40503]]], [[[-117.61191, 33.41048], [-117.61153, 33.4107], [-117.60592, 33.4043], [-117.6052, 33.40338], [-117.60357, 33.40119], [-117.60174, 33.39896], [-117.60049, 33.39698], [-117.60092, 33.39681], [-117.60115, 33.39725], [-117.6018, 33.39831], [-117.60206, 33.39868], [-117.60272, 33.39955], [-117.60325, 33.40021], [-117.60362, 33.40052], [-117.604, 33.40092], [-117.60442, 33.4015], [-117.60446, 33.4016], [-117.60481, 33.40208], [-117.60503, 33.40242], [-117.60525, 33.40266], [-117.60592, 33.40373], [-117.60671, 33.40473], [-117.60738, 33.40545], [-117.60751, 33.4056], [-117.60771, 33.40587], [-117.60801, 33.40623], [-117.60861, 33.40683], [-117.60927, 33.40752], [-117.6096, 33.40796], [-117.61037, 33.40882], [-117.61093, 33.40933], [-117.61133, 33.40974], [-117.61191, 33.41048]]], [[[-117.6037, 33.40681], [-117.60358, 33.40687], [-117.60352, 33.40693], [-117.60351, 33.40698], [-117.60333, 33.40731], [-117.60324, 33.40755], [-117.60313, 33.4077], [-117.60301, 33.40781], [-117.60293, 33.40777], [-117.60346, 33.40687], [-117.60364, 33.40676], [-117.6037, 33.40681]]], [[[-117.60838, 33.40757], [-117.60833, 33.4076], [-117.60717, 33.40623], [-117.60711, 33.40626], [-117.60692, 33.40604], [-117.60642, 33.40669], [-117.60579, 33.40636], [-117.60558, 33.40632], [-117.60532, 33.40632], [-117.60531, 33.40605], [-117.60527, 33.40601], [-117.6051, 33.40611], [-117.60454, 33.40628], [-117.60431, 33.40592], [-117.60407, 33.40604], [-117.6041, 33.40609], [-117.60405, 33.40631], [-117.60403, 33.40647], [-117.60384, 33.40653], [-117.60389, 33.40629], [-117.60384, 33.406], [-117.60386, 33.40593], [-117.60388, 33.40589], [-117.60396, 33.40582], [-117.60406, 33.40579], [-117.60591, 33.40526], [-117.60601, 33.40527], [-117.6061, 33.40536], [-117.60616, 33.40532], [-117.60627, 33.40544], [-117.60622, 33.4055], [-117.60656, 33.40589], [-117.60683, 33.40574], [-117.60838, 33.40757]]]]} | Open Access 1 | San Clemente State Beach | http://www.parks.ca.gov/default.asp?page_id=646 | 1724 | 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 | 121.083 | San Clemente SB | 1931 |
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]);