Friday 28 December 2012

Spammers

On Christmas day a number of entries were made on the Pterosaur Database on-line species list.  287 in fact.  They were all random text characters and links to drug sales websites, selling sex aids and other erotica.  Someone had been entering and pasting data manually, as this is the only way the website will accept entries on-line.  What kind of person would spend Christmas Day in this way?

These entries were deleted as soon as they were noticed and we have now updated the entry page to reject any links to E-mail or websites.  Data can still be added to the on-line site,but if a link of any kind is entered, the page will fail to write to the database.  I am please that I made the on-line database read only and installed a parallel entry database.  If such entries had been made directly to the full database, It may have been months before it was noticed.

The same modifications have been made to the Bibliography database uploader and the tests have worked well, so this type of spamming will be less likely in future.

Tuesday 25 September 2012

Mary Anning Weekend

The weekend of the 29th and 30th September is part of the Mary Anning Week event at the Lyme Regis Museum, Dorset.  Mary Anning was a prolific fossil collector who discovered several very well known marine reptiles from the Jurassic rocks and cliffs around Lyme Regis.  She also discovered one of the first recorded English Pterodactyles.
This specimen of Dimorphodon macronyx (then Pterodactylus macronyx) was collected from the Undercliff in the Lower Jurassic Blue Lias at Lyme Regis.  It was described by the Reverend Willaim Buckland in his 1829 paper and the specimen now resides in the Natural History Museum, London.


Several other specimens were found in the Lias following this discovery, including a skull, two tails and a near complete skeleton.  The skull, also now in the Natural History Museum, was drawn by Mary's brother Joseph, using reconstituted belemnite ink from the cliff fossils.  This early drawing is now in the Lyme Regis Museum.
Other illustrations have since been done using this method of ink drawing.  The Annings made a good living selling fossils from the Liassic Cliffs around Lyme.  Many of them can be found in museums around the UK and some have been sent to overseas customers.  The Plesiosaurs and Ichthyosaurs are perhaps their most dramatic finds from this time.



Saturday 1 September 2012

Old Photographs

A couple of days ago I received an enquiry about photographs of some of the obscure type specimens - the sort of fossils that are outside of the main stream of research because they are generally fragmentary remains.  To see if I could provide such photographs I searched my collection of images.  Very little joy in that search as I could only find two of the images, and they were of poor quality.  This inspired me to do a bit more with my negatives.
I do have some old photographs which go back to 1975 and they are mostly kept as negatives or 35mm slides.  This mandible of Rhamphocephalus was taken at the Natural History Museum, London, in 1976; then the British Museum of Natural History. It is digitised from a black and white negative using a film copier and it has remained good after 36 years in storage.
This image is of the upper and lower mandible of Istiodactylus in the University Museum of Zoology, Cambridge, taken in 1986.  The picture was taken using a cheap colour positive film and the chemistry of the slide has changed, degrading the image significantly.

Time is important in protecting old images.  The digital versions may often be less pixilated than good quality film images, but they do not degenerate in the same way.  I now keep all of my digital images on a separate hard drive in two files, my copyright and other peoples copyright.  This drive is backed up an a secure separate hard drive on a monthly basis and most of the images are also stored on a DVD disc.  This ensures that in the event of a crisis, some images will be preserved.

In my office are two boxes of slides and negatives which still need to be digitised.  Some have degraded considerably and may well never be recovered.

I am now looking for photographic images of the following specimens;

Natural History Museum, London
R176 Istiodactylus latidens
37002 Rhamphorhynchus longipes
42735 (Pterodactylus pulchellus) Pterodactylus micronyx
37990 (Pterodactylus longicollum) Diopocephalus longicollum
1640 (Cimoliornis diomedeus) Ornithocheirus diomedius

