Re: [postgis-users] Dot Density idea

2011-05-27 Thread strk
rename to save_it_for_future_use; And here are the functions: It'd be nice if you could make your function accessible on the postgis wiki, so it's easier to find it. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] Retrieve the portion of line external to polygon

2011-02-16 Thread strk
example showing it doesn't ? --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/mailman/listinfo/postgis-users

Re: [postgis-users] Retrieve the portion of line external to polygon

2011-02-16 Thread strk
to the intersection, or to node the input before proceeding. --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

Re: [postgis-users] Retrieve the portion of line external to polygon

2011-02-16 Thread strk
On Wed, Feb 16, 2011 at 07:08:03PM +0100, strk wrote: On Wed, Feb 16, 2011 at 06:47:53PM +0100, Andrea Peri wrote: Look this simple example the difference between the line and the same line intersected with the polygon is equal to the line :) select 1, ST_Difference(ST_GeomFromText

Re: [postgis-users] ST_DWithin Performance

2011-02-12 Thread strk
00080664000805640'::geography, 1000::double precision, true)) Total runtime: 4078.127 ms (7 rows) The geobits_location_index gist (location) index is not being used, for some reason. Why do you say ORDER BY is the culprit ? Does the plan come out differently w/out that ? --strk

Re: [postgis-users] ST_DWithin Performance

2011-02-11 Thread strk
? --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/mailman/listinfo/postgis-users

Re: [postgis-users] Core dumps

2011-02-08 Thread strk
it (lwg_parser_result-errlocation-1) w/out first checking errlocation begin = 0 (checked shortly after). postgis/lwgeom_pg.c:68 // use postgis/lwgeom_pg.c:72 // checks for 0 Could be a possible cause. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] postgis visual client

2011-02-08 Thread strk
[3] http://www.faunalia.it/qgis/plugins.xml --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/mailman

Re: [postgis-users] Core dumps

2011-02-08 Thread strk
On Tue, Feb 08, 2011 at 06:31:23PM +0100, strk wrote: I see pg_parser_errhint is calling lwmessage_truncate and passing it (lwg_parser_result-errlocation-1) w/out first checking errlocation begin = 0 (checked shortly after). I've committed a fix for the problem of my guess in r6789. --strk

Re: [postgis-users] Dice a large polygon

2011-02-07 Thread strk
development versions). --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/mailman/listinfo/postgis-users

Re: [postgis-users] Dice a large polygon

2011-02-07 Thread strk
for topology? It depends on your definition of usable. We are using it. Try it out and point out the limitation you see arising. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list

Re: [postgis-users] Using cleangeometry() on only the Multipolygons in a field of type geometry

2011-01-25 Thread strk
). You might have missed to install the contributed procedure, which I guess you found on the PostGIS wiki. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users

Re: [postgis-users] Documentation on Applying Patches

2011-01-19 Thread strk
path_to_postgis_svn_checkout $ patch postgis-offsetCurve-RafalMagda.patch $ man patch --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http

Re: [postgis-users] rtpostgis errors

2010-12-24 Thread strk
, it's so frustrating to get st_box2d undefined after working hard to convince myself st_ prefix was needed... :P --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users

Re: [postgis-users] rtpostgis errors

2010-12-24 Thread strk
says it should be an ST_Polygon and oracle says it should be an SDO_GEOMETRY. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http

Re: [postgis-users] what to do about TopologyExceptions

2010-12-20 Thread strk
strange things like internal lines. Is there a good way to fix these? ST_SimplifyPreserveTopology? Will doing this help the other union and difference manipulations? Often ST_Buffer(0) fixes it. Try it. If it doesn't, considere ST_MakeValid (requires PostGIS svn). --strk; () Free GIS

Re: [postgis-users] Postgis clipping

2010-12-15 Thread strk
(myPoly, myHolePolygon); --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/mailman/listinfo/postgis-users

Re: [postgis-users] Converting Geometry to WKT

2010-12-13 Thread strk
On Mon, Dec 13, 2010 at 12:41:47PM -0500, Adam Eskreis wrote: I was wondering if there was any documentation out there on how to convert PostGIS geometry to WKT. selet asWKT(geometry) ? --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] Converting Geometry to WKT

