<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle18
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>You’re seeing binary. Some where
along the way the storage of shapes in PostGIS was changed to that. To see the
type of stuff you want, AFTER inserting your data, you can do:</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>SELECT gid, name, asText(the_geom) from geotable;</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Robert W. Burgholzer</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Surface Water Modeler</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Office of Water Supply and Planning</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Virginia Department of Environmental
Quality</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><a
href="mailto:rwburgholzer@deq.virginia.gov">rwburgholzer@deq.virginia.gov</a></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>804-698-4405</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Open Source Modeling Tools:</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><a
href="http://sourceforge.net/projects/npsource/">http://sourceforge.net/projects/npsource/</a></span></font></p>
</div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Andre Hauptfleisch<br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, June 04, 2008
9:51 AM<br>
<b><span style='font-weight:bold'>To:</span></b> PostGIS User Mailing List<br>
<b><span style='font-weight:bold'>Subject:</span></b> [postgis-users] shp2pgsql
multipolygon weirdness</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-right:0in;margin-bottom:12.0pt;margin-left:
.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Good
day,<br clear=all>
<br>
I'm new to PostGIS and need to get a shapefile into the pgsql db.<br>
<br>
I stumbled onto the shp2pgsql tool, but when I run it on my shapefile, I get a
string of weird looking hex digits. Perhaps I don't quite understand what the
tool does, but I would expect it to output something 'sensible' such as: </span></font></p>
<pre style='margin-left:.5in'><font size=2 face="Courier New"><span
style='font-size:10.0pt'>INSERT INTO "geotable" ("zid","name","color","icon_size","extrude","tesellate",the_geom) <br>
<br>
</span></font></pre><pre style='margin-left:.5in'><font size=2
face="Courier New"><span style='font-size:10.0pt'>VALUES ('1','Untitled Polygon',NULL,NULL,NULL,NULL,'POLYGON(x y, x y,.....)');</span></font></pre>
<p class=MsoNormal style='margin-right:0in;margin-bottom:12.0pt;margin-left:
.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><br>
Here is my output:<br>
</span></font><font face="Courier New"><span style='font-family:"Courier New"'><br>
Shapefile type: Polygon<br>
<br>
Postgis type: MULTIPOLYGON[2]<br>
BEGIN;<br>
CREATE TABLE "geotable" (gid serial PRIMARY KEY,<br>
"zid" int4,<br>
"name" varchar(30),<br>
"color" varchar(10),<br>
"icon_size" varchar(5),<br>
"extrude" varchar(1),<br>
"tesellate" varchar(1));<br>
SELECT AddGeometryColumn('','geotable','the_geom','-1','MULTIPOLYGON',2);<br>
INSERT INTO "geotable"
("zid","name","color","icon_size","extrude","tesellate",the_geom)
VALUES ('1','Untitled
Polygon',NULL,NULL,NULL,NULL,'0106000000010000000103000000010000000A0000000000003411F63B400000C88F31073AC00000002B87F63B400000E81DA7083AC00000F053E3F53B400000385EBA093AC00000F085C9F43B40000008A3920A3AC0000060B3EAF33B40000040355E0A3AC0000060DC46F33B4000006007CE093AC0000060DC46F33B400000A0ABAD083AC00000807CD0F33B40000088F4DB073AC0000060A1D6F43B400000605452073AC00000003411F63B400000C88F31073AC0');<br>
...<br>
</span></font><br>
Any guidance would be much appreciated.<br>
<br>
-- <br>
Andre Hauptfleisch</p>
</div>
</body>
</html>