Accessing Data from the Design or Catalogue Databases
- Last UpdatedDec 09, 2025
- 2 minute read
All Design and Catalogue database attributes are accessible. For example, attribute ABCD would be accessed by code #ABCD (or #abcd). In addition, any Design element can be accessed. For example:
|
#SITE |
Name of site owning the referenced element |
|
#BRAN |
Name of Branch owning the referenced element |
Marine pseudo-attributes may be accessed in the same manner.
The codewords for the more commonly used position attributes can be modified so as to provide only one of the coordinates. For example:
|
#POS |
full 3D position, for example, W12250 N7890 U3120 |
|
#POSE |
Easting coordinate only, for example, E12250, W9675 |
|
#POSN |
Northing coordinate only, for example, N7890, S22150 |
|
#POSU |
Upping coordinate only, for example, U3120, D250 |
For users that work in XYZ format the alternative codewords: #POSX, #POSY, #POSZ are provided.
The position attributes that can be modified in this way are: POS, HPOS, TPOS, APOS, TPOS, NPOS, POSS, POSE, DRPS and DELP. Note that the codeword #POSE can have two meanings depending on the context: for SCTNs it means the POSE attribute (Section End Position), in other cases it means the Easting of the POS attribute.
For other position attributes single coordinates can be obtained by using a single index qualifier. For example:
#GCOFG[2] would provide the Northing (or Y coord) of the Gross Centre of Gravity position.
Only single index qualifiers are allowed, thus: #GCOFG[2,3] will generate an error.
The position codewords generate values in World coordinates. It is possible to generate values in the coordinate systems of other elements by the use of transform keywords - see Transforming Position/Direction Data.
Note: As an alternative to the standard ENU or XYZ formats, positions can be output in '+/-' format by appending '+' to the codeword. For example:
|
#POS |
full 3D position, for example, W12250 N7890 U3120 |
|
#POS+ |
would give -12250 +7890 +3120 |
|
#POSE+ |
would give -12250 |
|
#POS+[3] |
would give +3120 |