Vibe System Support
Formats supported - GPSQL can import Pelton, Sercel and Tigenav vibe data, either in batch or a file at a time. The resulting field structure of the table of the imported data is the same as
the Postplot table for the first dozen fields.
Computing the COG - GPSQL creates and/or appends a table with records consisting of the position average of all records for each station in the vibe data table. The table contains the
averaged coordinates and values which indicate how many points went into deriving the average and the RMS of the individual distances from each point to the resulting COG. If desired,
averaging can be accomplished by first averaging the individual coordinates of each vibe and then averaging those to finally compute the COG.
GPSQL/QuikMap connection - With the parent and averaged table discussed above, you are in a good position to look at the vibe data visually. You do this by writing queries that represent the
imported vibe data and the averaged data Select the imported vibe data query as the first layer and the averaged data query as the second layer and send this to QuikMap using the two layer
utility. Once the data is displayed, go to the File menu and select 'Compare/Offsets'. Zoom in and prepare to be enlightened.
When you compare points as above, if there are multiple matches, QuikMap can construct a special DXF layer which is comprised of pointers to duplicate groups that fail to meet some user
criteria. Click the pointer and a text box shows what the problem is.
GPSQL Duplicate Manager - There is a utility in GPSQL for managing duplicates. This utility can be used to isolate duplicates in a query and see just the points that make up each duplicate
group along with a computed center of gravity (COG). It is also possible to see a point with the same station name from another query as well as a template of intended relative vibe
locations. It is possible to delete, modify or add points.
Summary Of Vibe Data Processing Tools
1) import utilities for Pelton, Sercel and TigerNav in GPSQL 2) ability to create table of averaged data in GPSQL
3) ability of QuikMap to add template overlays
4) ability of QuikMap to add diagnostic DXF layer for multiple comparisons
5) duplicate managing utility in GPSQL