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
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user

Reply via email to