Bedrock Polygon

OpenDataNI

@ukgov.bedrock_polygon2

Table List

1 table(64.03 KB)

Table 1

@ukgov.bedrock_polygon2.table_1

64.03 KB
1280 rows
17 columns

objectid OBJECTID	lex LEX	lexicondesc LEXICONDESC	lex_rcs_sigma LEX RCS SIGMA	rcs_sigma RCS SIGMA	rcs_sigma_exp RCS SIGMA EXP	rcs_sigma_desc RCS SIGMA DESC	lex_rcs_sigma_index LEX RCS SIGMA INDEX	lex_rcs_sigma_desc LEX RCS SIGMA DESC	bgsref BGSREF	lex_web LEX WEB	rcs_web RCS WEB	source SOURCE	shape_length SHAPE Length	shape_area SHAPE Area
4166	CDLM	CARLINGFORD LIMESTONE GROUP	CDLM-LMST	LMST	LMST	LIMESTONE	13212215_CDLM-LMST	CARLINGFORD LIMESTONE GROUP - LIMESTONE	260	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=CDLM	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=LMST	1:250 000 scale	6780.10094957282	1940682.72211342
4167	SGD	SLIEVE GULLION COMPLEX	SGD-FELS	FELS	FELS	FELSITE	11399999_SGD-FELS	SLIEVE GULLION COMPLEX - FELSITE	804	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=SGD	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=FELS	1:250 000 scale	1544.42740389687	18302.6503467143
4168	HWK	HAWICK GROUP	HWK-SDST	SDST	SDST	SANDSTONE	13404999_HWK-SDST	HAWICK GROUP - SANDSTONE	122	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=HWK	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=SDST	1:250 000 scale	187.921098554985	46.6144217093836
4169	NEGD2	NEWRY GRANODIORITE COMPLEX PHASE 2	NEGD2-GD	GD	GD	GRANODIORITE	13399999_NEGD2-GD	NEWRY GRANODIORITE COMPLEX PHASE 2 - GRANODIORITE	406	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=NEGD2	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=GD	1:250 000 scale	2101.64056000225	47893.1519862159
4170	HWK	HAWICK GROUP	HWK-SDST	SDST	SDST	SANDSTONE	13404999_HWK-SDST	HAWICK GROUP - SANDSTONE	122	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=HWK	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=SDST	1:250 000 scale	5452.82004348614	191433.034103009
4171	HWK	HAWICK GROUP	HWK-SDST	SDST	SDST	SANDSTONE	13404999_HWK-SDST	HAWICK GROUP - SANDSTONE	122	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=HWK	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=SDST	1:250 000 scale	26787.8752652839	15816166.0529497
4172	NEGD2	NEWRY GRANODIORITE COMPLEX PHASE 2	NEGD2-GD	GD	GD	GRANODIORITE	13399999_NEGD2-GD	NEWRY GRANODIORITE COMPLEX PHASE 2 - GRANODIORITE	406	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=NEGD2	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=GD	1:250 000 scale	2901.42826823809	193269.342722619
4173	GALA	GALA GROUP	GALA-SDST	SDST	SDST	SANDSTONE	13404399_GALA-SDST	GALA GROUP - SANDSTONE	352	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=GALA	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=SDST	1:250 000 scale	3628.72943443584	598783.000998872
4174	NEGD2	NEWRY GRANODIORITE COMPLEX PHASE 2	NEGD2-GD	GD	GD	GRANODIORITE	13399999_NEGD2-GD	NEWRY GRANODIORITE COMPLEX PHASE 2 - GRANODIORITE	406	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=NEGD2	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=GD	1:250 000 scale	1754.69230502622	108344.046477661
4175	NEGD2	NEWRY GRANODIORITE COMPLEX PHASE 2	NEGD2-GD	GD	GD	GRANODIORITE	13399999_NEGD2-GD	NEWRY GRANODIORITE COMPLEX PHASE 2 - GRANODIORITE	406	http://www.bgs.ac.uk/Lexicon/lexicon.cfm?pub=NEGD2	http://www.bgs.ac.uk/bgsrcs/rcs_details.cfm?code=GD	1:250 000 scale	4791.50077567113	804128.271926246


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "lex" VARCHAR,
  "lexicondesc" VARCHAR,
  "lex_rcs_sigma" VARCHAR,
  "rcs_sigma" VARCHAR,
  "rcs_sigma_exp" VARCHAR,
  "rcs_sigma_desc" VARCHAR,
  "lex_rcs_sigma_index" VARCHAR,
  "lex_rcs_sigma_desc" VARCHAR,
  "bgsref" BIGINT,
  "shape_length_1" DOUBLE,
  "shape_area_1" DOUBLE,
  "lex_web" VARCHAR,
  "rcs_web" VARCHAR,
  "source" VARCHAR,
  "shape_length" DOUBLE,
  "shape_area" DOUBLE
);