Survey_Geometry_3D


[Columns] [Composed Of] [Referenced By] [Refers To]

General Information

[Next]
Name Survey_Geometry_3D
Entity Type ObjectView
Description PSS 2013.1 Survey_Geometry_3D DOV
Submodel Data_Object
Entity Scope Project
Primary Key Id
Natural Key
Generalizations
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
APPLICATION_PROJECT_ID NUMBER2 NA
_ No
NUMBER(2)
BIN_NODE_INC_ON_I_AXIS NUMBER2 NA
_ No
NUMBER(2)
BIN_NODE_INC_ON_J_AXIS NUMBER2 NA
_ No
NUMBER(2)
BIN_WIDTH_ON_I_AXIS NUMBER2 NA
_ No
NUMBER(2)
BIN_WIDTH_ON_J_AXIS NUMBER2 NA
_ No
NUMBER(2)
CALCULATED_AREA NUMBER Area
m2
_ No
NUMBER
COUNTRY_NAME STRING64 NA
_ No
VARCHAR2(64)
FIRST_CORNER_POINT_X NUMBER2 NA
_ No
NUMBER(2)
FIRST_CORNER_POINT_Y NUMBER2 NA
_ No
NUMBER(2)
FIRST_I_COORDINATE_LINE NUMBER2 NA
_ No
NUMBER(2)
FIRST_J_COORDINATE_LINE NUMBER2 NA
_ No
NUMBER(2)
FOREIGN_REPOSITORY_SYSTEM STRING64 NA
_ No
VARCHAR2(64)
FOREIGN_REP_OBJECT_ID STRING255 NA
_ No
VARCHAR2(255)
GUID STRING128 NA
_ No
VARCHAR2(128)
ID NUMBER2 NA
_ Yes
NUMBER(2)
INSERT_DATE DATE NA
_ No
DATE
INSERT_USER STRING64 NA
_ No
VARCHAR2(64)
I_COORDINATE_LINE_COUNT NUMBER2 NA
_ No
NUMBER(2)
J_COORDINATE_LINE_COUNT NUMBER2 NA
_ No
NUMBER(2)
LAST_I_COORDINATE_LINE NUMBER2 NA
_ No
NUMBER(2)
LAST_J_COORDINATE_LINE NUMBER2 NA
_ No
NUMBER(2)
LICENSE_HOLDER_ID NUMBER2 NA
_ No
NUMBER(2)
NAME STRING255 NA
_ No
VARCHAR2(255)
NOMINAL_AREA NUMBER Area
m2
_ No
NUMBER
ORIGINAL_SOURCE STRING64 NA
_ No
VARCHAR2(64)
PARENT_3D_SURVEY_ID NUMBER2 NA
_ No
NUMBER(2)
PRODUCED_BY STRING64 NA
_ No
VARCHAR2(64)
REMARKS STRING2000 NA
_ No
VARCHAR2(2000)
SECOND_CORNER_POINT_X NUMBER2 NA
_ No
NUMBER(2)
SECOND_CORNER_POINT_Y NUMBER2 NA
_ No
NUMBER(2)
SOURCE STRING64 NA
_ No
VARCHAR2(64)
SURVEY_3D_ID NUMBER2 NA
_ No
NUMBER(2)
SURVEY_AREA_NAME STRING255 NA
_ No
VARCHAR2(255)
SURVEY_CRS_ID NUMBER2 NA
_ No
NUMBER(2)
SURVEY_PROJECT_NAME STRING255 NA
_ No
VARCHAR2(255)
SURVEY_PROSPECT_NAME STRING255 NA
_ No
VARCHAR2(255)
SURVEY_UNIQUE_LOCATOR STRING2000 NA
_ No
VARCHAR2(2000)
THIRD_CORNER_POINT_X NUMBER2 NA
_ No
NUMBER(2)
THIRD_CORNER_POINT_Y NUMBER2 NA
_ No
NUMBER(2)
UPDATE_DATE DATE NA
_ No
DATE
UPDATE_USER STRING64 NA
_ No
VARCHAR2(64)


View Definition

[Previous] [Top]

