[postgis-users] PGFouine for windows

2009-01-15 Thread P Adji
how do i use PGFouine on windows ? where can i download the PGFouine installer ? _ What can you do with the new Windows Live? Find out http://www.microsoft.com/windows/windowslive/default.aspx__

RE: [postgis-users] postgre tmp_tablespace

2009-01-15 Thread P Adji
sorry my mistake, it should be temp_tablespaces. I use PG 8.3.0-1> Date: Thu, 15 Jan 2009 09:00:09 -0800> From: kneuf...@refractions.net> To: postgis-users@postgis.refractions.net> Subject: Re: [postgis-users] postgre tmp_tablespace> > What version of PostgreSQL are you using? I don't see that

RE: [postgis-users] PostGIS Solaris 10 compile issue - detectingiconv versions [SEC=UNCLASSIFIED]

2009-01-15 Thread Roppola, Antti - BRS
Hi Mark, That got me far enough back into more familiar territory and hack a solution. Adding CPPFLAGS and LDFLAGS got me an error where ld couldn't fine -liconv. Here's an excerpt from configure output: checking for iconv_open in -liconv... yes ... checking iconv.h usability... yes checking ico

Re: [postgis-users] Mapinfo

2009-01-15 Thread Simon Greener
The current list of desired MapInfo functionality maintained on the Google MapInfo-L Group includes support for PostGIS: http://groups.google.com/group/mapinfo-l/web/mapinfo-pro-feature-requests regards Simon On Fri, 16 Jan 2009 09:57:20 +1100, Paragon Corporation wrote: > > I don't think MapI

RE: [postgis-users] Mapinfo

2009-01-15 Thread Paragon Corporation
I don't think MapInfo supports PostGIS. However for working with MapInfo I usually use OGR2OGR which can dump PostGIS data into mapinfo tables with a single command line statement. Hope that helps, Regina -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:

[postgis-users] Mapinfo

2009-01-15 Thread Stephen Carville
Are Mapinfo and PostGIS compatible? I've seen a few messages on MapInfo-L that sorta imply they work together. Maybe. But there is no support mentioned on the MapInfo website. -- Stephen Carville Systems Engineer Land America 1.626.667.1450 X1326 ===

RE: [postgis-users] Re: st_union exception

2009-01-15 Thread Obe, Regina
Forgot to mention 1.3.5 is the latest PostGIS stable. So in summary GEOS 3.0.3, PostGIS 1.3.5 Though you should be fine with just upgrading your GEOS. -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf

Re: [postgis-users] Re: st_union exception

2009-01-15 Thread Martin Davis
I have to confess I'm not sure what the best or most current version is - perhaps the list can help out? Mark Mitchell wrote: It is an older version of PostGIS/GEOS (1.3.3 and 2.2.3) -- which version of GEOS are you using? -Mark Is this an older version of PostGIS/GEOS? I believe that mo

RE: [postgis-users] Re: st_union exception

2009-01-15 Thread Obe, Regina
3.0.3 is the latest stable -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Mark Mitchell Sent: Thursday, January 15, 2009 2:38 PM To: postgis-users@postgis.refractions.net Subject: [postgis-users] R

[postgis-users] Re: st_union exception

2009-01-15 Thread Mark Mitchell
It is an older version of PostGIS/GEOS (1.3.3 and 2.2.3) -- which version of GEOS are you using? -Mark > Is this an older version of PostGIS/GEOS? I believe that most of these > kinds of problems were addressed in a release of GEOS last year. > > Mark Mitchell wrote: > > Anyone get an error simi

Re: [postgis-users] st_union exception

2009-01-15 Thread Martin Davis
Is this an older version of PostGIS/GEOS? I believe that most of these kinds of problems were addressed in a release of GEOS last year. Mark Mitchell wrote: Anyone get an error similar to this when unioning a bunch of polygons with st_union? NOTICE: TopologyException: no outgoing dirEdge fou

[postgis-users] st_union exception

2009-01-15 Thread Mark Mitchell
Anyone get an error similar to this when unioning a bunch of polygons with st_union? NOTICE: TopologyException: no outgoing dirEdge found (-149.073,61.6101,61.6101) ERROR: GEOS union() threw an error! I must say before I get into the details only a few of you will read that portion that I've us

Re: [postgis-users] postgre tmp_tablespace

2009-01-15 Thread Kevin Neufeld
What version of PostgreSQL are you using? I don't see that variable in 8.3. postgis=# show tmp_tablespace; ERROR: unrecognized configuration parameter "tmp_tablespace" I would imagine it's the directory location for temporary files. According to the 8.3 docs: "Temporary files (for operations

Re: [postgis-users] Midd point for a segments

2009-01-15 Thread Kevin Neufeld
Since your multigeometry only contains a single linestring, use st_geometryn() to extract the linestring. Putting your geometry in a temp table: SELECT ST_X(mid_pt) AS long, ST_Y(mid_pt) AS lat FROM ( SELECT ST_Line_Interpolate_Point( ST_GeometryN(the_geom, 1), 0.5 ) AS mid_pt

Re: [postgis-users] PostGIS Solaris 10 compile issue - detecting iconv versions [SEC=UNCLASSIFIED]

2009-01-15 Thread Mark Cave-Ayland
Roppola, Antti - BRS wrote: Hi all, I have a Solaris 10 build of PostGIS, but so far I've had to disable unicode support (--without-unicode). The issue seems pretty close to the one described in this mapserver ticket, http://trac.osgeo.org/mapserver/ticket/1017 That is, my build seems to

Re: [postgis-users] newbie: Error in first atttempt to use postgis with mapserver?

2009-01-15 Thread Mark Cave-Ayland
Nicolas Ribot wrote: Hi MapServer is looking for the hidden OID column, that does not exist anymore in recent postgresql versions (tables are now created without oid by default. I do find it really frustrating that Mapserver still defaults to looking for the oid column. The practice of using

Re: [postgis-users] restricción check

2009-01-15 Thread Nicolas Ribot
> 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_g

Re: [postgis-users] Encoding issue in PostGIS/PostgreSQL

2009-01-15 Thread Lê Viết Thanh
Thanks Paul On Sun, Jan 11, 2009 at 6:21 AM, Paul Ramsey wrote: > Isn't this an encoding issue with PgAdmin? shp2pgsql writes out a UTF8 text > file. If you load that UTF8 text file into PgAdmin, and it thinks > (hypothetically) that all text files is loads are in your local encoding, > then the