About Amerisurv| Contact    
Magazine | Newsletter    
Flickr Photos | Advertise    
HomeNewsNewsletterAmerisurv DirectoryJobsStoreAuthorsHistoryArchivesBlogVideosEvents

Sponsored By

Software Reviews
Continuing Series
An RTN expert provides everything you need to know about network-corrected real-time GNSS observations.
Click Here to begin the series,
or view the Article PDF's Here
76-PageFlip Compilation
of the entire series
Test Yourself

Got Answers?
Test your knowledge with NCEES-level questions.
  Start HERE
Meet the Authors
Check out our fine lineup of writers. Each an expert in his or her field.
Wow Factor
Sponsored By

Product Reviews
Partner Sites







Spatial Media LLC properties




Home arrow Archives   The American Surveyor     

GIS Matters: Point Data as GIS Features—ASCII Print E-mail
Written by Rj Zimmer, LS   
Friday, 27 May 2011

A 592Kb PDF of this article as it appeared in the magazine—complete with images—is available by clicking HERE

Create a GIS point feature data set from an ASCII file, and then relate each point to a database record. The process described here works equally well with Excel spreadsheets with only minor differences on how the file is loaded into ArcMap.

ASCII (the American Standard Code for Information Interchange) is commonly used format for exchanging computer data. The ASCII has been in use since the 1960s and has been used in GIS for about that long. ASCII formatted data files are a common export/import option on most surveying software as well. In the GIS realm ASCII formats are used for a variety of raster and vector data. GIS software may read some ASCII formatted data directly, or may import or export the ASCII formatted data to other GIS formats. This article explains how to use an ASCII formatted point dataset in GIS and how to convert the ASCII point data to a GIS format (such as a shapefile or geodatabase feature class) with attributes.

With ESRI's ArcMap one can easily load a delimited text file for display in geographic space provide that the text file has the following elements (see Fig.1):

1. X coordinate and Y coordinate as numeric values. The coordinates may be geographic or project coordinates, although geographic coordinates cannot be in degree, minutes, seconds (DMS) format (that format is non-numeric). If your coordinates are in DMS format, you must convert those to decimal degrees. Other numeric coordinate formats are acceptable so long as the GIS software understands the spatial reference and units. Projected coordinates such as UTM meters, or State Plane feet will work as well.

2. ArcMap expects the first row to contain the header and it does not provide a means to designate any other row as the header. Therefore, the first row will be treated by ArcMap as the header row. The header row identifies the field names including which fields contain the X (or easting) coordinate and Y (or northing) coordinate. The headers will be used as field names so they must conform to the ten-character limitation with no spaces or special characters in the name. The header row must be the first row in the file (see Fig. 2).

Optionally, the file may have an ObjectID field as a numeric data type for unique identifiers for each record. If the ObjectID field exists, then you will be able to perform a few basic spatial functions on the data such as selecting points on the map. All other fields, as listed in the header row in the file, will be treated as attributes for which each record.

View and Prepare the File Format
The sample file shown in Fig. 2 is a comma delimited text file, which means that a comma defines the separation between fields in each row. In addition, each row is treated as an individual record, so the number of rows equals the number of records. If an individual record has no value for a particular field, then there will be no data between the delimiters. In this sample dataset that would look like two commas with nothing between them.

Since our sample dataset has a couple extra lines before the header row we must remove the two extra lines at the top of the file. You can do this with any text editor such as Notepad, which can save in ASCII format. Be careful not to use word processing software that would change the file format.

Add the Points to ArcMap
After editing the file to remove the first two lines, the file is now ready to add to ArcMap.

In ArcMap we use TOOLS --> Add X Y Data, browse for my ASCII file with the .txt extension (see Fig. 3). This utility allows us to browse for the file, designate which field contains the X coordinates and which field contains the Y coordinates, and specify the coordinate system of our X and Y coordinates. It is very important to specify the correct coordinate system, datum, projection, and coordinate units, as the spatial reference defines the proper placement of the points into geographic space.

After you set all the parameters in the Add XY Data dialog box and click OK, then ArcMap reads in each line of the file, and creates a point graphic on the screen for each record if the coordinates make sense (see Fig 4). The point graphics are based on the XY coordinates, and all other data are treated as attributes for each point (see Fig. 5).

The Add XY Data process adds the ASCII point data as an event theme in ArcMap. Event themes are not a GIS type, but rather a virtual geographic interpretation with a linkage to the data in the ASCII file. The original ASCII file is still intact with no changes to it. ArcMap is merely reading and interpreting the text file for display in ArcMap. The graphics and attributes are available for view only in the ArcMap project in which the event theme was created. It is not available as a GIS dataset for any other application. However, once you add the ASCII file to ArcMap as an event theme, you can add other GIS layers to the map and everything should properly align.

