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: <br>
<br><pre class="programlisting">INSERT INTO <span style="font-family: courier new,monospace;">"geotable" ("zid","name","color","icon_size","extrude","tesellate",the_geom) <br>
VALUES ('1','Untitled Polygon',NULL,NULL,NULL,NULL,</span>'POLYGON(x y, x y,.....)');</pre><br>Here is my output:<br><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Shapefile type: Polygon</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Postgis type: MULTIPOLYGON[2]</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">BEGIN;</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">CREATE TABLE "geotable" (gid serial PRIMARY KEY,</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">"zid" int4,</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">"name" varchar(30),</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">"color" varchar(10),</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">"icon_size" varchar(5),</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">"extrude" varchar(1),</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">"tesellate" varchar(1));</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">SELECT AddGeometryColumn('','geotable','the_geom','-1','MULTIPOLYGON',2);</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">INSERT INTO "geotable" ("zid","name","color","icon_size","extrude","tesellate",the_geom) VALUES ('1','Untitled Polygon',NULL,NULL,NULL,NULL,'0106000000010000000103000000010000000A0000000000003411F63B400000C88F31073AC00000002B87F63B400000E81DA7083AC00000F053E3F53B400000385EBA093AC00000F085C9F43B40000008A3920A3AC0000060B3EAF33B40000040355E0A3AC0000060DC46F33B4000006007CE093AC0000060DC46F33B400000A0ABAD083AC00000807CD0F33B40000088F4DB073AC0000060A1D6F43B400000605452073AC00000003411F63B400000C88F31073AC0');</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">...</span><br style="font-family: courier new,monospace;"><br>Any guidance would be much appreciated.<br><br>-- <br>Andre Hauptfleisch<br><br>