I'm kind of new on PostGIS. I have the coordinates (UTM) in a table, and I need to update the geometry field based on that coordinates.
The SRID in the table is 32717. I tried this sentence
UPDATE public.uems SET coordenada_uem=ST_Multi(ST_SetSRID ((ST_MakePoint(172332.96000 , 68435.29000)), 32717)) WHERE gid=78;`
And the result is this when I've tried to see the geometry
The updated point is really far away from the real ubication, and even the country (Ecuador).
How can I fix that?
::geography) before it will display over a basemap like you might be expecting.
st_transform- so you enter the lon/lat coordinates directly into your SQL