Tagged Questions
0
votes
1answer
195 views
Make POINT from longitude/latitude coordinates from existing table in PostGIS
I would like to make a POINT using the longitude and latitude columns of an existing table. Here's a link to the documentation of ST_MakePoint.
Here's my table:
CREATE TABLE sysinst.bio (
oid ...
1
vote
1answer
168 views
PostGIS Create Table with Geometry
I have written a query that will create a table and perform a GROUP BY from an existing spatial table, but the table does have the geometry. I am wondering where, and what, in this query I put to ...