2

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);
7
  • 1
    Very strange. They certanly don't look like 4326. Projected 3857 maybe?
    – U2ros
    Dec 4, 2012 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, 2012 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, 2012 at 11:55
  • 1
    @Kourosh How did you update it to 4326?
    – R.K.
    Dec 4, 2012 at 12:01
  • 1
    @Kourosh Got it. Btw, why did you decide to set it to 4326 btw?
    – R.K.
    Dec 4, 2012 at 12:14

1 Answer 1

4

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

EPSG:4326

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

http://spatialreference.org/ref/epsg/4326/

2

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.