Weighted Linear Regression

OpenDataNI

@ukgov.weighted_linear_regression

Table List

1 table(1.36 MB)

Table 1

@ukgov.weighted_linear_regression.table_1

1.36 MB
24335 rows
21 columns

objectid OBJECTID	transectid TransectID	baselineid BaselineID	transorder TransOrder	azimuth Azimuth	shrcount ShrCount	tcd TCD	sce SCE	nsm NSM	epr EPR	eprunc EPRunc	lrr LRR	lr2 LR2	lse LSE	lci99_7 LCI99–7	wlr WLR	wr2 WR2	wse WSE	wci99_7 WCI99–7	shape_length Shape, Length
1	1	1	1	151.93	7		4.53	2.43	0.01	0.09			1.78	0.05	0.04	0.23	0.58	0.17	47.9124767847126
2	2	1	2	155.13	7	25	10.32	-8.76	-0.05	0.09	-0.05	0.71	2.69	0.08	-0.09	0.8	0.36	0.11	31.2496150747472
3	3	1	3	156.82	7	50	3.66	-2.48	-0.01	0.09	-0.02	0.62	0.94	0.03			0.15	0.04	28.1060001272087
4	4	1	4	160.01	7	75	4.88	-4.49	-0.02	0.09	-0.02	0.77	0.95	0.03	-0.02	0.4	0.22	0.06	28.0229716200651
5	5	1	5	164.31	7	100	4.73	-3.12	-0.02	0.09	-0.01	0.28	1.4	0.04			0.23	0.07	32.1105008054739
6	6	1	6	166.86	7	125	14.45	-13.47	-0.07	0.09	-0.05	0.5	3.85	0.12	-0.05	0.53	0.41	0.12	42.694744988559
7	7	1	7	168.3	7	150	16.61	-15.77	-0.08	0.09	-0.06	0.5	4.56	0.14	-0.06	0.52	0.44	0.13	40.831123165932
8	8	1	8	170.47	7	175	19.78	-19.78	-0.1	0.09	-0.08	0.79	3.46	0.1	-0.08	0.87	0.23	0.07	37.0453080188307
9	9	1	9	173.81	7	200	15	-11.43	-0.06	0.09	-0.04	0.3	4.62	0.14	-0.03	0.13	0.59	0.17	35.0230458546834
10	10	1	10	177.47	7	225	8.42	-6.69	-0.03	0.09	-0.03	0.58	2.29	0.07	-0.1	0.52	0.74	0.22	29.4840260393301


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "transectid" BIGINT,
  "baselineid" BIGINT,
  "groupid" VARCHAR,
  "transorder" BIGINT,
  "azimuth" DOUBLE,
  "shrcount" BIGINT,
  "tcd" DOUBLE,
  "sce" DOUBLE,
  "nsm" DOUBLE,
  "epr" DOUBLE,
  "eprunc" DOUBLE,
  "lrr" DOUBLE,
  "lr2" DOUBLE,
  "lse" DOUBLE,
  "lci99_7" DOUBLE,
  "wlr" DOUBLE,
  "wr2" DOUBLE,
  "wse" DOUBLE,
  "wci99_7" DOUBLE,
  "shape_length" DOUBLE
);