id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc 5816,"Create consistent Layer creation options for geometry column name, spatial index and FID",jpalmer,Even Rouault,"Various OGR vector drivers provide the option to define the name of the geometry field/column when creating a layer. When scripting for multiple output formats at runtime this is an annoyance. GDAL should have one consistent layer creation option for this option across all drivers. It should also be possible to retain the older LCO values for compatibility reasons, but not advertise them in the documentation any more. Could be a good idea to address this before GDAL 2.0 is released :) Below is a list of the different LCO for each driver: ||'''Driver'''||'''Layer creation option'''|| ||MSSQLSpatial||GEOM_NAME|| ||PostgreSQL||GEOMETRY_NAME|| ||GPKG||GEOMETRY_COLUMN|| ||FileGDB||GEOMETRY_NAME|| ||MySQL||GEOMETRY_NAME|| ||SQLite|| - none - (GEOMETRY / WKT_GEOMETRY hardcoded)|| ||OCI||GEOMETRY_NAME|| ==> Use GEOMETRY_NAME Similar situation with FID column name: ||'''Driver'''||'''Layer creation option'''|| ||MSSQLSpatial|| -none - (ogr_fid hardcoded)|| ||PostgreSQL||FID|| ||GPKG||FID|| ||FileGDB||OID_NAME|| ||MySQL||MYSQL_FID|| ||SQLite|| - none - (OGC_FID hardcoded) -->TODO|| ||OCI|| - none, but use OCI_FID configuration option that default to OGR_FID|| ==> Use FID And a few minor issues with spatial index with the OCI driver using INDEX and the documentation being inconsistent across the drivers: ||'''Driver'''||'''Layer creation option'''||Documented|| ||MSSQLSpatial||SPATIAL_INDEX||Not documented|| ||PostgreSQL||SPATIAL_INDEX||OFF/ON|| ||GPKG||SPATIAL_INDEX||YES, NO|| ||MySQL||SPATIAL_INDEX||YES, NO|| ||SQLite||SPATIAL_INDEX||yes/no|| ||OCI||INDEX||OFF|| ",defect,closed,normal,2.0.0,default,unspecified,normal,fixed,,