Re: [postgis-users] "service" field in postgres

Hi, The service field allows to tie a connection to a service name instead of to a fixed hostname/port connection. If you want to move around QGIS projects between different machines (sometimes the database is on local host, sometimes it is in production environment on a dedicated db server), it i

[postgis-users] Rasteroutput of a complex query to a file

lipped_raster; How can I output this to a tiff-file in the filesystem? I tried with psql -d uster -U an -t -c "query as above" >test.tif but when I open test.tif it tells me that there is no valid tiff-header. Any idea how can export the result of my query? Thanks, Andreas -- --

Re: [postgis-users] Display of Postgis Raster with Pyramids

ok - so the Postgis Raster plugin should do it? Unfortunately it is currently broken with current QGIS trunk and Postgis trunk ;-( Thanks anyway, Andreas On Fri, 20 Jan 2012 14:09:52 +, Mateusz Loskot wrote: On 20 January 2012 14:02, Andreas Neumann wrote: I learned how to import

[postgis-users] Display of Postgis Raster with Pyramids

-file). Thanks if you have any hints for better usage of the overview/pyramid tables. Andreas -- -- Andreas Neumann Böschacherstrasse 10A 8624 Grüt (Gossau ZH) Switzerland ___ postgis-users mailing list postgis-users@postgis.refractions.net

Re: [postgis-users] postgis removed from latest postgres' stack builder?

s-users [3] mailto:dmontenegr...@gmail.com -- -- Andreas Neumann Böschacherstrasse 10A 8624 Grüt (Gossau ZH) Switzerland ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS to Web Map?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 well - if you already have a QGIS project, I would try QGIS server first. You need a recent QGIS though. If you go to the project properties, the last tab is for WMS settings. Be sure to narrow down the CRS to those you really need. Along with QGIS se

Re: [postgis-users] PostGIS to Web Map?

___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- -- Andreas Neumann Böschacherstrasse 10A 8624 Grüt (Gossau ZH) Switzerland ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] ST_OffsetCurve

EUR each). ok - that is reasonable. We can pay for that - no need to split it up. Let's get in contact off-list. I hope that someone else can pay for the single-sided buffer to be available in Postgis? Any takers? Andreas -- Andreas Neumann Böschacherstrasse 10A 862

Re: [postgis-users] ST_OffsetCurve

example trough http://pledgebank.com or similar. --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/ma

Re: [postgis-users] QGIS - PostGIS - ArcGIS Interaction

11 16:08:04 +0200, Paolo Cavallini wrote: Il giorno gio, 16/06/2011 alle 14.39 +0200, Andreas Neumann ha scritto: Thanks for the explanation. ArcGIS is still more powerful than QGIS, Are you *really* sure? http://donmeltz.com/blog/index.php/2011/06/10/arcgisqgis-faceoff/ I'd be interested

Re: [postgis-users] QGIS - PostGIS - ArcGIS Interaction

ep using ArcGIS for the time being. Maybe later this year I will learn more QGIS. Best wishes James On 16 June 2011 12:34, Andreas Neumann wrote: Hi James, Glad you found a good solution for your problem. Of course we'd like to know what keeps you from using QGIS instead of ArcGIS? Wher

Re: [postgis-users] QGIS - PostGIS - ArcGIS Interaction

.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______ postgis-users mailing list postgis-

Re: [postgis-users] Shifting linestrings left

Hi Ben, What you want are single sided, open buffers - or one could also call it "ST_Parallel(the_geom,distance)". This doesn't exist yet in Postgis, though I believe that geos (the underlying geometry engine) already supports it (at least the single-sided buffer - not sure about the open buf

Re: [postgis-users] FME and Postgis-SVN problems

ful answer! Andreas On Tue, July 27, 2010 1:14 pm, Mark Cave-Ayland wrote: > Andreas Neumann wrote: > >> Hi all, >> >> I recently installed Postgis-SVN (1.5.2SVN) together with PostgreSQL 9.0 >> beta 3 and noticed that FME (from Safe software) cannot read the >>

