superunits_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

12 rows where LAYER = 3, MNG_AGENCY = 545 and MNG_AG_TYP = 3

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • County Agency · 12 ✖

MNG_AGENCY 1

  • Humboldt, County of · 12 ✖
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

CSV options: 

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]);