Street Networks in Helsinki, Finland

This dataset collection consists of one or more dataset tables sourced from the website of 'Helsingin kaupunkiympariston toimiala' in Finland. The dataset collection contains data related to streets and roads in Helsinki. The tables provide information about the geographic locations, names, and other attributes of the streets and roads in the city. The dataset collection is named 'avoindatamelualueet_2017_12_kadut_maant_hki_lyo'.

Tables

Street and Road Noise Areas in Helsinki, Finland (December 2017)TSV
The table contains data from 'Helsinki City Environment Sector' website which originates from Finland. It provides information on noise areas and road locations in Helsinki. The table has various columns including '_extract_date', '_row_number', 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. These columns contain data that can be utilized for various data analytics purposes.
Version history of Street Noise Areas in Helsinki, FinlandTSV
This table contains the version history of the 'avoindatamelualueet_2017_12_kadut_maant_hki_lyo__melualueet_2017_12_kadut_maant_hki_lyopolygon' table. It provides information about the different versions of rows extracted from the data source. The table includes columns such as '_start_date', '_end_date', '_row_number', 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. The '_start_date' column represents the date when a row was extracted, while '_end_date' denotes the date when a new version of the row was obtained. If the '_end_date' value is null, it means the row is the most recent version. The data in this table can be utilized for data analytics purposes, such as monitoring...

Column Descriptions

Street and Road Noise Areas in Helsinki, Finland (December 2017)

Column	Type	Comment
_extract_date	date	The date the data was extracted
_row_number	long	The row number of the record
id	int	The unique identifier of the record
db_lo	float	The lower range of the database value
db_hi	float	The upper range of the database value
datanomist	string	The name of the data scientist
paivitetty	date	The date the record was last updated
geom_geojson	string	The geometry data in the GeoJSON format
geom_geotext	string	The geometry data in text 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 center of the geometry
geom_center_y	double	The y-coordinate of the center of the geometry
geom	binary	The full geometry data

Version history of Street Noise Areas in Helsinki, Finland

Column	Type	Comment
_start_date	date	Indicates the start date of the validity period for the row version.
_end_date	date	Indicates the end date of the validity period for the row version.
_row_number	long	Represents the row number of the version in the table.
id	int	Unique identifier for each row in the table.
db_lo	float	Low-order bits of the database identifier.
db_hi	float	High-order bits of the database identifier.
datanomist	string	The data source responsible for the row version.
paivitetty	date	Timestamp indicating when the row version was last updated.
geom_geojson	string	Geometric representation of the version using GeoJSON format.
geom_geotext	string	Textual representation of the version's geometry.
geom_type	string	Indicates the type of geometry for the version.
geom_centroid	string	The centroid coordinates of the version's geometry.
geom_center_x	double	X-coordinate of the center point of the version's geometry.
geom_center_y	double	Y-coordinate of the center point of the version's geometry.
geom	binary	The binary representation of the version's geometry.

Additional Info

Last Updated	September 13, 2024
Created	July 9, 2018