On 6/12/2012 12:29 AM, Lee Hachadoorian wrote:
I'm going to be giving a talk on PostGIS to a local Postgres group
next week. I would like to mention some large clients and/or
interesting uses to my audience, but the Case Studies section on the
PostGIS website is a bit dated. Does anyone want to
On 4/17/2012 4:00 PM, Jose Carlos Martinez Llario wrote:
Hi,
first I wanted to say thanks because Im asking a lot of questions lately
and you guys always answer me in a fast and kind way. Sandro you
specially must be tired of me. sorry!! :)
now another more question.
I found the function
On 04/02/2012 06:40 PM, THX1138 wrote:
Hello All,
I am attempting to keep my non-gis information separate from my gis
information and thus would like to create a separate postgis schema but I
have run into some problems.
I ran the following commands to move the data into a new schema:
CREATE
On 3/14/2012 4:46 PM, Paul Ramsey wrote:
On Wed, Mar 14, 2012 at 2:41 PM, Andy Colsona...@squeakycode.net wrote:
... and GeomFromText became ST_GeomFromText ... Why did some drop the ST_
and some have it added?
The external spatial functions got them added, so all match up to the
standards
I have run into a problem. Mapserver 6 (.0.1 and .0.2) uses GeomFromText.
Are there any mapserver people on this list? I'll post to the map server
list otherwise.
-Andy
It has been updated in svn though. I grabbed a copy from:
http://svn.osgeo.org/mapserver/branches/branch-6-0/mapserver
On 3/14/2012 11:20 AM, Paul Ramsey wrote:
Hi All,
PostGIS 2.0.0beta3: http://postgis.org/download/postgis-2.0.0beta3.tar.gz
Current open tickets: http://trac.osgeo.org/postgis/report/22
You'll note that the number of open tickets is getting close to zero.
Like a rocket ship countdown, when we
On 3/14/2012 3:46 PM, Sandro Santilli wrote:
On Wed, Mar 14, 2012 at 03:41:52PM -0500, Andy Colson wrote:
I'm now attempting backup pg 9.0 postgis 1.5, and restore it to my
new pg 9.1 postgis 2.0.
Make sure you follow the Hard upgrade procedure described
on the PostGIS manual.
Should
On 3/14/2012 4:02 PM, Sandro Santilli wrote:
On Wed, Mar 14, 2012 at 03:52:07PM -0500, Andy Colson wrote:
On 3/14/2012 3:46 PM, Sandro Santilli wrote:
On Wed, Mar 14, 2012 at 03:41:52PM -0500, Andy Colson wrote:
I'm now attempting backup pg 9.0 postgis 1.5, and restore it to my
new pg 9.1
On 3/14/2012 3:46 PM, Sandro Santilli wrote:
Make sure you follow the Hard upgrade procedure described
on the PostGIS manual.
Should happily bring you from 9.0/1.5 to 9.1/2.0.
And we're all very interested in any problem with that.
--strk;
Ok, backup/restore worked... mostly, turns out I'm
On 3/14/2012 4:33 PM, Andy Colson wrote:
On 3/14/2012 3:46 PM, Sandro Santilli wrote:
Make sure you follow the Hard upgrade procedure described
on the PostGIS manual.
Should happily bring you from 9.0/1.5 to 9.1/2.0.
And we're all very interested in any problem with that.
--strk;
Ok
On 3/12/2012 10:27 AM, Eric Aspengren wrote:
I have a couple of questions about getting some server space on the cloud.
1) anybody have any luck with this?
2) are the servers fast enough to do serious geocoding and such?
3) any recommendations?
4) what about PostGIS 2.0? anybody planning to
On 3/5/2012 11:15 AM, Nicolas Ribot wrote:
Hi,
Try the NOT EXISTS construct. I found it is order of magnitude
faster than NOT IN.
It should be something like (test the query before using it, i'm not
sure of it :)
DELETE FROM portal.metadata
WHERE NOT EXISTS
(
SELECT MIN(idx)
FROM
-Original Message-
From: Andy Colson [mailto:a...@squeakycode.net]
Sent: 01 March 2012 14:53
To: PostGIS Users Discussion
Cc: Stromberg Chris
Subject: Re: [postgis-users] Releasing a lock on a view/database
On 3/1/2012 4:05 AM, Chris Stromberg wrote:
I'm trying to edit a view
On 3/1/2012 4:05 AM, Chris Stromberg wrote:
I'm trying to edit a view that is not currently in active use, but has been
used previously.
when submitting the change to the view, the SQL window just says 'query is
running' and it'll sit there until i stop it.
If i restart the postgres service,
On 2/29/2012 2:12 PM, Paul Ramsey wrote:
Hey all, I know I posted earlier about the deadline (which is
tomorrow) for abstract submissions, but I wanted to stress how much
the conference is looking for stories about folks putting these tools
to use. Case studies, why open source worked for you,
On 2/29/2012 3:24 PM, Bob Pawley wrote:
Hi
After importing to postgis from a shapefile I have some rows duplicated.
Is there a method of making all rows unique after the import.
I tried identifying the rows with “select * where is not unique” without
success.
Bob
Do you have a column that is
On 2/8/2012 2:10 AM, Andreas Forø Tollefsen wrote:
Hi,
I am working on a query where i want to measure the distance from a set
of points, to the nearest point having a spi6 value over 0.
The priogrid includes the points and the spi6_cell identifies which
points have a spi6 over 0.
My question
On 02/05/2012 09:13 AM, Darrel Maddy wrote:
I would be grateful if someone could help me with the syntax for filenames when
using the WHERE clause in gdal_translate
I have
gdal_translate -of GTiff PG:host=localhost port=5432 dbname=testcuda user=postgres
password=H$%£! schema=public
On 02/04/2012 01:14 PM, Darrel Maddy wrote:
Dear Regina,
I would be happy to contribute $100 into any fund which secures a 64-bit
windows build of PostGIS2 -especially as I am about to install it on a machine
with 64Gb RAM :)
Count now at 1 ?
Thanks
Darrel
On 02/04/2012 02:31 PM, Darrel Maddy wrote:
I am no db expert, indeed I am new to PG and postgis so I guess I
have some preconceptions (and a lot to learn)! If you are correct
though it would suggest there is little point to having a 64 bit
version - so why do they do it?
There is a huge
On 01/30/2012 09:00 PM, John Morgan wrote:
Hello,
I am attempting to get a one (polys) to many (table) to load postgis data
within a mapserver wms. I have the following defined in the .map file.
DATA the_geom FROM (SELECT polys.gid AS gid, polys.the_g
eom AS the_geom, table.pt_id AS pt_id,
On 1/4/2012 1:32 AM, Evan Martin wrote:
I have a table of polygons covering most of the world and for a given
polygon I need to find all polygons adjacent to it. In theory, two
adjacent polygons should have a part of their border in common, but in
practice the data is not that precise -
On 12/12/2011 11:08 PM, Ravi ada wrote:
Hello Regina,
I was able to load the data for all states, now I have to gocode about 2
mil addresses . I followed the link below and used the pgScript option
to batch 100 addresses. I am having a terrible performance, query return
time is 10 to 100 times
And instead of running the update, try running:
explain analyze
SELECT ag.id,
(geocode(ag.address1||','||ag.city||','||ag.state||','||ag.zip)) As geo
FROM qliq.geo_biz_addr As ag
WHERE ag.rating IS NULL
ORDER BY zip
LIMIT 100
Also, the order by zip, combined with the
. but in any case, 100
to 300 secs to geocode 100 addresses is too long. I got the work_mem to set to
4GB in postgresql.conf.
Thanks
Ravi Ada
On Tue, 13 Dec 2011 14:31:34 -0600, Andy Colson wrote
And instead of running the update, try running:
explain analyze
SELECT ag.id,
(geocode(ag.address1
I downloaded PostGis 2 to play around with, and tried out the tiger stuff. I
have to say, that's kinda painful.
The doc says: add set -e -u, which causes as many problems as it might catch.
Editing the .sql was a little confusing, and the resulting .sh file is not
really re-startable.
Would
On 12/1/2011 8:04 AM, jdmorgan wrote:
Hello,
I am attempting utilizing the shp2pgsql utility to import a
shapefile.The utility reports that the shapefile is of the type
MULTIPOLYGON[2] and then proceeds to through a bunch of errors for each
record that it can’t import “current transaction is
On 12/1/2011 7:29 AM, maduako ikechukwu wrote:
Hi guys,
please could someone help me look at this SQL code, I cant figure out
what is wrong with it and it gives me this error,
ERROR: missing FROM-clause entry for table i
LINE 3: Select I.temp_lst_id,I.temp_value as I_t, R.tv.val as R_t, (...
On 11/29/2011 11:18 PM, Ravi ada wrote:
Hello All,
I have been fighting with PostGIS for the last week or two to geocode
about 2 million addresses. Here are the challenges that I am facing.
1)I sorted the addresses by zip, address, city to group the similar
addresses together.
2)So far I have
On 10/23/2011 03:02 PM, maduako ikechukwu wrote:
Hi guys,
I want to extract date information from the filename column of my
raster table to update a new date_of_creation column
but i don't have an idea of how to do this, using the substring() and
casting it.
Please could someone write for me
On 10/7/2011 4:32 AM, Andreas Forø Tollefsen wrote:
We will now try the python script again and terminate and open the
connection for each year in the for loop.
If this works, then it seems like there is a resource issue in
Postgresql or in one of the functions of postgis i think.
As i said.
On 10/6/2011 6:17 AM, Andreas Forø Tollefsen wrote:
Seems like everything works if i create everything in PgAdmin SQL query
window and execute the query.
Why is it that while using psycopg2 and python it stops somewhere in the
loop? Any ideas? This might be something for the psycopg2 mailing
On 10/5/2011 8:52 AM, Andreas Forø Tollefsen wrote:
Hi all,
I have a query that previously have been running without problems.
However, after installing everything from scratch it no longer work.
Ubuntu 11.04, Postgresql 8.4.8, PostGIS 2.0 (7932), Geos 3.3.1, GDAL 1.8.1.
The script measures
On 10/02/2011 06:41 AM, Gery . wrote:
Hello,
I'm new around here and after working a while with postgis/postgresql, I'd like
to get something that up to know is advanced for me. Please don't get mad at me
if this is a stupid question =)
I want to create a line table based on a point table,
Date: Sun, 2 Oct 2011 07:51:02 -0500
From: a...@squeakycode.net
To: postgis-users@postgis.refractions.net
CC: gameji...@hotmail.com
Subject: Re: [postgis-users] csv table to points and then create line based on
same name
On 10/02/2011 06:41 AM, Gery . wrote:
Hello,
I'm new around here and
Hi List,
I have a shapefile and using ogr2ogr to reproject it, then shp2pgsql to
import it, but a date column has nulls in it and I'm getting invalid
date errors. If I dont use ogr2ogr the nulls import fine (the dest
table has nulls as well).
It looks like ogr2ogr is using a newer version
36 matches
Mail list logo