servicemap
address
id, number, number_end, letter, modified_at, location_type, location_coordinates_0, location_coordinates_1, street_id...
Many rows
administrative_division
id, origin_id, ocd_id, service_point_id, start, end, modified_at, type, parent...
2,760 rows
announcement
id, title_fi, lead_paragraph_fi, lead_paragraph_sv, lead_paragraph_en, content_fi, content_sv, content_en, external_url...
2 rows
department
id, parent, business_id, name_fi, abbr, street_address, address_city, address_postal_full, www...
640 rows
observation
unit, id, property, time, expiration_time, value_fi, name_fi, value_sv, name_sv...
Many rows
service
name_fi, name_sv, name_en, id, period_enabled, clarification_enabled, keywords, root_service_node, unit_count_municipality_helsinki...
900 rows
service_node
id, children, name_fi, name_sv, name_en, service_reference, last_modified_time, level, parent...
1,140 rows
unit
id, connections, accessibility_properties, identifiers_0_namespace, identifiers_0_value, identifiers_1_namespace, identifiers_1_value, department, root_department...
Many rows
unit_connection
id, section_type, name_fi, www_fi, email, phone, contact_person, unit, www...
14,121 rows