From 872745dc2b4ea27e165071ab2099707e5325f737 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Wed, 1 May 2013 05:51:08 +0000 Subject: [PATCH] revise unpackaged to include pagc stuff git-svn-id: http://svn.osgeo.org/postgis/trunk@11333 b70326c6-7e19-0410-871a-916f4a2858ee --- .../tiger_geocoder--unpackaged.sql.in | 180 +++++++++--------- 1 file changed, 94 insertions(+), 86 deletions(-) diff --git a/extensions/postgis_tiger_geocoder/sql_bits/tiger_geocoder--unpackaged.sql.in b/extensions/postgis_tiger_geocoder/sql_bits/tiger_geocoder--unpackaged.sql.in index 8063a8cb8..fc1f38396 100644 --- a/extensions/postgis_tiger_geocoder/sql_bits/tiger_geocoder--unpackaged.sql.in +++ b/extensions/postgis_tiger_geocoder/sql_bits/tiger_geocoder--unpackaged.sql.in @@ -1,87 +1,95 @@ -ALTER EXTENSION postgis_tiger_geocoder ADD function count_words(character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function create_census_base_tables(); -ALTER EXTENSION postgis_tiger_geocoder ADD function cull_null(character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function diff_zip(character varying,character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function drop_dupe_featnames_generate_script(); -ALTER EXTENSION postgis_tiger_geocoder ADD function drop_indexes_generate_script(text); -ALTER EXTENSION postgis_tiger_geocoder ADD function drop_nation_tables_generate_script(text); -ALTER EXTENSION postgis_tiger_geocoder ADD function drop_state_tables_generate_script(text,text); -ALTER EXTENSION postgis_tiger_geocoder ADD function end_soundex(character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function geocode(character varying,integer,geometry); -ALTER EXTENSION postgis_tiger_geocoder ADD function geocode(norm_addy,integer,geometry); -ALTER EXTENSION postgis_tiger_geocoder ADD function geocode_address(norm_addy,integer,geometry); -ALTER EXTENSION postgis_tiger_geocoder ADD function geocode_intersection(text,text,text,text,text,integer); -ALTER EXTENSION postgis_tiger_geocoder ADD function geocode_location(norm_addy,geometry); -ALTER EXTENSION postgis_tiger_geocoder ADD function get_geocode_setting(text); -ALTER EXTENSION postgis_tiger_geocoder ADD function get_last_words(character varying,integer); -ALTER EXTENSION postgis_tiger_geocoder ADD function get_tract(geometry,text); -ALTER EXTENSION postgis_tiger_geocoder ADD function greatest_hn(character varying,character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function includes_address(integer,integer,integer,integer,integer); -ALTER EXTENSION postgis_tiger_geocoder ADD function install_geocode_settings(); -ALTER EXTENSION postgis_tiger_geocoder ADD function install_missing_indexes(); -ALTER EXTENSION postgis_tiger_geocoder ADD function interpolate_from_address(integer,character varying,character varying,geometry,character varying,double precision); -ALTER EXTENSION postgis_tiger_geocoder ADD function is_pretype(text); -ALTER EXTENSION postgis_tiger_geocoder ADD function least_hn(character varying,character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function levenshtein_ignore_case(character varying,character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function loader_generate_census_script(text[],text); -ALTER EXTENSION postgis_tiger_geocoder ADD function loader_generate_nation_script(text); -ALTER EXTENSION postgis_tiger_geocoder ADD function loader_generate_script(text[],text); -ALTER EXTENSION postgis_tiger_geocoder ADD function loader_load_staged_data(text,text); -ALTER EXTENSION postgis_tiger_geocoder ADD function loader_load_staged_data(text,text,text[]); -ALTER EXTENSION postgis_tiger_geocoder ADD function loader_macro_replace(text,text[],text[]); -ALTER EXTENSION postgis_tiger_geocoder ADD function location_extract(character varying,character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function location_extract_countysub_exact(character varying,character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function location_extract_countysub_fuzzy(character varying,character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function location_extract_place_exact(character varying,character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function location_extract_place_fuzzy(character varying,character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function missing_indexes_generate_script(); -ALTER EXTENSION postgis_tiger_geocoder ADD function normalize_address(character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function nullable_levenshtein(character varying,character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function numeric_streets_equal(character varying,character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function pprint_addy(norm_addy); -ALTER EXTENSION postgis_tiger_geocoder ADD function rate_attributes(character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function rate_attributes(character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function reverse_geocode(geometry,boolean); -ALTER EXTENSION postgis_tiger_geocoder ADD function set_geocode_setting(text,text); -ALTER EXTENSION postgis_tiger_geocoder ADD function setsearchpathforinstall(character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function state_extract(character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function topology_load_tiger(character varying,character varying,character varying); -ALTER EXTENSION postgis_tiger_geocoder ADD function utmzone(geometry); -ALTER EXTENSION postgis_tiger_geocoder ADD function zip_range(text,integer,integer); -ALTER EXTENSION postgis_tiger_geocoder ADD sequence addr_gid_seq; -ALTER EXTENSION postgis_tiger_geocoder ADD sequence addrfeat_gid_seq; -ALTER EXTENSION postgis_tiger_geocoder ADD sequence county_gid_seq; -ALTER EXTENSION postgis_tiger_geocoder ADD sequence cousub_gid_seq; -ALTER EXTENSION postgis_tiger_geocoder ADD sequence edges_gid_seq; -ALTER EXTENSION postgis_tiger_geocoder ADD sequence faces_gid_seq; -ALTER EXTENSION postgis_tiger_geocoder ADD sequence featnames_gid_seq; -ALTER EXTENSION postgis_tiger_geocoder ADD sequence place_gid_seq; -ALTER EXTENSION postgis_tiger_geocoder ADD sequence state_gid_seq; -ALTER EXTENSION postgis_tiger_geocoder ADD sequence zcta5_gid_seq; -ALTER EXTENSION postgis_tiger_geocoder ADD table addr; -ALTER EXTENSION postgis_tiger_geocoder ADD table addrfeat; -ALTER EXTENSION postgis_tiger_geocoder ADD table county; -ALTER EXTENSION postgis_tiger_geocoder ADD table county_lookup; -ALTER EXTENSION postgis_tiger_geocoder ADD table countysub_lookup; -ALTER EXTENSION postgis_tiger_geocoder ADD table cousub; -ALTER EXTENSION postgis_tiger_geocoder ADD table direction_lookup; -ALTER EXTENSION postgis_tiger_geocoder ADD table edges; -ALTER EXTENSION postgis_tiger_geocoder ADD table faces; -ALTER EXTENSION postgis_tiger_geocoder ADD table featnames; -ALTER EXTENSION postgis_tiger_geocoder ADD table geocode_settings; -ALTER EXTENSION postgis_tiger_geocoder ADD table loader_lookuptables; -ALTER EXTENSION postgis_tiger_geocoder ADD table loader_platform; -ALTER EXTENSION postgis_tiger_geocoder ADD table loader_variables; -ALTER EXTENSION postgis_tiger_geocoder ADD table place; -ALTER EXTENSION postgis_tiger_geocoder ADD table place_lookup; -ALTER EXTENSION postgis_tiger_geocoder ADD table secondary_unit_lookup; -ALTER EXTENSION postgis_tiger_geocoder ADD table state; -ALTER EXTENSION postgis_tiger_geocoder ADD table state_lookup; -ALTER EXTENSION postgis_tiger_geocoder ADD table street_type_lookup; -ALTER EXTENSION postgis_tiger_geocoder ADD table zcta5; -ALTER EXTENSION postgis_tiger_geocoder ADD table zip_lookup; -ALTER EXTENSION postgis_tiger_geocoder ADD table zip_lookup_all; -ALTER EXTENSION postgis_tiger_geocoder ADD table zip_lookup_base; -ALTER EXTENSION postgis_tiger_geocoder ADD table zip_state; -ALTER EXTENSION postgis_tiger_geocoder ADD table zip_state_loc; +ALTER EXTENSION postgis_tiger_geocoder ADD function count_words(character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function create_census_base_tables(); +ALTER EXTENSION postgis_tiger_geocoder ADD function cull_null(character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function diff_zip(character varying,character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function drop_dupe_featnames_generate_script(); +ALTER EXTENSION postgis_tiger_geocoder ADD function drop_indexes_generate_script(text); +ALTER EXTENSION postgis_tiger_geocoder ADD function drop_nation_tables_generate_script(text); +ALTER EXTENSION postgis_tiger_geocoder ADD function drop_state_tables_generate_script(text,text); +ALTER EXTENSION postgis_tiger_geocoder ADD function end_soundex(character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function geocode(character varying,integer,geometry); +ALTER EXTENSION postgis_tiger_geocoder ADD function geocode(norm_addy,integer,geometry); +ALTER EXTENSION postgis_tiger_geocoder ADD function geocode_address(norm_addy,integer,geometry); +ALTER EXTENSION postgis_tiger_geocoder ADD function geocode_intersection(text,text,text,text,text,integer); +ALTER EXTENSION postgis_tiger_geocoder ADD function geocode_location(norm_addy,geometry); +ALTER EXTENSION postgis_tiger_geocoder ADD function get_geocode_setting(text); +ALTER EXTENSION postgis_tiger_geocoder ADD function get_last_words(character varying,integer); +ALTER EXTENSION postgis_tiger_geocoder ADD function get_tract(geometry,text); +ALTER EXTENSION postgis_tiger_geocoder ADD function greatest_hn(character varying,character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function includes_address(integer,integer,integer,integer,integer); +ALTER EXTENSION postgis_tiger_geocoder ADD function install_geocode_settings(); +ALTER EXTENSION postgis_tiger_geocoder ADD function install_missing_indexes(); +ALTER EXTENSION postgis_tiger_geocoder ADD function install_pagc_tables(); +ALTER EXTENSION postgis_tiger_geocoder ADD function interpolate_from_address(integer,character varying,character varying,geometry,character varying,double precision); +ALTER EXTENSION postgis_tiger_geocoder ADD function is_pretype(text); +ALTER EXTENSION postgis_tiger_geocoder ADD function least_hn(character varying,character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function levenshtein_ignore_case(character varying,character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function loader_generate_census_script(text[],text); +ALTER EXTENSION postgis_tiger_geocoder ADD function loader_generate_nation_script(text); +ALTER EXTENSION postgis_tiger_geocoder ADD function loader_generate_script(text[],text); +ALTER EXTENSION postgis_tiger_geocoder ADD function loader_load_staged_data(text,text); +ALTER EXTENSION postgis_tiger_geocoder ADD function loader_load_staged_data(text,text,text[]); +ALTER EXTENSION postgis_tiger_geocoder ADD function loader_macro_replace(text,text[],text[]); +ALTER EXTENSION postgis_tiger_geocoder ADD function location_extract(character varying,character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function location_extract_countysub_exact(character varying,character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function location_extract_countysub_fuzzy(character varying,character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function location_extract_place_exact(character varying,character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function location_extract_place_fuzzy(character varying,character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function missing_indexes_generate_script(); +ALTER EXTENSION postgis_tiger_geocoder ADD function normalize_address(character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function nullable_levenshtein(character varying,character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function numeric_streets_equal(character varying,character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function pagc_normalize_address(character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function pprint_addy(norm_addy); +ALTER EXTENSION postgis_tiger_geocoder ADD function rate_attributes(character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function rate_attributes(character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function reverse_geocode(geometry,boolean); +ALTER EXTENSION postgis_tiger_geocoder ADD function set_geocode_setting(text,text); +ALTER EXTENSION postgis_tiger_geocoder ADD function setsearchpathforinstall(character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function state_extract(character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function topology_load_tiger(character varying,character varying,character varying); +ALTER EXTENSION postgis_tiger_geocoder ADD function utmzone(geometry); +ALTER EXTENSION postgis_tiger_geocoder ADD function zip_range(text,integer,integer); +ALTER EXTENSION postgis_tiger_geocoder ADD sequence addr_gid_seq; +ALTER EXTENSION postgis_tiger_geocoder ADD sequence addrfeat_gid_seq; +ALTER EXTENSION postgis_tiger_geocoder ADD sequence county_gid_seq; +ALTER EXTENSION postgis_tiger_geocoder ADD sequence cousub_gid_seq; +ALTER EXTENSION postgis_tiger_geocoder ADD sequence edges_gid_seq; +ALTER EXTENSION postgis_tiger_geocoder ADD sequence faces_gid_seq; +ALTER EXTENSION postgis_tiger_geocoder ADD sequence featnames_gid_seq; +ALTER EXTENSION postgis_tiger_geocoder ADD sequence pagc_gaz_id_seq; +ALTER EXTENSION postgis_tiger_geocoder ADD sequence pagc_lex_id_seq; +ALTER EXTENSION postgis_tiger_geocoder ADD sequence pagc_rules_id_seq; +ALTER EXTENSION postgis_tiger_geocoder ADD sequence place_gid_seq; +ALTER EXTENSION postgis_tiger_geocoder ADD sequence state_gid_seq; +ALTER EXTENSION postgis_tiger_geocoder ADD sequence zcta5_gid_seq; +ALTER EXTENSION postgis_tiger_geocoder ADD table addr; +ALTER EXTENSION postgis_tiger_geocoder ADD table addrfeat; +ALTER EXTENSION postgis_tiger_geocoder ADD table county; +ALTER EXTENSION postgis_tiger_geocoder ADD table county_lookup; +ALTER EXTENSION postgis_tiger_geocoder ADD table countysub_lookup; +ALTER EXTENSION postgis_tiger_geocoder ADD table cousub; +ALTER EXTENSION postgis_tiger_geocoder ADD table direction_lookup; +ALTER EXTENSION postgis_tiger_geocoder ADD table edges; +ALTER EXTENSION postgis_tiger_geocoder ADD table faces; +ALTER EXTENSION postgis_tiger_geocoder ADD table featnames; +ALTER EXTENSION postgis_tiger_geocoder ADD table geocode_settings; +ALTER EXTENSION postgis_tiger_geocoder ADD table loader_lookuptables; +ALTER EXTENSION postgis_tiger_geocoder ADD table loader_platform; +ALTER EXTENSION postgis_tiger_geocoder ADD table loader_variables; +ALTER EXTENSION postgis_tiger_geocoder ADD table pagc_gaz; +ALTER EXTENSION postgis_tiger_geocoder ADD table pagc_lex; +ALTER EXTENSION postgis_tiger_geocoder ADD table pagc_rules; +ALTER EXTENSION postgis_tiger_geocoder ADD table place; +ALTER EXTENSION postgis_tiger_geocoder ADD table place_lookup; +ALTER EXTENSION postgis_tiger_geocoder ADD table secondary_unit_lookup; +ALTER EXTENSION postgis_tiger_geocoder ADD table state; +ALTER EXTENSION postgis_tiger_geocoder ADD table state_lookup; +ALTER EXTENSION postgis_tiger_geocoder ADD table street_type_lookup; +ALTER EXTENSION postgis_tiger_geocoder ADD table zcta5; +ALTER EXTENSION postgis_tiger_geocoder ADD table zip_lookup; +ALTER EXTENSION postgis_tiger_geocoder ADD table zip_lookup_all; +ALTER EXTENSION postgis_tiger_geocoder ADD table zip_lookup_base; +ALTER EXTENSION postgis_tiger_geocoder ADD table zip_state; +ALTER EXTENSION postgis_tiger_geocoder ADD table zip_state_loc; ALTER EXTENSION postgis_tiger_geocoder ADD type norm_addy; \ No newline at end of file -- 2.40.0