<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
Thank you, now perfectly clear.<br><br><div><div id="SkyDrivePlaceholder"></div><hr id="stopSpelling">From: lr@pcorp.us<br>To: postgis-users@postgis.refractions.net<br>Date: Mon, 17 Sep 2012 00:35:16 -0400<br>Subject: Re: [postgis-users] Odd question<br><br>
<style><!--
.ExternalClass .ecxhmmessage P
{padding-bottom:0px;padding-left:0px;padding-right:0px;padding-top:0px;}
.ExternalClass BODY.ecxhmmessage
{font-family:Tahoma;font-size:10pt;}
--></style>
<div dir="ltr" align="left"><span class="ecx473153004-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="ecx473153004-17092012"><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span class="ecx473153004-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="ecx473153004-17092012"><font color="#0000ff" face="Arial">Say your road looks like this:</font></span></div>
<div dir="ltr" align="left"><span class="ecx473153004-17092012"><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span class="ecx473153004-17092012"><font color="#0000ff" face="Arial">0
24 30</font></span></div>
<div dir="ltr" align="left"><span class="ecx473153004-17092012"><font color="#0000ff" face="Arial">-----------------------------------</font></span></div>
<div><span class="ecx473153004-17092012"></span><font color="#0000ff" face="Arial">1 2<span class="ecx473153004-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="ecx473153004-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="ecx473153004-17092012"></span></font></font> </div>
<div><font face="Arial"><font color="#0000ff"><span class="ecx473153004-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="ecx473153004-17092012"></span></font></font> </div>
<div><font face="Arial"><font color="#0000ff"><span class="ecx473153004-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" class="ecxOutlookMessageHeader" align="left" lang="en-us">
<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="ecxSkyDrivePlaceholder"></div>
<hr id="ecxstopSpelling">
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>
<br>_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users</div> </div></body>
</html>