I would like to set up a local reverse geocoding service for the country codes (exactly the same as http://ws.geonames.org/countryCode). But how is this done?
I have tried to import all coordinates and country codes for the desired countries but this is an amazing amount of data and so the SQL queries take their time.
Is there any way to define the border lines as polygon, because this would be much more performant with fewer data records, I guess.
The GeoNames webservice is quite fast, so how can this be done?