[GRASS-user] Vector file import formats

   I have a 90 files that are supposed to be figures but have the Microsoft
Access .mdb extension and another 88 files with ARC/GIS .mxd extensions.
When I look at supported formats for v.in.ogr I don't see either of those
after sorting the list (why isn't it sorted anyway?).

   Is there a way to import the vectors and associated (I presume) data into
GRASS7x?

Rich

Hey Rich, the .mxd files are project files for ESRI's ArcGIS and don't really contain any "data". They can be opened with ArcMap for example and are used to mostly conduct geospatial analysis and map production.

The other files you have, .mdb may contain the spatial data but I think that data cannot be converted or extracted from within grass unless GDAL has been built with .mdb support [1][2].

[1] http://www.gdal.org/drv_pgeo.html

[2] http://www.gdal.org/drv_mdb.html

Donovan

On 27/10/16 09:28 AM, Rich Shepard wrote:

  I have a 90 files that are supposed to be figures but have the Microsoft
Access .mdb extension and another 88 files with ARC/GIS .mxd extensions.
When I look at supported formats for v.in.ogr I don't see either of those
after sorting the list (why isn't it sorted anyway?).

  Is there a way to import the vectors and associated (I presume) data into
GRASS7x?

Rich
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

--
Kind regards,

Donovan

The MXD files are just ArcGIS Map documents. They will hold no data - only symbology.

You'll need to get your data out of the personal geodatabase files (the .mdb files). It's been a while since I've tackled that - I wrote a tutorial for doing this in QGIS. People have had hit or miss luck with the tutorial - http://www.northrivergeographic.com/qgis-accessing-personal-geodatabase. It works for me (win 10 64 bit with QGIS).

Personal geodatabases were a first attempt at a database format for ESRI when they left coverages. It's mostly been abandoned for the File Based Geodatabase.

I know that probably isn't helping much - but - it might get you started. I don't think there's a straight forward way to push that into GRASS - there will need to be a few steps before hand.

Randy

On 10/27/2016 12:28 PM, Rich Shepard wrote:

  I have a 90 files that are supposed to be figures but have the Microsoft
Access .mdb extension and another 88 files with ARC/GIS .mxd extensions.
When I look at supported formats for v.in.ogr I don't see either of those
after sorting the list (why isn't it sorted anyway?).

  Is there a way to import the vectors and associated (I presume) data into
GRASS7x?

Rich
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

--
-----------------
Randal Hale
North River Geographic Systems, Inc
http://www.northrivergeographic.com
423.653.3611 rjhale@northrivergeographic.com
twitter:rjhale

On Thu, 27 Oct 2016, Donovan Cameron wrote:

Hey Rich, the .mxd files are project files for ESRI's ArcGIS and don't
really contain any "data". They can be opened with ArcMap for example and
are used to mostly conduct geospatial analysis and map production.

Donovan,

   Interesting. That's the problem with proprietary data: not everyone can
access it. And this is a shame for documents produced by federal agencies
since we all pay their costs.

The other files you have, .mdb may contain the spatial data but I think
that data cannot be converted or extracted from within grass unless GDAL
has been built with .mdb support [1][2].

   I doubt they have spatial data. I think I have a tool here that converts
.mdb to something usable.

Thanks,

Rich

On Thu, 27 Oct 2016, Randal Hale wrote:

The MXD files are just ArcGIS Map documents. They will hold no data - only symbology.

Randy,

   Therefore, useless to me.

You'll need to get your data out of the personal geodatabase files (the
.mdb files). It's been a while since I've tackled that - I wrote a
tutorial for doing this in QGIS. People have had hit or miss luck with the
tutorial -
http://www.northrivergeographic.com/qgis-accessing-personal-geodatabase.
It works for me (win 10 64 bit with QGIS).

   I think I still have an .mdb converter here somewhere. I'll go look for
it. I work with only linux and F/OSS tools. And I can still access data from
20+ years ago. :slight_smile:

I know that probably isn't helping much - but - it might get you started.
I don't think there's a straight forward way to push that into GRASS -
there will need to be a few steps before hand.

   Okay. If I decide to pursue this I'll do more digging.

Thanks,

Rich

Rich Shepard wrote

On Thu, 27 Oct 2016, Randal Hale wrote:

The MXD files are just ArcGIS Map documents. They will hold no data -
only
symbology.

Randy,

   Therefore, useless to me.

You'll need to get your data out of the personal geodatabase files (the
.mdb files). It's been a while since I've tackled that - I wrote a
tutorial for doing this in QGIS. People have had hit or miss luck with
the
tutorial -
http://www.northrivergeographic.com/qgis-accessing-personal-geodatabase.
It works for me (win 10 64 bit with QGIS).

   I think I still have an .mdb converter here somewhere. I'll go look for
it. I work with only linux and F/OSS tools. And I can still access data
from
20+ years ago. :slight_smile:

I know that probably isn't helping much - but - it might get you started.
I don't think there's a straight forward way to push that into GRASS -
there will need to be a few steps before hand.

   Okay. If I decide to pursue this I'll do more digging.

Thanks,

Rich
_______________________________________________
grass-user mailing list

grass-user@.osgeo

http://lists.osgeo.org/mailman/listinfo/grass-user

See

http://www.gdal.org/drv_pgeo.html

try accordingly to this GDAL driver manual ogrinfo to your mdb files.

it works for me on windows and linux to read personal geodatabases with the
. Mdb extension.

-----
best regards
Helmut
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Vector-file-import-formats-tp5293096p5293109.html
Sent from the Grass - Users mailing list archive at Nabble.com.

Rich,

    I would look at the excellent MDB-tools package (http://mdbtools.sourceforge.net). mdb-export will pull a specific layer out of the mdb file. Unless it's a point coverage it's not going to contain spatial data though, and even for point coverages it's rare to the the point coordinates in the table.

    The access2csv java.jar program also claims to do .mdb, but I have only used it for .accdb files because mdb-export works so well.

    As I recall, you're a linux guy, so you should have little trouble with this.

    For the spatial data you'll have to find a shape file or coverage.

Dave

On 10/27/16 10:46, Rich Shepard wrote:

On Thu, 27 Oct 2016, Randal Hale wrote:

The MXD files are just ArcGIS Map documents. They will hold no data -
only symbology.

Randy,

  Therefore, useless to me.

You'll need to get your data out of the personal geodatabase files (the
.mdb files). It's been a while since I've tackled that - I wrote a
tutorial for doing this in QGIS. People have had hit or miss luck with
the
tutorial -
http://www.northrivergeographic.com/qgis-accessing-personal-geodatabase.
It works for me (win 10 64 bit with QGIS).

  I think I still have an .mdb converter here somewhere. I'll go look for
it. I work with only linux and F/OSS tools. And I can still access data
from
20+ years ago. :slight_smile:

I know that probably isn't helping much - but - it might get you started.
I don't think there's a straight forward way to push that into GRASS -
there will need to be a few steps before hand.

  Okay. If I decide to pursue this I'll do more digging.

Thanks,

Rich
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

--

On Thu, 27 Oct 2016, Helmut Kudrnovsky wrote:

See
http://www.gdal.org/drv_pgeo.html
try accordingly to this GDAL driver manual ogrinfo to your mdb files.
it works for me on windows and linux to read personal geodatabases with the
. Mdb extension.

Helmut,

   Thank you. This is good information.

Regards,

Rich

On Thu, 27 Oct 2016, Dave Roberts wrote:

  I would look at the excellent MDB-tools package (http://mdbtools.sourceforge.net). mdb-export will pull a specific layer out of the mdb file. Unless it's a point coverage it's not going to contain spatial data though, and even for point coverages it's rare to the the point coordinates in the table.

Dave,

   Yes, I have/had this; don't know if it's still on the hard drive ... yes,
it is. There's a SlackBuilds.org package for this and it's still installed.

For the spatial data you'll have to find a shape file or coverage.

   There is another sub-directory with shapefiles.

   This is all for an idea that I might pursue if there's time for it.

Many thanks,

Rich

Rich,

    I'm working on a page for my tutorial on "GRASS for Ecologists" called "Living with ESRI". Let me know how your project works out so I can benefit from your experience.

Dave

On 10/27/16 11:13, Rich Shepard wrote:

Dave,

  Yes, I have/had this; don't know if it's still on the hard drive ... yes,
it is. There's a SlackBuilds.org package for this and it's still installed.

For the spatial data you'll have to find a shape file or coverage.

  There is another sub-directory with shapefiles.

  This is all for an idea that I might pursue if there's time for it.

Many thanks,

Rich
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

--

On Thu, 27 Oct 2016, Dave Roberts wrote:

  I'm working on a page for my tutorial on "GRASS for Ecologists" called
"Living with ESRI". Let me know how your project works out so I can
benefit from your experience.

Dave,

   Okay.

Rich

On Thu, Oct 27, 2016 at 2:51 PM, Dave Roberts <droberts@montana.edu> wrote:

Rich,

   I'm working on a page for my tutorial on "GRASS for Ecologists" called
"Living with ESRI". Let me know how your project works out so I can benefit
from your experience.

Dave

Awesome, please share it here once you are finished, or even before.

Thank you,

Anna

On 10/27/16 11:13, Rich Shepard wrote:

Dave,

  Yes, I have/had this; don't know if it's still on the hard drive ...
yes,
it is. There's a SlackBuilds.org package for this and it's still
installed.

For the spatial data you'll have to find a shape file or coverage.

  There is another sub-directory with shapefiles.

  This is all for an idea that I might pursue if there's time for it.

Many thanks,

Rich
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

--
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user