[postgis-users] Re : postgis-users Digest, Vol 48, Issue 12

Obe, Regina robe.dnd at cityofboston.gov
Tue Oct 17 14:58:52 PDT 2006


Tamir,
 
When you are using psql how are you creating and loading the data?  I'm trying to visualize it, but don't quite get it.
 
Whenever I use psql for loading data, I'm usually loading from an sql file like
psql -d gisdb -h localhost -U postgres -f mydata.sql 

 

in that situation, I would think more does not come into play since I'm not clicking the more button.

 

When dumping data, I just use the pg_dump

something like

pg_dump -h localhost -U postgres -f myfile.sql -t mytable

 


 

________________________________

From: postgis-users-bounces at postgis.refractions.net on behalf of Tahir Tamba
Sent: Tue 10/17/2006 3:58 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Re : postgis-users Digest, Vol 48, Issue 12



Dear Mark and Regina,

Thank you for your answers. Mark you're probably right because I've done the test to verify if  'more.exe'  exists in my Win32 System, unfortunatelly it's out of the Win32 System directory. Probably this issue causes the lack of Postgres configuration for better using psql terminal for creating and loading data in PostGIS. So I'm wondering how to come over this issue.
For instance I'm using PGAdmin to create and load data in the server, as suggest Regina, but I get  many data files with more 1000 records so psql is better for this to use the pg_dump function

Thank again
Best regards

Tahir Tamba
MSc. Géographie
Aménagement du territoire et SIG/ Gestion et conservation des ressources naturelles
Télédétection-cartographie écologique, caractérisation des milieux humides
Tel: (514) 526-7543
Courriel: tamba.tahir at courrier.uqam.ca
---------------------------------------------------------
Tahir Tamba
MSc. Geography
Urban planning and GIS specialist/Natural resources management and conservation
Remote-sensing-ecological mapping and wetland monitoring and Characterization
Tel: (514) 526-7543
E-mail: tamba.tahir at courrier.uqam.ca



----- Message d'origine -----
De: postgis-users-request at postgis.refractions.net
Date: Vendredi, Octobre 13, 2006 3:00 pm
Objet: postgis-users Digest, Vol 48, Issue 12

