Skip to main content
Geographic Information Systems

Return to Question

Tweeted twitter.com/StackGIS/status/1173839084931997696
added 356 characters in body
Source Link
Nic Pickers
Nic Pickers
  • 97
  • 6

I want to create a table that contains 3D data. I I currently have 2D data stored as EWKT, which is multipoint geometry in a geomone column, and another tablecolumn that has elevation datafrom sea level in another column. Is there a way that I can combine these two columns and output a single column with 3D data?

Example:

Geom column ("010400000001000000010100000000001038011323410000E9631AFC5641")

Elevation column ("1346.9495")

My goal is to combine the Geom column with the Elevation column, to create a 3D geometry column.

My thought is to possibly use subquerries, but I don't know how.

I am using pgAdmin 4.

I want to create a table that contains 3D data. I currently have 2D data stored in a geom column, and another table that has elevation data. Is there a way that I can combine these two columns and output a single column with 3D data?

I am using pgAdmin 4.

I want to create a table that contains 3D data. I currently have 2D data stored as EWKT, which is multipoint geometry in one column, and another column that has elevation from sea level in another column. Is there a way that I can combine these two columns and output a single column with 3D data?

Example:

Geom column ("010400000001000000010100000000001038011323410000E9631AFC5641")

Elevation column ("1346.9495")

My goal is to combine the Geom column with the Elevation column, to create a 3D geometry column.

My thought is to possibly use subquerries, but I don't know how.

I am using pgAdmin 4.

deleted 6 characters in body; edited tags; edited title
Source Link
PolyGeo ♦
PolyGeo ♦
  • 65.4k
  • 29
  • 114
  • 345

How to create Creating 3D geometry column by combining an existing 2D geometry column with an "elevation" column?

I want to create a table that contains 3D data. I currently have 2D data stored in a geom column, and another table that has elevation data. Is there a way that I can combine these two columns and output a single column with 3D data?

I am using pgAdmin 4 Thanks.

How to create 3D geometry column by combining an existing 2D geometry column with an "elevation" column

I want to create a table that contains 3D data. I currently have 2D data stored in a geom column, and another table that has elevation data. Is there a way that I can combine these two columns and output a single column with 3D data?

I am using pgAdmin 4 Thanks

Creating 3D geometry column by combining existing 2D geometry column with "elevation" column?

I want to create a table that contains 3D data. I currently have 2D data stored in a geom column, and another table that has elevation data. Is there a way that I can combine these two columns and output a single column with 3D data?

I am using pgAdmin 4.

Source Link
Nic Pickers
Nic Pickers
  • 97
  • 6

How to create 3D geometry column by combining an existing 2D geometry column with an "elevation" column

I want to create a table that contains 3D data. I currently have 2D data stored in a geom column, and another table that has elevation data. Is there a way that I can combine these two columns and output a single column with 3D data?

I am using pgAdmin 4 Thanks