Water samples are gathered by DoH County Public
Health Unit samplers. Locational data is provided by these samplers,
historically from quad maps, currently with GPS (post 1996). The field data
is provided to the DOH lab in Jacksonville where the water is analysed and
the analytic data associated with the field information. This data is then
transferred electronically to DEP/WSRP. 2 text files from the WSRP
database are dumped for generation of a coverage. One file is a list of
coordinates, while the other is an associate ID file containing well records.
The aml 'wsrp.aml' generates a point coverage from WSRP database
dumps, saved as (1) a coordinate table and (2) ID table
containing records. Original data is in NAD27 and WGS84 datums.
The aml projects all points to ALBERS-HPGN.
A coordinate table (wsrp.gen) is used as input text file to generate
a point coverage. Records are added from the ID table (wsrp.id)
into a previously defined INFO table. Records not accepted are written
to a wsrp.reject file.
The point coverage .PAT file is then joined with the INFO table to
create a composite feature attribute table containing all the fields.
WELL_ID is used as the joinitem. The coverage is brought in to ARCEDIT and
broken up into separate coverages based on datum, using PUT command. Item
LOC_METH is used as proxy for datum. Coverages are projected to ALBERS-HPGN
and combined using GET command. Point topology is rebuilt.
It then reselects points which fall outside the clip coverage for its destined
library and creates a report (wsrp.libclip). New coverage then replaces the
library layer.
Files and programs used:
well.dbf -- wsrp database
wsrp.id -- ID file containing well records
wsrp.gen -- coordinate file
wsrp.dat -- INFO table populated by records from ID file
wsrp.aml -- aml creating ARC/INFO coverage
wsrp.reject -- list of points rejected by INFO
wsrp.libclip -- list of points outside clip coverage