Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
  • 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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.