.id
select * from tmp3; - here is what I needed..
Thanks Nicolas, Julien for your quick support.
Regards
Mehmet Erkek
www.REIDIN.com http://www.reidin.com/
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf
I have multipolygons which I would like to convert a single polygon. is
there a way to do this? please check the attached image. I tried st_dump
and afterwards st_union , but eventually I get a multipolygon again, not
polygon.
Mehmet Erkek
www.REIDIN.com http://www.reidin.com
://www.postgis.org/docs/ST_GeometryN.html
--Extracting all geometries (useful when you want to assign an id)
SELECT gid, n, ST_GeometryN(the_geom, n)
FROM sometable CROSS JOIN generate_series(1,100) n
WHERE n = ST_NumGeometries(the_geom);
best regards, julien
Le 26/04/2012 16:27, Mehmet Erkek a écrit :
I
as (
select (st_dump(geom)).geom
from my_table
) select st_union(geom) from t;
Nicolas
On 26 April 2012 17:22, Mehmet Erkek mer...@reidin.com wrote:
Hi Juilen, thanks for quick answer.
I have 1 geometry and 1 row on the table. this geometry is multiploygon which
consists of 4
Thanks Mark. I think you are right. Shp2pgsql did not change anything.
Please ignore my comment about it. We have found the problem. It looks
to be the simplification algorithm we use to display shapes in Google
maps. Sorry for keeping the list busy.
Regards
Mehmet Erkek
sharper boundaries and sometimes
overlaps with neighboring boundaries.
Is there way to make it produce outputs with more points and much
closer to original shapefile?
I appreciate any comment on this.
Thanks.
Mehmet Erkek
www.REIDIN.com http://www.reidin.com
September 2009 USE_STATS
I appreciate any help. Thank you.
---
Mehmet ERKEK
www.REIDIN.com http://www.reidin.com/
___
postgis-users mailing list
postgis-users
this?
---
Mehmet ERKEK
www.REIDIN.com http://www.reidin.com/
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of
Francis Markham
Sent: Monday, May 03, 2010 11:09 AM
To: PostGIS Users