X hits on this document

Powerpoint document

Database Management: Tables - page 30 / 35

75 views

0 shares

0 downloads

0 comments

30 / 35

1/23/2015  UT Dallas

POEC 6382 Applied GIS Software

30

Merging Tables with JOINITEM

JOINITEM  permanently merges two INFO data files based on a shared item

JOINITEM <in_info_file> <join_info_file> <out_info_file> <relate_item> {start_item} {LINEAR | ORDERED | LINK}

- The <relate_item> must exist for both files.

- The <relate_item> must have the same definitions (i.e. name, type, width, output) in both files.

-{LINEAR | ORDERED | LINK} specifies how <join_info_file> records are matched to <in_info_file> records.

LINEAR - both files can be sorted in any order.  This is the default option.

ORDERED - the <join_info_file> must be sorted on <relate_item>.  

LINK - The <relate_item> value in each record of <in_info_file> indicates the internal record number in <join_info_file> which is to be merged.

- The speed of execution will depend on the organization of the files being joined.  In general, LINK is the fastest matching operation, then LINEAR with an indexed <relate_item>, and then ORDERED. The fastest option, LINK cannot be applied to most cases.

Hints:  --use the LINEAR (default) option-- slower but safer      --when adding attribute data to a coverage, the coverage must be the in_file

     --use same name for in_file and out_file--otherwise all the associated spatial files are not available.

Note: altho. we talk of joining tables, the command is JOINITEM.  Do not use JOIN, which is a very specialized ArcEdit command used for joining lines on a map.

Document info
Document views75
Page views75
Page last viewedMon Dec 05 06:53:42 UTC 2016
Pages35
Paragraphs787
Words4938

Comments