Convert to GIS format
To create a GIS dataset from the event theme, you must export the event theme to a shapefile or to a feature class in a geodatabase. To export to a GIS dataset, right click on the event theme layer in the map's table of contents, then select Export from the list of options. This will initiate the Export dialog (see Fig. 6) which allows you to save as a GIS dataset with the file name of your choice and, optionally, to change the spatial reference as well. The result of the export operation will be a new file such as a shapefile. This operation does not make any changes to the original ASCII file. The new GIS file will be immediately available to use in any number of GIS display and analysis operations.

Rj Zimmer is Director of GIS and Mapping for DJ&A, PC of Montana, an engineering, surveying, and mapping consulting company.

A 592Kb PDF of this article as it appeared in the magazine—complete with images—is available by clicking HERE

< Prev   Next >

Marc Cheves, PS 
Editorial: A Great Year to be a Surveyor
Some magazines have what are called "theme" issues. That is, most of the content is focused on one particular subject. In my 22+ years of survey magazine publishing, my philosophy has always been to have a little bit of everything in each issue, thereby eliminating the possibility that ....
Read the Article
Jason E. Foose, PS 
Decided Guidance: Case Examinations: Halverson v. Deerwood Village
Whew! We really beat the snot out of Bryant v. Blevins and practical locations. Well this month we're back on new case that hit the Minnesota Supreme Court's docket in 1982. We've got the familiar gymnastics of jurisprudence featuring an extraordinary array of flying rope stretchers ...
Read the Article
Michel Philips 
Extreme Environment Surveying
A Franco-Chilean team of cave divers used the Nautiz X8 rugged handheld for marine cave surveying, gathering data to classify the inaccessible northern half of Madre de Dios for UNESCO World Heritage. The team of cave divers used the Nautiz X8 ....
Read the Article
Erik Dahlberg 
The Original Green Engineers
Sometimes, it's best just to leave things as you found them. That's the lesson shared by Dr. Richard Miksad and his students at the University of Virginia. As a result of studies covering nearly a decade, Miksad's teams have developed detailed ....
Read the Article
Dave Lindell, PS 
Test Yourself 49: No Dimensions
In square A-C-D-B with side S, C-E is tangent to the semicircle Q1 with diameter B-D. Q2 is the inscribed circle of A-C-E. The tangent to Q1 and Q2 meets the sides of the square at F and H and intersects C-E at t G. Q3 is the inscribed circle of C-G-H. What is the ratio of the radii of circles ....
Read the Article
Jerry Penry, PS 
Discovery on Grizzly Peak
When First Lieutenant Montgomery M. Macomb arrived in Carson City, Nevada, from Washington D.C., on July 28, 1878, his assigned survey crew from the 4th Artillery was waiting and ready for the new field season. At age 25, Macomb was the leader ....
Read the Article
Wendy Lathrop, PS, CFM 
Vantage Point: Fighting City Hall Over Land
Once upon a time (1989 to be exact) in a place not so far away from where I live, a man (Francis Galdo) bought a home across the street from a vacant parcel owned by the City of Philadelphia. That parcel, along with others, had been acquired by condemnation back in 1974 subsequent to a 1956 ....
Read the Article
Patrick C. Garner, PS 
Book Review: Boundary Retracement: Processes and Procedures
When I was in my mid-twenties and learning the honorable profession of land surveying, I was lucky to be guided by a mentor who would grab a book off his office shelf and say, "Every surveyor should have a copy of this!" The first example he waved at me was Davis, Foote and Kelly's Surveying ....
Read the Article


Amerisurv Exclusive Online-only Article ticker
Featured Amerisurv Events
List Your Event Here
contact Amerisurv


SXblue Announces
Premier Receiver

press [at] amerisurv.com
Online Internet Content


News Feeds

Subscribe to Amerisurv news & updates via RSS or get our Feedburn
xml feed

Need Help? See this RSS Tutorial

Historic Maps

post a job
Reach our audience of Professional land surveyors and Geo-Technology professionals with your GeoJobs career ad. Feel free to contact us if you need additional information.


Social Bookmarks

Amerisurv on Facebook 

Amerisurv LinkedIn Group 

Amerisurv Flickr Photos 

Amerisurv videos on YouTube 



The American Surveyor © All rights reserved / Privacy Statement
Spatial Media LLC
7820B Wormans Mill Road, #236
Frederick MD 21701
301-695-1538 - fax