About this Dataset

Inland Fisheries - Public Angling Estate

This feature class contains the polygon layer comprising the water bodies of the Public Angling Estate in Northern Ireland, and details all of the information for each fishery as set out in the Inland Fisheries 'Short Guide to Fisheries in the Public Angling Estate of Northern Ireland'. The polygons are derived from the February 2019 release of the 'Stand Water Polygon' and 'Water Course Polygon' layers from OSNI Fusion - a product from Ordnance Survey of Northern Ireland (OSNI). The layer is based on the coordinate system TM65 Irish Grid, and is linked to the 'PAE_OSNIFusion_Feb2019' table using a Relationship Class.
Publisher name: OpenDataNI
Last updated: 2022-07-01T04:01:55Z

Tables

Table 1

@ukgov.inland_fisheries_public_angling_estate2.table_1

33.7 kB
91 rows
33 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "pae_name" VARCHAR,
  "pae_area" VARCHAR,
  "water_type" VARCHAR,
  "licence_type_and_permit" VARCHAR,
  "season_open_game_fish" VARCHAR  -- Season Open - Game Fish,
  "season_closed_game_fish" VARCHAR  -- Season Closed - Game Fish,
  "season_open_coarse_fish" VARCHAR  -- Season Open - Coarse Fish,
  "season_closed_coarse_fish" VARCHAR  -- Season Closed - Coarse Fish,
  "bream" VARCHAR,
  "brown_trout" VARCHAR,
  "carp" VARCHAR,
  "dollaghan" VARCHAR,
  "gudgeon" VARCHAR,
  "hybrids" VARCHAR,
  "perch" VARCHAR,
  "pike" VARCHAR,
  "rainbow_trout" VARCHAR,
  "roach" VARCHAR,
  "rudd" VARCHAR,
  "salmon" VARCHAR,
  "sea_trout" VARCHAR,
  "tench" VARCHAR,
  "bag_limit_for_trout" VARCHAR,
  "bag_limit_for_salmon" VARCHAR,
  "bag_limit_for_pike" VARCHAR,
  "bag_limit_for_coarse" VARCHAR,
  "fishing_methods_and_byelaws" VARCHAR,
  "boats_allowed" VARCHAR,
  "county" VARCHAR,
  "globalid" VARCHAR,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);