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/?page_id=432"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15272 | 15272 | 15271 | {"type": "MultiPolygon", "coordinates": [[[[-123.8054, 39.33332], [-123.80144, 39.33393], [-123.80138, 39.33423], [-123.80133, 39.33666], [-123.80044, 39.33696], [-123.79837, 39.33749], [-123.7981, 39.33745], [-123.78933, 39.33734], [-123.78928, 39.33556], [-123.78461, 39.33553], [-123.76613, 39.33536], [-123.76478, 39.33533], [-123.76147, 39.33532], [-123.75241, 39.33523], [-123.75235, 39.33148], [-123.74587, 39.33141], [-123.74576, 39.32952], [-123.74524, 39.32941], [-123.74448, 39.32897], [-123.74392, 39.32821], [-123.74348, 39.32774], [-123.75907, 39.32792], [-123.76133, 39.32802], [-123.76137, 39.32442], [-123.77989, 39.32449], [-123.77997, 39.32812], [-123.78285, 39.32816], [-123.78641, 39.32819], [-123.78923, 39.32827], [-123.79311, 39.32826], [-123.79833, 39.32831], [-123.80413, 39.32842], [-123.80508, 39.33214], [-123.8054, 39.33332]]], [[[-123.815, 39.32998], [-123.81306, 39.32999], [-123.81304, 39.33001], [-123.81282, 39.32993], [-123.81276, 39.32989], [-123.81272, 39.32983], [-123.81261, 39.32979], [-123.81256, 39.32975], [-123.81256, 39.3297], [-123.81253, 39.32966], [-123.81246, 39.32964], [-123.81235, 39.32956], [-123.8123, 39.32945], [-123.81225, 39.32943], [-123.81219, 39.32943], [-123.81186, 39.32931], [-123.81179, 39.32932], [-123.81177, 39.32935], [-123.81179, 39.3294], [-123.81175, 39.32946], [-123.81182, 39.32956], [-123.81206, 39.32976], [-123.81239, 39.32992], [-123.81248, 39.32993], [-123.81253, 39.32999], [-123.81257, 39.33007], [-123.81247, 39.33021], [-123.81241, 39.33025], [-123.81232, 39.33025], [-123.81224, 39.3303], [-123.81203, 39.33028], [-123.81194, 39.33024], [-123.81182, 39.33022], [-123.81173, 39.33025], [-123.81136, 39.33032], [-123.81134, 39.33037], [-123.8114, 39.33042], [-123.8114, 39.33047], [-123.81142, 39.33052], [-123.81145, 39.33054], [-123.81167, 39.33059], [-123.81169, 39.3307], [-123.81173, 39.33072], [-123.81175, 39.33078], [-123.81181, 39.3308], [-123.81193, 39.33074], [-123.81204, 39.33074], [-123.81207, 39.33078], [-123.81212, 39.33082], [-123.81221, 39.33086], [-123.81229, 39.33092], [-123.81232, 39.33099], [-123.81232, 39.33103], [-123.81223, 39.33103], [-123.81215, 39.33113], [-123.81208, 39.33119], [-123.81176, 39.33129], [-123.80999, 39.33176], [-123.80992, 39.33141], [-123.8099, 39.33001], [-123.8083, 39.32998], [-123.80821, 39.33052], [-123.80812, 39.33138], [-123.80817, 39.33212], [-123.80818, 39.33253], [-123.80717, 39.3325], [-123.80699, 39.33304], [-123.80593, 39.33302], [-123.80582, 39.33251], [-123.80623, 39.33249], [-123.80615, 39.33214], [-123.80573, 39.33213], [-123.80497, 39.32981], [-123.80491, 39.32946], [-123.8051, 39.32943], [-123.80516, 39.32931], [-123.80508, 39.3292], [-123.80505, 39.32908], [-123.80498, 39.32901], [-123.80485, 39.32898], [-123.8048, 39.32895], [-123.80477, 39.3289], [-123.80479, 39.32885], [-123.80489, 39.32885], [-123.80499, 39.32879], [-123.80507, 39.32866], [-123.80518, 39.32853], [-123.80467, 39.32842], [-123.80442, 39.32675], [-123.80371, 39.32682], [-123.80319, 39.32581], [-123.80278, 39.32518], [-123.80262, 39.32514], [-123.80243, 39.32494], [-123.80238, 39.3248], [-123.80253, 39.32463], [-123.80228, 39.32417], [-123.80197, 39.32348], [-123.80164, 39.32282], [-123.8013, 39.32236], [-123.80065, 39.32125], [-123.80055, 39.32105], [-123.80106, 39.32105], [-123.80136, 39.32114], [-123.80193, 39.32134], [-123.80245, 39.32136], [-123.80297, 39.32181], [-123.8038, 39.32243], [-123.80412, 39.32256], [-123.80438, 39.32262], [-123.80449, 39.32261], [-123.8046, 39.32258], [-123.80472, 39.32251], [-123.80478, 39.3225], [-123.80487, 39.32243], [-123.80494, 39.32243], [-123.80508, 39.32238], [-123.80521, 39.32236], [-123.80524, 39.32238], [-123.80529, 39.32246], [-123.80535, 39.32249], [-123.80541, 39.32253], [-123.8054, 39.32263], [-123.80536, 39.32268], [-123.80528, 39.32274], [-123.80511, 39.32274], [-123.80501, 39.32271], [-123.80495, 39.32272], [-123.80494, 39.32279], [-123.80499, 39.32286], [-123.80508, 39.32289], [-123.80532, 39.32288], [-123.80549, 39.32286], [-123.80557, 39.32287], [-123.80581, 39.32299], [-123.8059, 39.32309], [-123.80588, 39.3232], [-123.80577, 39.32323], [-123.80568, 39.32327], [-123.80565, 39.32333], [-123.80568, 39.32335], [-123.80583, 39.32331], [-123.80571, 39.32341], [-123.80557, 39.32345], [-123.8056, 39.32351], [-123.80628, 39.32335], [-123.80672, 39.32338], [-123.80678, 39.32341], [-123.80676, 39.32349], [-123.80677, 39.32352], [-123.80675, 39.32353], [-123.8067, 39.32358], [-123.8067, 39.32362], [-123.8069, 39.32373], [-123.80693, 39.32379], [-123.80677, 39.32394], [-123.80659, 39.32416], [-123.80659, 39.32423], [-123.80656, 39.32428], [-123.80659, 39.32434], [-123.80677, 39.32443], [-123.80689, 39.32441], [-123.80703, 39.32436], [-123.80729, 39.3244], [-123.80732, 39.32441], [-123.80739, 39.32439], [-123.80746, 39.32433], [-123.80757, 39.32427], [-123.808, 39.32427], [-123.80815, 39.32433], [-123.80828, 39.32431], [-123.80837, 39.32435], [-123.80857, 39.32453], [-123.80867, 39.32457], [-123.80871, 39.3246], [-123.80864, 39.32466], [-123.80852, 39.32467], [-123.8084, 39.32473], [-123.80838, 39.32476], [-123.80819, 39.3248], [-123.80812, 39.32475], [-123.80806, 39.32476], [-123.80802, 39.32482], [-123.80785, 39.32485], [-123.80777, 39.32489], [-123.80739, 39.32497], [-123.80725, 39.32498], [-123.80713, 39.32493], [-123.80712, 39.32496], [-123.80716, 39.32499], [-123.80646, 39.32492], [-123.80617, 39.32492], [-123.80607, 39.32498], [-123.806, 39.32507], [-123.80594, 39.32511], [-123.80567, 39.32503], [-123.80562, 39.32504], [-123.80557, 39.32508], [-123.80553, 39.32515], [-123.80548, 39.32511], [-123.8054, 39.3251], [-123.80537, 39.32515], [-123.80537, 39.32526], [-123.80531, 39.32528], [-123.80526, 39.32528], [-123.80506, 39.32513], [-123.80501, 39.32511], [-123.80486, 39.32495], [-123.80478, 39.32493], [-123.80475, 39.32488], [-123.80472, 39.32487], [-123.80458, 39.32486], [-123.80436, 39.32492], [-123.8041, 39.32505], [-123.80391, 39.32524], [-123.80385, 39.32535], [-123.80384, 39.3255], [-123.80387, 39.32557], [-123.80392, 39.32563], [-123.80394, 39.32571], [-123.80397, 39.32576], [-123.80406, 39.32581], [-123.80408, 39.32592], [-123.80416, 39.32606], [-123.80426, 39.32613], [-123.80428, 39.32623], [-123.80633, 39.32575], [-123.80603, 39.32596], [-123.80598, 39.32614], [-123.80611, 39.32635], [-123.80633, 39.32644], [-123.80674, 39.32649], [-123.80709, 39.32643], [-123.80798, 39.32621], [-123.80812, 39.32625], [-123.80824, 39.32635], [-123.808, 39.32652], [-123.80782, 39.32692], [-123.80777, 39.32716], [-123.80773, 39.32731], [-123.80724, 39.32777], [-123.80704, 39.32799], [-123.80695, 39.32817], [-123.807, 39.32835], [-123.80718, 39.32845], [-123.80759, 39.32848], [-123.80797, 39.32839], [-123.80821, 39.32821], [-123.8084, 39.32786], [-123.80837, 39.32749], [-123.80837, 39.3273], [-123.8085, 39.32721], [-123.80875, 39.32723], [-123.80912, 39.32722], [-123.80922, 39.32708], [-123.80925, 39.32693], [-123.80922, 39.32681], [-123.80898, 39.32671], [-123.80896, 39.32646], [-123.80901, 39.32627], [-123.80913, 39.32612], [-123.80951, 39.32603], [-123.80982, 39.32597], [-123.81013, 39.32602], [-123.81046, 39.32611], [-123.81064, 39.32632], [-123.81063, 39.3266], [-123.81073, 39.32669], [-123.8109, 39.32674], [-123.81112, 39.32669], [-123.81141, 39.32668], [-123.81164, 39.32676], [-123.81188, 39.32677], [-123.81213, 39.32675], [-123.81242, 39.32688], [-123.81266, 39.32708], [-123.81276, 39.32729], [-123.81276, 39.32749], [-123.81283, 39.32763], [-123.813, 39.32765], [-123.81323, 39.32761], [-123.8133, 39.32745], [-123.81333, 39.32714], [-123.81343, 39.32693], [-123.81356, 39.3268], [-123.81371, 39.32673], [-123.8139, 39.32678], [-123.814, 39.3269], [-123.814, 39.32712], [-123.81385, 39.32732], [-123.81376, 39.32758], [-123.81376, 39.32788], [-123.8138, 39.32818], [-123.81394, 39.32836], [-123.81411, 39.32852], [-123.81431, 39.32867], [-123.81445, 39.32883], [-123.81451, 39.32893], [-123.81448, 39.32909], [-123.81452, 39.3294], [-123.81476, 39.32964], [-123.81496, 39.32979], [-123.815, 39.32998]], [[-123.81389, 39.3292], [-123.81386, 39.32914], [-123.81387, 39.32911], [-123.81386, 39.32907], [-123.81375, 39.32899], [-123.81379, 39.32895], [-123.81382, 39.32884], [-123.81381, 39.3288], [-123.81363, 39.32872], [-123.81356, 39.32872], [-123.81352, 39.32876], [-123.81351, 39.32879], [-123.81342, 39.32883], [-123.81343, 39.32887], [-123.81349, 39.32893], [-123.8136, 39.32899], [-123.8136, 39.32902], [-123.81352, 39.32917], [-123.81348, 39.3292], [-123.81336, 39.32908], [-123.8133, 39.32909], [-123.81315, 39.32905], [-123.81307, 39.32907], [-123.81303, 39.32914], [-123.81304, 39.32927], [-123.81302, 39.3295], [-123.81305, 39.32954], [-123.81313, 39.32954], [-123.81326, 39.32949], [-123.81328, 39.32953], [-123.81328, 39.32968], [-123.81332, 39.32972], [-123.81336, 39.32974], [-123.81363, 39.32981], [-123.81372, 39.3298], [-123.81375, 39.32963], [-123.81391, 39.32968], [-123.81395, 39.32966], [-123.81396, 39.32961], [-123.81393, 39.32942], [-123.81393, 39.32923], [-123.81389, 39.3292]], [[-123.81313, 39.3298], [-123.81328, 39.32985], [-123.81331, 39.32986], [-123.81333, 39.32984], [-123.8132, 39.3297], [-123.81313, 39.3297], [-123.81311, 39.32972], [-123.81309, 39.32976], [-123.81313, 39.3298]]]]} | Open Access 1 | Russian Gulch State Park | http://www.parks.ca.gov/?page_id=432 | 1980 | 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 | 1297.336 | Russian Gulch SP | 1933 |
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]);