GpE’s …

"that we would do we should do when we would" (William Shakespeare)

ISTAT’s Italian municipalities dataset

2018-04-23 

Over the years it happened to me to come across stuck situations trying to manage business changes in the Italian’s municipalities archive. My advice has always been the same: take advantage of the well engineered and up-to-date dataset exposed by ISTAT (Italian national statistics institute). You can download excel as long as csv versions and there’s plenty of descriptions for each field/entity.

My hopefully appreciated two cents has been to make available a slightly revised version to avoid some unnecessary data redundancies. You’ll be able to load everything on you database just running the script.

 

On the right the revised data model. “GpE” ‘s prefixed entities are the modified/added ones. One note: the model has a logical value which means that y0u won’t find a strong referential integrity on your “after script” physical schema.

Updates will reflect the original site’s ones.

​

Find here a  demo with some PHP lines of code.

DOWNLOADS

CSV

FIELD SEPARATOR: ‘;’ HEADERS: Y

Microsoft Access 365 (accdb file). Unzip  and use.

PostgreSQL                                DDL: sì DATI: sì

ENGINE: InnoDB DEFAULT CHARSET: utf8mb4 COLLATE: utf8mb4_unicode_ci DDL: Y DATA: Y

DDL: Y DATA: Y

DDL: Y DATA: Y

DDL: Y DATA: Y

SQLite “db” file. Unzip and use.

DDL: Y DATA: N Use your preferred tool to load CSV data.

Send your feedback…

© 2019 Giampaolo Erriquez

OK