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