Where is that city?
Some time ago I downloaded a large database of cities around the world, with their geographical locations (latitude and longitude). Now that I'm writing an article on the eZ components for php|architect I was going to demo a small import script and a SOAP service that uses this information. But I didn't have the vagest clue where I got this database from, and what its license was.
What I did remember is that I read it somewhere on planet PHP and with some backtracing I found Henri's post which lead me to the site of MaxMind . This company provides a list of a few million cities including geo-coordinates. They provide it under a very nice license as well. In a few more days I'll be publishing the client so that you can use this Web service as well.
Comments
Thanks for the info. I was just looking for such a database yesterday.
Now for the big question, will either Google or Yahoo go seriously international in their street maps?
They have .. try http://maps.google.co.uk/
Why SOAP? Use REST.
Later... I just wanted to play with the SOAP extension :)
Life Line
Updated an information and a bench
Created 2 benches
Created 4 picnic_tables, a bench, and a fitness_station; Updated a pub and a sport club
Created 2 benches and 2 waste_baskets; Updated 4 benches, a bus_stop, and a cafe; Confirmed a dentist
Created 3 waste_baskets, 2 main entrances, and a bench; Deleted a cycle_barrier, a bench, and a waste_basket
Created an information; Updated a waste_basket and a bench
Updated 2 waste_baskets and a bench
Created 3 benches
Created a waste_basket; Updated 2 benches and a tree
I walked 3.5km in 35m31s
Created a main entrance and a home entrance
Created an entrance
Updated a house building
Created an entrance
I walked 5.8km in 1h15m06s
I've just finished reading "A Cheese-Monger's Tour de France", by Ned Palmer.
Now I want to try many of those! 🧀
I'm thrilled to announce that I'll be speaking at the 23rd edition of #phpday, the international PHP conference in Italy, organised by @grusp.
I’ll be presenting a talk titled: "Better Debugging With Xdebug".
It's in Verona, Italy, on May 14-15th 2026.
You can use my speaker’s discount code "speaker_10OFF" for 10% off at https://www.phpday.it/tickets/?utm_medium=organic&utm_source=linkedin&utm_campaign=post-speaker
I walked 5.5km in 1h11m00s
I walked 1.1km in 9m37s
Merged pull request #1066
PHP 8.6: Changes to opcache optimisations wrt function arguments
I walked 10.5km in 1h49m54s
Fixed building type
Fixed addresses and building type
Updated a bus_stop, a waste_basket, and a bench


Shortlink
This article has a short URL available: https://drck.me/witc-4nf