The International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences. Vol. XXXVII. Part B4. Beijing 2008
347
interpolation of the component’s attributes (such as grade, etc.);
4) Property description mainly include: volume, proportion,
weight, grade of ore-bearing element, the mechanical
parameters of rock strength, porosity, permeability, etc.
name
type
description
SFID
Int
Surface object’s ID(PK)
SF Name
Varchar
Surface object’s name
SF_Type
Varchar
Surface object’s type
RIDSequence
Varchar
The IDs’ sequence of regions
Attr
Varchar
Attribute description
Table 8 Surface object data structure
Note:
1) Surface object can be the real surface (such as fault plane,
unconformity surface, strata surface, the top/bottom deposit
surface), may be the user-defined geological surface in order to
* facilitate the understanding of the geological model (such as
exploitation level of coal mining);
2) The field domain can be defined as follow:
FS - Fault Surface; AUS - Angular unconformity surface;
PUS - Parallel unconformity Surface; CS - Conformity Surface;
TS - Top Surface; BS - Bottom Surface; OS - Other Surface;
name
tyP e
description
CF ID
Int
CF’s ID(PK)
CFType
char
CF’s type(side-face, up-face,
down-face)
RIDSequence
Varchar
The IDs’ sequence of
regions(FK)
ArcIDSequence
varchar
The degradation line, the default
is Null
N ID
Int
The degradation point, the
default is Null
Table 9 Component face data structure
Note:
1) CF: Component Face
2) Component face’s type including:
CSF: Component Side-Face; CUF - Component-Up-Face;
CDF: Component-Down-Face; FCP
F ore-Component-Polygon;
MCP:
Mid-Component-Polygon; PCP:
Post-Component-Polygon
3) Component face
can be depredated as line or point.
name
type
description
RID
Int
Region ID(PK)
Attrs
varchar
Attribute description
FatherPoly
Int
Outer polygon’s ID, the default
is Null(FK)
SonPoly
Int
Inner polygons’ ID, the default is
Null(FK)
N_IDSequence
varchar
The sequence of isolated-nodes
Front CO ID
Int
The positive component’s
ID(FK,1:1)
NegativeCOID
Int
The negative component’s
ID(FK,1:1)
Table 10 Region data structure
Note: Positive and negative decision by the Polygon, to meet
the right rules for the positive and negative to the contrary.
name
type
description
P_ID
Int
Polygon’s ID(PK)
Attr
varchar
Attribute description
The arcs’ ID sequence of outer
Arc_IDSequence
varchar
polygon, positive arc is
negative arc is “-“(FK,l:n)
type description
InnerRegionID;
OuterRegionID
Int
Int
The inner regions’ IDs , the
default is 0(FK,l:n)
The outer region’s ID, the default
is 0(FK,1:1)
ClosedBox
Varchar
The Min box(defindedby (xMin,
yMin, xMax, yMax)
Table 11 Polygon data structure
name
type
description
Ln_ID
Int
Line object’s ID(PK)
Ln Name
Varchar
Line object’s name
LnType
Varchar
Line object’s type
ArcIDSequence Varchar
The IDs’ sequence of
arcs(FK,l:n)
Ln Attr
Varchar
Attribute description
Table 12 Line Object data structure
name
type
description
FLID
Int
FL’s ID(PK)
LnType
Varchar
FL’s type
PntIDSequence Varchar
The IDs’ sequence of
feature-node(FK, 1 :n)
Arc ID
Int
The arc’s ID(FK,1:1)
Ln Attr
Varchar
Attribute description
Table 13 Feature line data structure
Note:
1) Feature line(FL) can be automatically connected or user
interactively connected the feature-nodes of the arc.
2) The type of feature line is as follow:
DL: Divided Line for side-face and up/down-face
CL: Constrained Line; OL: Other Line
name
type
description
ArcID
Int
Arc’s ID(PK)
LeftCode
Short
int
Left region’s ID,the default is -1
Right_Code
Short
int
Right region’s ID
FromNode
Int
Started cru-node’s ID(FK, 1:1)
ToNode
Int
Ended cru-node’s ID(FK, 1:1)
nPoints
Short
int
Numbers of nodes contained in
the arc
PointsSequence Varchar
The IDs’ sequence of nodes
contained in the arc
LeftPoly
RightPoly
Attr
Int
Int
varchar
Left polygon’s ID(FK, 1:1 )
Right polygon’s ID(FK,1:1)
Attributes(format as up|mid|down
or left|mid|right
nStyle
Short
int
The fault’s type
FaultID
Short
int
The ID of fault
Table 14 Arc data structure
name
№
Description
NJD
Int
Node’s ID(PK)
N_type
Int
The node’s type
X
Long
X
y
Long
y
z
Long
z
N Attr
Varchar
Attribute description
Table 15 Node data structure
Node:
1) The value of node’s type is as follow: