search

kokoalberti / postgis-baselayers

Web application to download and import popular vector datasets (Natural Earth, GADM, Geonames, etc) into a PostGIS database with the click of a button.
MIT License
43 stars 9 forks source link

Use `geom` as column name for geometry columns #15

Closed kokoalberti closed 5 years ago

kokoalberti commented 5 years ago

Better to use geom where possible instead of mixing things like location, the_geom, wkb_geometry etc.

kokoalberti commented 5 years ago

Where possible, all datasets now use geom as a column name for their geometries.

The geometry column name is often not defined as such in the download of a dataset and left upto the enduser when using an import tool such as ogr2ogr. Also, sometimes only lat/lon columns are defined, and we need to make a geom column from these ourselves.