Maankäyttö:Kantakartta:Kiintopiste

Tables

Kiintopiste, Kantakiintopiste, Full historyTSV
No description available for layer kanta:Kiintopiste (Maankäyttö:Kantakartta:Kiintopiste)
Kiintopiste, Kantakiintopiste, LatestTSV
No description available for layer kanta:Kiintopiste (Maankäyttö:Kantakartta:Kiintopiste)

Column Descriptions

Kiintopiste, Kantakiintopiste, Latest

Column	Type	Comment
gml_id	string	Data source did not contain a description for gml_id. Column gml_id has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kiintopiste.102278887 and maximum string is Kiintopiste.9487094.
kplkoodi	int	Data source did not contain a description for kplkoodi. Column kplkoodi has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 95120001 and maximum value is 95160001.
sijaintiepavarmuus	int	Data source did not contain a description for sijaintiepavarmuus. Column sijaintiepavarmuus has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 5.
luontitapa	string	Data source did not contain a description for luontitapa. Column luontitapa has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: maastomittaus.
alkupvm	timestamp	Data source did not contain a description for alkuPvm. Column alkupvm has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1997-06-16 15:14:27 and maximum value is 2020-07-28 07:41:50.
ilmentymaelementinnimi	string	Data source did not contain a description for ilmentymaElementinNimi. Column ilmentymaelementinnimi has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: pisteNumero.
suunta	int	Data source did not contain a description for suunta. Column suunta has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 1.
suunta_uom	string	Data source did not contain a description for suunta_uom. Column suunta_uom has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: rad.
jarjestelma	string	Data source did not contain a description for jarjestelma. Column jarjestelma has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ETRS-GK25/N2000.
luokka	string	Data source did not contain a description for luokka. Column luokka has 18755 rows, out of which 97 are empty, making the null percent 0.52. First 25 characters of minimum string: ... and first 25 characters of maximum string: Trig./GPS -määr. tasoitet...
rakennusalusta	string	Data source did not contain a description for rakennusalusta. Column rakennusalusta has 18755 rows, out of which 202 are empty, making the null percent 1.08. Minimum string is and maximum string is W-kaivo.
tyyppi	string	Data source did not contain a description for tyyppi. Column tyyppi has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is korkeuskiintopiste and maximum string is tasokiintopiste.
pistenumero	int	Data source did not contain a description for pisteNumero. Column pistenumero has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10001 and maximum value is 35653.
suuntakulma	int	Data source did not contain a description for suuntakulma. Column suuntakulma has 18755 rows, out of which 18752 are empty, making the null percent 99.98. Minimum value is 0 and maximum value is 4.
suuntakulma_uom	string	Data source did not contain a description for suuntakulma_uom. Column suuntakulma_uom has 18755 rows, out of which 18752 are empty, making the null percent 99.98. The single string value is: .
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (24.4991791 60.2875... and first 25 characters of maximum string: POINT (24.8524623 60.2241...
geom_center_x	float	Longitude of center. Column geom_center_x has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.50 and maximum value is 24.85.
geom_center_y	float	Latitude of center. Column geom_center_y has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.06 and maximum value is 60.37.
geom_type	string	Geometry type. Column geom_type has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT.

Kiintopiste, Kantakiintopiste, Full history

Column	Type	Comment
gml_id	string	Data source did not contain a description for gml_id. Column gml_id has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kiintopiste.102278887 and maximum string is Kiintopiste.9487094.
kplkoodi	int	Data source did not contain a description for kplkoodi. Column kplkoodi has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 95120001 and maximum value is 95160001.
sijaintiepavarmuus	int	Data source did not contain a description for sijaintiepavarmuus. Column sijaintiepavarmuus has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 5.
luontitapa	string	Data source did not contain a description for luontitapa. Column luontitapa has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: maastomittaus.
alkupvm	timestamp	Data source did not contain a description for alkuPvm. Column alkupvm has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1997-06-16 15:14:27 and maximum value is 2020-07-28 07:41:50.
ilmentymaelementinnimi	string	Data source did not contain a description for ilmentymaElementinNimi. Column ilmentymaelementinnimi has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: pisteNumero.
suunta	int	Data source did not contain a description for suunta. Column suunta has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 1.
suunta_uom	string	Data source did not contain a description for suunta_uom. Column suunta_uom has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: rad.
jarjestelma	string	Data source did not contain a description for jarjestelma. Column jarjestelma has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ETRS-GK25/N2000.
luokka	string	Data source did not contain a description for luokka. Column luokka has 18755 rows, out of which 97 are empty, making the null percent 0.52. First 25 characters of minimum string: ... and first 25 characters of maximum string: Trig./GPS -määr. tasoitet...
rakennusalusta	string	Data source did not contain a description for rakennusalusta. Column rakennusalusta has 18755 rows, out of which 202 are empty, making the null percent 1.08. Minimum string is and maximum string is W-kaivo.
tyyppi	string	Data source did not contain a description for tyyppi. Column tyyppi has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is korkeuskiintopiste and maximum string is tasokiintopiste.
pistenumero	int	Data source did not contain a description for pisteNumero. Column pistenumero has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10001 and maximum value is 35653.
suuntakulma	int	Data source did not contain a description for suuntakulma. Column suuntakulma has 18755 rows, out of which 18752 are empty, making the null percent 99.98. Minimum value is 0 and maximum value is 4.
suuntakulma_uom	string	Data source did not contain a description for suuntakulma_uom. Column suuntakulma_uom has 18755 rows, out of which 18752 are empty, making the null percent 99.98. The single string value is: .
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (24.4991791 60.2875... and first 25 characters of maximum string: POINT (24.8524623 60.2241...
geom_center_x	float	Longitude of center. Column geom_center_x has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.50 and maximum value is 24.85.
geom_center_y	float	Latitude of center. Column geom_center_y has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.06 and maximum value is 60.37.
geom_type	string	Geometry type. Column geom_type has 18755 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	September 10, 2020
Created	September 9, 2020