Audubon Photo Contest

Written by charlie   
Friday, 29 April 2016 18:00
Check out the Audubon Society's photo contest winners, the photos are all amazing, but the one of an eagle swooping down to snatch a fish out of a Blue Heron's grasp is magnificent!

Link Here: Audubon Photo Winners
Last Updated on Friday, 29 April 2016 18:05

Atlas Obscura

Written by charlie   
Thursday, 28 April 2016 01:35
Atlas Obscura, the always amazing and thought provoking travel website full of strange, wondrous or merely overlooked destinations has a motley bunch of entries tagged "wetlands" here A few articles are tangential, but the entry for Panjin Red Beach in Liaoning, China, in one of the worlds largest wetlands, is the most eye catching. At first glance, it looks like a photoshop trick, but the rich crimson and cranberry reds in the photos run true.

The estuaries unique combination of salinity, fluctuating water levels and alkalinity allows a distinct species of the common seepweed, a halophile or salt loving species with thick, succulent like leaves to thrive. The leaves turn a crimson red fading to purple as it matures in autumn. The fields of seepweed are not limited to a small area, but a horizon to horizon view encompassing 51 square miles, attracting many tourists, but remain threatened by oil drilling and wells. It is also home to some 250 migratory birds.

The other article, is a good jumping off point for learning more about some of the largest, and little known wetlands in the world. It skips from continent to continent, from the Pantanal in Brazil through the southern forested wetlands in the United States, and lowland African wetlands and New Guinea’s Giant River Swamps. It doesn't mention the bogs of Siberia, but its definitely worth a read and a forward.


Extracting all articles from an old MediaWiki Database

Written by charlie   
Tuesday, 19 April 2016 20:48
The Wetland Wiki, with almost 200 articles was successful for a few years, but writing constant wiki style articles and combating incessant spam was tiring. Combining this with the improving coverage on wetands at Wikipedia, made it time to close the Wiki. Short sightedly, I closed the wiki rather than than maintaining it, leaving me with an dated, unsupported version of Mediawiki, with some good articles residing in the database. Mediawiki offers a bunch of export options, but all I had was the MySQL datbase. What to do? Goto Stackoverflow of course! I Found the following snippet of code to run in phpmyadmin, which extracts the last revision of the page text and title, which can be easily exported to a csv file. The csv still retains the wiki styling, but with a little effort, all page data can be retrieved. The Sql is as follows:

SELECT page_title, page_touched, old_text
FROM revision,page,text
WHERE revision.rev_id=page.page_latest
AND text.old_id=revision.rev_text_id;

The Wetland Wiki was published under the Creative Commons, and the csv file of all of the articles in a semi readable format is is available here: Wetland Wiki extract

Last Updated on Wednesday, 27 April 2016 01:26

Page 3 of 51

<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Twitter Feed