2010-12-13 Thread strk
On Mon, Dec 13, 2010 at 01:00:55PM -0500, Adam Eskreis wrote: Thank you so much Paul, this was exactly what I was looking for. And strk, thank you for your response, but I am well aware of the asWKT and asText functions, what I am trying to do is AVOID using these functions, and parse

Re: [postgis-users] Simplify borders

2010-12-10 Thread strk
be faces. You could simplify whole topologies and automatically find that simplification in all TopoGeometry objects defined by their topological primitives. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] Can't create topology schema/functions - PostgreSQL 9.0.1 PostGIS 1.5.2

2010-12-09 Thread strk
improvement ideas are welcome :) --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/mailman/listinfo/postgis-users

Re: [postgis-users] Can't create topology schema/functions - PostgreSQL 9.0.1 PostGIS 1.5.2

2010-12-08 Thread strk
topology yet ? Anyway, if you're looking at topology please try current SVN head. I've been fixing the CREATEFUNCTION one recently, while the first ERROR is a false alarm. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] postgis from ubuntu to suse

2010-12-07 Thread strk
Management created a template_gis database for you. If so, use it as a template for the database you create. See createdb(1) manual page for more info. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] ST_Buffer

2010-11-30 Thread strk
On Tue, Nov 30, 2010 at 03:51:14PM -, d...@inventium.co.uk wrote: PostgreSQL 8.4.5 on Windows 7 What am I doing wrong? You're using proprietary software! --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] Benshmark postgis

2010-11-26 Thread strk
is vs. others _given_the_exactly_same_input_ I suggest making the points predictable too rather than rendom, if you're aiming at this kind of comparison. If you want to evaluate something else make it clear what the goal is. --strk; () Free GIS Flash consultant/developer /\ http

Re: [postgis-users] Benshmark postgis

2010-11-26 Thread strk
the most out of the index ? --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/mailman/listinfo/postgis-users

Re: [postgis-users] Magnifying Topology

2010-11-17 Thread strk
libs. Are you sure you want it in PostGIS, btw ? As it really sounds to me as something you'd want to compute _temporary_ visualizations for human consumption (no analitical computations). --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] Magnifying Topology

2010-11-17 Thread strk
, tolerance) would clean up that kind of error. --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/mailman

Re: [postgis-users] massive snap of points of one geometry to points of another geometry

2010-11-15 Thread strk
of the missing bit (the wrapper). --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/mailman/listinfo/postgis-users

Re: [postgis-users] help with pgsql2shp error

2010-11-09 Thread strk
010120E61022FDF675E0DC35C000917EFB3A085040 \. EOF --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/mailman/listinfo/postgis-users

Re: [postgis-users] help with pgsql2shp error

2010-11-07 Thread strk
\001c035dce075f6fd224050083afb7e9100 Can you check the postgrsql logs to confirm the dumper uses _that_ query ? --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users

Re: [postgis-users] help with pgsql2shp error

2010-11-07 Thread strk
On Sun, Nov 07, 2010 at 09:58:02AM +0100, strk wrote: On Sat, Nov 06, 2010 at 05:31:55PM -0400, Sam Snellings wrote: *(database geog_three, tutorial data) select asEWKB(setSRID(geog::geometry,-1), 'XDR') from airports;* * * asewkb *\001c05d9a1b089a02754040f8c154c985f0

Re: [postgis-users] help with pgsql2shp error

2010-11-06 Thread strk
with geography data types, correct? You can cast geography to geometry using the ::geometry operator. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users

Re: [postgis-users] help with pgsql2shp error

2010-11-06 Thread strk
;* count: 3 The suggestion was due to the fact that pgsql2shp should be using that call. In particular: asEWKB(setSRID(%s::geometry, -1), 'XDR') Want to try that as well ? (substitute %s with the name of your geometry column) --strk; () Free GIS Flash consultant/developer /\ http

Re: [postgis-users] help with pgsql2shp error

2010-11-05 Thread strk
). Output shape: PolyLine *Dumping: XERROR: parse error - invalid geometry* Ouch. What's the output of: select postgis_full_version() ? A bug with that kind of effect was fixed in 1.5.1 and 1.4.2 releases. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net

Re: [postgis-users] help with pgsql2shp error

2010-11-05 Thread strk
(asEWKB(the_geom)) from global_points; Anyway, would you want the invalid geometries in your shapefile ? I'd think you'd better fix the invalidities and then try again. See ST_isValid and ST_isValidReason. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net

