20191219_DML_METHODS_UPDATE: Method abbrev. is sometimes null

[johanvonboer]

For example, see: http://supersead.humlab.umu.se/site/102

[johanvonboer]

This is because the method abbreviation (or alt name) is sometimes null in the database.

This query: SELECT * FROM tbl_methods WHERE method_abbrev_or_alt_name is null

Results in this table

method_id	biblio_id	date_updated	description	method_abbrev_or_alt_name	method_group_id	method_name	record_type_id	unit_id
102	NULL	2013-05-13 09:29:56.070308+00	Rikets höjdsystem 1970	NULL	17	RH70	NULL	1
103	NULL	2013-05-13 09:29:56.070308+00	RT90 5 gon V	NULL	17	RT90 5 gon V	NULL	1
104	NULL	2013-05-13 09:29:56.070308+00	Derived from: Troedsson, Tryggve & Nykvist, Nils (1973). Marklära och markvård. Stockholm: Almqvist & Wiksell	NULL	18	MAL horizon	11	NULL
105	NULL	2013-05-13 09:29:56.070308+00	Site-specific grid or unknown grid	NULL	17	Local grid	NULL	1
106	NULL	2013-05-13 09:29:56.070308+00	Bartington MS2 & MS2D	NULL	2	MS loop	10	NULL
107	NULL	2013-05-13 09:29:56.070308+00	µS (H2O)	NULL	2	µS (H2O)	12	NULL
108	NULL	2013-05-13 09:29:56.070308+00	Göteborgs kommuns koordinatsystem	NULL	17	Göteborgs kommuns koordinatsystem	NULL	1
109	NULL	2013-05-13 09:29:56.070308+00	pH	NULL	2	pH (H2O)	12	NULL
110	NULL	2013-05-13 09:29:56.070308+00	pH (KCl 0,1M)	NULL	2	pH (KCl 0,1M)	12	NULL
111	NULL	2013-05-13 09:29:56.070308+00	Plant macrofossils by volume	NULL	1	Plant macros [volume]	2	14
112	NULL	2013-05-13 09:29:56.070308+00	Sieving 600µ	NULL	16	Sieving 600µ	NULL	12
113	NULL	2013-11-13 14:33:32.218+00	In use until 2008-01-01	NULL	17	Malmö stads koordinatnät	NULL	NULL
114	NULL	2013-11-13 14:33:32.218+00	Last Revised: June 2, 1995 Area: World - N hemisphere - 6°E to 12°E - by country	NULL	17	WGS84 UTM zone 32	NULL	NULL
115	NULL	2013-11-13 14:33:32.218+00	Depth from surface lower sample boundary	NULL	17	Depth from surface lower sample boundary	NULL	1
116	NULL	2013-11-13 14:33:32.218+00	Upper sample boundry	NULL	17	Depth from surface upper sample boundry	NULL	1
122	NULL	2013-11-13 14:33:32.218+00	Depth from surface lower sample boundary	NULL	17	Depth from surface lower sample boundary	NULL	1
123	NULL	2013-11-13 14:33:32.218+00	UTM U32 Euref89	NULL	17	UTM U32 euref89	NULL	NULL
124	NULL	2013-11-13 14:33:32.218+00	Sieving 1,25mm	NULL	16	Sieving 1,25mm	NULL	NULL
125	NULL	2014-02-19 14:28:44.312+00	Upper sample boundary positive	NULL	17	Upper sample boundary	NULL	1
126	NULL	2014-02-19 14:28:44.312+00	Lower sample boundary depth positive	NULL	17	Lower sample boundary depth	NULL	1
120	NULL	2013-11-13 14:33:32.218+00	Area: World	NULL	17	WGS84 UTM zone 33N	NULL	NULL

[visead]

I'll have a look through these and provide data for an update.

[visead]

Working on this now. Some of these and other methods need units too (which I will sort out)

[visead]

Update tbl_methods as follows:

