Accessibility Route Dataset Collection from Helsingin kaupunkiympariston toimiala in Finland

The dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympäristön toimiala in Finland.

Tables

Accessibility route - History (From: Helsingin kaupunkiympariston toimiala, Country: Finland)TSV
This table contains the version history of the rows from the base table 'avoindataesteettomyys_reitti__esteettomyys_reittiline'. Each row in the table represents a specific version of a row from the base table, with additional columns '_start_date' and '_end_date' indicating the extraction dates for each version. The data in this table is sourced from the website of 'Helsinki City Environment Sector' from the country Finland (ISO country code: FI). The table can be utilized in data analytics for various purposes such as analyzing the accessibility of routes, examining changes over time in the implementation of sound guidance, autopark availability, actualization status, geographical features, and more.
Accessibility Route - Line Level DataTSV
This table, sourced from the website of Helsingin kaupunkiympariston toimiala, contains data on accessibility routes and related information. The data originates from Finland (ISO country code 'fi'). It provides various attributes and spatial information for each accessibility route. The table can be utilized in data analytics to analyze the distribution and characteristics of accessible routes in different regions, perform spatial analysis to identify areas with a high concentration of accessibility routes, assess the compliance of routes with accessibility standards, and investigate the relationship between accessibility and other factors such as population density or proximity to amenities.

Column Descriptions

Accessibility Route - Line Level Data

Column	Type	Comment
_extract_date	date	The date when the row was extracted.
_row_number	long	The sequential number assigned to each row.
aaniopastu	string	The number of audio messages played.
le_autopai	string	The license plate of the vehicle.
toteutunut	string	The actual value or result achieved.
geom_geojson	string	The geometry of the object in GeoJSON format.
geom_geotext	string	The geometry of the object in geotext format.
geom_type	string	The type of the geometry object.
geom_centroid	string	The centroid of the geometry object.
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 geometry of the object.

Accessibility route - History (From: Helsingin kaupunkiympariston toimiala, Country: Finland)

Column	Type	Comment
_start_date	date	The start date of the validity period for the row version.
_end_date	date	The end date of the validity period for the row version.
_row_number	long	The row number of the version.
aaniopastu	string	Description not available.
le_autopai	string	Description not available.
toteutunut	string	Description not available.
geom_geojson	string	The geometry of the version in GeoJSON format.
geom_geotext	string	The geometry of the version in Geotext format.
geom_type	string	The type of geometry of the version.
geom_centroid	string	The centroid of the geometry of the version.
geom_center_x	double	The x-coordinate of the center of the geometry of the version.
geom_center_y	double	The y-coordinate of the center of the geometry of the version.
geom	binary	The geometry of the version.

Additional Info

Last Updated	April 23, 2024
Created	June 10, 2018