Hki alue

Tables

Hki Alue, Faris Testhki AlueTSV
hki_alue

Column Descriptions

Hki Alue, Faris Testhki Alue

Column	Type	Comment
id	float	Data source did not contain a description for ID. Column id has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 5161.00.
aluejako	string	Data source did not contain a description for ALUEJAKO. Column aluejako has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: KAUPUNGINOSA.
kunta	string	Data source did not contain a description for KUNTA. Column kunta has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 091.
tunnus	string	Data source did not contain a description for TUNNUS. Column tunnus has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 15.
nimi	string	Data source did not contain a description for NIMI. Column nimi has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: MEILAHTI.
nimi_se	string	Data source did not contain a description for NIMI_SE. Column nimi_se has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: MEJLANS.
alkuperako	int	Data source did not contain a description for ALKUPERAKO. Column alkuperako has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is -99.
luonti_pvm	string	Data source did not contain a description for LUONTI_PVM. Column luonti_pvm has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 20091230131500000.
data_muokk	string	Data source did not contain a description for DATA_MUOKK. Column data_muokk has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: konversio.
muokkaus_p	string	Data source did not contain a description for MUOKKAUS_P. Column muokkaus_p has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 20091230131500000.
omistaja	string	Data source did not contain a description for OMISTAJA. Column omistaja has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: kmo.
historia_p	string	Data source did not contain a description for HISTORIA_P. Column historia_p has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 20091230131600000.
pinta	int	Data source did not contain a description for PINTA. Column pinta has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is -99.
mittausera	int	Data source did not contain a description for MITTAUSERA. Column mittausera has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is -9999.
tarkkuus	int	Data source did not contain a description for TARKKUUS. Column tarkkuus has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is -9999.
data_luoja	string	Data source did not contain a description for DATA_LUOJA. Column data_luoja has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: konversio.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: POLYGON ((25.219538055583...
geom_center_x	double	Longitude of the centroid of the geometry. Column geom_center_x has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 25.02.
geom_center_y	double	Latitude of the centroid of the geometry. Column geom_center_y has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 60.11.
geom_type	string	Geometry type. Column geom_type has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POLYGON.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	April 12, 2019
Created	October 22, 2018