Placemarks from KML

Creating a KML file from MySQL data with PHP

I recently had a need for a PHP script that queries a MySQL database for location-based point data (a LatLong coordinate and some descriptive information) and then creates a KML-file from that data on the fly. A file like this can then easily be loaded into Google Maps, Google Earth and other geospatial applications. In […] Read more..

ECO Sign

QR codes everywhere!

  As you may have noticed, I have been experimenting with QR codes lately. There’s just so much fun you can have with these little black-and-white icons. For your Friday enjoyment, here is a list of where I have used them so far: 3D QR code The example video above is simply a vectorized QR […] Read more..

The Construction Tree

Merry Christmas and a Happy New Year 2011!

Now that the year is almost over, it’s time to step back and look at what we all built over the past weeks… Wherever you are and whatever you celebrate, enjoy your holidays and some relaxing time with your families. I wish you all the best for the new year! Cheers, Alex P.S.: Yes, it’s […] Read more..

Wordpress

How to move your old static HTML website to WordPress (or just start a new one)

I frequently get asked how to set up a small-ish CMS-driven (CMS = Content Management System) website for research groups or other entities. Many of these people have learned that maintaining a static website the “old-fashioned way” (e.g. using Dreamweaver) presents a variety of problems – mainly related to inconsistent content or collaborative editing problems. These issues […] Read more..

Wordpress post revisions

My WordPress Post Revisions Problem

While many functions in WordPress (the self-hosted kind) work like a charm, this one gave me the run-around a few days ago: The auto-saving post revisions that got added to WordPress a few releases back. On our departmental website (http://eco.umass.edu/) that I created in WordPress (works great for this purpose, it’s the “Just-enough CMS!”) we […] Read more..

A lightweight WordPress page

I had read about this trick before but had never had a need to try it out – until now. So here’s a nifty trick for any self-hosted WordPress installation: If you want to add a webpage outside of a WordPress installation that has its own design, yet relies on some of the functions of […] Read more..

Liquid Page – A bookmarklet to rearrange webpages

I was once again changing the design of one of my websites when I realized that it would be great if I could just move things around on a page to preview the changes – without any coding. As it turns out, there is a solution to that problem: A bookmarklet and a few lines […] Read more..