[GRASS-user] Using Access .mdb Files

Rich Shepard rshepard at appl-ecosys.com
Tue Jan 11 16:54:53 EST 2011

On Tue, 11 Jan 2011, John C. Tull wrote:

> Did it preserve spatial topology for you? I was able to successfully
> convert an mdb to sqlite, but it does not have any geographic reference.
> This is fine for extracting data tables, but seems to sacrifice the value
> of a spatial database, unless there are fields representing coordinates
> for each table row.


   I've no idea. I'm only unzipping BLM data files now. I assume that Access
has no topology as it's a flatfile database that could be used as a front
end to SQL-Server.

   The file I have is for land status (i.e., ownership) and the SQLite tables

sqlite> .tab
GDB_AnnoSymbols        GDB_GeomColumns        GDB_ReplicasEx 
GDB_AttrRules          GDB_JnConnRules        GDB_SpatialRefs 
GDB_CodedDomains       GDB_ObjectClasses      GDB_Subtypes 
GDB_DefaultValues      GDB_RangeDomains       GDB_Toolboxes 
GDB_Domains            GDB_RasterCatalogs     GDB_TopoClasses 
GDB_EdgeConnRules      GDB_RelClasses         GDB_TopoRules 
GDB_ExtensionDatasets  GDB_RelRules           GDB_Topologies 
GDB_Extensions         GDB_ReleaseInfo        GDB_UserMetadata 
GDB_FeatureClasses     GDB_ReplicaDatasets    GDB_ValidRules 
GDB_FeatureDataset     GDB_ReplicaLog         Ownership 
GDB_FieldInfo          GDB_Replicas           Ownership_Shape_Index

   I've no idea what the GDB_ prefix is supposed to mean. The Bureau
apparently does not have these data on their ESRI GIS or we'd see .shp or
.e00 files rather than .mdb files.


More information about the grass-user mailing list