RESOLVED Re : [postgis-users] why a longitude like 180 are not valid in WGS84 in postgis ?

[Norbert]

;-) I'a really beginner !

yes ok, my problem was the use of conversion fonction GeometryFromText()

We have to explicitly set the srid, even if the postgis/database column is already specified with a specific srid.

example :

GeometryFromText('POINT(long lat)') or  GeometryFromText('POINT(long lat)', -1) will not work
GeometryFromText('POINT(long lat)', 4326) work.

==> GeometryFromText() it's not a contextual function !

(and GeometryFromText('POINT(-54 158)', 4326) work too ! but lot of thanks Guido)

----- Message d'origine ----
De : Guido Lemoine <guido.lemoine at jrc.it>
À : PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Envoyé le : Vendredi, 17 Novembre 2006, 11h26mn 22s
Objet : Re: [postgis-users] why a longitude like 180 are not valid in WGS84 in postgis ?

try POINT (158.93 -54.51)

Notation is in X Y = LON LAT! 158.93 is far beyond the North Pole :-)

GL

Norbert wrote:

>Hi all,
>
>Can you explain to me why a point like POINT(-54.51 158.93) is not valid in wgs84 / srid 4326 in PostGIS and make a conflict "enforce_srid_coordinates" ?
>
>What's the error and solution ?
>
>thanks in advance,
>
>Norbert
>
>
>
>
>    
>
>    
>        
>___________________________________________________________________________ 
>Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! 
>Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses 
>http://fr.answers.yahoo.com
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>  
>

-- 

----------------------------------------------------------------
Joint Research Centre, European Commission
Institute for the Protection and Security of the Citizen (IPSC)
Unit: Support to External Security
Via E. Fermi, 1 TP 267 Ispra 21020 (VA), Italy
Tel. +39 0332 786239 (direct line) Fax. +39 0332 785154
WWW: http://ses.jrc.it
----------------------------------------------------------------
Disclaimer:
Views expressed are those of the individual and do not represent the
views of the European Commission


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users





	

	
		
___________________________________________________________________________ 
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! 
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses 
http://fr.answers.yahoo.com