<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=iso-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Just for note<br>
<br>
U can specify the geometry column U want with option -g with pgsql2shp<br>
<br>
do a<br>
<br>
pgsql2shp --help <br>
<br>
to have more info<br>
<br>
<br>
<br>
Frances Collier a écrit :
<blockquote cite="mid002a01c6d6b6$e43b47c0$0d5aa8c0@devfrances"
type="cite">
<pre wrap="">Okay, I didn't know that it needed an attribute. Thanks for the info.
Frances
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>
[<a class="moz-txt-link-freetext" href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of Bruce
Rindahl
Sent: Tuesday, September 12, 2006 2:55 PM
To: 'Frances Collier'
Cc: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] ogr2ogr creating shapefile
Your function getpop() returns two geometries - pnt and pop. I wanted to
confirm that with the first query. A shapefile needs one geometry and at
least one attribute. As an example I just created columns of the x and y
coordinates of the pnt geometry and the pop for the shapefile. X() and Y()
are standard PostGIS functions.
Bruce
-----Original Message-----
From: Frances Collier [<a class="moz-txt-link-freetext" href="mailto:fcollier@preparedresponse.com">mailto:fcollier@preparedresponse.com</a>]
Sent: Tuesday, September 12, 2006 3:49 PM
To: <a class="moz-txt-link-abbreviated" href="mailto:rindahl@lrcwe.com">rindahl@lrcwe.com</a>
Subject: RE: [postgis-users] ogr2ogr creating shapefile
That worked, of course, and thank you very much. The table now has the FID,
shape, X, and Y in it. I understand what they all are, but I don't
understand why. If you don't mind too much, would you explain (or point me
to an explanation of) why the x and y needed to be included?
-Frances Collier
-----Original Message-----
From: Bruce Rindahl [<a class="moz-txt-link-freetext" href="mailto:rindahl@lrcwe.com">mailto:rindahl@lrcwe.com</a>]
Sent: Tuesday, September 12, 2006 2:24 PM
To: 'Frances Collier'
Subject: RE: [postgis-users] ogr2ogr creating shapefile
Now try:
Pgsql2shp -f D:\myshapefile.shp -u postgres -P postgres mydb 'select pop,
X(pnt) as x, y(pnt) as y from getpop()'
This should give you a shapefile of the buffers and the x and y coordinates
of the points as attributes in the table.
Bruce
-----Original Message-----
From: Frances Collier [<a class="moz-txt-link-freetext" href="mailto:fcollier@preparedresponse.com">mailto:fcollier@preparedresponse.com</a>]
Sent: Tuesday, September 12, 2006 3:04 PM
To: <a class="moz-txt-link-abbreviated" href="mailto:rindahl@lrcwe.com">rindahl@lrcwe.com</a>
Subject: RE: [postgis-users] ogr2ogr creating shapefile
Sure:
pnt|pop
0101000020FF7F000034BBEEAD48635EC06E3480B7402C4840|"0103000020FF7F0000010000
002200000034BBEEAD48435EC06E3480B7402C4840B1C31E16E6435EC01E01625BC41F484010
881F42B8455EC09E88D9D4C213484049ABC547AD485EC076DB0C41B2084840CA39880FA84C5E
C0533AB37AFFFE47409609B57281515EC0741B2EEB09F74740995F9BBC09575EC0DED2E1DF1F
F147407F9BDF7F0A5D5EC0D047E0877BED474008B5EEAD48635EC06E3480B740EC4740CFCEFD
DB86695EC0FF42E0877BED4740680B429F876F5EC06CC9E1DF1FF147408F6228E90F755EC0BD
0D2EEB09F74740E433554CE9795EC0DF28B37AFFFE474044C41714E47D5EC0F0C60C41B20848
409FE9BD19D9805EC0D171D9D4C21348404FB0BE45AB825EC0E9E8615BC41F484034BBEEAD48
835EC0BF1B80B7402C484020B5BE45AB825EC0884F9E13BD38484011F3BD19D9805EC070C926
9ABE444840FAD11714E47D5EC0E178F32DCF4F48405845554CE9795EC0151D4DF48159484015
7728E90F755EC0B23FD283776148403622429F876F5EC08C8C1E8F6167484004E7FDDB86695E
C03B1C20E7056B4840B7CDEEAD48635EC06E3480B7406C4840B4B3DF7F0A5D5EC0AE2A20E705
6B484066769BBC09575EC0E2A81E8F616748401C1EB57281515EC0D568D283776148403E4B88
0FA84C5EC071514DF48159484000B9C547AD485EC072B6F32DCF4F484082911F42B8455EC0D9
0D279ABE44484082C81E16E6435EC028989E13BD38484034BBEEAD48435EC0CB6580B7402C48
4034BBEEAD48435EC06E3480B7402C4840"
I separated the columns with the "|" symbol.
Frances Collier
-----Original Message-----
From: Bruce Rindahl [<a class="moz-txt-link-freetext" href="mailto:rindahl@lrcwe.com">mailto:rindahl@lrcwe.com</a>]
Sent: Tuesday, September 12, 2006 1:44 PM
To: 'Frances Collier'
Subject: RE: [postgis-users] ogr2ogr creating shapefile
Can you post the result of:
Select * from mypop() limit 1
Bruce Rindahl
-----Original Message-----
From: Frances Collier [<a class="moz-txt-link-freetext" href="mailto:fcollier@preparedresponse.com">mailto:fcollier@preparedresponse.com</a>]
Sent: Tuesday, September 12, 2006 2:40 PM
To: <a class="moz-txt-link-abbreviated" href="mailto:rindahl@lrcwe.com">rindahl@lrcwe.com</a>; 'PostGIS Users Discussion'
Subject: RE: [postgis-users] ogr2ogr creating shapefile
Bruce,
Well, I fixed the query so I'm only calling one of the two columns ("select
pop from getpop()"), and I still get the same error. Do I need to be
querying another column in addition to the geometry one? Perhaps it's the
way I've written my function.
First I created my own type: myset(pnt geometry, pop geometry). My function
returns a setof myset. In the function, I take a linestring, get the
individual points, and then simply call the buffer function on each point.
(Does this make enough sense?) So, I guess I'm really asking if the myset
type is the problem.
Thank you for your time.
Frances Collier
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>
[<a class="moz-txt-link-freetext" href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of Bruce
Rindahl
Sent: Tuesday, September 12, 2006 1:10 PM
To: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] ogr2ogr creating shapefile
An ESRI shapefile can only have one type of geometry. You can't have a
point and a polygon in one shapefile.
Bruce Rindahl
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>
[<a class="moz-txt-link-freetext" href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of Frances
Collier
Sent: Tuesday, September 12, 2006 2:07 PM
To: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] ogr2ogr creating shapefile
Thank you Bill. That worked wonderfully.
Now, I have another problem. When I try to open the shape file, it breaks.
The ESRI software says that the number of shapes does not match the number
of table records. When I open the .dbf there are no records. The getPop()
function is returning a point column and a polygon column. Does it need more
than?
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>
[<a class="moz-txt-link-freetext" href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of Bill
Thoen
Sent: Tuesday, September 12, 2006 12:50 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] ogr2ogr creating shapefile
Oddly enough, 'Select' must be lower case for this to work.
On Tue, Sep 12, 2006 at 12:32:46PM -0700, Frances Collier wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Thank you for your reply, David. I did copy and post the question to the
gdal-dev mailing list. In the meantime, though, I tried using pgsql2shp.
</pre>
</blockquote>
<pre wrap=""><!---->My
</pre>
<blockquote type="cite">
<pre wrap="">exact syntax:
Pgsql2shp -f D:\myshapefile.shp -u postgres -P postgres mydb 'Select *
</pre>
</blockquote>
<pre wrap=""><!---->from
</pre>
<blockquote type="cite">
<pre wrap="">getPop()'
The print out is: Initializing... Querying for attributes: ERROR: syntax
error at or near "Select" at character 152 Now, I've tried putting both
single and double quotes around mydb and around the select statement. If I
don't have the single quotes around the select statement it returns back
</pre>
</blockquote>
<pre wrap=""><!---->an
</pre>
<blockquote type="cite">
<pre wrap="">error stating that the table Select does not exist.
And getPop() is a function that I wrote. If you'd like that code, let me
know.
Thank you,
Frances Collier
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>
[<a class="moz-txt-link-freetext" href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of TECHER
David
Sent: Monday, September 11, 2006 4:56 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] ogr2ogr creating shapefile
Hi Frances,
I'm used to using ogr2ogr but I've never had problems.
Never see this error before! For me to understanding what is getPop() in
your query???
What about using pgsql2shp instead of ogr2ogr ??? (see
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/docs/ch04.html#id2524054">http://postgis.refractions.net/docs/ch04.html#id2524054</a>)
example: pgsql2shp -f your_shapefile.shp your_database your_query
for us to see if U have error too with this tool
For the error U give, it seems better to ask on gdal mailing list!
Frances Collier a écrit :
</pre>
<blockquote type="cite">
<pre wrap="">Hello all,
I have been trying to figure out how to create a shapefile using ogr2ogr.
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->I
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">haven't been able to find much on it through google and the user pages so
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->I
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">thought one of you might be able to help.
Here's my statement:
ogr2ogr -f "ESRI Shapefile" test "PG:dbname=mydb host=localhost
user=postgres password=postgres" -sql "Select pop from getPop()"
When I click enter I get an Application Error that states the memory
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->could
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">not be "read". I'm sure it's in my syntax, but I can't figure it out. I
would like to know if there are other ways to accomplish this as well.
Thank you,
Frances Collier
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<pre wrap="">
--
--david;
<a class="moz-txt-link-freetext" href="http://www.postgis.fr">http://www.postgis.fr</a>
<a class="moz-txt-link-freetext" href="http://www.davidgis.fr">http://www.davidgis.fr</a>
</pre>
</blockquote>
<pre wrap=""><!---->___________________________________________________________________________
</pre>
<blockquote type="cite">
<pre wrap="">Dcouvrez un nouveau moyen de poser toutes vos questions quelque soit le
sujet !
Yahoo! Questions/Rponses pour partager vos connaissances, vos opinions et
vos expriences.
<a class="moz-txt-link-freetext" href="http://fr.answers.yahoo.com">http://fr.answers.yahoo.com</a>
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<pre wrap=""><!---->_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
--david;
<a class="moz-txt-link-freetext" href="http://www.postgis.fr">http://www.postgis.fr</a>
<a class="moz-txt-link-freetext" href="http://www.davidgis.fr">http://www.davidgis.fr</a>
</pre>
</body>
</html>