[GRASS-user] Using Access .mdb Files

[Rich Shepard]

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.

John,

   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
are:

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.

Rich