superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 2, MNG_AGENCY = 25, MNG_AG_TYP = 5 and YR_EST = 1983
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency · 3 ✖
MNG_AGENCY 1
- California Department of Fish and Wildlife · 3 ✖
ACCESS_TYP 1
- Restricted Access · 3 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12302 | 12302 | 12301 | {"type": "Polygon", "coordinates": [[[-119.85959, 34.42432], [-119.85958, 34.4251], [-119.85929, 34.42512], [-119.8593, 34.42523], [-119.85958, 34.42524], [-119.85956, 34.4273], [-119.85783, 34.42735], [-119.85758, 34.42861], [-119.85609, 34.42866], [-119.85706, 34.43053], [-119.85707, 34.43059], [-119.85041, 34.43096], [-119.85037, 34.42968], [-119.84781, 34.42968], [-119.84772, 34.42807], [-119.85207, 34.42791], [-119.85201, 34.42631], [-119.8449, 34.42644], [-119.83962, 34.42311], [-119.8383, 34.41926], [-119.83522, 34.41979], [-119.83523, 34.41728], [-119.83572, 34.41704], [-119.83596, 34.41682], [-119.83596, 34.41656], [-119.83624, 34.41644], [-119.83795, 34.41587], [-119.83861, 34.41589], [-119.83919, 34.41603], [-119.83978, 34.41639], [-119.8403, 34.41663], [-119.84059, 34.41665], [-119.84147, 34.41655], [-119.84202, 34.41676], [-119.84225, 34.41702], [-119.84254, 34.41719], [-119.84261, 34.41773], [-119.84345, 34.41803], [-119.84388, 34.41787], [-119.84649, 34.41887], [-119.84724, 34.4191], [-119.84777, 34.41943], [-119.84846, 34.41967], [-119.84932, 34.42002], [-119.84941, 34.42008], [-119.84978, 34.42043], [-119.85006, 34.42077], [-119.85048, 34.42106], [-119.85071, 34.4211], [-119.85104, 34.42129], [-119.85145, 34.42146], [-119.85197, 34.42172], [-119.85228, 34.42193], [-119.85231, 34.42208], [-119.85241, 34.42211], [-119.8514, 34.42425], [-119.85141, 34.42427], [-119.85959, 34.42432]]]} | Restricted Access 2 | Goleta Slough Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Goleta-Slough-ER | 19383 | 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 | 382.485 | Goleta Slough ER | 1983 |
14498 | 14498 | 14497 | {"type": "MultiPolygon", "coordinates": [[[[-117.29913, 33.08782], [-117.296, 33.08783], [-117.2961, 33.09165], [-117.29506, 33.09132], [-117.29447, 33.09119], [-117.29399, 33.09112], [-117.29368, 33.09104], [-117.2933, 33.09101], [-117.29317, 33.09104], [-117.29273, 33.09131], [-117.29159, 33.09153], [-117.29145, 33.09161], [-117.29119, 33.09195], [-117.29122, 33.09209], [-117.29092, 33.09265], [-117.29069, 33.09263], [-117.29055, 33.09233], [-117.29061, 33.09211], [-117.29034, 33.09156], [-117.29014, 33.09155], [-117.28933, 33.09103], [-117.28869, 33.09113], [-117.28837, 33.09138], [-117.28839, 33.09145], [-117.28751, 33.09185], [-117.2875, 33.09199], [-117.28707, 33.09197], [-117.28667, 33.09191], [-117.28609, 33.09218], [-117.28594, 33.09219], [-117.2858, 33.09243], [-117.28541, 33.09235], [-117.28503, 33.09256], [-117.28438, 33.09257], [-117.28374, 33.09245], [-117.28356, 33.09233], [-117.28361, 33.0918], [-117.28297, 33.09161], [-117.28264, 33.09145], [-117.28199, 33.09146], [-117.28169, 33.09166], [-117.28148, 33.09218], [-117.28178, 33.09255], [-117.28098, 33.09295], [-117.28058, 33.09312], [-117.27922, 33.09404], [-117.27868, 33.09395], [-117.27849, 33.09399], [-117.27823, 33.09392], [-117.27784, 33.09398], [-117.27746, 33.09412], [-117.27715, 33.09402], [-117.27743, 33.09379], [-117.27735, 33.09356], [-117.27702, 33.09357], [-117.2769, 33.09367], [-117.27653, 33.09371], [-117.2765, 33.09377], [-117.27625, 33.09371], [-117.27628, 33.09347], [-117.27598, 33.09332], [-117.27567, 33.09331], [-117.27499, 33.09352], [-117.27495, 33.09385], [-117.27485, 33.09385], [-117.27477, 33.09351], [-117.27465, 33.09352], [-117.27448, 33.0933], [-117.27447, 33.09326], [-117.27439, 33.09324], [-117.27412, 33.09316], [-117.27415, 33.09309], [-117.27414, 33.09307], [-117.27356, 33.09311], [-117.27351, 33.09329], [-117.27326, 33.0933], [-117.27313, 33.09348], [-117.27233, 33.09352], [-117.27149, 33.09332], [-117.27162, 33.09308], [-117.27099, 33.09295], [-117.27071, 33.09282], [-117.27048, 33.09283], [-117.2703, 33.09301], [-117.27012, 33.09307], [-117.27011, 33.09336], [-117.26959, 33.09349], [-117.26939, 33.09361], [-117.26927, 33.09402], [-117.26884, 33.09406], [-117.2691, 33.09349], [-117.26905, 33.09328], [-117.26915, 33.09306], [-117.2692, 33.09274], [-117.2694, 33.09233], [-117.26939, 33.09232], [-117.26909, 33.09228], [-117.26959, 33.09091], [-117.26969, 33.09051], [-117.26974, 33.09005], [-117.26973, 33.08974], [-117.26968, 33.0893], [-117.26914, 33.08688], [-117.26907, 33.08645], [-117.26905, 33.08621], [-117.26895, 33.0858], [-117.26896, 33.08569], [-117.26901, 33.0856], [-117.2691, 33.08553], [-117.26921, 33.08549], [-117.26995, 33.08542], [-117.27001, 33.08634], [-117.27226, 33.08537], [-117.27266, 33.08545], [-117.27305, 33.08556], [-117.2735, 33.08574], [-117.27549, 33.08667], [-117.27723, 33.08753], [-117.27775, 33.08773], [-117.27833, 33.0879], [-117.27866, 33.08808], [-117.27893, 33.08802], [-117.2795, 33.08807], [-117.28, 33.08809], [-117.28049, 33.08806], [-117.28089, 33.08801], [-117.28337, 33.08757], [-117.28557, 33.08736], [-117.28897, 33.08739], [-117.29074, 33.08746], [-117.29403, 33.08635], [-117.29551, 33.08529], [-117.29563, 33.08547], [-117.29694, 33.08588], [-117.29866, 33.08722], [-117.29913, 33.08782]]], [[[-117.30633, 33.0891], [-117.30621, 33.08967], [-117.3061, 33.08989], [-117.30599, 33.09005], [-117.30585, 33.09021], [-117.30548, 33.09053], [-117.30534, 33.09068], [-117.30452, 33.09207], [-117.30327, 33.09029], [-117.3049, 33.08911], [-117.30633, 33.0891]]], [[[-117.30981, 33.08934], [-117.30886, 33.08952], [-117.30803, 33.08948], [-117.30787, 33.08951], [-117.30774, 33.08955], [-117.30768, 33.08964], [-117.30769, 33.0898], [-117.30752, 33.08981], [-117.30679, 33.0891], [-117.3097, 33.08909], [-117.30981, 33.08934]]], [[[-117.31196, 33.08767], [-117.31147, 33.08776], [-117.31087, 33.08784], [-117.31081, 33.08787], [-117.3108, 33.08792], [-117.31083, 33.08801], [-117.31145, 33.0887], [-117.31157, 33.08893], [-117.3115, 33.08908], [-117.31131, 33.08917], [-117.31094, 33.08932], [-117.3106, 33.0894], [-117.30986, 33.08747], [-117.31032, 33.08713], [-117.31097, 33.08695], [-117.31177, 33.08717], [-117.31196, 33.08767]]]]} | Restricted Access 2 | Batiquitos Lagoon Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Batiquitos-Lagoon-ER | 15864 | 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 | 410.729 | Batiquitos Lagoon ER | 1983 |
14532 | 14532 | 14531 | {"type": "MultiPolygon", "coordinates": [[[[-117.25116, 33.00742], [-117.25114, 33.00903], [-117.25115, 33.01098], [-117.24055, 33.01098], [-117.23939, 33.00941], [-117.24279, 33.00937], [-117.2428, 33.0092], [-117.24293, 33.00923], [-117.24295, 33.00922], [-117.24295, 33.00892], [-117.2428, 33.00883], [-117.24281, 33.00747], [-117.24445, 33.00745], [-117.24444, 33.00563], [-117.24552, 33.00564], [-117.24554, 33.00744], [-117.25116, 33.00742]]], [[[-117.24895, 33.02066], [-117.24723, 33.0218], [-117.24698, 33.0218], [-117.24696, 33.02001], [-117.24894, 33.02002], [-117.24895, 33.02066]]], [[[-117.25907, 33.01465], [-117.25889, 33.01488], [-117.25873, 33.01505], [-117.25836, 33.01536], [-117.25815, 33.0155], [-117.25784, 33.01568], [-117.25757, 33.0158], [-117.25711, 33.01597], [-117.25673, 33.01617], [-117.25651, 33.01633], [-117.25568, 33.01708], [-117.25569, 33.01468], [-117.25907, 33.01465]]], [[[-117.27291, 33.00739], [-117.26287, 33.00739], [-117.26203, 33.00689], [-117.26063, 33.00632], [-117.26065, 33.00625], [-117.26003, 33.00589], [-117.25972, 33.00557], [-117.25947, 33.00491], [-117.25957, 33.00483], [-117.25923, 33.00381], [-117.2588, 33.00344], [-117.25859, 33.00253], [-117.2588, 33.00172], [-117.25872, 33.00139], [-117.25829, 33.0005], [-117.25825, 33.0003], [-117.25846, 33.0003], [-117.2604, 33.00252], [-117.26197, 33.00312], [-117.26213, 33.00334], [-117.26214, 33.00387], [-117.26433, 33.00388], [-117.26433, 33.00262], [-117.2647, 33.00262], [-117.26472, 33.00248], [-117.26512, 33.00248], [-117.26513, 33.00208], [-117.26657, 33.00209], [-117.26659, 33.00211], [-117.2669, 33.00284], [-117.26699, 33.00292], [-117.26713, 33.00294], [-117.26724, 33.00291], [-117.2673, 33.00286], [-117.2678, 33.00198], [-117.26806, 33.00198], [-117.26818, 33.00279], [-117.26813, 33.00299], [-117.26835, 33.00318], [-117.26842, 33.0035], [-117.2686, 33.00363], [-117.26862, 33.00391], [-117.27038, 33.00393], [-117.2704, 33.00381], [-117.27061, 33.00383], [-117.27071, 33.00382], [-117.27089, 33.00376], [-117.27131, 33.00356], [-117.27158, 33.00354], [-117.27197, 33.00355], [-117.27209, 33.00359], [-117.27221, 33.0036], [-117.27224, 33.00361], [-117.2724, 33.00364], [-117.27248, 33.0037], [-117.27258, 33.0037], [-117.27269, 33.00406], [-117.27274, 33.00414], [-117.27287, 33.00423], [-117.27291, 33.00739]], [[-117.26716, 33.00301], [-117.26674, 33.00298], [-117.26688, 33.0036], [-117.26733, 33.00348], [-117.26726, 33.00298], [-117.26716, 33.00301]]], [[[-117.27505, 33.0139], [-117.275, 33.01393], [-117.27475, 33.01377], [-117.27434, 33.01359], [-117.27395, 33.01348], [-117.27374, 33.01345], [-117.27352, 33.01343], [-117.2735, 33.01315], [-117.27319, 33.01315], [-117.27309, 33.01322], [-117.27307, 33.01326], [-117.27304, 33.01336], [-117.27305, 33.01344], [-117.27284, 33.01347], [-117.27256, 33.01347], [-117.27231, 33.01344], [-117.272, 33.01337], [-117.27171, 33.01326], [-117.27134, 33.01306], [-117.27104, 33.01279], [-117.27096, 33.01269], [-117.27083, 33.01249], [-117.27404, 33.01107], [-117.27469, 33.01223], [-117.27472, 33.01331], [-117.27505, 33.0139]]]]} | Restricted Access 2 | San Elijo Lagoon Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Elijo-Lagoon-ER | 24877 | 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 | 268.698 | San Elijo Lagoon ER | 1983 |
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]);