Column name: "geom" vs. "geometry"

[erikamariano]

Expected Behavior

Check any layer in database, the column name for the geometry type has to be the same for all tables: "geom". This should happen for all kinds of files: GeoJSON, Shapefile, etc.

Actual Behavior

• When adding GeoJSON files to Geonode, the geometry column name is "geometry".
• When adding Shapefiles or Geopackages, the geometry column name is "geom".

Steps to Reproduce the Problem

1. Add a GeoJSON file by the user interface
2. Check the table of this layer in the database
3. The column name will be "geometry"
4. Compare it to a layer that was created with a Shapefile or Geopackage

Specifications

• GeoNode version: 4.1.3
• Installation type (vanilla, geonode-project): Vanilla
• Installation method (manual, docker): Docker
• Platform: CentOS and Ubuntu

[mattiagiupponi]

@erikamariano i was checking the code, and for shapefiles, the column name should be converted in geometry since is passed as parameter. Anyway there are a couple of handlers that not define the colum in the ogr2ogr command so is ogr to decide the column name. we can make it equal for all the handlers