[postgis-users] tiger question

Thomas, Cord cthomas at rand.org
Fri Nov 26 10:55:18 PST 2004


Joel:

Yes, the dbf file contains the data linked to the geometry.  I am unsure
about how shp2psql works; as an alternative, you can use ogr2ogr to load
data directly from tiger files to postgres doing some interesting
feature, field and attribute filtering.

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Joel
Gwynn
Sent: Wednesday, November 24, 2004 9:27 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] tiger question

I used ogr2ogr to convert some tiger files to ESRI Shapefile.  From
there, I used shp2pgsql to import the shapefiles into postgres.

I've noticed that the geometry, CompleteChain for example, has a dbf
file associated with it.  Is that data grabbed by shp2pgsql, or do I
need to import the dbf to another table?  If so, what's the best way
to get a dbf into postgres?
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

--------------------

This email message is for the sole use of the intended recipient(s) and
may contain privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all copies
of the original message.





More information about the postgis-users mailing list