Table of Contents Introduction ................................................. 1 Installation ................................................. 1 Running DSSELECT ............................................. 1 Field Definitions ............................................ 6 Errors and Solutions ......................................... 10 Section 1 - Introduction to the Datasheet Interface 1.0 Introduction The intention of this manual is to offer you step by step instructions on how to load and run the DSSELECT program. The program DSSELECT is simply an interface which will give the user the ability to divide a datasheet into separate fields and print the fields out in any order specified. You will need a file of NGS formatted datasheets to run this program. The output of DSSELECT is a file of selected data elements from the datasheets. Section 1.0 gives and introduction and explanation of DSSELECT and this manual. Section 2.0 presents how to install and run the DSSELECT program and the different command line options for the program. Section 3.0 lists the data elements that can be selected and defines each. Section 4.0 describes the error messages the program can generate and gives possible corrective measures. 2.0 Installation To install DSSELECT simply copy the file DSSELECT.EXE from the installation diskette to your hard disk. 2.1 Running DSSELECT When running the program you have two command line formats, C:\DSSELECT script file name and C:\DSSELECT to select from. You have three arguments to the program, they are input, output and script files. The input file contains the NGS formatted datasheets which will be processed by the DSSELECT program. This file is required. The next file is the output file, which also is required. If this file does not exist, it will be created. If the file exists, there will be a message displayed asking if you would like to overwrite, append or quit. If you type 'O' the output file which already exist will automatically be erased of all it's contents, if you type a 'A' the data will be added on to the end of the output file, or if you type a 'Q' the program will terminate. The third and final argument is the script file. This argument is optional. The script file contains a list of the names of the data elements in the order the data values will appear in the output file. The script file can be modified manually through an editor. If you edit the script file through a editor be sure that the spelling of the data elements matches the spelling of the data elements in section 3.0 Field Definitions. If you do not follow one of these formats or if you have a erroneous file, a error message will be displayed. For explanation of the error message and possible solution see section 4.0. There is one more way you can run this program, and that is simply typing dsselect and pressing enter. By running the program this way a screen will appear prompting for the various files which you will need to run this program. The first thing you will see on the screen after you enter the command line arguments is a disclaimer. The disclaimer will be displayed on the screen until you press any key from the keyboard. If you run DSSELECT without giving a script file name on the command line, C:\DSSELECT DATAFILE DATAOUT, the program will create a new script file called "script". The next screen to appear is the data element selection form, which allows you to assign numbers to each data element to indicate the order in which the data elements will appear in the output file. An example of the form is shown in Figure 2.1. ÛßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßÛ Û Û Û Data Element Order of Selection Û Û Û Û DESIGNATION [_ ] VERT ORDER [ ] Û Û PID [ ] MODELED GRAV [ ] Û Û STATE [ ] HORZ ORDER [ ] Û Û COUNTY [ ] VERT ORDER [ ] Û Û USGS QUAD [ ] SPECIAL STATUS [ ] Û Û HORZ DATUM [ ] HISTORY [ ] Û Û EPOCH DATE [ ] X [ ] Û Û VERT DATUM [ ] Y [ ] Û Û 92 MINUS 83 [ ] Z [ ] Û Û HEIGHT [ ] LATITUDE [ ] Û Û 88 MINUS 29 [ ] LATITUDE DIR [ ] Û Û 83 MINUS 27 [ ] LONGITUDE [ ] Û Û LAPLACE CORR [ ] LONGITUDE DIR [ ] Û Û MONUMENTATION [ ] POS SRC [ ] Û Û SETTINGS [ ] SPC [ ] Û Û STABILITY [ ] UTM [ ] Û Û GEOID HEIGHT [ ] STAMPED [ ] Û Û ELLIP HEIGHT [ ] GPS SUITABILITY[ ] Û Û SEQUENCE NUMBER [ ] Û ßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßß Exit Initiate Toggle | Use arrows to scroll form Figure 2.1 When this form comes up the cursor will be in the DESIGNATION field. Let's say you wanted to only get the DESIGNATION and the STATE from your datasheet, but you want the state to be printed first, you would enter in a 2 in the DESIGNATION field and a 1 in the STATE field, see Figure 2.2. ÛßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßÛ Û Û Û Data Element Order of Selection Û Û Û Û DESIGNATION [2 ] ELLIP HEIGHT [ ] Û Û PID [ ] MODELED GRAV [ ] Û Û STATE [1 ] HORZ ORDER [ ] Û Û COUNTY [ ] VERT ORDER [ ] Û Û USGS QUAD [ ] SPECIAL STATUS [ ] Û Û HORZ DATUM [ ] HISTORY [ ] Û Û EPOCH DATE [ ] X [ ] Û Û VERT DATUM [ ] Y [ ] Û Û 92 MINUS 83 [ ] Z [ ] Û Û HEIGHT [ ] LATITUDE [ ] Û Û 88 MINUS 29 [ ] LATITUDE DIR [ ] Û Û 83 MINUS 27 [ ] LONGITUDE [ ] Û Û LAPLACE CORR [ ] LONGITUDE DIR [ ] Û Û MONUMENTATION [ ] POS SRC [ ] Û Û SETTINGS [ ] SPC [ ] Û Û STABILITY [ ] UTM [ ] Û Û GEOID HEIGHT [ ] STAMPED [ ] Û Û GPS SUITABILITY[ ] Û Û SEQUENCE[ ] Û ßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßß Exit Initiate Toggle | Use arrows to scroll form Figure 2.2 By placing a "1" in the STATE field, a "2" in the DESIGNATION field and pressing F10 the program will then print a message telling you that DSSELECT is copying data from the input file to the output file followed by a series of ".". What is actually happening is the program is taking the values of the data elements you have selected, STATE and DESIGNATION, and is printing them to the output file in the order you have selected. When the program is complete you will get a message saying Copying Complete. To prevent errors when entering the order numbers, the program will sound a beep and display a message at the bottom of the screen explaining the problem, see figure 2.3. ÛßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßÛ Û Û Û Data Element Order of Selection Û Û Û Û DESIGNATION [1 ] ELLIP HEIGHT [ ] Û Û PID [ ] MODELED GRAV [ ] Û Û STATE [1_] HORZ ORDER [ ] Û Û COUNTY [ ] VERT ORDER [ ] Û Û USGS QUAD [ ] SPECIAL STATUS [ ] Û Û HORZ DATUM [ ] HISTORY [ ] Û Û EPOCH DATE [ ] X [ ] Û Û VERT DATUM [ ] Y [ ] Û Û 92 MINUS 83 [ ] Z [ ] Û Û HEIGHT [ ] LATITUDE [ ] Û Û 88 MINUS 29 [ ] LATITUDE DIR [ ] Û Û 83 MINUS 27 [ ] LONGITUDE [ ] Û Û LAPLACE CORR [ ] LONGITUDE DIR [ ] Û Û MONUMENTATION [ ] POS SRC [ ] Û Û SETTINGS [ ] SPC [ ] Û Û STABILITY [ ] UTM [ ] Û Û GEOID HEIGHT [ ] STAMPED [ ] Û Û GPS SUITABILITY[ ] Û Û SEQUENCE [ ] Û ßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßßß Value entered in is the same as for the DESIGNATION field. figure 2.3 You can always go back to a field you have already entered a number in and update it if you wish by pressing F7 or to go to the previous field and F8 or to go to the next field. There are two field on this form which when selected will generate a sub-form asking for additional input. These fields are the LONGITUDE and the LATITUDE fields. When you select either of these fields and press , another form will be displayed asking if you would like to convert this information to decimal form. When this occurs you just simply press the space bar to toggle the field to "Y" for yes and "N" for no and press , and depending on your input you will either receive the data in decimal or character string format in your output file. There is a field option on the selection form called SEQUENCE. This field is a toggle field, by that I mean when you press the space bar you can either turn this field option on or off. By turning this field on you will get a sequential numbers in your output file at the beginning of every datasheet. If you choose not to select this field make sure the field is not marked with an "X". If the field is marked with an "X" it is set to on and you will get the sequence numbers, but if the field is blank it is set to off and you will not receive the sequence numbers. The program keeps the data element names and the order you have selected them stored in a file called "SCRIPT" for future use. Every time you run DSSELECT without the script file name on the command line, C:\DSSELECT , a new script file will be generated. A script file is a list of data element names in the order you have selected them from the Data Element Order of Selection form. See section 4.0 for valid data element names. 3.0 Field Definitions On the Datasheet Order of Selection form you have various fields of data which you have an option of selecting. This chapter defines each of these fields to give you a better understanding of what you are selecting. DESIGNATION DESCRIPTION : This is the common name, by which the station is known. FIELD TYPE : String. FIELD LENGTH: 40 PID DESCRIPTION : This is the unique "Permanent Identifier" Assigned to the station. FIELD TYPE : String. FIELD LENGTH: 6 STATE DESCRIPTION : This is the character code for the state where the station is located. FIELD TYPE : String. FIELD LENGTH: 2 COUNTY DESCRIPTION : This is the name of the county where the station is located. FIELD TYPE : String. FIELD LENGTH: 25 USGS QUAD DESCRIPTION : This is the name of the USGS topographic map sheet for the 7.5 minute area where the station is located. NGS often publishes data sheets by use of a quadrangle (quad) system, for which the USGS quad sheet name is used as a reference. FIELD TYPE : String. FIELD LENGTH: 34 HORZ DATUM DESCRIPTION : The horizonal datum is always NAD 83. The NAD 83 datum will be suffixed with the adjustment date of a high accuracy regional adjustment when the horizontal position resides within the bounds of the regional adjustment and was determined in conjunction with, or subsequent to, that regional adjustment. FIELD TYPE : String. FIELD LENGTH: 6 DATUM TAG DESCRIPT ION : A ll Latitude/Longitude which were adjusted in the North American Readjustment of 198 3 are on the NAD 83 Datum. Certain states ar e now having their Latitude/Lon gitudes readjusted again to a High Accuracy Regional Network (HARN). These stations are on the NAD 83 Datum but are being readjusted, so they are given a Datum Tag which distinguishes them from regular NAD 83 Datum stations. The Datum Tag is the Year when the readjustment was completed, such as (1990), (1992), (1994). FIELD TYPE : String. FIELD LENGTH: 4 VERT DATUM DESCRIPTION : This is the Datum on which the HEIGHT resides. It is usually either NGVD 29 or NAVD 88, but may be something other, like 'GUAM', 'AMERICAN SAMOA', etc. FIELD TYPE : String. FIELD LENGTH: 7 HEIGHT DESCRIPTION : This is the Orthometric height as found in . HEIGHT (Orthometric means that Height has been corrected for variations in the Gravity field). FIELD TYPE : String. FIELD LENGTH: 10 LAPLACE CORR DESCRIPTION : The Laplace correction is the quantity which, when algebraically added to an astronomic azimuth, yields a geodetic azimuth. FIELD TYPE : String. FIELD LENGTH: 6 MONUMENTATION DESCRIPTION : This tells if the mark is, A SURVEY DISK, or A REBAR, or A NAIL, etc as found in and the Blue Book. In DSDATA the two digit code is converted to the associated text. FIELD TYPE : String. FIELD LENGTH: 2 SETTINGS DESCRIPTION : This tells if the mark is , SET IN A ROUND CONCRETE MONUMENT, of SET IN A BOULDER, etc, as found in and the Blue Book. In DSDATA the two digit code is converted to the associated text. FIELD TYPE : String. FIELD LENGTH: 2 STABILITY DESCRIPTION : This tells how likely it is that the station monument will move, as found in and the Blue Book. In DSDATA the one letter code is displayed along with the associated text. FIELD TYPE : String. FIELD LENGTH: 1 GEOID HEIGHT DESCRIPTION : The geoid height is the height of the geoid surface above or below the ellipsoid surface. A positive geoid height indicates that the geoid surface lies above the ellipsoid surface. FIELD TYPE : String. FIELD LENGTH: 6 ELLIP HEIGHT DESCRIPTION : The ellipsoidal height is the height of the station above the ellipsoid. The ellipsoidal height is always referenced from NAD 83. FIELD TYPE : String. FIELD LENGTH: This field consists of 2 elements. The first element has a length of 8 characters and the second a length of 9 characters. MODELED GRAV DESCRIPTION : The modeled gravity is the interpolated gravity value that was used in the NAVD 88 adjustment. FIELD TYPE : String. FIELD LENGTH: 9 HORZ ORDER DESCRIPTION : Orthometric Height Order as per 'Specifications to Support classification, Standards of Accuracy, and General Specifications of Geodetic Control Surveys'. A = High Accuracy ( Better than B ) B = High Accuracy ( Better than 1st ) FIRST = 1st order SECOND = 2nd order THIRD = 3rd order FIELD TYPE : String. FIELD LENGTH: 1 VERT ORDER DESCRIPTION : Orthometric Height Order as per 'Specifications to Support Classification, Standards of Accuracy, and General Specifications of Geodetic Control Surveys'. FIRST = 1st order SECOND = 2nd order THIRD = 3rd order THIRD ? = 3rd order from a horizontal field party, but no observations available for confirmation. Orthometric Height Class as per FGGC spec mentioned above. 1 = Class 1 2 = Class 2 0 = Other Cases; Usually, the tolerance factor for ORDER/CLASS 1/0 is 2 mm or less, for 2/0, 8.4 mm and for 3/0, 12.0 mm. FIELD TYPE : String. FIELD LENGTH: 3 SPECIAL STATUS DESCRIPTION : The horizontal position of this high accuracy station is here by published prior to the rea djustment of the remaining lower order (first, second, and third order) stations in the region. The lower order non-suffixed stations in these region will not have consistent horizontal coordinate values with this station until the regional readjustment has been completed. FIELD TYPE : String. FIELD LENGTH: 1 HISTORY DESCRIPTION : History consists of the Year set (UNK=Unknown), the condition (STATION MONUMENTED, GOOD, POOR, etc) and who it was recovered by. FIELD TYPE : char struct[25] FIELD LENGTH: This field consist of three parts: condition text char 20 recovering agency char 30 year recovered char 4 X Y Z DESCRIPTION : Cartesian coordinates X, Y and Z are computed from the station's geodetic position and ellipsoidal height and are only displayed when and adjusted position and an ellipsoidal height are both available. FIELD TYPE : string. FIELD LENGTH: 12 each. LATITUDE DESCRIPTION : The latitude is always referenced to the NAD 83 datum. FIELD TYPE : String or Decimal. FIELD LENGTH: If string 14 or if decimal. LATITUDE DIR DESCRIPTION : The latitude direction from the equator. FIELD TYPE : String. FIELD LENGTH: 1 LONGITUDE DESCRIPTION : The longitude is always referenced to the NAD 83 datum. FIELD TYPE : String or Decimal. FIELD LENGTH: If string 15 or if decimal . LONGITUDE DIR DESCRIPTION : The longitude direction from Grenich. FIELD TYPE : String. FIELD LENGTH: 1 SUPER LAT NAD83 DESCRIPTION : This latitude is always reference to the NAD 83 datum. This is old data. This data has newer, more accurate data which supersedes it. FIELD TYPE : String. FIELD LENGTH: 13 SUPER LATDIR83 DESCRIPTION : The longitude direction from Grenich. This direction has a direction which supersedes it. FIELD TYPE : String. FIELD LENGTH: 1 SUPER LONG NAD83 DESCRIPTION : This longitude is always referenced to the NAD 83 datum. This is old data. This data has newer, more accurate data which supersedes it. FIELD TYPE : String. FIELD LENGTH: 13 SUPER LONGDIR 83 DESCRIPTION : The longitude direction from Grenich. This direction has a direction which supersedes it. FIELD TYPE : String. FIELD LENGTH: 1 SUPER LAT NAD27 DESCRIPTION : The latitude is always referenced to the NAD 83 datum. This is old data. This data has newer, more accurate data which supersedes it. FIELD TYPE : String or Decimal. FIELD LENGTH: If string 14 or decimal. SUPER LATDIR27 DESCRIPTION : The longitude direction from Grenich. This direction has a direction which supersedes it. FIELD TYPE : String. FIELD LENGTH: 1 SUPER LONG NAD27 DESCRIPTION : The latitude is always referenced to the NAD 83 datum. This is old data. This data has newer, more accurate data which supersedes it. FIELD TYPE : String or Decimal. FIELD LENGTH: If string 14 or decimal. SUPER LONGDIR27 DESCRIPTION : The longitude direction from Grenich. This direction has data that supersedes it. FIELD TYPE : String. FIELD LENGTH: 1 SUPER TAG DESCRIPT ION : A ll Latitude/Longitude which were adjusted in the North American Readjustment of 198 3 are on the NAD 83 Datum. Certain states ar e now having their Latitude/Lon gitudes readjusted again to a High Accuracy Regional Network (HARN). These stations are on the NAD 83 Datum but are being readjusted, so they are given a Datum Tag which distinguishes them from regular NAD 83 Datum stations. The Datum Tag is the Year when the readjustment was completed, such as (1990), (1992), (1994). This tag is for superseded data only. FIELD TYPE : String. FIELD LENGTH: 7 SUPER HEIGHT DESCRIPTION : This is the Orthometric height as found in . HEIGHT (Orthometric means that Height has been corrected for variations in the Gravity field). This is older data which has been superseded by some more recent data. FIELD TYPE : String. FIELD LENGTH: 10 SUPER SOURCE DESCRIPTION : Shows how the height for the superseded data was determined. FIELD TYPE : String. FIELD LENGTH: 10 POS SRC DESCRIPTION : Shows how the position was determined. FIELD TYPE : String. FIELD LENGTH: 10 SPC MT DESCRIPTION : State Plane Coordinate Zone as per Annex B of Blue Book measured in metrics. FIELD TYPE : String. FIELD LENGTH: This field consist of 5 elements: ZONE char 9 North char 13 East char 13 Scale char 10 Convergence char 10 SPC SURVEY FT. DESCRIPTION : State Plane Coordinate Zone Survey as per Annex B of Blue Book, measured in feet. FIELD TYPE : String. FIELD LENGTH: This field consist of 5 elements: ZONE char 9 North char 13 East char 12 Scale char 10 Convergence char 11 SPC INTL. FT. DESCRIPTION : State Plane Coordinate Zone International as per Annex B of Blue Book, measured in feet. FIELD TYPE : String. FIELD LENGTH: This field consist of 5 elements: ZONE char 9 North char 13 East char 12 Scale char 10 Convergence char 11 UTM DESCRIPTION : Universal Transverse Mercator. This is a World Wide Grid system. FIELD TYPE : String. FIELD LENGTH: This field consist of 5 elements: ZONE char 9 North char 14 East char 12 Scale char 11 Convergence char 12 STAMPED DESCRIPTION : This is what is stamped on the station disk. In most cases it is the same as the DESIGNATION, but may have a Agency and/or Data appended. FIELD TYPE : String. FIELD LENGTH: 50 GPS SUITABILITY D ESCRIPTION : If a site is reported as being sui table for GPS occupation then the Date of this determination and a 'Y' code is loaded into IDB table POINT_GPS. If it is reported as Not Suitable then a 'N' code is loaded. In some cases the site may be 'Y' one year and 'N' the next or vice-versa. FIELD TYPE : String. FIELD LENGTH: This field consists of 2 elements: verification char 1 date char 8 EPOCH DATE DESCRIPTION : The epoch date is used for stations in regions of horizontal crustal motion. When a station moves horizontally due to episodic earthquakes and/or continuous motion, the coordinates change with time. The epoch date indicates the time when the published horizontal coordinates are valid. FIELD TYPE : String. FIELD LENGTH: 7 NO CHECK DESCRIPTION : N = No observational check was made to the position. ' ' = Check was made. FIELD TYPE : String. FIELD LENGTH: 1 BOX SCORE DESCRIPTION : Shows how the height was determined. FIELD TYPE : char struct[75] FIELD LENGTH: this field consists of 6 elements and there lengths are: (1) char 6 (2) char 35 (3) char 7 (4) char 5 (5) char 2 (6) char 9 SEQUENCE NUMBER DESCRIPTION : Prints a sequential list of numbers before each datasheet. FIELD TYPE : toggle FIELD LENGTH: char 1 4.0 Errors, Solutions and File Format When you run the DSSELECT program you may encounter some errors along the way. This section will help you define your problem, then solve it. Here are a some errors you may come across while running the program along with it's solution. 1) ERROR: ***ERROR: not found. DEFINITION: You are trying to read a input file that cannot be found. SOLUTION: Check the path of the input file and make sure the file is actually at that location. you are 2) WARNING: File: already exist. Do you wish to [O]verwrite, [A]ppend, or [Q]uit. DEFINITION: The output file you want to write your data to already exists and you can either write over it, append to it, or quit the program. SOLUTION: This is just a safety feature for you. If you are sure of what you wish to do, simply type either an O to overwrite the file, an A to append to the end of the file, or an Q to quit the program. 3) ERROR: ***ERROR: Invalid input. Enter either an O, A, or Q. DEFINITION: You did not type the correct letter when you were prompted for whether or not you want to overwrite, append, or quit the output file. SOLUTION: When your output file already exists and you are prompted for input on whether or not you want to overwrite, append, or quit you must enter in either an O, A, Q. 4) ERROR: ***ERROR: invalid input file, or file does not contain the correct datatype. DEFINITION: The input file you are trying to read in is either empty, or does not contain the right information in it i.e., (data sheets). SOLUTION: Check the input file and make sure it's not empty and it contains NGS formatted datasheets. 5) ERROR: ***ERROR: You must enter a input file. DEFINITION: You did not enter a input file as one of programs arguments. SOLUTION: When running this program you must have a input file as one of the programs arguments. 6) ERROR: ***ERROR: You must enter a output file. DEFINITION: You did not enter a output file as one of programs arguments. SOLUTION: When running this program you must have a output file as one of the programs arguments. 7) ERROR: invalid or empty script file. DEFINITION: You have tried to run the program with the script file option and when the script file was read it either was empty or it did not contain the correct script file format. SOLUTION: Check to see if the script file is empty or that it has the correct script file format. See section 4.1 for the script file format. 8) ERROR: Value entered in is the same as for the field. DEFINITION: When entering in the sequence in which you want your fields printed, you have used the same number twice. SOLUTION: Either change the number in the previous field or change the number in the current field you in. 4.1 File Format You have two files which will be created by DSSELECT. These two files are the and the