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?

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

SELECT UpdateGeometrySRID('buildings','geom',4326);
  • 1
    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
  • 1
    @Kourosh How did you update it to 4326? – R.K. Dec 4 '12 at 12:01
  • 1
    @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 spatialreference.org, 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



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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