Tag: I would like to get a PostGIS point table from a PostGreSQL table containing OpenDataKit data where the coordinates are contained into in a c

Create point geometry in PostGIS from a X Y Z M coordinate format

Post author By Technical Analysis
Post date November 27, 2020
No Comments on Create point geometry in PostGIS from a X Y Z M coordinate format

I would like to get a PostGIS point table from a PostGreSQL table containing OpenDataKit data where the coordinates are contained into in a column in a X Y Z M format (M being I think the value of the GPS precision in meters). E.g: 10.384643333333335 -23.214940000000002 -0.8 5.0 My first question is: what should […]

Tags ..., 'column2', column=1, I would like to get a PostGIS point table from a PostGreSQL table containing OpenDataKit data where the coordinates are contained into in a c

Ask Geographic Information System (GIS)

Create point geometry in PostGIS from a X Y Z M coordinate format

Post author By Technical Analysis
Post date November 26, 2020
No Comments on Create point geometry in PostGIS from a X Y Z M coordinate format

Tags ..., 'column2', column=1, I would like to get a PostGIS point table from a PostGreSQL table containing OpenDataKit data where the coordinates are contained into in a c

Ask Geographic Information System (GIS)

Create point geometry in PostGIS from a X Y Z M coordinate format

Post author By Technical Analysis
Post date November 26, 2020
No Comments on Create point geometry in PostGIS from a X Y Z M coordinate format

Tags ..., 'column2', ) but I got this error message: ERROR: parse error - invalid geometry Any clue?, column=1, I would like to get a PostGIS point table from a PostGreSQL table containing OpenDataKit data where the coordinates are contained into in a c, ST_MakePoint(coordinates_column) as geom FROM schema.postgresql_odk_table as ST_MakePoint seems to be the one able to retrieve X Y Z M data