[postgis-users] TIGER/Line Shapefiles released

[Stephen Frost]

* Stephen Woodbridge (woodbri at swoodbridge.com) wrote:
> 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&btnG=Search
> http://www.google.com/search?num=100&hl=en&newwindow=1&safe=off&q=dbf2sql&btnG=Search
>
> some of these might be helpful.

Just fyi, my script uses dbview from the, conveniantly named, dbview
Debian package.  It works quite well for me.  Not that I'd be against
having that functionality in shp2pgsql, it's certainly be useful.

First I'd like to see an option to add the primary key *after* the data
is loaded though.

	Thanks,

		Stephen

> 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: postgis-users-bounces at postgis.refractions.net
>> [mailto:postgis-users-bounces at postgis.refractions.net] 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 (sfrost at snowman.net) 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 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080403/366a2d47/attachment.pgp>