Public Transport Errors 2014-2017 in Helsinki, Finland

This dataset collection contains one or more tables sourced from the website of the 'Helsinki City Environment Sector' in Finland.

Tables

Parking Violation Errors Version HistoryTSV
This is a historical version of a table sourced from the website of Helsingin kaupunkiympariston toimiala, which originates from the country Finland (ISO country code: 'fi'). The table contains the version history of the rows from its base table. Each row includes the start and end dates when the version was extracted from the data source. The table can be utilized in data analytics to analyze the historical changes in the 'virheen_tekokuukausi', 'virheen_tekovuosi', 'osoite', 'virhemaksun_vaihe', 'virheen_paaluokka__paasyy', 'virheen_kirjaaja', 'y', 'x', 'postinumero', 'postitoimipaikka', 'alue', 'kunta', and 'kunta_nro' columns. By examining the changes over time, trends and patterns can be identified for further analysis and decision-making.
Parking Violations in Helsinki, Finland (2014-2017)TSV
This table contains data from the 'Helsinki City Environment' department of Finland. It provides information on errors related to public transportation stops in Helsinki from 2014 to 2017. The data includes the extraction date, row number, month and year of error occurrence, address, error fine stage, main category of error, error reporter, coordinates (latitude and longitude), postal code, post office, area, municipality, and municipality number. The table can be used for various data analytics purposes such as analyzing error trends over time, identifying areas with a high number of errors, investigating error categories and their causes, and geospatial analysis of error occurrences in Helsinki.

Column Descriptions

Parking Violations in Helsinki, Finland (2014-2017)

Column	Type	Comment
_extract_date	date	The date the data was extracted from the source system.
_row_number	long	The unique identifier for each row in the table.
virheen_tekokuukausi	string	The month when the error occurred.
virheen_tekovuosi	int	The year when the error occurred.
osoite	string	The address associated with the error.
virhemaksun_vaihe	string	The stage of the error payment process.
virheen_paaluokka__paasyy	string	The main category or reason for the error.
virheen_kirjaaja	string	The person or entity who recorded the error.
y	string	The Y coordinate of the location associated with the error.
x	string	The X coordinate of the location associated with the error.
postinumero	string	The postal code of the location where the error occurred.
postitoimipaikka	string	The postal district of the location where the error occurred.
alue	string	The area or region of the location where the error occurred.
kunta	string	The municipality of the location where the error occurred.
kunta_nro	string	The number code assigned to the municipality where the error occurred.

Parking Violation Errors Version History

Column	Type	Comment
_start_date	date	The start date indicating the validity period of the row version in the table.
_end_date	date	The end date indicating the validity period of the row version in the table.
_row_number	long	The row number of the version history entry in the table.
virheen_tekokuukausi	string	The month of the error occurrence.
virheen_tekovuosi	int	The year of the error occurrence.
osoite	string	The address.
virhemaksun_vaihe	string	The phase of error payment.
virheen_paaluokka__paasyy	string	The main category or cause of the error.
virheen_kirjaaja	string	The person who recorded the error.
y	string	The y-coordinate of a location.
x	string	The x-coordinate of a location.
postinumero	string	The postal code.
postitoimipaikka	string	The post office of the address.
alue	string	The region or area.
kunta	string	The municipality or city.
kunta_nro	string	The municipality or city number.

Additional Info

Last Updated	September 13, 2024
Created	June 10, 2018