Sedgwick Museum, Cambridge
B54.443 (Ornithocheirus brachyrhinus)
B54.437 or B54.438 (Ornithocheirus carteri)
B54.499 (Ornithocheirus crassidens) Amblydectes crassidens
B54.544 (Ornithocheirus dentatus)
B54.444 (Ornithocheirus enchorhynchus)
B54.644 (Ornithocheirus eurygnathus) Amblydectes eurygnathus
87822 (Ornithocheirus huxleyi) Lonchodectes oweni
B54.835 (Ornithocheirus platystomus) Amblydectes platystomus
B54.440 (Ornithocheirus polyodon) Seeley 1870
B54.441 (Ornithocheirus scaphorhynchus) Lonchodectes scaphorhynchus

If you have such images that you are willing to share, please send them to pterosaur@ntlworld.com

Sunday 5 August 2012

Searching on-line Part Two

The Pterosaur Database is now on-line in a limited form.  The listing of museums with pterosaur specimens and the listing of collection material has been put on-line in a test format.  The data still needs some adjustment, but it is available for the first time for everyone to search.
The first search up is the specimen search, where you can enter the name of a species or genus and see what comes up.  The data search gives basic information like description, museum and catalogue number as well as a few notes in some cases.


It is also possible to search by specimen type and by Museum.  The museum search is in two phases - firstly the general information search by country, key name words and town/city.  A second search page gives a choice of matches, and a selection of the record number presents a specimen list, as shown below;

First page requiring general information.
Second page giving a choice of matches.
Third page showing the museum list of specimens, postal address, contact telephone number and website where available.

There are several museums with pterosaur material that are represented by only type and figured specimens.  Some museums that hold pterosaur material have not been visited and are therefore not included here.

This database is a read only system to protect the data at source. However, a parallel database has been set up into which new specimens can be added.  When the input has been verified, the entries will be included in the main database.  Corrections can also be entered here by adding the correct entry and describing the alteration in the Notes field.

Any comments on the functionality of the on-line system will be appreciated in order to adapt it to the needs of users.

Wednesday 25 July 2012

Bibliography on-line

For a few weeks, the current bibliography of The Pterosaur Database has been tested on-line.  It is now up and running in its current form, enabling the listing and printing of publications from a database file.
The records are extracted from a SQL database by a simple request program which was written specifically for this purpose.
Just enter an authors surname, part of a title or a date and see what comes up on  the list.
Searching for 'Bennett' brings up 47 publications from a current file set of 1438 records.

The data on this database cannot be amended or added to as it is a static file.  However, we are running a parallel database which can be interrogated and added to.  The data will be verified at intervals and where appropriate, transferred to the main database.  This will prevent corruption of the master database whilst allowing people to add new papers and texts for inclusion.
Feel free to comment on the functionality of the database.

Thursday 7 June 2012

Host Migration

The Pterosaur Database is moving to www.pterosaur.org.uk hosted by UK Web Hosting (Enix Ltd).  The website framework is now running and all of the database search elements should be in place by August.

It is good to have a host that responds rapidly to problems and provides skilled advice and support.  There are a few re-write issues to be resolved as the server structure is different to the previous server for which the website was designed.

Thursday 24 May 2012

The On-line Database Problem

Since February 2012 I have been unable to load data to the on-line database files on the Pterosaur Database.  This has been a concern for some time and I have tried to progress this issue with 1and1 to find out how they are moving on with the server error that is blocking the file uploads.

Unfortunately, the support desk of the company is set up to act as a firewall between the customer and the server administrators.  The server is in Germany and the support desk is in the Pillipines.  This is an on-going problem and after 4 attempts to enquire about progress, this is the best response so far:-

"Thank you for contacting us.

We sincerely apologize for the inconvenience that this has 
brought you,we have already informed our higher department 
regarding how urgent thiscase to be resolved.
And as of the moment they are doing there best to have this 
resolved atthe back end of the server. Once they are able to
find the cause for thisissue and have this fixed then we will 
sent you an email update for this.We understand that you 
might be anxious to have this resolved as soon as possible 
so thank you so much for your patience while we working on
the resolution.

