GEOTRANS is an application program which allows you to easily convert geographic coordinates among a wide variety of coordinate systems, map projections, and datums. GEOTRANS runs in Microsoft Windows (95 and NT) and UNIX Motif environments. Developed by the United States National Imagery and Mapping Agency
| Perseverance pays off. We got our GeoTrans data file to convert (just renamed it) and sorted through the intricacies of the software, but found it really handy. It's just saved us likely 3 days of hand datum conversions of about 3300 sheep and goat locations. Thanks for the tips. If you decide to download it and give it a whirl, I've attached the steps for large file conversion (it took quite a while to work out the bugs, but it's very simple). This may have some applications to the wildlife crowd with regards to old paper location data. Thanks again Salut! -- Todd Powell - 30 July 2003 |
=a1&, &b1 for all the columns to group up so your resulting column looks like 11, N, 337200, 5996700 Delete all other columns and make sure that the worksheet youre using is the first one on the worksheet order.
11, N, 337200, 5996700(zone, north, easting, northing) Each number/letter needs to be separated by a comma and at least one space no paranthesis are able to be used. Example:
COORDINATES: Universal Transverse Mercator (UTM) DATUM: NAS-F # ELLIPSOID: CC END OF HEADER 11, N, 337200, 5996700 11, N, 340000, 5994700 11, N, 337300, 5996500 11, N, 337200, 5996500 11, N, 337200, 5995900 11, N, 337200, 5996400 11, N, 337100, 5996700 11, N, 337000, 5995800 11, N, 337300, 5996500 11, N, 337200, 5996700 11, N, 340500, 5992500 11, N, 341200, 5992400 11, N, 337000, 5996900
The input header (very key) can be created by selecting an existing file (several available from the examples in the geotrans program file) and then select the output file with the parameters youd like for your header (ex NAD83, UTM, zone#). Paste this to the top of your .dat file
Select your output parameters for what you would like it to become (ex: NAD83, UTM, Zone#), and name a file for it when asked
click through the instructions, it will display results and errors
Open the .dat output file in excel, and go through the wizard to select the columns of easting and northing as youd like and finish
Now you can convert your new excel file into a text file, then in ArcView create an event theme in a view to bring in the table, then reproject it into the standard projection using avtools.
For more complete GeoTrans instructions see GeoTrans User manual ({install_dir}/geotrans2/docs/user.doc)
-- Todd Powell - 30 Jul 2003
| WebForm | |
|---|---|
| TopicCategory | HowTo |
Comments0