[gdal-dev] Does OGR support GeoPackage enums in write mode (or at all?)

[Even Rouault]

Hi,

as as follow-up, the mentioned below capacity is now in GDAL master per 
https://github.com/OSGeo/gdal/pull/3638

This is implemented curretly for FileGeodatabase (reading-only, could be 
extended on the write side in the FileGDB) and GeoPackage (read/write).

I guess this could be extended to PostgreSQL too by storing the enums in 
an auxiliary table linked through a foreign key.

Even

Le 15/04/2020 à 11:05, Andrea Aime a écrit :
> Hi,
> I'm trying to dump a large PostGIS database into a GeoPackage. In the 
> original database some columns
> are strings, but could be more efficiently represented as enums, as 
> they have a small set of values.
>
> GeoPackage has a native notion of enums, check the spec and search for 
> "table 27" for an example:
> http://www.geopackage.org/spec/ <http://www.geopackage.org/spec/>
>
> However I cannot find mention of them in the GPKG driver documentation:
> https://gdal.org/drivers/vector/gpkg.html 
> <https://gdal.org/drivers/vector/gpkg.html>
> I quickly grepped into the geopackage sources for "enum", could not 
> find it in the geopackage sources.
>
> Also looked at the "mapFieldType" ogr2ogr parameter and at OGR SQL, 
> did not find anything there either.
>
> So I'm wondering, is there direct support for enum fields? Any way to 
> map a string column to enum during
> a ogr2ogr call?
>
> Best Regards,
>
> Andrea Aime== GeoServer Professional Services from the experts! Visit 
> http://goo.gl/it488V <http://goo.gl/it488V> for more information. == 
> Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di 
> Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 
> 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it 
> <http://www.geo-solutions.it> http://twitter.com/geosolutions_it 
> <http://twitter.com/geosolutions_it> 
> ------------------------------------------------------- /Con 
> riferimento alla normativa sul trattamento dei dati personali (Reg. UE 
> 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si 
> precisa che ogni circostanza inerente alla presente email (il suo 
> contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è 
> riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il 
> messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra 
> operazione è illecita. Le sarei comunque grato se potesse darmene 
> notizia. This email is intended only for the person or entity to which 
> it is addressed and may contain information that is privileged, 
> confidential or otherwise protected from disclosure. We remind that - 
> as provided by European Regulation 2016/679 “GDPR” - copying, 
> dissemination or use of this e-mail or the information herein by 
> anyone other than the intended recipient is prohibited. If you have 
> received this email by mistake, please notify us immediately by 
> telephone or e-mail./
>
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
http://www.spatialys.com
My software is free, but my time generally not.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20210406/66e03069/attachment.html>