Re: [postgis-users] selectivity

2010-11-02 Thread strk
functions to, say, temporal postgres or cube? would you recommend it? Sure, why not. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users@postgis.refractions.net

Re: [postgis-users] selectivity

2010-11-02 Thread strk
On Tue, Nov 02, 2010 at 03:13:14PM +0100, strk wrote: On Mon, Nov 01, 2010 at 04:18:30PM -0700, Ben wrote: 2 - is there any documentation describing how they work (besides the source code)? i'm interested in the kind of statistics you use. You may find something in postgis-devel

Re: [postgis-users] Proposal to drop support for PostgreSQL 8.3 inPostGIS 2.0

2010-10-29 Thread strk
feature, maybe I even funded it, but want to restrict the risk to a well-defined postgis space. PS: I'll give up easily, don't take this as strong opposition :P --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] Proposal to drop support for PostgreSQL 8.3 in PostGIS 2.0

2010-10-28 Thread strk
used an official distro since they always seem to be eons behind in the name of stability. My rule of thumb in the recent years have been: Stick to what Debian stable has. (debian stable is known to be behind in name of stability) http://packages.debian.org/stable/postgresql --strk; () Free

Re: [postgis-users] Proposal to drop support for PostgreSQL 8.3 in PostGIS 2.0

2010-10-28 Thread strk
are ready when they are ready. That's what makes it a good choice for basing dependencies on :) Look at present for deps, not future. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list

Re: [postgis-users] Selecting polygons circled by one only polygons

2010-10-28 Thread strk
table --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/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 1.5.2 make check fails

2010-10-19 Thread strk
? --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/mailman/listinfo/postgis-users

Re: [postgis-users] Makeline help

2010-10-12 Thread strk
checking for EVENT_ID changes and closing the line there (or at end of input). Interesting use case indeed. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users

Re: [postgis-users] Makeline help

2010-10-12 Thread strk
aggregate function. Check the PostgreSQL developer manual about aggregates and the supported languages. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users

Re: [postgis-users] Split Polygon in PostGIS

2010-10-07 Thread strk
) ) )) FROM districts )); --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/mailman/listinfo/postgis-users

Re: [postgis-users] How to Update Geometry table

2010-09-30 Thread strk
(geom =). Maybe you meant to *create* split_polys10 from that subquery ? --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http

Re: [postgis-users] pgsql2shp revision

2010-09-12 Thread strk
that in an header file (which we'd touch) and use that when we see fit. I wouldn't drop the file-specific one though, you can always get a diff from current to the specific one w/out querying the server (right? or time to move to git :). --strk; () Free GIS Flash consultant/developer /\ http

Re: [postgis-users] Size of .dbf file produced with pgsql2shp

2010-09-02 Thread strk
? --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/mailman/listinfo/postgis-users

Re: [postgis-users] Input versus output geometry

2010-09-02 Thread strk
dropbbox(ST_expand(setsrid(makepoint(-122.50367,37.74189),4326), 0.4)) dropbbox(ST_expand(setsrid(makepoint(-122.50376,37.74185),4326), 0.4)); --strk; This was with Postgres 9.0rc1 and Postgis 1.5.2 SVN r5851. gisttest2=# select ST_expand(setsrid(makepoint(-122.50367,37.74189),4326

Re: [postgis-users] Input versus output geometry

2010-09-02 Thread strk
On Thu, Sep 02, 2010 at 02:24:30AM -0700, Alex Zepeda wrote: strk wrote: Are you sure your constraint checked your input in the original table ? Yup. I went over this with the postgres guys on postgres-bugs and managed to distill something of a test case as far as the constraints being

Re: [postgis-users] ST_Difference and ST_Buffer queries

2010-09-01 Thread strk
the area is below a given value (including holes, I'd say). It'd be useful to have the above functionality in a function, possibly taking the threshold as a factor of total area. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] ERROR: You need GEOS-3.3.0 or up for ST_MakeValid

2010-09-01 Thread strk
. 4.7.1, 23 September 2009 LIBXML=2.7.6 USE_STATS You need to configure, build and install postgis library again for that function to work. --strk; ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman

Re: [postgis-users] Size of .dbf file produced with pgsql2shp

2010-09-01 Thread strk
day we'll add a flag to specify the geometry type thus allowing creation of empty-but-structuted shapefiles starting from a table template. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users

Re: [postgis-users] Size of .dbf file produced with pgsql2shp

2010-09-01 Thread strk
On Wed, Sep 01, 2010 at 06:29:56PM +0100, Mark Cave-Ayland wrote: strk wrote: Checking the resulting file size is not the right way to be trying to detect whether the query returned 0 rows. It strikes me that the best way to detect this would be to return a different exit code from

Re: [postgis-users] Check geometry for true intersection using ST_Relate

2010-07-19 Thread strk
between interiors. --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/mailman/listinfo/postgis-users

Re: [postgis-users] Can I add geometry column without use AddGeometryColumn?

2010-07-16 Thread strk
a column manually (at CREATE TABLE or ALTER TABLE or SELECT INTO time). --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http

Re: [postgis-users] Info on topology

2010-07-16 Thread strk
On Fri, Jul 16, 2010 at 04:00:22PM +0200, Andrea Peri wrote: There is some document to help to install and use topology ? See topology/README and the wiki: http://trac.osgeo.org/postgis/wiki/UsersWikiPostgisTopology --strk; () Free GIS Flash consultant/developer /\ http

[postgis-users] PostGIS topology use ?

2010-07-01 Thread strk
for some time as PostGIS changed function signatures and PostgreSQL switched a couple of major versions, but works again in trunk. So, did anyone try it ? --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] PostGIS topology use ?

