Hi<br>I imported the tiger database with the ogr tool. It has created table with the structure below.<br> geometry_columns has an entry like this:<br><br>197276;"''";"public";"masuf";"wkb_geometry";"2";"4269";"LINESTRING"
<br><br>Can you tell how I can query for locations based on distance using these?<br>thanks a lot<br>mark<br><br>CREATE TABLE masuf<br>(<br>  ogc_fid serial NOT NULL,<br>  wkb_geometry geometry,<br>  module char(8),<br>  tlid numeric(10),
<br>  side1 numeric(1),<br>  source char(1),<br>  fedirp char(2),<br>  fename char(30),<br>  fetype char(4),<br>  fedirs char(2),<br>  cfcc char(3),<br>  fraddl char(11),<br>  toaddl char(11),<br>  fraddr char(11),<br>  toaddr char(11),
<br>  friaddl char(1),<br>  toiaddl char(1),<br>  friaddr char(1),<br>  toiaddr char(1),<br>  zipl numeric(5),<br>  zipr numeric(5),<br>  aianhhfpl numeric(5),<br>  aianhhfpr numeric(5),<br>  aihhtlil char(1),<br>  aihhtlir char(1),
<br>  census1 char(1),<br>  census2 char(1),<br>  statel numeric(2),<br>  stater numeric(2),<br>  countyl numeric(3),<br>  countyr numeric(3),<br>  cousubl numeric(5),<br>  cousubr numeric(5),<br>  submcdl numeric(5),<br>
  submcdr numeric(5),<br>  placel numeric(5),<br>  placer numeric(5),<br>  tractl numeric(6),<br>  tractr numeric(6),<br>  blockl numeric(4),<br>  blockr numeric(4),<br>  CONSTRAINT masuf_pk PRIMARY KEY (ogc_fid),<br>  CONSTRAINT enforce_dims_wkb_geometry CHECK (ndims(wkb_geometry) = 2),
<br>  CONSTRAINT enforce_geotype_wkb_geometry CHECK (geometrytype(wkb_geometry) = 'LINESTRING'::text OR wkb_geometry IS NULL),<br>  CONSTRAINT enforce_srid_wkb_geometry CHECK (srid(wkb_geometry) = 4269)<br>) <br><br>
<br><div><span class="gmail_quote">On 2/11/07, <b class="gmail_sendername">mark</b> <<a href="mailto:rkmr.em@gmail.com">rkmr.em@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="margin-top: 0; margin-right: 0; margin-bottom: 0; margin-left: 0; margin-left: 0.80ex; border-left-color: #cccccc; border-left-width: 1px; border-left-style: solid; padding-left: 1ex">
hi<br>are there any tools for importing the tiger database into postgres to use with postgis?<br>thanks !<br><span class="sg">mark<br></span></blockquote></div><br>