Piirijako pienalue

Tables

• Piirijako pienaluepolygon, Avoindatapiirijako pienalue, LatestTSV

  No description available for layer avoindata:Piirijako_pienalue (Piirijako_pienalue)

Column Descriptions

Piirijako pienaluepolygon, Avoindatapiirijako pienalue, Latest

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 112420 and maximum value is 116151.
aluejako	string	Data source did not contain a description for aluejako. Column aluejako has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: PIENALUE.
kunta	int	Data source did not contain a description for kunta. Column kunta has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Constant value is 91.
tunnus	int	Data source did not contain a description for tunnus. Column tunnus has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 9.
osaalue_tu	int	Data source did not contain a description for osaalue_tu. Column osaalue_tu has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 10 and maximum value is 592.
osaalue_ni	string	Data source did not contain a description for osaalue_ni. Column osaalue_ni has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Ala-Malmi and maximum string is Östersundom.
osaalue_n0	string	Data source did not contain a description for osaalue_n0. Column osaalue_n0 has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Alpbyn and maximum string is Övre Malm.
peruspiiri	int	Data source did not contain a description for peruspiiri. Column peruspiiri has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 101 and maximum value is 801.
peruspiir0	string	Data source did not contain a description for peruspiir0. Column peruspiir0 has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is ALPPIHARJU and maximum string is ÖSTERSUNDOM.
peruspiir1	string	Data source did not contain a description for peruspiir1. Column peruspiir1 has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is BERGHÄLL and maximum string is ÖSTRA BAGGBÖLE.
suurpiiri	int	Data source did not contain a description for suurpiiri. Column suurpiiri has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 8.
suurpiiri0	string	Data source did not contain a description for suurpiiri0. Column suurpiiri0 has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is ETELÄINEN and maximum string is ÖSTERSUNDOM.
suurpiiri1	string	Data source did not contain a description for suurpiiri1. Column suurpiiri1 has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is MELLERSTA and maximum string is ÖSTRA.
yhtluontip	date	Data source did not contain a description for yhtluontip. Column is empty.
yhtmuokkau	date	Data source did not contain a description for yhtmuokkau. Column is empty.
yhtdatanom	string	Data source did not contain a description for yhtdatanom. Column yhtdatanom has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Helsinki/Kami.
paivitetty	date	Data source did not contain a description for paivitetty. Column is empty.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POLYGON ((24.826075973609... and first 25 characters of maximum string: POLYGON ((25.219538051825...
geom_center_x	float	Longitude of center. Column geom_center_x has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.84 and maximum value is 25.23.
geom_center_y	float	Latitude of center. Column geom_center_y has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.01 and maximum value is 60.29.
geom_type	string	Geometry type. Column geom_type has 404 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POLYGON.

Additional Info

Last Updated	July 6, 2022
Created	September 8, 2018