1# SOME DESCRIPTIVE TITLE. 2# 3# Translators: 4msgid "" 5msgstr "" 6"Project-Id-Version: PostGIS\n" 7"Report-Msgid-Bugs-To: https://bugs.kde.org\n" 8"POT-Creation-Date: 2021-09-11 01:55+0000\n" 9"PO-Revision-Date: 2018-07-23 18:00+0000\n" 10"Last-Translator: Milena Nowotarska <do.milenki@gmail.com>\n" 11"Language-Team: Polish (http://www.transifex.com/postgis/postgis/language/" 12"pl/)\n" 13"Language: pl\n" 14"MIME-Version: 1.0\n" 15"Content-Type: text/plain; charset=UTF-8\n" 16"Content-Transfer-Encoding: 8bit\n" 17"Plural-Forms: nplurals=4; plural=(n==1 ? 0 : (n%10>=2 && n%10<=4) && (n" 18"%100<12 || n%100>14) ? 1 : n!=1 && (n%10>=0 && n%10<=1) || (n%10>=5 && n" 19"%10<=9) || (n%100>=12 && n%100<=14) ? 2 : 3);\n" 20 21#. Tag: title 22#: extras_address_standardizer.xml:3 23#, no-c-format 24msgid "Address Standardizer" 25msgstr "" 26 27#. Tag: para 28#: extras_address_standardizer.xml:4 29#, no-c-format 30msgid "" 31"This is a fork of the <ulink url=\"http://www.pagcgeo.org/docs/html/pagc-11." 32"html\">PAGC standardizer</ulink> (original code for this portion was <ulink " 33"url=\"http://sourceforge.net/p/pagc/code/360/tree/branches/sew-refactor/" 34"postgresql\">PAGC PostgreSQL Address Standardizer</ulink>)." 35msgstr "" 36 37#. Tag: para 38#: extras_address_standardizer.xml:5 39#, no-c-format 40msgid "" 41"The address standardizer is a single line address parser that takes an input " 42"address and normalizes it based on a set of rules stored in a table and " 43"helper lex and gaz tables." 44msgstr "" 45 46#. Tag: para 47#: extras_address_standardizer.xml:6 48#, no-c-format 49msgid "" 50"The code is built into a single PostgreSQL extension library called " 51"<code>address_standardizer</code> which can be installed with <code>CREATE " 52"EXTENSION address_standardizer;</code>. In addition to the " 53"address_standardizer extension, a sample data extension called " 54"<code>address_standardizer_data_us</code> extensions is built, which " 55"contains gaz, lex, and rules tables for US data. This extensions can be " 56"installed via: <code>CREATE EXTENSION address_standardizer_data_us;</code>" 57msgstr "" 58 59#. Tag: para 60#: extras_address_standardizer.xml:7 61#, no-c-format 62msgid "" 63"The code for this extension can be found in the PostGIS <filename>extensions/" 64"address_standardizer</filename> and is currently self-contained." 65msgstr "" 66 67#. Tag: para 68#: extras_address_standardizer.xml:8 69#, no-c-format 70msgid "" 71"For installation instructions refer to: <xref linkend=" 72"\"installing_pagc_address_standardizer\"/>." 73msgstr "" 74 75#. Tag: title 76#: extras_address_standardizer.xml:9 77#, no-c-format 78msgid "How the Parser Works" 79msgstr "" 80 81#. Tag: para 82#: extras_address_standardizer.xml:10 83#, no-c-format 84msgid "" 85"The parser works from right to left looking first at the macro elements for " 86"postcode, state/province, city, and then looks micro elements to determine " 87"if we are dealing with a house number street or intersection or landmark. It " 88"currently does not look for a country code or name, but that could be " 89"introduced in the future." 90msgstr "" 91 92#. Tag: term 93#: extras_address_standardizer.xml:17 94#, no-c-format 95msgid "Country code" 96msgstr "" 97 98#. Tag: para 99#: extras_address_standardizer.xml:18 100#, no-c-format 101msgid "" 102"Assumed to be US or CA based on: postcode as US or Canada state/province as " 103"US or Canada else US" 104msgstr "" 105 106#. Tag: term 107#: extras_address_standardizer.xml:21 108#, no-c-format 109msgid "Postcode/zipcode" 110msgstr "" 111 112#. Tag: para 113#: extras_address_standardizer.xml:22 114#, no-c-format 115msgid "" 116"These are recognized using Perl compatible regular expressions. These regexs " 117"are currently in the parseaddress-api.c and are relatively simple to make " 118"changes to if needed." 119msgstr "" 120 121#. Tag: term 122#: extras_address_standardizer.xml:27 123#, no-c-format 124msgid "State/province" 125msgstr "" 126 127#. Tag: para 128#: extras_address_standardizer.xml:28 129#, no-c-format 130msgid "" 131"These are recognized using Perl compatible regular expressions. These regexs " 132"are currently in the parseaddress-api.c but could get moved into includes in " 133"the future for easier maintenance." 134msgstr "" 135 136#. Tag: para 137#: extras_address_standardizer.xml:37 138#, no-c-format 139msgid "" 140"This section lists the PostgreSQL data types installed by Address " 141"Standardizer extension. Note we describe the casting behavior of these which " 142"is very important especially when designing your own functions." 143msgstr "" 144 145#. Tag: title 146#: extras_address_standardizer.xml:42 147#, no-c-format 148msgid "Address Standardizer Types" 149msgstr "" 150 151#. Tag: refname 152#: extras_address_standardizer.xml:45 153#, no-c-format 154msgid "stdaddr" 155msgstr "" 156 157#. Tag: refpurpose 158#: extras_address_standardizer.xml:46 159#, no-c-format 160msgid "" 161"A composite type that consists of the elements of an address. This is the " 162"return type for <varname>standardize_address</varname> function." 163msgstr "" 164 165#. Tag: title 166#: extras_address_standardizer.xml:49 extras_address_standardizer.xml:153 167#: extras_address_standardizer.xml:486 extras_address_standardizer.xml:528 168#: extras_address_standardizer.xml:586 extras_address_standardizer.xml:646 169#, no-c-format 170msgid "Description" 171msgstr "Opis" 172 173#. Tag: para 174#: extras_address_standardizer.xml:50 175#, no-c-format 176msgid "" 177"A composite type that consists of elements of an address. This is the return " 178"type for <xref linkend=\"standardize_address\"/> function. Some descriptions " 179"for elements are borrowed from <ulink url=\"http://www.pagcgeo.org/docs/html/" 180"pagc-12.html#ss12.1\">PAGC Postal Attributes</ulink>." 181msgstr "" 182 183#. Tag: para 184#: extras_address_standardizer.xml:51 185#, no-c-format 186msgid "" 187"The token numbers denote the output reference number in the <xref linkend=" 188"\"rulestab\"/>." 189msgstr "" 190 191#. Tag: para 192#: extras_address_standardizer.xml:52 extras_address_standardizer.xml:593 193#: extras_address_standardizer.xml:655 194#, no-c-format 195msgid "&address_standardizer_required;" 196msgstr "" 197 198#. Tag: term 199#: extras_address_standardizer.xml:55 200#, no-c-format 201msgid "building" 202msgstr "" 203 204#. Tag: para 205#: extras_address_standardizer.xml:57 206#, no-c-format 207msgid "" 208"is text (token number <code>0</code>): Refers to building number or name. " 209"Unparsed building identifiers and types. Generally blank for most addresses." 210msgstr "" 211 212#. Tag: term 213#: extras_address_standardizer.xml:60 214#, no-c-format 215msgid "house_num" 216msgstr "" 217 218#. Tag: para 219#: extras_address_standardizer.xml:62 extras_address_standardizer.xml:397 220#, no-c-format 221msgid "" 222"is a text (token number <code>1</code>): This is the street number on a " 223"street. Example <emphasis>75</emphasis> in <code>75 State Street</code>." 224msgstr "" 225 226#. Tag: term 227#: extras_address_standardizer.xml:65 extras_address_standardizer.xml:400 228#, no-c-format 229msgid "predir" 230msgstr "" 231 232#. Tag: para 233#: extras_address_standardizer.xml:66 extras_address_standardizer.xml:401 234#, no-c-format 235msgid "" 236"is text (token number <code>2</code>): STREET NAME PRE-DIRECTIONAL such as " 237"North, South, East, West etc." 238msgstr "" 239 240#. Tag: term 241#: extras_address_standardizer.xml:68 extras_address_standardizer.xml:403 242#, no-c-format 243msgid "qual" 244msgstr "" 245 246#. Tag: para 247#: extras_address_standardizer.xml:70 extras_address_standardizer.xml:405 248#, no-c-format 249msgid "" 250"is text (token number <code>3</code>): STREET NAME PRE-MODIFIER Example " 251"<emphasis>OLD</emphasis> in <code>3715 OLD HIGHWAY 99</code>." 252msgstr "" 253 254#. Tag: term 255#: extras_address_standardizer.xml:73 extras_address_standardizer.xml:408 256#, no-c-format 257msgid "pretype" 258msgstr "" 259 260#. Tag: para 261#: extras_address_standardizer.xml:75 extras_address_standardizer.xml:410 262#, no-c-format 263msgid "is text (token number <code>4</code>): STREET PREFIX TYPE" 264msgstr "" 265 266#. Tag: term 267#: extras_address_standardizer.xml:78 268#, no-c-format 269msgid "name" 270msgstr "" 271 272#. Tag: para 273#: extras_address_standardizer.xml:80 extras_address_standardizer.xml:415 274#, no-c-format 275msgid "is text (token number <code>5</code>): STREET NAME" 276msgstr "" 277 278#. Tag: term 279#: extras_address_standardizer.xml:83 extras_address_standardizer.xml:418 280#, no-c-format 281msgid "suftype" 282msgstr "" 283 284#. Tag: para 285#: extras_address_standardizer.xml:85 extras_address_standardizer.xml:420 286#, no-c-format 287msgid "" 288"is text (token number <code>6</code>): STREET POST TYPE e.g. St, Ave, Cir. A " 289"street type following the root street name. Example <emphasis>STREET</" 290"emphasis> in <code>75 State Street</code>." 291msgstr "" 292 293#. Tag: term 294#: extras_address_standardizer.xml:88 extras_address_standardizer.xml:423 295#, no-c-format 296msgid "sufdir" 297msgstr "" 298 299#. Tag: para 300#: extras_address_standardizer.xml:90 extras_address_standardizer.xml:425 301#, no-c-format 302msgid "" 303"is text (token number <code>7</code>): STREET POST-DIRECTIONAL A directional " 304"modifier that follows the street name.. Example <emphasis>WEST</emphasis> in " 305"<code>3715 TENTH AVENUE WEST</code>." 306msgstr "" 307 308#. Tag: term 309#: extras_address_standardizer.xml:93 310#, no-c-format 311msgid "ruralroute" 312msgstr "" 313 314#. Tag: para 315#: extras_address_standardizer.xml:95 316#, no-c-format 317msgid "" 318"is text (token number <code>8</code>): RURAL ROUTE . Example <emphasis>7</" 319"emphasis> in <code>RR 7</code>." 320msgstr "" 321 322#. Tag: term 323#: extras_address_standardizer.xml:98 324#, no-c-format 325msgid "extra" 326msgstr "" 327 328#. Tag: para 329#: extras_address_standardizer.xml:100 330#, no-c-format 331msgid "is text: Extra information like Floor number." 332msgstr "" 333 334#. Tag: term 335#: extras_address_standardizer.xml:103 336#, no-c-format 337msgid "city" 338msgstr "" 339 340#. Tag: para 341#: extras_address_standardizer.xml:105 342#, no-c-format 343msgid "is text (token number <code>10</code>): Example Boston." 344msgstr "" 345 346#. Tag: term 347#: extras_address_standardizer.xml:108 348#, no-c-format 349msgid "state" 350msgstr "" 351 352#. Tag: para 353#: extras_address_standardizer.xml:110 354#, no-c-format 355msgid "" 356"is text (token number <code>11</code>): Example <code>MASSACHUSETTS</code>" 357msgstr "" 358 359#. Tag: term 360#: extras_address_standardizer.xml:113 361#, no-c-format 362msgid "country" 363msgstr "" 364 365#. Tag: para 366#: extras_address_standardizer.xml:115 367#, no-c-format 368msgid "is text (token number <code>12</code>): Example <code>USA</code>" 369msgstr "" 370 371#. Tag: term 372#: extras_address_standardizer.xml:118 373#, no-c-format 374msgid "postcode" 375msgstr "" 376 377#. Tag: para 378#: extras_address_standardizer.xml:120 379#, no-c-format 380msgid "" 381"is text POSTAL CODE (ZIP CODE) (token number <code>13</code>): Example " 382"<code>02109</code>" 383msgstr "" 384 385#. Tag: term 386#: extras_address_standardizer.xml:123 387#, no-c-format 388msgid "<term>box</term>" 389msgstr "" 390 391#. Tag: para 392#: extras_address_standardizer.xml:125 393#, no-c-format 394msgid "" 395"is text POSTAL BOX NUMBER (token number <code>14 and 15</code>): Example " 396"<code>02109</code>" 397msgstr "" 398 399#. Tag: term 400#: extras_address_standardizer.xml:128 401#, no-c-format 402msgid "unit" 403msgstr "" 404 405#. Tag: para 406#: extras_address_standardizer.xml:130 407#, no-c-format 408msgid "" 409"is text Apartment number or Suite Number (token number <code>17</code>): " 410"Example <emphasis>3B</emphasis> in <code>APT 3B</code>." 411msgstr "" 412 413#. Tag: para 414#: extras_address_standardizer.xml:141 415#, no-c-format 416msgid "" 417"This section lists the PostgreSQL table formats used by the " 418"address_standardizer for normalizing addresses. Note that these tables do " 419"not need to be named the same as what is referenced here. You can have " 420"different lex, gaz, rules tables for each country for example or for your " 421"custom geocoder. The names of these tables get passed into the address " 422"standardizer functions." 423msgstr "" 424 425#. Tag: para 426#: extras_address_standardizer.xml:143 427#, no-c-format 428msgid "" 429"The packaged extension <varname>address_standardizer_data_us</varname> " 430"contains data for standardizing US addresses." 431msgstr "" 432 433#. Tag: title 434#: extras_address_standardizer.xml:146 435#, no-c-format 436msgid "Address Standardizer Tables" 437msgstr "" 438 439#. Tag: refname 440#: extras_address_standardizer.xml:149 441#, no-c-format 442msgid "rules table" 443msgstr "" 444 445#. Tag: refpurpose 446#: extras_address_standardizer.xml:150 447#, no-c-format 448msgid "" 449"The rules table contains a set of rules that maps address input sequence " 450"tokens to standardized output sequence. A rule is defined as a set of input " 451"tokens followed by -1 (terminator) followed by set of output tokens followed " 452"by -1 followed by number denoting kind of rule followed by ranking of rule." 453msgstr "" 454 455#. Tag: para 456#: extras_address_standardizer.xml:154 457#, no-c-format 458msgid "" 459"A rules table must have at least the following columns, though you are " 460"allowed to add more for your own uses." 461msgstr "" 462 463#. Tag: term 464#: extras_address_standardizer.xml:158 extras_address_standardizer.xml:492 465#: extras_address_standardizer.xml:534 466#, no-c-format 467msgid "<term>id</term>" 468msgstr "" 469 470#. Tag: para 471#: extras_address_standardizer.xml:160 extras_address_standardizer.xml:494 472#: extras_address_standardizer.xml:536 473#, no-c-format 474msgid "Primary key of table" 475msgstr "" 476 477#. Tag: term 478#: extras_address_standardizer.xml:163 479#, no-c-format 480msgid "rule" 481msgstr "" 482 483#. Tag: para 484#: extras_address_standardizer.xml:165 485#, no-c-format 486msgid "" 487"text field denoting the rule. Details at <ulink url=\"http://www.pagcgeo.org/" 488"docs/html/pagc-12.html#--r-rec--\">PAGC Address Standardizer Rule records</" 489"ulink>." 490msgstr "" 491 492#. Tag: para 493#: extras_address_standardizer.xml:166 494#, no-c-format 495msgid "" 496"A rule consists of a set of non-negative integers representing input tokens, " 497"terminated by a -1, followed by an equal number of non-negative integers " 498"representing postal attributes, terminated by a -1, followed by an integer " 499"representing a rule type, followed by an integer representing the rank of " 500"the rule. The rules are ranked from 0 (lowest) to 17 (highest)." 501msgstr "" 502 503#. Tag: para 504#: extras_address_standardizer.xml:167 505#, no-c-format 506msgid "" 507"So for example the rule <code>2 0 2 22 3 -1 5 5 6 7 3 -1 2 6</code> maps to " 508"sequence of output tokens <emphasis>TYPE NUMBER TYPE DIRECT QUALIF</" 509"emphasis> to the output sequence <emphasis>STREET STREET SUFTYP SUFDIR " 510"QUALIF</emphasis>. The rule is an ARC_C rule of rank 6." 511msgstr "" 512 513#. Tag: para 514#: extras_address_standardizer.xml:168 515#, no-c-format 516msgid "" 517"Numbers for corresponding output tokens are listed in <xref linkend=\"stdaddr" 518"\"/>." 519msgstr "" 520 521#. Tag: title 522#: extras_address_standardizer.xml:174 523#, no-c-format 524msgid "Input Tokens" 525msgstr "" 526 527#. Tag: para 528#: extras_address_standardizer.xml:175 529#, no-c-format 530msgid "" 531"Each rule starts with a set of input tokens followed by a terminator " 532"<code>-1</code>. Valid input tokens excerpted from <ulink url=\"http://www." 533"pagcgeo.org/docs/html/pagc-12.html#ss12.2\">PAGC Input Tokens</ulink> are as " 534"follows:" 535msgstr "" 536 537#. Tag: emphasis 538#: extras_address_standardizer.xml:176 539#, no-c-format 540msgid "Form-Based Input Tokens" 541msgstr "" 542 543#. Tag: term 544#: extras_address_standardizer.xml:179 545#, no-c-format 546msgid "AMPERS" 547msgstr "" 548 549#. Tag: para 550#: extras_address_standardizer.xml:181 551#, no-c-format 552msgid "" 553"(13). The ampersand (&) is frequently used to abbreviate the word \"and" 554"\"." 555msgstr "" 556 557#. Tag: term 558#: extras_address_standardizer.xml:186 559#, no-c-format 560msgid "DASH" 561msgstr "" 562 563#. Tag: para 564#: extras_address_standardizer.xml:188 565#, no-c-format 566msgid "(9). A punctuation character." 567msgstr "" 568 569#. Tag: term 570#: extras_address_standardizer.xml:193 571#, no-c-format 572msgid "DOUBLE" 573msgstr "" 574 575#. Tag: para 576#: extras_address_standardizer.xml:195 577#, no-c-format 578msgid "(21). A sequence of two letters. Often used as identifiers." 579msgstr "" 580 581#. Tag: term 582#: extras_address_standardizer.xml:200 583#, no-c-format 584msgid "FRACT" 585msgstr "" 586 587#. Tag: para 588#: extras_address_standardizer.xml:202 589#, no-c-format 590msgid "(25). Fractions are sometimes used in civic numbers or unit numbers." 591msgstr "" 592 593#. Tag: term 594#: extras_address_standardizer.xml:207 595#, no-c-format 596msgid "MIXED" 597msgstr "" 598 599#. Tag: para 600#: extras_address_standardizer.xml:209 601#, no-c-format 602msgid "" 603"(23). An alphanumeric string that contains both letters and digits. Used for " 604"identifiers." 605msgstr "" 606 607#. Tag: term 608#: extras_address_standardizer.xml:214 609#, no-c-format 610msgid "NUMBER" 611msgstr "" 612 613#. Tag: para 614#: extras_address_standardizer.xml:216 615#, no-c-format 616msgid "(0). A string of digits." 617msgstr "" 618 619#. Tag: term 620#: extras_address_standardizer.xml:221 extras_address_standardizer.xml:228 621#, no-c-format 622msgid "<term>ORD</term>" 623msgstr "" 624 625#. Tag: para 626#: extras_address_standardizer.xml:223 627#, no-c-format 628msgid "(15). Representations such as First or 1st. Often used in street names." 629msgstr "" 630 631#. Tag: para 632#: extras_address_standardizer.xml:230 633#, no-c-format 634msgid "(18). A single letter." 635msgstr "" 636 637#. Tag: term 638#: extras_address_standardizer.xml:235 639#, no-c-format 640msgid "WORD" 641msgstr "" 642 643#. Tag: para 644#: extras_address_standardizer.xml:237 645#, no-c-format 646msgid "" 647"(1). A word is a string of letters of arbitrary length. A single letter can " 648"be both a SINGLE and a WORD." 649msgstr "" 650 651#. Tag: emphasis 652#: extras_address_standardizer.xml:242 653#, no-c-format 654msgid "Function-based Input Tokens" 655msgstr "" 656 657#. Tag: term 658#: extras_address_standardizer.xml:245 extras_address_standardizer.xml:446 659#, no-c-format 660msgid "BOXH" 661msgstr "" 662 663#. Tag: para 664#: extras_address_standardizer.xml:247 665#, no-c-format 666msgid "" 667"(14). Words used to denote post office boxes. For example <emphasis>Box</" 668"emphasis> or <emphasis>PO Box</emphasis>." 669msgstr "" 670 671#. Tag: term 672#: extras_address_standardizer.xml:252 673#, no-c-format 674msgid "BUILDH" 675msgstr "" 676 677#. Tag: para 678#: extras_address_standardizer.xml:254 679#, no-c-format 680msgid "" 681"(19). Words used to denote buildings or building complexes, usually as a " 682"prefix. For example: <emphasis>Tower</emphasis> in <emphasis>Tower 7A</" 683"emphasis>." 684msgstr "" 685 686#. Tag: term 687#: extras_address_standardizer.xml:259 688#, no-c-format 689msgid "BUILDT" 690msgstr "" 691 692#. Tag: para 693#: extras_address_standardizer.xml:261 694#, no-c-format 695msgid "" 696"(24). Words and abbreviations used to denote buildings or building " 697"complexes, usually as a suffix. For example: <emphasis>Shopping Centre</" 698"emphasis>." 699msgstr "" 700 701#. Tag: term 702#: extras_address_standardizer.xml:266 703#, no-c-format 704msgid "DIRECT" 705msgstr "" 706 707#. Tag: para 708#: extras_address_standardizer.xml:268 709#, no-c-format 710msgid "" 711"(22). Words used to denote directions, for example <emphasis>North</" 712"emphasis>." 713msgstr "" 714 715#. Tag: term 716#: extras_address_standardizer.xml:273 717#, no-c-format 718msgid "MILE" 719msgstr "" 720 721#. Tag: para 722#: extras_address_standardizer.xml:275 723#, no-c-format 724msgid "(20). Words used to denote milepost addresses." 725msgstr "" 726 727#. Tag: term 728#: extras_address_standardizer.xml:280 729#, no-c-format 730msgid "ROAD" 731msgstr "" 732 733#. Tag: para 734#: extras_address_standardizer.xml:282 735#, no-c-format 736msgid "" 737"(6). Words and abbreviations used to denote highways and roads. For example: " 738"the <emphasis>Interstate</emphasis> in <emphasis>Interstate 5</emphasis>" 739msgstr "" 740 741#. Tag: term 742#: extras_address_standardizer.xml:287 extras_address_standardizer.xml:456 743#, no-c-format 744msgid "<term>RR</term>" 745msgstr "" 746 747#. Tag: para 748#: extras_address_standardizer.xml:289 749#, no-c-format 750msgid "" 751"(8). Words and abbreviations used to denote rural routes. <emphasis>RR</" 752"emphasis>." 753msgstr "" 754 755#. Tag: term 756#: extras_address_standardizer.xml:294 757#, no-c-format 758msgid "TYPE" 759msgstr "" 760 761#. Tag: para 762#: extras_address_standardizer.xml:296 763#, no-c-format 764msgid "" 765"(2). Words and abbreviation used to denote street typess. For example: " 766"<emphasis>ST</emphasis> or <emphasis>AVE</emphasis>." 767msgstr "" 768 769#. Tag: term 770#: extras_address_standardizer.xml:301 extras_address_standardizer.xml:461 771#, no-c-format 772msgid "UNITH" 773msgstr "" 774 775#. Tag: para 776#: extras_address_standardizer.xml:303 777#, no-c-format 778msgid "" 779"(16). Words and abbreviation used to denote internal subaddresses. For " 780"example, <emphasis>APT</emphasis> or <emphasis>UNIT</emphasis>." 781msgstr "" 782 783#. Tag: emphasis 784#: extras_address_standardizer.xml:308 785#, no-c-format 786msgid "Postal Type Input Tokens" 787msgstr "" 788 789#. Tag: term 790#: extras_address_standardizer.xml:311 791#, no-c-format 792msgid "QUINT" 793msgstr "" 794 795#. Tag: para 796#: extras_address_standardizer.xml:313 797#, no-c-format 798msgid "(28). A 5 digit number. Identifies a Zip Code" 799msgstr "" 800 801#. Tag: term 802#: extras_address_standardizer.xml:318 803#, no-c-format 804msgid "QUAD" 805msgstr "" 806 807#. Tag: para 808#: extras_address_standardizer.xml:320 809#, no-c-format 810msgid "(29). A 4 digit number. Identifies ZIP4." 811msgstr "" 812 813#. Tag: term 814#: extras_address_standardizer.xml:325 815#, no-c-format 816msgid "<term>PCH</term>" 817msgstr "" 818 819#. Tag: para 820#: extras_address_standardizer.xml:327 821#, no-c-format 822msgid "" 823"(27). A 3 character sequence of letter number letter. Identifies an FSA, the " 824"first 3 characters of a Canadian postal code." 825msgstr "" 826 827#. Tag: term 828#: extras_address_standardizer.xml:332 829#, no-c-format 830msgid "<term>PCT</term>" 831msgstr "" 832 833#. Tag: para 834#: extras_address_standardizer.xml:334 835#, no-c-format 836msgid "" 837"(26). A 3 character sequence of number letter number. Identifies an LDU, the " 838"last 3 characters of a Canadian postal code." 839msgstr "" 840 841#. Tag: emphasis 842#: extras_address_standardizer.xml:339 843#, no-c-format 844msgid "Stopwords" 845msgstr "" 846 847#. Tag: para 848#: extras_address_standardizer.xml:340 849#, no-c-format 850msgid "" 851"STOPWORDS combine with WORDS. In rules a string of multiple WORDs and " 852"STOPWORDs will be represented by a single WORD token." 853msgstr "" 854 855#. Tag: term 856#: extras_address_standardizer.xml:343 857#, no-c-format 858msgid "STOPWORD" 859msgstr "" 860 861#. Tag: para 862#: extras_address_standardizer.xml:345 863#, no-c-format 864msgid "" 865"(7). A word with low lexical significance, that can be omitted in parsing. " 866"For example: <emphasis>THE</emphasis>." 867msgstr "" 868 869#. Tag: title 870#: extras_address_standardizer.xml:354 871#, no-c-format 872msgid "Output Tokens" 873msgstr "" 874 875#. Tag: para 876#: extras_address_standardizer.xml:355 877#, no-c-format 878msgid "" 879"After the first -1 (terminator), follows the output tokens and their order, " 880"followed by a terminator <code>-1</code>. Numbers for corresponding output " 881"tokens are listed in <xref linkend=\"stdaddr\"/>. What are allowed is " 882"dependent on kind of rule. Output tokens valid for each rule type are listed " 883"in <xref linkend=\"rule_types_rank\"/>." 884msgstr "" 885 886#. Tag: title 887#: extras_address_standardizer.xml:358 888#, no-c-format 889msgid "Rule Types and Rank" 890msgstr "" 891 892#. Tag: para 893#: extras_address_standardizer.xml:359 894#, no-c-format 895msgid "" 896"The final part of the rule is the rule type which is denoted by one of the " 897"following, followed by a rule rank. The rules are ranked from 0 (lowest) to " 898"17 (highest)." 899msgstr "" 900 901#. Tag: emphasis 902#: extras_address_standardizer.xml:361 903#, no-c-format 904msgid "MACRO_C" 905msgstr "" 906 907#. Tag: para 908#: extras_address_standardizer.xml:362 909#, no-c-format 910msgid "" 911"(token number = \"<emphasis role=\"bold\">0</emphasis>\"). The class of " 912"rules for parsing MACRO clauses such as <emphasis>PLACE STATE ZIP</emphasis>" 913msgstr "" 914 915#. Tag: para 916#: extras_address_standardizer.xml:363 917#, no-c-format 918msgid "" 919"<emphasis role=\"bold\">MACRO_C output tokens</emphasis> (excerpted from " 920"<ulink url=\"http://www.pagcgeo.org/docs/html/pagc-12.html#--r-typ--" 921"\">http://www.pagcgeo.org/docs/html/pagc-12.html#--r-typ--</ulink>." 922msgstr "" 923 924#. Tag: term 925#: extras_address_standardizer.xml:366 926#, no-c-format 927msgid "CITY" 928msgstr "" 929 930#. Tag: para 931#: extras_address_standardizer.xml:368 932#, no-c-format 933msgid "(token number \"10\"). Example \"Albany\"" 934msgstr "" 935 936#. Tag: term 937#: extras_address_standardizer.xml:372 938#, no-c-format 939msgid "STATE" 940msgstr "" 941 942#. Tag: para 943#: extras_address_standardizer.xml:374 944#, no-c-format 945msgid "(token number \"11\"). Example \"NY\"" 946msgstr "" 947 948#. Tag: term 949#: extras_address_standardizer.xml:378 950#, no-c-format 951msgid "NATION" 952msgstr "" 953 954#. Tag: para 955#: extras_address_standardizer.xml:380 956#, no-c-format 957msgid "" 958"(token number \"12\"). This attribute is not used in most reference files. " 959"Example \"USA\"" 960msgstr "" 961 962#. Tag: term 963#: extras_address_standardizer.xml:384 964#, no-c-format 965msgid "POSTAL" 966msgstr "" 967 968#. Tag: para 969#: extras_address_standardizer.xml:386 970#, no-c-format 971msgid "" 972"(token number \"13\"). (SADS elements \"ZIP CODE\" , \"PLUS 4\" ). This " 973"attribute is used for both the US Zip and the Canadian Postal Codes." 974msgstr "" 975 976#. Tag: emphasis 977#: extras_address_standardizer.xml:391 978#, no-c-format 979msgid "MICRO_C" 980msgstr "" 981 982#. Tag: para 983#: extras_address_standardizer.xml:392 984#, no-c-format 985msgid "" 986"(token number = \"<emphasis role=\"bold\">1</emphasis>\"). The class of " 987"rules for parsing full MICRO clauses (such as House, street, sufdir, predir, " 988"pretyp, suftype, qualif) (ie ARC_C plus CIVIC_C). These rules are not used " 989"in the build phase." 990msgstr "" 991 992#. Tag: para 993#: extras_address_standardizer.xml:393 994#, no-c-format 995msgid "" 996"<emphasis role=\"bold\">MICRO_C output tokens</emphasis> (excerpted from " 997"<ulink url=\"http://www.pagcgeo.org/docs/html/pagc-12.html#--r-typ--" 998"\">http://www.pagcgeo.org/docs/html/pagc-12.html#--r-typ--</ulink>." 999msgstr "" 1000 1001#. Tag: term 1002#: extras_address_standardizer.xml:395 1003#, no-c-format 1004msgid "HOUSE" 1005msgstr "" 1006 1007#. Tag: term 1008#: extras_address_standardizer.xml:413 1009#, no-c-format 1010msgid "street" 1011msgstr "" 1012 1013#. Tag: emphasis 1014#: extras_address_standardizer.xml:430 1015#, no-c-format 1016msgid "ARC_C" 1017msgstr "" 1018 1019#. Tag: para 1020#: extras_address_standardizer.xml:431 1021#, no-c-format 1022msgid "" 1023"(token number = \"<emphasis role=\"bold\">2</emphasis>\"). The class of " 1024"rules for parsing MICRO clauses, excluding the HOUSE attribute. As such uses " 1025"same set of output tokens as MICRO_C minus the HOUSE token." 1026msgstr "" 1027 1028#. Tag: emphasis 1029#: extras_address_standardizer.xml:433 1030#, no-c-format 1031msgid "CIVIC_C" 1032msgstr "" 1033 1034#. Tag: para 1035#: extras_address_standardizer.xml:434 1036#, no-c-format 1037msgid "" 1038"(token number = \"<emphasis role=\"bold\">3</emphasis>\"). The class of " 1039"rules for parsing the HOUSE attribute." 1040msgstr "" 1041 1042#. Tag: emphasis 1043#: extras_address_standardizer.xml:436 1044#, no-c-format 1045msgid "EXTRA_C" 1046msgstr "" 1047 1048#. Tag: para 1049#: extras_address_standardizer.xml:437 1050#, no-c-format 1051msgid "" 1052"(token number = \"<emphasis role=\"bold\">4</emphasis>\"). The class of " 1053"rules for parsing EXTRA attributes - attributes excluded from geocoding. " 1054"These rules are not used in the build phase." 1055msgstr "" 1056 1057#. Tag: para 1058#: extras_address_standardizer.xml:439 1059#, no-c-format 1060msgid "" 1061"<emphasis role=\"bold\">EXTRA_C output tokens</emphasis> (excerpted from " 1062"<ulink url=\"http://www.pagcgeo.org/docs/html/pagc-12.html#--r-typ--" 1063"\">http://www.pagcgeo.org/docs/html/pagc-12.html#--r-typ--</ulink>." 1064msgstr "" 1065 1066#. Tag: term 1067#: extras_address_standardizer.xml:441 1068#, no-c-format 1069msgid "BLDNG" 1070msgstr "" 1071 1072#. Tag: para 1073#: extras_address_standardizer.xml:443 1074#, no-c-format 1075msgid "(token number <code>0</code>): Unparsed building identifiers and types." 1076msgstr "" 1077 1078#. Tag: para 1079#: extras_address_standardizer.xml:448 1080#, no-c-format 1081msgid "" 1082"(token number <code>14</code>): The <emphasis role=\"bold\">BOX</emphasis> " 1083"in <code>BOX 3B</code>" 1084msgstr "" 1085 1086#. Tag: term 1087#: extras_address_standardizer.xml:451 1088#, no-c-format 1089msgid "BOXT" 1090msgstr "" 1091 1092#. Tag: para 1093#: extras_address_standardizer.xml:453 1094#, no-c-format 1095msgid "" 1096"(token number <code>15</code>): The <emphasis role=\"bold\">3B</emphasis> in " 1097"<code>BOX 3B</code>" 1098msgstr "" 1099 1100#. Tag: para 1101#: extras_address_standardizer.xml:458 1102#, no-c-format 1103msgid "" 1104"(token number <code>8</code>): The <emphasis role=\"bold\">RR</emphasis> in " 1105"<code>RR 7</code>" 1106msgstr "" 1107 1108#. Tag: para 1109#: extras_address_standardizer.xml:463 1110#, no-c-format 1111msgid "" 1112"(token number <code>16</code>): The <emphasis role=\"bold\">APT</emphasis> " 1113"in <code>APT 3B</code>" 1114msgstr "" 1115 1116#. Tag: term 1117#: extras_address_standardizer.xml:466 1118#, no-c-format 1119msgid "UNITT" 1120msgstr "" 1121 1122#. Tag: para 1123#: extras_address_standardizer.xml:468 1124#, no-c-format 1125msgid "" 1126"(token number <code>17</code>): The <emphasis role=\"bold\">3B</emphasis> in " 1127"<code>APT 3B</code>" 1128msgstr "" 1129 1130#. Tag: term 1131#: extras_address_standardizer.xml:471 1132#, no-c-format 1133msgid "UNKNWN" 1134msgstr "" 1135 1136#. Tag: para 1137#: extras_address_standardizer.xml:473 1138#, no-c-format 1139msgid "(token number <code>9</code>): An otherwise unclassified output." 1140msgstr "" 1141 1142#. Tag: refname 1143#: extras_address_standardizer.xml:482 1144#, no-c-format 1145msgid "lex table" 1146msgstr "" 1147 1148#. Tag: refpurpose 1149#: extras_address_standardizer.xml:483 1150#, no-c-format 1151msgid "" 1152"A lex table is used to classify alphanumeric input and associate that input " 1153"with (a) input tokens ( See <xref linkend=\"rule_input_tokens\"/>) and (b) " 1154"standardized representations." 1155msgstr "" 1156 1157#. Tag: para 1158#: extras_address_standardizer.xml:487 1159#, no-c-format 1160msgid "" 1161"A lex (short for lexicon) table is used to classify alphanumeric input and " 1162"associate that input with <xref linkend=\"rule_input_tokens\"/> and (b) " 1163"standardized representations. Things you will find in these tables are " 1164"<code>ONE</code> mapped to stdword: <code>1</code>." 1165msgstr "" 1166 1167#. Tag: para 1168#: extras_address_standardizer.xml:489 1169#, no-c-format 1170msgid "A lex has at least the following columns in the table. You may add" 1171msgstr "" 1172 1173#. Tag: term 1174#: extras_address_standardizer.xml:497 extras_address_standardizer.xml:539 1175#, no-c-format 1176msgid "<term>seq</term>" 1177msgstr "" 1178 1179#. Tag: para 1180#: extras_address_standardizer.xml:499 1181#, no-c-format 1182msgid "integer: definition number?" 1183msgstr "" 1184 1185#. Tag: term 1186#: extras_address_standardizer.xml:503 extras_address_standardizer.xml:544 1187#, no-c-format 1188msgid "word" 1189msgstr "" 1190 1191#. Tag: para 1192#: extras_address_standardizer.xml:505 extras_address_standardizer.xml:546 1193#, no-c-format 1194msgid "text: the input word" 1195msgstr "" 1196 1197#. Tag: term 1198#: extras_address_standardizer.xml:508 extras_address_standardizer.xml:549 1199#, no-c-format 1200msgid "stdword" 1201msgstr "" 1202 1203#. Tag: para 1204#: extras_address_standardizer.xml:510 extras_address_standardizer.xml:551 1205#, no-c-format 1206msgid "text: the standardized replacement word" 1207msgstr "" 1208 1209#. Tag: term 1210#: extras_address_standardizer.xml:513 extras_address_standardizer.xml:554 1211#, no-c-format 1212msgid "token" 1213msgstr "" 1214 1215#. Tag: para 1216#: extras_address_standardizer.xml:515 extras_address_standardizer.xml:556 1217#, no-c-format 1218msgid "" 1219"integer: the kind of word it is. Only if it is used in this context will it " 1220"be replaced. Refer to <ulink url=\"http://www.pagcgeo.org/docs/html/pagc-12." 1221"html#--i-tok--\">PAGC Tokens</ulink>." 1222msgstr "" 1223 1224#. Tag: refname 1225#: extras_address_standardizer.xml:524 1226#, no-c-format 1227msgid "gaz table" 1228msgstr "" 1229 1230#. Tag: refpurpose 1231#: extras_address_standardizer.xml:525 1232#, no-c-format 1233msgid "" 1234"A gaz table is used to standardize place names and associate that input with " 1235"(a) input tokens ( See <xref linkend=\"rule_input_tokens\"/>) and (b) " 1236"standardized representations." 1237msgstr "" 1238 1239#. Tag: para 1240#: extras_address_standardizer.xml:529 1241#, no-c-format 1242msgid "" 1243"A gaz (short for gazeteer) table is used to standardize place names and " 1244"associate that input with <xref linkend=\"rule_input_tokens\"/> and (b) " 1245"standardized representations. For example if you are in US, you may load " 1246"these with State Names and associated abbreviations." 1247msgstr "" 1248 1249#. Tag: para 1250#: extras_address_standardizer.xml:531 1251#, no-c-format 1252msgid "" 1253"A gaz table has at least the following columns in the table. You may add " 1254"more columns if you wish for your own purposes." 1255msgstr "" 1256 1257#. Tag: para 1258#: extras_address_standardizer.xml:541 1259#, no-c-format 1260msgid "" 1261"integer: definition number? - identifer used for that instance of the word" 1262msgstr "" 1263 1264#. Tag: title 1265#: extras_address_standardizer.xml:567 1266#, no-c-format 1267msgid "Address Standardizer Functions" 1268msgstr "" 1269 1270#. Tag: refname 1271#: extras_address_standardizer.xml:570 1272#, no-c-format 1273msgid "parse_address" 1274msgstr "" 1275 1276#. Tag: refpurpose 1277#: extras_address_standardizer.xml:572 1278#, no-c-format 1279msgid "Takes a 1 line address and breaks into parts" 1280msgstr "" 1281 1282#. Tag: funcprototype 1283#: extras_address_standardizer.xml:577 1284#, no-c-format 1285msgid "" 1286"<funcdef>record <function>parse_address</function></funcdef> " 1287"<paramdef><type>text </type> <parameter>address</parameter></paramdef>" 1288msgstr "" 1289 1290#. Tag: para 1291#: extras_address_standardizer.xml:588 1292#, no-c-format 1293msgid "" 1294"Returns takes an address as input, and returns a record output consisting of " 1295"fields <emphasis>num</emphasis>, <emphasis>street</emphasis>, " 1296"<emphasis>street2</emphasis>, <emphasis>address1</emphasis>, <emphasis>city</" 1297"emphasis>, <emphasis>state</emphasis>, <emphasis>zip</emphasis>, " 1298"<emphasis>zipplus</emphasis>, <emphasis>country</emphasis>." 1299msgstr "" 1300 1301#. Tag: para 1302#: extras_address_standardizer.xml:592 extras_address_standardizer.xml:654 1303#, no-c-format 1304msgid "Availability: 2.2.0" 1305msgstr "" 1306 1307#. Tag: title 1308#: extras_address_standardizer.xml:598 extras_address_standardizer.xml:660 1309#, no-c-format 1310msgid "Examples" 1311msgstr "Przykłady" 1312 1313#. Tag: para 1314#: extras_address_standardizer.xml:600 1315#, no-c-format 1316msgid "Single Addresss" 1317msgstr "" 1318 1319#. Tag: programlisting 1320#: extras_address_standardizer.xml:601 1321#, no-c-format 1322msgid "" 1323"SELECT num, street, city, zip, zipplus\n" 1324" FROM parse_address('1 Devonshire Place, Boston, MA 02109-1234') AS a;" 1325msgstr "" 1326 1327#. Tag: screen 1328#: extras_address_standardizer.xml:602 1329#, no-c-format 1330msgid "" 1331"num | street | city | zip | zipplus\n" 1332"-----+------------------+--------+-------+---------\n" 1333" 1 | Devonshire Place | Boston | 02109 | 1234" 1334msgstr "" 1335 1336#. Tag: para 1337#: extras_address_standardizer.xml:604 1338#, no-c-format 1339msgid "Table of addresses" 1340msgstr "" 1341 1342#. Tag: programlisting 1343#: extras_address_standardizer.xml:605 1344#, no-c-format 1345msgid "" 1346"-- basic table\n" 1347"CREATE TABLE places(addid serial PRIMARY KEY, address text);\n" 1348"\n" 1349"INSERT INTO places(address)\n" 1350"VALUES ('529 Main Street, Boston MA, 02129'),\n" 1351" ('77 Massachusetts Avenue, Cambridge, MA 02139'),\n" 1352" ('25 Wizard of Oz, Walaford, KS 99912323'),\n" 1353" ('26 Capen Street, Medford, MA'),\n" 1354" ('124 Mount Auburn St, Cambridge, Massachusetts 02138'),\n" 1355" ('950 Main Street, Worcester, MA 01610');\n" 1356"\n" 1357" -- parse the addresses\n" 1358" -- if you want all fields you can use (a).*\n" 1359"SELECT addid, (a).num, (a).street, (a).city, (a).state, (a).zip, (a)." 1360"zipplus\n" 1361"FROM (SELECT addid, parse_address(address) As a\n" 1362" FROM places) AS p;" 1363msgstr "" 1364 1365#. Tag: screen 1366#: extras_address_standardizer.xml:606 1367#, no-c-format 1368msgid "" 1369"addid | num | street | city | state | zip | zipplus\n" 1370"-------+-----+----------------------+-----------+-------+-------+---------\n" 1371" 1 | 529 | Main Street | Boston | MA | 02129 |\n" 1372" 2 | 77 | Massachusetts Avenue | Cambridge | MA | 02139 |\n" 1373" 3 | 25 | Wizard of Oz | Walaford | KS | 99912 | 323\n" 1374" 4 | 26 | Capen Street | Medford | MA | |\n" 1375" 5 | 124 | Mount Auburn St | Cambridge | MA | 02138 |\n" 1376" 6 | 950 | Main Street | Worcester | MA | 01610 |\n" 1377"(6 rows)" 1378msgstr "" 1379 1380#. Tag: title 1381#: extras_address_standardizer.xml:611 extras_address_standardizer.xml:682 1382#, no-c-format 1383msgid "See Also" 1384msgstr "Zobacz także" 1385 1386#. Tag: refname 1387#: extras_address_standardizer.xml:619 1388#, no-c-format 1389msgid "standardize_address" 1390msgstr "" 1391 1392#. Tag: refpurpose 1393#: extras_address_standardizer.xml:621 1394#, no-c-format 1395msgid "" 1396"Returns an stdaddr form of an input address utilizing lex, gaz, and rule " 1397"tables." 1398msgstr "" 1399 1400#. Tag: funcsynopsis 1401#: extras_address_standardizer.xml:625 1402#, no-c-format 1403msgid "" 1404"<funcprototype> <funcdef>stdaddr <function>standardize_address</function></" 1405"funcdef> <paramdef><type>text </type> <parameter>lextab</parameter></" 1406"paramdef> <paramdef><type>text </type> <parameter>gaztab</parameter></" 1407"paramdef> <paramdef><type>text </type> <parameter>rultab</parameter></" 1408"paramdef> <paramdef><type>text </type> <parameter>address</parameter></" 1409"paramdef> </funcprototype> <funcprototype> <funcdef>stdaddr " 1410"<function>standardize_address</function></funcdef> <paramdef><type>text </" 1411"type> <parameter>lextab</parameter></paramdef> <paramdef><type>text </type> " 1412"<parameter>gaztab</parameter></paramdef> <paramdef><type>text </type> " 1413"<parameter>rultab</parameter></paramdef> <paramdef><type>text </type> " 1414"<parameter>micro</parameter></paramdef> <paramdef><type>text </type> " 1415"<parameter>macro</parameter></paramdef> </funcprototype>" 1416msgstr "" 1417 1418#. Tag: para 1419#: extras_address_standardizer.xml:648 1420#, no-c-format 1421msgid "" 1422"Returns an <xref linkend=\"stdaddr\"/> form of an input address utilizing " 1423"<xref linkend=\"lextab\"/> table name, <xref linkend=\"gaztab\"/>, and <xref " 1424"linkend=\"rulestab\"/> table names and an address." 1425msgstr "" 1426 1427#. Tag: para 1428#: extras_address_standardizer.xml:650 1429#, no-c-format 1430msgid "Variant 1: Takes an address as a single line." 1431msgstr "" 1432 1433#. Tag: para 1434#: extras_address_standardizer.xml:651 1435#, no-c-format 1436msgid "" 1437"Variant 2: Takes an address as 2 parts. A <varname>micro</varname> " 1438"consisting of standard first line of postal address e.g. <code>house_num " 1439"street</code>, and a macro consisting of standard postal second line of an " 1440"address e.g <code>city, state postal_code country</code>." 1441msgstr "" 1442 1443#. Tag: para 1444#: extras_address_standardizer.xml:661 1445#, no-c-format 1446msgid "Using address_standardizer_data_us extension" 1447msgstr "" 1448 1449#. Tag: programlisting 1450#: extras_address_standardizer.xml:662 1451#, no-c-format 1452msgid "" 1453"CREATE EXTENSION address_standardizer_data_us; -- only needs to be done once" 1454msgstr "" 1455 1456#. Tag: para 1457#: extras_address_standardizer.xml:664 1458#, no-c-format 1459msgid "" 1460"Variant 1: Single line address. This doesn't work well with non-US addresses" 1461msgstr "" 1462 1463#. Tag: programlisting 1464#: extras_address_standardizer.xml:665 1465#, no-c-format 1466msgid "" 1467"SELECT house_num, name, suftype, city, country, state, unit FROM " 1468"standardize_address('us_lex',\n" 1469" 'us_gaz', 'us_rules', 'One Devonshire Place, PH " 1470"301, Boston, MA 02109');" 1471msgstr "" 1472 1473#. Tag: screen 1474#: extras_address_standardizer.xml:666 1475#, no-c-format 1476msgid "" 1477"house_num | name | suftype | city | country | state | " 1478"unit\n" 1479"----------+------------+---------+--------+---------+---------------" 1480"+-----------------\n" 1481"1 | DEVONSHIRE | PLACE | BOSTON | USA | MASSACHUSETTS | # " 1482"PENTHOUSE 301" 1483msgstr "" 1484 1485#. Tag: para 1486#: extras_address_standardizer.xml:667 1487#, no-c-format 1488msgid "" 1489"Using tables packaged with tiger geocoder. This example only works if you " 1490"installed <varname>postgis_tiger_geocoder</varname>." 1491msgstr "" 1492 1493#. Tag: programlisting 1494#: extras_address_standardizer.xml:668 1495#, no-c-format 1496msgid "" 1497"SELECT * FROM standardize_address('tiger.pagc_lex',\n" 1498" 'tiger.pagc_gaz', 'tiger.pagc_rules', 'One Devonshire Place, PH " 1499"301, Boston, MA 02109-1234');" 1500msgstr "" 1501 1502#. Tag: para 1503#: extras_address_standardizer.xml:670 1504#, no-c-format 1505msgid "" 1506"Make easier to read we'll dump output using hstore extension CREATE " 1507"EXTENSION hstore; you need to install" 1508msgstr "" 1509 1510#. Tag: programlisting 1511#: extras_address_standardizer.xml:671 1512#, no-c-format 1513msgid "" 1514"SELECT (each(hstore(p))).*\n" 1515" FROM standardize_address('tiger.pagc_lex', 'tiger.pagc_gaz',\n" 1516" 'tiger.pagc_rules', 'One Devonshire Place, PH 301, Boston, MA 02109') As " 1517"p;" 1518msgstr "" 1519 1520#. Tag: screen 1521#: extras_address_standardizer.xml:672 extras_address_standardizer.xml:676 1522#, no-c-format 1523msgid "" 1524"key | value\n" 1525"------------+-----------------\n" 1526" box |\n" 1527" city | BOSTON\n" 1528" name | DEVONSHIRE\n" 1529" qual |\n" 1530" unit | # PENTHOUSE 301\n" 1531" extra |\n" 1532" state | MA\n" 1533" predir |\n" 1534" sufdir |\n" 1535" country | USA\n" 1536" pretype |\n" 1537" suftype | PL\n" 1538" building |\n" 1539" postcode | 02109\n" 1540" house_num | 1\n" 1541" ruralroute |\n" 1542"(16 rows)" 1543msgstr "" 1544 1545#. Tag: para 1546#: extras_address_standardizer.xml:674 1547#, no-c-format 1548msgid "Variant 2: As a two part Address" 1549msgstr "" 1550 1551#. Tag: programlisting 1552#: extras_address_standardizer.xml:675 1553#, no-c-format 1554msgid "" 1555"SELECT (each(hstore(p))).*\n" 1556" FROM standardize_address('tiger.pagc_lex', 'tiger.pagc_gaz',\n" 1557" 'tiger.pagc_rules', 'One Devonshire Place, PH 301', 'Boston, MA 02109, " 1558"US') As p;" 1559msgstr "" 1560 1561#. Tag: para 1562#: extras_address_standardizer.xml:684 1563#, no-c-format 1564msgid "" 1565", <xref linkend=\"rulestab\"/>, <xref linkend=\"lextab\"/>, <xref linkend=" 1566"\"gaztab\"/>, <xref linkend=\"Pagc_Normalize_Address\"/>" 1567msgstr "" 1568