The feature class TB_PROFILE_DETAIL stores the definition details of profile lines, profile points, or frame lines.
Each record in TB_PROFILE_DETAIL that corresponds to a feature class will create one profile feature per feature.
Each record in TB_PROFILE_DETAIL that does not correspond to a feature class will create one profile feature only.
For example, the profile detail containing the profile WW_MANHOLE_PRO corresponds to the WW_MANHOLE feature class. For each manhole, one profile feature will be stored. The detail WW_VERTICALLINE_PRO has no relation to the manhole feature class, so this profile detail defines only the one line.
A LOCAL* value replaces the information of the feature and is considered an absolute value in the profile coordinate system.
If F_CLASS_NAME_MAIN is null and F_CLASS_NAME_PROFILE is a point feature class, then LOCAL_EASTING_1 and LOCAL_NORTHING_1 must be not null and are used as absolute values.
If F_CLASS_NAME_MAIN is null and F_CLASS_NAME_PROFILE is a line feature class, then LOCAL_EASTING_1, LOCAL_NORTHING_1, LOCAL_EASTING_2 and LOCAL_NORTHING_2 must be not null and are used as absolute values.
For a line feature class, if a point is not exactly on the line, it is projected to the nearest position of the line.
The relation between the feature of F_CLASS_NAME_PROFILE and FEAT_CONN_LINE_F_CLASS_NAME must be stored in TB_RELATIONS. This relation is automatically filled during the profile generation process.
The relation between the features of F_CLASS_NAME_PROFILE and VERT_CONN_LINE_F_CLASS_NAME must be stored in TB_RELATIONS. This relation is automatically filled during the profile generation process.
The relation between the features of F_CLASS_NAME_PROFILE and POLYGON_NEXT_PT_F_CLASS_NAME must be stored in TB_RELATIONS. This relation is automatically filled during the profile generation process.
|
TB_PROFILE_DETAIL attribute |
Description |
|
ID |
Primary key. |
|
USER_ID |
User who creates the profile definition. This corresponds to MAPSYS.TB_USER.ID. |
|
DETAIL_TITLE |
Title of the profile detail. |
|
PROFILE_DEFINITION_ID |
Profile definition related to this detail, related with TB_PROFILE_DEFINITION.ID |
|
F_CLASS_NAME_PROFILE |
Name of the feature class containing the features shown in the profile. |
|
F_CLASS_NAME_MAIN |
Name of the feature class corresponding to the profile feature class: If F_CLASS_NAME_MAIN is null, only one feature is created as detail. If F_CLASS_NAME_MAIN is not null, one feature per main feature is created as detail. |
|
WHERE_CLAUSE_MAIN |
WHERE clause assigned to F_CLASS_NAME_MAIN in order to make a sub-selection of the features. select * from F_CLASS_NAME_MAIN f where WHERE_CLAUSE_MAINThe alias f can be used in the WHERE clause. |
|
SELECT_STATEMENT_GEOM_MAIN |
Selection of the geometry of the main feature. The query must use the column alias FID, EASTING, NORTHING, HEIGHT. For point feature classes, 0 or 1 row can be returned by this statement. For line feature classes, 0, 1 or more rows can be returned. |
|
FEAT_CONN_LINE_F_CLASS_NAME |
Name of the line feature class containing the features used to connect the point features in the profile. |
|
FEAT_CONN_LINE_ATTR1 |
Attribute name of the line connection feature class |
|
FEAT_CONN_LINE_VALUE_1 |
Value set for the attribute FEAT_CONN_LINE_ATTR1 |
|
VERT_CONN_LINE_F_CLASS_NAME |
Name of the line feature class containing the features used to make a vertical line from the feature to the reference height. If F_CLASS_NAME_PROFILE is a point feature class, one vertical line is created. If F_CLASS_NAME_PROFILE is a line feature class, one line is created at the start and one at the end. If two lines are geometrically connected, only one vertical line is created at the connection point. |
|
VERT_CONN_LINE_ATTR1 |
Attribute name of the line connection feature class. |
|
VERT_CONN_LINE_VALUE_1 |
Value set for the attribute VERT_CONN_LINE_ATTR1. |
|
VERT_CONN_LINE_ORIGIN_OFFSET |
Offset between the reference height and the vertical line. Has the global coordinate system unit. |
|
POLYGON_NEXT_PT_F_CLASS_NAME |
Name of the polygon feature class that can only be used for F_CLASS_NAME_PROFILE point feature classes. A polygon is created from the current point feature to the next point feature. |
|
POLYGON_NEXT_PT_HEIGHT |
Height of the polygon. |
|
POLYGON_NEXT_PT_WHERE_CLAUSE |
WHERE clause used to make a sub selection of the point features. Creates a polygon only if the following statement gives a row back: select 1 from F_CLASS_NAME f where POLYGON_NEXT_PT_WHERE_CLAUSE, the alias f can be used in the where clause. |
|
DISTANCE_ATTRIBUTE |
Attribute name of F_CLASS_NAME_PROFILE in which the distance along the axis is stored. Only if F_CLASS_NAME_PROFILE is a point feature class. |
|
LOCAL_EASTING_1 |
First easting coordinate in the local coordinate system. |
|
LOCAL_NORTHING_1 |
First northing coordinate in the local coordinate system. |
|
LOCAL_EASTING_2 |
Second easting coordinate in the local coordinate system. |
|
LOCAL_NORTHING_2 |
Second northing coordinate in the local coordinate system. |
|
LOCAL_EASTING_1_ADD_WIDTH |
Flag that defines whether the profile width has to be added to LOCAL_EASTING_1. |
|
LOCAL_NORTHING_1_ADD_HEIGHT |
Flag that defines whether the profile height has to be added to LOCAL_NORTHING_1. |
|
LOCAL_EASTING_2_ADD_WIDTH |
Flag that defines whether the profile width has to be added to LOCAL_EASTING_2. |
|
LOCAL_NORTHING_2_ADD_HEIGHT |
Flag that defines whether the profile height has to be added to LOCAL_NORTHING_2. |
|
REPEATED_DISTANCE |
Object is placed every REPEATED_DISTANCE distance; only for point feature class and if F_CLASS_NAME_MAIN is null. |
|
SET_ATTRIBUTE_1 - 5 |
Attribute name of the table F_CLASS_NAME_PROFILE |
|
SET_VALUE_1 - 5 |
Value set to the corresponding feature attribute |