superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, MNG_AG_TYP = 5 and YR_EST = 1997
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15357 | 15357 | 15356 | {"type": "Polygon", "coordinates": [[[-120.86553, 35.31438], [-120.86552, 35.31585], [-120.8655, 35.31606], [-120.86538, 35.31654], [-120.86541, 35.31685], [-120.86529, 35.31688], [-120.865, 35.31687], [-120.86458, 35.31689], [-120.86426, 35.31697], [-120.86413, 35.31703], [-120.86404, 35.31711], [-120.86391, 35.31729], [-120.86386, 35.31743], [-120.86381, 35.31751], [-120.86374, 35.31758], [-120.86367, 35.31773], [-120.86371, 35.31817], [-120.86375, 35.31829], [-120.86383, 35.31845], [-120.86386, 35.31857], [-120.86386, 35.31868], [-120.86376, 35.31884], [-120.86369, 35.31893], [-120.86335, 35.31904], [-120.86323, 35.3191], [-120.86315, 35.31919], [-120.86311, 35.31939], [-120.86315, 35.3196], [-120.86313, 35.31975], [-120.86302, 35.31987], [-120.86294, 35.32002], [-120.8629, 35.32029], [-120.86261, 35.32054], [-120.86251, 35.32093], [-120.86242, 35.32103], [-120.86216, 35.32114], [-120.86212, 35.32119], [-120.86209, 35.32155], [-120.86207, 35.32169], [-120.86197, 35.3221], [-120.86197, 35.32222], [-120.86211, 35.32244], [-120.86224, 35.32259], [-120.86251, 35.32307], [-120.86254, 35.32317], [-120.86255, 35.32329], [-120.86251, 35.3234], [-120.86231, 35.32361], [-120.86209, 35.3238], [-120.86175, 35.32403], [-120.86141, 35.32418], [-120.86105, 35.32437], [-120.86065, 35.32461], [-120.86048, 35.32478], [-120.8603, 35.32502], [-120.86023, 35.3253], [-120.86023, 35.32547], [-120.86025, 35.32573], [-120.86025, 35.32608], [-120.86023, 35.3264], [-120.86029, 35.3266], [-120.86054, 35.32725], [-120.86053, 35.32738], [-120.86048, 35.32749], [-120.8604, 35.32755], [-120.8603, 35.32761], [-120.86001, 35.32766], [-120.85982, 35.32775], [-120.85971, 35.32784], [-120.85957, 35.32796], [-120.85952, 35.3281], [-120.8595, 35.32826], [-120.85949, 35.32841], [-120.85953, 35.32853], [-120.85973, 35.32881], [-120.85994, 35.32905], [-120.86027, 35.32933], [-120.86032, 35.32942], [-120.86029, 35.32988], [-120.86023, 35.32999], [-120.86013, 35.33006], [-120.85999, 35.33011], [-120.85992, 35.33018], [-120.85981, 35.33046], [-120.85977, 35.33064], [-120.85962, 35.33094], [-120.85953, 35.33105], [-120.85949, 35.33116], [-120.8594, 35.33124], [-120.85932, 35.33136], [-120.8593, 35.3315], [-120.85926, 35.33201], [-120.85927, 35.33237], [-120.8594, 35.33251], [-120.85945, 35.33258], [-120.85945, 35.33268], [-120.85942, 35.3328], [-120.85933, 35.33299], [-120.85931, 35.33309], [-120.85934, 35.3332], [-120.85939, 35.33327], [-120.85943, 35.33338], [-120.85953, 35.33375], [-120.85966, 35.33394], [-120.85967, 35.33403], [-120.85961, 35.33426], [-120.85952, 35.33439], [-120.8594, 35.33444], [-120.85929, 35.33447], [-120.85897, 35.33448], [-120.85886, 35.3345], [-120.85853, 35.33465], [-120.8582, 35.33472], [-120.85774, 35.3348], [-120.85744, 35.33494], [-120.85735, 35.33506], [-120.85736, 35.33511], [-120.8574, 35.33516], [-120.85742, 35.33534], [-120.85748, 35.33545], [-120.85765, 35.33565], [-120.85773, 35.33584], [-120.85774, 35.3359], [-120.85771, 35.33604], [-120.85774, 35.33615], [-120.85771, 35.33618], [-120.8577, 35.33623], [-120.85776, 35.33641], [-120.85776, 35.33646], [-120.85772, 35.33653], [-120.85771, 35.33666], [-120.85771, 35.337], [-120.85774, 35.33706], [-120.85793, 35.33727], [-120.85806, 35.33746], [-120.85814, 35.33768], [-120.8582, 35.33788], [-120.85821, 35.33798], [-120.85819, 35.33806], [-120.85813, 35.33816], [-120.85823, 35.33869], [-120.85832, 35.33895], [-120.85871, 35.33968], [-120.85897, 35.34028], [-120.85911, 35.34088], [-120.8591, 35.34092], [-120.85881, 35.34108], [-120.85861, 35.34126], [-120.85847, 35.34148], [-120.85843, 35.34157], [-120.85841, 35.34176], [-120.85842, 35.34187], [-120.85845, 35.342], [-120.85844, 35.34212], [-120.8584, 35.34214], [-120.8583, 35.34216], [-120.85818, 35.34221], [-120.85809, 35.34227], [-120.85793, 35.3426], [-120.85792, 35.34267], [-120.85798, 35.34286], [-120.858, 35.34318], [-120.85803, 35.34323], [-120.85813, 35.34329], [-120.85818, 35.34328], [-120.8582, 35.34321], [-120.85824, 35.34321], [-120.85826, 35.34324], [-120.85826, 35.34332], [-120.85823, 35.3435], [-120.85819, 35.34361], [-120.85815, 35.34365], [-120.85782, 35.34366], [-120.85771, 35.34371], [-120.85764, 35.34377], [-120.85759, 35.34386], [-120.85757, 35.34411], [-120.85757, 35.34433], [-120.85756, 35.34443], [-120.85753, 35.3445], [-120.85725, 35.34472], [-120.85717, 35.34481], [-120.85703, 35.34506], [-120.85698, 35.34519], [-120.85696, 35.34531], [-120.85682, 35.34549], [-120.85646, 35.34586], [-120.85635, 35.34613], [-120.85631, 35.34616], [-120.85624, 35.34618], [-120.85614, 35.34639], [-120.85615, 35.34663], [-120.8561, 35.34688], [-120.85635, 35.34733], [-120.85669, 35.34759], [-120.8568, 35.3477], [-120.85706, 35.34804], [-120.85709, 35.3481], [-120.85709, 35.34823], [-120.85718, 35.34844], [-120.85737, 35.3487], [-120.85765, 35.34901], [-120.85797, 35.34927], [-120.85817, 35.34943], [-120.85836, 35.34953], [-120.85842, 35.34959], [-120.85862, 35.34983], [-120.85888, 35.3501], [-120.8593, 35.35076], [-120.85949, 35.3511], [-120.8598, 35.35285], [-120.8435, 35.34928], [-120.84339, 35.34885], [-120.84365, 35.34772], [-120.8439, 35.34737], [-120.84419, 35.34728], [-120.84433, 35.34699], [-120.84462, 35.34665], [-120.84442, 35.3464], [-120.84426, 35.3463], [-120.84344, 35.33164], [-120.84359, 35.33146], [-120.84421, 35.33057], [-120.8442, 35.33055], [-120.84479, 35.32897], [-120.84465, 35.3283], [-120.84226, 35.32727], [-120.84199, 35.32714], [-120.84115, 35.3268], [-120.84051, 35.32616], [-120.84035, 35.32593], [-120.84027, 35.32511], [-120.84041, 35.32436], [-120.84069, 35.3238], [-120.84157, 35.32248], [-120.84305, 35.32222], [-120.84319, 35.32215], [-120.84526, 35.32195], [-120.84642, 35.32149], [-120.84804, 35.32132], [-120.84815, 35.32137], [-120.84822, 35.32126], [-120.84986, 35.32176], [-120.85038, 35.32168], [-120.85046, 35.32165], [-120.85057, 35.32155], [-120.85063, 35.32158], [-120.85076, 35.32147], [-120.85091, 35.3214], [-120.85086, 35.32134], [-120.8521, 35.31941], [-120.85215, 35.3193], [-120.85317, 35.31855], [-120.85361, 35.3181], [-120.854, 35.31778], [-120.85604, 35.31827], [-120.86107, 35.31702], [-120.86109, 35.31665], [-120.86149, 35.3165], [-120.86209, 35.31614], [-120.86232, 35.31618], [-120.86299, 35.31589], [-120.86362, 35.31574], [-120.86427, 35.31555], [-120.86491, 35.31515], [-120.86527, 35.31474], [-120.86552, 35.31443], [-120.86553, 35.31438]]]} | Open Access 1 | Morro Bay Wildlife Area | 30475 | 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 | 1266.887 | Morro Bay Wildlife Area | 1997 | |
15360 | 15360 | 15359 | {"type": "Polygon", "coordinates": [[[-120.44787, 41.42527], [-120.44782, 41.42894], [-120.44775, 41.43226], [-120.44781, 41.43246], [-120.44775, 41.43252], [-120.44767, 41.43609], [-120.44282, 41.43607], [-120.44287, 41.43251], [-120.42832, 41.43248], [-120.4282, 41.44314], [-120.40862, 41.44283], [-120.40848, 41.42877], [-120.4057, 41.42856], [-120.40484, 41.42831], [-120.40443, 41.42816], [-120.4042, 41.42805], [-120.40388, 41.42803], [-120.40362, 41.42793], [-120.40324, 41.42773], [-120.40259, 41.42746], [-120.4023, 41.4274], [-120.40201, 41.42738], [-120.40166, 41.4274], [-120.40139, 41.42747], [-120.4011, 41.42748], [-120.40087, 41.42745], [-120.40069, 41.4274], [-120.40018, 41.42709], [-120.40005, 41.42679], [-120.39991, 41.42676], [-120.39983, 41.42671], [-120.39982, 41.42655], [-120.39975, 41.42646], [-120.39957, 41.42639], [-120.39921, 41.42616], [-120.39891, 41.42609], [-120.3986, 41.42605], [-120.39846, 41.42597], [-120.39828, 41.42589], [-120.39804, 41.42584], [-120.39777, 41.42554], [-120.39728, 41.42522], [-120.39708, 41.42512], [-120.39696, 41.42509], [-120.39632, 41.42507], [-120.39606, 41.42508], [-120.39511, 41.42495], [-120.39418, 41.42473], [-120.39373, 41.4247], [-120.3934, 41.42474], [-120.39316, 41.42486], [-120.39252, 41.42512], [-120.3922, 41.42521], [-120.39173, 41.4253], [-120.39148, 41.42532], [-120.39121, 41.42532], [-120.39091, 41.42529], [-120.39068, 41.42523], [-120.39045, 41.42515], [-120.39023, 41.42505], [-120.38995, 41.42498], [-120.38971, 41.42499], [-120.38884, 41.42509], [-120.3887, 41.42508], [-120.38809, 41.42477], [-120.38774, 41.4247], [-120.38749, 41.42461], [-120.38709, 41.42444], [-120.38672, 41.42432], [-120.38632, 41.42425], [-120.38548, 41.42425], [-120.38407, 41.42419], [-120.38362, 41.42412], [-120.38247, 41.42401], [-120.38166, 41.42406], [-120.38055, 41.42403], [-120.38005, 41.42398], [-120.37976, 41.42392], [-120.37909, 41.42371], [-120.37826, 41.42349], [-120.37777, 41.42335], [-120.37742, 41.42327], [-120.37705, 41.42327], [-120.37668, 41.4233], [-120.37637, 41.42335], [-120.37592, 41.42349], [-120.3757, 41.42352], [-120.37541, 41.42352], [-120.37518, 41.42348], [-120.37503, 41.42343], [-120.37465, 41.42338], [-120.37444, 41.42332], [-120.37432, 41.4232], [-120.37416, 41.42312], [-120.37398, 41.42309], [-120.37368, 41.42312], [-120.37344, 41.42311], [-120.37331, 41.42306], [-120.37316, 41.42286], [-120.37273, 41.42283], [-120.37226, 41.42271], [-120.3719, 41.42253], [-120.37145, 41.4222], [-120.37129, 41.42212], [-120.37066, 41.42197], [-120.36958, 41.42149], [-120.36914, 41.42141], [-120.36816, 41.42119], [-120.36796, 41.42119], [-120.3678, 41.42116], [-120.36764, 41.42111], [-120.36734, 41.42097], [-120.36724, 41.42088], [-120.36721, 41.4208], [-120.36709, 41.42068], [-120.3669, 41.4206], [-120.36647, 41.42049], [-120.36608, 41.42045], [-120.36573, 41.42045], [-120.36551, 41.42052], [-120.36535, 41.42054], [-120.36493, 41.4204], [-120.36463, 41.42035], [-120.36388, 41.42028], [-120.36346, 41.42026], [-120.36298, 41.42029], [-120.36224, 41.42026], [-120.36193, 41.42021], [-120.36167, 41.42013], [-120.36153, 41.42006], [-120.36135, 41.41992], [-120.36116, 41.41984], [-120.36042, 41.41964], [-120.35997, 41.41961], [-120.35941, 41.41952], [-120.35942, 41.41715], [-120.35461, 41.41713], [-120.35466, 41.41351], [-120.37011, 41.41356], [-120.37446, 41.41354], [-120.37439, 41.42113], [-120.38646, 41.42126], [-120.40888, 41.42134], [-120.40889, 41.42151], [-120.42851, 41.42161], [-120.43822, 41.42163], [-120.43816, 41.42525], [-120.44787, 41.42527]], [[-120.42407, 41.42367], [-120.42447, 41.42337], [-120.42453, 41.423], [-120.42432, 41.42243], [-120.42414, 41.42232], [-120.4235, 41.42232], [-120.42261, 41.422], [-120.42189, 41.42202], [-120.42116, 41.42223], [-120.42067, 41.42262], [-120.42065, 41.42285], [-120.42091, 41.423], [-120.42179, 41.4233], [-120.42319, 41.42405], [-120.42359, 41.42412], [-120.42401, 41.42388], [-120.42407, 41.42367]]]} | Open Access 1 | Pine Creek Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Pine-Creek-WA | 30487 | 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 | 2028.994 | Pine Creek Wildlife Area | 1997 |
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]);