[postgis-users] FME and Postgis-SVN problems

known binary geometry Invalid WKB encountered" I wonder if other users of Postgis SVN and FME are getting similar problems? Thanks, Andreas -- Andreas Neumann http://www.carto.net/neumann/ http://www.svgopen.org/ ___ postgis-users mailing list pos

[postgis-users] non-convex or concave hull

Postgis programmer potentially need to implement such an algorithm in Postgis? Thanks, Andreas -- Andreas Neumann http://www.carto.net/neumann/ http://www.svgopen.org/ ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postg

Re: [postgis-users] Copying parallel line features

_ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Andreas Neumann http://www.carto.net/neumann/ http://www.svgopen.org/ ___ postgis-use

Re: [postgis-users] PostGIS FDO

This is great news. I have been waiting for an officially supported FDO Postgis provider for a long time! We are using Postgis as our main data warehouse and Autodesk tools as expert GIS (editing survey data and waste water data). Other GIS tasks are done with QGIS. Having a good FDO Postgis p

Re: [postgis-users] Postgis and arcgis with data interoperability extension

quot; >>>   >>>> We are using the Postgis/PostgreSQL version 8.3 and ArcEditor 9.3.1 >>>> >>>> Thanks for your help >>>> >>> >>> The best thing I could recommend to you now is to do some logging from >>> the >&

Re: [postgis-users] Google Earth/PostGIS integration

; www.gcs-sa.biz <http://www.gcs-sa.biz/> > > > > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Andrea

Re: [postgis-users] OSGeo PostGIS flyer

Hallo Astrid, Hallo Otto, Ich habe gesehen dass es unter http://svn.osgeo.org/osgeo/marketing/flyer/project_brochure_pdfs/ einen ziemlich alten QGIS-Flyer gibt. Mittlerweile gibt es neuere unter http://www.qgis.org/en/documentation/brochures.html - könnt ihr bitte aktualisieren? Otto gibt e

Re: [postgis-users] PostGIS layer not rendering

without seeing the result - there could be several issues: * you need proper primary keys for display in QGIS (e.g. a sequence or an integer type column with unique data) - maybe you don't have a column that qualifies as a primary key? * most GIS (including QGIS) don't allow mixtures of geomet

Re: [postgis-users] Open buffers or parallel lines

sure - I can wait - it's not that urgent. Let me know if there is something to test. Andreas Simon Greener wrote: Regina, This might help http://trac.osgeo.org/postgis/wiki/UsersWikiplpgsqlfunctions upgis_lineshift(centerline geometry, dist double precision) Though its simplified in t

[postgis-users] Open buffers or parallel lines

, but the parallel offset to the centerline should be drawn. Are there any tricks how this can be done in Postgis? I see that there is st_buffer, but there is no option to get an open buffer or parallel lines. Thanks for any hints, Andreas -- Andreas Neumann http://www.carto.net/neuman

Re: [postgis-users] Display & Print Methods For PostGIS

Hi, there are a lot of different options available. Many GIS offer Postgis connectors and are scriptable (GRASS, QGIS Server, GeoServer). I personally would also experiment with SVG output. The AsSVG() output allows you to convert Postgis geometry to SVG. You'd have to build the SVG structu

Re: [postgis-users] OIDS, PostGIS and Quantum GIS

aggregate query really. This is also a problem for querymaps in MapServer. The alternative I settled with was creating a false key - for instance if the view was a makeline from points, making an id that was the gid of the first * 10 + the gid of the second. That may help. It may not - but th

Re: [postgis-users] OIDS, PostGIS and Quantum GIS

role in my model other than that. > > Greetings, > > Juan Pedro Pérez Alcántara > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Andreas Neumann http://www.carto.net/neumann/

Re: [postgis-users] Postgis and Ramdisk

