Im importing a xlsx with x y coordinates to a postgis database, with the following command:
ogr2ogr -overwrite -progress -nln data -nlt POINT -f PostgreSQL "PG:host=Localhost user=postgres password=Postgres dbname=database" -nln data C:\data\data.XLSX
It successfully add the data to my database. With some sql included in the command i will now like to take the x y columns and update the (empty) geometry column, so that the x y data is converted to geometry.
I tried to add:
-sql "SELECT AddGeometryColumn ('database', 'data', 'geom', 26913, 'POINT', 2)" -dialect sqlite
Just to try to add / define some geometry to my table.
Any suggestion on where to look or what to do?