List of Irish Towns & Counties

tomED

I know it's a bit cheeky, but has anyone got a DB dump (or similar) of all the towns in Ireland categorised by counties?

Something as deep as Daft.ie go is really what I'm looking for.

Thanks a million

aidan_walsh

http://en.wikipedia.org/wiki/List_of_towns_and_villages_in_the_Republic_of_Ireland ?

tomED

Hi Aidan

Thanks for that - I was actually being even lazier than that and looking for an actual DB dump! Something that I wouldn't have to do much manual labour with!

ChicoMendez

tomED wrote: »

Hi Aidan

Thanks for that - I was actually being even lazier than that and looking for an actual DB dump! Something that I wouldn't have to do much manual labour with!

hi there
theres one on the net somewhere that i came across before. ill look aroudn and see do i still have it somewhere

tomED

Thanks Chico - I had a quick look and couldn't find one. I know there's a county list alright - I usually nick that from Michele's blog.

It's the towns/villages that I need too!

Ta!

tomED

Here's an example of what I'm looking for - but have noticed a few anomolies in this one... and it's UK aswell

http://www.pandemedia.biz/resources_town_county.php?country_id=4

ChicoMendez

no worries


here it is http://www.maxmind.com/app/worldcities

just have to take the irish ones out of the reat

the db for the countires(regions) should be somewhere on that site also somewhere

cheers

tricky D

This might do the trick

irishtownlands.csv

tomED

tricky D wrote: »

This might do the trick

irishtownlands.csv

Tricky - yer a legend!!!

Much appreciated man! Thanks!!!

k.p.h

Spent a while trying to get this into SQL, partly because I'm a noob but mostly because I'm an idiot

But just in case anyone else needs it at some stage, might save some time.

http://pastebin.com/CSGWZgk2

Jim2007

k.p.h wrote: »

Spent a while trying to get this into SQL, partly because I'm a noob but mostly because I'm an idiot

For the next time, here is a tip I picked up from a USER, who seem to be able to generate SQL from a CSV file at lightening speed

- Import CSV file into Excel
- Parse into columns
- In right most column write an Excel function to generate SQL, picking up values from left most columns
- Replicate function to all cells in the column
- Copy column containing SQL and past as values into text file
- have a coffee, your done!!!

The Excel function would looking something like:

="INSERT INTO.... VALUES(" + A15......" you get the idea

dwliston

Tricky do you have this so that the Town names are in English?

KonFusion

This thread is 4 years old.

Just PM him :P

Locked.