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.

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

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

[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

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

[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

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

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

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

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

[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,

[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

[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

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

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. ___