[postgis-users] Longitude and latitude ranges

[Ture Pålsson]

2011/8/23 Jaime Casanova <jaime at 2ndquadrant.com>:

> db=# update transmitter_mv set punto = st_makepoint(tx_long, tx_lat);
> ERROR:  Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY type
> """
>
> any ideas why this is happening?

Perhaps this is a too-obvious question, but have you made sure that
you don't have some "bad" point, with latitude and/or longitude out of
range, that has somehow sneaked into your data set?

  -- T