|
|||||||||
|
How do we do that? We have carefully correlated data obtained from the sources below and many others over several years. To amass that much data in an orderly way is no small task. Beginning with large databases from: Then merging in even more data from: Then merging in even more data from our own research via multi-media research and "boots on the ground" waterfall hunting. We import the data into Microsoft Excel for some basic data massaging and checking. Once the data is organized into Excel 97 files a series of custom developed scripts import this data into an offline database named MonsterDB. We developed MonsterDB in-house using Filemaker Pro Advanced 9, though this project started while Filemaker was still selling version 6. MonsterDB then process each imported data record, extracting fields from the raw incoming data. MonsterDB then loops through each record seeking records with matching names and very close GPS co-ordinates. These records are marked then compared BY HAND. We use all information we have available to determine if these 2 records are indeed the same waterfall (or location). A primary record is selected that shows the most complete, current information. Once both automated and manual data processing is completed, MonsterDB outputs a simple Tab-Delimited text file. This file is uploaded in the wee hours Pacific Standard Time, then integrated into our MonsterDB online MySQL database. This is the live data 's permanent home that serves the data to the web pages that you see. All stages of this process including downloaded text files and the stages our data goes through are archived and backed up to increase data integrity including Excel files , MonsterDB/Filemaker files, and export to Tab-Delimited text file. We constantly compare data with incoming data as we find it both on the net and offline, in addition to visiting as many waterfalls as we possibly can to confirm data, photograph and oh yeah, ENJOY WATERFALLS!
|
|||||||||
|
|||||||||
