geonode icon indicating copy to clipboard operation
geonode copied to clipboard

Column name: "geom" vs. "geometry"

Open erikamariano opened this issue 9 months ago • 1 comments

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

erikamariano avatar Apr 30 '24 19:04 erikamariano