unit
1 row where description_sv = "Vid Lantmäteriverkets serviceställen kan du få råd i lantmäteri- och inskrivningsärenden. Du kan också köpa registerutdrag och intyg, dokumentkopior och olika kartor och kartutskrifter. Våra serviceställen har tillgång till riksomfattande register, elektroniska arkiv och geodatamaterial. Du kan alltså få dina ärenden skötta vid vilket som helst av våra serviceställen oavsett var fastigheten eller området som ditt ärende gäller finns." and identifiers_1_namespace = "ptvout"
This data as json, CSV (advanced)
Suggested facets: created_time (date), last_modified_time (date)
| id ▼ | connections | accessibility_properties | identifiers_0_namespace | identifiers_0_value | identifiers_1_namespace | identifiers_1_value | department | root_department | provider_type | organizer_type | contract_type_id | contract_type_description_fi | contract_type_description_sv | contract_type_description_en | is_active | deleted_at | organizer_name | organizer_business_id | picture_url | picture_entrance_url | streetview_entrance_url | description_fi | description_en | short_description | name_fi | name_en | street_address_fi | street_address_sv | street_address_en | www_fi | www_sv | www_en | address_postal_full | call_charge_info_fi | call_charge_info_sv | call_charge_info_en | picture_caption | phone | fax | accessibility_phone | accessibility_email | accessibility_www | created_time | address_zip | data_source | extensions_maintenance_group | extensions_maintenance_organization | last_modified_time | accessibility_viewpoints | root_service_nodes | municipality | service_nodes | services | keywords | location_type | location_coordinates_0 | location_coordinates_1 | address_postal_full_fi | identifiers_2_value | picture_caption_fi | call_charge_info | www | name_sv | short_description_fi | accessibility_shortcoming_count_reduced_mobility | accessibility_shortcoming_count_wheelchair | location | picture_caption_sv | accessibility_shortcoming_count_stroller | address_postal_full_en | accessibility_shortcoming_count_hearing_aid | street_address | contract_type | accessibility_shortcoming_count_rollator | identifiers_2_namespace | address_postal_full_sv | short_description_sv | description_sv | accessibility_shortcoming_count_visually_impaired | short_description_en | description | picture_caption_en | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17894 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 09-16:15", "sv": "\u00f6ppet m\u00e5n-fre 09-16:15", "en": "open Mon-Fri 09-16:15"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Palvelut Suomi.fi-verkkopalvelussa", "sv": "Tj\u00e4nsterna i Suomi.fi-webbtj\u00e4nsten", "en": "Services in the Suomi.fi Web Service"}, "www": {"fi": "https://www.suomi.fi/palvelut/palvelupiste/xxx/946e5f17-c121-455f-b8f5-8932a39695af/palvelut?p=0", "sv": "https://www.suomi.fi/service/servicestalle/xxx/946e5f17-c121-455f-b8f5-8932a39695af/service?p=0", "en": "https://www.suomi.fi/services/servicepoint/xxx/946e5f17-c121-455f-b8f5-8932a39695af/services?p=0"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 37}, {"value": "false", "variable": 98}, {"value": "false", "variable": 105}, {"value": "false", "variable": 92}, {"value": "false", "variable": 102}, {"value": "true", "variable": 104}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 83}, {"value": "false", "variable": 84}, {"value": "false", "variable": 103}, {"value": "false", "variable": 48}, {"value": "false", "variable": 80}, {"value": "true", "variable": 52}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 79}, {"value": "true", "variable": 62}, {"value": "false", "variable": 82}, {"value": "false", "variable": 107}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 58}, {"value": "true", "variable": 53}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 57}, {"value": "true", "variable": 50}, {"value": "true", "variable": 59}, {"value": "true", "variable": 51}, {"value": "true", "variable": 20}, {"value": "false", "variable": 38}, {"value": "false", "variable": 44}, {"value": "indoor_facility", "variable": 500}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 49}, {"value": "false", "variable": 22}, {"value": "false", "variable": 23}, {"value": "false", "variable": 29}, {"value": "false", "variable": 21}, {"value": "false", "variable": 5}, {"value": "0", "variable": 1}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "smooth", "variable": 17}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 34}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 33}] | internal | 4980 | ptvout | 946e5f17-c121-455f-b8f5-8932a39695af | 62d0b5fa-aa79-4c83-af48-7847f12ad285 | 62d0b5fa-aa79-4c83-af48-7847f12ad285 | SELF_PRODUCED | state_service | valtion palvelu | statlig tjänst | state service | 1 | Maanmittauslaitoksen palvelupisteissä saat neuvoja maanmittaus- ja kirjaamisasioissa. Voit myös ostaa rekisteriotteita ja todistuksia, asiakirjakopioita sekä erilaisia karttoja ja karttatulosteita. Palvelupisteissämme on käytössä koko maan kattavat rekisterit, sähköiset arkistot ja paikkatietoaineistot. Voit siis asioida missä tahansa palvelupisteessä riippumatta siitä missä päin Suomea asiointisi kohteena oleva kiinteistö tai muu alue sijaitsee. | Maanmittauslaitos Helsinki | Opastinsilta 12 K | Semaforbron 12 K | Opastinsilta 12 K | http://www.maanmittauslaitos.fi | http://www.maanmittauslaitos.fi | http://www.maanmittauslaitos.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 29 530 1110 | asiakaspalvelu@maanmittauslaitos.fi | 2011-03-25T14:21:10+02:00 | 00520 | www.maanmittauslaitos.fi | kaikki | helsinki | 2020-11-05T16:31:11.074716+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1400, 1402] | helsinki | [322, 244] | [367, 247] | {} | Point | 24.93526 | 60.199146 | Lantmäteriverket Helsingfors | Maanmittauslaitoksen valtakunnallinen palvelupiste Helsingissä | 3 | 5 | 1 | 5 | Lantmäteriverkets riksomfattande serviceställe i Helsingfors | Vid Lantmäteriverkets serviceställen kan du få råd i lantmäteri- och inskrivningsärenden. Du kan också köpa registerutdrag och intyg, dokumentkopior och olika kartor och kartutskrifter. Våra serviceställen har tillgång till riksomfattande register, elektroniska arkiv och geodatamaterial. Du kan alltså få dina ärenden skötta vid vilket som helst av våra serviceställen oavsett var fastigheten eller området som ditt ärende gäller finns. | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [unit] ( [id] INTEGER PRIMARY KEY, [connections] TEXT, [accessibility_properties] TEXT, [identifiers_0_namespace] TEXT, [identifiers_0_value] TEXT, [identifiers_1_namespace] TEXT, [identifiers_1_value] TEXT, [department] TEXT, [root_department] TEXT, [provider_type] TEXT, [organizer_type] TEXT, [contract_type_id] TEXT, [contract_type_description_fi] TEXT, [contract_type_description_sv] TEXT, [contract_type_description_en] TEXT, [is_active] INTEGER, [deleted_at] TEXT, [organizer_name] TEXT, [organizer_business_id] TEXT, [picture_url] TEXT, [picture_entrance_url] TEXT, [streetview_entrance_url] TEXT, [description_fi] TEXT, [description_en] TEXT, [short_description] TEXT, [name_fi] TEXT, [name_en] TEXT, [street_address_fi] TEXT, [street_address_sv] TEXT, [street_address_en] TEXT, [www_fi] TEXT, [www_sv] TEXT, [www_en] TEXT, [address_postal_full] TEXT, [call_charge_info_fi] TEXT, [call_charge_info_sv] TEXT, [call_charge_info_en] TEXT, [picture_caption] TEXT, [phone] TEXT, [fax] TEXT, [email] TEXT, [accessibility_phone] TEXT, [accessibility_email] TEXT, [accessibility_www] TEXT, [created_time] TEXT, [address_zip] TEXT, [data_source] TEXT, [extensions_maintenance_group] TEXT, [extensions_maintenance_organization] TEXT, [last_modified_time] TEXT, [accessibility_viewpoints] TEXT, [root_service_nodes] TEXT, [municipality] TEXT, [service_nodes] TEXT, [services] TEXT, [keywords] TEXT, [location_type] TEXT, [location_coordinates_0] FLOAT, [location_coordinates_1] FLOAT, [address_postal_full_fi] TEXT, [identifiers_2_value] TEXT, [picture_caption_fi] TEXT, [call_charge_info] TEXT, [www] TEXT, [name_sv] TEXT, [short_description_fi] TEXT, [accessibility_shortcoming_count_reduced_mobility] TEXT, [accessibility_shortcoming_count_wheelchair] TEXT, [location] TEXT, [picture_caption_sv] TEXT, [accessibility_shortcoming_count_stroller] TEXT, [address_postal_full_en] TEXT, [accessibility_shortcoming_count_hearing_aid] TEXT, [street_address] TEXT, [contract_type] TEXT, [accessibility_shortcoming_count_rollator] TEXT, [identifiers_2_namespace] TEXT, [address_postal_full_sv] TEXT, [short_description_sv] TEXT, [description_sv] TEXT, [accessibility_shortcoming_count_visually_impaired] TEXT, [short_description_en] TEXT, [description] TEXT, [picture_caption_en] TEXT );