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

Turvattomat paikat Helsingissä peruspiireittäin

Turvattomat paikat Helsingissä peruspiireittäin

Tables

Column Descriptions

Turvattomat paikat 4326, Faris testturvattomat paikat 4326, Latest

Column Type Comment
peruspiiri int Data source did not contain a description for peruspiiri. Column peruspiiri has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 101 and maximum value is 801.
suurpiiri int Data source did not contain a description for suurpiiri. Column suurpiiri has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 8.
kunta int Data source did not contain a description for kunta. Column kunta has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 91.
nimi_fi string Data source did not contain a description for nimi_fi. Column nimi_fi has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alppiharju and maximum string is Östersundom.
nimi_se string Data source did not contain a description for nimi_se. Column nimi_se has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Berghäll and maximum string is Östra Baggböle.
aluekoodi int Data source did not contain a description for aluekoodi. Column aluekoodi has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 911101000 and maximum value is 918801000.
havainnot int Data source did not contain a description for Havainnot. Column havainnot has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 16 and maximum value is 98.
peruspii_1 string Data source did not contain a description for Peruspii_1. Column peruspii_1 has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum string is and maximum string is Vuosaari.
alue string Data source did not contain a description for Alue. Column alue has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum string is and maximum string is 704 Vuosaari.
juna_asema int Data source did not contain a description for juna_asema. Column juna_asema has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 45.
metroasema int Data source did not contain a description for metroasema. Column metroasema has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 50.
puisto_len int Data source did not contain a description for puisto_len. Column puisto_len has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 51.
metsat_pol int Data source did not contain a description for metsat_pol. Column metsat_pol has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 31.
baarit int Data source did not contain a description for baarit. Column baarit has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 13.
erityisryh int Data source did not contain a description for erityisryh. Column erityisryh has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 39.
pimeat_syr int Data source did not contain a description for pimeat_syr. Column pimeat_syr has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 19.
kauppa_ost int Data source did not contain a description for kauppa_ost. Column kauppa_ost has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 49.
liikenne int Data source did not contain a description for liikenne. Column liikenne has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 19.
kavelytiet int Data source did not contain a description for kavelytiet. Column kavelytiet has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 13.
alikulut int Data source did not contain a description for alikulut. Column alikulut has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 12.
torit_auk int Data source did not contain a description for torit_auk. Column torit_auk has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 22.
muut int Data source did not contain a description for muut. Column muut has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 7 and maximum value is 44.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((24.844243... and first 25 characters of maximum string: POLYGON ((25.062133739757...
geom_center_x float Longitude of center. Column geom_center_x has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.86 and maximum value is 25.20.
geom_center_y float Latitude of center. Column geom_center_y has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.15 and maximum value is 60.28.
geom_type string Geometry type. Column geom_type has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_MULTIPOLYGON and maximum string is ST_POLYGON.

Turvattomat paikat 4326, Faris testturvattomat paikat 4326, Full history

Column Type Comment
peruspiiri int Data source did not contain a description for peruspiiri. Column peruspiiri has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 101 and maximum value is 801.
suurpiiri int Data source did not contain a description for suurpiiri. Column suurpiiri has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 8.
kunta int Data source did not contain a description for kunta. Column kunta has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 91.
nimi_fi string Data source did not contain a description for nimi_fi. Column nimi_fi has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alppiharju and maximum string is Östersundom.
nimi_se string Data source did not contain a description for nimi_se. Column nimi_se has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Berghäll and maximum string is Östra Baggböle.
aluekoodi int Data source did not contain a description for aluekoodi. Column aluekoodi has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 911101000 and maximum value is 918801000.
havainnot int Data source did not contain a description for Havainnot. Column havainnot has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 16 and maximum value is 98.
peruspii_1 string Data source did not contain a description for Peruspii_1. Column peruspii_1 has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum string is and maximum string is Vuosaari.
alue string Data source did not contain a description for Alue. Column alue has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum string is and maximum string is 704 Vuosaari.
juna_asema int Data source did not contain a description for juna_asema. Column juna_asema has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 45.
metroasema int Data source did not contain a description for metroasema. Column metroasema has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 50.
puisto_len int Data source did not contain a description for puisto_len. Column puisto_len has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 51.
metsat_pol int Data source did not contain a description for metsat_pol. Column metsat_pol has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 31.
baarit int Data source did not contain a description for baarit. Column baarit has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 13.
erityisryh int Data source did not contain a description for erityisryh. Column erityisryh has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 39.
pimeat_syr int Data source did not contain a description for pimeat_syr. Column pimeat_syr has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 19.
kauppa_ost int Data source did not contain a description for kauppa_ost. Column kauppa_ost has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 49.
liikenne int Data source did not contain a description for liikenne. Column liikenne has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 19.
kavelytiet int Data source did not contain a description for kavelytiet. Column kavelytiet has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 13.
alikulut int Data source did not contain a description for alikulut. Column alikulut has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 12.
torit_auk int Data source did not contain a description for torit_auk. Column torit_auk has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 0 and maximum value is 22.
muut int Data source did not contain a description for muut. Column muut has 34 rows, out of which 1 are empty, making the null percent 2.94. Minimum value is 7 and maximum value is 44.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((24.844243... and first 25 characters of maximum string: POLYGON ((25.062133739757...
geom_center_x float Longitude of center. Column geom_center_x has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.86 and maximum value is 25.20.
geom_center_y float Latitude of center. Column geom_center_y has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.15 and maximum value is 60.28.
geom_type string Geometry type. Column geom_type has 34 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_MULTIPOLYGON and maximum string is ST_POLYGON.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated February 28, 2023
Created September 9, 2020