<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'>
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 class="ecxgmail_quote" style="border-left:1px #ccc solid;padding-left:1ex">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>