I'm new to databases.
How can I use the PostGIS Geohash function to run through a column of coordinates and dump results in new column?
Here is the postgis documentation on it
Here's what my data looks like:
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
Since you don't share what you're trying to do, it's hard to know if the answer will be of any use to you.
WITH coords AS ( SELECT string_to_array(coord, ',') AS coords FROM mytable ) SELECT ST_GeoHash(ST_SetSRID(ST_MakePoint(coords, coords), 4326)) FROM coords;