Re: [postgis-users] bounding box incorrect on circularstring

es not exist ERROR: function st_intersects(geometry, geometry, integer) does not exist ERROR: function st_intersects(unknown, unknown, integer) does not exist ... for various combinations of geometry, unknown and text. Are these a result of our ongoing prepared geometry API indecision and co

[postgis-users] Re: [Foss4g2009] Integration Showcase Machine 1

r the time being share resources with MapServer and GeoServer. Can any comment on the proposed requirements below? Mark Leslie Geospatial Software Architect LISAsoft - Ph: +61 2 8570 5000 Fax: +61 2 8570 5099 Mob: +61 Suite 112, Jones Bay

[postgis-users] FOSS4G workshop/tutorial closing monday

Just a reminder that the call for workshops and tutorials from the FOSS4G conference in October will be closing on Monday. http://fromtheinsidelookingin.blogspot.com/2009/02/foss4g-2009-workshops-and-tutorial.html -- Mark ___ postgis-users mailing li

[postgis-users] FOSS4G 2009 Call for Abstracts

The Organising Committee would like to welcome all interested participants to submit abstracts for presentations for the Free and Open Source Software for Geospatial conference (FOSS4G), being held in Sydney, Australia October 20-23. FOSS4G offers participants an opportunity to learn from and s

Re: [postgis-users] ST_Disjoint function

7B Assuming you have some sort of unique id, try: select c.district, count(*) from (select distinct a.id, a.district from blah as a, blah as b where a.district = b.district AND st_disjoint(a.point, b.point)) as c group by district; district | count --+--- 17B | 3 Ma

Re: [postgis-users] Strange type casts

code('YWJj', 'base64') to avoid the automatic geometry castings. Mark Leslie Geospatial Software Architect LISAsoft - Ph: +61 2 8570 5000 Fax: +61 2 8570 5099 Mob: +61 Suite 112, Jones Bay Wharf 19-21 Pirrama Rd Pyrmont

[postgis-users] Broken download link

There's a broken link in the "PostGIS : Windows" download page (http://postgis.refractions.net/download/windows/). The installer, postgis-pg83-setup-1.3.6-1.exe, doesn't seem to exist. It is available at pgfoundary, just needs to be copied onto the Refractions serv

Re: [postgis-users] Creating compoundcurve

I can't see anything in the specs or code that leads me to believe this was intentional or sensible. I'll create a bug report. -- Mark Paul Ramsey wrote: Good question. An arc requires at least 3 points, but a linestring does not. Mark? On Wed, Aug 5, 2009 at 6:20 AM, wrote: Hello, Why com

Re: [postgis-users] Postgis for dummies

There's another workshop available at http://revenant.ca/www/postgis/workshop/ -- Mark Paragon Corporation wrote: You can also look at some of these - might be helpful http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01 http://workshops.opengeo.org/stack-intro/ This

Re: [postgis-users] postgis 1.2.1 manual

Regina is correct. The function renaming is the first step in an inevitably long deprecation process. There is as yet no firm date for having the old functions actually removed, but it's necessarily at least three releases away. Mark Obe, Regina wrote: > Hi Stefan, > > In the 1.2.1 release thes

Re: [postgis-users] Large geometry issue

? Both servers are postgres > 8.2.4 on slightly different flavors of linux. > > Thanks! > > Greg W. > > -Original Message- > From: [EMAIL PROTECTED] on behalf of Paul Ramsey > Sent: Thu 7/5/2007 10:29 PM > To: PostGIS Users Discussion > Cc: Mark Leslie &g

[postgis-users] PostGIS 1.3.0 Released

PostGIS 1.3.0 has been released. The highlights of this release are a number of performance improvements for the relational functions, a new Hibernate Dialect and the addition of relational functions ST_Covers, ST_CoveredBy and ST_DWithin. The release can be found as usual at: http://postgis.refra

Re: [postgis-users] postgis tuning parameters

Henry, Instead of copying the thread or cross posting, I'd suggest you direct them to the archives (http://postgis.refractions.net/pipermail/postgis-users/2007-October/017309.html). Then they have the option of participating in this thread, and the list gets a little publicity. Mark Henry H

Re: [postgis-users] Curved Geometry not supported by postgis functions

of geometry to a linear approximation, pass that to geos, and then attempt to regenerate curved sections from any result returned. That is clearly not very good solution, but is the only one I'm aware of at the moment. -- Mark Leslie Software Architect LISAsoft Pty Ltd www.lisasoft.com _

Re: [postgis-users] Polygon covering points?

__ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > Try, ST_ConvexHull(ST_Collect(geometry set)) -- Mark Leslie Software Architect LISAsoft Pty Ltd www.lisasoft.com ___

Re: [postgis-users] Geometry precision setting

