[postgis-users] Re: postgis-users Digest, Vol 32, Issue 52
orkun
temiz at deprem.gov.tr
Wed Jun 29 23:22:18 PDT 2005
postgis-users-request at postgis.refractions.net wrote:
>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. Re: PostGIS/Mapserver Mapfile Question (Stephen Woodbridge)
> 2. I need geo-database ? (orkun)
> 3. AW: [postgis-users] I need geo-database ? (Uwe Seher)
> 4. sql command to see layers ( J?rgen Mischker )
> 5. Re: sql command to see layers (Stephen Woodbridge)
> 6. JDBC and PostGIS (Gustavo Henrique Sberze Ribas)
> 7. Re: sql command to see layers ( J?rgen Mischker )
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Tue, 28 Jun 2005 19:39:46 -0400
>From: Stephen Woodbridge <woodbri at swoodbridge.com>
>Subject: Re: [postgis-users] PostGIS/Mapserver Mapfile Question
>To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
>Message-ID: <42C1DFC2.1020703 at swoodbridge.com>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>Don,
>
>Well I did not migrate the whole shebang. I started playing with postGIS
>v0.9 on a freeBSD server, then I loaded the v1.0 on the Windows XP
>laptop and I moved some selected tables using backup/restore (the
>postgis_restore.pl) so this is probably the root of my problem.
>
>In general, it seems like there should be a procedure the allows me to
>copy a table from one server to another even if it has geometry columns
>in it. I guess I need to look at the postgis_restore.pl and backup
>scripts and see what they are doing.
>
>There also seems to be a freeze on the freeBSD ports as non of the newer
>software releases have made it into the ports directory, so I am face
>with another problem of how to back port the database I now have built
>and working in postGIS v1.0 on XP back to the freeBSD postGIS v0.9. This
>will be easier in that I would drop the outdated database there and want
>to migrate the whole thing I have built on XP back to the freeBSD server.
>
>-Steve
>
>Don Drake wrote:
>
>
>>I just completed an upgrade of Postgres7.4/PostGIS0.9 -->
>>Postgres8.0.3/PostGIS1.0.1 this week using a backup and the
>>postgis_restore.pl script with no real problems.
>>
>>The geometry_columns table (and spatial_ref..) tables were backed up and
>>restored just fine for me.
>>
>>Did you backup/restore a single schema maybe?
>>
>>-Don
>>
>>-----Original Message-----
>>From: postgis-users-bounces at postgis.refractions.net
>>[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Stephen
>>Woodbridge
>>Sent: Tuesday, June 28, 2005 1:03 PM
>>To: PostGIS Users Discussion
>>Subject: Re: [postgis-users] PostGIS/Mapserver Mapfile Question
>>
>>Mark,
>>
>>Awesome, that worked great.
>>
>>So, what is the "correct" procedure if you want to move a table with
>>geometry from database to another. Obviously, backup/restore does not do
>>the "whole" thing.
>>
>>-Steve
>>
>>Mark Cave-Ayland wrote:
>>
>>
>>
>>>>-----Original Message-----
>>>>From: postgis-users-bounces at postgis.refractions.net
>>>>[mailto:postgis-users-bounces at postgis.refractions.net] On
>>>>Behalf Of Stephen Woodbridge
>>>>Sent: 28 June 2005 18:22
>>>>To: PostGIS Users Discussion
>>>>Subject: Re: [postgis-users] PostGIS/Mapserver Mapfile Question
>>>>
>>>>
>>>>OK, it looks like there are no entries in the geometry_columns table.
>>>>The zcta table is the only one that currently has a geometry column.
>>>>When I did the backup/restore, I did not save the
>>>>geometry_columns table
>>>>it there and easy way to regenerate this?
>>>>
>>>>-Steve
>>>>
>>>>
>>>
>>>Hi Steve,
>>>
>>>Sorry if it wasn't clear; the SQL given before should do that job for you.
>>>The corrected version is:
>>>
>>>BEGIN;
>>>CREATE TABLE old_geometry_columns WITH OIDS AS SELECT * FROM
>>>geometry_columns;
>>>DELETE FROM geometry_columns;
>>>SELECT probe_geometry_columns();
>>>COMMIT;
>>>
>>>
>>>You can probably delete the old_geometry_columns table once you're done,
>>>especially as in your case it was empty to begin with :)
>>>
>>>
>>>Kind regards,
>>>
>>>Mark.
>>>
>>>------------------------
>>>WebBased Ltd
>>>17 Research Way
>>>Tamar Science Park
>>>Plymouth
>>>PL6 8BT
>>>
>>>T: +44 (0)1752 797131
>>>F: +44 (0)1752 791023
>>>W: http://www.webbased.co.uk
>>>
>>>
>
>
>------------------------------
>
>Message: 2
>Date: Wed, 29 Jun 2005 10:39:03 +0300
>From: orkun <temiz at deprem.gov.tr>
>Subject: [postgis-users] I need geo-database ?
>To: postgis-users at postgis.refractions.net
>Message-ID: <42C25017.1090300 at deprem.gov.tr>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>hello
>
>I am new to postgis and geo-database.
>
>I want to know what db table containing geographic columns is more
>beneficial
>than conventional db table.
>
>For example as far as I know,
>In ESRI's shape file has a shape column. But it is closed to see the
>geometric shape with coordinates. And one can not query on real
>coordinates on table.
>
>Can you tell me more about the comparision of geo-table with
>conventiaonal table ?
>so I could say that I need geo-database and conventianal table (and
>ESRI' shape file)
>are not enough to carry out certain works.
>
>What does geo-table provide more than conventional-table does ?
>
>kind regards
>
>regards
>
>Ahmet Temiz
>
>______________________________________
>XamimeLT - installed on mailserver for domain @deprem.gov.tr
>Queries to: postmaster at deprem.gov.tr
>______________________________________
>The views and opinions expressed in this e-mail message are the sender's own
>and do not necessarily represent the views and the opinions of Earthquake Research Dept.
>of General Directorate of Disaster Affairs.
>
>Bu e-postadaki fikir ve gorusler gonderenin sahsina ait olup, yasal olarak T.C.
>B.I.B. Afet Isleri Gn.Mud. Deprem Arastirma Dairesi'ni baglayici nitelikte degildir.
>
>
>
>------------------------------
>
>Message: 3
>Date: Wed, 29 Jun 2005 10:47:08 +0200
>From: "Uwe Seher" <uwe.seher at arteng.de>
>Subject: AW: [postgis-users] I need geo-database ?
>To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
>Message-ID: <LHEAIANPDGBGBPEBEBMGCENKCAAA.uwe.seher at arteng.de>
>Content-Type: text/plain; charset="iso-8859-1"
>
>Hello!
>
>
>
>>I am new to postgis and geo-database.
>>
>>
>
>Welcome in a fascinating new world ;)
>
>
>
>>In ESRI's shape file has a shape column. But it is closed to see the
>>geometric shape with coordinates. And one can not query on real
>>coordinates on table.
>>
>>
>
>In the Shape-column are the coordinates of the geometry in a binary format.
>I think it is something (or it is) like WKB-format from PostGIS. You can
>access the coordinates and objects in the shape-column by programming in
>Arcobjects.
>
>
>
>>Can you tell me more about the comparision of geo-table with
>>conventiaonal table ?
>>
>>
>
>The difference is only the geometry-column where the geometry is stored.
>With this Field you can make some geoprocessing functions directly in the
>database and you dont have to bother ArcGIS ;).
>
>
>
>>so I could say that I need geo-database and conventianal table (and
>>ESRI' shape file)
>>are not enough to carry out certain works.
>>
>>
>
>No, in theory you need only a geodatabase table (or a view) with a
>geometry-field. You can handle it as a common db-table.
>In the real world you get some problems, because ArcGIS doesnt process the
>PostGIS-Formt. But ther is the pgArc-extension on sourcforge and myself is
>working on something comparable.
>
>
>
>>What does geo-table provide more than conventional-table does ?
>>
>>
>
>the geometry-field. And PostGIS some additional Functionality. Geo-tables in
>MySQL for example can only handle the geometry without functionality.
>
>
>
>>kind regards
>>
>>regards
>>
>>Ahmet Temiz
>>
>>
>
>Greetings
>
>Uwe Seher
>
>
>
>
>>-----Ursprüngliche Nachricht-----
>>Von: postgis-users-bounces at postgis.refractions.net
>>[mailto:postgis-users-bounces at postgis.refractions.net]Im Auftrag von
>>orkun
>>Gesendet: Mittwoch, 29. Juni 2005 09:39
>>An: postgis-users at postgis.refractions.net
>>Betreff: [postgis-users] I need geo-database ?
>>
>>
>>hello
>>
>>I am new to postgis and geo-database.
>>
>>I want to know what db table containing geographic columns is more
>>beneficial
>>than conventional db table.
>>
>>For example as far as I know,
>>
>>Can you tell me more about the comparision of geo-table with
>>conventiaonal table ?
>>
>>
>>______________________________________
>>XamimeLT - installed on mailserver for domain @deprem.gov.tr
>>Queries to: postmaster at deprem.gov.tr
>>______________________________________
>>The views and opinions expressed in this e-mail message are the
>>sender's own
>>and do not necessarily represent the views and the opinions of
>>Earthquake Research Dept.
>>of General Directorate of Disaster Affairs.
>>
>>Bu e-postadaki fikir ve gorusler gonderenin sahsina ait olup,
>>yasal olarak T.C.
>>B.I.B. Afet Isleri Gn.Mud. Deprem Arastirma Dairesi'ni baglayici
>>nitelikte degildir.
>>
>>_______________________________________________
>>postgis-users mailing list
>>postgis-users at postgis.refractions.net
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
>____________
>Virus checked by G DATA AntiVirusKit
>
>
>
>------------------------------
>
>Message: 4
>Date: Wed, 29 Jun 2005 16:37:19 +0200
>From: " J?rgen Mischker " <juergen.mischker at boku.ac.at>
>Subject: [postgis-users] sql command to see layers
>To: <postgis-users at postgis.refractions.net>
>Message-ID: <s2c2ce47.062 at gwdata.boku.ac.at>
>Content-Type: text/plain; charset=ISO-8859-1
>
>I am looking for a sql command that shows only the (geog.) layers in a postgis database.
>
>also: a php class doing the same thing would be a big help. I found a postgis php class @ http://phpclasses.byting.at/browse/package/2039.html, but this particular function is missing.
>
>Cheers for help
>juergen
>
>DI Jürgen Mischker
>Insitut f. Vermessung, Fernerkundung und Landinformation,
>Universität für Bodenkultur, BOKU, Wien
>Institute of Surveying, Remote Sensing and Land Information.
>University of Natural Resources and Applied Life Science, Vienna.
>Tel.: +43 1 47654-5132
>Fax.: +43 1 47654-5142
>email: jmischker at boku.ac.at
>
>
>
>------------------------------
>
>Message: 5
>Date: Wed, 29 Jun 2005 10:43:34 -0400
>From: Stephen Woodbridge <woodbri at swoodbridge.com>
>Subject: Re: [postgis-users] sql command to see layers
>To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
>Message-ID: <42C2B396.7020104 at swoodbridge.com>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>You might try "select * from geometry_columns;"
>
>-Steve W
>
>Jürgen Mischker wrote:
>
>
>>I am looking for a sql command that shows only the (geog.) layers in a postgis database.
>>
>>also: a php class doing the same thing would be a big help. I found a postgis php class @ http://phpclasses.byting.at/browse/package/2039.html, but this particular function is missing.
>>
>>Cheers for help
>>juergen
>>
>>DI Jürgen Mischker
>>Insitut f. Vermessung, Fernerkundung und Landinformation,
>>Universität für Bodenkultur, BOKU, Wien
>>Institute of Surveying, Remote Sensing and Land Information.
>>University of Natural Resources and Applied Life Science, Vienna.
>>Tel.: +43 1 47654-5132
>>Fax.: +43 1 47654-5142
>>email: jmischker at boku.ac.at
>>
>>_______________________________________________
>>postgis-users mailing list
>>postgis-users at postgis.refractions.net
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>
>
>
>
>------------------------------
>
>Message: 6
>Date: Wed, 29 Jun 2005 11:59:21 -0300
>From: "Gustavo Henrique Sberze Ribas" <gribas at cpqd.com.br>
>Subject: [postgis-users] JDBC and PostGIS
>To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
>Message-ID:
> <E6F2049DCBE10840B22DC64587E6F3EC08EB9B at MAILSRV1.aquarius.cpqd.com.br>
>Content-Type: text/plain; charset="iso-8859-1"
>
>Hi,
>
> I'm having some issues while trying to use PreparedStatements
>to query a PostGIS database... I can't make it work :(
>
> I've added the geometric type entries as usual:
>
>((org.postgresql.PGConnection)conn).addDataType("geometry",org.postgis.PGgeometry.class);
>((org.postgresql.PGConnection)conn).addDataType("box3d",org.postgis.PGbox3d.class);
>
> And tried this simple insert query:
>
> Point p = new Point(-47.12, -22.374);
> p.setSrid(4326);
>
> PreparedStatement ps = conn.prepareStatement("INSERT INTO jdbc_test(geom,id) VALUES(?,?)");
>--> ps.setObject(1, p); // replaces first "?" so geom = Point(-47.12, -22.374)
> ps.setInt(2, 1); // replaces second "?" so id = 1
> ps.executeUpdate();
>
> It crashes giving a PSQLException saying it couldn't find the appropriate type.
>So I tried the following, with no sucess either:
>
> ps.setObject(1, p, java.sql.Types.OTHER); // can't convert Point to Types.OTHER
> ps.setObject(1, p, conn.getSQLType("geometry")); // can't convert Point to Types.OTHER
> ps.setObject(1, p, conn.getPGType("geometry")); // Unsuported value: 72.190
> ps.setObject(1, p, Geometry.POINT); // ERROR: column "geom" is of type geometry but
> // expression is of type character
> ps.setObject(1, p, p.type); // ERROR: column "geom" is of type geometry but
> // expression is of type character
> ps.setString(1, p.toString()); // ERROR: column "geom" is of type geometry but
> ^^^^^^ // expression is of type character
>
>
> Any thoughts ? I've attached a java program based on
>TestServer.java that implements this small test.
>
>
>System Info:
>
> PostgreSQL 8.0.3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)
> POSTGIS="1.0.1" GEOS="2.1.1" PROJ="Rel. 4.4.9, 29 Oct 2004" USE_STATS DBPROC="0.3.0" RELPROC="0.3.0"
> PGDrivers: postgresql-8.0-311.jdbc3.jar (last stable release)
> postgis_1_0_0.jar (came with windows installer)
> java version "1.5.0_03"
>
>
>Thanks,
>Gustavo
>-------------- next part --------------
>A non-text attachment was scrubbed...
>Name: Test.java
>Type: application/octet-stream
>Size: 3680 bytes
>Desc: Test.java
>Url : http://lists.refractions.net/pipermail/postgis-users/attachments/20050629/003e6715/Test-0001.obj
>
>------------------------------
>
>Message: 7
>Date: Wed, 29 Jun 2005 17:17:29 +0200
>From: " J?rgen Mischker " <juergen.mischker at boku.ac.at>
>Subject: Re: [postgis-users] sql command to see layers
>To: <postgis-users at postgis.refractions.net>
>Message-ID: <s2c2d7b6.035 at gwdata.boku.ac.at>
>Content-Type: text/plain; charset=ISO-8859-1
>
>thanks steve, nice and too easy...
>
>i use the postgis_class_inc.php and came up with the following php code the get my feature list:
>
> include("postgis_class_inc.php");
> $pg = new postgis();
> $pg->connect("novisad");
> $pg->exec("select array(select f_table_name from geometry_columns)");
> $rs = $pg->farray();
> print_r($rs);
>
>but the output in my browser is correct but pretty ugly:
>
>Array ( [0] => {judenburg,tracks,rivers,trattenbachdem} [?column?] => {judenburg,tracks,rivers,trattenbachdem} )
>
>any hints?
>juergen
>
>DI Jürgen Mischker
>Insitut f. Vermessung, Fernerkundung und Landinformation,
>Universität für Bodenkultur, BOKU, Wien
>Institute of Surveying, Remote Sensing and Land Information.
>University of Natural Resources and Applied Life Science, Vienna.
>Tel.: +43 1 47654-5132
>Fax.: +43 1 47654-5142
>email: jmischker at boku.ac.at
>
>
>
>------------------------------
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>End of postgis-users Digest, Vol 32, Issue 52
>*********************************************
>
>
>
>
I have one more question.
Supposing, I had a polygon field in postgis table and wanted to
connect it to my favorite gis program (GRASS).
Will I able to see these polygons on grass's (view) monitor ?
or in reverse direction
is it possible to transfer polygons from grass to postgis
to hold polygons in a polygon field.
(Thank you Uwe, Your explanations were really comprehensive.)
regards
Ahmet Temiz
______________________________________
XamimeLT - installed on mailserver for domain @deprem.gov.tr
Queries to: postmaster at deprem.gov.tr
______________________________________
The views and opinions expressed in this e-mail message are the sender's own
and do not necessarily represent the views and the opinions of Earthquake Research Dept.
of General Directorate of Disaster Affairs.
Bu e-postadaki fikir ve gorusler gonderenin sahsina ait olup, yasal olarak T.C.
B.I.B. Afet Isleri Gn.Mud. Deprem Arastirma Dairesi'ni baglayici nitelikte degildir.
More information about the postgis-users
mailing list