[GRASS-user] Using Access .mdb Files
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
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