1. Home
  2. Datasets
  3. Toimipisterekisteri yksikot
To download the data set, please sign up or log in

Toimipisterekisteri yksikot

No description available for layer avoindata:Toimipisterekisteri_yksikot (Toimipisterekisteri_yksikot)

Tables

Column Descriptions

Toimipisterekisteri yksikotpoint, Avoindatatoimipisterekisteri yksikot, Latest

Column Type Comment
id int Data source did not contain a description for id. Column id has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2 and maximum value is 68811.
org_id string Data source did not contain a description for org_id. Column org_id has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: 0154f8e4-443c-4d0c-821a-c... and first 25 characters of maximum string: f6566775-7492-4437-b24b-9...
dept_id string Data source did not contain a description for dept_id. Column dept_id has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: 0154f8e4-443c-4d0c-821a-c... and first 25 characters of maximum string: ffc3ff18-4527-4160-81a5-d...
provider_t string Data source did not contain a description for provider_t. Column provider_t has 18109 rows, out of which 3 are empty, making the null percent 0.02. Minimum string is and maximum string is VOUCHER_SERVICE.
data_sourc string Data source did not contain a description for data_sourc. Column data_sourc has 18109 rows, out of which 707 are empty, making the null percent 3.9. Minimum string is and maximum string is www.vayla.fi.
name_fi string Data source did not contain a description for name_fi. Column name_fi has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is 3A-Sport Squash-halli and maximum string is Ølhus København.
name_sv string Data source did not contain a description for name_sv. Column name_sv has 18109 rows, out of which 4379 are empty, making the null percent 24.18. Minimum string is and maximum string is Övre Malms Torg.
name_en string Data source did not contain a description for name_en. Column name_en has 18109 rows, out of which 7086 are empty, making the null percent 39.13. Minimum string is and maximum string is Ølhus København.
manual_coo boolean Data source did not contain a description for manual_coo.
street_add string Data source did not contain a description for street_add. Column street_add has 18109 rows, out of which 367 are empty, making the null percent 2.03. Minimum string is and maximum string is Överbyntie 16.
street_ad0 string Data source did not contain a description for street_ad0. Column street_ad0 has 18109 rows, out of which 844 are empty, making the null percent 4.66. Minimum string is and maximum string is Övre Malms torg 6.
street_ad1 string Data source did not contain a description for street_ad1. Column street_ad1 has 18109 rows, out of which 2752 are empty, making the null percent 15.2. Minimum string is and maximum string is Österbyntie 26.
address_zi int Data source did not contain a description for address_zi. Column address_zi has 18109 rows, out of which 757 are empty, making the null percent 4.18. Minimum value is 82 and maximum value is 59100.
address_ci string Data source did not contain a description for address_ci. Column address_ci has 18109 rows, out of which 391 are empty, making the null percent 2.16. Minimum string is and maximum string is Vuosaari.
address_c0 string Data source did not contain a description for address_c0. Column address_c0 has 18109 rows, out of which 668 are empty, making the null percent 3.69. Minimum string is and maximum string is Vuosaari.
address_c1 string Data source did not contain a description for address_c1. Column address_c1 has 18109 rows, out of which 391 are empty, making the null percent 2.16. Minimum string is and maximum string is Vuosaari.
phone string Data source did not contain a description for phone. Column phone has 18109 rows, out of which 6239 are empty, making the null percent 34.45. Minimum string is and maximum string is 116 117.
call_charg string Data source did not contain a description for call_charg. Column call_charg has 18109 rows, out of which 6229 are empty, making the null percent 34.4. Minimum string is and maximum string is pvm/mpm.
call_char0 string Data source did not contain a description for call_char0. Column call_char0 has 18109 rows, out of which 6229 are empty, making the null percent 34.4. First 25 characters of minimum string: ... and first 25 characters of maximum string: Mån-Fre 9-17: 1,98EUR/min...
call_char1 string Data source did not contain a description for call_char1. Column call_char1 has 18109 rows, out of which 6229 are empty, making the null percent 34.4. Minimum string is and maximum string is toll free.
email string Data source did not contain a description for email. Column email has 18109 rows, out of which 11747 are empty, making the null percent 64.87. Minimum string is and maximum string is zodiak@zodiak.fi.
www_fi string Data source did not contain a description for www_fi. Column www_fi has 18109 rows, out of which 3491 are empty, making the null percent 19.28. Minimum string is and maximum string is www.helmet.fi/jätkäsaari.
www_sv string Data source did not contain a description for www_sv. Column www_sv has 18109 rows, out of which 3491 are empty, making the null percent 19.28. Minimum string is and maximum string is www.helmet.fi/busholmen.
www_en string Data source did not contain a description for www_en. Column www_en has 18109 rows, out of which 3491 are empty, making the null percent 19.28. Minimum string is and maximum string is www.helmet.fi/busholmen.
address_po string Data source did not contain a description for address_po. Column address_po has 18109 rows, out of which 14572 are empty, making the null percent 80.47. First 25 characters of minimum string: ... and first 25 characters of maximum string: Ylästöntie 3, 01510 Vanta...
address_p0 string Data source did not contain a description for address_p0. Column address_p0 has 18109 rows, out of which 14837 are empty, making the null percent 81.93. First 25 characters of minimum string: ... and first 25 characters of maximum string: Örnbräksvägen 6, 01350 Va...
address_p1 string Data source did not contain a description for address_p1. Column address_p1 has 18109 rows, out of which 14864 are empty, making the null percent 82.08. Minimum string is and maximum string is Virtatie 4, 01600 Vantaa.
streetview string Data source did not contain a description for streetview. Column streetview has 18109 rows, out of which 17901 are empty, making the null percent 98.85. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://www.kulttuuriespo...
extra_sear string Data source did not contain a description for extra_sear. Column extra_sear has 18109 rows, out of which 13448 are empty, making the null percent 74.26. Minimum string is and maximum string is YoYo.
accessibil string Data source did not contain a description for accessibil. Column accessibil has 18109 rows, out of which 16578 are empty, making the null percent 91.55. Minimum string is and maximum string is +358 9 931 052 641.
accessibi0 string Data source did not contain a description for accessibi0. Column accessibi0 has 18109 rows, out of which 16810 are empty, making the null percent 92.83. Minimum string is and maximum string is yucel.tozalan@palmia.fi.
accessibi1 string Data source did not contain a description for accessibi1. Column accessibi1 has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: 00:unknown,11:green,12:gr... and first 25 characters of maximum string: 00:unknown,11:unknown,12:...
created_ti date Data source did not contain a description for created_ti. Column is empty.
modified_t date Data source did not contain a description for modified_t. Column is empty.
service_id int Data source did not contain a description for service_id. Column service_id has 18109 rows, out of which 3792 are empty, making the null percent 20.94. Minimum value is 42 and maximum value is 1022.
service_fi string Data source did not contain a description for service_fi. Column service_fi has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: 1. luokalta alkava sovelt... and first 25 characters of maximum string: öljyntorjuntavarikot...
service_sv string Data source did not contain a description for service_sv. Column service_sv has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: A1-engelska (språkprogram... and first 25 characters of maximum string: övrig säkerhetsservice (f...
service_en string Data source did not contain a description for service_en. Column service_en has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: A1-English (basic educati... and first 25 characters of maximum string: zoos,water bus platforms...
datanomist string Data source did not contain a description for datanomist. Column datanomist has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Palvelukartta.
paivitetty date Data source did not contain a description for paivitetty. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POINT (0.00060510880115 0... and first 25 characters of maximum string: POINT (29.49847652354771 ...
geom_center_x float Longitude of center. Column geom_center_x has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 29.5.
geom_center_y float Latitude of center. Column geom_center_y has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 61.56.
geom_type string Geometry type. Column geom_type has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POINT.

Toimipisterekisteri yksikotpoint, Avoindatatoimipisterekisteri yksikot, Full history

Column Type Comment
id int Data source did not contain a description for id. Column id has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2 and maximum value is 68811.
org_id string Data source did not contain a description for org_id. Column org_id has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: 0154f8e4-443c-4d0c-821a-c... and first 25 characters of maximum string: f6566775-7492-4437-b24b-9...
dept_id string Data source did not contain a description for dept_id. Column dept_id has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: 0154f8e4-443c-4d0c-821a-c... and first 25 characters of maximum string: ffc3ff18-4527-4160-81a5-d...
provider_t string Data source did not contain a description for provider_t. Column provider_t has 18109 rows, out of which 3 are empty, making the null percent 0.02. Minimum string is and maximum string is VOUCHER_SERVICE.
data_sourc string Data source did not contain a description for data_sourc. Column data_sourc has 18109 rows, out of which 707 are empty, making the null percent 3.9. Minimum string is and maximum string is www.vayla.fi.
name_fi string Data source did not contain a description for name_fi. Column name_fi has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is 3A-Sport Squash-halli and maximum string is Ølhus København.
name_sv string Data source did not contain a description for name_sv. Column name_sv has 18109 rows, out of which 4379 are empty, making the null percent 24.18. Minimum string is and maximum string is Övre Malms Torg.
name_en string Data source did not contain a description for name_en. Column name_en has 18109 rows, out of which 7086 are empty, making the null percent 39.13. Minimum string is and maximum string is Ølhus København.
manual_coo boolean Data source did not contain a description for manual_coo.
street_add string Data source did not contain a description for street_add. Column street_add has 18109 rows, out of which 367 are empty, making the null percent 2.03. Minimum string is and maximum string is Överbyntie 16.
street_ad0 string Data source did not contain a description for street_ad0. Column street_ad0 has 18109 rows, out of which 844 are empty, making the null percent 4.66. Minimum string is and maximum string is Övre Malms torg 6.
street_ad1 string Data source did not contain a description for street_ad1. Column street_ad1 has 18109 rows, out of which 2752 are empty, making the null percent 15.2. Minimum string is and maximum string is Österbyntie 26.
address_zi int Data source did not contain a description for address_zi. Column address_zi has 18109 rows, out of which 757 are empty, making the null percent 4.18. Minimum value is 82 and maximum value is 59100.
address_ci string Data source did not contain a description for address_ci. Column address_ci has 18109 rows, out of which 391 are empty, making the null percent 2.16. Minimum string is and maximum string is Vuosaari.
address_c0 string Data source did not contain a description for address_c0. Column address_c0 has 18109 rows, out of which 668 are empty, making the null percent 3.69. Minimum string is and maximum string is Vuosaari.
address_c1 string Data source did not contain a description for address_c1. Column address_c1 has 18109 rows, out of which 391 are empty, making the null percent 2.16. Minimum string is and maximum string is Vuosaari.
phone string Data source did not contain a description for phone. Column phone has 18109 rows, out of which 6239 are empty, making the null percent 34.45. Minimum string is and maximum string is 116 117.
call_charg string Data source did not contain a description for call_charg. Column call_charg has 18109 rows, out of which 6229 are empty, making the null percent 34.4. Minimum string is and maximum string is pvm/mpm.
call_char0 string Data source did not contain a description for call_char0. Column call_char0 has 18109 rows, out of which 6229 are empty, making the null percent 34.4. First 25 characters of minimum string: ... and first 25 characters of maximum string: Mån-Fre 9-17: 1,98EUR/min...
call_char1 string Data source did not contain a description for call_char1. Column call_char1 has 18109 rows, out of which 6229 are empty, making the null percent 34.4. Minimum string is and maximum string is toll free.
email string Data source did not contain a description for email. Column email has 18109 rows, out of which 11747 are empty, making the null percent 64.87. Minimum string is and maximum string is zodiak@zodiak.fi.
www_fi string Data source did not contain a description for www_fi. Column www_fi has 18109 rows, out of which 3491 are empty, making the null percent 19.28. Minimum string is and maximum string is www.helmet.fi/jätkäsaari.
www_sv string Data source did not contain a description for www_sv. Column www_sv has 18109 rows, out of which 3491 are empty, making the null percent 19.28. Minimum string is and maximum string is www.helmet.fi/busholmen.
www_en string Data source did not contain a description for www_en. Column www_en has 18109 rows, out of which 3491 are empty, making the null percent 19.28. Minimum string is and maximum string is www.helmet.fi/busholmen.
address_po string Data source did not contain a description for address_po. Column address_po has 18109 rows, out of which 14572 are empty, making the null percent 80.47. First 25 characters of minimum string: ... and first 25 characters of maximum string: Ylästöntie 3, 01510 Vanta...
address_p0 string Data source did not contain a description for address_p0. Column address_p0 has 18109 rows, out of which 14837 are empty, making the null percent 81.93. First 25 characters of minimum string: ... and first 25 characters of maximum string: Örnbräksvägen 6, 01350 Va...
address_p1 string Data source did not contain a description for address_p1. Column address_p1 has 18109 rows, out of which 14864 are empty, making the null percent 82.08. Minimum string is and maximum string is Virtatie 4, 01600 Vantaa.
streetview string Data source did not contain a description for streetview. Column streetview has 18109 rows, out of which 17901 are empty, making the null percent 98.85. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://www.kulttuuriespo...
extra_sear string Data source did not contain a description for extra_sear. Column extra_sear has 18109 rows, out of which 13448 are empty, making the null percent 74.26. Minimum string is and maximum string is YoYo.
accessibil string Data source did not contain a description for accessibil. Column accessibil has 18109 rows, out of which 16578 are empty, making the null percent 91.55. Minimum string is and maximum string is +358 9 931 052 641.
accessibi0 string Data source did not contain a description for accessibi0. Column accessibi0 has 18109 rows, out of which 16810 are empty, making the null percent 92.83. Minimum string is and maximum string is yucel.tozalan@palmia.fi.
accessibi1 string Data source did not contain a description for accessibi1. Column accessibi1 has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: 00:unknown,11:green,12:gr... and first 25 characters of maximum string: 00:unknown,11:unknown,12:...
created_ti date Data source did not contain a description for created_ti. Column is empty.
modified_t date Data source did not contain a description for modified_t. Column is empty.
service_id int Data source did not contain a description for service_id. Column service_id has 18109 rows, out of which 3792 are empty, making the null percent 20.94. Minimum value is 42 and maximum value is 1022.
service_fi string Data source did not contain a description for service_fi. Column service_fi has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: 1. luokalta alkava sovelt... and first 25 characters of maximum string: öljyntorjuntavarikot...
service_sv string Data source did not contain a description for service_sv. Column service_sv has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: A1-engelska (språkprogram... and first 25 characters of maximum string: övrig säkerhetsservice (f...
service_en string Data source did not contain a description for service_en. Column service_en has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: A1-English (basic educati... and first 25 characters of maximum string: zoos,water bus platforms...
datanomist string Data source did not contain a description for datanomist. Column datanomist has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Palvelukartta.
paivitetty date Data source did not contain a description for paivitetty. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POINT (0.00060510880115 0... and first 25 characters of maximum string: POINT (29.49847652354771 ...
geom_center_x float Longitude of center. Column geom_center_x has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 29.5.
geom_center_y float Latitude of center. Column geom_center_y has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 61.56.
geom_type string Geometry type. Column geom_type has 18109 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POINT.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 7, 2022
Created July 5, 2022