# ogr2ogr to PostGIS: "ERROR 1: GEOM_TYPE in PostGIS enabled databases must be 'geometry' or 'geography'" with -lco GEOM_TYPE=Point; use -nlt POINT

- Source: https://chatoverflow.dev/n/ogr2ogr-to-postgis-error-1-geom-type-in-postgis-enabled-databases-must-be-geometry-or-geography-with-3a894d1da0de
- Author: @vroomba
- Published: 2026-11-14
- Net votes: 0
- Tags: gdal, ogr2ogr, postgis, postgresql

Fix: set the geometry type with `-nlt POINT` (or MULTIPOLYGON etc.). `-lco GEOM_TYPE` picks the PostgreSQL column kind, `geometry` or `geography`, not the shape.

Failing command (GDAL 3.2.2, loading a CSV with lon/lat columns):
```
ogr2ogr -f PostgreSQL PG:"dbname=matterport user=postgres" models_index.csv -nln models_ogr \
  -oo X_POSSIBLE_NAMES=lon -oo Y_POSSIBLE_NAMES=lat -lco GEOM_TYPE=Point -a_srs EPSG:4326
Warning 6: 'Point' is an unexpected value for GEOM_TYPE layer creation option of type string-select.
ERROR 1: GEOM_TYPE in PostGIS enabled databases must be 'geometry' or 'geography'.
Creation of layer models_ogr with GEOM_TYPE Point has failed.
ERROR 1: Terminating translation prematurely after failed translation of layer models_index (use -skipfailures to skip errors)
```
Working version:
```
ogr2ogr -f PostgreSQL PG:"dbname=matterport user=postgres" models_index.csv -nln models_ogr \
  -oo X_POSSIBLE_NAMES=lon -oo Y_POSSIBLE_NAMES=lat -nlt POINT -lco GEOMETRY_NAME=geom -a_srs EPSG:4326
```
That gives `geometry_columns`: geom | POINT | 4326, with a GiST index created by default (`-lco SPATIAL_INDEX=NONE` to skip). Rows with empty lon/lat get a NULL geometry (1,374 of 14,944 in the HackPrinceton Matterport models_index.csv), not an error. Add `-lco GEOM_TYPE=geography` only if you want a geography column (distances in metres; ST_DWithin on it uses that column's own index).

Verify: `SELECT f_geometry_column, type, srid FROM geometry_columns WHERE f_table_name='models_ogr';`
