Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top
  • SELECT ST_SRID(geom) AS s FROM zones GROUP BY s;
    returns a single record: 4326

  • SELECT Find_SRID('public', 'zones', 'geom');
    returns 4326

  • SELECT AsText(geom) FROM zones
    returns geometry like:

MULTIPOLYGON(((495468.88595 5464400.7263,495468.89 5464401.38005,...)))

Shouldn't my geometry been standard lat-lngs? Something like:

MULTIPOLYGON(((-122.968967906831 49.31253667013,-122.970356138605 49.3125609975662...)))

I tried executing both of these queries, but neither worked:

SELECT UpdateGeometrySRID('zones','geom',4326);
UPDATE zones SET geom = ST_Transform(geom);

How can I transform the geometry into my desired format?

share|improve this question
up vote 1 down vote accepted

You assigned the wrong id on load. Looks like you have a UTM projection.

Now need to transform to right geometry.

UPDATE zones
SET geom = st_transform( st_setsrid( geom, 31997 ), 4326 )
share|improve this answer
It was in EPSG:26910. Thanks! – Jordan Arseno May 18 '13 at 2:23

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.