|
CSV Batch File Converter HelpUpdated March 16, 2011 to add NTS Conversion Capabilities This program will convert batches of legal land descriptions and National Topographic System descriptions to latitude and longitude, Any line with 7 fields total (6 NTS Fields + 1 Account ID Field) is treated as NTS data. Any line with 6 fields total (5 Legal Land Description Fields + 1 Account ID Field) is treated as Legal Land data. Legal Land Data and NTS Data can be mixed into the same input file. The output file will list all the Legal Land Conversions first, followed by all the NTS conversions. Please run a small batch first to ensure proper operation before converting a large batch. This will make everyone happier. The 'Check Syntax' feature allows you to check your data for suitability before purchasing any credits for conversion.
/** Input and Output File Specifications
LEGAL LAND DESCRIPTION
INPUT FIELDS
------------
1. ID
2. Quarter
3. Section
4. Township
5. Range
6. Meridian
EXAMPLE INPUT DATA LINE
-----------------------
A14,NE,1,2,2,4
OUTPUT FIELDS
-------------
1. ID
2. Quarter
3. Section
4. Township
5. Range
6. Meridian
7. LATITUDE
8. LONGITUDE
EXAMPLE OUTPUT DATA LINE
-------------------------
A14,NE,1,2,2,4,42.0945,110.135
National Topographic System
INPUT FIELDS
------------
1. ID
2. Quarter
3. Unit
4. Block
5. Series
6. Area
7. Sheet
EXAMPLE INPUT DATA LINE
-----------------------
A16,A,2,D,94,P,1
OUTPUT FIELDS
-------------
1. ID
2. Quarter
3. Unit
4. Block
5. Series
6. Area
7. Sheet
7. LATITUDE
8. LONGITUDE
EXAMPLE OUTPUT DATA LINE
-------------------------
A16,A,2,D,94,P,1,59,-120.388
Download
Sample Input File
Sample Output File
**/
1. Create Account if needed
2. Click on CSV File Converter
3. Login with user name and password you created in step 1
4. Upload File
5. Check Syntax
6. Check Conversion Report for syntax errors and Number of Credits Needed
7. Buy Credits From Paypal
8. Run Convert
9. Check Conversion Report for errors and control totals
10. Download output
11. Cleanup Files.
Example Control Totals
The input file name must end with a .csv extension. The input file name cannot start with the 3 letters 'run'. These are reserved for run output. 'ID' is a line number or key you assign. It is normally the key used to re-import the converted data. One Credit is used for each conversion. Only converted lines are billed. Lines that are not converted (ie: errors) are listed in the conversion listing. There is no charge for syntax checking. Each run will be assigned a run number. All filenames related to a run will contain that run number. The input file is renamed to runXXinput.csv with the XX being replaced with the run number. This prevents the conversion from being re-run and re-billed. The Upload feature has been tested to 64 Megabytes. Files are to be uploaded for conversion purposes only. 'Parking' files such as backups, videos, powerpoints or tarballs is not allowed. These 'Parked' files may be deleted immediately. We may delete any files that are older than 45 days. |
![]() Convert National Topographic System to Latitude and Longitude (NTS to GPS) Convert Universal Transverse Mercator to Latitude and Longitude (UTM to GPS) ![]() Convert USA Public Land Survey System to Latitude and Longitude (PLSS to GPS) ![]() Convert United States National Grid (USNG) / Military Grid Reference System (MGRS) to Latitude and Longitude Becoming a Subscriber Create Account Purchase Credits Online Credits Order Form Edit Account Fees FAQ Privacy Suggestion Box Waiver Contact CSV Batch File Converter CSV Batch File Converter Help NTS Grids of Alberta, BC & Canada Map of North America with Latitude and Longitude Grid |
||||||||||||||||||||||
|
www.legallandconverter.com Scantek Systems Inc. Copyright © 2009, 2010, 2011, 2012 |
||||||||||||||||||||||||