postgresql-9.3-postgis-scripts 2.1.2+dfsg-2 / usr / share / postgresql / 9.3 / extension / postgis_tiger_geocoder--unpackaged--2.1.2.sql

This file is indexed.

/usr/share/postgresql/9.3/extension/postgis_tiger_geocoder--unpackaged--2.1.2.sql is in postgresql-9.3-postgis-scripts 2.1.2+dfsg-2.

This file is owned by root:root, with mode 0o644.

The actual contents of the file can be viewed below. 

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
 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 schema tiger_data;
 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 bg_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 tabblock_gid_seq;
 ALTER EXTENSION postgis_tiger_geocoder ADD sequence tract_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 bg;
 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 tabblock;
 ALTER EXTENSION postgis_tiger_geocoder ADD table tract;
 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;

APT Browse - Built by Thomas Orozco.