If you have any further questions please do not hesitate to
contact us."

The first update enquiry response 3 days ago, when they had already replicated the error on two previous occasions was:-

"Thank you for contacting us.

We have tried testing in importing database composing of
2 data and it gonethrough. What is the data file size that 
are you trying to import?

If you have any further questions please do not hesitate to 
contact us."

I must say that for years, 1and1 have provided excellent service.  But now, the new support desk is a wast of time.  Each enquirey contact is treated as a new problem by a different opperative. The opperatives generally have a poor grasp of the English Language and they are limited in what responses thay can give.  The general policy seems to be - ask the customer a question, then the enquiry will come back to someone else - it is essentially a "pass it around" culture with no single point of contact responsibility.  When I have asked for the enquiry to be read by a supervisor, the response has been a further question.

My advice is, if you want to use databases on-line, avoid using 1and1 at present.

The datasets, I am sure, will eventually be uploaded, but there is no timescale for the completion of the on-line data.




Sunday 20 May 2012

A tail

 Within the collections on display at the Sedwick Museum, Cambridge is a specimen of a Dimorphodon macronyx tail.  This is catalogue number J.61175 and is part of the Whinborne Collection.  The fossil is from Lyme Regis in Dorset and may have been collected by Mary Anning from the Lower Lias of the Undercliff.  The tail is in a state of dissociation and may be the rotting offcast from a predators meal.
Removing the bones photographically from the matrix shows the caudal vertebrae and the stiffening rods that would have kept the tail rigid in life.  There is also some material on this slab that looks like a sternum fragment.  It is not easily defined from a photograph.  If there was a cartilage running from the sternum to the tail, this would not be an unusual association.

The only other tail of Dimorphodon macronyx is in the Natural History Museum, London.  Specimen number 41349 is a complete and rigid tail with all of the stiffening rods in their natural place close to the vertebrae.  The arrangement of rods is similar to that seen in Rhamphorhynchus.

The long tail of this type of pterosaur would have been used as a balancing organ and would most probably have had a vertical sail at the tip to give the animal directional stability when flying. The sail is only seen in some Rhamphorhynchus specimens where wing membrain is preserved.  Dimorphodon does not show this degree of preservation.

Sunday 13 May 2012

Acronym Confusion

The names of museums are often added to scientific papers as acronyms.  It occurred to me that if the pterosaur database included a searchable list of museum information, the appropriate acronyms could be used to link the museums to specimens.
This idea sounds good, but the truth is that museum acronyms are not standard.  Above is a picture of The Natural History Museum, London.  This is represented in many of the old papers as BMNH or BM(NH).  In newer papers it is seen as NHM, NHM London, NHMUK, NHMGB or BMNHL.  The change in name from British Museum of Natural History to Natural History Museum has been an issue here.
There are a number of websites that allow you to match a museum acronym to a museum.  In Europe, the Natural History Museum London usually comes up as NHMUK;  on U.S. searches it comes up as BMNH.  There seems to be no means of standardising the acronyms across the world, especially in scientific papers that were written some time ago.

To start to address this problem, I have written to the Museums Association in London to see if they have an existing UK standard for acronyms.  Lets see how we go on from there!

If anyone has any sound information I would like to hear about it.

Footnote:  An E-mail from the Museums Association informs me that the old ERGMA system of the 1970's, which allocated a code to every museum, was not supported by all museums and was dispensed with many years ago.  There is no clear standardisation of Museum Acronyms in the UK.

Monday 7 May 2012

Still having server problems

Today all of the web database failed.  There is an issue with the server at 1and1 Internet - the host for the Pterosaur Database.  The support desk is powerless to do anything, but if I leave a message on the 1and1 facebook page, I get a lucid response.  Perhaps this is the way forward.

1and1 have been an excellent host for many years, but my recent experiences are unusually exceptional.  This issue first started in January this year and we are now into May and I have had no contact from the people who control the web servers.  This is not helping the reputation of a once excellent company.

