Thanks I'll take a look. I was thinking more for completeness and the marginal effort that I think would be involved from my memory of what the shp2pgsql C code looks like. I would change it myself, but I'm moderately afraid of C code.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Woodbridge Sent: Thursday, April 03, 2008 9:53 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] TIGER/Line Shapefiles released Yes, it would be ideal if it was handled by shp2pgsql but have you looked at: http://www.google.com/search?num=100&hl=en&newwindow=1&safe=off&q=dbf2pgsql&; btnG=Search http://www.google.com/search?num=100&hl=en&newwindow=1&safe=off&q=dbf2psql&b tnG=Search http://www.google.com/search?num=100&hl=en&newwindow=1&safe=off&q=dbf2sql&bt nG=Search some of these might be helpful. Best regards, -Stephen Woodbridge http://imaptools.com/ Paragon Corporation wrote: > As a side note to what you were saying in the .sh file it would be > really nice if the shp2pgsql dealt with standalone dbf files too. I > mean the logic is all there so doesn't seem like it would be that hard > to put in a switch for that. > > For the dbfs I was using Ogr2Ogr which works well except it adds a > useless geometry field. > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Stephen Frost > Sent: Thursday, April 03, 2008 7:16 PM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] TIGER/Line Shapefiles released > > * Stephen Frost ([EMAIL PROTECTED]) wrote: >> If anyone's interested in the scripts used to load the data (they're >> pretty simple, really), I'd be happy to provide them. > > Alright, since it's apparently kind of popular, I went ahead and put > the script up here: > > http://snowman.net/tiger/ > > I also included a README.txt that is essentially what I wrote up to > the first person who asked me for the script. Please let me know if > you improve upon it or find problems with it. > > Thanks, > > Stephen > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
