[postgis-users] attempt to deserialize a point which is really aInvalid type

[Willy-Bas Loos]

Hi, in a late reaction,

I ran into the same error when I tried to measure distance_sphere
between polygons. It only does points.
In PostGIS 1.3.3 I got the much clearer message: "ERROR:
lwpoint_deserialize: attempt to deserialize a point which is really a
Polygon"
Possibly, "a Invalid type" is to be interpreted as a GeometryType kind
of type. (and "location" in the example code is not a Point)

Cheers,

WBL

On Thu, Jun 5, 2008 at 12:55 PM, Obe, Regina <robe.dnd at cityofboston.gov> wrote:
> Adding SRID makes it an invalid geometry so the text will not be
> automatically cast to a geometry.  Your point doesn't look like 3395
> point anyway
>
>  SELECT name, distance_spheroid(location, 'POINT(-3.6620213
> 40.4475235)', 'SPHEROID["WGS 84",6378137,298.257223563]')  as distance
> FROM ways
>
> Also note if your point was actually in 3395 projection you'll get very
> laughable results with distance_spheriod because distance_spheriod/shpe*
> always assumes degrees regardless of what the srid of your data says it
> is.
>
> Hope that helps,
> Regina
>

>> receive an error :
>>
>> ERROR: lwpoint_deserialize: attempt to deserialize a point which is
>> really a Invalid type
>> Estado SQL:XX000
-- 
"Patriotism is the conviction that your country is superior to all
others because you were born in it." -- George Bernard Shaw