Reactive
Build your app
Catalog ›Education & public sector ›Townhall — municipal management › Territory

Territory

Part of the Townhall

The codes an office needs every day, straight from official open data: Italian municipalities with their ISTAT code and plate code, always at hand.

▶ Use this app

data space «townhall-en» — this micro app reads and writes the suite’s shared data space.

What it records

  • Municipality (e.g. Roma)

The other micro apps in the same suite

📊Dashboard🗂️Registry🚧Reports📜Acts📅Front desk

How it works

This is a Reactive app: a plain text document that your browser turns into a working app — forms, live data, tables, statistics and even charts, with nothing to install or configure.

  1. Use it right away. Hit “Use this app”: it opens right in your browser, ready to go, with data saved only on your device.
  2. Your data stays yours. Everything is stored locally on your device, kept separate for each app: no account, no server, nothing to set up.
  3. Make it your own. The text below is the entire app: copy it, tweak fields, views and words, and your changes become interactive instantly.
  4. Share it as a file. An app is a simple file: save it, export it or share it with a link; and with encrypted collaboration several people edit the same data in real time.
The app’s source
# 🗺️ Territory

## Official territorial references (open data)

The codes an office needs every day, straight from official open data:
Italian municipalities with their ISTAT code and plate code, always at hand.

::input[od_cityq]{placeholder="Municipality (e.g. Roma)"}

::od-query{into="od_territory" sql="SELECT LABEL_COMUNE_IT AS city, SIGLA_AUTOMOBILISTICA AS plate, CODICE_COMUNE AS code, CODICE_PROVINCIA AS province FROM voc_istat_cities WHERE DATA_FINE_VALIDITA = '31-12-9999' AND LABEL_COMUNE_IT LIKE '%' || UPPER('{#od_cityq}') || '%' ORDER BY city" limit="20"}

:::table{path="od_territory" headers="Municipality,Plate,ISTAT code,Province code" search="false" pagesize="5"}
{city} | {plate} | {code} | {province}
:::

## Find more public datasets

Describe the data you need in plain words (e.g. "classification of
professions") and discover the official datasets available, each with a
ready-to-copy query.

::od-search{}