QUALITY 'OF THE DATABASES often think that new technologies can automatically solve the problems of data quality, thereby helping to simplify administrative procedures and reduce the time waiting and working for public offices and their customers (citizens).
The new tools available to the various agencies, in reality, can help to improve the performance of services, increase profitability and reduce delivery times, but first need to available data are correct, the only way it will be possible to achieve better results in terms of increasing efficiency and provide services.
The websit can be considered as a kind of "container" within which you can enter various data banks, which have a link between them (the link can be made through street and house number or through register data) and obviously the databases must have a solid baseline that is what we call "base maps" (buildings, streets, house number and orthophotos). The quality delle banche dati inserite gioca quindi un ruolo fondamentale per il corretto funzionamento dell’intero sistema.
I tempi necessari per la costruzione di un servizio di WebSit efficiente, sono lunghi poiché per funzionare in modo ottimale e soddisfare il maggior numero di richieste, questo deve essere costruito partendo da una base di dati ordinati e precisi.
Un Websit strutturato in maniera arbitraria non raggiunge un buon livello di precisione e le operazioni di analisi e di lettura saranno limitate.
Inoltre il WebSit SIGIT messo a disposizione dei comuni non è a Geographic Information System as others, in fact, differs in its ability to improve: OFFICE ultrasonography through the ability to edit and update data (place names and register real estate) in it.
The base of the websit is made up of streets and civic buildings, and these elements will be connected to all the information from different databases and municipal.
Particularly important is the number, which for example may be connected to the database dell’ufficio anagrafico comunale permettendo così una spazializzazione della popolazione sul territorio. Ogni iscritto nei registri comunali può essere rintracciato sul territorio. Nel WebSit il numero civico è legato al fabbricato di riferimento quindi la popolazione è collegabile al fabbricato, che tra i vari dati possiede anche quelli catastali fino alla divisione in subalterni. Con pochi passaggi, si ha quindi la possibilità attraverso un numero civico di ottenere tantissime informazioni territoriali, sociali ed economiche; ad esempio si possono incrociare i dati dell’ufficio anagrafico (popolazione), dell’ufficio tecnico (pratiche edilizie, PGT), dell’ufficio tributi (Ici – Tarsu-Tia), dei lavori public and communal property (parks, cycle paths), local police etc ... through the identification of the data in the area.
The potential of the websit are many but it is easy to see that to achieve all this is essential given that the "home address" is unique and correct. The interaction between different banks can take place if their data are correct, otherwise you need to proceed with a phase of data cleansing.
To better describe the problem of reclamation of the city as we try to illustrate some case studies found at the crossroads of the municipal database.
| Let's look at the housing unit located at the corner of two streets. We have a single house where a family resides composta da 3 elementi. Data per certa la corretta nomina dei tre numeri civici sulle due vie abbiamo: - civico n°22 di via XXV Aprile – Carraio - civico n°5 di via Carducci – Pedonale - house No. 7 Via Carducci - Pedestrian |
analysis of the databases provided by the municipality in which the house is returned reference (the main house) that they are connected to the information office You can find these informazioni:
Banca dati ANAGRAFE | Civico di riferimento via Carducci 5 (dove è stata assegnata la residenza) |
Banca dati ICI | Civico di riferimento via Carducci 7 |
Database TIA | Municipal Reference away XVV April 22 |
Database REGISTER | Civic reference Via Carducci 9 (detailed in the land) |
It is clear that before attempting to cross these data banks automatically becomes impossible and is therefore need to operate manually to achieve consistency between the databases mentioned above. Office software through the ultrasound can be identified on maps the main street in this case is No. 5 on A Street - Pedestrian. At this point it is necessary, because everything works, that the civic internal reference to other databases to be modified depending on the main street identified .
| Other popular event is the presence of accessible entrances not numbered, marked for example as a result of surveying in the field of numbering. OFFICE Through the use of ultrasound is possible fix these "empty" (the master Regulation provides for the numbering of all these access road). In this case, the placement of house numbers could be following: - 1 PEDONALE – principale - 1/A CARRAIO - secondario - 3 PEDONALE - principale - 3/A CARRAIO - secondario |
Una volta bonificato da questi errori lo stradario digitale (le banche dati), il Websit diventa la semplificazione digitale della realtà, meno soggetta ad errori e senza dubbio utile per molteplici scopi.
È molto importante inoltre controllare la sintassi dei toponimi delle vie. Per fare ciò potrebbe essere utile seguire le linee guida fornite dall’Istat.
Below is what was communicated to the Istat-SIGIT CST.
Activities for the improvement of municipal street:
- complete the street in this registry
- the street should be unique within the commune
- the name of the streets should be recorded in full, complete spacing the words with a space, no abbreviations and spelling errors and capital letters, preferably with the description given in the relevant resolutions of the place names of which you can find a copy. Conventionally, in an electronic addresses are listed in order Alphabetical excluding the species (DUG, urban generic name) that identifies the type of street name (street, square, waterfront, climbing, etc. ..) and any supplement to the DUG (prepositions are not strictly related to the designation of the name, like gods, , of the li ... etc). for reasons of electronic follow the following rules:
· the streets that bear dates expressed in Arabic numerals (eg, via August 18, 1944) are at the top list
· the streets that bear dates expressed in Roman numerals, appear in letter for the first character (eg VIALE IV NOVEMBRE is inserted in the letter "I")
· the vie intestate a “FRATELLI” (es. VIA FRATELLI ZONDINI) o “SORELLE”(es. VIA SORELLE JACCHIA) sono inserite rispettivamente nelle lettere “F” e “S”.
· le vie intestate a religiosi, precedute dall’attributo “DON” (es. VIA DON MINZONI) o “PADRE”(es. VIA PADRE VINICIO DA SARSINA) sono inserite rispettivamente nelle lettere “D” e “P”.
· the streets made out to personal names with honorifics (eg GENERAL CAPITAL. . etc.) are inserted respectively with the letters "G" and "C".
· the streets with proper names to sort follows the letter of the surname, unless otherwise indicated in the resolution. This name is often a problem of how to order, some municipalities use a duplicate of the best performing name linked by an alias. In one of the shows in the first and last name and last name and first name.
· The change of name for the construction of an electronic archive does not include any structured public communication. The communication must be made only if the name change of the name of the street provided by a special municipal decision (eg VIA GIUSEPPE GARIBALDI PIETRO which becomes Via Mascagni)
Upon completion of the placement of house numbers and place names road map of the base and all the databases that you want to load you can cross them and analyze the results. The utility derived from the intersection of databases can be numerous such as the comparison of tax self-certifications, analysis, identifying the correct placement of the age brackets of the population, etc. ...
Once the territorial basis, and databases are cleared and you can successfully maintain the accuracy of the data for new construction through the procedure developed by SIGIT Professionals, which provides for the allocation civic numbers correct before piling for the collimation off-street-with internal -sheet-subordinate cadastral maps.