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....@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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users