Public Transportation Infrastructure: Street Parts

This dataset collection includes one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala (City of Helsinki Public Works Department) in Finland.

Tables

Street Part LineTSV
This table contains data from 'Helsingin kaupunkiympariston toimiala' website in Finland. It consists of various columns such as _extract_date, _row_number, osan_id, paatyyppi, paatyyppi_c2, alatyyppi, alatyyppi_c4, materiaali, materiaal0, rakenteell, rakenteel0, talvikunno, talvikunn0, tkp_kiiree, tyhjentava, yllapitolu, yllapitol0, yllapitolk, puhtaanapi, puhtaanap0, puhtaanap1, pituus, leveys, pinta_ala, kadun_nimi, katualueen, katualuee0, katualuee1, osan_nro, paivitetty, geom_geojson, geom_geotext, geom_type, geom_centroid, geom_center_x, and geom_center_y. This table can be utilized for data analytics purposes such as analyzing the length, width, and area of the street parts, identifying the material used for construction, determining the maintenance type and level, and examining...
Version History of Line Parts in Helsinki City - Street AreaTSV
This table contains the version history of the rows in the 'Helsingin kaupunkiympariston toimiala' data source, which originates from the country Finland (ISO country code 'fi'). The table records the changes made to the base table rows over time. Each row in the table has additional columns - '_start_date' and '_end_date' - indicating the extraction dates of the row versions. If the value of '_end_date' is null, it means that the row is the most recent version. The table provides valuable data for data analytics, such as tracking changes in 'paatyyppi' (main type), 'alatyyppi' (sub-type), 'materiaali' (material), 'rakenteel' (structure), 'talvikunno' (winter maintenance), 'tkp_kiiree' (priority), 'tyhjentava' (cleansing), and 'yllapitolu' (maintenance level) over time. It also includes...

Column Descriptions

Street Part Line

Column	Type	Comment
_extract_date	date	The date when the data was extracted
_row_number	long	The unique identifier of each row
osan_id	int	The unique identifier of the part
paatyyppi	string	The main type of the part
paatyyppi_c2	int	The secondary type of the part
alatyyppi	string	The sub-type of the part
alatyyppi_c4	int	The secondary sub-type of the part
materiaali	string	The material of the part
materiaal0	int	The secondary material of the part
rakenteell	string	The structural information of the part
rakenteel0	int	The secondary structural information of the part
talvikunno	string	The winter maintenance information of the part
talvikunn0	int	The secondary winter maintenance information of the part
tkp_kiiree	string	The urgency level of the maintenance
tyhjentava	string	The emptying information of the part
yllapitolu	string	The maintenance type of the part
yllapitol0	int	The secondary maintenance type of the part
yllapitolk	string	The maintenance class of the part
puhtaanapi	string	The cleanliness information of the part
puhtaanap0	int	The secondary cleanliness information of the part
puhtaanap1	int	Additional cleanliness information of the part
pituus	int	The length of the part
leveys	int	The width of the part
pinta_ala	int	The surface area of the part
kadun_nimi	string	The street name of the part
katualueen	string	The street area information of the part
katualuee0	int	The secondary street area information of the part
katualuee1	int	Additional street area information of the part
osan_nro	int	The part number
paivitetty	string	The date of the last update for the part
geom_geojson	string	The geometry information in GeoJSON format
geom_geotext	string	The geometry information 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 center of the geometry
geom_center_y	double	The y-coordinate of the center of the geometry
geom	binary	The geometry information

Version History of Line Parts in Helsinki City - Street Area

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 history row.
osan_id	int	The ID of the base table row.
paatyyppi	string	The main type of the base table row.
paatyyppi_c2	int	The secondary type of the base table row.
alatyyppi	string	The sub-type of the base table row.
alatyyppi_c4	int	The secondary sub-type of the base table row.
materiaali	string	The material of the base table row.
materiaal0	int	The alternative material of the base table row.
rakenteell	string	The structural information of the base table row.
rakenteel0	int	The alternative structural information of the base table row.
talvikunno	string	The winter condition of the base table row.
talvikunn0	int	The alternative winter condition of the base table row.
tkp_kiiree	string	The urgency of the maintenance work for the base table row.
tyhjentava	string	The clearance information of the base table row.
yllapitolu	string	The maintenance class of the base table row.
yllapitol0	int	The alternative maintenance class of the base table row.
yllapitolk	string	The actual maintenance class of the base table row.
puhtaanapi	string	The cleanliness information of the base table row.
puhtaanap0	int	The alternative cleanliness information of the base table row.
puhtaanap1	int	The secondary alternative cleanliness information of the base table row.
pituus	int	The length of the base table row.
leveys	int	The width of the base table row.
pinta_ala	int	The surface area of the base table row.
kadun_nimi	string	The street name of the base table row.
katualueen	string	The street area of the base table row.
katualuee0	int	The alternative street area of the base table row.
katualuee1	int	The secondary alternative street area of the base table row.
osan_nro	int	The part number of the base table row.
paivitetty	string	The update date of the base table row.
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 data.
geom_centroid	string	The centroid of the geometry data.
geom_center_x	double	The x-coordinate of the center of the geometry data.
geom_center_y	double	The y-coordinate of the center of the geometry data.
geom	binary	The geometry data.

Additional Info

Last Updated	April 23, 2024
Created	October 22, 2018