PKS osoiteluettelo

Tables

• Pks osoiteluettelopoint, Avoindatapks osoiteluettelo, LatestTSV

  No description available for layer avoindata:PKS_osoiteluettelo (PKS_osoiteluettelo)

Column Descriptions

Pks osoiteluettelopoint, Avoindatapks osoiteluettelo, Latest

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 141744 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 141744.
katunimi	string	Data source did not contain a description for katunimi. Column katunimi has 141744 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is A.I. Virtasen aukio and maximum string is Östersundomin lintuvedet.
gatan	string	Data source did not contain a description for gatan. Column gatan has 141744 rows, out of which 9 are empty, making the null percent 0.01. Minimum string is and maximum string is Övre terrassvägen.
osoitenume	int	Data source did not contain a description for osoitenume. Column osoitenume has 141744 rows, out of which 3203 are empty, making the null percent 2.26. Minimum value is 0 and maximum value is 1215.
osoitenum0	int	Data source did not contain a description for osoitenum0. Column osoitenum0 has 141744 rows, out of which 140848 are empty, making the null percent 99.37. Minimum value is 2 and maximum value is 960.
osoitekirj	string	Data source did not contain a description for osoitekirj. Column osoitekirj has 141744 rows, out of which 120067 are empty, making the null percent 84.71. Minimum string is and maximum string is p.
n	int	Data source did not contain a description for n. Column n has 141744 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 6657477 and maximum value is 6698540.
e	int	Data source did not contain a description for e. Column e has 141744 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 25472568 and maximum value is 25514298.
kaupunki	string	Data source did not contain a description for kaupunki. Column kaupunki has 141744 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Espoo and maximum string is Vantaa.
staden	string	Data source did not contain a description for staden. Column staden has 141744 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Esbo and maximum string is Vanda.
tyyppi	int	Data source did not contain a description for tyyppi. Column tyyppi has 141744 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 23.
osoitenum1	int	Data source did not contain a description for osoitenum1. Column osoitenum1 has 141744 rows, out of which 25882 are empty, making the null percent 18.26. Minimum value is 0 and maximum value is 1215.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 141744 rows, out of which 3213 are empty, making the null percent 2.27. Minimum value is 100 and maximum value is 4320.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 141744 rows, out of which 3804 are empty, making the null percent 2.68. Minimum string is and maximum string is VANTAA.
datanomist	string	Data source did not contain a description for datanomist. Column is empty.
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 141744 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POINT (24.5038823316986 6... and first 25 characters of maximum string: POINT (25 60.269768863968...
geom_center_x	float	Longitude of center. Column geom_center_x has 141744 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.5 and maximum value is 25.26.
geom_center_y	float	Latitude of center. Column geom_center_y has 141744 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.03 and maximum value is 60.4.
geom_type	string	Geometry type. Column geom_type has 141744 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POINT.

Additional Info

Last Updated	July 6, 2022
Created	August 7, 2018