Korbinus

Here is the MySQL function to use to get the current datetime as ISO 8601 format as asked in DarwinCore:

DATE_FORMAT(NOW(),'%Y-%m-%dT%TZ')

DATE_FORMAT() is obviously a function for formatting date and time, and we are using here %Y for four-digit year, %m for two-digits month, %d for two-digits day and %T for 24-hour time (hh:mm:ss). NOW() gives the current datetime.

And then you get a nice figure like this one:

2009-06-10T07:43:12Z

Note that the same result can be achieved with:
CONCAT(CURDATE(),'T',CURTIME(),'Z')

Where CONCAT() is used for concatenating strings, and CURDATE() and CURTIME() give respectively the current date and the current time.

Read the news here.

I’ll test that as soon as I can and after I’ll update geo:truc.

geo:truc provides snippets of code in different formats (microformat, geoRSS, KML and more) when a location is found.

It provides now code for embedding a map as an image in a web page: just choose the option ‘Google Maps (static)’ in the drop down list in the right box on top of the map. An HTML image tag will be generated, invoking the Google Maps API.

The image has a dimension of 400×300px and it will be necessary to add a Google Maps API key when publishing on the Net. Zoom and map format are taken from the current map displayed in geo:truc.

An exemple of code for the Eiffel tower in Paris:

<!-- replace YOUR_API_KEY with your Google Maps API key. Get it at http://code.google.com/apis/maps/signup.html //-->
<img src="http://maps.google.com/staticmap?zoom=16&size=400x300&maptype=hybrid&markers=48.858205,2.294359&sensor=false&key=YOUR_API_KEY" />
<!-- generated by geo:truc - http://www.geotruc.net //-->

Et voilà! The result, after replacing YOUR_API_KEY by the one for the domain korbinus.net:

Now geo:truc can be read in swedish. It supports also OpenSearch, which means that you can start searching from your toolbar in Firefox without visiting first the site. I haven’t tested it yet on other browsers but that should make it.

Read more

• geo:truc [www.geotruc.net]
• geo:truc in swedish [www.geotruc.net/?hl=sv_SE]

So I finally added support for other languages in geo:truc. It is now possible to use it in french.

Next step is to have swedish support.

Read more

• geo:truc [www.geotruc.net]
• geo:truc in french [www.geotruc.net/?hl=fr_FR]