superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AG_TYP = 5 and PARK_NAME = "Oroville Wildlife Area"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15359 | 15359 | 15358 | {"type": "MultiPolygon", "coordinates": [[[[-121.54375, 39.52569], [-121.54155, 39.53055], [-121.54011, 39.53059], [-121.54004, 39.52574], [-121.54375, 39.52569]]], [[[-121.63909, 39.45781], [-121.63593, 39.46013], [-121.63277, 39.46183], [-121.62966, 39.4628], [-121.62877, 39.46312], [-121.62603, 39.46435], [-121.62516, 39.46518], [-121.62484, 39.46532], [-121.61979, 39.46613], [-121.61833, 39.46686], [-121.61817, 39.47204], [-121.62668, 39.47195], [-121.62666, 39.47519], [-121.61572, 39.47804], [-121.61413, 39.47961], [-121.61341, 39.47945], [-121.61202, 39.47933], [-121.61162, 39.48073], [-121.61143, 39.48098], [-121.61145, 39.48497], [-121.60913, 39.48499], [-121.60907, 39.48263], [-121.60807, 39.48285], [-121.60682, 39.48288], [-121.60652, 39.48293], [-121.60406, 39.48287], [-121.60407, 39.48422], [-121.60481, 39.48423], [-121.60481, 39.48572], [-121.60257, 39.48643], [-121.60239, 39.48641], [-121.60232, 39.48637], [-121.602, 39.48579], [-121.60189, 39.48576], [-121.60178, 39.48582], [-121.60173, 39.48596], [-121.60232, 39.48809], [-121.60234, 39.48842], [-121.60241, 39.48995], [-121.6021, 39.49099], [-121.59976, 39.49116], [-121.59961, 39.49292], [-121.59774, 39.49322], [-121.59616, 39.49302], [-121.59598, 39.49353], [-121.59394, 39.49366], [-121.59388, 39.49476], [-121.59172, 39.49478], [-121.5916, 39.49648], [-121.59122, 39.49669], [-121.58998, 39.49673], [-121.58986, 39.4977], [-121.58931, 39.4979], [-121.58904, 39.49792], [-121.5884, 39.49791], [-121.58815, 39.49778], [-121.58819, 39.49753], [-121.58818, 39.49752], [-121.58456, 39.49729], [-121.58446, 39.49744], [-121.58404, 39.49753], [-121.58362, 39.49756], [-121.58331, 39.49747], [-121.58303, 39.49729], [-121.58284, 39.49584], [-121.58002, 39.49586], [-121.58016, 39.49506], [-121.58016, 39.49389], [-121.58032, 39.49331], [-121.57996, 39.49296], [-121.57972, 39.49129], [-121.57948, 39.49032], [-121.57867, 39.48812], [-121.57888, 39.48549], [-121.5791, 39.48539], [-121.58032, 39.47886], [-121.58056, 39.47822], [-121.58123, 39.47554], [-121.58276, 39.4743], [-121.58434, 39.47174], [-121.58545, 39.47129], [-121.58613, 39.47127], [-121.587, 39.47132], [-121.59454, 39.46749], [-121.59492, 39.46742], [-121.59593, 39.46752], [-121.5995, 39.46654], [-121.60218, 39.46537], [-121.60322, 39.46439], [-121.60379, 39.46377], [-121.60911, 39.46172], [-121.61032, 39.4618], [-121.61291, 39.46079], [-121.61367, 39.45918], [-121.61421, 39.45849], [-121.61509, 39.45794], [-121.61645, 39.45752], [-121.61794, 39.45763], [-121.61824, 39.45777], [-121.62605, 39.45744], [-121.62838, 39.45721], [-121.63306, 39.45654], [-121.63463, 39.45628], [-121.63566, 39.45589], [-121.63631, 39.45581], [-121.63677, 39.4558], [-121.63706, 39.45618], [-121.63871, 39.4578], [-121.63909, 39.45781]]], [[[-121.63801, 39.45189], [-121.63798, 39.45278], [-121.63778, 39.45305], [-121.63672, 39.4536], [-121.63442, 39.45486], [-121.63286, 39.4552], [-121.62613, 39.45565], [-121.62336, 39.45569], [-121.62156, 39.45607], [-121.61419, 39.45608], [-121.61338, 39.45628], [-121.61345, 39.45158], [-121.6057, 39.45171], [-121.60571, 39.45173], [-121.61327, 39.45176], [-121.61315, 39.45761], [-121.60675, 39.46139], [-121.60364, 39.4623], [-121.60362, 39.46221], [-121.60277, 39.46222], [-121.59734, 39.46567], [-121.59366, 39.46591], [-121.59469, 39.46272], [-121.59472, 39.46162], [-121.59694, 39.46124], [-121.5973, 39.46111], [-121.5982, 39.46071], [-121.5989, 39.46078], [-121.59926, 39.46076], [-121.59956, 39.46066], [-121.6003, 39.46049], [-121.60139, 39.45988], [-121.60276, 39.45886], [-121.60315, 39.45812], [-121.60361, 39.45718], [-121.60456, 39.45499], [-121.6049, 39.45418], [-121.60504, 39.45365], [-121.60539, 39.45268], [-121.60529, 39.45173], [-121.60548, 39.45171], [-121.60542, 39.45031], [-121.60666, 39.44526], [-121.60685, 39.4442], [-121.60704, 39.44237], [-121.60912, 39.44229], [-121.60905, 39.44075], [-121.60969, 39.44075], [-121.6099, 39.43933], [-121.61047, 39.43868], [-121.61046, 39.43799], [-121.61063, 39.43747], [-121.61128, 39.43711], [-121.61177, 39.43661], [-121.61208, 39.43575], [-121.61207, 39.43573], [-121.61175, 39.43564], [-121.61137, 39.43485], [-121.6115, 39.4344], [-121.61218, 39.43427], [-121.61271, 39.43349], [-121.6127, 39.43347], [-121.60966, 39.43352], [-121.60974, 39.42706], [-121.61086, 39.42698], [-121.61083, 39.42532], [-121.60703, 39.42525], [-121.60525, 39.42458], [-121.60528, 39.42264], [-121.62115, 39.42248], [-121.62129, 39.42174], [-121.61923, 39.42123], [-121.61913, 39.41172], [-121.62098, 39.4111], [-121.61892, 39.41015], [-121.61878, 39.40872], [-121.62224, 39.4097], [-121.62245, 39.40951], [-121.62368, 39.40964], [-121.6253, 39.41111], [-121.6264, 39.41184], [-121.62659, 39.41203], [-121.62735, 39.415], [-121.6273, 39.41556], [-121.62658, 39.4177], [-121.62603, 39.41797], [-121.62557, 39.41825], [-121.6247, 39.41913], [-121.6238, 39.42081], [-121.62351, 39.42246], [-121.62355, 39.42376], [-121.62353, 39.42549], [-121.62367, 39.426], [-121.62365, 39.42671], [-121.62411, 39.42742], [-121.62429, 39.42889], [-121.62437, 39.42918], [-121.62461, 39.42947], [-121.62609, 39.42962], [-121.62737, 39.43016], [-121.6276, 39.43049], [-121.62778, 39.43051], [-121.62799, 39.43045], [-121.62808, 39.43039], [-121.62844, 39.43046], [-121.62861, 39.43061], [-121.62889, 39.43092], [-121.63051, 39.43142], [-121.63097, 39.43161], [-121.63208, 39.43243], [-121.63298, 39.43239], [-121.63498, 39.43402], [-121.63557, 39.43458], [-121.63598, 39.43586], [-121.63618, 39.43626], [-121.63523, 39.43936], [-121.63542, 39.44056], [-121.6357, 39.4448], [-121.63563, 39.44626], [-121.6357, 39.44792], [-121.63549, 39.44937], [-121.6356, 39.44963], [-121.63731, 39.45104], [-121.63766, 39.45136], [-121.63801, 39.45189]]], [[[-121.6556, 39.45095], [-121.65469, 39.45243], [-121.65108, 39.45509], [-121.64987, 39.45554], [-121.64835, 39.45567], [-121.64642, 39.4555], [-121.64507, 39.45533], [-121.64252, 39.45585], [-121.64067, 39.45657], [-121.63968, 39.45737], [-121.63946, 39.45764], [-121.63921, 39.45718], [-121.63736, 39.45562], [-121.6372, 39.45544], [-121.63717, 39.45526], [-121.63794, 39.45427], [-121.6392, 39.4533], [-121.64007, 39.45173], [-121.63994, 39.45107], [-121.6396, 39.45051], [-121.63893, 39.44998], [-121.63807, 39.44761], [-121.63811, 39.44719], [-121.6377, 39.44407], [-121.63761, 39.44305], [-121.63779, 39.43854], [-121.63822, 39.43815], [-121.63831, 39.43774], [-121.63819, 39.43747], [-121.63793, 39.43723], [-121.63735, 39.43565], [-121.63675, 39.43437], [-121.63628, 39.43369], [-121.63545, 39.43376], [-121.6342, 39.43251], [-121.6337, 39.43234], [-121.63164, 39.43037], [-121.62809, 39.42911], [-121.62604, 39.42743], [-121.62488, 39.42628], [-121.62467, 39.42599], [-121.62469, 39.42432], [-121.62461, 39.42336], [-121.62478, 39.4229], [-121.62593, 39.42193], [-121.62609, 39.42036], [-121.62799, 39.41662], [-121.62849, 39.41551], [-121.62857, 39.41461], [-121.62847, 39.41347], [-121.62836, 39.41296], [-121.62745, 39.41113], [-121.62705, 39.41092], [-121.62609, 39.41063], [-121.62568, 39.4101], [-121.6248, 39.40919], [-121.6232, 39.40871], [-121.62051, 39.40826], [-121.61944, 39.40766], [-121.61897, 39.40695], [-121.61811, 39.40652], [-121.61798, 39.40632], [-121.61821, 39.40572], [-121.6186, 39.40394], [-121.61888, 39.40357], [-121.61987, 39.40117], [-121.62056, 39.39776], [-121.62061, 39.39712], [-121.62125, 39.39624], [-121.62169, 39.39622], [-121.62191, 39.39596], [-121.62615, 39.39584], [-121.62983, 39.39581], [-121.62995, 39.40135], [-121.63086, 39.4014], [-121.63091, 39.40484], [-121.63678, 39.40493], [-121.63677, 39.40894], [-121.63475, 39.40904], [-121.63469, 39.41271], [-121.631, 39.41275], [-121.62969, 39.41273], [-121.62961, 39.41635], [-121.62963, 39.41636], [-121.63163, 39.41633], [-121.63176, 39.41636], [-121.6348, 39.41635], [-121.635, 39.42064], [-121.63743, 39.42079], [-121.6374, 39.42295], [-121.63698, 39.42298], [-121.63451, 39.42309], [-121.6345, 39.42311], [-121.63885, 39.42749], [-121.63887, 39.42747], [-121.63884, 39.42658], [-121.6419, 39.42651], [-121.64208, 39.42666], [-121.64221, 39.42685], [-121.6422, 39.42831], [-121.64098, 39.42834], [-121.64106, 39.43089], [-121.64484, 39.43261], [-121.64495, 39.43571], [-121.64569, 39.43565], [-121.64577, 39.43677], [-121.64582, 39.43704], [-121.64653, 39.43844], [-121.64655, 39.43903], [-121.64643, 39.43935], [-121.64608, 39.43951], [-121.64608, 39.43958], [-121.64592, 39.43958], [-121.64588, 39.4396], [-121.64434, 39.4396], [-121.64172, 39.43963], [-121.64213, 39.44653], [-121.64107, 39.44666], [-121.64109, 39.44739], [-121.64145, 39.44743], [-121.64145, 39.4483], [-121.64073, 39.44919], [-121.64049, 39.45105], [-121.64263, 39.4511], [-121.64265, 39.45112], [-121.64266, 39.45111], [-121.64388, 39.45225], [-121.64672, 39.45229], [-121.64681, 39.45102], [-121.6556, 39.45095]], [[-121.62384, 39.40503], [-121.62385, 39.40505], [-121.62628, 39.40498], [-121.62628, 39.40146], [-121.62378, 39.40139], [-121.62384, 39.40503]]], [[[-121.68786, 39.50861], [-121.68683, 39.50855], [-121.68308, 39.5106], [-121.68135, 39.51232], [-121.6759, 39.51391], [-121.67491, 39.51321], [-121.67341, 39.51442], [-121.66721, 39.51475], [-121.66594, 39.5107], [-121.66369, 39.50904], [-121.65854, 39.51198], [-121.65758, 39.51108], [-121.65748, 39.50875], [-121.65681, 39.50894], [-121.65631, 39.50873], [-121.65774, 39.50645], [-121.65892, 39.50545], [-121.65892, 39.50544], [-121.65098, 39.50565], [-121.65099, 39.49986], [-121.65103, 39.49785], [-121.65352, 39.49728], [-121.65413, 39.49432], [-121.6587, 39.49303], [-121.66177, 39.49404], [-121.662, 39.4944], [-121.66276, 39.4942], [-121.66224, 39.49323], [-121.66309, 39.49191], [-121.6614, 39.49079], [-121.66153, 39.48389], [-121.66535, 39.48559], [-121.66539, 39.48381], [-121.66677, 39.48328], [-121.66655, 39.4813], [-121.66062, 39.47835], [-121.65738, 39.4779], [-121.65375, 39.47571], [-121.65374, 39.47573], [-121.65578, 39.47959], [-121.65446, 39.48216], [-121.6506, 39.48286], [-121.64918, 39.48216], [-121.64745, 39.4833], [-121.64439, 39.48151], [-121.64191, 39.47573], [-121.63928, 39.47422], [-121.63914, 39.47235], [-121.63676, 39.47241], [-121.63499, 39.47354], [-121.63218, 39.47109], [-121.63191, 39.46883], [-121.62765, 39.46936], [-121.62712, 39.46851], [-121.62699, 39.46789], [-121.62712, 39.46719], [-121.62746, 39.46643], [-121.62793, 39.46565], [-121.62912, 39.4645], [-121.62986, 39.46389], [-121.63749, 39.45971], [-121.63833, 39.45909], [-121.64162, 39.4566], [-121.64265, 39.45619], [-121.64336, 39.45596], [-121.64436, 39.45586], [-121.6454, 39.45579], [-121.64752, 39.45604], [-121.64861, 39.45606], [-121.65028, 39.45593], [-121.65211, 39.45532], [-121.65297, 39.45491], [-121.65674, 39.45179], [-121.6571, 39.45169], [-121.65754, 39.45173], [-121.68052, 39.45139], [-121.68195, 39.45125], [-121.68574, 39.45113], [-121.6863, 39.45122], [-121.68679, 39.45142], [-121.6871, 39.45178], [-121.68705, 39.4522], [-121.68732, 39.46191], [-121.68679, 39.46462], [-121.68677, 39.46518], [-121.68677, 39.46578], [-121.68728, 39.46877], [-121.68715, 39.47011], [-121.68734, 39.49148], [-121.68708, 39.492], [-121.68589, 39.49268], [-121.68547, 39.493], [-121.68523, 39.49364], [-121.6851, 39.49375], [-121.68128, 39.49361], [-121.68116, 39.49399], [-121.68118, 39.494], [-121.68528, 39.49414], [-121.68529, 39.49463], [-121.68544, 39.49509], [-121.68606, 39.49559], [-121.6871, 39.49588], [-121.68741, 39.49606], [-121.68758, 39.49628], [-121.68767, 39.49656], [-121.68791, 39.49998], [-121.68784, 39.50549], [-121.68608, 39.50493], [-121.68586, 39.50533], [-121.68771, 39.50608], [-121.68786, 39.50861]]]]} | Open Access 1 | Oroville Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Oroville-WA | 30484 | 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 | 11619.308 | Oroville Wildlife Area | 1968 |
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]);