CREATE OR REPLACE FORCE VIEW Survey_Geometry_3D(ID, SURVEY_3D_ID, INSERT_DATE, INSERT_USER, UPDATE_DATE, UPDATE_USER, GUID, NAME, ORIGINAL_SOURCE, PRODUCED_BY, REMARKS, SOURCE, APPLICATION_PROJECT_ID, LICENSE_HOLDER_ID, SURVEY_AREA_NAME, COUNTRY_NAME, SURVEY_CRS_ID, SURVEY_PROJECT_NAME, SURVEY_PROSPECT_NAME, SURVEY_UNIQUE_LOCATOR, FOREIGN_REP_OBJECT_ID, FOREIGN_REPOSITORY_SYSTEM, PARENT_3D_SURVEY_ID, NOMINAL_AREA, CALCULATED_AREA, FIRST_I_COORDINATE_LINE, FIRST_J_COORDINATE_LINE, LAST_I_COORDINATE_LINE, LAST_J_COORDINATE_LINE, BIN_NODE_INC_ON_I_AXIS, BIN_NODE_INC_ON_J_AXIS, I_COORDINATE_LINE_COUNT, J_COORDINATE_LINE_COUNT, FIRST_CORNER_POINT_X, FIRST_CORNER_POINT_Y, SECOND_CORNER_POINT_X, SECOND_CORNER_POINT_Y, THIRD_CORNER_POINT_X, THIRD_CORNER_POINT_Y, BIN_WIDTH_ON_I_AXIS, BIN_WIDTH_ON_J_AXIS) AS SELECT
   CUBE_LATTICE.ID,
   CUBE_LATTICE.SURVEY_3D_ID,
   CUBE_LATTICE.INSERT_DATE,
   CUBE_LATTICE.INSERT_USER,
   CUBE_LATTICE.UPDATE_DATE,
   CUBE_LATTICE.UPDATE_USER,
   
CUBE_LATTICE.GUID,
   CUBE_LATTICE.NAME,
   CUBE_LATTICE.ORIGINAL_SOURCE,
   CUBE_LATTICE.PRODUCED_BY,
   CUBE_LATTICE.REMARKS,
   CUBE_LATTICE.SOURCE,
   SURVEY_3D.APPLICATION_PROJECT_ID,
   SURVEY_3D.LICENSE_HOLDER_ID,
   SURVEY_3D.SURVEY_AREA_NAME,
   SURVEY_3D.COUNTRY_NAME,
   SURVEY_3D.SURVEY_CRS_ID,
   SURVEY_3D.SURVEY_PROJECT_NAME,
   SURVEY_3D.SURVEY_PROSPECT_NAME,
   SURVEY_3D.SURVEY_UNIQUE_LOCATOR,
   SURVEY_3D.FOREIGN_REP_OBJECT_ID,
   SURVEY_3D.FOREIGN_REPOSITORY_SYSTEM,
   SURVEY_3D.PARENT_3D_SURVEY_ID,
   SURVEY_3D.NOMINAL_AREA,
   SURVEY_3D.CALCULATED_AREA,
   CUBE_LATTICE.I_ANNOTATION_AT_0_0,
   CUBE_LATTICE.J_ANNOTATION_AT_0_0,
   CUBE_LATTICE.I_ANNOTATION_AT_0_0+(CUBE_LATTICE.I_COUNT-1)*CUBE_LATTICE.I_ANNOTATION_INCREMENT,
   CUBE_LATTICE.J_ANNOTATION_AT_0_0+(CUBE_LATTICE.J_COUNT-1)*CUBE_LATTICE.J_ANNOTATION_INCREMENT,
   CUBE_LATTICE.I_ANNOTATION_INCREMENT,
   CUBE_LATTICE.J_ANNOTATION_INCREMENT,
   CUBE_LATTICE.I_COUNT,
   CUBE_LATTICE.J_COUNT,
   
POINT_0_0.ORIGINAL_X_LONGITUDE,
   POINT_0_0.ORIGINAL_Y_LATITUDE,
   POINT_0_J.ORIGINAL_X_LONGITUDE,
   POINT_0_J.ORIGINAL_Y_LATITUDE,
   POINT_I_0.ORIGINAL_X_LONGITUDE,
   POINT_I_0.ORIGINAL_Y_LATITUDE,
   SQRT(POWER(POINT_I_0.ORIGINAL_X_LONGITUDE-POINT_0_0.ORIGINAL_X_LONGITUDE,2)+
        POWER(POINT_I_0.ORIGINAL_Y_LATITUDE-POINT_0_0.ORIGINAL_Y_LATITUDE,2))/(I_COUNT-1),
   SQRT(POWER(POINT_0_J.ORIGINAL_X_LONGITUDE-POINT_0_0.ORIGINAL_X_LONGITUDE,2)+
        POWER(POINT_0_J.ORIGINAL_Y_LATITUDE-POINT_0_0.ORIGINAL_Y_LATITUDE,2))/(J_COUNT-1)
FROM
   CUBE_LATTICE,
   SURVEY_3D,
   POSITION POINT_0_0,
   POSITION POINT_0_J,
   POSITION POINT_I_0
WHERE
   POINT_0_0.ID (+) = CUBE_LATTICE.POINT_0_0_POSITION_ID AND
   POINT_0_J.ID (+) = CUBE_LATTICE.POINT_0_J_POSITION_ID AND
   POINT_I_0.ID (+) = CUBE_LATTICE.POINT_I_0_POSITION_ID AND
   SURVEY_3D.ID = CUBE_LATTICE.SURVEY_3D_ID
   


[Seabed Objects] [Entities in Schema Seabed] [Index]

Copyright © 2018 Schlumberger. All rights reserved.