From:
"postgis-users-requ...@postgis.refractions.net"
<postgis-users-requ...@postgis.refractions.net>
To:
postgis-users@postgis.refractions.net
Sent: Mon,
May 16, 2011 9:00:02 PM
Subject:
postgis-users Digest, Vol 109, Issue 15
Send postgis-users mailing list submissions to
postgis-users@postgis.refractions.net
To subscribe or unsubscribe via the World Wide Web, visit
http://postgis.refractions.net/mailman/listinfo/postgis-users
or, via email, send a message with subject or body 'help' to
postgis-users-requ...@postgis.refractions.net
You can reach the person managing the list at
postgis-users-ow...@postgis.refractions.net
When replying, please edit your Subject line so it is more
specific
than "Re: Contents of postgis-users digest..."
Today's Topics:
1. Re: Clip a table using a donut geometry (J?lio Almeida)
2. Help for my error when I install Postgis (truongxuan
quang)
3. Re: Help for my error when I install Postgis (Ren?
Riech)
----------------------------------------------------------------------
Message: 1
Date: Mon, 16 May 2011 15:31:23 +0100
From: J?lio Almeida <
julio.augusto.alme...@gmail.com>
Subject: Re: [postgis-users] Clip a table using a donut
geometry
To: Ralf Suhr <
ralf.s...@itc-halle.de>
Cc: PostGIS Users Discussion <
postgis-users@postgis.refractions.net>
Message-ID: <
banlktikguwnzvu23abyevmdkeay-tef...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Thanks Ralf for your suggestion.
I solved it by doing it in two steps.
First, I created a temporary table with the donut geometry:
EXECUTE 'create table tempdonut as SELECT
ST_Difference(st_buffer(the_geom,buffer_radius), the_geom)
as the_geom
from designprocess.dp_zn_boundaries
where type = site_name);
Second, I did de Intersects query:
EXECUTE 'INSERT INTO tempdonut SELECT
r.the_geom, r.gid FROM
urbanenvironment.ue_ms_crossings_wegdeel_punt
AS r, tempdonut as m
WHERE ST_Intersects(r.the_geom, m.the_geom)';
Thanks again,
j?lio almeida
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20110516/212d79ac/attachment-0001.html>
------------------------------
Message: 2
Date: Mon, 16 May 2011 10:23:15 -0700 (PDT)
From: truongxuan quang <
truongxuanqu...@yahoo.com>
Subject: [postgis-users] Help for my error when I install
Postgis
To:
postgis-users@postgis.refractions.net
Message-ID: <
11939.11902...@web114704.mail.gq1.yahoo.com>
Content-Type: text/plain; charset="us-ascii"
Dear list
I face with some problem in installation PostgreSQL 8.3 on
winXP , long time
before I use PostgreSQL and PostGIS for managing shape file
data. Last week I
tried to install PostgreSQL 8.4, after that I remove
PostgreSQL 8.3 (I only
uninstalled inside windows control panel/add and then I
delete all folder inside
window programs) and I reinstall PostgreSQL 8.4, and problem
was starting happen
from this step, until now, I could not connect data by my
user and password or
start PostgreSQL8.4 service from Administrative Tools . Even
I tried to
uninstall and reinstall for at least 20 times, delete
folder, remove
user/password on Administrative Tools.
Could you please help me to fix my problem
Many thanks
T.X.Quang
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20110516/3cd27eaa/attachment-0001.html>
------------------------------
Message: 3
Date: Mon, 16 May 2011 19:50:34 +0200
From: Ren? Riech <
rene.ri...@arcor.de>
Subject: Re: [postgis-users] Help for my error when I
install Postgis
To: "PostGIS Users Discussion" <
postgis-users@postgis.refractions.net>
Message-ID: <op.vvk46kax1ftthu@roarglch>
Content-Type: text/plain; charset=iso-8859-15;
format=flowed;
delsp=yes
On Mon, 16 May 2011 19:23:15 +0200, truongxuan quang
<
truongxuanqu...@yahoo.com>
wrote:
> Dear list
>
> I face with some problem in installation PostgreSQL 8.3
on winXP , long
> time
> before I use PostgreSQL and PostGIS for managing shape
file data. Last
> week I
> tried to install PostgreSQL 8.4, after that I remove
PostgreSQL 8.3 (I
> only
> uninstalled inside windows control panel/add and then I
delete all
> folder inside
> window programs) and I reinstall PostgreSQL 8.4, and
problem was
> starting happen
> from this step, until now, I could not connect data by
my user and
> password or
> start PostgreSQL8.4 service from Administrative Tools .
Even I tried to
> uninstall and reinstall for at least 20 times, delete
folder, remove
> user/password on Administrative Tools.
Hi Truongxuan,
I once had also a problem with a deinstallation of
PostgreSQL. I found that
script, It deletes everytthing what stays after the
deinstallation.
echo on
@REM
********************************************************************************
@REM
@REM NAME : Remove_PostgreSQL_Total.CMD
@REM
@REM DESCRIPTION : Entfernt vollst?ndig alle Verzeichnisse
und Eintr?ge
die durch
@REM die De-Installation von PostgreSQL
nicht entfernt
wurden.
@REM
@REM Diese Datei darf erst nach der
De-Installtion von
PostgreSQL
@REM gestartet werden. Sie mu? von dem User
ausgef?hrt
werden, unter
@REM dem die Installation von PostgreSQL
erfolgte.
Normalerweise ist
@REM das der Administrator unter Windows.
@REM
@REM Die Verzeichnisse beziehen sich auf
eine
PostgreSQL-Standard-
@REM Installation!
@REM
@REM
********************************************************************************
@REM
-------------------------------------------------------------
@REM Benutzerkonto, unter dem der
PostgreSQL-Datenbankserver l?uft
@REM
-------------------------------------------------------------
@set WIN_USER=postgres
@REM
================================================================================
NET USER %WIN_USER% /DELETE
rmdir /S /Q "%SystemDrive%\Dokumente und
Einstellungen\%USERNAME%\Anwendungsdaten\PostgreSQL"
rmdir /S /Q "%SystemDrive%\Dokumente und
Einstellungen\%WIN_USER%"
rmdir /S /Q "%ProgramFiles%\PostgreSQL"
Use this script AFTER the deinstallation of PostgreSQL as an
administrator
user.
maybe this helps.
with regards
Ren?
------------------------------
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
End of postgis-users Digest, Vol 109, Issue 15
**********************************************
