Survey data can be imported into either a new or existing survey. See the section on Importing Data for an introduction into the overall workflow. Importing survey data works the same way. This process is expanded here for the special case of importing survey data because it is so central to the operation of the cross section viewer software.
1. Create empty survey data template
To import survey data, click on
Data main menu item and then choose
Surveys. The gridview showing all existing surveys will appear. Next select
Create Empty Survey Data Template... from the
Edit > Import menu. Specify a file path for the new, empty template.
At this step, you need to choose one of the three ways that you intend to define cross sections in the template. The default selected item is the method used in the currently open cross section viewer database. See the section on creating new databases if you are unsure which option to choose.
Click OK and the import template will be generated and saved.
2. Populating the Import Template.
Open the import template using Microsoft Access. The
SurveyPoints table should be the only table in the database, open it and then use the built-in features of Microsoft Access to import your survey data into this single table. Typically this can be done using cut and paste from some other software. Or you can use the Access import feature to get information into this table.
The fields present will be dependent on which cross section identification method you specified above.
- SurveyName - name for the survey to which all the survey points belong. Use the same value for all rows.
- SurveyDate - the date that each survey point was collected.
- Cross Section Identification Field - this will either be
RiverMileif you chose to identify your cross sections by either ID or river mile respectively. If you chose to identify your cross sections by stationing then there will be
RiverDistanceLabelwhich must contain values in a
- Easting - the UTM easting of the survey point.
- Northing - the UTM northing of the survey point.
- Elevation - absolute elevation above sea level of the survey point.
- Station - Distance from left bank of the survey point.
- Offset - perpendicular distance of the survey point from the intended cross section line. See the cross section plot options section for more information.
See the section on creating databases for the units of the elevation and station fields.
3. Importing the Data
When you have finished inserting survey data into the template, and before you import the data, it’s a very good idea to double check all the values. This can be done using Microsoft Access SQL Queries to validate the range of values in each field, and also the completeness of the database.
Also, you should backup both the cross section viewer database as well as the import template that contains the new survey data.
To import the contents of the populated template, choose the
Import Populated Template from the
Edit > Import menu. Browse to the populated Microsoft Access template file that you edited in the previous step.
Choose whether you want to import the contents of the template into a new survey or an existing survey. i.e. the survey includes a cross section at a location that was not included in any previous surveys. If you choose to import into an existing survey then you should ensure that the new survey data represent cross sections that are not already present in the cross section viewer for the selected survey. In other words, don’t import data for the same cross section into the same survey twice!
The following warning will appear if the import routine finds a cross section in the populated template that is not already defined in the cross section viewer database. This warning will appear regardless of cross section identification process being used, albeit with either the ID, river mile or display distance shown as the distinguishing column.
Review the cross sections in the list. If you click
Continue new cross section definitions will be added to the cross section viewer database as part of the import process. If you click
Cancel then the import process will be aborted and no changes will be made to the cross section viewer database.