Ben Harper | 3 Jul 09:28

The EWKB/EWKT specs should be part of the PostGIS manual

Sorry to rant about an open source product that's free,

But the EWKB/EWKT specs should really be included in the PostGIS manual.
Only after a fair amount of mistrial did I discover this:

http://postgis.refractions.net/pipermail/postgis-devel/2004-December/000710.html

If that was part of the manual, it would have saved me a fair amount
of confusion.

Additionally, the PostGIS manual claims that "every valid WKB/WKT is a
valid EWKB/EWKT" but I find this to be untrue.
Specifically, if I construct a WKB PointZ geometry, as specified by
http://portal.opengeospatial.org/files/?artifact_id=18241
and I try to read it via GeomFromEWKB(), I get garbage (A COMPOUND
CURVE is what comes out).
The docs should be updated to reflect this fact, or the WKB parser
should support this part of the spec.

Thanks,
Ben
santy | 3 Jul 06:58

Function geomunion() problem


Hi,

Here is the URL for my application
http://www.wetlandsofindia.org/kerala/sample.htm
When I search as below

District: Palakkad
Then select Panchayat option
Bloack: Ottappalam

Then hit Submit.

It shows me the boundary of Ottappalam block but it shows me a line
joining the polygon.

I am using following query to return the boundary

select btrim(astext(transform(geomunion(geometry), 4326)),'MULTIPOLYGON
()') from k_panchayat where
district like '%$district%' and block like '%$block%' group by block

It returns me a single polygon only but somehow I do not understand
from where the line is coming.

I am looking for the solution.

Thanks

Santosh 
(Continue reading)

Steffen Macke | 2 Jul 23:00

Re: Windows binaries for PostGIS 1.4RC1 for PostgreSQL 8.3 and 8.4

Hi Regina,

> I think as someone already noted -- compiling PostGIS under windows is
> currently not as easy as it is under Linux and I as of yet haven't been able
> to compile the shp2gui yet under MingW windows. Getting closer but still no
> cigar.

Problems with the GTK+ part? Is there an error that does not go away?

I've noticed that shp2pgsql-gui.c (current SVN) is lacking a WinMain() function.
Might that cause the problem?

Regards,

Steffen
Favicon

Windows binaries for PostGIS 1.4RC1 for PostgreSQL 8.3 and 8.4

We have up experimental binaries if any windows users want to test drive the
1.4RC1.

For PostgreSQL 8.3 1.4.0 RC1
http://postgis.refractions.net/download/windows/pg83/experimental/postgis/

(both the WKT Raster and PostGIS experimental builds will be located here
for 8.3)
http://postgis.refractions.net/download/windows/pg83/experimental/   

For PostgreSQL 8.4 1.4.0 RC1
http://postgis.refractions.net/download/windows/pg84/experimental/postgis/

(both the WKT Raster and PostGIS experimental builds will be located here
for 8.4 (I don't have the latest wkt raster for 8.4 though you can fine the
last in the archive folder)
http://postgis.refractions.net/download/windows/pg84/experimental/   

These are just the binaries -- no installer included.

Hopefully the README is clear enough.

We plan to have frequent interim builds for Windows users in the future for
our 1.5 SVN and WKT Raster to make it easier for Windows users to help
Test these out and eventually automate this process to make it even more
frequent.

I think as someone already noted -- compiling PostGIS under windows is
currently not as easy as it is under Linux and I as of yet haven't been able
to compile the shp2gui yet under MingW windows. Getting closer but still no
(Continue reading)

Ben Harper | 2 Jul 17:49

Z and M coordinates seem inconsistent and barely supported

I'm struggling to create a geometry field in PostGIS that stores Z and
M coordinates. Are these supported?
Some issues:
1. I cannot create a ZM field. "Dimensionality must be 3 or less"
2. GeomFromText() doesn't recognize "POINT Z (0 0 0)"
3. GeomFromText() does parse (with a warning) "POINTM (0 0 0)", but it
appears the DB isn't really storing the Z coordinate.
4. Using the C library interface, I can't get WKB geometry with Z to parse.

Thanks,
Ben
Ben Harper | 2 Jul 12:46

Polygon and Multipolygon distinguished by field type constraint - call for a generic AnyPoly type

I am looking for a way of creating a geometry field that has a
constrained type identical to the Shapefile spec.
Basically, Polygons and MultiPolygons are equals. Linestrings and
Multilinestrings are equals.
Is there a way to accomplish this with PostGIS?
If I make the field Polygon, then I can't insert Multipolygons, and vice versa.

Thanks,
Ben
Bob Pawley | 1 Jul 20:33

Math Operators

Hi
 
I have an expression such as -
 
select ST_distance(st_centroid(p_id.p_id.the_geom), st_boundary(p_id.p_id.the_geom))/2 + 15000
   from p_id.p_id
   where p_id.p_id.process_id = '1012' ;
 
This works
 
I can access the number 15000 from a table as a variable. 
 
I want to be able to also access the + (or -) from a table as a variable but can't figure out how to do this.
 
Is it possible to store math operators and access them from a table??
 
Bob
_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Clay, Bruce | 1 Jul 19:12
Favicon

large table question

We are looking into Postgres/PostGis as a possible alternative to Oracle for one of our projects.  Some of our data tables have over 800 million data points.

 

Has anyone tried to put that much data into a single data table?

 

Does anyone have any advice on tuning Postgres/PostGis to be able to handle large datasets?

 

Bruce

 

This message and any enclosures are intended only for the addressee. Please notify the sender by email if you are not the intended recipient. If you are not the intended recipient, you may not use, copy, disclose, or distribute this message or its contents or enclosures to any other person and any such actions may be unlawful. Ball reserves the right to monitor and review all messages and enclosures sent to or from this email address.
_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Paul Ramsey | 1 Jul 18:59
Favicon

PostGIS 1.4.0rc1

The first (and hopefully only) release candidate for the 1.4 release
of PostGIS is now available for download:

 http://postgis.refractions.net/download/postgis-1.4.0rc1.tar.gz

For an idea of what's new, please read the NEWS file:

 http://svn.osgeo.org/postgis/branches/1.4/NEWS

For all the latest goodies, make sure you first install the latest GEOS:

 http://download.osgeo.org/geos/geos-3.1.1.tar.bz2

We are hoping to release a Windows test build shortly, and the final
1.4 release soon after.

If you find issues with the release, please file a ticket:

 http://trac.osgeo.org/postgis

Thanks for your help testing! Your time checking PostGIS makes it a
better product for everyone.

Yours,

The PostGIS Team
Jaak Laineste | 1 Jul 18:55
Favicon

pgrouting win32

Hello,

 Does anybody happen to have pgrouting win32 binary, like one from http://www.davidgis.fr/download/pgRouting-1.02_pg-8.3.3.zip to share? The given site seems to be offline, and no idea when will be back up again.  I’ve got same file for PostGIS 8.2 version, and can contribute with it; but this is no good for my PG 8.3.

 

/Jaak Laineste

jaak <at> nutiteq.com

www.nutiteq.com

Skype: nutiteq

 

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Paul Ramsey | 1 Jul 17:51

Easy Ticket

Want to contribute to PostGIS? Power user but not a C programmer?
Here's a ticket for you:

http://trac.osgeo.org/postgis/ticket/214

Get your name up in lights as a PostGIS contributor!

P.

Gmane