On Wed, Nov 30, 2011 at 03:06:46PM -0800, Bob Pawley wrote:
Do you yet have a timeline for the Postgis 2.0 release??
Spring at worst, but it's much more likely that you could
have something to test by the first days of the new year.
A lot depends on how good the postgis users have been
Hi,
I have some issues with pgsql2shp.
I am using postgis 1.5.3 over postgresql 9.0 on windows.
The database I am working with is utf8.
I have several spatial tables and I want some of them to be exported to
a shape file.
pgsql2shp seems to be working fine but when I load the generated shape
Andreas ,
You don't need to install postgis.sql, rtpostgis.sql
Just _upgrade_20_minor.sql ones.
That is unless we change the on disk format or change non-droppable things
like casts which we might before release.
_
From: postgis-users-boun...@postgis.refractions.net
On 01/12/11 08:32, toni hernández wrote:
Hi,
I have some issues with pgsql2shp.
I am using postgis 1.5.3 over postgresql 9.0 on windows.
The database I am working with is utf8.
I have several spatial tables and I want some of them to be exported to
a shape file.
pgsql2shp seems to be working
Pierre,
This is great you're working on this. It is exactly what I think that
pgraster is going to make a great tool.
Last days I didn't really have time to check out things, hopefully this
week.
Cheers,
Tom
On 30-11-2011 19:19, Pierre Racine wrote:
Andreas, Tom,
I have put two new
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, (...
^
Here is the code;
Select
Try this:
SELECT I_t,
(tv).val as R_t,
(I_t - R_t) as D_t
FROM (SELECT ST_intersection(R.rast, I.the_geom) AS tv,
I.temp_value as I_t
FROM in_situ_lst I, lst_day R
WHERE I.the_geom R.rast AND ST_intersects(R.rast,I.the_geom)
Thanks all for the suggestions. I am migrating this process to a bigger
machine which has 16GB RAM and faster hard drives. I will incorporate these
changes once the migration completes.
There are two things I got so far I need to do.
1) use pgScript to commit every 500 or 1000 updates
2) send
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 aborted, commands
ignored until end of
I have put a first version of ST_Clip in script/plpgsql
Pierre
-Original Message-
From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-
boun...@postgis.refractions.net] On Behalf Of Tom van Tilburg
Sent: Thursday, December 01, 2011 7:14 AM
To:
My question is already answered: someone committed changes at
http://trac.osgeo.org/postgis/ticket/1333#comment:3.
Are these already in the SVN trunk?
Aren
On Wed, Nov 30, 2011 at 6:29 PM, Aren Cambre a...@arencambre.com wrote:
Based on the conversation below, it appears there is already a
FYI. You can not do a COMMIT in a plpgsql or any stored procedures
because the the function call is run in a transaction. The way to do
this is in an external script like Perl or PHP where you cycle through
500-1000 addresses and updates and then do the COMMIT.
-Steve
On 12/1/2011 9:04 AM,
This is great! Fantastic. I will do some testing.
2011/12/1 Tom van Tilburg tom.van.tilb...@gmail.com
Pierre,
This is great you're working on this. It is exactly what I think that
pgraster is going to make a great tool.
Last days I didn't really have time to check out things, hopefully
Mark,
No, I haven't.
Right now I am preparing some material for a course and I need some
stable release but I'll keep that in mind.
Thanks.
On 01/12/2011 11:50, Mark Cave-Ayland wrote:
It's had a fairly hefty rewrite
___
postgis-users mailing
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 12/1/2011 9:56 AM, Andy Colson wrote:
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
ST_GeomFromText turns WKT into a geometry, not SQL. You can either
format WKT (text) using:
ST_GeomFromText('POINT(' || NEW.koordinat_x || ', ' || NEW.koordinat_y
|| ')', 32748)
Or, a simpler/faster/lossless geometry constructor would be to pass
the floating point values directly to a point
Dear Mike,
Thank you for the solutions. I will try it.
Thanks again.
Cheers,
Firman.
On 12/2/11 5:16 AM, Mike Toews wrote:
ST_GeomFromText turns WKT into a geometry, not SQL. You can either
format WKT (text) using:
ST_GeomFromText('POINT(' || NEW.koordinat_x || ', ' || NEW.koordinat_y
||
19 matches
Mail list logo