2010-07-01 Thread strk
would be on the app level. For instance QGIS itself does use some form of topological representation when doing edits. Would be interesting to see it cope directly with topology in the backend. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] ERROR: could not load library /usr/local/pgsql/lib/postgis-1.5.so

2010-05-27 Thread strk
libproj install. --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/mailman/listinfo/postgis-users

Re: [postgis-users] Adding new points to multipoints and new polygons to multipolygons

2010-05-26 Thread strk
and efficiency are important as these updates will happen frequently. See ST_AddPoint and ST_AddGeometry. The latter should work in both cases. If it doesn't, file a feature request as I think it should :D --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net

Re: [postgis-users] Problem with ST_ExteriorRing and ST_contains

2010-05-20 Thread strk
-intersection[-2.14772 42.5812] which is what I expected. Which version of GEOS are you using ? The latest release contains a fix for false positives. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis

Re: [postgis-users] Problem with ST_ExteriorRing and ST_contains

2010-05-20 Thread strk
On Thu, May 20, 2010 at 02:03:41PM +0200, didier peeters wrote: it's GEOS 3.2.0-1 from http://www.kyngchaos.com/ is this the last release ? Nope. 3.2.1 fixed the isvalid false and 3.2.2 memory leaks. --strk; Le 20 mai 2010 à 13:20, strk a écrit : On Thu, May 20, 2010 at 12:14:55PM

Re: [postgis-users] Question on GEOMETRY type

2010-05-19 Thread strk
keystrokes too! :) Was that function deprecated ? --strk; 2010/5/19 Paul Ramsey pram...@opengeo.org: ST_NDims() returns the number of dimensions, but that doesn't distinguish between XYM and XYZ. The ESRI compatibility functions SE_IsMeasured() and SE_Is3D() (hey, they are useful after all

Re: [postgis-users] WKT expected, EWKT provided

2010-05-12 Thread strk
On Tue, May 11, 2010 at 01:56:21PM -0700, Peter Willis wrote: I am entering 2D polygons so from where would postgis be warning about EWKT entry? Are you embedding a SRID value inside your WKT ? That's also an extension. --strk; () Free GIS Flash consultant/developer /\ http

Re: [postgis-users] Extract points from multipoint geometries

2010-05-11 Thread strk
On Mon, May 10, 2010 at 11:32:32AM -0400, Charles Galpin wrote: ST_PointN doesn't work for multipoints, ST_GeometryN does. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing

Re: [postgis-users] Converting Multilinestrings to Linestrings

2010-05-07 Thread strk
the first LINESTRING of the (pseudo)set. --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/mailman/listinfo

Re: [postgis-users] Dot Density idea

2010-05-06 Thread strk
. --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/mailman/listinfo/postgis-users

Re: [postgis-users] Dot Density idea

2010-05-06 Thread strk
ST_RandomPoinsOnSurface(geometry, numpoints) would be an interesting function indeed. Sounds like a good job for GEOS/JTS. --strk; On Mon, May 03, 2010 at 10:49:32PM -0600, John Abraham wrote: One of the things I miss about using ESRI's GIS is the ability to do dot-density maps. Within

