Address List Data Collection

The dataset collection consists of one or more dataset tables sourced from the website of 'Helsinki City Environment Services' in Finland.

Address List Point Registry Information Version HistoryTSV
This table contains the version history of the rows from the base table 'avoindataosoiteluettelo_piste_rekisteritiedot__osoiteluettelo_piste_rekisteritiedotpoint'. Each row in this table represents a specific version of a row in the base table, with additional columns '_start_date' and '_end_date' indicating the extraction dates of the versions. The data in this table is sourced from the website of 'Helsinki City Environment Sector', which originates from the country 'Finland' (ISO country code 'fi'). The table can be utilized in data analytics to track changes in address information over time, analyze the historical state of properties and locations, and identify trends or patterns in the maintenance or updates of the dataset.
Address Point Registration Information for Open Data - Helsinki City Environment Sector, FinlandTSV
This table contains data from the 'Helsinki City Environment Sector' website. It represents address information including various attributes such as the extracted date, row number, identifier, street address, postal code, coordinates, and other relevant data. The dataset originates from Finland (ISO country code 'fi'). This table can be utilized for data analytics to perform tasks such as geospatial analysis, address parsing, address quality assessment, and demographic analysis based on location.

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data.
id	int	The unique identifier of the record.
nimisto_id	int	The identifier of the location.
katuosoite	string	The street address.
adress	string	The address.
katunimi	string	The street name.
gatan	string	The street.
osoitenume	int	The address number.
nimistokoh	int	The location name.
nimistoko0	string	The location.
olotila	int	The condition.
olotila_se	string	The condition (Swedish).
kunta	int	The municipality.
kaupungino	int	The town.
kaupungin0	string	The city.
kaupungin1	string	The city.
postinumer	int	The postal code.
n	int	The northern coordinate.
e	int	The eastern coordinate.
paivitetty	string	The date when the record was updated.
datanomist	string	The data owner.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in geotext format.
geom_type	string	The type of geometry.
geom_centroid	string	The centroid of the geometry.
geom_center_x	double	The x-coordinate of the geometry center.
geom_center_y	double	The y-coordinate of the geometry center.
geom	binary	The geometry.

Column	Type	Comment
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	The row number of the version.
id	int	The unique identifier of the row.
nimisto_id	int	The identifier of the naming system.
katuosoite	string	The address in Finnish.
adress	string	The address in Swedish.
katunimi	string	The street name in Finnish.
gatan	string	The street name in Swedish.
osoitenume	int	The address number.
nimistokoh	int	The name location.
nimistoko0	string	The name location 0.
olotila	int	The condition.
olotila_se	string	The condition in Swedish.
kunta	int	The municipality.
kaupungino	int	The city.
kaupungin0	string	The city 0.
kaupungin1	string	The city 1.
postinumer	int	The postal code.
n	int	The latitude coordinate.
e	int	The longitude coordinate.
paivitetty	string	The date of update.
datanomist	string	The data owner.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in Geotext format.
geom_type	string	The type of geometry.
geom_centroid	string	The centroid of the geometry.
geom_center_x	double	The x-coordinate of the geometry center.
geom_center_y	double	The y-coordinate of the geometry center.
geom	binary	The geometry.

Last Updated	April 23, 2024
Created	April 23, 2024