Query failed: ERROR: Operation on two geometries with different SRID
I had to change the srid of the column from the UNKNOWN
indicator of -1
to 4326
. The answer at this StackOverflow post was very helpful in this. Also, the question in this SE GIS post was instrumental in helping me in the right direction.
Summarily: Running UPDATE table_name SET the_geom = ST_SetSRID(the_geom, 4326)
and UPDATE table_name SET the_geom = ST_Transform(the_geom, 4326)
did it.