Coastal Superficial Geology

OpenDataNI

@ukgov.coastal_superficial_geology

Table List

1 table(81.74 KB)

Table 1

@ukgov.coastal_superficial_geology.table_1

81.74 KB
2899 rows
12 columns

objectid OBJECTID	lex LEX	lex_d LEX D	rcs RCS	rcs_d RCS D	lex_rcs LEX RCS	lex_rcs_d LEX RCS D	lex_web LEX WEB	rcs_web RCS WEB	released RELEASED	shape_area Shape, Area	shape_length Shape, Length
1	COLV	Colluvium	XVSZ	Gravel, sand and silt [UDCS-X]	COLV-XVSZ	Colluvium-Gravel, sand and silt [UDCS-X]	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=COLV	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=XVSZ	15-12-2023	2289.06715393066	321.179647708717
2	COLV	Colluvium	XVSZ	Gravel, sand and silt [UDCS-X]	COLV-XVSZ	Colluvium-Gravel, sand and silt [UDCS-X]	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=COLV	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=XVSZ	15-12-2023	5209.41889953613	499.547697319431
3	BCHD	Beach deposits	XSVB	Sand, gravel and boulders [UDCS-X]	BCHD-XSVB	Beach deposits-Sand, gravel and boulders [UDCS-X]	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=BCHD	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=XSVB	15-12-2023	27641.6299133301	1614.0722600909
4	BCHD	Beach deposits	XSVB	Sand, gravel and boulders [UDCS-X]	BCHD-XSVB	Beach deposits-Sand, gravel and boulders [UDCS-X]	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=BCHD	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=XSVB	15-12-2023	3642.80339813232	407.457802241594
5	BCHD	Beach deposits	XSVB	Sand, gravel and boulders [UDCS-X]	BCHD-XSVB	Beach deposits-Sand, gravel and boulders [UDCS-X]	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=BCHD	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=XSVB	15-12-2023	6291.81283569336	721.626190942736
6	BCHD	Beach deposits	XSVB	Sand, gravel and boulders [UDCS-X]	BCHD-XSVB	Beach deposits-Sand, gravel and boulders [UDCS-X]	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=BCHD	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=XSVB	15-12-2023	5084.93003082275	1171.29145830987
7	BCHD	Beach deposits	XSVB	Sand, gravel and boulders [UDCS-X]	BCHD-XSVB	Beach deposits-Sand, gravel and boulders [UDCS-X]	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=BCHD	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=XSVB	15-12-2023	1573.602684021	420.589790574947
8	BCHD	Beach deposits	XSVB	Sand, gravel and boulders [UDCS-X]	BCHD-XSVB	Beach deposits-Sand, gravel and boulders [UDCS-X]	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=BCHD	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=XSVB	15-12-2023	3577.91583251953	660.03274798469
9	BCHD	Beach deposits	XSVB	Sand, gravel and boulders [UDCS-X]	BCHD-XSVB	Beach deposits-Sand, gravel and boulders [UDCS-X]	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=BCHD	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=XSVB	15-12-2023	817.124244689941	310.491330268437
10	BCHD	Beach deposits	XSVB	Sand, gravel and boulders [UDCS-X]	BCHD-XSVB	Beach deposits-Sand, gravel and boulders [UDCS-X]	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=BCHD	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=XSVB	15-12-2023	11454.2272109985	2062.61126512383


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "lex" VARCHAR,
  "lex_d" VARCHAR,
  "rcs" VARCHAR,
  "rcs_d" VARCHAR,
  "lex_rcs" VARCHAR,
  "lex_rcs_d" VARCHAR,
  "lex_web" VARCHAR,
  "rcs_web" VARCHAR,
  "released" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);