Osoitteet

Tables

• Osoitteet, GisosoitteetTSV

  Vantaan katuosoitteet pistemäisinä vektorikohteina osoiterekisteristä.

• features
• osoitteet

Column Descriptions

Osoitteet, Gisosoitteet

Column	Type	Comment
katunimi	string	Data source did not contain a description for katunimi. Column katunimi has 40825 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Virtapuistonkenttä and maximum string is Övre-Thors.
katunimi_r	string	Data source did not contain a description for katunimi_r. Column katunimi_r has 40825 rows, out of which 37 are empty, making the null percent 0.09. Minimum string is Oljevägen and maximum string is Övre-Thors.
osoitenume	int	Data source did not contain a description for osoitenume. Column osoitenume has 40825 rows, out of which 45 are empty, making the null percent 0.11. Minimum value is 0 and maximum value is 900.
osoitenum0	string	Data source did not contain a description for osoitenum0. Column osoitenum0 has 40825 rows, out of which 40754 are empty, making the null percent 99.83. Minimum string is and maximum string is 9.
kirjain	string	Data source did not contain a description for kirjain. Column kirjain has 40825 rows, out of which 32014 are empty, making the null percent 78.42. Minimum string is and maximum string is p.
osoiteteks	string	Data source did not contain a description for osoiteteks. Column osoiteteks has 40825 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Öljytie 10 and maximum string is Övre-Thors 0.
osoitetek0	string	Data source did not contain a description for osoitetek0. Column osoitetek0 has 40825 rows, out of which 6 are empty, making the null percent 0.01. Minimum string is Oljevägen 10 and maximum string is Övre-Thors 0.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 40825 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.891917645209983... and first 25 characters of maximum string: POINT (25.191978895992094...
geom_center_x	double	Longitude of the centroid of the geometry. Column is empty.
geom_center_y	double	Latitude of the centroid of the geometry. Column is empty.
geom_type	string	Geometry type. Column geom_type has 40825 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	April 12, 2019
Created	October 22, 2018