Loading Sequence

1.    Create the Survey_2D instance with Name and Survey_CRS_Id foreign key to R-Coordinate_Ref_System.

2.    Add License_Holder_Id foreign key in Survey_2D to Business_Associate (Company or Person).

3.    Create Acquisition_2D with foreign key Survey_2D_Id to Survey_2D.

4.    Create foreign keys in Acquisition_2D (Acquisition_Data_Type, Navigation_System, Recording_System, and Acquisition_Format) to reference tables for available acquisition information.

5.    Create an instance of Geophysical_Inventory with Inventory_Type "Other" and Full_Path_Filename set to the path of the input file to store the UKOOA header text.

6.    Create an instance of Header_ Text for each line of the UKOAA header with Id equal to the Id of the Geophysical_Inventory created in previous step, Header_Text, containing one header record and Rank containing the record number within the header.

7.    Read and parse all records belonging to a line.

8.    Create Seismic_Line with foreign key Survey_Id and Seismic_Line_Type set to Navigation (from R_Seismic_Line_Type).

9.    Create an instance of Line to represent the seismic line and add foreign key Seismic_Line.Line_Id pointing to it.

10.  Simplify and or segment the latitude and longitude (or X and Y) of navigation points if desired. Convert the points to the project coordinate system if necessary.

11.  Create a Seismic_Dataset_2D instance with foreign key Seismic_Line_Id to the Seismic_Line, Seismic_Data_Type to "Postplot_Navigation", Seismic_Format to "UKOOA P1/90," and Processing_Contractor_Id set to the Id of Business_Associate that processed the navigation data.

12.  Create an instance of Dataset_Inventory_X with Seismic_Dataset_Id equal to the Id of the Seismic_Dataset_2D created in the previous step and Geophysical_Inventory_Id set to the of the Id of the Geophysical_Inventory instance for the UKOOA Header created in step 5.

13.  Create instances of Dataset_Line_Segment with the First_CDP (First_Shotpoint), Last_CDP (Last_Shotpoint), and Numbering_System (CDP or Shotpoint) of the segment and foreign key Dataset_Line_Segment.Seismic_Line_Id as needed.

14.  Create a Dataset_Boundary instance with foreign key Seismic_Dataset_Id to the Seismic_Dataset from the previous step.

15.  Create an Area instance to represent the dataset boundary and add the foreign key Dataset_Boundary.Polygon_Geometry.Id pointing to the Area. Compute the boundary and store the Area.

16.  Repeat steps 7 through 16 for each 2D seismic line.

17.  Create an instance of Inventory_Boundary with foreign key Geophysical_Inventory_Id equal to the Id of the Geophysical_Inventory instance created in step 5 to store the UKOOA header text.

18.  Create an Area instance to represent the inventory item boundary and add the foreign key Inventory_Boundary.Polygon_Geometry.Id pointing to the Area.