[postgis-users] importing shape files nightmare!

[christomec]

Well, I quess I don't have any options other than trying the source route?

Wish me luck

> On Thu, Sep 15, 2005 at 04:27:59PM +0200, christomec wrote:
>> I'm sorry, my mistake. I thought I had the use flags set in a file
>> somewhere, but that was not the case. I'll try emerging again. Could
>> this
>> be why I'm still experiencing the same problems?
>
> GEOS and PROJ4 have nothing to do with loading shapefiles.
> Why don't you get the sources instead of fighting with package
> managers ? Belive me, that's where the meat is.
>
> --strk;
>
>
>>
>> > Well ....
>> > I've just downloaded the lastest 1.0.4 version of postgis from
>> > postgis.org and I see that the shp2pgsql.c as the same date
>> > (2005/08/29 22:36:14) so the problem couldn't came from here I think.
>> > Concerning the geos and proj support you must set proj and geos in
>> > your USE flags, for more support information use emerge -pv postgis,
>> > here you've see all the support (red are supports enabled and  blue
>> > are those disabled). To simplify you must reemerge postgis with the
>> > specified flags, for example you could simply use this command line :
>> > USE="proj geos" emerge -v postgis
>> > (or -pv to ensure that you'll effectively use geos and proj support).
>> >
>> > Hope that help.
>> >
>> >
>> > Le 15 sept. 05 à 15:37, christomec a écrit :
>> >
>> >> I have now emerged postgis-1.0.4_p20050914.ebuild, but it seems
>> >> that the
>> >> original problems weren't solved. Trying to import a shape file still
>> >> fails.
>> >>
>> >> trying:
>> >>
>> >> shp2pgsql -c /tmp/streets.shp streets | psql -d dbname
>> >>
>> >> ERROR:  unterminated quoted string at or near
>> >> "'010500000001000000010200000005000000D670917BBAA6394034BDC458A6E940C0
>> >> 2C9ACE4E06A73940A911FA997AE940C0BEF561BD51A7394"
>> >> at character 292
>> >> LINE 1: ...TRAND','0687-0890-000','0687-0890-000_6TH
>> >> AVENUE','010500000...
>> >>
>> >> and trying:
>> >>
>> >> shp2pgsql -D /tmp/streets.shp streets dbname > /tmp/streets.sql
>> >>
>> >> Shapefile type: Arc
>> >> Postgis type: MULTILINESTRING[2]
>> >> Segmentation fault
>> >>
>> >> shp2pgsql
>> >>
>> >> RCSID: $Id: shp2pgsql.c,v 1.96 2005/08/29 22:36:25 strk Exp $
>> >>
>> >> select postgis_full_version();
>> >>
>> >> POSTGIS="1.1.0CVS" USE_STATS DBPROC="0.3.1" RELPROC="0.3.1"
>> >>
>> >> Where is geos and proj4?
>> >>
>> >> cat /etc/portage/package.keywords
>> >> dev-db/postgis ~x86
>> >> sci-libs/proj ~x86
>> >> sci-libs/geos ~x86
>> >>
>> >>
>> >>
>> >>> Attached is a patch to bring shp2pgsql.c from Revision 1.91
>> >>> to Revision 1.96 (the one shipped with PostGIS 1.0.4).
>> >>>
>> >>> If you don't have the sources that's ... well ... sad :(
>> >>> You can still download latest release sources (1.0.4),
>> >>> run make in the loader/ directory and replace your dumper/loader
>> >>> with the newly created ones.
>> >>>
>> >>> .. you can read by the end of the patch all changes
>> >>> in shp2pgsql since 1.91 ...
>> >>>
>> >>> --strk;
>> >>>
>> >>> On Thu, Sep 15, 2005 at 12:28:25PM +0200, christomec wrote:
>> >>>
>> >>>> I get:
>> >>>>
>> >>>> RCSID: $Id: shp2pgsql.c,v 1.91 2005/07/04 09:47:03 strk Exp $
>> >>>>
>> >>>> Is there a way of just fixing the shp2pgsql without having to
>> >>>> re-emerging
>> >>>> postgis?
>> >>>>
>> >>>>
>> >>>>> On Thu, Sep 15, 2005 at 11:58:29AM +0200, strk at refractions.net
>> >>>>> wrote:
>> >>>>>
>> >>>>>> On Thu, Sep 15, 2005 at 11:52:08AM +0200, christomec wrote:
>> >>>>>>
>> >>>>>>> So is POSTGIS="1.1.0CVS" is in actual fact 1.0.3?
>> >>>>>>>
>> >>>>>>
>> >>>>>> Might be, the 1.1 and 1.0 are two different branches in CVS,
>> >>>>>> and 1.1.0CVS is there since about 1.0.0 is out... there's no
>> >>>>>> easy way to tell which version of the code 1.1.0CVS is.
>> >>>>>>
>> >>>>>> Since this is a bug with pgsql2shp what you should look at
>> >>>>>> is RCSID from it. It is shown running pgsql2shp w/out arguments.
>> >>>>>>
>> >>>>>
>> >>>>> Oops.. sorry, it's shp2pgsql (the loader), NOT pgsql2shp (the
>> >>>>> dumper).
>> >>>>> The RCSID is still shown when called w/out args
>> >>>>>
>> >>>>> --strk;
>> >>>>> _______________________________________________
>> >>>>> postgis-users mailing list
>> >>>>> postgis-users at postgis.refractions.net
>> >>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> >>>>>
>> >>>>>
>> >>>>>
>> >>>>>
>> >>>>>
>> >>>>>
>> >>>>
>> >>>> _______________________________________________
>> >>>> postgis-users mailing list
>> >>>> postgis-users at postgis.refractions.net
>> >>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> >>>>
>> >>>
>> >>>
>> >>>
>> >>> _______________________________________________
>> >>> postgis-users mailing list
>> >>> postgis-users at postgis.refractions.net
>> >>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>
>> >> _______________________________________________
>> >> postgis-users mailing list
>> >> postgis-users at postgis.refractions.net
>> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> >>
>> >
>> > _______________________________________________
>> > postgis-users mailing list
>> > postgis-users at postgis.refractions.net
>> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>> >
>> > !DSPAM:43297c7440031236047141!
>> >
>> >
>> >
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> !DSPAM:432986c488651111385114!
>
>
>