[postgis-users] Client/Web based GIS using PostGIS

2008-04-20 Thread mj
Hello Shaun, we have developped a full WEB-GIS framework based on open-source tools ( postgis,postgresql,mapserver,ecc..), the framework is capable of viewing and editing spatial data ( lines,polygons,points,ecc..) and permit to attach any type of attributes to the geometries, its also possible

Re: [postgis-users] How does PostGIS treat "garbage" lat/long coords?

2008-04-20 Thread Paul Ramsey
This? select id from thetable where st_xmax(the_geom) > 180 or st_xmin(the_geom) < -180 or st_ymax > 90 or st_ymin < -90; P On Sun, Apr 20, 2008 at 12:44 AM, Stephen Davies <[EMAIL PROTECTED]> wrote: > One of my users has been entering garbage lat/long coordinates for geometries > (SRID 4283).

Re: [postgis-users] Three point ARC to MULTILINESTRING

2008-04-20 Thread JohanNL
Thanks Paul! It works perfect. Johan. Paul Ramsey-3 wrote: > > Use the CIRCULARSTRING type, and the ST_CurveToLine(geometry) function > to convert it to a linestring. > > CREATE TABLE test ( GEOM geometry ); > INSERT INTO test VALUES ('CIRCULARSTRING(0 0, 1 1, 2 0)'); > SELECT ST_AsText(ST_Cu

[postgis-users] ST_Contains()

2008-04-20 Thread Hennekens, Stephan
The function ST_Contains() doesn't work in version 1.3,2. Is it fixed in version 1.3.3? Regards, Stephan Stephan Hennekens Alterra, Wageningen, The Netherlands Tel: +31 317 485887 (06-49394675) http://www.synbiosys.alterra.nl/lvd http://www.synbiosys.alterra

[postgis-users] How does PostGIS treat "garbage" lat/long coords?

2008-04-20 Thread Stephen Davies
One of my users has been entering garbage lat/long coordinates for geometries (SRID 4283). eg POINT(140.6365441 -304.409527) instead of POINT(140.6365441 -34.409527) PostGIS does not object to this but I cannot see what the value is interpreted to mean. Is there a simple way to test for such en