wikiPlants started as an experiment with the Screwturn Wiki engine, an opensource wiki based on the C#.net programming language.  Unfortunately, Screwturn could not handle the original amount of data stored in SQL Server 2005.

Now, the same information from the United States Department of Agriculture is served from TikiWiki.  The TikiWiki engine runs on an Apache server via the PHP programming language with data stored in a MySql database.  TikiWiki is far superior to Screwturn although additional functionality is constantly coming through the pipe of opensource contributions.

To see wikiPlants in action please click here.

Run The Nation makes the sport of running more accessible to all types of runners by listing and mapping a variety of races and providing online training tools.  Find 5k, 10k, half marathon and full marathon races on interactive maps.  Read news about races in your area or use a free suite of calculators to track your progress and set goals.

http://www.runthenation.com/

For years Matt Burgess searched newspapers, magazines and his neighbors for a list of the best Christmas lights in Richmond, Virginia. He wasn’t the only one taking part in a tradition known as the Tacky Light Tour that organically started in the early 1980s. Thousands of pack minivans, rent limousines and charter buses for the annual event, which is known for causing traffic jams and keeping the electric company profitable. However, he was the first to optimize his tedious search by building a website complete with interactive maps and driving directions.

What started as a guide to Richmond’s Tacky Light Tour in 2005 has now grown to over 100 cities and 180 displays with over 7 million Christmas lights combined. TackyLightTour.com allows decorators from around the world to list their display if it has over 10,000 lights. The information collected from decorators is freely available to online visitors in the form of interactive maps and custom driving directions.

TackyLightTour.com is known as a mashup, which is a web application that combines data from more than one source into a single integrated tool. The technology “mashes up” Microsoft Virtual Earth, Yahoo Maps and the GeoName geographical database with information collected on the website.

Each mashup source plays a key role in the overall experience. A variety of maps are available in 2D and 3D modes using Microsoft Virtual Earth, which offers interactive controls like zooming, panning and satellite imagery. The Yahoo Maps service is used to generate a single list of driving directions for up to 25 Christmas displays. The GeoName geographical database is used for geocoding.

According to Matt Burgess, all the sources are crucial elements but they all hinge on the ability to geocode locations. Geocoding is the process of retrieving latitude and longitude coordinates for a physical address. Every address entered into TackyLightTour.com is geocoded. The coordinates are then used to determine distance. This is especially crucial for custom driving directions where the order of a route depends on a series of the shortest distances possible to ensure the shortest overall route possible.

Thanks to this unique combination of technologies, families and friends throughout the country can put down their maps and pick up a mouse to plan their own tour of over-the-top Christmas lights.