tions and hardware probing. Course if the data is not critical and you just need something lightweight there are application specific options…" Any other online-resources on the topic? Thanks, Andreas Andreas Neumann wrote: Hi, I wonder if people have experiences with running Po

[postgis-users] Postgis and Ramdisk

Hi, I wonder if people have experiences with running Postgis with tablespaces on a ramdisk? How are the performance gains - is it worth a try? My DB is several hundred mb (300-400 - may grow), the physical RAM is 8GB. Most of the DB is read-only. I would perhaps only store the read-only par

Re: [postgis-users] PostGIS view in qgis

nfo/postgis-users >>>> >>>> >>> ___ >>> postgis-users mailing list >>> postgis-users@postgis.refractions.net >>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>> >>>

Re: [postgis-users] load csv file in data base?

Hi Zia, As Michael said, the postgresql COPY command is a standard way from PostgreSQL to import CSV data. You can specify the columns, delimiter, NULL values, quotes and other parameters and it will stop and report errors if a line does not fit the data-types of the defined tables. Often, l

Re: [postgis-users] Updating PostGIS views from Geoserver

Hi Regina, I am pretty sure it is a restriction by Geoserver, but I am not a Geoserver user, so I may be wrong. I am using updateable views with Postgis and QGIS and it works fine, as long as it finds a primary key (integer and unique). Did you make sure that you have a "primary key" in you

[postgis-users] Current status of Curve Support in Postgis

limitations? Thank you for shedding some light on it. If the curve support is already quite good, I would consider starting to experiment with curves. Andreas -- Andreas Neumann Böschacherstrasse 6, CH-8624 Grüt/Gossau, Switzerland Email: a.neum...@carto.net, Web: * http://www.carto.net/ (Carto and SVG

Re: [postgis-users] The Old Who is using PostGIS survey again?

s-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- -- Andreas Neumann Böschacherstrasse 6 CH-8624 Grüt (Gossau ZH) Switzerland Phone: ++41-44-2736668 Email: a.neum...@carto.net Web: http://www.carto.net/neumann

Re: [postgis-users] The Old Who is using PostGIS survey again?

stats a while back, but can't find them. > > Thanks, > Regina > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Andreas Neumann Böschacherst

Re: [postgis-users] Flow Diagram Graphics

l Message - From: "Andreas Neumann" <[EMAIL PROTECTED]> To: "PostGIS Users Discussion" Sent: Thursday, August 21, 2008 10:03 AM Subject: Re: [postgis-users] Flow Diagram Graphics Hi Bob, Do you mean flowcharts in the sense of an org-chart? Rectangles or other sh

Re: [postgis-users] Flow Diagram Graphics

@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- -- Andreas Neumann Böschacherstrasse 6 CH-8624 Grüt (Gossau ZH) Switzerland Phone: ++41-44-2736668 Email: [EMAIL PROTECTED] Web: http://www.carto.net/neumann/ SVG Examples: http://www.carto.net/papers/svg

Re: [postgis-users] Post Gis problem

sagesaying that either #./ or configure is not an internal command. So how do irun this? I have downloaded the file in the C:\postgis-1.3.3\postgis-1.3.3path. Please help guys. Cheers -- -- Andreas Neumann Böschacherstrasse 6 CH-8624 Grüt (Gossau ZH) Switzerland Phone: ++41-44-2736668 Email: [EMAIL

Re: [postgis-users] Best graphical viewer for PostGIS data

tinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- -- Andreas Neumann Böschacherstrasse 6 CH-8624 Grüt (Gossau ZH) Switzerland Phone: ++41-44-

Re: [postgis-users] Any tutorials on integrating PostGIS data with the Google Maps API?

search.yahoo.com/newsearch/category.php?category=shopping > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Andreas Neumann Böschacherstrasse 6, CH-8624 Grüt/G

Re: [postgis-users] Affine transformations of GIS data.

