Survey_Geometry_3D

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