Version History of Unsafe Places in Helsinki Urban Environment
Click here for a data sample
This table, sourced from the website of 'Urban Environment Sector of the City of Helsinki' in Finland, contains the version history of the rows in the 'turvattomat_paikat_4326' table. The rows in this table represent different versions of the data extracted from the source. Each row has a start date (_start_date) and an end date (_end_date) to indicate when the data version was extracted. If the value of _end_date is null, it means that the row represents the most recent version of the data. The table has additional columns such as 'peruspiiri', 'suurpiiri', 'kunta', 'nimi_fi', 'nimi_se', 'aluekoodi', 'havainnot', 'peruspii_1', 'alue', 'juna_asema', 'metroasema', 'puisto_len', 'metsat_pol', 'baarit', 'erityisryh', 'pimeat_syr', 'kauppa_ost', 'liikenne', 'kavelytiet', 'alikulut', 'torit_auk', 'muut', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns contain various attributes and characteristics of the places in the data. The data in this table can be utilized in data analytics to analyze changes over time, track trends, identify patterns, and perform spatial analysis on the locations represented in the data.
Field Descriptions
| Name |
Data type |
Description |
| _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. |
|---|
| peruspiiri | int | The basic boundary. |
|---|
| suurpiiri | int | The large district. |
|---|
| kunta | int | The municipality. |
|---|
| nimi_fi | string | The name in Finnish. |
|---|
| nimi_se | string | The name in Swedish. |
|---|
| aluekoodi | int | The area code. |
|---|
| havainnot | int | The observations. |
|---|
| peruspii_1 | string | The basic boundary (duplicate column). |
|---|
| alue | string | The area. |
|---|
| juna_asema | int | The train station. |
|---|
| metroasema | int | The metro station. |
|---|
| puisto_len | int | The park length. |
|---|
| metsat_pol | int | The forest path. |
|---|
| baarit | int | The bars. |
|---|
| erityisryh | int | The specific group. |
|---|
| pimeat_syr | int | The dark alleys. |
|---|
| kauppa_ost | int | The commerce and shopping. |
|---|
| liikenne | int | The traffic. |
|---|
| kavelytiet | int | The walking paths. |
|---|
| alikulut | int | The underpasses. |
|---|
| torit_auk | int | The marketplaces and open spaces. |
|---|
| muut | int | The miscellaneous. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry 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 geometric center. |
|---|
| geom_center_y | double | The y-coordinate of the geometric center. |
|---|
| geom | binary | The geometry. |
|---|
