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

[Even Rouault]

On mercredi 15 avril 2020 11:56:58 CEST Andrea Aime wrote:
> On Wed, Apr 15, 2020 at 11:36 AM Even Rouault <even.rouault at spatialys.com>
> 
> wrote:
> > > http://www.geopackage.org/spec/
> > 
> > My understanding of table 27 is that it is just to define constraints on
> > the values of a column, but not a way to establish a integer<-->string
> > mapping as you'd like. Unless I'm missing something. Of course you could
> > create an auxiliary table with the mapping, but I'm not aware of a
> > standardized way of registering it.
> 
> I had the idea because Table 27 lists enum values (in the "value" column)
> as 1, 2, 3, and while not providing an example of it,
> gpkg_data_column_constraints
> also has a "description" column. so my current guess is that one could use
> integer numbers in "value", and provide the name of the value in
> "description".

Oh I missed that. Table 25 indeed mentions "For ranges and globs, describes the constraint; 
for enums, describes the enum value.", so yes your idea could be workable.

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20200415/5ccc1d4b/attachment-0001.html>