Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

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

From this line:

SELECT ST_AsEWKT(geom) FROM buildings LIMIT 1;

I get this result:

"SRID=4326;MULTIPOLYGON(((404269.308014269 4543087.6184561,...)))"

I'm wondering if the coordinations are actually in the right format as SRID 4326?

Thank you.

EDIT ---- > The table was updated using this line:

SELECT UpdateGeometrySRID('buildings','geom',4326);
share|improve this question
Very strange. They certanly don't look like 4326. Projected 3857 maybe? – U2ros Dec 4 '12 at 11:50
Actually this table didn't have SRID at all, it was 0, so I Updated to 4326, but seems like it's not properly fixed. any suggestions? thank you – Kourosh Dec 4 '12 at 11:52
Hmm, if it didn't have SRID to begin with, im not sure what is the default projection? Maybe you should recreate the table and set srid explicitly! Then reimport the data. – U2ros Dec 4 '12 at 11:55
@Kourosh How did you update it to 4326? – R.K. Dec 4 '12 at 12:01
@Kourosh Got it. Btw, why did you decide to set it to 4326 btw? – R.K. Dec 4 '12 at 12:14

Acording to the following information found at, the response is no.


WGS84 Bounds: -180.0000, -90.0000, 180.0000, 90.0000

Projected Bounds: -180.0000, -90.0000, 180.0000, 90.0000

Scope: Horizontal component of 3D system. Used by the GPS satellite navigation system and for NATO military geodetic surveying.

Last Revised: 2007-08-27

Area: World

share|improve this answer
how could I reproject this geom column with proper SRID(e.g 4326) without having to reimport all over again? thanks – Kourosh Dec 4 '12 at 11:56
@Kourosh That's already answered… – R.K. Dec 4 '12 at 12:13

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.