Unsafe Places in Helsinki, Finland
Click here for a data sample
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 original geometry.
Field Descriptions
Name |
Data type |
Description |
_extract_date | date | The date of the extraction. |
_row_number | long | The number of the row in the table. |
peruspiiri | int | The basic district. |
suurpiiri | int | The major 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 second basic district. |
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 area. |
baarit | int | The number of bars. |
erityisryh | int | The special group. |
pimeat_syr | int | The dark syrup. |
kauppa_ost | int | The shopping center. |
liikenne | int | The traffic. |
kavelytiet | int | The walking path. |
alikulut | int | The underpasses. |
torit_auk | int | The market places. |
muut | int | The Other. |
geom_geojson | string | The geometry in GeoJSON format. |
geom_geotext | string | The geometry in Geotext format. |
geom_type | string | The geometry type. |
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. |