ng list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Andreas Neumann Böschacherstrasse 6, CH-8624 Grüt/Gossau, Switzerland Email: [EMAIL PROTECTED], Web: * http://www.carto.net/ (Carto and SVG resources) * http://www.carto.net

Re: [postgis-users] Problem (bug?) in ST_POLYGONIZE

s, > > - > Kevin Neufeld > Software Developer > Refractions Research Inc. > 300-1207 Douglas St. > Victoria, B.C., V8W 2E7 > > Phone: (250) 383-3022 > Email: [EMAIL PROTECTED] > > > > Andreas Neumann wrote: >> Hello, >> >> I have a lin

Re: [postgis-users] PostGIS Jobs - UK, Worldwide

___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Andreas Neumann Böschacherstrasse 6, CH-8624 Grüt/Gossau, Switzerland Email: [EMAIL PROTECTED], Web:

Re: [postgis-users] Merging 2 Linestring to get another Linestring

ditional light on my situation. Andreas > ST_Collect() the geometries together and then use ST_LineMerge() to > merge the multilinestring. > > This yields a single LineString: > SELECT AsText(ST_LineMerge(ST_Collect('LINESTRING(...)'::geometry, > 'LINESTRING(...)':

[postgis-users] Merging 2 Linestring to get another Linestring

gid > 14) AS the_geom; There are only 16 lines in the db and the gids 15 and 16 are the two I want to merge. Thanks for any hints how I can get a sewed together LINESTRING. Andreas -- Andreas Neumann Böschacherstrasse 6, CH-8624 Grüt/Gossau, Switzerland Email: [EMAIL PROTECTED], Web: * h

Re: [postgis-users] Several Schemas in a spatial Database

_ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Andreas Neumann Böschacherstrasse 6, CH-8624 Grüt/Gossau, Switzerland Email: [EMAIL PROTECTED], Web: * http://www

Re: [postgis-users] Topology Support for PostGIS

> postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Andreas Neumann Böschacherstrasse 6, CH-8624 Grüt/Gossau, Switzerland Email: [EMAIL PROTECTED], Web: * http://www.carto.net/

RE: [postgis-users] 3D maps

> the > road polylines with the correct elevation in each intersection (roadline - > triangle border). Att the same time I would like to insert the correct > elevation of the original points of the road-polyline. is there a command > in > PostGIS that could do this for me? > > Ki

Re: [postgis-users] St_Simplify usage with adjacent polygons

-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- -- Andreas Neumann Böschacherstrasse 6 CH-8624 Grüt (Gossau ZH) Switzerland Phone: ++41-44-2736668 Email: [EMAIL PROTECTED] Web: http://www.carto.net/neumann/ SVG Examples: http://www.carto.net/pape

Re: [postgis-users] Extract nodes in a Polygon Mosaic (Topology)

> astext(intersection(intersection (a.shape,b.shape),c.shape)) > > To find nodes with more than three members. > > C. > > > Andreas Neumann wrote: >> Hello all, >> >> I have a polygon mosaic (lets say administrative units, municipalities) >> and would l

[postgis-users] Converting MULTIPOLYGONS to MULTILINESTRINGS and MULTIPOINTS

Hi again, I am wondering if there is an easy way to convert MULTIPOLYGON geometries to MULTILINESTRING or MULTIPOINT geometries? Thanks for any ideas. Andreas -- Andreas Neumann Böschacherstrasse 6, CH-8624 Grüt/Gossau, Switzerland Email: [EMAIL PROTECTED], Web: * http://www.carto.net

[postgis-users] Extract nodes in a Polygon Mosaic (Topology)

Postgis and found this: http://postgis.refractions.net/support/wiki/index.php?PostgisTopology - whats the state of this project? Thanks for any hints on my two questions. Andreas -- Andreas Neumann Böschacherstrasse 6, CH-8624 Grüt/Gossau, Switzerland Email: [EMAIL PROTECTED], Web: * http