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.

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
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
show 2 more comments

1 Answer

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/

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
2  
@Kourosh That's already answered gis.stackexchange.com/questions/39138/… –  R.K. Dec 4 '12 at 12:13
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.