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

Toimipisterekisteri palvelut

No description available for layer avoindata:Toimipisterekisteri_palvelut (Toimipisterekisteri_palvelut)

Tables

Column Descriptions

Toimipisterekisteri palvelutpoint, Avoindatatoimipisterekisteri palvelut, Latest

Column Type Comment
tietopalve int Data source did not contain a description for tietopalve. Column tietopalve has 27569 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 27569.
org_id string Data source did not contain a description for org_id. Column org_id has 27569 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 27569 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 27569 rows, out of which 9 are empty, making the null percent 0.03. 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 27569 rows, out of which 1524 are empty, making the null percent 5.53. 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 27569 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 27569 rows, out of which 6242 are empty, making the null percent 22.64. 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 27569 rows, out of which 9206 are empty, making the null percent 33.39. 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 27569 rows, out of which 728 are empty, making the null percent 2.64. 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 27569 rows, out of which 1348 are empty, making the null percent 4.89. 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 27569 rows, out of which 3251 are empty, making the null percent 11.79. 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 27569 rows, out of which 1135 are empty, making the null percent 4.12. 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 27569 rows, out of which 753 are empty, making the null percent 2.73. 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 27569 rows, out of which 1037 are empty, making the null percent 3.76. 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 27569 rows, out of which 753 are empty, making the null percent 2.73. Minimum string is and maximum string is Vuosaari.
phone string Data source did not contain a description for phone. Column phone has 27569 rows, out of which 8078 are empty, making the null percent 29.3. 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 27569 rows, out of which 8060 are empty, making the null percent 29.24. 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 27569 rows, out of which 8060 are empty, making the null percent 29.24. 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 27569 rows, out of which 8060 are empty, making the null percent 29.24. Minimum string is and maximum string is toll free.
email string Data source did not contain a description for email. Column email has 27569 rows, out of which 16015 are empty, making the null percent 58.09. 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 27569 rows, out of which 5085 are empty, making the null percent 18.44. 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 27569 rows, out of which 5085 are empty, making the null percent 18.44. 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 27569 rows, out of which 5085 are empty, making the null percent 18.44. 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 27569 rows, out of which 18290 are empty, making the null percent 66.34. 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 27569 rows, out of which 18754 are empty, making the null percent 68.03. 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 27569 rows, out of which 18866 are empty, making the null percent 68.43. 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 27569 rows, out of which 26787 are empty, making the null percent 97.16. 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 27569 rows, out of which 16072 are empty, making the null percent 58.3. Minimum string is and maximum string is YoYo.
accessibil string Data source did not contain a description for accessibil. Column accessibil has 27569 rows, out of which 22466 are empty, making the null percent 81.49. 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 27569 rows, out of which 23169 are empty, making the null percent 84.04. 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 27569 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 27569 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 1022.
service_fi string Data source did not contain a description for service_fi. Column service_fi has 27569 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 27569 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 27569 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: A1-Chinese (basic educati... and first 25 characters of maximum string: zoos...
can_add_sc boolean Data source did not contain a description for can_add_sc.
can_add_cl boolean Data source did not contain a description for can_add_cl.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 27569 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 27569 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 27569 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 27569 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 27569 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 palvelutpoint, Avoindatatoimipisterekisteri palvelut, Full history

Column Type Comment
tietopalve int Data source did not contain a description for tietopalve. Column tietopalve has 27569 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 27569.
org_id string Data source did not contain a description for org_id. Column org_id has 27569 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 27569 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 27569 rows, out of which 9 are empty, making the null percent 0.03. 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 27569 rows, out of which 1524 are empty, making the null percent 5.53. 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 27569 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 27569 rows, out of which 6242 are empty, making the null percent 22.64. 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 27569 rows, out of which 9206 are empty, making the null percent 33.39. 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 27569 rows, out of which 728 are empty, making the null percent 2.64. 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 27569 rows, out of which 1348 are empty, making the null percent 4.89. 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 27569 rows, out of which 3251 are empty, making the null percent 11.79. 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 27569 rows, out of which 1135 are empty, making the null percent 4.12. 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 27569 rows, out of which 753 are empty, making the null percent 2.73. 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 27569 rows, out of which 1037 are empty, making the null percent 3.76. 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 27569 rows, out of which 753 are empty, making the null percent 2.73. Minimum string is and maximum string is Vuosaari.
phone string Data source did not contain a description for phone. Column phone has 27569 rows, out of which 8078 are empty, making the null percent 29.3. 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 27569 rows, out of which 8060 are empty, making the null percent 29.24. 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 27569 rows, out of which 8060 are empty, making the null percent 29.24. 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 27569 rows, out of which 8060 are empty, making the null percent 29.24. Minimum string is and maximum string is toll free.
email string Data source did not contain a description for email. Column email has 27569 rows, out of which 16015 are empty, making the null percent 58.09. 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 27569 rows, out of which 5085 are empty, making the null percent 18.44. 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 27569 rows, out of which 5085 are empty, making the null percent 18.44. 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 27569 rows, out of which 5085 are empty, making the null percent 18.44. 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 27569 rows, out of which 18290 are empty, making the null percent 66.34. 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 27569 rows, out of which 18754 are empty, making the null percent 68.03. 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 27569 rows, out of which 18866 are empty, making the null percent 68.43. 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 27569 rows, out of which 26787 are empty, making the null percent 97.16. 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 27569 rows, out of which 16072 are empty, making the null percent 58.3. Minimum string is and maximum string is YoYo.
accessibil string Data source did not contain a description for accessibil. Column accessibil has 27569 rows, out of which 22466 are empty, making the null percent 81.49. 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 27569 rows, out of which 23169 are empty, making the null percent 84.04. 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 27569 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 27569 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 1022.
service_fi string Data source did not contain a description for service_fi. Column service_fi has 27569 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 27569 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 27569 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: A1-Chinese (basic educati... and first 25 characters of maximum string: zoos...
can_add_sc boolean Data source did not contain a description for can_add_sc.
can_add_cl boolean Data source did not contain a description for can_add_cl.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 27569 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 27569 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 27569 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 27569 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 27569 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