method_id	biblio_id	date_updated	description	method_abbrev_or_alt_name	method_group_id	method_name	record_type_id	unit_id
102	NULL	2013-05-13 09:29:56.070308+00	Rikets höjdsystem 1970. Swedish national altitude system 1970.	RH70	17	Rikets höjdsystem 1970	NULL	1
103	NULL	2013-05-13 09:29:56.070308+00	Rikets koordinatsystem RT90 5 gon V	RT90 5 gon V	17	RT90 5 gon V	NULL	4
104	NULL	2013-05-13 09:29:56.070308+00	Qualitative soil horizon classifications used by MAL. Derived from: Troedsson, Tryggve & Nykvist, Nils (1973). Marklära och markvÃ¥rd. Stockholm: Almqvist & Wiksell	MAL soil horizons	18	MAL soil horizon classifications	11	NULL
105	NULL	2013-05-13 09:29:56.070308+00	Site-specific grid or unknown site or sampling grid or coordinate system.	Local or unknown grid	17	Local or unknown grid	NULL	1
106	NULL	2013-05-13 09:29:56.070308+00	Bartington MS2 & MS2D	MS Loop	2	MS loop	10	NULL
107	NULL	2013-05-13 09:29:56.070308+00	Conductivity in µS (H2O)	µS (H2O)	2	Conductivity µS (H2O)	12	NULL
108	NULL	2013-05-13 09:29:56.070308+00	Göteborgs kommuns koordinatsystem. Gothenburg municipality coordinate system.	Göteborgs kommuns koordinatsystem	17	Göteborgs kommuns koordinatsystem	NULL	1
109	NULL	2013-05-13 09:29:56.070308+00	Acidity (pH)	pH	2	pH (H2O)	12	NULL
110	NULL	2013-05-13 09:29:56.070308+00	Acidity (pH) (KCl 0,1M)	pH (KCl 0,1M)	2	pH (KCl 0,1M)	12	NULL
111	NULL	2013-05-13 09:29:56.070308+00	Plant macrofossil amount quantified by absolute volume	Plant macros (volume)	1	Plant macros (volume)	2	14
112	NULL	2013-05-13 09:29:56.070308+00	Preparation method: Sieving through 600µ seive (retaining seive contents)	Sieving 600µ	16	Sieving 600µ	NULL	2
113	NULL	2013-11-13 14:33:32.218+00	Malmö stads koordinatnät. Malmä city coordinate system. In use until 2008-01-01	Malmö stads koordinatnät	17	Malmö stads koordinatnät	NULL	NULL
114	NULL	2013-11-13 14:33:32.218+00	Global coordinate system zone UTM 32 in WGS84 system. Last Revised: June 2, 1995 Area: World - N hemisphere - 6°E to 12°E - by country	WGS84 UTM 32	17	WGS84 UTM zone 32	NULL	4
115	NULL	2013-11-13 14:33:32.218+00	Depth from surface lower sample boundary (depth is positive)	Depth lower (from surface)	17	Depth from surface lower sample boundary	NULL	1
116	NULL	2013-11-13 14:33:32.218+00	Depth from ground surface to upper sample boundary (depth is positive)	Depth upper (from surface)	17	Depth surface to upper sample boundary	NULL	1
122	NULL	2013-11-13 14:33:32.218+00	Depth from ground surface to lower sample boundary (depth is positive)	Depth lower (from surface)	17	Depth surface to lower sample boundary	NULL	1
123	NULL	2013-11-13 14:33:32.218+00	Official geodetic datum (reference system/projection) of Norway. UTM zone U32. EUREF89. https://www.kartverket.no/Posisjonstjenester/Kartprojeksjoner/	EUREF89 UTM U32	17	EUREF89 UTM U32	NULL	NULL
124	NULL	2013-11-13 14:33:32.218+00	Preparation method: Sieving through  1.25mm seive (retaining seive contents)	Sieving 1.25mm	16	Sieving 1.25mm	NULL	2
125	NULL	2014-02-19 14:28:44.312+00	Upper sample boundary positive	Upper sample boundary (positive depth)	17	Upper sample boundary (positive depth)	NULL	1
126	NULL	2014-02-19 14:28:44.312+00	Lower sample boundary depth positive	Lower sample boundary (positive depth)	17	Lower sample boundary (positive depth)	NULL	1
120	NULL	2013-11-13 14:33:32.218+00	WGS84 UTM zone 33N	WGS84 UTM 33N	17	WGS84 UTM zone 33N	NULL	4