> Send postgis-users mailing list submissions to
>       postgis-users at 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-request at postgis.refractions.net
>
> You can reach the person managing the list at
>       postgis-users-owner at 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. kmeans/natural breaks returns R_HOME error when  called
>      (Jeff Cavner)
>   2. Re: kmeans/natural breaks returns R_HOME error when      called
>      (David William Bitner)
>   3. Re: kmeans/natural breaks returns R_HOME error when      called
>      (David William Bitner)
>   4. PostGIS configuration on WinXP issue using psql  terminal
>      (Tahir Tamba)
>   5. Re: PostGIS configuration on WinXP issue using   psql terminal
>      (Mark Cave-Ayland)
>   6. RE: PostGIS configuration on WinXP issue using   psqlterminal
>      (Obe, Regina)
>   7. Re: Error Message Importing Into PostgreSQL (Guglielmo Raimondi)
>   8. Anti-meridian and polar polygon question, 2006 (thegis)
>
>
> -------------------------------------------------------------------
> ---
>
> Message: 1
> Date: Thu, 12 Oct 2006 14:09:52 -0600
> From: "Jeff Cavner" <jcavner at edac.unm.edu>
> Subject: [postgis-users] kmeans/natural breaks returns R_HOME error
>       when    called
> To: <postgis-users at postgis.refractions.net>
> Message-ID: <200610122013.k9CKDI1l000812 at saturn.unm.edu>
> Content-Type: text/plain; charset="us-ascii"
>
> In a post for March 2006 David Bitner had a nifty SQL function
> using plr for
> natural breaks.  I have successfully installed R and plr in
> postgress and
> created the function in my database but when called with select
> kmeans(array[1,1,1,1,4,3,5,6,45,3,5,7,8,6,4,3,2,1,32,6,7,5,6,7,8],4);  to
> test it , it reports  ERROR:  environment variable R_HOME not defined
>
>
>
> I have noticed that when I run R from the command line I get the line
> ignoring the R_HOME variable.  When installing plr, I had problems
> with the
> make file finding R.h.  R.h lives in /usr/local/lib/R/include. 
> But when I
> looked at the plr makefile I noticed it was concatenating an extra
> /includeonto the path.  So I set R_HOME using export
> R_HOME=/usr/local/lib/R (one
> directory up from the actual location of R.h)  since running my
> sql call to
> the kmeans function I have changed R_HOME back to the actual
> location of
> R.h.  No path setting for R_HOME seems to allow me to call the kmeans
> function.  Each returns the same R_HOME error. Does any body know
> whereR_HOME is actually supposed to be set,e.g. to  the R.h, the
> .so, the /bin?
> And if anyone has had this problem why R_HOME works for the plr
> install but
> not the actual execution of the function kmeans?
>
>
>
> Jeff Cavner
>
> Earth Data Analysis Center
>
> University of New Mexico
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://lists.refractions.net/pipermail/postgis-
> users/attachments/20061012/aba2def5/attachment-0001.html
>
> ------------------------------
>
> Message: 2
> Date: Thu, 12 Oct 2006 15:39:22 -0500
> From: "David William Bitner" <bitner at gyttja.org>
> Subject: Re: [postgis-users] kmeans/natural breaks returns R_HOME
>       error when      called
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Message-ID:
>       <d2f53e190610121339nd59f416w3e64d38f3dcfc37e at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> I don't quite remember the details too much, but I think that you
> need to
> have R_HOME declared at the time you start postmaster, so if you
> changeR_HOME, you need to restart postmaster as well.
>
> David
>
> On 10/12/06, Jeff Cavner <jcavner at edac.unm.edu> wrote:
> >
> >  In a post for March 2006 David Bitner had a nifty SQL function
> using plr
> > for natural breaks.  I have successfully installed R and plr in
> postgress> and created the function in my database but when called
> with select
> >
> kmeans(array[1,1,1,1,4,3,5,6,45,3,5,7,8,6,4,3,2,1,32,6,7,5,6,7,8],4);  to
> > test it , it reports  ERROR:  environment variable R_HOME not
> defined>
> >
> >
> > I have noticed that when I run R from the command line I get the
> line> ignoring the R_HOME variable.  When installing plr, I had
> problems with the
> > make file finding R.h.  R.h lives in /usr/local/lib/R/include. 
> But when I
> > looked at the plr makefile I noticed it was concatenating an
> extra /include
> > onto the path.  So I set R_HOME using export
> R_HOME=/usr/local/lib/R (one
> > directory up from the actual location of R.h)  since running my
> sql call
> > to the kmeans function I have changed R_HOME back to the actual
> location of
> > R.h.  No path setting for R_HOME seems to allow me to call the
> kmeans> function.  Each returns the same R_HOME error. Does any
> body know where
> > R_HOME is actually supposed to be set,e.g. to  the R.h, the .so, the
> > /bin?   And if anyone has had this problem why R_HOME works for
> the plr
> > install but not the actual execution of the function kmeans?
> >
> >
> >
> > Jeff Cavner
> >
> > Earth Data Analysis Center
> >
> > University of New Mexico
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> >
>
>
> --
> ************************************
> David William Bitner
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://lists.refractions.net/pipermail/postgis-
> users/attachments/20061012/82a3d192/attachment-0001.html
>
> ------------------------------
>
> Message: 3
> Date: Thu, 12 Oct 2006 16:01:13 -0500
> From: "David William Bitner" <david.bitner at gmail.com>
> Subject: Re: [postgis-users] kmeans/natural breaks returns R_HOME
>       error when      called
> To: jcavner at edac.unm.edu,     "PostGIS Users Discussion"
>       <postgis-users at postgis.refractions.net>
> Message-ID:
>       <d2f53e190610121401t390f4852r47741260808aa8a at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> I don't quite remember the details too much, but I think that you
> need to
> have R_HOME declared at the time you start postmaster, so if you
> changeR_HOME, you need to restart postmaster as well.
>
> David
>
> On 10/12/06, Jeff Cavner <jcavner at edac.unm.edu> wrote:
>
> >  In a post for March 2006 David Bitner had a nifty SQL function
> using plr
> > for natural breaks.  I have successfully installed R and plr in
> postgress> and created the function in my database but when called
> with select
> >
> kmeans(array[1,1,1,1,4,3,5,6,45,3,5,7,8,6,4,3,2,1,32,6,7,5,6,7,8],4);  to
> > test it , it reports  ERROR:  environment variable R_HOME not
> defined>
> >
> >
> > I have noticed that when I run R from the command line I get the
> line> ignoring the R_HOME variable.  When installing plr, I had
> problems with the
> > make file finding R.h.  R.h lives in /usr/local/lib/R/include. 
> But when I
> > looked at the plr makefile I noticed it was concatenating an
> extra /include
> > onto the path.  So I set R_HOME using export
> R_HOME=/usr/local/lib/R (one
> > directory up from the actual location of R.h)  since running my
> sql call
> > to the kmeans function I have changed R_HOME back to the actual
> location of
> > R.h.  No path setting for R_HOME seems to allow me to call the
> kmeans> function.  Each returns the same R_HOME error. Does any
> body know where
> > R_HOME is actually supposed to be set,e.g. to  the R.h, the .so, the
> > /bin?   And if anyone has had this problem why R_HOME works for
> the plr
> > install but not the actual execution of the function kmeans?
> >
> >
> >
> > Jeff Cavner
> >
> > Earth Data Analysis Center
> >
> > University of New Mexico
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> >
>
>
> --
> ************************************
> David William Bitner
>
> --
> ************************************
> David William Bitner
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://lists.refractions.net/pipermail/postgis-
> users/attachments/20061012/65c3901b/attachment-0001.html
>
> ------------------------------
>
> Message: 4
> Date: Thu, 12 Oct 2006 17:40:30 -0400
> From: Tahir Tamba <tamba.tahir at courrier.uqam.ca>
> Subject: [postgis-users] PostGIS configuration on WinXP issue using
>       psql    terminal
> To: postgis-users at postgis.refractions.net
> Message-ID: <498c80492983.452e7e0e at courrier.uqam.ca>
> Content-Type: text/plain; charset="us-ascii"
>
> An HTML attachment was scrubbed...
> URL: http://lists.refractions.net/pipermail/postgis-
> users/attachments/20061012/ccdffec0/attachment-0001.html
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: tamba.tahir.vcf
> Type: text/x-vcard
> Size: 226 bytes
> Desc: Card for Tahir Tamba <tamba.tahir at courrier.uqam.ca>
> Url : http://lists.refractions.net/pipermail/postgis-
> users/attachments/20061012/ccdffec0/tamba.tahir-0001.vcf
>
> ------------------------------
>
> Message: 5
> Date: Fri, 13 Oct 2006 07:27:42 +0100
> From: Mark Cave-Ayland <mark.cave-ayland at ilande.co.uk>
> Subject: Re: [postgis-users] PostGIS configuration on WinXP issue
>       using   psql terminal
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID: <1160720862.5483.5.camel at mca-desktop>
> Content-Type: text/plain; charset=utf-8
>
> On Thu, 2006-10-12 at 17:40 -0400, Tahir Tamba wrote:
> > Dear all,
> >
> > I'm a newby to PostGis and I'm getting some difficulties to
> setting up
> > PostGis using the psql terminal. I installed Windows 8.1.4 compiled
> > version from Postgres and Windows 1.1.3 compiled version from
> > PostGIS.
> > Using the example presented by Refractions on the document titled
> > "Introduction to PostGIS" refering on how to create a table
> using psl
> > terminal I get the following error:
> >
> >
> > Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
> >
> > Type:  \copyright for distribution terms
> >         \h for help with SQL commands
> >         \? for help with psql commands
> >         \g or terminate with semicolon to execute query
> >         \q to quit
> >
> > Warning: Console code page (850) differs from Windows code page
> > (1252)
> >           8-bit characters may not work correctly. See psql
> reference
> >           page "Notes for Windows users" for details.
> >
> >
> > postgres=# \c postgis
> > You are now connected to database "postgis".
> > postgis=# create table points ( pt geometry, name varchar );
> > CREATE TABLE
> > postgis=# insert into points values ( 'POINT(0 0)', 'Origin' );
> > INSERT 0 1
> > postgis=# insert into points values ( 'POINT(5 0)', 'X Axis' );
> > INSERT 0 1
> > postgis=# insert into points values ( 'POINT(0 5)', 'Y Axis' );
> > INSERT 0 1
> > postgis=# select name, AsText (pt), Distance (pt, 'POINT(5 5) ')
>
> > from points;
> > 'more' n'est pas reconnu en tant que commande interne
> > ou externe, un programme ex??cutable ou un fichier de commandes.
> > postgis=#
> >
> >
> > I have been told that the psql terminal is configured to use the
> > pager, 'more', so I should turn it off. Running the the following
> > command on psql : \pset pager  the terminal noticed that pager is
> > setted to Off.
> >
> > Any help about this issue would be appreciated.
> >
> > Regards
> >
> > Tahir Tamba
>
>
> Hi Tahir,
>
> (This is actually a PostgreSQL issue rather than a PostGIS issue since
> you will see the same problem regardless of whether you query is
> spatialin nature or not)
>
> This sounds like a broken installation of Windows - more.exe is
> suppliedas part of a standard WinXP installation, and on my system
> can be found
> in C:\WINDOWS\SYSTEM32. Could it be a permissions problem that is
> preventing you from seeing the file? A good test would be to use the
> Start Menu and navigate to Programs -> PostgreSQL 8.1 -> command
> promptand then try and bring up the more.exe help screen by
> typing: more /?
>
>
> Kind regards,
>
> Mark.
>
>
>
>
> ------------------------------
>
> Message: 6
> Date: Fri, 13 Oct 2006 02:32:18 -0400
> From: "Obe, Regina" <robe.dnd at cityofboston.gov>
> Subject: RE: [postgis-users] PostGIS configuration on WinXP issue
>       using   psqlterminal
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Message-ID:
>       <53F9CF533E1AA14EA1F8C5C08ABC08D20CBA04 at ZDND.DND.boston.cob>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Have you tried using the PgAdmin tool that comes prepackaged with
> the PostGreSQL installation.  I find it in general a bit easier to
> use than psql and limit my psql use for automated jobs, loading of
> sql batch files and things of that sort.
>
> At the very list if you run into similar problems using the
> PgAdmin query tool part, it may give you more clues as to what is
> wrong with your install.
>
> Regina
>
> ________________________________
>
> From: postgis-users-bounces at postgis.refractions.net on behalf of
> Tahir Tamba
> Sent: Thu 10/12/2006 5:40 PM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] PostGIS configuration on WinXP issue
> using psqlterminal
>
>
>
> Dear all,
>
> I'm a newby to PostGis and I'm getting some difficulties to
> setting up PostGis using the psql terminal. I installed Windows
> 8.1.4 compiled version from Postgres and Windows 1.1.3 compiled
> version from PostGIS.
> Using the example presented by Refractions on the document titled
> "Introduction to PostGIS" refering on how to create a table using
> psl terminal I get the following error:
>
>
> Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
>
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help with psql commands
>        \g or terminate with semicolon to execute query
>        \q to quit
>
> Warning: Console code page (850) differs from Windows code page
> (1252)
>          8-bit characters may not work correctly. See psql
> reference
>          page "Notes for Windows users" for details.
>
>
> postgres=# \c postgis
> You are now connected to database "postgis".
> postgis=# create table points ( pt geometry, name varchar );
> CREATE TABLE
> postgis=# insert into points values ( 'POINT(0 0)', 'Origin' );
> INSERT 0 1
> postgis=# insert into points values ( 'POINT(5 0)', 'X Axis' );
> INSERT 0 1
> postgis=# insert into points values ( 'POINT(0 5)', 'Y Axis' );
> INSERT 0 1
> postgis=# select name, AsText (pt), Distance (pt, 'POINT(5 5) ') 
> from points;
> 'more' n'est pas reconnu en tant que commande interne
> ou externe, un programme ex?cutable ou un fichier de commandes.
> postgis=#
>
>
> I have been told that the psql terminal is configured to use the
> pager, 'more', so I should turn it off. Running the the following
> command on psql : \pset pager  the terminal noticed that pager is
> setted to Off.
>
> Any help about this issue would be appreciated.
>
> Regards
>
> Tahir Tamba
> MSc. G?ographie
> Am?nagement du territoire et SIG/ Gestion et conservation des
> ressources naturelles
> T?l?d?tection-cartographie ?cologique, caract?risation des milieux
> humides
> Tel: (514) 526-7543
> Courriel: tamba.tahir at courrier.uqam.ca
> ---------------------------------------------------------
> Tahir Tamba
> MSc. Geography
> Urban planning and GIS specialist/Natural resources management and
> conservation
> Remote-sensing-ecological mapping and wetland monitoring and
> Characterization
> Tel: (514) 526-7543
> E-mail: tamba.tahir at courrier.uqam.ca
>
>
>
>
>
>
>
>
> -----------------------------------------
> The substance of this message, including any attachments, may be
> confidential, legally
> privileged and/or exempt from disclosure pursuant to Massachusetts
> law. It is intended
> solely for the addressee. If you received this in error, please
> contact the sender and
> delete the material from any computer.
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: not available
> Type: application/ms-tnef
> Size: 5988 bytes
> Desc: not available
> Url : http://lists.refractions.net/pipermail/postgis-
> users/attachments/20061013/7773fd46/attachment-0001.bin
>
> ------------------------------
>
> Message: 7
> Date: Fri, 13 Oct 2006 10:02:46 +0200
> From: "Guglielmo Raimondi" <g.raimondi at glasic.it>
> Subject: Re: [postgis-users] Error Message Importing Into PostgreSQL
> To: <postgis-users at postgis.refractions.net>
> Cc: 'Adriana Tanfara' <ada.malizmaj at gmail.com>
> Message-ID: <20061013080109.45F922C04C7 at netnation.refractions.net>
> Content-Type: text/plain; charset="windows-1250"
>
> For the conversion part, you can also use the open source tool
> DXF2PostGIS,available on SourceForge (HYPERLINK
> "http://sourceforge.net/projects/dxf2postgis/"http://sourceforge.net/project
> s/dxf2postgis/).
>
> Regards,
>
>  Guglielmo Raimondi
>
> ------------------------------
> Message: 3
> Date: Thu, 12 Oct 2006 17:17:04 +0200
> From: "Adriana Tanfara" <ada.malizmaj at gmail.com>
> Subject: [postgis-users] Error Message Importing Into PostgreSQL
> To: postgis-users at postgis.refractions.net
> Message-ID:
> <6012312e0610120817i44dac64eofc8c94dc38334c07 at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
> Hi to all!
> I am beginner whit working with HostGIS Linux and MapServer.I
> managed to
> convert dwg from AutoCad Map to shape files.Then shape files to sql!
> I try to get my sql data into PostGIS/PostgreSQLdatabase but i got
> thiserror message:
> ERROR: could not access file "$libdir/liblwgeom.so.1.0": No such file
> or directory
> Can anyone help?
> thanks
> Adriana
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.408 / Virus Database: 268.13.3/473 - Release Date:
> 12/10/2006
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://lists.refractions.net/pipermail/postgis-
> users/attachments/20061013/bf285417/attachment-0001.html
>
> ------------------------------
>
> Message: 8
> Date: Fri, 13 Oct 2006 12:56:10 +0200
> From: thegis <thegis at googlemail.com>
> Subject: [postgis-users] Anti-meridian and polar polygon question,
>       2006
> To: postgis-users at postgis.refractions.net
> Message-ID:
>       <169fc830610130356o33302971ife1b758bc2b851e8 at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi everyone!
>
> I found this 2 year old thread about handling polar coordinates with
> PostGIS: http://postgis.refractions.net/pipermail/postgis-
> users/2004-October/006006.html
>
>
> Does anyone know if support for pole encompassing polygons been
> improvedsince then? What about geocentric coordinate systems (e.g.
> EPSG 4978)?
>
> Thanks,
> Torsten
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://lists.refractions.net/pipermail/postgis-
> users/attachments/20061013/b464f613/attachment-0001.html
>
> ------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> End of postgis-users Digest, Vol 48, Issue 12
> *********************************************
>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061017/3cf15052/attachment.html>


More information about the postgis-users mailing list