System Table TB_INTERSECTION

The following table stores intersection definitions.

Note: The properties are set with the data model administrator.

Attributes of TB_INTERSECTION	Description
ID	Stores the unique key, which is system-generated.
NAME	Specifies the name of the intersection.
TYPE	OO = Polygon/Polygon => Polygon OL = Polygon/Line => Line OP = Polygon/Point => Point LL = Line/Line => Point LP = Line/Point => Point
ADJUST_SECOND	True/false: Adjusts the area of the second feature class to the area of the first feature class. Only useful for polygon/polygon intersections.
ADJUST_EXCLUDE	Specifies the condition that excludes features from an adjustment. Example: s.area <100.
BUFFER_PRIM_FC	Defines a perimeter for a buffer. All features inside the perimeter are returned.
F_CF_CLASS_NAME_PRIM	Primary feature class.
F_CLASS_NAME_SEC	Secondary feature class.
F_CLASS_NAME_INTER	Specifies the name for intersection feature class. If the table does not exist, it is created automatically. The name must not contain blanks.
PRIM_JOBID SEC_JOBID	Specifies the job used to get data from DB. If “JOBID= 0”, the currently selected job is used.
PRIM_UPDATE_STATEMENT SEC_UPDATE_STATEMENT	Selects values from other tables to store in the intersection feature class. These values can be used for reports. This method is faster than creating a view that joins information from other tables and from the intersection results.
STORE_GEOMETRY	Stores “AREA” and “AREA_NOMINAL” on OO intersections (polygon/polygon). Set to true or false.
TOL_AREA_NOMINAL	Stores the maximum value of the difference between the area of the primary and summary of the secondary feature class where no adjustment is started.
TOLERANCE	Sets the spatial tolerance for the intersection. This tolerance is equal to the smallest tolerance of primary and secondary feature class.
WHERE_CLAUSE_SEC WHERE_CLAUSE_PRIM	Restricts features participating in the intersection. The restriction can be defined as a WHERE Clause.

TB_STATE_INTERSECTION defines the state in which the intersection applies. If an intersection is called with the same primary and secondary feature classes, it must be executed before the merge job. All other intersections can be called after the merge.