superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where MNG_AG_ID = 348 and MNG_AG_LEV = 3
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
219 | 219 | 218 | {"type": "Polygon", "coordinates": [[[-123.98647, 40.49898], [-123.98241, 40.49898], [-123.97734, 40.49932], [-123.9773, 40.4995], [-123.97607, 40.49958], [-123.97481, 40.49962], [-123.97472, 40.49964], [-123.97325, 40.4994], [-123.97166, 40.49876], [-123.97059, 40.49784], [-123.97027, 40.49748], [-123.96992, 40.49649], [-123.96947, 40.49486], [-123.96915, 40.49332], [-123.96936, 40.49281], [-123.96941, 40.49162], [-123.96928, 40.4893], [-123.96926, 40.48925], [-123.96865, 40.48863], [-123.9678, 40.48728], [-123.96424, 40.48356], [-123.96509, 40.48276], [-123.96537, 40.48234], [-123.96645, 40.48135], [-123.96749, 40.48067], [-123.96847, 40.4811], [-123.96835, 40.48206], [-123.96841, 40.48325], [-123.96842, 40.48452], [-123.96814, 40.48582], [-123.9682, 40.48695], [-123.96855, 40.48777], [-123.96878, 40.48789], [-123.97058, 40.48784], [-123.9724, 40.48728], [-123.97416, 40.48663], [-123.97595, 40.48657], [-123.97741, 40.48698], [-123.97872, 40.48785], [-123.97866, 40.48895], [-123.9771, 40.48895], [-123.97454, 40.48917], [-123.9726, 40.49005], [-123.97195, 40.49104], [-123.97175, 40.49173], [-123.97174, 40.49269], [-123.97193, 40.49387], [-123.9721, 40.49487], [-123.97299, 40.49584], [-123.974, 40.49668], [-123.97488, 40.49748], [-123.97611, 40.49812], [-123.97683, 40.4987], [-123.97767, 40.49848], [-123.97942, 40.49699], [-123.98167, 40.49559], [-123.98244, 40.49577], [-123.98336, 40.49653], [-123.98467, 40.49758], [-123.98544, 40.49776], [-123.98593, 40.49717], [-123.98641, 40.49678], [-123.98651, 40.49858], [-123.98647, 40.49898]]]} | Open Access 1 | Van Duzen Park | http://www.humboldtgov.org/1592/County-Parks-Facilities | 4515 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 212.15 | Van Duzen Park | |
604 | 604 | 603 | {"type": "MultiPolygon", "coordinates": [[[[-124.11238, 40.99434], [-124.11197, 40.9942], [-124.11155, 40.99394], [-124.11106, 40.99357], [-124.11072, 40.99337], [-124.11036, 40.99314], [-124.11011, 40.99306], [-124.1101, 40.9927], [-124.11013, 40.99039], [-124.11077, 40.9904], [-124.11142, 40.99138], [-124.11163, 40.99163], [-124.11185, 40.99267], [-124.11182, 40.99282], [-124.11173, 40.99291], [-124.11153, 40.99316], [-124.11153, 40.9933], [-124.11157, 40.99346], [-124.11191, 40.99371], [-124.11229, 40.99415], [-124.11238, 40.99434]]], [[[-124.11253, 40.99492], [-124.1125, 40.99629], [-124.11235, 40.99698], [-124.11014, 40.99694], [-124.11015, 40.99329], [-124.11047, 40.99343], [-124.11077, 40.99358], [-124.111, 40.99378], [-124.11158, 40.99418], [-124.11211, 40.99443], [-124.11239, 40.9945], [-124.11252, 40.9946], [-124.11253, 40.99492]]], [[[-124.11554, 40.98526], [-124.11482, 40.98939], [-124.1139, 40.99205], [-124.11328, 40.99308], [-124.11305, 40.99355], [-124.11235, 40.99342], [-124.11214, 40.99295], [-124.11195, 40.99348], [-124.11188, 40.99344], [-124.1118, 40.99337], [-124.11179, 40.99327], [-124.11184, 40.99315], [-124.11196, 40.993], [-124.11209, 40.99286], [-124.11209, 40.99279], [-124.11201, 40.99212], [-124.11194, 40.99179], [-124.11196, 40.99167], [-124.11169, 40.99137], [-124.11135, 40.99082], [-124.11125, 40.9907], [-124.11021, 40.98912], [-124.1104, 40.98913], [-124.11355, 40.98921], [-124.11359, 40.98887], [-124.11172, 40.98595], [-124.11127, 40.98529], [-124.11284, 40.98529], [-124.11554, 40.98526]]], [[[-124.12799, 40.95635], [-124.12792, 40.95711], [-124.12754, 40.95802], [-124.12705, 40.95878], [-124.12667, 40.95964], [-124.12598, 40.96114], [-124.1258, 40.96174], [-124.12572, 40.96226], [-124.1255, 40.96276], [-124.1254, 40.96332], [-124.12539, 40.96377], [-124.12473, 40.96575], [-124.124, 40.96809], [-124.12261, 40.97101], [-124.12089, 40.97536], [-124.1205, 40.97811], [-124.12029, 40.98041], [-124.11816, 40.98047], [-124.11779, 40.98205], [-124.12014, 40.982], [-124.11935, 40.98526], [-124.11842, 40.98926], [-124.11778, 40.99153], [-124.1173, 40.99425], [-124.11721, 40.99439], [-124.11715, 40.9946], [-124.11718, 40.99501], [-124.11692, 40.99575], [-124.11676, 40.9963], [-124.11664, 40.99644], [-124.11664, 40.99676], [-124.11647, 40.99779], [-124.11616, 40.99931], [-124.11613, 40.99977], [-124.116, 41.0004], [-124.11584, 41.00151], [-124.11552, 41.00338], [-124.11518, 41.0051], [-124.11492, 41.00587], [-124.11479, 41.00679], [-124.11381, 41.00676], [-124.11166, 41.00675], [-124.11202, 41.00575], [-124.11257, 41.00368], [-124.11309, 41.00035], [-124.11346, 40.99777], [-124.11345, 40.99775], [-124.11316, 40.99775], [-124.1136, 40.99545], [-124.11438, 40.99282], [-124.11473, 40.99281], [-124.11472, 40.99264], [-124.11512, 40.99162], [-124.11587, 40.98928], [-124.11684, 40.98531], [-124.11683, 40.98529], [-124.11659, 40.9853], [-124.11757, 40.98077], [-124.11775, 40.97936], [-124.11776, 40.97838], [-124.11761, 40.9757], [-124.11856, 40.9709], [-124.11884, 40.9709], [-124.12008, 40.96751], [-124.12054, 40.96633], [-124.12079, 40.96562], [-124.1209, 40.96506], [-124.12084, 40.96415], [-124.12107, 40.9626], [-124.12138, 40.96172], [-124.1213, 40.96168], [-124.12179, 40.96025], [-124.12239, 40.95866], [-124.12262, 40.95793], [-124.12278, 40.95701], [-124.12297, 40.95632], [-124.12799, 40.95635]]]]} | Open Access 1 | Clam Beach County Park | http://co.humboldt.ca.us/portal/living/county_parks/default.asp?parkID=CLAM | 4510 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 462.336 | Clam Beach County Park | |
1604 | 1604 | 1603 | {"type": "Polygon", "coordinates": [[[-124.23254, 40.26773], [-124.2322, 40.26878], [-124.2322, 40.26882], [-124.23085, 40.26907], [-124.23083, 40.26963], [-124.22952, 40.26963], [-124.22932, 40.26935], [-124.22906, 40.2691], [-124.22878, 40.26892], [-124.22853, 40.2688], [-124.22824, 40.26872], [-124.22783, 40.26872], [-124.22766, 40.26887], [-124.22753, 40.26908], [-124.22742, 40.2694], [-124.22737, 40.26964], [-124.22653, 40.26964], [-124.22663, 40.26911], [-124.22669, 40.2689], [-124.22677, 40.26883], [-124.22696, 40.26874], [-124.22714, 40.26859], [-124.22729, 40.26841], [-124.22743, 40.26818], [-124.22764, 40.26797], [-124.22769, 40.2677], [-124.22769, 40.26741], [-124.22774, 40.26713], [-124.22776, 40.26676], [-124.22796, 40.2665], [-124.22833, 40.26628], [-124.22869, 40.2662], [-124.23016, 40.26621], [-124.23062, 40.26624], [-124.23196, 40.26648], [-124.2323, 40.26669], [-124.23243, 40.2669], [-124.23252, 40.26726], [-124.23254, 40.26773]]]} | Open Access 1 | Arthur W. Way Park | 15641 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 33.388 | Arthur W. Way Park | ||
4812 | 4812 | 4811 | {"type": "Polygon", "coordinates": [[[-123.99351, 40.88039], [-123.99291, 40.88117], [-123.99172, 40.88062], [-123.99228, 40.87997], [-123.99351, 40.88039]]]} | Open Access 1 | Gymkhana Field | 19579 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 2.641 | Gymkhana Field | ||
6504 | 6504 | 6503 | {"type": "Polygon", "coordinates": [[[-124.1405, 40.9168], [-124.13948, 40.91945], [-124.13918, 40.92099], [-124.13862, 40.92235], [-124.13723, 40.92536], [-124.1361, 40.92829], [-124.13591, 40.92864], [-124.13588, 40.92955], [-124.1358, 40.93084], [-124.13559, 40.93173], [-124.13514, 40.93311], [-124.135, 40.93361], [-124.13459, 40.93468], [-124.13456, 40.93442], [-124.13006, 40.93436], [-124.13004, 40.93449], [-124.12991, 40.9342], [-124.12991, 40.93361], [-124.12993, 40.93336], [-124.12993, 40.93311], [-124.13003, 40.93278], [-124.13008, 40.93251], [-124.13002, 40.93218], [-124.12999, 40.93184], [-124.12972, 40.9315], [-124.12972, 40.9312], [-124.12966, 40.93091], [-124.12956, 40.92928], [-124.12961, 40.92819], [-124.12975, 40.92698], [-124.13003, 40.92698], [-124.12996, 40.9278], [-124.12996, 40.92821], [-124.13014, 40.92835], [-124.13075, 40.92864], [-124.13105, 40.92873], [-124.13128, 40.92879], [-124.13189, 40.92884], [-124.13227, 40.92893], [-124.13306, 40.9292], [-124.13326, 40.92933], [-124.13342, 40.9295], [-124.13357, 40.92927], [-124.13413, 40.92957], [-124.13494, 40.9274], [-124.13702, 40.92214], [-124.1392, 40.91654], [-124.1405, 40.9168]]]} | Open Access 1 | Mad River County Park | 21640 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 116.363 | Mad River County Park | ||
7183 | 7183 | 7182 | {"type": "MultiPolygon", "coordinates": [[[[-124.11352, 41.03153], [-124.11281, 41.03154], [-124.11251, 41.03149], [-124.11199, 41.03171], [-124.11142, 41.03101], [-124.11142, 41.03073], [-124.11175, 41.03043], [-124.11174, 41.03018], [-124.11109, 41.03014], [-124.11109, 41.02998], [-124.11142, 41.03006], [-124.11152, 41.03006], [-124.11161, 41.03002], [-124.11164, 41.02992], [-124.11161, 41.02986], [-124.1115, 41.02976], [-124.11194, 41.02927], [-124.11252, 41.02921], [-124.11268, 41.02967], [-124.11292, 41.02999], [-124.11297, 41.03043], [-124.11352, 41.03153]]], [[[-124.11154, 41.02993], [-124.11152, 41.02998], [-124.11143, 41.02999], [-124.11111, 41.02991], [-124.11137, 41.02992], [-124.11145, 41.02982], [-124.1115, 41.02986], [-124.11154, 41.02993]]]]} | Open Access 1 | Moonstone Beach County Park | 22454 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 7.606 | Moonstone Beach County Park | ||
10388 | 10388 | 10387 | {"type": "Polygon", "coordinates": [[[-123.79899, 40.09038], [-123.79816, 40.09043], [-123.79723, 40.09053], [-123.79654, 40.09066], [-123.79587, 40.09113], [-123.79544, 40.08958], [-123.79611, 40.08922], [-123.79668, 40.08901], [-123.79717, 40.08896], [-123.79765, 40.0889], [-123.79809, 40.08892], [-123.79853, 40.08904], [-123.79868, 40.08913], [-123.79883, 40.08954], [-123.79898, 40.09026], [-123.79899, 40.09038]]]} | Open Access 1 | Tooby Memorial Park | 26400 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 11.824 | Tooby Memorial Park | ||
11715 | 11715 | 11714 | {"type": "Polygon", "coordinates": [[[-124.13354, 41.16255], [-124.1334, 41.16295], [-124.13222, 41.1637], [-124.13198, 41.1638], [-124.13182, 41.16385], [-124.13171, 41.16386], [-124.13145, 41.16382], [-124.13112, 41.16353], [-124.13059, 41.16298], [-124.13059, 41.16293], [-124.13063, 41.16285], [-124.13182, 41.16266], [-124.13212, 41.1625], [-124.13219, 41.16248], [-124.13249, 41.16255], [-124.13277, 41.16255], [-124.13325, 41.16251], [-124.13354, 41.16255]]]} | Open Access 1 | Big Lagoon Park | http://www.redwoods.info/showrecord.asp?id=1581 | 28318 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 5.584 | Big Lagoon Park | |
12055 | 12055 | 12054 | {"type": "Polygon", "coordinates": [[[-124.21445, 40.77156], [-124.2134, 40.7727], [-124.21288, 40.77334], [-124.21022, 40.77332], [-124.21322, 40.77091], [-124.21357, 40.77045], [-124.21445, 40.77156]]]} | Open Access 1 | Samoa Boat Ramp County Park | 30519 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 12.044 | Samoa Boat Ramp County Park | ||
13240 | 13240 | 13239 | {"type": "Polygon", "coordinates": [[[-124.05116, 40.7557], [-124.05103, 40.75618], [-124.04968, 40.75812], [-124.04942, 40.75783], [-124.0492, 40.75749], [-124.04903, 40.75714], [-124.04894, 40.75682], [-124.04935, 40.75622], [-124.04958, 40.75585], [-124.04974, 40.75546], [-124.04981, 40.75519], [-124.0507, 40.75519], [-124.05116, 40.7557]]]} | Open Access 1 | Freshwater Park | http://co.humboldt.ca.us/portal/living/county_parks/default.asp?parkID=FP | 30520 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 8.276 | Freshwater Park | |
14334 | 14334 | 14333 | {"type": "Polygon", "coordinates": [[[-123.96182, 40.47601], [-123.96157, 40.47625], [-123.96067, 40.47662], [-123.95893, 40.478], [-123.95764, 40.47896], [-123.95666, 40.48], [-123.95668, 40.4767], [-123.95728, 40.4765], [-123.95804, 40.47633], [-123.9587, 40.47616], [-123.95966, 40.47599], [-123.96182, 40.47601]]]} | Restricted Access 2 | Unnamed site - Humboldt, County of | 29996 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 19.487 | |||
15537 | 15537 | 15536 | {"type": "Polygon", "coordinates": [[[-124.35159, 40.57354], [-124.35147, 40.57383], [-124.35066, 40.57367], [-124.35064, 40.57382], [-124.3494, 40.57383], [-124.34941, 40.57334], [-124.35087, 40.57312], [-124.35077, 40.57344], [-124.35159, 40.57354]]]} | Open Access 1 | Centerville Beach | 17041 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 2.346 | Centerville Beach |
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]);