ain this precisions through updates and insertions, you'll need to attach a trigger to the table. -- Mark Leslie Software Architect LISAsoft Pty Ltd www.lisasoft.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] Can ArcView view the maps stored in postGIS tables?

list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > Have a look into the ArcGIS Data Interoperability product at http://www.esri.com/software/standards/interopdata.html. A quick scan shows it's for ArcGIS 9.2, so it may not help

Re: [postgis-users] Problem installing PostGIS

liblwgeom.so.1.3 is the PostGIS library. It's installed into the pgsql directory during a 'make install'. Alex Turner wrote: > Is /usr/lib/pgsql/liblwgeom.so.1.3 generated by PostGIS or from the > Postgresql RPMs? Do I just need to update my postgres version? > > Alex > > On Dec 10, 2007 12:50

[postgis-users] Finding a PostGIS guru (in Australia)

of design work to be done? -- Mark Leslie Geospatial Software Architect LISAsoft Pty Ltd +61 (0)2 8570 5050 Commercial Support for Geospatial Open Source Software http://www.lisasoft.com/LISAsoft/SupportedProducts.html Craig Feuerherdt wrote: > I work for a small agricultural managemen

Re: [postgis-users] Can postGIS database views work like .ARP project files?

, LINE, etc), or you can define it as GEOMETRY, and include a mix. The difficulty will come when you try to connect a client app to the table to visualize. I'm not sure if/how they will handle mixed feature types. -- Mark Leslie Geospatial Software Architect LISAsoft Pty Ltd +61 (0)2 857

Re: [postgis-users] GiST Index

great tuning guide to the list a while back. It can be found at: http://postgis.refractions.net/pipermail/postgis-users/2006-March/011539.html -- Mark Leslie Geospatial Software Architect LISAsoft Pty Ltd +61 (0)2 8570 5050 Commercial Support for Geospatial Open Source Software http://www.lisasof

Re: [postgis-users] postgis

numeric column. -- Mark Leslie Geospatial Software Architect LISAsoft Pty Ltd +61 (0)2 8570 5050 Commercial Support for Geospatial Open Source Software http://www.lisasoft.com/LISAsoft/SupportedProducts.html Gregory Williamson wrote: It's been a while since I used MMS, but IIRC it does n

Re: [postgis-users] Difference between @ and ST_WITHIN/ST_CONTAINS

On Wed, Apr 23, 2008 at 3:27 AM, Dylan Beaudette <[EMAIL PROTECTED]> wrote: > On Tuesday 22 April 2008, Paul Ramsey wrote: > > The operators (@, &&, etc) all work on bounding boxes. The functions > > all work on full geometries. It is possible for geometries to satisfy > > bounding box containment

Re: [postgis-users] Projections for Australia

e to the warping as you move away from the central meridian. Australia is big. The distortion across one MGA zone usually isn't tragic, if your points are near the boundary. If you need to compare across more than that I would think you're better off with something more geodetic, like ST_dista

Re: [postgis-users] Is CIRCULARLINESTRING ready for use?

fairly heavily tested. It would also likely involve prototyping in JTS, or maybe one of the JTS extensions that are emerging for this very purpose, before porting to GEOS. As it stands, these functions should error out 'gracefully'. Mark Leslie Markus Schneider wrote: Hello, I

Re: [postgis-users] Is CIRCULARLINESTRING ready for use?

Bruce Rindahl wrote: Mark Leslie wrote: Support for CIRCULARSTRING is there. Loading and retrieving of the supported curved geometries should scale to large numbers perfectly well, but not all the SQL-MM geometries are currently supported. In particular, PostGIS was choking when I attempted

Re: [postgis-users] Generating PNGs from PostGIS

___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > Off the top of my head, I believe both uDig and QGIS are able to save out PNG images, and both are capable of connecting to a PostGIS server. QGIS can ev

Re: [postgis-users] Any Projected Straights Function?

27;t'; END; $$ LANGUAGE plpgsql; The function is a bit of a mess, since I didn't spend much time on it, but is this close to what you're looking for? -- Mark Leslie Geospatial Software Architect LISAsoft

Re: [postgis-users] PostGIS topology

t > http://postgis.refractions.net/mailman/listinfo/postgis-users > This may also be of some help. http://postgis.refractions.net/support/wiki/index.php?PostgisTopology -- Mark Leslie Geospatial Software Architect LISAsoft - P

Re: [postgis-users] PostGIS topology

GEOS for Linux and > API's for a windows build) it's GEOS a good choice? and how does it works > exactly? thanks > > best regards > I haven't worked directly in GEOS much at all. Before you go the route of building on Windows, what exactly are you trying to do?

Re: [postgis-users] PostGIS topology

gis gives a tool to build a topology (nodes, linkers, > edges) with ur geospatial data. thanks > > best regards > > > mchapman wrote: > >> I use geos directly on windows xp using visual studio 2005. How do you >> plan to use it? >> >> Martin >> &g