Jump to content

Western PA Specimen Collection - Fossils of Parks Township

Recommended Posts

Hopefully I'm not breaking any rules here posting a link. I spent my weekend finally putting my catalog into a proper database, and creating a user interface for it. I used to use Google Sheets, which is pretty great. If I wanted to, I could use them as the source of data, but I decided to create a proper MYSQL database so I can keep relationships across tables, such as the stratigraphy of particular find locations. I have many more improvements coming for it, but it is at least functional right now.


Everything from CG-0001 to CG-0161 is from the Glenshaw Formation, Conemaugh Group.




I also maintain a thread with individual photos here, just not everything:



  • Enjoyed 1
Link to post
Share on other sites

This looks great.  What software or program did you use to build the database?  

Link to post
Share on other sites
Just now, jpc said:

What software or program

I use SQLYOG to manage it visually. I've been writing SQL queries as part of my career for the past 20 years, so writing the structure is 2nd nature at this point. It's still evolving, as I originally placed geologic formation/group in the same rows as the specimens, until I changed mid-stream and made locations their own table.


I'm still filling in the gaps, for example I need to hunt down the Class, Order and Family of the genus Antiquatonia. That's a pain for plants I'm finding, where sources want to omit Phylum for Clade, etc.



Link to post
Share on other sites
  • 1 year later...

As an update, I continue to populate specimens here. I am approaching 400 unique cataloged specimens.

  • I found this Informative 1
Link to post
Share on other sites

Took the time to scroll through your specimens. Great collection!! Makes my collection from that formation look pretty small.



Edited by minnbuckeye
  • Thank You 1
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...