«
»

Historic records uploaded

November 9th, 2007 by Richard G

I’ve just finished uploading the historic records that Mike had sent me in an Excel spreadsheet. It’s taken me a lot longer to do this than I thought due to a memory leak within one of the technologies I was using – Propel! After wasting some time, first tracking down the problem, then attempting to fix it, I ended up having to rewrite the code to directly modify the MYSQL database.

I’ve amalgamated any records that had the same date and coordinates, this has given 5,111 different events, which are linked to 4,790 locations and a total of 315,200 spots for these events.

The next stage is to extract the relevant figures from this data to give the evolution details to users about their current spots.

This entry was posted on Friday, November 9th, 2007 at 12:20 pm and is filed under MegaLab, Progress. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Responses to “Historic records uploaded”

  1. Jonathan Says:
    November 9th, 2007 at 12:52 pm

    Sounds good. How is a ‘spot’ defined?

  2. r.m.greenwood Says:
    November 9th, 2007 at 12:55 pm

    a spot is 1 snail, so 315,200 snails.

  3. The Biodiversity Observatory & Evolution MegaLab » Blog Archive » MegaLab update Says:
    May 1st, 2009 at 11:01 am

    [...] found this problem when uploading large amounts of data to the historic part of the site (see Historic records uploaded), this meant I knew what I had to do to fix it, although it still took some time to track down the [...]

Leave a Reply