[gdal-dev] Howto convert a CSV with geometry and a CVS without into
one Geodatabase (.mdb)?
sfkeller at gmail.com
Sun Mar 14 15:07:26 EDT 2010
I'm trying something new to me: I have two comma separated value files
(CSV, from an Excel user naturally :->) - one file having a lat and a
The target database is a Geodatabase (.mdb) which not only has a
feature class table (fctable) but also another 'normal' MS Access
table (without geometry). The columns of the CSV with la/lon goes to
the fctable and the other CSV goes to othertable.
One of the challenges here is that othertable can't be accessed
through PGeo driver AFAIK.
In addition - after inserting a row into the fctable with a new oid -
there should be a foreign key added to othertable which establishes a
relationship from othertable to fctable.
=> How do I shuffle these CSVs into this Geodatabase (preferrably with Python)?
=> Has anyone accomplished a similar conversion (using Python or other scripts)?
More information about the gdal-dev