Bedrock Polygon

OpenDataNI

@ukgov.bedrock_polygon11

Table List

1 table(60.03 KB)

Table 1

@ukgov.bedrock_polygon11.table_1

60.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_area Shape, Area	shape_length Shape, Length
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	1940682.7220993	6780.10094957282
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	18302.6503448486	1544.42740389687
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	46.6144332885742	187.921098554985
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	47893.1519622803	2101.64056000225
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	191433.034118652	5452.82004348614
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	15816166.0528946	26787.8752652839
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	193269.342712402	2901.42826823809
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	598783.00100708	3628.72943443584
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	108344.046463013	1754.69230502622
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	804128.271911621	4791.50077567113


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" VARCHAR,
  "shape_area_1" VARCHAR,
  "lex_web" VARCHAR,
  "rcs_web" VARCHAR,
  "source" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);