<div>Regina,</div>
<div> thank you for you valuable information, it works.</div>
<div> At the same time there is another way to get the exact point coordinates as the following:</div>
<div> select *,point(the_geom) from pt_gsqy_point;<br><br></div>
<div class="gmail_quote">On Tue, Jul 1, 2008 at 3:00 AM, <<a href="mailto:postgis-devel-request@postgis.refractions.net">postgis-devel-request@postgis.refractions.net</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Send postgis-devel mailing list submissions to<br> <a href="mailto:postgis-devel@postgis.refractions.net">postgis-devel@postgis.refractions.net</a><br>
<br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-devel" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-devel</a><br>
or, via email, send a message with subject or body 'help' to<br> <a href="mailto:postgis-devel-request@postgis.refractions.net">postgis-devel-request@postgis.refractions.net</a><br><br>You can reach the person managing the list at<br>
<a href="mailto:postgis-devel-owner@postgis.refractions.net">postgis-devel-owner@postgis.refractions.net</a><br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of postgis-devel digest..."<br>
<br><br>Today's Topics:<br><br> 1. shp2pgsql using problem (zhengyong zhang)<br> 2. RE: shp2pgsql using problem (Obe, Regina)<br> 3. PostGIS bugtracker email notifications (Mark Cave-Ayland)<br><br><br>----------------------------------------------------------------------<br>
<br>Message: 1<br>Date: Mon, 30 Jun 2008 16:05:10 +0800<br>From: "zhengyong zhang" <<a href="mailto:shieldly@gmail.com">shieldly@gmail.com</a>><br>Subject: [postgis-devel] shp2pgsql using problem<br>To: <a href="mailto:postgis-devel@postgis.refractions.net">postgis-devel@postgis.refractions.net</a><br>
Message-ID:<br> <<a href="mailto:d7f039270806300105p70e9fe82sb2cd591ef129a12@mail.gmail.com">d7f039270806300105p70e9fe82sb2cd591ef129a12@mail.gmail.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br>
<br>when I'm trying to use shp2pgsql to convert a shp file into postgresql.<br>as I do it using the following commands:<br>1, shp2pgsql pt_gsqy_point.shp pt_gsqy_point > pt_gsqy_point.sql<br>2, psql -d postgis -f pt_gsqy_point.sql >log.txt<br>
after I run the first command, and I got sql script file:<br>the content is :<br>BEGIN;<br>CREATE TABLE "pt_gsqy_point" (gid serial PRIMARY KEY,<br>"name" varchar(40));<br>SELECT AddGeometryColumn('','pt_gsqy_point','the_geom','-1','POINT',2);<br>
INSERT INTO "pt_gsqy_point" ("name",the_geom) VALUES ('the first location<br>name','010100000085EC6F9141E2C5C0E829EE9F0AC98240');<br>INSERT INTO "pt_gsqy_point" ("name",the_geom) VALUES ('the second location<br>
name','0101000000CCFE346E05B4C5C0A9A946F9A30D8640');<br>.....<br>...<br>etc...<br><br>and after I run the second command, in the pgadmin, I got to see the values<br>in it. but the geometry values can not be used directly, as the values are<br>
those : '010100000085EC6F9141E2C5C0E829EE9F0AC98240',<br>anyone in the mailist have used the shp2pgsql.exe???<br>how to deal with it, so that I can use those point coordinates to do some<br>operations, such as select a point using the point coordinate to get the<br>
name of it.<br><br><br>--<br>Zhengyong Zhang<br>ECNU CS<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://lists.refractions.net/pipermail/postgis-devel/attachments/20080630/cf8997ac/attachment-0001.html" target="_blank">http://lists.refractions.net/pipermail/postgis-devel/attachments/20080630/cf8997ac/attachment-0001.html</a><br>
<br>------------------------------<br><br>Message: 2<br>Date: Mon, 30 Jun 2008 08:18:09 -0400<br>From: "Obe, Regina" <<a href="mailto:robe.dnd@cityofboston.gov">robe.dnd@cityofboston.gov</a>><br>Subject: RE: [postgis-devel] shp2pgsql using problem<br>
To: "PostGIS Development Discussion"<br> <<a href="mailto:postgis-devel@postgis.refractions.net">postgis-devel@postgis.refractions.net</a>><br>Message-ID:<br> <53F9CF533E1AA14EA1F8C5C08ABC08D2044CD15D@ZDND.DND.boston.cob><br>
Content-Type: text/plain; charset="us-ascii"<br><br>Zhengyong,<br><br>shp2pgsql dumps out in binary format to compensate for floating point<br>issues with dumping out in WKT text.<br><br>If you just want to see what the geometries look like as text from<br>
PostgreSQL - you can do<br><br>SELECT ST_AsText(the_geom) from pt_gsqy_point limit 1;<br><br>If you want to dump out your sql as WKT text instead of the default<br>binary for some reason then you can use the -w switch<br>
<br>shp2pgsql -w pt_gsqy_point.shp pt_gsqy_point > pt_gsqy_point.sql<br><br>Hope that helps,<br>Regina<br><br><br>________________________________<br><br>From: <a href="mailto:postgis-devel-bounces@postgis.refractions.net">postgis-devel-bounces@postgis.refractions.net</a><br>
[mailto:<a href="mailto:postgis-devel-bounces@postgis.refractions.net">postgis-devel-bounces@postgis.refractions.net</a>] On Behalf Of<br>zhengyong zhang<br>Sent: Monday, June 30, 2008 4:05 AM<br>To: <a href="mailto:postgis-devel@postgis.refractions.net">postgis-devel@postgis.refractions.net</a><br>
Subject: [postgis-devel] shp2pgsql using problem<br><br><br>when I'm trying to use shp2pgsql to convert a shp file into postgresql.<br>as I do it using the following commands:<br>1, shp2pgsql pt_gsqy_point.shp pt_gsqy_point > pt_gsqy_point.sql<br>
2, psql -d postgis -f pt_gsqy_point.sql >log.txt<br>after I run the first command, and I got sql script file:<br>the content is :<br>BEGIN;<br>CREATE TABLE "pt_gsqy_point" (gid serial PRIMARY KEY,<br>"name" varchar(40));<br>
SELECT AddGeometryColumn('','pt_gsqy_point','the_geom','-1','POINT',2);<br>INSERT INTO "pt_gsqy_point" ("name",the_geom) VALUES ('the first<br>location name','010100000085EC6F9141E2C5C0E829EE9F0AC98240');<br>
INSERT INTO "pt_gsqy_point" ("name",the_geom) VALUES ('the second<br>location name','0101000000CCFE346E05B4C5C0A9A946F9A30D8640');<br>.....<br>...<br>etc...<br><br>and after I run the second command, in the pgadmin, I got to see the<br>
values in it. but the geometry values can not be used directly, as the<br>values are those : '010100000085EC6F9141E2C5C0E829EE9F0AC98240',<br>anyone in the mailist have used the shp2pgsql.exe???<br>how to deal with it, so that I can use those point coordinates to do<br>
some operations, such as select a point using the point coordinate to<br>get the name of it.<br><br><br>--<br>Zhengyong Zhang<br>ECNU CS<br>-----------------------------------------<br>The substance of this message, including any attachments, may be<br>
confidential, legally privileged and/or exempt from disclosure<br>pursuant to Massachusetts law. It is intended<br>solely for the addressee. If you received this in error, please<br>contact the sender and delete the material from any computer.<br>
<br><br><br>------------------------------<br><br>Message: 3<br>Date: Mon, 30 Jun 2008 17:33:41 +0100<br>From: Mark Cave-Ayland <<a href="mailto:mark.cave-ayland@siriusit.co.uk">mark.cave-ayland@siriusit.co.uk</a>><br>
Subject: [postgis-devel] PostGIS bugtracker email notifications<br>To: PostGIS Development Discussion<br> <<a href="mailto:postgis-devel@postgis.refractions.net">postgis-devel@postgis.refractions.net</a>><br>Message-ID: <<a href="mailto:48690AE5.9030103@siriusit.co.uk">48690AE5.9030103@siriusit.co.uk</a>><br>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br><br>Hi everyone,<br><br>Do you think it's worth setting up the PostGIS bugtracker so it emails<br>postgis-devel whenever an issue is reported/changed? Otherwise it seems<br>
quite easy to miss a bug report/update as they come in...<br><br><br>ATB,<br><br>Mark.<br><br>--<br>Mark Cave-Ayland<br>Sirius Corporation - The Open Source Experts<br><a href="http://www.siriusit.co.uk/" target="_blank">http://www.siriusit.co.uk</a><br>
T: +44 870 608 0063<br><br><br>------------------------------<br><br>_______________________________________________<br>postgis-devel mailing list<br><a href="mailto:postgis-devel@postgis.refractions.net">postgis-devel@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-devel" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-devel</a><br><br><br>End of postgis-devel Digest, Vol 57, Issue 29<br>*********************************************<br>
</blockquote></div><br><br clear="all"><br>-- <br>Zhengyong Zhang<br>ECNU CS