[GIS] Converting .dat files to shapefiles

convertshapefile

We have electrical conductivity maps of our fields created using a Veris sensor that are in a .dat file type. We want to import these maps into our Ag leader SMS database, but in order to do that, they need to be converted to shapefiles.

How would I go about converting them?

Best Answer

As you have confirmed that the file format is (per my comment) as described in the link Re: .dat file from Veris Machine How to Read

There are five columns of data logged by a Veris machine: Column A: Longitude Column B: Latitude Column C: Shallow EC Column D: Deep EC Column E: Elevation

You should as per that post be able to import the .dat file into Excel add the appropriate column headings and export as CSV.

You say you need a shapefile to import into the Ag leader SMS database, but the Ag Leader support documentation tells us that CSV file format is supported, so you should be able to import the CSV directly.

Related Solutions

[GIS] Converting JSON/GeoJSON files to Shapefiles

To convert TopoJSON files to Shapefiles using ogr2ogr you'll need to install the geojson-cli package for Node.js using the Node Package Manager (NPM). You can follow the instructions below or read this article on installing both.

# If you need to install Node and NPM...
wget http://nodejs.org/dist/v0.10.24/node-v0.10.24.tar.gz
tar -xzvf node-v0.10.24.tar.gz && rm node-v0.10.24.tar.gz && cd node-v0.10.24
./configure
sudo make
sudo make install

# For installing NPM...
wget https://npmjs.org/install.sh
source install.sh

# Finally, install the geojson-cli
sudo npm install -g geojson

With the geojson-cli installed, you can convert your TopoJSON back into GeoJSON, which can then be converted to a Shapefile using ogr2ogr.

# Automatically makes a file with ".topo" removed in filename
geojson my.topo.json
ogr2ogr -f "ESRI Shapefile" my.shp my.json

Alternatively, you can convert your TopoJSON to GeoJSON and back again using this handy web client.

[GIS] Bulk conversion and import of OS MasterMap .gz files to .shp in ArcGIS Desktop

You could use python to extract the shps of each .gz file and use feature class to feature class method to import them into the destination geodatabase. The Q/A below is one example how to extract contents of many .gz files in a directory.

python script to copy and extract .gz files

Best Answer

Related Solutions

[GIS] Converting JSON/GeoJSON files to Shapefiles

[GIS] Bulk conversion and import of OS MasterMap .gz files to .shp in ArcGIS Desktop

Related Question