SURVEY_2D

The Survey_2D entity must exist in order for the navigation data to be loaded. In this example, the name is derived from the Line Prefix in header record H0203 and the first two characters found in each of the lines. The table created should look like the one the below. Id is a unique surrogate key automatically generated and assigned to the Survey_2D when the instance is created and Name contains the name of the 2D survey. Survey_CRS contains the surrogate key to the existing instance in Coordinate_System that corresponds to the coordinate system in which data is plotted as described in the UKOOA P1/90 header records. In this example, the coordinate system referenced is UTM Zone 31 North projection using the ED50 datum and the 1924 International spheroid. The documentation for the Spatial model contains information on how to define this coordinate system if it does not exist. License_Holder_Id is the surrogate key to the existing instance in Business_Associate where name is Conoco, Norway.