CANADA-US MERGING PROCESS:
1) The Canadian and US coverage files in NAD83 Geographic Decimal Degrees format were appended using the "joincover" script taken from the ERSI website and developped by Sam Henderson . More information on script can be obtained from the following website <http://www.surv.ufl.edu/~sam/joincovers/index.htm> . This application prepares coverages with different attiributes for the APPEND command, it finds all possible items in the feature attribute tables and make them similar by adding and pulling. It does not drop any items and creates a file containing a "superset" of all attributes of the original files. Topology of vectors is updated using a dangle=0 and fuzzy tolerence=0.00001 (degrees) before appending.
2) Merged Canada-US watercourse was exported to Shapefile geographic decimal degrees for final distributes purposes.
3) Attributes correspondance was evaluated but is was decided not to crosswalk attributes. The full set of Canadian an US watercourse attributes were retained for the exeception of Canadian watercourse attributes relating to feature geometry and some internal GIS attributes (see list below).
ORIGINAL NTDB ATTRIBUTES:
NAME, width, output, type, n. dec
WAT_BODY_A 4,10,B,0
WAT_BODY_1 4,10,B,0
ENTITYNAME 40,40,C,0
NTS 6,6,C,0E
DITION 4,10,B,0
VERSION 4,10,B,0
THEME 2,2,C,0
ID 4,10,B,0
CODE_GENER 4,10,B,0
ATC 4,10,B,0
ATG 4,10,B,0
ATZ 4,10,B,0
ATE 4,10,B,0
ACCURACY 4,10,B,0
TYPE_ 4,10,B,0
ELEVATION 8,19,F,3
CENTROID_X 8,19,F,3
CENTROID_Y 8,19,F,3
ORIGINAL RAD ATTRIBUTES:
NAME, width, output, type, n. dec
OBJECTID_1 4,10,B,0
DEFAULTNAM 4,10,B,0
DEFAULTN_1 4,10,B,0
DRAIN_ 8,19,F,3
DRAIN_ID 8,19,F,3
COM_ID 8,19,F,3
RCH_COM_ID 8,19,F,3
WB_COM_ID 8,19,F,3
FTYPE 24,24,C,0
FCODE 4,10,B,0
METERS 8,19,F,3
OBJECTID 4,10,B,0
FID_LEN 8,19,F,3
SHAPE_LEN 8,19,F,3
ATTRIBUTES SUPERSET (NTDB + RAD):
FNODE_
TNODE_
LPOLY_
RPOLY_
WA_C_L_
WA_C_L_ID
ENTITYNAME
NTS
EDITION
VERSION
THEME
ID
CODE_GENER
ATC
ATG
ATZ
ATE
ACCURACY
TYPE
ELEVATION
OBJECTID_1
DEFAULTNAM
DEFAULTN_1
DRAIN_
DRAIN_ID
COM_ID
RCH_COM_ID
WB_COM_ID
FTYPE
FCODE
METERS
OBJECTID
FID_LEN
SHAPE_LEN
RETAINED ATTRIBUTES:
GIS Software required -> FID, Shape
Canadian Watercourse Attributes -> NTS, ID, ELEVATION
US Drainage Attributes -> COM_ID, RCH_COM_ID, WB_COM_ID, FTYPE, FCODE, METERS, OBJECTID, FID_LEN, SHAPE_LEN