Geospatial Data Collection for 2012 Areas and Road Networks in Helsingin kaupunkiymparisto, Finland

This dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala in Finland.

Tables

2012 Noise Analysis on Road Network in Area 09TSV
This table contains data from the 'Helsinki City Environment Department' website which originates from Finland (ISO country code: 'fi'). The table 'avoindatameluselvitys_2012_alue_09_maantiet_l_den__meluselvitys_2012_alue_09_maantiet_l_denpolygon' provides information related to noise surveys conducted in 2012. The table consists of several columns that store various attributes such as the date of data extraction, the row number, unique identifier, noise levels range, data source, last updated date, geometric representation in GeoJSON and GeoText formats, geometry type, centroid coordinates, and the full geometry. This data can be utilized in data analytics to analyze noise pollution levels in different areas, identify areas with high noise levels, perform spatial analyses by examining...
Version History of Meluselvitys 2012 Alue 09 Maantietölädän Polygon from Helsingin kaupunkiympäristön toimiala in FinlandTSV
This table, sourced from the website of Helsingin kaupunkiympariston toimiala in Finland, contains the version history of the avoindatameluselvitys_2012_alue_09_maantiet_l_den__meluselvitys_2012_alue_09_maantiet_l_denpolygon table. It includes the '_start_date' and '_end_date' columns, which indicate when a particular row of the base table was extracted from the data source. The table consists of various columns such as 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', as well as the 'geom' column. These columns provide valuable data that can be utilized in data analytics to gain insights and perform various analyses.

Column Descriptions

2012 Noise Analysis on Road Network in Area 09

Column	Type	Comment
_extract_date	date	The date when the data is extracted from the source.
_row_number	long	The row number of the record in the table.
id	int	The unique identifier for each record.
db_lo	int	The lower bound of the database value.
db_hi	int	The upper bound of the database value.
datanomist	string	The name of the data analyst.
paivitetty	string	The date when the record is last updated.
geom_geojson	string	The geometry data in GeoJSON format.
geom_geotext	string	The geometry data in Geotext format.
geom_type	string	The type of geometry.
geom_centroid	string	The centroid point of the geometry.
geom_center_x	double	The x-coordinate of the center point of the geometry.
geom_center_y	double	The y-coordinate of the center point of the geometry.
geom	binary	The geometry data.

Version History of Meluselvitys 2012 Alue 09 Maantietölädän Polygon from Helsingin kaupunkiympäristön toimiala in Finland

Column	Type	Comment
_start_date	date	Date indicating the start of validity period for the row version
_end_date	date	Date indicating the end of validity period for the row version
_row_number	long	Sequential number assigned to each row version in the table
id	int	Unique identifier for the row
db_lo	int	Lower bound of a range for the row in the database
db_hi	int	Upper bound of a range for the row in the database
datanomist	string	Name of the data analyst who created or last updated the row version
paivitetty	string	Timestamp indicating when the row version was last updated
geom_geojson	string	Geometry of the row version in GeoJSON format
geom_geotext	string	Geometry of the row version in geotext format
geom_type	string	Type of geometry for the row version
geom_centroid	string	Centroid of the geometry for the row version
geom_center_x	double	X coordinate of the center of the geometry for the row version
geom_center_y	double	Y coordinate of the center of the geometry for the row version
geom	binary	Geometry object for the row version

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024