X hits on this document

Powerpoint document

Database Management: Tables - page 32 / 35

79 views

0 shares

0 downloads

0 comments

32 / 35

1/23/2015  UT Dallas

POEC 6382 Applied GIS Software

32

Creating a Relate Environment

RELATE ADD requires the following elements to be specified:

Relation name:  Name to reference the relate

Table identifier:  The name of the data file (in INFO or other RDBMS) to which you want to relate

Database name:  Where the related files is stored (e.g. INFO)

INFO item:  The item name in the feature attribute table that will be matched to the relate column.  These names do not have to be the same

Related column: The item in the related data file to match the INFO item

Relate type:  Specify the search method: Linear, Ordered, Link

Relate access:  Sets the access rights to the related data file.  Can be Read/Write (RW), Read-Only (RO), or the same as the current file (Auto)

Arc:  relate add

Relation Name: sorel

Table Identifier: soil  (may need to specify full path name if other than current directory)

Database Name: INFO

INFO item:  soil_type

Relate column: soil_type

Relate type:  ordered

Relate access:  RW

Relation Name: (starts over -- hit return to end addition of relates)

Document info
Document views79
Page views79
Page last viewedMon Dec 05 14:51:02 UTC 2016
Pages35
Paragraphs787
Words4938

Comments