<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<STYLE>.hmmessage P {
PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; PADDING-TOP: 0px
}
BODY.hmmessage {
FONT-FAMILY: Tahoma; FONT-SIZE: 10pt
}
</STYLE>
<META name=GENERATOR content="MSHTML 9.00.8112.16448"></HEAD>
<BODY class=hmmessage>
<DIV dir=ltr align=left><SPAN class=473153004-17092012><FONT color=#0000ff
face=Arial>The offset is to get you on the right side of the street, not to
compensate for the fuzzyness of census data.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=473153004-17092012><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=473153004-17092012><FONT color=#0000ff
face=Arial>Not sure if that was clear. The census data are all street
centerlines, and what the offset is intended to do is this</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=473153004-17092012><FONT color=#0000ff
face=Arial>Say your road looks like this:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=473153004-17092012><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=473153004-17092012><FONT color=#0000ff
face=Arial>0
24 30</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=473153004-17092012><FONT color=#0000ff
face=Arial>-----------------------------------</FONT></SPAN></DIV>
<DIV><SPAN class=473153004-17092012></SPAN><FONT color=#0000ff
face=Arial>1 2<SPAN
class=473153004-17092012>5</SPAN> 31</FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff>S<SPAN class=473153004-17092012>ay
lets say your street address is like 25 State street, the interpolation would
put you on the centerline of the line corresponding to
24/25</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN
class=473153004-17092012></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN class=473153004-17092012>But
since we know you are 25 -- the 10 offset pushes the point to hit the 25 (so 10
meters) in the 25 direction</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN
class=473153004-17092012></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN class=473153004-17092012>So the
offset should be more accurate than without as it would put you on the correct
side of the road instead of standing in the middle of
it.</SPAN></FONT></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial></FONT><FONT color=#0000ff
face=Arial></FONT><BR></DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT face=Tahoma><B>From:</B> postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Chris
English<BR><B>Sent:</B> Sunday, September 16, 2012 9:14 AM<BR><B>To:</B>
postgis_users<BR><B>Subject:</B> Re: [postgis-users] Odd
question<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr>But changing the setting to zero doesn't get one necessarily closer
to the <BR>true location of the address, does it? It remains fuzzy as was
the intent<BR>of the census bureau to elide.<BR>Chris<BR><BR>
<DIV>
<DIV id=SkyDrivePlaceholder></DIV>
<HR id=stopSpelling>
Date: Sat, 15 Sep 2012 18:46:06 -0500<BR>From: ericaspen@gmail.com<BR>To:
postgis-users@postgis.refractions.net<BR>Subject: Re: [postgis-users] Odd
question<BR><BR>That's fantastic! Exactly what I was looking for. Thank you very
much.<BR><BR>
<DIV class=ecxgmail_quote>On Sat, Sep 15, 2012 at 6:44 PM, Paragon Corporation
<SPAN dir=ltr><<A href="mailto:lr@pcorp.us">lr@pcorp.us</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE style="BORDER-LEFT: #ccc 1px solid; PADDING-LEFT: 1ex"
class=ecxgmail_quote>Eric,<BR><BR>Did y ou want to change the default or set
it to 0 or something?<BR><BR>We were meaning to expose that but wasn't sure if
anyone would be interested<BR>in changing it.<BR><BR>The setting is on the
function:<BR><BR>interpolate_from_address<BR><BR>Just change the hardcoded
default of 10 to what you want.<BR><BR><BR><BR>CREATE OR REPLACE FUNCTION
interpolate_from_address(given_address INTEGER,<BR>in_addr1 VARCHAR, in_addr2
VARCHAR, in_road GEOMETRY,<BR> in_side VARCHAR
DEFAULT '',in_offset_m float DEFAULT 10 );<BR><BR><BR>In 2.1. we'll add to the
list to allow this to be voerrided at the geocode<BR>function level as an
additional arg. Can't do that with the 2.0 one though<BR>since that
would change the api.<BR><BR>Hope that helps,<BR>Regina<BR><A
href="http://www.postgis.us" target=_blank>http://www.postgis.us</A><BR>
<DIV>
<DIV class=h5><BR><BR><BR>-----Original Message-----<BR>From: <A
href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</A><BR>[mailto:<A
href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</A>]
On Behalf Of Eric<BR>Aspengren<BR>Sent: Saturday, September 15, 2012 5:20
PM<BR>To: PostGIS Users Discussion<BR>Subject: [postgis-users] Odd
question<BR><BR>Anybody know how to remove the default 10 meter offset from
the PostGIS<BR>geocoder?<BR><BR><BR>--<BR>Eric Aspengren<BR><A
target=_blank>(402) 478-8683</A><BR><A
href="http://www.streetlevelstrategies.com"
target=_blank>www.streetlevelstrategies.com</A><BR><A
href="mailto:ericaspen@gmail.com">ericaspen@gmail.com</A><BR><BR><BR><BR></DIV></DIV>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></BLOCKQUOTE></DIV><BR><BR
clear=all>
<DIV><BR></DIV>-- <BR>Eric Aspengren<BR>(402) 478-8683<BR><A
href="http://www.streetlevelstrategies.com"
target=_blank>www.streetlevelstrategies.com</A><BR><A
href="mailto:ericaspen@gmail.com">ericaspen@gmail.com</A><BR><BR>_______________________________________________
postgis-users mailing list postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users</DIV></DIV></BODY></HTML>