[gdal-dev] Howto convert a CSV with geometry and a CVS without into one Geodatabase (.mdb)?

Frank Warmerdam warmerdam at pobox.com
Sun Mar 14 15:18:25 EDT 2010


Stefan Keller wrote:
> Dear all
> 
> 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
> lon column.
> 
> 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)?

Stefan,

The OGR PGeo and ODBC drivers are read-only.  If you want to update
a geodatabase you will need to find another route, or just route
low level SQL through the ODBC driver using ExecuteSQL().

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent



More information about the gdal-dev mailing list