It may be the case that like all big and successful companies, the infrastructure becomes overloaded as costs are cut.  As soon as we are able, the database pages will be re-instated.

Should this problem persist much longer Then a new host company may be the only solution to the problem.

Footnote: within a couple of hours of posting on the 1and1 facebook page, the databases were restored and running.  There are still issues with uploading data, but at least the uploaded data is now accessible again.

Sunday 1 April 2012

Brick Wall

The specimens on-line data has been loaded to The Pterosaur Database website in part.  The original Pterosaur Database specimen list is far too big and cumbersome to be fully on-line, so we have extracted basic information into a new database.  This entailed uploading 22 file sets to an on-line access database.  So far 3200 specimen records have been loaded, the remainder just will not load.

The website is hosted by 1and1 on a server in Germany.  This company has provided an excellent service for us since last century.  Even when they moved their local help desk service to India, the service was swift.  Now they have re-organised the company and moved the help desk service to the Philippines where I have to say, the service response is scripted and discontinuous, most of the 'help desk clerks' not understanding the systems they are there to help people with.

After a recent server migration to a new Apache server (to streamline and update the 1and1 service) a number of errors have been experienced with the web database uploads.   HTTP 500 errors suggest a server malfunction of indeterminate type.  HTTP 403 errors suggest a likely URL pointer trying to link with a directory entry instead of a web page or program.  We have been struggling with these errors on the server system for 3 weeks now.

The 1and1 help desk say they are trying to resolve the issue as soon as possible (24 E-Mails and 2 phone calls on) and as soon as this issue is corrected, I shall install the remainder of the specimens to the on-line database.  We no longer have any means of communicating with the server developers, and there is no specific timescale for the resolution of the problem.

Friday 2 March 2012

On-line Data


For quite some time, The Pterosaur Database has been held on Microsoft Access files.  This format can be used on-line as a searchable database, and now we have produced the code to do this for the bibliography.  The pilot is accessed from the bibliography drop down menu as On-line Search Tool.


The first search page will accept a general search string for the whole database.  This will return any instance of the string in any field.  Searching for Kellner as an author will at present return 86 records.


The detail is visible when you click on the end of line link.  This will show the whole database entry for that particular record.  The bibliography database is a flat file (only one database) so the return is standard throughout.


For a more specific search, you can click on Extended from  the main search page.  This will enable a search of individual data fields.


This is a trial run at the moment, to identify the functionality of the database on line.  There will be flaws in the system that will require improvement.  If this data set runs well, the specimens data set will be the next step.  That may be updatable with user password control, but at present, the only user update system is by E-mail from the home page.

Constructive comments welcome please.

Wednesday 11 January 2012

Birds and Pterosaurs

Pterosaurs and birds were both competing for space in the Mesozoic skies.  However, the pterosaurs diverged as an order before the birds, and this was a clear advantage.  If the number of currently defines species are plotted on a graph by geological age, an interesting trend is observed.


Pterosaurs emerged in the Late Triassic, becoming the dominant flying creatures of the Era.  The birds are first seen in the Middle Jurassic, and start off as localised communities, as did the pterosaurs many millions of years earlier.  As bird species increase throughout the Cretaceous, the pterosaur species are seen to peak in numbers and then fall into decline.  By the end of the Cretaceous, pterosaurs were specialised as very large and wide ranging flying animals - most of the smaller pterosaur species having disappeared towards the end of the Cretaceous.
Birds clearly had an ecological advantage in most niche environments, eventually forcing pterosaurs into decline.  By the time of the Mass Extinction Event at the end of the the Mesozoic, There were only a handful of pterosaur species left, and these were too highly specialised to survive as an order of animals. The changes in ambient temperature and atmospheric oxygen content that resulted from the meteor impact and ensuing lava flows would have been biologically catastrophic, making life impossible for the large pterosaurs.