I'm willing to create an electoral map from the complete list of addresses of a city (Rome, Italy). I have data (.csv) that relate each address (road and civic number) to an electoral section.
I thought that I should group together into a single shapefile all addresses of each section, but I crashed into an obvious problem: geocoding (via a python script) of such a large number of addresses causes all web geocoding services to stop working for the excessive amount of requests. Is there a way work around this, perhaps downloading the whole bunch of address data for the area I need and then geocoding the addresses offline? Which software can I use to geocode offline?
A second problem, that is marginal as long as I don't manage to solve the first one, is this: even if I had said coordinates, I wouldn't be able to join them together into shapefiles. Any advice on this, too?