[postgis-devel] Several problems with shapeloader GUI

Nicklas Avén nicklas.aven at jordogskog.no
Thu Dec 24 21:47:04 PST 2009


Ok I will try to give you as much information as possible.I run pgAdmin 1.10.1 installed with oneclick installer to postgresql 8.4.2 What I see now and  I don't know the importance of is that I have 1.10.0 Beta2 installed too.I removed that directory and get the same result, but  havene't restarted the box yet. I downloaded the file http://www.postgis.org/download/windows/pg84/experimental/postgis/postgis-pg84-binaries-1.5svn.zip copied the files to C:\Programfiler\PostgreSQL\8.4notice the norwegiean folder name "Programfiler" instead of "Program files" I created a template database as described in readme with bat file. then created a dataase named pg15 from that template I edited pgbin-path under options to pgAdmin to point to this postgresql installation bin fiolder. Before it pointed to my home compiled installation. Then I copied that lines into the ini-file as described in readme, and the plugin showed up as expected. in pgAdmin I mark the new database and open the plug!
 inAll connection properties looks fine. I open file dialog and choose a file. ( I have tried more than the one attached but I send it anyway)change SRID to 32633when I run the import I get the earlier decribed error-message.Connection: user=postgres password=postgres port=5433 host=localhost dbname=pg15
Destination: public.vegen
Source File: D:\Askprosjekt\test\vegen
Shapefile type: Arc
Postgis type: LINESTRING[2]
Invalid SRID for geography type: 7f79
Shapefile import failed.
 It seems like it only wants geography. I have removed the gid-field, that's why the new path to the file vegen.shp  If I instead try running with SRID -1 I get the error Regina just posted a ticket about with the window exploding with the progressbar out to the right of the screen. If I try another database on the same server, then I still got the same problem if I change the SRID but I get this message if I run with SRID -1 (the explosion is not happening) Connection: user=postgres password=postgres port=5433 host=localhost dbname=pg14
Destination: public.vegen
Source File: D:\Askprosjekt\test\vegen
Shapefile type: Arc
Postgis type: LINESTRING[2]
Failed SQL was: SET CLIENT_ENCODING TO UTF8;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "public"."vegen" (gid serial PRIMARY KEY,
"start" int4,
"stop" int4,
"aske" int4,
"the_geom" geography(LINESTRING,4326));Failed in pgui_exec(): ERROR:  type "geography" does not exist
LINE 8: "the_geom" geography(LINESTRING,4326));
                   ^Shapefile import failed.
  So I tried to change encoding under optionsI don't get this encoding things but I tried both UTF8 and win1252 and both tries crashed the plugin with a kindly asked messege of sending an error report to microsoft I'll go sleeping for a couple of more hours Hope this helps Nicklas
2009-12-25 Paul Ramsey wrote:

Can you give us the file you used and an *exact* set of steps?
>thanks,
>P
>
>On Thu, Dec 24, 2009 at 4:29 PM, Nicklas Avén
> wrote:
>> Hallo
>>
>> I have not tried the shapeloader GUI before because of the compiling
>> problems in windows.
>> Now I tried it.
>> It looks great, but I had some problems.
>>
>> Just before I sent this I found that the result was very different when
>> running as standalone see bottom of mail
>>
>> 1) If I change SRID from -1 to 32633 I get following error:
>> Connection: user=postgres password=postgres port=5433 host=localhost
>> dbname=pg15
>> Destination: public.vegen
>> Source File: D:\Askprosjekt\vegen
>> Shapefile type: Arc
>> Postgis type: LINESTRING[2]
>> Invalid SRID for geography type: 7f79
>> Shapefile import failed.
>> I have not asked for geography and not checked it or changed anything else
>> under options.
>> I see if I try SRID -1 too, that it asks for values in long lat range.
>>
>> 2) If I get any error, for instance the above, when I open dialog for
>> choosing shapefile it doesn't filter for shapefiles anymore and shows all
>> files.
>>
>> 3) If I try to load with srid -1 it totally flips. The progress bar seems to
>> extend the window of the loader GUI out to the left as showed in attached
>> picture.
>>
>> 4) As seen on the picture there is also some error happening probably
>> because the shapefile already contains a gid column.
>>
>>
>> Environment is
>> windows XP
>> postgresql 8.4.2
>> postgis is the experimental build from 23 dec
>> ran loader GUI as plugin to pgAdmin. Getting connection properties
>> automatically worked perfect :-)
>>
>>
>>
>> When I tried as standalone it worked very good. The only thing that seems
>> unstable in standalone is that when first file is loaded the shape file
>> filter doesn't work when I open the file dialog for the next file.
>>
>> I haven't done those tests very thoroughly so I can have missunderstood
>> something, but this was what I got.
>>
>> /Nicklas
>>
>> _______________________________________________
>> postgis-devel mailing list
>> postgis-devel at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>>
>>
>_______________________________________________
>postgis-devel mailing list
>postgis-devel at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-devel
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20091225/a4131eb7/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: vegen.zip
Type: application/x-zip-compressed
Size: 5282 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20091225/a4131eb7/attachment.bin>


More information about the postgis-devel mailing list