servicemap

Custom SQL query

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

administrative_division_type

id, type, name

22 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

street

id, modified_at, municipality, name_fi, name_sv

10,780 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