Version History of Line Parts in Helsinki City - Street Area

To download the data set, please sign up or log in

Click here for a data sample

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 geographical information, such as 'geom', 'kadun_nimi' (street name), 'katualueen' (street area), and 'pituus' (length), which can be used for spatial analysis and visualization.

Field Descriptions

Name Data type Description
_start_datedateThe start date of the validity period of the row version.
_end_datedateThe end date of the validity period of the row version.
_row_numberlongThe row number of the version history row.
osan_idintThe ID of the base table row.
paatyyppistringThe main type of the base table row.
paatyyppi_c2intThe secondary type of the base table row.
alatyyppistringThe sub-type of the base table row.
alatyyppi_c4intThe secondary sub-type of the base table row.
materiaalistringThe material of the base table row.
materiaal0intThe alternative material of the base table row.
rakenteellstringThe structural information of the base table row.
rakenteel0intThe alternative structural information of the base table row.
talvikunnostringThe winter condition of the base table row.
talvikunn0intThe alternative winter condition of the base table row.
tkp_kiireestringThe urgency of the maintenance work for the base table row.
tyhjentavastringThe clearance information of the base table row.
yllapitolustringThe maintenance class of the base table row.
yllapitol0intThe alternative maintenance class of the base table row.
yllapitolkstringThe actual maintenance class of the base table row.
puhtaanapistringThe cleanliness information of the base table row.
puhtaanap0intThe alternative cleanliness information of the base table row.
puhtaanap1intThe secondary alternative cleanliness information of the base table row.
pituusintThe length of the base table row.
leveysintThe width of the base table row.
pinta_alaintThe surface area of the base table row.
kadun_nimistringThe street name of the base table row.
katualueenstringThe street area of the base table row.
katualuee0intThe alternative street area of the base table row.
katualuee1intThe secondary alternative street area of the base table row.
osan_nrointThe part number of the base table row.
paivitettystringThe update date of the base table row.
geom_geojsonstringThe geometry data in GeoJSON format.
geom_geotextstringThe geometry data in Geotext format.
geom_typestringThe type of geometry data.
geom_centroidstringThe centroid of the geometry data.
geom_center_xdoubleThe x-coordinate of the center of the geometry data.
geom_center_ydoubleThe y-coordinate of the center of the geometry data.
geombinaryThe geometry data.

No sample for this dataset

Additional Information

Last updated April 23, 2024
Created April 23, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapterdelta
Countryfi
Databasefi_helsingin_kaupunkiympariston_toimiala
Id77e8b86b-8d6f-4e93-aec8-faf32733ff74
Package id8bfdeea7-e55a-47b3-9868-aae167c56cb4
Position1
Revision id4ee691f5-c903-411c-a4de-11f4a5e60015
Stateactive
Tablehkrylre_katuosat_line__ylre_katuosat_lineline__history