Re: [postgis-users] line_interpolate_point does not return a point that intersects the line

2010-05-03 Thread strk
much the intersection point is off the line, should be a really low number. --strk; gis=# SELECT ST_AsText(v.the_geom), ST_SRID(v.the_geom), ST_AsText(r.the_geom), ST_SRID(r.the_geom) FROM road_segments AS r, venues AS v WHERE v.venue_id = 29 AND r.gid = 100982; st_astext

Re: [postgis-users] line_interpolate_point does not return a point that intersects the line

2010-05-03 Thread strk
approach. No built-in tolerance for others. --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/mailman/listinfo

Re: [postgis-users] Establish versus of a line

2010-05-03 Thread strk
You're probably looking for an ST_IsCCW() function ( is counter-clock-wise ? ). Such a function could only work with closed and simple lines (see ST_IsClosed and ST_IsSimple). It's not available at the moment, but defining the interface is half work, so shouldn't cost too much to add :) --strk

Re: [postgis-users] setsrid does not exist

2010-05-03 Thread strk
the problem .. ST_SetSRID( 'BOX3D((26.8988086602918-200 7.71874658182343-200 26.8988086602918+200 7.71874658182343+200)), ::box3d,4326)' ) You're passing ST_SetSRID a single string, with no cast (what looks like an attempt to cast is inside the string single quote) --strk; () Free GIS

Re: [postgis-users] Need a polygon box of a table instead of the bounding box that returns extent function

2010-05-03 Thread strk
On Mon, May 03, 2010 at 09:32:54AM -0300, Oscar Zamudio wrote: I need to clarify: my table is a table of streets. So ... I don't know how to proceed. You may be looking for ST_ConvexHull. Something like: SELECT ST_ConvexHull(ST_Collect(the_geom)) from mytable; --strk; () Free GIS Flash

Re: [postgis-users] SetSRID functin does not exist

2010-04-29 Thread strk
the problem .. Tried ST_SetSRID ? ... I know, I know ... --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/mailman

Re: [postgis-users] Error building postgis 1.5.1 on Solaris Sparc 64 bit

2010-04-16 Thread strk
error before or at: typedef lwgeom_pg.h, line 44: invalid token in #define macro parameters: ... cc: acomp failed for lwgeom_pg.c Try building with GCC ? --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] st_union

2010-04-13 Thread strk
a tolerance explicitly. [1] http://www.gadm.org/ --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html On Tue, Apr 13, 2010 at 09:05:07AM -0700, Martin Davis wrote: PostGIS (actually GEOS, which mirrors JTS) doesn't use a tolerance during geometry union

Re: [postgis-users] Postgres/Postgis query very slow

2010-04-01 Thread strk
), p.the_geom) Blind guess: - Use ST_DFullyWithin instead of buffer (major improvement expected) - Use equality operator and an OR for tags rather than like (minor) - Avoid the DISTINCT if not needed (minor) --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] Polygon validity

2010-03-31 Thread strk
notice about self intersection. Please explain this situation. My guess is that when transferring the data from postgis to QGIS, ArcView or ArcGis you're loosing precision (using WKT ?) thus introducing self intersections. --strk; () Free GIS Flash consultant/developer /\ http

[postgis-users] Recommended update: GEOS-3.2.1

2010-03-30 Thread strk
. This version plugs painlessly in existing PostGIS installations, just make install and you would get a correct ST_isValid() implementation. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis

Re: [postgis-users] Confused about st_snaptogrid and precision.

2010-03-23 Thread strk
should get a consistent precision all over. The equality tests you report are only snapping one operator, thus the false return. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing

Re: [postgis-users] Confused about st_snaptogrid and precision.

2010-03-23 Thread strk
)),the_geom); --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/mailman/listinfo/postgis-users

Re: [postgis-users] Confused about st_snaptogrid and precision.

2010-03-23 Thread strk
On Tue, Mar 23, 2010 at 01:05:52PM +0100, strk wrote: On Tue, Mar 23, 2010 at 06:57:41AM -0500, Paul Moen wrote: UPDATE the_control SET the_geom=st_snaptogrid(the_geom,.001); After setting the precision, shouldn't I be able to find the point, POINT(1881581.0894989 638200.5564884

