Hi
Thanks for the referral, Fredrik!
The site referred to above is the ice database of the Finnish DN Icesailing Association. We designed the database to make it possible to keep track of our sailing friendly lakes and bays. The database has permanent data and icereport data for each sailing location and separate user interfaces for browser and mobile phone access.
The permanent data:
Area = name of the lake or bay
Locality = name of closest town
Location = GPS co-ordinates
Description = Free text description of the sailing site
Drive instructions = Free text for driving instructions
Road link = link to www page with map to the site. e.g. google maps
Weather link = link to weather forecast oft
Size of area = sailable area
Accommodation = www and street adress and phone number to recommended and nearby accomodation
Store address = street address to closest shop
Miscellaneous = free text, we usually use this for inserting the name and phone number of the local farmer who lives by the lake
Only the user who has originally created the permanent data can edit or remove any of the information above. This way we do not rely on any central administrator to maintain the information, it is maintained by the originating user.
The ice-report data:
Ice = Ice thickness in cm
Snow = snow thickness in cm
Description = free text to describe the ice
Anyone can leave an ice report to any of the locations to update the "Fresh" information. The database keeps 5 latest updates.
The data is used through a nice graphical user interface with icons for the key informations. Please visit our site and have a look!
Accessing the database via smartphone is made easy through a dedicated mobile user interface:
http://www.dn-finland.net/jaatieto/mobile/browseareas.php?lang=ENG Through this interface anyone can insert the ice and snow thickness and upload a picture of the ice using a smart phone on the spot. I encourage you to test this with your smart phone to get a feel for how it works.
The database is currently translated into English, Swedish and Finnish languages and is easy to translate further. The database is written in php and runs on a MySQL database, both of which are standard services offered by web hotels. Design and requirements for the software were done by the Finnish DN Ice Sailing association and the software development was done by a local software company.
Please visit our database and have a look. We, DN-Finland, own the copyright to the software and would be happy to help you setting up your copy.
See you on the ice!
Timo L-731
Communication Officer
Finnish DN-Icesailing Association
http://www.dn-finland.net