Regina Obe
6603fceab6
git-svn-id: http://svn.osgeo.org/postgis/trunk@13957 b70326c6-7e19-0410-871a-916f4a2858ee
39 lines
1.1 KiB
MySQL
39 lines
1.1 KiB
MySQL
---------------------------------------------------------------------
|
|
-- Core function to access the PAGC address standardizer
|
|
-- Author: Stephen Woodbridge <woodbri@imaptools.com>
|
|
---------------------------------------------------------------------
|
|
|
|
CREATE OR REPLACE FUNCTION standardize_address(
|
|
lextab text,
|
|
gaztab text,
|
|
rultab text,
|
|
micro text,
|
|
macro text )
|
|
RETURNS stdaddr
|
|
AS 'MODULE_PATHNAME', 'standardize_address'
|
|
LANGUAGE 'c' IMMUTABLE STRICT COST 200;
|
|
|
|
CREATE OR REPLACE FUNCTION standardize_address(
|
|
lextab text,
|
|
gaztab text,
|
|
rultab text,
|
|
address text )
|
|
RETURNS stdaddr
|
|
AS 'MODULE_PATHNAME', 'standardize_address1'
|
|
LANGUAGE 'c' IMMUTABLE STRICT COST 200;
|
|
|
|
CREATE OR REPLACE FUNCTION parse_address(IN text,
|
|
OUT num text,
|
|
OUT street text,
|
|
OUT street2 text,
|
|
OUT address1 text,
|
|
OUT city text,
|
|
OUT state text,
|
|
OUT zip text,
|
|
OUT zipplus text,
|
|
OUT country text)
|
|
RETURNS record
|
|
AS 'MODULE_PATHNAME', 'parse_address'
|
|
LANGUAGE 'c' IMMUTABLE STRICT;
|
|
|