Re: [postgis-users] ERROR: array size exceeds the maximum allowed (134217727)

2010-03-20 Thread strk
this on a fairly sturdy system that that has more capacity than some of the Fedora systems I'm running. st_memunion builds a big array with all geometries in it.. you were hitting a limit of the array type. st_union should behave better. --strk; () Free GIS Flash consultant/developer

Re: [postgis-users] ERROR: array size exceeds the maximum allowed (134217727)

2010-03-20 Thread strk
On Sat, Mar 20, 2010 at 07:56:14AM -0700, Paul Ramsey wrote: Actually, memunion does the opposite, it passes the resultant and preserves mem. Oops, sorry for the confusion. Not-so-intuitive name :P --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] GEOS intersects() threw an error!

2010-03-18 Thread strk
. --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/mailman/listinfo/postgis-users

Re: [postgis-users] how to contribute to development?

2010-03-17 Thread strk
-in for approval (without tripping over ego ;))? See this for more informations: http://mapserver.org/development/index.html#development --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users

Re: [postgis-users] ERROR after geos install

2010-03-15 Thread strk
.1: cannot open shared object file: No such file or directory Try running ldconfig, as root. Make sure /usr/local/lib is in your /etc/ld.so.conf --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis

Re: [postgis-users] How to edit one point in multipolygon given dump path

2010-03-15 Thread strk
the text for the multipolygon. There has to be a better way using PostGIS and SQL, right? Right, you can code your function and submit a patch ! --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis

Re: [postgis-users] How to edit one point in multipolygon given dump path

2010-03-15 Thread strk
to core postgis. A C function might. Both versions you can share (the postgis wiki contains a fair amount of scripting language functions). --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users

Re: [postgis-users] st_intersects threw an error

2010-03-15 Thread strk
On Mon, Mar 15, 2010 at 04:20:57PM +0100, Leonid Khaylov wrote: Thank you for your professional reply, strk! Just for your information, we updated our PostGIS installation to version 1.5.0 and checked all the geometries for validity (all of them are valid). Did you get the false positive

Re: [postgis-users] How to edit one point in multipolygon given dump path

2010-03-15 Thread strk
the code (when simple) on the wiki: http://trac.osgeo.org/postgis/wiki/UsersWikiMain --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http

Re: [postgis-users] Changing transaction behaviour in shp2pgsql

2010-03-14 Thread strk
file and removing all the begin and commit commands...) Feel like working on a patch to make transaction policy selectable with a switch ? -T policy transaction policy (single*,none) Current policy is chunked, dunno for what rationale.. --strk; () Free GIS Flash consultant/developer

Re: [postgis-users] PostGIS manager: importing multilinestring

2010-03-12 Thread Sandro Santilli(strk)
the shapefile to me. Thanks for finding a new bug! --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/mailman/listinfo

Re: [postgis-users] PostGIS manager: importing multilinestring

2010-03-12 Thread Sandro Santilli(strk)
I found memory errors in the loader, and fixed in trunk with commit 5430. Please test again with the new version. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html On Fri, Mar 12, 2010 at 05:35:54PM +0100, Sandro Santilli(strk) wrote: On Fri, Mar

Re: [postgis-users] PostGIS manager: importing multilinestring

2010-03-12 Thread strk
On Fri, Mar 12, 2010 at 10:52:30AM -0800, Paul Ramsey wrote: That appears to have fixed things on OS/X. Can you port back into 1.5 branch? Done: http://trac.osgeo.org/postgis/changeset/5431 --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] Copying parallel line features

2010-03-10 Thread strk
to be developed. See ST_OffsetCurve: http://trac.osgeo.org/postgis/ticket/413 Your use case may help defining the final interface. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list

Re: [postgis-users] st_intersects threw an error

2010-03-09 Thread strk
up if any invalidity is found. Also note that upgrading GEOS will give you improved robustness and speed. Finally, consider also upgrading postgis (1.5.1 is about to be released). --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] Postgis: Error

2010-03-05 Thread strk
On Fri, Mar 05, 2010 at 04:11:25PM -0500, Majid Kazemi wrote: l:57: ERROR: could not load library /opt/PostgreSQL/8.3/lib/postgresql/postgis-1.5.so: libgeos_c.so.1: cannot open shared object file: No such file or directory Did you run ldconfig(8) after geos install ? --strk; () Free

  1   2   >