[postgis-users] distance from imported tiger database

[mark]

Hi
I imported the tiger database with the ogr tool. It has created table with
the structure below.
geometry_columns has an entry like this:

197276;"''";"public";"masuf";"wkb_geometry";"2";"4269";"LINESTRING"

Can you tell how I can query for locations based on distance using these?
thanks a lot
mark

CREATE TABLE masuf
(
ogc_fid serial NOT NULL,
wkb_geometry geometry,
module char(8),
tlid numeric(10),
side1 numeric(1),
source char(1),
fedirp char(2),
fename char(30),
fetype char(4),
fedirs char(2),
cfcc char(3),
fraddl char(11),
toaddl char(11),
fraddr char(11),
toaddr char(11),
friaddl char(1),
toiaddl char(1),
friaddr char(1),
toiaddr char(1),
zipl numeric(5),
zipr numeric(5),
aianhhfpl numeric(5),
aianhhfpr numeric(5),
aihhtlil char(1),
aihhtlir char(1),
census1 char(1),
census2 char(1),
statel numeric(2),
stater numeric(2),
countyl numeric(3),
countyr numeric(3),
cousubl numeric(5),
cousubr numeric(5),
submcdl numeric(5),
submcdr numeric(5),
placel numeric(5),
placer numeric(5),
tractl numeric(6),
tractr numeric(6),
blockl numeric(4),
blockr numeric(4),
CONSTRAINT masuf_pk PRIMARY KEY (ogc_fid),
CONSTRAINT enforce_dims_wkb_geometry CHECK (ndims(wkb_geometry) = 2),
CONSTRAINT enforce_geotype_wkb_geometry CHECK (geometrytype(wkb_geometry) =
'LINESTRING'::text OR wkb_geometry IS NULL),
CONSTRAINT enforce_srid_wkb_geometry CHECK (srid(wkb_geometry) = 4269)
)


On 2/11/07, mark <rkmr.em at gmail.com> wrote:
>
> hi
> are there any tools for importing the tiger database into postgres to use
> with postgis?
> thanks !
> mark
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070211/09cb42b3/attachment.html>