"that we would do we should do when we would" (William Shakespeare)
Latest update: mar 4th, 2019
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.
FIELD SEPARATOR: ‘;’ HEADERS: Y
DDL: Y DATA: N Use your preferred tool to load CSV data.
© 2019 Giampaolo Erriquez