adverts.ie Map

Here's a map showing where people are buying and selling items using adverts.ie, powered by Google Maps. To get locations for each county, I used John Handelaar's town/city to geocode utility for Ireland and IShareMaps town/city to geocode utility for the UK (for Northern Ireland), along with the names of the county towns from Wikipedia.

20060802a.png

Edit: It took a while to gather these geocodes, so I'm pasting here for those who may find them useful (for counties in the Republic of Ireland and Northern Ireland).

+-----------+-----------+-------------+
| lat       | lon       | description |
+-----------+-----------+-------------+
| 54.700000 | -6.200000 | Antrim      |
| 54.350000 | -6.666666 | Armagh      |
| 52.835510 | -6.930966 | Carlow      |
| 53.991311 | -7.361547 | Cavan       |
| 52.842932 | -8.985514 | Clare       |
| 51.894768 | -8.493410 | Cork        |
| 55.000000 | -7.333333 | Derry       |
| 54.833900 | -7.480600 | Donegal     |
| 54.316666 | -5.700000 | Down        |
| 53.344104 | -6.267494 | Dublin      |
| 54.366666 | -7.633333 | Fermanagh   |
| 53.275733 | -9.070914 | Galway      |
| 52.269440 | -9.709956 | Kerry       |
| 53.220781 | -6.658838 | Kildare     |
| 52.654328 | -7.249180 | Kilkenny    |
| 53.035700 | -7.300800 | Laois       |
| 53.944800 | -8.084700 | Leitrim     |
| 52.677338 | -8.614351 | Limerick    |
| 53.732305 | -7.805288 | Longford    |
| 53.999744 | -6.399023 | Louth       |
| 53.855500 | -9.297100 | Mayo        |
| 53.654186 | -6.689197 | Meath       |
| 54.249673 | -6.969461 | Monaghan    |
| 53.276900 | -7.490200 | Offaly      |
| 54.600000 | -7.300000 | Omagh       |
| 53.629759 | -8.192296 | Roscommon   |
| 54.269734 | -8.473116 | Sligo       |
| 52.474876 | -8.157204 | Tipperary   |
| 52.259034 | -7.108192 | Waterford   |
| 53.527300 | -7.338600 | Westmeath   |
| 52.338448 | -6.463445 | Wexford     |
| 52.990116 | -6.079859 | Wicklow     |
+-----------+-----------+-------------+

Comments

Fixed the link to John

Fixed the link to John Handelaar.

Hehe - just as I was about to

Hehe - just as I was about to fix the Galway bug, our network went down for maintenance - fixed!

Steve - I only started reading about Google Maps yesterday so it really is very straightforward - first, I read up at:

http://www.google.com/apis/maps/documentation/

Then, I coded a bit of PHP to pull a total count of products in the database matching a particular county, and drew a marker (using Google's letter icons) for each county (town) using the coordinates listed above. If you look at the HTML source code for map.php you can copy and paste the JavaScript sections and fiddle around with it yourself.

John, slight Bug, when I

John, slight Bug, when I click Cork, it links to the correct page but the link says 'Galway' not Cork.

Nice work John but there

Nice work John but there appears to be a bug - regardless of which marker I click on I get the link for Galway. Eg. when I click on the Waterford Marker I get this -

"Waterford:
There are 20 adverts in this county.
Show all adverts in Galway."

By the way Geonames.org is also a very good resource for geocoding with detail to to small county towns and even villages.

Hi John, I have noticed a

Hi John,
I have noticed a bug, when you hover over a county for every county when you click the letter it says Show adverts in Galway

Hi John, I would be curious

Hi John,

I would be curious to know more about how you where able to build this Google map onto your site. I have two other questions about it.

1. When you click on a county link, Louth for example, it tells me there are 28 adverts in Louth, but then it has a link to Go To All Adverts in Galway. This "Go To All Adverts in Galway" link appears to be on the markers for each county. Should the link not read "Go To All Adverts in (respective county)", or are you just very keen to promote th Galway adverst ;)

2. Your link in your post for "John Handelaar’s town/city to geocode utility for Ireland" is dead.

Good work on Adverts.ie, I love it.

Steve