[postgis-users] TopologyException in GEOS ST_Union function

TopologyException in GEOS ST_Union function I'm writting a function using the plpgsql language in PostgreSQL. This function operate with geometries and I do something like this: -- Open a cursor for a table OPEN veget_cursor FOR SELECT gid, wkb_geometry as the_geom FROM table_v

[postgis-users] select the interior parcels smaller than 25 hectares

Hi, I used this SQL for select the interior parcels and obtained all interior parcels on the map.. SELECT ST_InteriorRingN((the_geom),s) FROM datnivel3, generate_series(1,(SELECT max(ST_NumInteriorRing(the_geom)) FROM datnivel3)) s WHERE ST_NumInteriorRing(the_geom) > 0 AND ST_InteriorRingN(th

Re: [postgis-users] how obtain the interior parcels

he other conditions? Thanks , Francisco Salas - Original Message - From: "Havard Tveite" To: "fsalas" ; "PostGIS Users Discussion" Sent: Thursday, December 17, 2009 11:15 AM Subject: Re: [postgis-users] how obtain the interior parcels Dear Salas, Wha

Re: [postgis-users] how obtain the interior parcels

polygon or the given N is out of range. Fred. On Thu, Dec 10, 2009 at 7:35 PM, Fsalas wrote: Hi, I have a table parcels , and I need obtain the list of the only interior parcels, the parcels is not overlap. I test ST_Contains(), ST_Intersects() but the result is not c

[postgis-users] how obtain the interior parcels

Hi, I have a table parcels , and I need obtain the list of the only interior parcels, the parcels is not overlap. I test ST_Contains(), ST_Intersects() but the result is not correct. Salas. ___ postgis-users mailing list postgis-users@postgis.refractio

[postgis-users] restricción check

hi, when i try to insert record from parcelas table into prueba table, the are is error. ERROR: el nuevo registro para la relación «prueba» viola la restricción check «enforce_srid_the_geom» Estado SQL:23514 this is the syntaxis insert into prueba (SELECT gid,p.the_geom as the_geom from parc

Re: [postgis-users] about st_distance

parcela,tipo as tipo_Pozo FROM selepozo(1,1) po,parcelas p WHERE ST_DWithin(p.the_geom, po.the_geom, 1) http://postgis.refractions.net/documentation/manual-svn/ST_DWithin.html Hope that helps, Regina -Original Message- From: [EMAIL PROTECTED] on behalf of fsalas Sent: Fri 10/3/20

[postgis-users] about st_distance

Hi, I need to know about obtain distance between polygon( parcels) and point I Use the next sentences SELECT p.gid as id_parcela,tipo as tipo_Pozo FROM selepozo(1,1) po,parcelas p WHERE ST_distance(p.the_geom, po.the_geom) < 1 I have some questions This distance is between centroide of parc

Fw: [postgis-users] about point and multipoint

Thanks, Kevin Now being working very good Best Regards,Salas - Original Message - From: "Kevin Neufeld" <[EMAIL PROTECTED]> To: "fsalas" <[EMAIL PROTECTED]>; "PostGIS Users Discussion" Sent: Wednesday, August 27, 2008 1:09 PM Subject: Re:

[postgis-users] about point and multipoint

Hi, How I can obtain the X,Y coordinates in one Multipoint table. When I try to execute this select ST_X(geoloc), ST_Y(geoloc) from consultorios PostgreeSql/Postgis show the error ERROR: Argument to X() must be a point ERROR: Argument to X() must be a point Best Regards,Salas __

Re: [postgis-users] problem with OIDS

quot;geoloc from consejospopulares USING UNIQUE gid USING SRID=sridgoeshere" Or DATA "geoloc from consejospopulares USING UNIQUE gid" Hope that helps, Regina -Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of fsalas Sent:

Re: [postgis-users] problem with OIDS

END END END END Best Regards,Salas - Original Message - From: "David Fawcett" <[EMAIL PROTECTED]> To: "fsalas" <[EMAIL PROTECTED]>; "PostGIS Users Discussion" Cc: "Obe, Regina" <[EMAIL PROTECTED]> Sent: Tuesday, August

Re: [postgis-users] problem with OIDS

lab-2.2\htdocs\mapedit\preview.php on line 469 can you Tell me , How I can resolve this situation? Best Regards,Salas - Original Message - From: Obe, Regina To: fsalas ; PostGIS Users Discussion Sent: Tuesday, August 26, 2008 9:29 AM Subject: RE: [postgis-users] problem with OIDS

[postgis-users] problem with OIDS

Hi, in this moment I have problems with mapserver and postgis. This is the sentence create with shp2pgsql.exe why set the WITH (OIDS=FALSE)?; How I can change this to OIDS=TRUE CREATE TABLE areasalud ( gid serial NOT NULL, codasalud bigint, "version" bigint, descasalud character varyi

Re: [postgis-users] problem with postgree 8.3 and mapserver 2.2.8

pps/salud//mapfile///salud.map&gszCurrentState=BBOX=217200,284600,228100,295300|SRS=|MAPSIZE=600,450|LAYERS=0,1,2,3,4&map_session_mode=0&run_query=0&gszPHPMapScriptModName=php_mapscript_42.dll&gszQueryCoords= HTTP/1.1" 200 1250 bets regards salas - Original Message ----- F

[postgis-users] problem with postgree 8.3 and mapserver 2.2.8

Why? When i work with postgree 8.1 and postgis my projects mapserver is ok , but whhe i change to postgree 8.3 and postgis 1.3.3 I can't see my maps only a blank image bets regards salas ___ Dpto de Sistemas Informáticos Oficina Central Grupo Empresarial GEOCU

[postgis-users] error with PgRouting 1.02 on Win32

Bruce Thanks for his instruction, right now it works well Best regards Francisco salas ___ Dpto de Sistemas Informáticos Oficina Central Grupo Empresarial GEOCUBA Este mensaje esta libre de virus. Revisado por Kaspersky Antivirus

[postgis-users] error in sentence sql

Hi, in this moment i migrate my database to postgree 8.3 but my mapserver application don´t work, when i try to execute this sentence select X(the_geom), Y(the_geom) from consultorios, show the error. ERROR: Argument to X() must be a point ** Error ** ERROR: Argument to X() mu

[postgis-users] error with PgRouting 1.02 on Win32

Hi, why when i try to excecute ths sentece SELECT * FROM shortest_path('SELECT id, source, target,x1,y1,x2,y2,cost,reverse_cost from roads',26,39,true,true); appear this error I follow the instruction on tutorial PgRouting 1.02 on Win32 best regards Francisco Salas __