convert .dat files to either .dta, .shp, .bdf, or .csv

gis dta
Mere picture Mere · Jul 14, 2012 · Viewed 64.8k times · Source

I have downloaded spatial data from the USGS website that comes in a .dat format, which I can't read in textedit either - it just says "../ofr041189it03/vat.adf". I am familiar with STATA, ArcGIS, and GeoDA, so I was hoping to convert it into a type that can be read by any of these programs (preferably STATA), but don't know how. Any ideas?

Answer

Saravanan Divin picture Saravanan Divin · Oct 3, 2012

Open a New Blank Excel file

In Excel

  1. Go to Data tab
  2. Select From Text
  3. Select the .dat file which you want to open(Note: Select "All files" in dropdown box)
  4. Click Import
  5. Check Delimited and click next
  6. Deselect the tab and select Other and give "|"(Tab symbol) then click next
  7. Click finish and Ok

Related questions

Fastest Way to Find Distance Between Two Lat/Long Points

I currently have just under a million locations in a mysql database all with longitude and latitude information. I am trying to find the distance between one point and many other points via a query. It's not as fast as …

Read More
Best way to overlay an ESRI shapefile on google maps?

What is the best way to overlay a shapefile in Google Maps? After some reading suggests that, converting shapefile into KML and overlaying KML in Google map is an option. If that is the case, how do I convert a …

Read More
Get lat/long given current point, distance and bearing

Given an existing point in lat/long, distance in (in KM) and bearing (in degrees converted to radians), I would like to calculate the new lat/long. This site crops up over and over again, but I just can't get …

Read More