Re: [postgis-users] Is it worth to load background raster into postgis?

2013-02-08 Thread Paolo Cavallini
Il 08/02/2013 20:27, Pietro Rossin ha scritto: > We don't have a WMS server yet, any suggestion for a "not too difficult to > configure" > solution? OT here, but cetainly the easiest is aptitude install qgis-mapserver All the best. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact deta

Re: [postgis-users] Is it worth to load background raster into postgis?

2013-02-08 Thread Pietro Rossin
We don't have a WMS server yet, any suggestion for a "not too difficult to configure" solution? p 2013/2/8 Paolo Cavallini [via PostGIS] > Il 08/02/2013 14:19, Pietro Rossin ha scritto: > > Hi > > Thanks Paolo > > How can I store my images to be served as WMS? > > any format that can by read by

Re: [postgis-users] Is it worth to load background raster into postgis?

2013-02-08 Thread Paolo Cavallini
Il 08/02/2013 14:19, Pietro Rossin ha scritto: > Hi > Thanks Paolo > How can I store my images to be served as WMS? any format that can by read by your WMS server; most probably gdalinfo --formats > > > I don't know if these performances could be the same with raster... > I mean, if I load the ecw

Re: [postgis-users] rtpostgis.sql

2013-02-08 Thread dustymugs
rtpostgis.sql is still present. You'll want to check with the rpm packager. -bborie On 02/08/2013 08:09 AM, Gold, Jack L (US SSA) wrote: > I recently changed my installation process and allowed one of my company > admins to install postgis 2.0 with the RHEL 5.9 installation, but I noticed > w

[postgis-users] rtpostgis.sql

2013-02-08 Thread Gold, Jack L (US SSA)
I recently changed my installation process and allowed one of my company admins to install postgis 2.0 with the RHEL 5.9 installation, but I noticed when he finished that the rtpostgis.sql file was no longer in the installation. Has rtpostgis.sql been removed? Is it not part of the rpm? [cid:i

[postgis-users] Calculating the maximum minimal distance between two points

2013-02-08 Thread Carsten Hogertz
Hi, I've got two point layer. I want to identify the maximum distance of the nearest neighbour point. How could it be possible? Thank for every help. Carsten ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/ma

Re: [postgis-users] How to update (replace) a Postgis table?

2013-02-08 Thread Stephen Woodbridge
On 2/8/2013 1:34 AM, Stefan Schwarzer wrote: Hi there, I would like to "update" a "countries of the world"-postgis-table, by replacing it with another one which comes in form of a shapefile (dumped from a Postgis database) from my development server. Now, I can't just do a "pgsql2shp", as this

Re: [postgis-users] Is it worth to load background raster into postgis?

2013-02-08 Thread Pietro Rossin
Hi Thanks Paolo How can I store my images to be served as WMS? @Pierre The advantages are a lot considering our situation. At first, all our base offical regional data are in dxf format, crazy but true.. These are 983 dxf that I converted into three postgis tables, 3D polylines, block and text pla

Re: [postgis-users] How to update (replace) a Postgis table?

2013-02-08 Thread Paolo Crosato
Il 08/02/2013 07:34, Stefan Schwarzer ha scritto: Hi there, I would like to "update" a "countries of the world"-postgis-table, by replacing it with another one which comes in form of a shapefile (dumped from a Postgis database) from my development server. Now, I can't just do a "pgsql2shp",

Re: [postgis-users] How to update (replace) a Postgis table?

2013-02-08 Thread Francois Hugues
Hello, I think the reason why your renaming does not work comes from your index. If you want to use the renaming strategy you may have two strategies : - use alter index after altertable to rename - import with shp2pgsql without -I option and create the index on the new populated table with a dif

Re: [postgis-users] How to update (replace) a Postgis table?

2013-02-08 Thread Paolo Corti
On Fri, Feb 8, 2013 at 7:34 AM, Stefan Schwarzer wrote: > Hi there, > > I would like to "update" a "countries of the world"-postgis-table, by > replacing it with another one which comes in form of a shapefile (dumped > from a Postgis database) from my development server. > > Now, I can't just do a