Re: [postgis-users] Odd question
That's fantastic! Exactly what I was looking for. Thank you very much. On Sat, Sep 15, 2012 at 6:44 PM, Paragon Corporation wrote: > Eric, > > Did y ou want to change the default or set it to 0 or something? > > We were meaning to expose that but wasn't sure if anyone would be > interested > in changing it. > > The setting is on the function: > > interpolate_from_address > > Just change the hardcoded default of 10 to what you want. > > > > CREATE OR REPLACE FUNCTION interpolate_from_address(given_address INTEGER, > in_addr1 VARCHAR, in_addr2 VARCHAR, in_road GEOMETRY, > in_side VARCHAR DEFAULT '',in_offset_m float DEFAULT 10 ); > > > In 2.1. we'll add to the list to allow this to be voerrided at the geocode > function level as an additional arg. Can't do that with the 2.0 one though > since that would change the api. > > Hope that helps, > Regina > http://www.postgis.us > > > > -Original Message- > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Eric > Aspengren > Sent: Saturday, September 15, 2012 5:20 PM > To: PostGIS Users Discussion > Subject: [postgis-users] Odd question > > Anybody know how to remove the default 10 meter offset from the PostGIS > geocoder? > > > -- > Eric Aspengren > (402) 478-8683 > www.streetlevelstrategies.com > ericas...@gmail.com > > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Eric Aspengren (402) 478-8683 www.streetlevelstrategies.com ericas...@gmail.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Odd question
Anybody know how to remove the default 10 meter offset from the PostGIS geocoder? -- Eric Aspengren (402) 478-8683 www.streetlevelstrategies.com ericas...@gmail.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] QGIS issues
Anybody have any issues with QGIS not displaying PostGIS layers? -- Eric Aspengren (402) 478-8683 www.streetlevelstrategies.com ericas...@gmail.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Help with PL/PGSQL!
Well, that was simple enough! Thanks! (as Eric rolls his eyes at himself)
On Mon, Jul 30, 2012 at 3:13 PM, David William Bitner wrote:
> You have geocoded declared as a type record. ST_Within needs that to be of
> type geometry.
>
> On Mon, Jul 30, 2012 at 1:32 PM, Eric Aspengren wrote:
>
>> So, I've got this PL/PGSQL script that doesn't want to work. I've got the
>> TIGER geocoder up and running and I can get whatever I want from that.
>> However, when I try and combine ST_Within with the output from GEOCODE I
>> get an error. I assume there's a simple syntax error here, but I can't
>> figure it out. I've been able to get this to work when just cutting and
>> pasting the actual geometry data into where "geocoded" is below, but
>> replacing it with the variable name gives me an error (sldu is a table with
>> Senate districts and sldust is the district number column):
>>
>> CREATE OR REPLACE FUNCTION get_district(address text)
>> RETURNS text AS
>> $$
>> DECLARE
>> district RECORD;
>> geocoded RECORD;
>> BEGIN
>> SELECT geomout into geocoded from geocode(address) as g;
>> SELECT sldust from sldu into district where ST_Within(geocoded,
>> the_geom);
>> return district;
>> END;
>> $$
>> LANGUAGE 'plpgsql' IMMUTABLE;
>>
>>
>> geocoder=# select get_district('1700 C St Lincoln, NE');
>>
>>
>> ERROR: function st_within(record, geometry) does not exist
>> LINE 1: SELECT sldust from sldu where ST_Within( $1 , the_geom)
>> ^
>> HINT: No function matches the given name and argument types. You might
>> need to add explicit type casts.
>> QUERY: SELECT sldust from sldu where ST_Within( $1 , the_geom)
>> CONTEXT: PL/pgSQL function "get_district" line 6 at SQL statement
>>
>> --
>> Eric Aspengren
>>
>> ___
>> postgis-users mailing list
>> postgis-users@postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
>
> --
>
> David William Bitner
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
--
Eric Aspengren
(402) 478-VOTE
ericas...@gmail.com
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Help with PL/PGSQL!
So, I've got this PL/PGSQL script that doesn't want to work. I've got the
TIGER geocoder up and running and I can get whatever I want from that.
However, when I try and combine ST_Within with the output from GEOCODE I
get an error. I assume there's a simple syntax error here, but I can't
figure it out. I've been able to get this to work when just cutting and
pasting the actual geometry data into where "geocoded" is below, but
replacing it with the variable name gives me an error (sldu is a table with
Senate districts and sldust is the district number column):
CREATE OR REPLACE FUNCTION get_district(address text)
RETURNS text AS
$$
DECLARE
district RECORD;
geocoded RECORD;
BEGIN
SELECT geomout into geocoded from geocode(address) as g;
SELECT sldust from sldu into district where ST_Within(geocoded,
the_geom);
return district;
END;
$$
LANGUAGE 'plpgsql' IMMUTABLE;
geocoder=# select get_district('1700 C St Lincoln, NE');
ERROR: function st_within(record, geometry) does not exist
LINE 1: SELECT sldust from sldu where ST_Within( $1 , the_geom)
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
QUERY: SELECT sldust from sldu where ST_Within( $1 , the_geom)
CONTEXT: PL/pgSQL function "get_district" line 6 at SQL statement
--
Eric Aspengren
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Census loader
Well now. I see to have discovered, finally, why I was having trouble getting the census loader to work. The script generated wasn't complete. I seem to have a corrupted .sql file. I don't even know where that is in the install. Where would that file be and where can I find a full version of that .sql file to fix it? Eric Aspengren ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Whew
thanks for the follow up! I may put in a ticket. On Fri, Jul 13, 2012 at 2:26 AM, Paragon Corporation wrote: > ** > Not included at the moment. Would require putting an entry in the > loader_generate_tables and also companion structures for each table in > tiger schema and mostly a lot of testing > mostly because census seems to like to change field names etc. every year. > > It's something we've thought about just adding these common entries, but > having them possibly disabled by default so people could choose to load > them if they wanted. > > If you are interested you can put in a ticket: > > http://trac.osgeo.org/postgis/ > > And mark it under tiger geocoder and version 2.1. > > We don't plan to make any more changes (aside from major bug fixes) to the > tiger_2010 (pacakged with 2.0) since tiger_2011 is already vastly > different and more efficient in the way it loads and the client that is > funding most of our work on tiger geocoder is using the tiger_2011 one > packaged with PostGIS 2.1 (though using it on a PostGIS 2.0 database) > > Thanks, > Regina and Leo > http://www.postgis.us > > > -- > *From:* postgis-users-boun...@postgis.refractions.net [mailto: > postgis-users-boun...@postgis.refractions.net] *On Behalf Of *Eric > Aspengren > *Sent:* Thursday, July 12, 2012 11:20 AM > *To:* PostGIS Users Discussion > *Subject:* [postgis-users] Whew > > Ok, so, I've finally gotten a functional geocoder up and running. > > Has anyone had any luck using the scripts provided to load other Tiger > files (Congressional Districts, Statehouse Districts, Etc.)? > > -- > Eric Aspengren > (402) 478-VOTE > ericas...@gmail.com > > > _______ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- Eric Aspengren (402) 478-VOTE ericas...@gmail.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Whew
Ok, so, I've finally gotten a functional geocoder up and running. Has anyone had any luck using the scripts provided to load other Tiger files (Congressional Districts, Statehouse Districts, Etc.)? -- Eric Aspengren (402) 478-VOTE ericas...@gmail.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] I'm so close!
Please ignore this note. I solved the issue. It was very simple, of course. On Mon, Jul 9, 2012 at 11:30 AM, Eric Aspengren wrote: > And yet... > > I've gotten just about everything done in a PostGIS/Tiger Geocoder install > and I get to create_geocode.sh and get a few problems. > > I couldn't this problem being addressed on this list or anywhere else. Any > ideas? > > I get this after all the tables are generated: > > psql:census_loader.sql:102: NOTICE: function > loader_generate_census(text[],text) does not exist, skipping > DROP FUNCTION > CREATE FUNCTION > DELETE 0 > INSERT 0 1 > INSERT 0 1 > INSERT 0 1 > create_census_base_tables > --- > Tables already present > (1 row) > > SET > BEGIN > psql:create_geocode.sql:23: NOTICE: type "norm_addy" does not exist, > skipping > DROP TYPE > CREATE TYPE > CREATE FUNCTION > CREATE FUNCTION > CREATE FUNCTION > psql:utility/levenshtein_ignore_case.sql:5: ERROR: function > levenshtein(text, text) does not exist > LINE 3: SELECT levenshtein(upper($1), upper($2)); > ^ > HINT: No function matches the given name and argument types. You might > need to add explicit type casts. > psql:normalize/end_soundex.sql:17: ERROR: current transaction is aborted, > commands ignored until end of transaction block > psql:normalize/count_words.sql:32: ERROR: current transaction is aborted, > commands ignored until end of transaction block > psql:normalize/state_extract.sql:90: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:normalize/get_last_words.sql:29: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:normalize/location_extract_countysub_exact.sql:56: ERROR: current > transaction is aborted, commands ignored until end of transaction block > psql:normalize/location_extract_countysub_fuzzy.sql:89: ERROR: current > transaction is aborted, commands ignored until end of transaction block > psql:normalize/location_extract_place_exact.sql:62: ERROR: current > transaction is aborted, commands ignored until end of transaction block > psql:normalize/location_extract_place_fuzzy.sql:90: ERROR: current > transaction is aborted, commands ignored until end of transaction block > psql:normalize/location_extract.sql:85: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:normalize/normalize_address.sql:708: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:normalize/pprint_addy.sql:10: ERROR: current transaction is aborted, > commands ignored until end of transaction block > psql:normalize/pprint_addy.sql:43: ERROR: current transaction is aborted, > commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:14: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:22: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:32: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:48: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:58: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:201: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:213: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:240: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:geocode/other_helper_functions.sql:252: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:geocode/rate_attributes.sql:29: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/rate_attributes.sql:80: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/includes_address.sql:94: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/interpolate_from_address.sql:94: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:geocode/geocode_address.sql:435: ERROR: current transaction is > aborted, commands ignored until end of transaction block > psql:geocode/geo
[postgis-users] I'm so close!
of transaction block psql:geocode/census_tracts_functions.sql:57: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK CREATE FUNCTION ERROR: function least_hn(character varying, character varying) does not exist LINE 1: ...idx_tiger_addr_least_address ON addr USING btree (least_hn(f... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. -- Eric Aspengren (402) 478-VOTE ericas...@gmail.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Amazon EC2 and PostGIS 2.0
Has anyone on this list successfully deployed PostGIS 2.0 on AWS? I'm wondering what particular instance people would recommend (Amazon Linux, SuSE, RedHat, Etc)? This will be explicitly for geocoding and such for a fairly large dataset. -- Eric Aspengren (402) 478-VOTE ericas...@gmail.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Server Question
I just dove in and set myself up with Amazon EC2. I'll see if I can come up with a tutorial on installing stuff, if I happen to succeed. On Mon, Mar 12, 2012 at 11:44 AM, Andy Colson wrote: > On 3/12/2012 10:27 AM, Eric Aspengren wrote: > >> I have a couple of questions about getting some server space on the cloud. >> 1) anybody have any luck with this? >> 2) are the servers fast enough to do serious geocoding and such? >> 3) any recommendations? >> 4) what about PostGIS 2.0? anybody planning to support that/already >> supporting the Beta? >> >> -- >> Eric Aspengren >> (402) 478-VOTE >> ericas...@gmail.com <mailto:ericas...@gmail.com> >> >> > I use mod_perl and PG, which nobody supports. I have a small Linode > account for it. Its great because you get complete control -- run > whatever, whenever. > > -Andy > > -- Eric Aspengren (402) 478-VOTE ericas...@gmail.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Server Question
I have a couple of questions about getting some server space on the cloud. 1) anybody have any luck with this? 2) are the servers fast enough to do serious geocoding and such? 3) any recommendations? 4) what about PostGIS 2.0? anybody planning to support that/already supporting the Beta? -- Eric Aspengren (402) 478-VOTE ericas...@gmail.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] 2010 Census
I know this has likely been covered on this list before. So, pardon if this is redundant, I just signed up. I'm looking for a good tutorial to get the new 2010 Census data for a state loaded into a PostGIS database, including all the recent Tiger files and demographic data. Is there a good one out there? -- Eric Aspengren Data Manager Planned Parenthood of the Heartland (402) 478-VOTE ericas...@gmail.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
