Finnish Unsecured Places - Data from Helsinki City Environment Sector

Tables

• Unsafe Places in Helsinki, FinlandTSV

  This table contains data on unsafe places in the city of Helsinki, Finland. It provides information about the date when the data was extracted, the row number of each record, the basic district, the main district, the municipality, the name in Finnish, the name in Swedish, the area code, the observations, the basic district abbreviation, the area, the train station, the metro station, the length of parks, the length of forests, the number of bars, the special groups, the dark alleys, the shopping centers, the traffic, the walking paths, the underpasses, the markets and squares, the others, the geometry in GeoJSON format, the geometry in GeoText format, the geometry type, the centroid geometry, the center x-coordinate of the geometry, the center y-coordinate of the geometry, and the...

• Version History of Unsafe Places in Helsinki Urban EnvironmentTSV

  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',...