Re: [postgis-users] make generates incorrect PERL variable value on v1.5.2

2011-03-09 Thread Bill Teluk
Correction: that was PostgreSQL 9.0.3 Sorry! -- View this message in context: http://old.nabble.com/make-generates-incorrect-PERL-variable-value-on-v1.5.2-tp31112316p31112350.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ po

Re: [postgis-users] make install as root on v1.5.2

2011-03-09 Thread Bill Teluk
Correction: that was PostgreSQL 9.0.3 Sorry! -- View this message in context: http://old.nabble.com/make-install-as-root-on-v1.5.2-tp31112326p31112347.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list

[postgis-users] make install as root on v1.5.2

2011-03-09 Thread Bill Teluk
Hi, I have installed PostGIS 1.5.2 on a PostgreSQL 9.0.4 (OpenSCG RPM) on an RHEL5.5 system - the instructions in the included README.postgis indicate that I should perform "make install" as "postgres" user. This didn't work and generated the error below: /bin/mkdir -p '/opt/postgres/9.0/shar

[postgis-users] make generates incorrect PERL variable value on v1.5.2

2011-03-09 Thread Bill Teluk
Hi, I have installed PostGIS 1.5.2 on a PostgreSQL 9.0.4 (OpenSCG RPM) on an RHEL5.5 system, during the build process, when I ran "make" (after "./configure") I got the following error. Error message extract: gcc -E -traditional-cpp postgis.sql.in.c | grep -v '^#' > postgis.sql.in sed 's,

[postgis-users] datatype question in postgis

2011-03-09 Thread Robert Buckley
Hi, I have a project on my desktop gis which I would like to transfer to the web and offer as a map service. Currently the project consists of around 90 layers (all shps) -points/lines and polygons. If I serve them through postgresql into geoserver should I keep the data structure as it is, o

Re: [postgis-users] Creating a grid purely in SQL

2011-03-09 Thread Pierre Racine
I would use PostGIS raster: first: CREATE OR REPLACE FUNCTION ST_PixelAsPolygons(rast raster, band integer) RETURNS SETOF geomval AS $$ DECLARE rast alias for $1; w integer; h integer; x integer; y integer; result geomval; BEGIN

Re: [postgis-users] Infinite loop in st_intersects - because of incorrect data out of st_transform?

2011-03-09 Thread Mark Cave-Ayland
On 08/03/11 09:16, Magnus Hagander wrote: Since nobody appears to be too interested in producing a quick fix in geos, attached is a patch that puts in an *ugly* workaround in PostGIS, that simply rejects the infinite values higher up in the stack. I don't consider this a long-term fix, but it at

Re: [postgis-users] Increase query performance

2011-03-09 Thread Andreas Forø Tollefsen
Thanks for all the suggestions. I first thought about doing the simplify, but after some reconsideration I realized that this would change the geometry of the country borders, and Area measurements might be wrong. Then i tried the query without the ST_Intersection and only the conditional ST_Inter

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

2011-03-09 Thread Ralf Suhr
Hi Birgit, this is only a topoligie Problem. Your secound polygon is computed outside PostGIS and numeric precision are lost by import. In this case ST_Difference() and other PostGIS function can have results with very small errors. You can clean the second polygon by move all points to the bor

[postgis-users] bug in st_difference() ?

2011-03-09 Thread Birgit Laggner
Dear list, when I am using ST_Difference(), I often have the problem, that the resulting geometries contain vertexes lying outside of the supposed geometry extent. My impression is that the function tries to preserve vertexes of the input geometries and does not check properly, whether the p

Re: [postgis-users] newbie prob: PostgreSQL server will not connect so PostGIS installation fails with dbcreate

2011-03-09 Thread Sean
Did you install PostgreSQL? It sounds like you need to learn the basics of Relations Database Management Systems (RDMS) before you dive into PostgreSQL/PostGIS. The server is the database system. It manages connections to the databases. If the server isn't running, there's nothing to which you

Re: [postgis-users] Is there any free postgis host?

2011-03-09 Thread Sean
You can a year of Amazon AWS for free: http://aws.amazon.com/free/ OpenGeo has an AMI you can use: http://blog.opengeo.org/2010/09/13/opengeo-suite-community-edition-on-amazon-web-services/ That combination might give a free platform for testing for a year. Sean On Mar 9, 5:38 am, Saka Royba

[postgis-users] Is there any free postgis host?

2011-03-09 Thread Saka Royban
Hi all I wonder if there is any free postgis host on the web for testing an asp.net application which uses postgis? regards ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/po

Re: [postgis-users] Increase query performance

2011-03-09 Thread Mark Cave-Ayland
On 08/03/11 17:01, Andreas Forø Tollefsen wrote: After a suggestion from pgsql_performance i tried with ST_Simplify to speed things up. However this gives me a: NOTICE: ptarray_simplify returned a <2 pts array Then server connection terminates. Like this: SELECT ST_Intersection(priogrid_land.

Re: [postgis-users] newbie prob: PostgreSQL server will not connect so PostGIS installation fails with dbcreate

2011-03-09 Thread Florian Reimer
Hi, thanks for the reply but I do not have a "Start Database" Icon. I think a DB was never yet created as PostGIS Installation fails, because the Server created by pg Admin III can not connect. Is it correct to use default settings? Server [localhost] Database [postgres] Post [5432] Username [p

Re: [postgis-users] 2010 Census

2011-03-09 Thread Paragon Corporation
Eric, I'm not sure if its any value to you, but the PostGIS 2.0 we upgraded the Tiger geocoder to load in Tiger 2010 data. We only loaded in the datasets that were relevant for geocoding, but the system is table driven, so you could use it to load the other datasets you care about. http://www.