[postgis-users] finding street address points

[Thomas, Cord]

Alex, 

First question - you developing in Perl, or other?

This is basic geometry.

I am new to MapServer, so there may be address matching libraries already
built, but if not, we should defitely explore the creation of a mapping
library for address matching - a very common task.

The issue at hand is to do the following at various levels of complexity:
  given an address data source (street centerline often, sometimes property
data from assessor)
  search the source for the request street name, street extension (often
suffix), and house/building number.
  if exact street name matches, great, other use some heuristics/phonetics
rules to find appropriate list of close matches
  find street segment between which requested house number lies.  
  interpolate between 'from' and 'to' addresses and build the function for
the line connecting the two points (from and two). 
  offset the requested address by 25 feet (in your case) using the line
function just built.

This is a basic set of queries to PostGIS and then a little simple geometry.

Has anyone done this?

Cord

-----Original Message-----
From: Alex Rice [mailto:alex_rice at arc.to]
Sent: Tuesday, September 03, 2002 11:07 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] finding street address points


Hi, I am developing in mapserver + postgis and trying to duplicate some 
functionality that we have in mapinfo. I think it originally came from 
MapBasic, and I don't have the source code for it. Does any function 
similar to this exist in PostGIS? Any pointers for approaches for this 
problem?

The mapbasic function in question finds an estimated point for an 
address, given a line segment object and an address number. The line 
segment object also has integer fields for the address range: fromleft, 
fromright, toleft, toright. The algorithm selects a point along the 
line segment based on the address range, and then moves back about 25' 
from the boundary based on the odd or even address number. This is used 
to estimate points where street address locations are.

Thanks,

Alex Rice, Software Developer
Architectural Research Consultants, Inc.
alrice at swcp.com
alex_rice at arc.to


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users