A S57 file with only 6 feature object classes? Normally there should be
many more.
I would add triggers to each table in the database for timestamps.
Potential workflow:
1 ogr for initial import into own schema
2 Postgre script, reading all tables in the schema using the
information_schema info, to truncate and add triggers
3 ogr for final import
Even,
Appreciate the response.
Your example is interesting but there are a couple of issues.
Importing a random .000 file using ogr2ogr yields 6 tables in the
database. Which tables are created depend on the data and are unknown
to me prior to import, so it is difficult to generate the SQL in
advance. This approach does not scale very well if data yields a
number of tables.
Another issue was when adding the SQL statement for one specific table
caused the import to ignore the other 5 tables. Is this the expect
result or should all 6 table be imported?
Regards, Lars
------------------------------------------------------------------------
*Fra:* Even Rouault <[email protected]>
*Sendt:* fredag 22. juni 2018 23.15
*Til:* [email protected]
*Kopi:* Lars
*Emne:* Re: [gdal-dev] ogr2ogr adding metadata
On vendredi 22 juin 2018 09:41:02 CEST Lars wrote:
> Hello folks,
>
> Using ogr2ogr (version 2.2.3) to import s57 into PostgreSQL which works
> great.
>
> What is the recommended approach for adding metadata to all inserted
data?
>
> Say I wanted to add current date to all inserted data. Does ogr2ogr
support
> such operation? Tried using the "-mo" argument but it did not make any
> inpact (same result with argument as without). Ideally I do not want the
> client to be adding this information as a post insert operation (if even
> possible).
Lars,
-mo will work only with very few target drivers (I can only think to
GeoPackage actually). This is per-layer/per-table metadata. There's
perhaps
the equivalent in PostgreSQL but this isn't implemented by GDAL
But you can add a column with the current timestamp for example with
ogr2ogr -update PG:xxxxxx poly.shp \
-sql "SELECT *, CURRENT_TIMESTAMP FROM poly" -dialect SQLITE
Even
--
Spatialys - Geospatial professional services
http://www.spatialys.com
_______________________________________________
gdal-dev mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/gdal-dev
--
Hälsningar
Andreas Oxenstierna
T-Kartor Geospatial AB
mobile: +46 733 206831
mailto: [email protected]
http://www.t-kartor.com
_______________________________________________
gdal-dev mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/gdal-dev
