1# SOME DESCRIPTIVE TITLE. 2# 3# Translators: 4# TERAMOTO Ikuhiro <yellow@affrc.go.jp>, 2017 5msgid "" 6msgstr "" 7"Project-Id-Version: PostGIS\n" 8"Report-Msgid-Bugs-To: http://bugs.kde.org\n" 9"POT-Creation-Date: 2019-10-06 23:48+0000\n" 10"PO-Revision-Date: 2017-01-27 09:48+0000\n" 11"Last-Translator: TERAMOTO Ikuhiro <yellow@affrc.go.jp>\n" 12"Language-Team: Japanese (http://www.transifex.com/postgis/postgis/language/" 13"ja/)\n" 14"Language: ja\n" 15"MIME-Version: 1.0\n" 16"Content-Type: text/plain; charset=UTF-8\n" 17"Content-Transfer-Encoding: 8bit\n" 18"Plural-Forms: nplurals=1; plural=0;\n" 19 20#. Tag: para 21#: extras_tigergeocoder.xml:6 22#, no-c-format 23msgid "" 24"A plpgsql based geocoder written to work with the <ulink url=\"http://www." 25"census.gov/geo/www/tiger/\">TIGER (Topologically Integrated Geographic " 26"Encoding and Referencing system ) / Line and Master Address database export</" 27"ulink> released by the US Census Bureau." 28msgstr "" 29"米国国勢調査局が公開している<ulink url=\"http://www.census.gov/geo/www/tiger/" 30"\">TIGER (Topologically Integrated Geographic Encoding and Referencing " 31"system ) / Line and Master Address database export</ulink>で動作するよう書か" 32"れた、PL/pgSQLベースのジオコーダです。" 33 34#. Tag: para 35#: extras_tigergeocoder.xml:7 36#, no-c-format 37msgid "" 38"There are four components to the geocoder: the data loader functions, the " 39"address normalizer, the address geocoder, and the reverse geocoder." 40msgstr "" 41"データローダ機能、住所正規化、住所ジオコーダおよび逆ジオコーダ、の四つの要素" 42"があります。" 43 44#. Tag: para 45#: extras_tigergeocoder.xml:8 46#, no-c-format 47msgid "" 48"Although it is designed specifically for the US, a lot of the concepts and " 49"functions are applicable and can be adapted to work with other country " 50"address and road networks." 51msgstr "" 52"米国のための設計ですが、概念および機能の多くは適用可能で、他国の住所と道路" 53"ネットワークで動作するように適合させることができます (訳注: 日本の地名につい" 54"ては未知です)。" 55 56#. Tag: para 57#: extras_tigergeocoder.xml:9 58#, no-c-format 59msgid "" 60"The script builds a schema called <varname>tiger</varname> to house all the " 61"tiger related functions, reusable lookup data such as road type prefixes, " 62"suffixes, states, various control tables for managing data load, and " 63"skeleton base tables from which all the tiger loaded tables inherit from." 64msgstr "" 65"Tiger関連の関数、道路型前置辞・道路型後置辞・州といった再利用可能な参照デー" 66"タ、データロード管理のための様々な制御テーブル、全てのロードされたテーブルが" 67"継承するスケルトンテーブル、を収容するための<varname>tiger</varname>というス" 68"キーマが、スクリプトによって作成されます。" 69 70#. Tag: para 71#: extras_tigergeocoder.xml:10 72#, no-c-format 73msgid "" 74"Another schema called <varname>tiger_data</varname> is also created which " 75"houses all the census data for each state that the loader downloads from " 76"Census site and loads into the database. In the current model, each set of " 77"state tables is prefixed with the state code e.g <varname>ma_addr</varname>, " 78"<varname>ma_edges</varname> etc with constraints to enforce only that state " 79"data. Each of these tables inherits from the tables <varname>addr</varname>, " 80"<varname>faces</varname>, <varname>edges</varname>, etc located in the " 81"<varname>tiger schema</varname>." 82msgstr "" 83"<varname>tiger_data</varname>という、もう一つのスキーマが作られます。ここに、" 84"ローダが米国国勢調査サイトからダウンロードしてデータベースにロードした州ごと" 85"の全ての国勢調査データが収容されます。現在のモデルでは、州ごとのテーブルは、" 86"<varname>ma_addr</varname>や<varname>ma_edges</varname>といったように名前の先" 87"頭に州コードを付けていて、州データのみに強制する制約が付いています。これらの" 88"テーブルは<varname>tiger schema</varname>にある<varname>addr</varname>, " 89"<varname>faces</varname>, <varname>edges</varname>等から継承されています。" 90 91#. Tag: para 92#: extras_tigergeocoder.xml:12 93#, no-c-format 94msgid "" 95"All the geocode functions only reference the base tables, so there is no " 96"requirement that the data schema be called <varname>tiger_data</varname> or " 97"that data can't be further partitioned into other schemas -- e.g a different " 98"schema for each state, as long as all the tables inherit from the tables in " 99"the <varname>tiger</varname> schema." 100msgstr "" 101"全てのジオコード関数は基底テーブルを参照するだけです。そのため、" 102"<varname>tiger_data</varname>データスキーマやそのデータを他のスキーマに分割で" 103"きないという条件はありません。例えば、州ごとに異なるスキーマにしても、" 104"<varname>tiger</varname>内のテーブルから継承されているなら使用可能です。" 105 106#. Tag: para 107#: extras_tigergeocoder.xml:16 108#, no-c-format 109msgid "" 110"For instructions on how to enable the extension in your database and also to " 111"load data using it, refer to <xref linkend=\"install_tiger_geocoder_extension" 112"\"/>." 113msgstr "" 114"お手持ちのデータベース内のエクステンションを有効にし、使用するデータをロード" 115"する方法については、<xref linkend=\"install_tiger_geocoder_extension\"/>を参" 116"照して下さい。" 117 118#. Tag: para 119#: extras_tigergeocoder.xml:19 120#, no-c-format 121msgid "" 122"If you are using tiger geocoder (tiger_2010), you can upgrade the scripts " 123"using the accompanying upgrade_geocoder.bat / .sh scripts in extras/tiger. " 124"One major change between <varname>tiger_2010</varname> and " 125"<varname>tiger_2011+</varname> is that the <varname>county</varname> and " 126"<varname>state</varname> tables are no longer broken out by state. If you " 127"have data from tiger_2010 and want to replace with tiger_2015, refer to " 128"<xref linkend=\"upgrade_tiger_geocoder\"/>" 129msgstr "" 130"Tigerジオコーダ (tiger_2010)を使っている場合には、extras/tiger内にある" 131"upgrade_geocoder.bat / .sh を使ってアップグレードすることができます。" 132"<varname>tiger_2010</varname>と<varname>tiger_2011以上</varname>での大きな変" 133"更点は、<varname>county</varname>テーブルと<varname>state</varname>テーブル" 134"が、stateごとに出現することがなくなっています。tiger_2010からのデータを持って" 135"いて、tiger_2015に置き換えたい場合には、<xref linkend=" 136"\"upgrade_tiger_geocoder\"/>を参照して下さい。" 137 138#. Tag: para 139#: extras_tigergeocoder.xml:26 140#, no-c-format 141msgid "" 142"New in PostGIS 2.2.0 release is support for Tiger 2015 data and inclusion of " 143"Address Standardizer as part of PostGIS." 144msgstr "" 145"PostGIS 2.2.0での新規機能は、Tiger 2015データに対応したことと、住所標準化が" 146"PostGISの一部に取り入れられたことです。" 147 148#. Tag: para 149#: extras_tigergeocoder.xml:27 150#, no-c-format 151msgid "" 152"New in PostGIS 2.1.0 release is ability to install tiger geocoder with " 153"PostgreSQL extension model if you are running PostgreSQL 9.1+. Refer to " 154"<xref linkend=\"install_tiger_geocoder_extension\"/> for details." 155msgstr "" 156"PostGIS 2.1.0での新規機能は、PostgreSQL 9.1以上では、Tigerジオコーダを" 157"PostgreSQLエクステンションモデルでインストールすることができるようになったこ" 158"とです。詳細については<xref linkend=\"install_tiger_geocoder_extension\"/>を" 159"参照して下さい。" 160 161#. Tag: para 162#: extras_tigergeocoder.xml:30 163#, no-c-format 164msgid "" 165"The <xref linkend=\"Pagc_Normalize_Address\"/> function as a drop in " 166"replacement for in-built <xref linkend=\"Normalize_Address\"/>. Refer to " 167"<xref linkend=\"installing_pagc_address_standardizer\"/> for compile and " 168"installation instructions." 169msgstr "" 170"PostGISが用意している<xref linkend=\"Normalize_Address\"/>の代替として<xref " 171"linkend=\"Pagc_Normalize_Address\"/>関数があります。コンパイルとインストール" 172"の方法については、<xref linkend=\"installing_pagc_address_standardizer\"/>を" 173"参照して下さい。" 174 175#. Tag: para 176#: extras_tigergeocoder.xml:34 177#, no-c-format 178msgid "Design:" 179msgstr "設計:" 180 181#. Tag: para 182#: extras_tigergeocoder.xml:35 183#, no-c-format 184msgid "" 185"The goal of this project is to build a fully functional geocoder that can " 186"process an arbitrary United States address string and using normalized TIGER " 187"census data, produce a point geometry and rating reflecting the location of " 188"the given address and likeliness of the location. The higher the rating " 189"number the worse the result." 190msgstr "" 191"このプロジェクトの目標は、任意の米国住所文字列を処理し、正規化したTiger国勢調" 192"査データを使ってポイントジオメトリを生成し、与えられた住所の位置や、位置の" 193"もっともらしさを反映した評価値を算出する、十分に実用的なジオコーダを構築する" 194"ことです。なお、評価値は高いほど悪い結果とします。" 195 196#. Tag: para 197#: extras_tigergeocoder.xml:37 198#, no-c-format 199msgid "" 200"The <varname>reverse_geocode</varname> function, introduced in PostGIS 2.0.0 " 201"is useful for deriving the street address and cross streets of a GPS " 202"location." 203msgstr "" 204"PostGIS 2.0.0で導入された<varname>reverse_geocode</varname>は、GPS位置のスト" 205"リート住所と交差点を得るのに便利です。" 206 207#. Tag: para 208#: extras_tigergeocoder.xml:38 209#, no-c-format 210msgid "" 211"The geocoder should be simple for anyone familiar with PostGIS to install " 212"and use, and should be easily installable and usable on all platforms " 213"supported by PostGIS." 214msgstr "" 215"ジオコーダは、PostGISに慣れている方ならだれでもインストールと使用が容易な程度" 216"に単純であるべきで、PostGISがサポートする全てのプラットフォームで簡便にインス" 217"トール、使用ができるべきです。" 218 219#. Tag: para 220#: extras_tigergeocoder.xml:39 221#, no-c-format 222msgid "" 223"It should be robust enough to function properly despite formatting and " 224"spelling errors." 225msgstr "" 226"書式や綴りの誤りがあっても確実に機能するための十分なロバスト性があるべきで" 227"す。" 228 229#. Tag: para 230#: extras_tigergeocoder.xml:40 231#, no-c-format 232msgid "" 233"It should be extensible enough to be used with future data updates, or " 234"alternate data sources with a minimum of coding changes." 235msgstr "" 236"将来のデータ更新が使えるか、最小のプログラムの変更で他のデータが使えるための" 237"十分な拡張性もあるべきです。" 238 239#. Tag: para 240#: extras_tigergeocoder.xml:42 241#, no-c-format 242msgid "" 243"The <varname>tiger</varname> schema must be added to the database search " 244"path for the functions to work properly." 245msgstr "" 246"関数が確実に動作するために、<varname>tiger</varname>スキーマは、データベース" 247"検索パスに追加されていなければなりません。" 248 249#. Tag: title 250#: extras_tigergeocoder.xml:46 251#, no-c-format 252msgid "Tiger Geocoder" 253msgstr "Tigerジオコーダ" 254 255#. Tag: para 256#: extras_tigergeocoder.xml:48 257#, no-c-format 258msgid "" 259"There are a couple other open source geocoders for PostGIS, that unlike " 260"tiger geocoder have the advantage of multi-country geocoding support" 261msgstr "" 262"PostGIS用の二つのオープンソースジオコーダがあります。これらはTigerジオコーダ" 263"と違い、他国のジオコーディングに対応している利点があります。" 264 265#. Tag: para 266#: extras_tigergeocoder.xml:50 267#, no-c-format 268msgid "" 269"<ulink url=\"http://wiki.openstreetmap.org/wiki/Nominatim\">Nominatim</" 270"ulink> uses OpenStreetMap gazeteer formatted data. It requires osm2pgsql for " 271"loading the data, PostgreSQL 8.4+ and PostGIS 1.5+ to function. It is " 272"packaged as a webservice interface and seems designed to be called as a " 273"webservice. Just like the tiger geocoder, it has both a geocoder and a " 274"reverse geocoder component. From the documentation, it is unclear if it has " 275"a pure SQL interface like the tiger geocoder, or if a good deal of the logic " 276"is implemented in the web interface." 277msgstr "" 278"<ulink url=\"http://wiki.openstreetmap.org/wiki/Nominatim\">Nominatim</ulink>" 279"は、OpenStreetMapの地名集データを使います。データのロードにはosm2pgsqlが必要" 280"です。PostgreSQL 8.4以上とPostGIS 1.5以上が必要です。Webサービスのインタ" 281"フェースとして作られていて、Webサービスと呼ばれるような設計に見えます。Tiger" 282"ジオコーダと同じように、ジオコーダと逆ジオコーダの要素を持ちます。文書からで" 283"は、Tigerジオコーダのような純粋なSQLインタフェースを持っているのか、多くの処" 284"理がWebインタフェースに実装されているのか、は明確ではありません。" 285 286#. Tag: para 287#: extras_tigergeocoder.xml:53 288#, no-c-format 289msgid "" 290"<ulink url=\"http://www.gisgraphy.com/\">GIS Graphy</ulink> also utilizes " 291"PostGIS and like Nominatim works with OpenStreetMap (OSM) data. It comes " 292"with a loader to load OSM data and similar to Nominatim is capable of " 293"geocoding not just US. Much like Nominatim, it runs as a webservice and " 294"relies on Java 1.5, Servlet apps, Solr. GisGraphy is cross-platform and also " 295"has a reverse geocoder among some other neat features." 296msgstr "" 297"<ulink url=\"http://www.gisgraphy.com/\">GIS Graphy</ulink>も、PostGISを使用" 298"したもので、NominatimのようにOpenStreetMap (OSM)データを使用します。OSMデータ" 299"のロードを行うローダとNominatimのように米国だけでなくジオコーディングを行う能" 300"力があります。Nominatimとよく似ていて、Webサービスとして動作し、Java 1.5、" 301"サーブレットアプリケーション、Apache Solrに依存しています。GisGraphyは、複数" 302"プラットフォームで動作し、他の機能の中には逆ジオコーダがあります。" 303 304#. Tag: refname 305#: extras_tigergeocoder.xml:58 306#, no-c-format 307msgid "Drop_Indexes_Generate_Script" 308msgstr "Drop_Indexes_Generate_Script" 309 310#. Tag: refpurpose 311#: extras_tigergeocoder.xml:60 312#, no-c-format 313msgid "" 314"<refpurpose>Generates a script that drops all non-primary key and non-unique " 315"indexes on tiger schema and user specified schema. Defaults schema to " 316"<varname>tiger_data</varname> if no schema is specified.</refpurpose>" 317msgstr "" 318"<refpurpose>tigerスキーマとユーザが指定したスキーマ上の、全ての主キーでなく、" 319"かつユニークでないインデックスを削除します。スキーマを指定しない場合のデフォ" 320"ルトスキーマは、<varname>tiger_data</varname>です。</refpurpose>" 321 322#. Tag: funcprototype 323#: extras_tigergeocoder.xml:65 324#, no-c-format 325msgid "" 326"<funcdef>text <function>Drop_Indexes_Generate_Script</function></funcdef> " 327"<paramdef choice=\"opt\"><type>text </type> " 328"<parameter>param_schema=tiger_data</parameter></paramdef>" 329msgstr "" 330"<funcdef>text <function>Drop_Indexes_Generate_Script</function></funcdef> " 331"<paramdef choice=\"opt\"><type>text </type> " 332"<parameter>param_schema=tiger_data</parameter></paramdef>" 333 334#. Tag: title 335#: extras_tigergeocoder.xml:73 extras_tigergeocoder.xml:115 336#: extras_tigergeocoder.xml:157 extras_tigergeocoder.xml:213 337#: extras_tigergeocoder.xml:275 extras_tigergeocoder.xml:320 338#: extras_tigergeocoder.xml:361 extras_tigergeocoder.xml:406 339#: extras_tigergeocoder.xml:451 extras_tigergeocoder.xml:509 340#: extras_tigergeocoder.xml:570 extras_tigergeocoder.xml:628 341#: extras_tigergeocoder.xml:673 extras_tigergeocoder.xml:759 342#: extras_tigergeocoder.xml:851 extras_tigergeocoder.xml:898 343#: extras_tigergeocoder.xml:971 extras_tigergeocoder.xml:1036 344#, no-c-format 345msgid "Description" 346msgstr "説明" 347 348#. Tag: para 349#: extras_tigergeocoder.xml:75 350#, no-c-format 351msgid "" 352"<para>Generates a script that drops all non-primary key and non-unique " 353"indexes on tiger schema and user specified schema. Defaults schema to " 354"<varname>tiger_data</varname> if no schema is specified.</para>" 355msgstr "" 356"<para>tigerスキーマとユーザが指定したスキーマ上の、全ての主キーでなく、かつユ" 357"ニークでないインデックスを削除します。スキーマを指定しない場合のデフォルトス" 358"キーマは、<varname>tiger_data</varname>です。</para>" 359 360#. Tag: para 361#: extras_tigergeocoder.xml:76 362#, no-c-format 363msgid "" 364"This is useful for minimizing index bloat that may confuse the query planner " 365"or take up unnecessary space. Use in combination with <xref linkend=" 366"\"Install_Missing_Indexes\"/> to add just the indexes used by the geocoder." 367msgstr "" 368"PostgreSQLのクエリプランナを混乱させる可能性があり、不要なディスク容量を取" 369"る、インデックスの膨張を最小化するために使います。ジオコーダで使われるイン" 370"デックスを追加する関数<xref linkend=\"Install_Missing_Indexes\"/>を併用しま" 371"す。" 372 373#. Tag: para 374#: extras_tigergeocoder.xml:79 extras_tigergeocoder.xml:163 375#: extras_tigergeocoder.xml:282 extras_tigergeocoder.xml:371 376#: extras_tigergeocoder.xml:414 extras_tigergeocoder.xml:469 377#: extras_tigergeocoder.xml:636 extras_tigergeocoder.xml:925 378#: extras_tigergeocoder.xml:997 379#, no-c-format 380msgid "Availability: 2.0.0" 381msgstr "Availability: 2.0.0" 382 383#. Tag: title 384#: extras_tigergeocoder.xml:86 extras_tigergeocoder.xml:127 385#: extras_tigergeocoder.xml:170 extras_tigergeocoder.xml:421 386#: extras_tigergeocoder.xml:476 extras_tigergeocoder.xml:536 387#: extras_tigergeocoder.xml:596 extras_tigergeocoder.xml:643 388#: extras_tigergeocoder.xml:726 extras_tigergeocoder.xml:817 389#: extras_tigergeocoder.xml:861 extras_tigergeocoder.xml:930 390#, no-c-format 391msgid "Examples" 392msgstr "例" 393 394#. Tag: programlisting 395#: extras_tigergeocoder.xml:87 396#, no-c-format 397msgid "" 398"SELECT drop_indexes_generate_script() As actionsql;\n" 399"actionsql\n" 400"---------------------------------------------------------\n" 401"DROP INDEX tiger.idx_tiger_countysub_lookup_lower_name;\n" 402"DROP INDEX tiger.idx_tiger_edges_countyfp;\n" 403"DROP INDEX tiger.idx_tiger_faces_countyfp;\n" 404"DROP INDEX tiger.tiger_place_the_geom_gist;\n" 405"DROP INDEX tiger.tiger_edges_the_geom_gist;\n" 406"DROP INDEX tiger.tiger_state_the_geom_gist;\n" 407"DROP INDEX tiger.idx_tiger_addr_least_address;\n" 408"DROP INDEX tiger.idx_tiger_addr_tlid;\n" 409"DROP INDEX tiger.idx_tiger_addr_zip;\n" 410"DROP INDEX tiger.idx_tiger_county_countyfp;\n" 411"DROP INDEX tiger.idx_tiger_county_lookup_lower_name;\n" 412"DROP INDEX tiger.idx_tiger_county_lookup_snd_name;\n" 413"DROP INDEX tiger.idx_tiger_county_lower_name;\n" 414"DROP INDEX tiger.idx_tiger_county_snd_name;\n" 415"DROP INDEX tiger.idx_tiger_county_the_geom_gist;\n" 416"DROP INDEX tiger.idx_tiger_countysub_lookup_snd_name;\n" 417"DROP INDEX tiger.idx_tiger_cousub_countyfp;\n" 418"DROP INDEX tiger.idx_tiger_cousub_cousubfp;\n" 419"DROP INDEX tiger.idx_tiger_cousub_lower_name;\n" 420"DROP INDEX tiger.idx_tiger_cousub_snd_name;\n" 421"DROP INDEX tiger.idx_tiger_cousub_the_geom_gist;\n" 422"DROP INDEX tiger_data.idx_tiger_data_ma_addr_least_address;\n" 423"DROP INDEX tiger_data.idx_tiger_data_ma_addr_tlid;\n" 424"DROP INDEX tiger_data.idx_tiger_data_ma_addr_zip;\n" 425"DROP INDEX tiger_data.idx_tiger_data_ma_county_countyfp;\n" 426"DROP INDEX tiger_data.idx_tiger_data_ma_county_lookup_lower_name;\n" 427"DROP INDEX tiger_data.idx_tiger_data_ma_county_lookup_snd_name;\n" 428"DROP INDEX tiger_data.idx_tiger_data_ma_county_lower_name;\n" 429"DROP INDEX tiger_data.idx_tiger_data_ma_county_snd_name;\n" 430":\n" 431":" 432msgstr "" 433"SELECT drop_indexes_generate_script() As actionsql;\n" 434"actionsql\n" 435"---------------------------------------------------------\n" 436"DROP INDEX tiger.idx_tiger_countysub_lookup_lower_name;\n" 437"DROP INDEX tiger.idx_tiger_edges_countyfp;\n" 438"DROP INDEX tiger.idx_tiger_faces_countyfp;\n" 439"DROP INDEX tiger.tiger_place_the_geom_gist;\n" 440"DROP INDEX tiger.tiger_edges_the_geom_gist;\n" 441"DROP INDEX tiger.tiger_state_the_geom_gist;\n" 442"DROP INDEX tiger.idx_tiger_addr_least_address;\n" 443"DROP INDEX tiger.idx_tiger_addr_tlid;\n" 444"DROP INDEX tiger.idx_tiger_addr_zip;\n" 445"DROP INDEX tiger.idx_tiger_county_countyfp;\n" 446"DROP INDEX tiger.idx_tiger_county_lookup_lower_name;\n" 447"DROP INDEX tiger.idx_tiger_county_lookup_snd_name;\n" 448"DROP INDEX tiger.idx_tiger_county_lower_name;\n" 449"DROP INDEX tiger.idx_tiger_county_snd_name;\n" 450"DROP INDEX tiger.idx_tiger_county_the_geom_gist;\n" 451"DROP INDEX tiger.idx_tiger_countysub_lookup_snd_name;\n" 452"DROP INDEX tiger.idx_tiger_cousub_countyfp;\n" 453"DROP INDEX tiger.idx_tiger_cousub_cousubfp;\n" 454"DROP INDEX tiger.idx_tiger_cousub_lower_name;\n" 455"DROP INDEX tiger.idx_tiger_cousub_snd_name;\n" 456"DROP INDEX tiger.idx_tiger_cousub_the_geom_gist;\n" 457"DROP INDEX tiger_data.idx_tiger_data_ma_addr_least_address;\n" 458"DROP INDEX tiger_data.idx_tiger_data_ma_addr_tlid;\n" 459"DROP INDEX tiger_data.idx_tiger_data_ma_addr_zip;\n" 460"DROP INDEX tiger_data.idx_tiger_data_ma_county_countyfp;\n" 461"DROP INDEX tiger_data.idx_tiger_data_ma_county_lookup_lower_name;\n" 462"DROP INDEX tiger_data.idx_tiger_data_ma_county_lookup_snd_name;\n" 463"DROP INDEX tiger_data.idx_tiger_data_ma_county_lower_name;\n" 464"DROP INDEX tiger_data.idx_tiger_data_ma_county_snd_name;\n" 465":\n" 466":" 467 468#. Tag: title 469#: extras_tigergeocoder.xml:93 extras_tigergeocoder.xml:134 470#: extras_tigergeocoder.xml:177 extras_tigergeocoder.xml:244 471#: extras_tigergeocoder.xml:298 extras_tigergeocoder.xml:338 472#: extras_tigergeocoder.xml:384 extras_tigergeocoder.xml:428 473#: extras_tigergeocoder.xml:486 extras_tigergeocoder.xml:548 474#: extras_tigergeocoder.xml:605 extras_tigergeocoder.xml:650 475#: extras_tigergeocoder.xml:736 extras_tigergeocoder.xml:829 476#: extras_tigergeocoder.xml:872 extras_tigergeocoder.xml:945 477#: extras_tigergeocoder.xml:1013 extras_tigergeocoder.xml:1053 478#, no-c-format 479msgid "See Also" 480msgstr "関連情報" 481 482#. Tag: para 483#: extras_tigergeocoder.xml:94 extras_tigergeocoder.xml:429 484#, no-c-format 485msgid ", <xref linkend=\"Missing_Indexes_Generate_Script\"/>" 486msgstr ", <xref linkend=\"Missing_Indexes_Generate_Script\"/>" 487 488#. Tag: refname 489#: extras_tigergeocoder.xml:100 490#, no-c-format 491msgid "Drop_Nation_Tables_Generate_Script" 492msgstr "Drop_Nation_Tables_Generate_Script" 493 494#. Tag: refpurpose 495#: extras_tigergeocoder.xml:102 496#, no-c-format 497msgid "" 498"Generates a script that drops all tables in the specified schema that start " 499"with <varname>county_all</varname>, <varname>state_all</varname> or state " 500"code followed by <varname>county</varname> or <varname>state</varname>." 501msgstr "" 502"指定したスキーマ内のテーブルのうち、<varname>county_all</varname>, " 503"<varname>state_all</varname>または、<varname>county</varname> or " 504"<varname>state</varname>を削除するスクリプトを生成します。" 505 506#. Tag: funcprototype 507#: extras_tigergeocoder.xml:107 508#, no-c-format 509msgid "" 510"<funcdef>text <function>Drop_Nation_Tables_Generate_Script</function></" 511"funcdef> <paramdef choice=\"opt\"><type>text </type> " 512"<parameter>param_schema=tiger_data</parameter></paramdef>" 513msgstr "" 514"<funcdef>text <function>Drop_Nation_Tables_Generate_Script</function></" 515"funcdef> <paramdef choice=\"opt\"><type>text </type> " 516"<parameter>param_schema=tiger_data</parameter></paramdef>" 517 518#. Tag: para 519#: extras_tigergeocoder.xml:117 520#, no-c-format 521msgid "" 522"Generates a script that drops all tables in the specified schema that start " 523"with <varname>county_all</varname>, <varname>state_all</varname> or stae " 524"code followed by <varname>county</varname> or <varname>state</varname>. This " 525"is needed if you are upgrading from <varname>tiger_2010</varname> to " 526"<varname>tiger_2011</varname> data." 527msgstr "" 528"指定したスキーマ内のテーブルのうち、名前が<varname>county_all</varname>、" 529"<varname>state_all</varname>、<varname>(州コード)_county</varname>、" 530"<varname>(州コード)_state</varname>で始まるテーブルを全て削除するスクリプトを" 531"生成します。 <varname>tiger_2010</varname>データから<varname>tiger_2011</" 532"varname>データに更新する際に必要です。" 533 534#. Tag: para 535#: extras_tigergeocoder.xml:120 extras_tigergeocoder.xml:326 536#: extras_tigergeocoder.xml:588 extras_tigergeocoder.xml:768 537#: extras_tigergeocoder.xml:1040 538#, no-c-format 539msgid "Availability: 2.1.0" 540msgstr "Availability: 2.1.0" 541 542#. Tag: programlisting 543#: extras_tigergeocoder.xml:128 544#, no-c-format 545msgid "" 546"SELECT drop_nation_tables_generate_script();\n" 547"DROP TABLE tiger_data.county_all;\n" 548"DROP TABLE tiger_data.county_all_lookup;\n" 549"DROP TABLE tiger_data.state_all;\n" 550"DROP TABLE tiger_data.ma_county;\n" 551"DROP TABLE tiger_data.ma_state;" 552msgstr "" 553"SELECT drop_nation_tables_generate_script();\n" 554"DROP TABLE tiger_data.county_all;\n" 555"DROP TABLE tiger_data.county_all_lookup;\n" 556"DROP TABLE tiger_data.state_all;\n" 557"DROP TABLE tiger_data.ma_county;\n" 558"DROP TABLE tiger_data.ma_state;" 559 560#. Tag: refname 561#: extras_tigergeocoder.xml:141 562#, no-c-format 563msgid "Drop_State_Tables_Generate_Script" 564msgstr "Drop_State_Tables_Generate_Script" 565 566#. Tag: refpurpose 567#: extras_tigergeocoder.xml:143 568#, no-c-format 569msgid "" 570"Generates a script that drops all tables in the specified schema that are " 571"prefixed with the state abbreviation. Defaults schema to " 572"<varname>tiger_data</varname> if no schema is specified." 573msgstr "" 574"指定したスキーマ内の、名前が州コードから始まるテーブルを全て削除するスクリプ" 575"トを生成します。スキーマが指定されていない場合のデフォルトスキーマは" 576"<varname>tiger_data</varname>です。" 577 578#. Tag: funcprototype 579#: extras_tigergeocoder.xml:148 580#, no-c-format 581msgid "" 582"<funcdef>text <function>Drop_State_Tables_Generate_Script</function></" 583"funcdef> <paramdef><type>text </type> <parameter>param_state</parameter></" 584"paramdef> <paramdef choice=\"opt\"><type>text </type> " 585"<parameter>param_schema=tiger_data</parameter></paramdef>" 586msgstr "" 587"<funcdef>text <function>Drop_State_Tables_Generate_Script</function></" 588"funcdef> <paramdef><type>text </type> <parameter>param_state</parameter></" 589"paramdef> <paramdef choice=\"opt\"><type>text </type> " 590"<parameter>param_schema=tiger_data</parameter></paramdef>" 591 592#. Tag: para 593#: extras_tigergeocoder.xml:159 594#, no-c-format 595msgid "" 596"Generates a script that drops all tables in the specified schema that are " 597"prefixed with the state abbreviation. Defaults schema to " 598"<varname>tiger_data</varname> if no schema is specified. This function is " 599"useful for dropping tables of a state just before you reload a state in case " 600"something went wrong during your previous load." 601msgstr "" 602"指定したスキーマ内の、名前が州コードから始まるテーブルを全て削除するスクリプ" 603"トを生成します。スキーマが指定されていない場合のデフォルトスキーマは" 604"<varname>tiger_data</varname>です。ある州の以前のデータのロードがうまくいかず" 605"に再ロードする際に使います。" 606 607#. Tag: programlisting 608#: extras_tigergeocoder.xml:171 609#, no-c-format 610msgid "" 611"SELECT drop_state_tables_generate_script('PA');\n" 612"DROP TABLE tiger_data.pa_addr;\n" 613"DROP TABLE tiger_data.pa_county;\n" 614"DROP TABLE tiger_data.pa_county_lookup;\n" 615"DROP TABLE tiger_data.pa_cousub;\n" 616"DROP TABLE tiger_data.pa_edges;\n" 617"DROP TABLE tiger_data.pa_faces;\n" 618"DROP TABLE tiger_data.pa_featnames;\n" 619"DROP TABLE tiger_data.pa_place;\n" 620"DROP TABLE tiger_data.pa_state;\n" 621"DROP TABLE tiger_data.pa_zip_lookup_base;\n" 622"DROP TABLE tiger_data.pa_zip_state;\n" 623"DROP TABLE tiger_data.pa_zip_state_loc;" 624msgstr "" 625"SELECT drop_state_tables_generate_script('PA');\n" 626"DROP TABLE tiger_data.pa_addr;\n" 627"DROP TABLE tiger_data.pa_county;\n" 628"DROP TABLE tiger_data.pa_county_lookup;\n" 629"DROP TABLE tiger_data.pa_cousub;\n" 630"DROP TABLE tiger_data.pa_edges;\n" 631"DROP TABLE tiger_data.pa_faces;\n" 632"DROP TABLE tiger_data.pa_featnames;\n" 633"DROP TABLE tiger_data.pa_place;\n" 634"DROP TABLE tiger_data.pa_state;\n" 635"DROP TABLE tiger_data.pa_zip_lookup_base;\n" 636"DROP TABLE tiger_data.pa_zip_state;\n" 637"DROP TABLE tiger_data.pa_zip_state_loc;" 638 639#. Tag: refname 640#: extras_tigergeocoder.xml:183 641#, no-c-format 642msgid "Geocode" 643msgstr "Geocode" 644 645#. Tag: refpurpose 646#: extras_tigergeocoder.xml:185 647#, no-c-format 648msgid "" 649"Takes in an address as a string (or other normalized address) and outputs a " 650"set of possible locations which include a point geometry in NAD 83 long lat, " 651"a normalized address for each, and the rating. The lower the rating the more " 652"likely the match. Results are sorted by lowest rating first. Can optionally " 653"pass in maximum results, defaults to 10, and restrict_region (defaults to " 654"NULL)" 655msgstr "" 656"住所を文字列 (もしくは他の正規化された住所)として取り、可能性のある位置の集合" 657"を返します。返される集合の要素は、NAD 83経度緯度のポイントジオメトリ、正規化" 658"された住所と評価値を持ちます。評価値は低いほど可能性が高いことを示していま" 659"す。結果は評価値の低い順に並べ替えられます。オプションにmax_result (最大結果" 660"数、デフォルトは10)とrestrict_region (制限領域、デフォルトはNULL)を渡すことが" 661"できます。" 662 663#. Tag: funcsynopsis 664#: extras_tigergeocoder.xml:190 665#, no-c-format 666msgid "" 667"<funcprototype> <funcdef>setof record <function>geocode</function></funcdef> " 668"<paramdef><type>varchar </type> <parameter>address</parameter></paramdef> " 669"<paramdef choice=\"opt\"><type>integer </type> <parameter>max_results=10</" 670"parameter></paramdef> <paramdef choice=\"opt\"><type>geometry </type> " 671"<parameter>restrict_region=NULL</parameter></paramdef> " 672"<paramdef><type>norm_addy </type> <parameter>OUT addy</parameter></paramdef> " 673"<paramdef><type>geometry </type> <parameter>OUT geomout</parameter></" 674"paramdef> <paramdef><type>integer </type> <parameter>OUT rating</parameter></" 675"paramdef> </funcprototype> <funcprototype> <funcdef>setof record " 676"<function>geocode</function></funcdef> <paramdef><type>norm_addy </type> " 677"<parameter>in_addy</parameter></paramdef> <paramdef choice=\"opt" 678"\"><type>integer </type> <parameter>max_results=10</parameter></paramdef> " 679"<paramdef choice=\"opt\"><type>geometry </type> " 680"<parameter>restrict_region=NULL</parameter></paramdef> " 681"<paramdef><type>norm_addy </type> <parameter>OUT addy</parameter></paramdef> " 682"<paramdef><type>geometry </type> <parameter>OUT geomout</parameter></" 683"paramdef> <paramdef><type>integer </type> <parameter>OUT rating</parameter></" 684"paramdef> </funcprototype>" 685msgstr "" 686"<funcprototype> <funcdef>setof record <function>geocode</function></funcdef> " 687"<paramdef><type>varchar </type> <parameter>address</parameter></paramdef> " 688"<paramdef choice=\"opt\"><type>integer </type> <parameter>max_results=10</" 689"parameter></paramdef> <paramdef choice=\"opt\"><type>geometry </type> " 690"<parameter>restrict_region=NULL</parameter></paramdef> " 691"<paramdef><type>norm_addy </type> <parameter>OUT addy</parameter></paramdef> " 692"<paramdef><type>geometry </type> <parameter>OUT geomout</parameter></" 693"paramdef> <paramdef><type>integer </type> <parameter>OUT rating</parameter></" 694"paramdef> </funcprototype> <funcprototype> <funcdef>setof record " 695"<function>geocode</function></funcdef> <paramdef><type>norm_addy </type> " 696"<parameter>in_addy</parameter></paramdef> <paramdef choice=\"opt" 697"\"><type>integer </type> <parameter>max_results=10</parameter></paramdef> " 698"<paramdef choice=\"opt\"><type>geometry </type> " 699"<parameter>restrict_region=NULL</parameter></paramdef> " 700"<paramdef><type>norm_addy </type> <parameter>OUT addy</parameter></paramdef> " 701"<paramdef><type>geometry </type> <parameter>OUT geomout</parameter></" 702"paramdef> <paramdef><type>integer </type> <parameter>OUT rating</parameter></" 703"paramdef> </funcprototype>" 704 705#. Tag: para 706#: extras_tigergeocoder.xml:215 707#, no-c-format 708msgid "" 709"Takes in an address as a string (or already normalized address) and outputs " 710"a set of possible locations which include a point geometry in NAD 83 long " 711"lat, a <varname>normalized_address</varname> (addy) for each, and the " 712"rating. The lower the rating the more likely the match. Results are sorted " 713"by lowest rating first. Uses Tiger data (edges,faces,addr), PostgreSQL fuzzy " 714"string matching (soundex,levenshtein) and PostGIS line interpolation " 715"functions to interpolate address along the Tiger edges. The higher the " 716"rating the less likely the geocode is right. The geocoded point is defaulted " 717"to offset 10 meters from center-line off to side (L/R) of street address is " 718"located on." 719msgstr "" 720"文字列住所 (または正規化された住所)を引数に取り、NAD 83経度緯度のポイントジオ" 721"メトリ (geomout)、個々の<varname>normalized_address</varname> (addy)、評価値 " 722"(rating)からなる、可能性のある位置の集合を出力します。評価値が低いほど合致度" 723"が高くなります。Tigerデータ (エッジ、フェイス、住所)、PostgreSQLあいまい文字" 724"列合致 (soundex,levenshtein)を使い、Tigerデータのエッジに沿った住所の補間のた" 725"めにPostGIS線補間関数を使用っています。評価値が高いほどジオコードの正確度が低" 726"くなります。ジオコードされたポイントは、ストリート住所を中心線から左/右に移動" 727"しますが、デフォルトでは10メートルです。" 728 729#. Tag: para 730#: extras_tigergeocoder.xml:219 731#, no-c-format 732msgid "" 733"Enhanced: 2.0.0 to support Tiger 2010 structured data and revised some logic " 734"to improve speed, accuracy of geocoding, and to offset point from centerline " 735"to side of street address is located on. The new parameter " 736"<varname>max_results</varname> useful for specifying number of best results " 737"or just returning the best result." 738msgstr "" 739"Enhanced: 2.0.0 Tiger 2010構造のデータに対応しました。実行速度とジオコーディ" 740"ング精度を改善し、ストリート住所の位置を中心線から側線に移動するための改訂を" 741"行いました。また、良い結果の数を指定したり、最も良い結果だけを返すようにする" 742"のに使う新しいパラメータ<varname>max_results</varname>を導入しました。" 743 744#. Tag: title 745#: extras_tigergeocoder.xml:225 extras_tigergeocoder.xml:288 746#: extras_tigergeocoder.xml:377 747#, no-c-format 748msgid "Examples: Basic" 749msgstr "例: 基本" 750 751#. Tag: para 752#: extras_tigergeocoder.xml:226 753#, no-c-format 754msgid "" 755"The below examples timings are on a 3.0 GHZ single processor Windows 7 " 756"machine with 2GB ram running PostgreSQL 9.1rc1/PostGIS 2.0 loaded with all " 757"of MA,MN,CA, RI state Tiger data loaded." 758msgstr "" 759"下の例は、3.0GHzの単一プロセッサと2GBのメモリを持つWindows 7機で、PostgreSQL " 760"9.1rc1/PostGIS 2.0を走らせて、MA, MN, CA, RI の各州のTigerデータをロードした" 761"ものです。" 762 763#. Tag: para 764#: extras_tigergeocoder.xml:227 765#, no-c-format 766msgid "Exact matches are faster to compute (61ms)" 767msgstr "完全一致は速いです (61ミリ秒)" 768 769#. Tag: programlisting 770#: extras_tigergeocoder.xml:228 771#, fuzzy, no-c-format 772msgid "" 773"SELECT g.rating, ST_X(g.geomout) As lon, ST_Y(g.geomout) As lat,\n" 774" (addy).address As stno, (addy).streetname As street,\n" 775" (addy).streettypeabbrev As styp, (addy).location As city, (addy)." 776"stateabbrev As st,(addy).zip\n" 777" FROM geocode('75 State Street, Boston MA 02109', 1) As g;\n" 778" rating | lon | lat | stno | street | styp | city " 779"| st | zip\n" 780"--------+-------------------+----------------+------+--------+------+--------" 781"+----+-------\n" 782" 0 | -71.0557505845646 | 42.35897920691 | 75 | State | St | Boston " 783"| MA | 02109" 784msgstr "" 785"SELECT g.rating, ST_X(g.geomout) As lon, ST_Y(g.geomout) As lat,\n" 786" (addy).address As stno, (addy).streetname As street,\n" 787" (addy).streettypeabbrev As styp, (addy).location As city, (addy)." 788"stateabbrev As st,(addy).zip\n" 789" FROM geocode('75 State Street, Boston MA 02109') As g;\n" 790" rating | lon | lat | stno | street | styp | " 791"city | st | zip\n" 792"--------+-------------------+------------------+------+--------+------" 793"+--------+----+-------\n" 794" 0 | -71.0556722990239 | 42.3589914927049 | 75 | State | St | " 795"Boston | MA | 02109" 796 797#. Tag: para 798#: extras_tigergeocoder.xml:229 799#, no-c-format 800msgid "" 801"Even if zip is not passed in the geocoder can guess (took about 122-150 ms)" 802msgstr "郵便番号を渡さない場合でも推測可能です (122-150ミリ秒かかりました)" 803 804#. Tag: programlisting 805#: extras_tigergeocoder.xml:230 806#, no-c-format 807msgid "" 808"SELECT g.rating, ST_AsText(ST_SnapToGrid(g.geomout,0.00001)) As wktlonlat,\n" 809" (addy).address As stno, (addy).streetname As street,\n" 810" (addy).streettypeabbrev As styp, (addy).location As city, (addy)." 811"stateabbrev As st,(addy).zip\n" 812" FROM geocode('226 Hanover Street, Boston, MA',1) As g;\n" 813" rating | wktlonlat | stno | street | styp | city | st | " 814"zip\n" 815"--------+---------------------------+------+---------+------+--------+----" 816"+-------\n" 817" 1 | POINT(-71.05528 42.36316) | 226 | Hanover | St | Boston | MA | " 818"02113" 819msgstr "" 820"SELECT g.rating, ST_AsText(ST_SnapToGrid(g.geomout,0.00001)) As wktlonlat,\n" 821" (addy).address As stno, (addy).streetname As street,\n" 822" (addy).streettypeabbrev As styp, (addy).location As city, (addy)." 823"stateabbrev As st,(addy).zip\n" 824" FROM geocode('226 Hanover Street, Boston, MA',1) As g;\n" 825" rating | wktlonlat | stno | street | styp | city | st | " 826"zip\n" 827"--------+---------------------------+------+---------+------+--------+----" 828"+-------\n" 829" 1 | POINT(-71.05528 42.36316) | 226 | Hanover | St | Boston | MA | " 830"02113" 831 832#. Tag: para 833#: extras_tigergeocoder.xml:231 834#, no-c-format 835msgid "" 836"Can handle misspellings and provides more than one possible solution with " 837"ratings and takes longer (500ms)." 838msgstr "" 839"綴りの誤りを処理して、一つ以上の可能性のある答を評価値付きで提供すると遅くな" 840"ります (500ミリ秒)。" 841 842#. Tag: programlisting 843#: extras_tigergeocoder.xml:232 844#, fuzzy, no-c-format 845msgid "" 846"SELECT g.rating, ST_AsText(ST_SnapToGrid(g.geomout,0.00001)) As wktlonlat,\n" 847" (addy).address As stno, (addy).streetname As street,\n" 848" (addy).streettypeabbrev As styp, (addy).location As city, (addy)." 849"stateabbrev As st,(addy).zip\n" 850" FROM geocode('31 - 37 Stewart Street, Boston, MA 02116',1) As g;\n" 851" rating | wktlonlat | stno | street | styp | city | st | " 852"zip\n" 853"--------+---------------------------+------+--------+------+--------+----" 854"+-------\n" 855" 70 | POINT(-71.06466 42.35114) | 31 | Stuart | St | Boston | MA | " 856"02116" 857msgstr "" 858"SELECT g.rating, ST_AsText(ST_SnapToGrid(g.geomout,0.00001)) As wktlonlat,\n" 859" (addy).address As stno, (addy).streetname As street,\n" 860" (addy).streettypeabbrev As styp, (addy).location As city, (addy)." 861"stateabbrev As st,(addy).zip\n" 862" FROM geocode('31 - 37 Stewart Street, Boston, MA 02116') As g;\n" 863" rating | wktlonlat | stno | street | styp | city | st | " 864"zip\n" 865"--------+---------------------------+------+--------+------+--------+----" 866"+-------\n" 867" 70 | POINT(-71.06459 42.35113) | 31 | Stuart | St | Boston | MA | " 868"02116" 869 870#. Tag: para 871#: extras_tigergeocoder.xml:234 872#, no-c-format 873msgid "" 874"Using to do a batch geocode of addresses. Easiest is to set " 875"<varname>max_results=1</varname>. Only process those not yet geocoded (have " 876"no rating)." 877msgstr "" 878"複数住所のジオコードバッチ処理を行います。<varname>max_results=1</varname>と" 879"すると最も簡単です。まだジオコードを行っていない (評価値が無い)もののみ処理し" 880"ます。" 881 882#. Tag: programlisting 883#: extras_tigergeocoder.xml:235 884#, fuzzy, no-c-format 885msgid "" 886"CREATE TABLE addresses_to_geocode(addid serial PRIMARY KEY, address text,\n" 887" lon numeric, lat numeric, new_address text, rating integer);\n" 888"\n" 889"INSERT INTO addresses_to_geocode(address)\n" 890"VALUES ('529 Main Street, Boston MA, 02129'),\n" 891" ('77 Massachusetts Avenue, Cambridge, MA 02139'),\n" 892" ('25 Wizard of Oz, Walaford, KS 99912323'),\n" 893" ('26 Capen Street, Medford, MA'),\n" 894" ('124 Mount Auburn St, Cambridge, Massachusetts 02138'),\n" 895" ('950 Main Street, Worcester, MA 01610');\n" 896"\n" 897"-- only update the first 3 addresses (323-704 ms - there are caching and " 898"shared memory effects so first geocode you do is always slower) --\n" 899"-- for large numbers of addresses you don't want to update all at once\n" 900"-- since the whole geocode must commit at once\n" 901"-- For this example we rejoin with LEFT JOIN\n" 902"-- and set to rating to -1 rating if no match\n" 903"-- to ensure we don't regeocode a bad address\n" 904"UPDATE addresses_to_geocode\n" 905" SET (rating, new_address, lon, lat)\n" 906" = ( COALESCE(g.rating,-1), pprint_addy(g.addy),\n" 907" ST_X(g.geomout)::numeric(8,5), ST_Y(g.geomout)::numeric(8,5) )\n" 908"FROM (SELECT addid, address\n" 909" FROM addresses_to_geocode\n" 910" WHERE rating IS NULL ORDER BY addid LIMIT 3) As a\n" 911" LEFT JOIN LATERAL geocode(a.address,1) As g ON true\n" 912"WHERE a.addid = addresses_to_geocode.addid;\n" 913"\n" 914"result\n" 915"-----\n" 916"Query returned successfully: 3 rows affected, 480 ms execution time.\n" 917"\n" 918"SELECT * FROM addresses_to_geocode WHERE rating is not null;\n" 919"\n" 920" addid | address | lon | lat " 921"| new_address | rating\n" 922"-------+----------------------------------------------+-----------+----------" 923"+-------------------------------------------+--------\n" 924" 1 | 529 Main Street, Boston MA, 02129 | -71.07177 | 42.38357 " 925"| 529 Main St, Boston, MA 02129 | 0\n" 926" 2 | 77 Massachusetts Avenue, Cambridge, MA 02139 | -71.09396 | 42.35961 " 927"| 77 Massachusetts Ave, Cambridge, MA 02139 | 0\n" 928" 3 | 25 Wizard of Oz, Walaford, KS 99912323 | -97.92913 | 38.12717 " 929"| Willowbrook, KS 67502 | 108\n" 930"(3 rows)" 931msgstr "" 932"CREATE TABLE addresses_to_geocode(addid serial PRIMARY KEY, address text,\n" 933" lon numeric, lat numeric, new_address text, rating integer);\n" 934"\n" 935"INSERT INTO addresses_to_geocode(address)\n" 936"VALUES ('529 Main Street, Boston MA, 02129'),\n" 937" ('77 Massachusetts Avenue, Cambridge, MA 02139'),\n" 938" ('25 Wizard of Oz, Walaford, KS 99912323'),\n" 939" ('26 Capen Street, Medford, MA'),\n" 940" ('124 Mount Auburn St, Cambridge, Massachusetts 02138'),\n" 941" ('950 Main Street, Worcester, MA 01610');\n" 942"\n" 943"-- 全体のジオコードでは、必ず最後に一度コミットが行われます。\n" 944"-- 多数の住所があって、一度に全てを更新したくない場合として、\n" 945"-- 最初の三つのアドレスだけ更新します。\n" 946"-- (323-704ミリ秒 - キャッシュと共有メモリがあるので、最初のジオコーディング" 947"は必ず遅くなります)\n" 948"-- この例では、間違った住所の逆ジオコーディングをしなよう、\n" 949"-- LEFT JOINで再結合して、合致しないものには-1の評価値を設定しています。\n" 950"UPDATE addresses_to_geocode\n" 951" SET (rating, new_address, lon, lat)\n" 952" = ( COALESCE((g.geo).rating,-1), pprint_addy((g.geo).addy),\n" 953" ST_X((g.geo).geomout)::numeric(8,5), ST_Y((g.geo).geomout)::" 954"numeric(8,5) )\n" 955"FROM (SELECT addid\n" 956" FROM addresses_to_geocode\n" 957" WHERE rating IS NULL ORDER BY addid LIMIT 3) As a\n" 958" LEFT JOIN (SELECT addid, (geocode(address,1)) As geo\n" 959" FROM addresses_to_geocode As ag\n" 960" WHERE ag.rating IS NULL ORDER BY addid LIMIT 3) As g ON a.addid = g." 961"addid\n" 962"WHERE a.addid = addresses_to_geocode.addid;\n" 963"\n" 964"結果\n" 965"-----\n" 966"Query returned successfully: 3 rows affected, 480 ms execution time.\n" 967"\n" 968"SELECT * FROM addresses_to_geocode WHERE rating is not null;\n" 969"\n" 970" addid | address | lon | lat " 971"| new_address | rating\n" 972"-------+----------------------------------------------+-----------+----------" 973"+-------------------------------------------+--------\n" 974" 1 | 529 Main Street, Boston MA, 02129 | -71.07181 | 42.38359 " 975"| 529 Main St, Boston, MA 02129 | 0\n" 976" 2 | 77 Massachusetts Avenue, Cambridge, MA 02139 | -71.09428 | 42.35988 " 977"| 77 Massachusetts Ave, Cambridge, MA 02139 | 0\n" 978" 3 | 25 Wizard of Oz, Walaford, KS 99912323 | | " 979"| | -1" 980 981#. Tag: title 982#: extras_tigergeocoder.xml:238 983#, no-c-format 984msgid "Examples: Using Geometry filter" 985msgstr "例: ジオメトリフィルタの使用" 986 987#. Tag: programlisting 988#: extras_tigergeocoder.xml:239 989#, fuzzy, no-c-format 990msgid "" 991"SELECT g.rating, ST_AsText(ST_SnapToGrid(g.geomout,0.00001)) As wktlonlat,\n" 992" (addy).address As stno, (addy).streetname As street,\n" 993" (addy).streettypeabbrev As styp,\n" 994" (addy).location As city, (addy).stateabbrev As st,(addy).zip\n" 995" FROM geocode('100 Federal Street, MA',\n" 996" 3,\n" 997" (SELECT ST_Union(the_geom)\n" 998" FROM place WHERE statefp = '25' AND name = 'Lynn')::geometry\n" 999" ) As g;\n" 1000"\n" 1001" rating | wktlonlat | stno | street | styp | city | st | " 1002"zip\n" 1003"--------+---------------------------+------+---------+------+------+----" 1004"+-------\n" 1005" 7 | POINT(-70.96796 42.4659) | 100 | Federal | St | Lynn | MA | " 1006"01905\n" 1007" 16 | POINT(-70.96786 42.46853) | NULL | Federal | St | Lynn | MA | " 1008"01905\n" 1009"(2 rows)\n" 1010"\n" 1011"Time: 622.939 ms" 1012msgstr "" 1013"SELECT g.rating, ST_AsText(ST_SnapToGrid(g.geomout,0.00001)) As wktlonlat,\n" 1014" (addy).address As stno, (addy).streetname As street,\n" 1015" (addy).streettypeabbrev As styp,\n" 1016" (addy).location As city, (addy).stateabbrev As st,(addy).zip\n" 1017" FROM geocode('100 Federal Street, MA',\n" 1018" 3,\n" 1019" (SELECT ST_Union(the_geom)\n" 1020" FROM place WHERE statefp = '25' AND name = 'Lynn')::geometry\n" 1021" ) As g;\n" 1022"\n" 1023" rating | wktlonlat | stno | street | styp | city | st | " 1024"zip\n" 1025"--------+--------------------------+------+---------+------+------+----" 1026"+-------\n" 1027" 8 | POINT(-70.96796 42.4659) | 100 | Federal | St | Lynn | MA | " 1028"01905\n" 1029"Total query runtime: 245 ms." 1030 1031#. Tag: para 1032#: extras_tigergeocoder.xml:245 1033#, no-c-format 1034msgid "" 1035", <xref linkend=\"Pprint_Addy\"/>, <xref linkend=\"ST_AsText\"/>, <xref " 1036"linkend=\"ST_SnapToGrid\"/>, <xref linkend=\"ST_X\"/>, <xref linkend=\"ST_Y" 1037"\"/>" 1038msgstr "" 1039", <xref linkend=\"Pprint_Addy\"/>, <xref linkend=\"ST_AsText\"/>, <xref " 1040"linkend=\"ST_SnapToGrid\"/>, <xref linkend=\"ST_X\"/>, <xref linkend=\"ST_Y" 1041"\"/>" 1042 1043#. Tag: refname 1044#: extras_tigergeocoder.xml:252 1045#, no-c-format 1046msgid "Geocode_Intersection" 1047msgstr "Geocode_Intersection" 1048 1049#. Tag: refpurpose 1050#: extras_tigergeocoder.xml:254 1051#, no-c-format 1052msgid "" 1053"Takes in 2 streets that intersect and a state, city, zip, and outputs a set " 1054"of possible locations on the first cross street that is at the intersection, " 1055"also includes a geomout as the point location in NAD 83 long lat, a " 1056"<varname>normalized_address</varname> (addy) for each location, and the " 1057"rating. The lower the rating the more likely the match. Results are sorted " 1058"by lowest rating first. Can optionally pass in maximum results, defaults to " 1059"10. Uses Tiger data (edges, faces, addr), PostgreSQL fuzzy string matching " 1060"(soundex, levenshtein)." 1061msgstr "" 1062"インタセクトする二つのストリート、州コード、市名、郵便番号を引数に取り、最初" 1063"の交差点の可能性のある位置の集合を出力します。geomoutにNAD83経度緯度のポイン" 1064"ト、<varname>normalized_address</varname>にそれぞれの位置、ratingに評価値がそ" 1065"れぞれ入ります。評価値が低いほど合致度が高くなります。結果は評価値の低い順に" 1066"ソートされます。最大結果数を渡すことができ、デフォルトは10です。Tigerデータ " 1067"(エッジ、フェイス、住所)と、PostgreSQLあいまい文字列合致 (soundex, " 1068"levenshtein)を使います。" 1069 1070#. Tag: funcprototype 1071#: extras_tigergeocoder.xml:259 1072#, no-c-format 1073msgid "" 1074"<funcdef>setof record <function>geocode_intersection</function></funcdef> " 1075"<paramdef><type>text </type> <parameter> roadway1</parameter></paramdef> " 1076"<paramdef><type>text </type> <parameter> roadway2</parameter></paramdef> " 1077"<paramdef><type>text </type> <parameter> in_state</parameter></paramdef> " 1078"<paramdef choice=\"opt\"><type>text </type> <parameter> in_city</parameter></" 1079"paramdef> <paramdef choice=\"opt\"><type>text </type> <parameter> in_zip</" 1080"parameter></paramdef> <paramdef choice=\"opt\"><type>integer </type> " 1081"<parameter>max_results=10</parameter></paramdef> <paramdef><type>norm_addy </" 1082"type> <parameter>OUT addy</parameter></paramdef> <paramdef><type>geometry </" 1083"type> <parameter>OUT geomout</parameter></paramdef> <paramdef><type>integer " 1084"</type> <parameter>OUT rating</parameter></paramdef>" 1085msgstr "" 1086"<funcdef>setof record <function>geocode_intersection</function></funcdef> " 1087"<paramdef><type>text </type> <parameter> roadway1</parameter></paramdef> " 1088"<paramdef><type>text </type> <parameter> roadway2</parameter></paramdef> " 1089"<paramdef><type>text </type> <parameter> in_state</parameter></paramdef> " 1090"<paramdef choice=\"opt\"><type>text </type> <parameter> in_city</parameter></" 1091"paramdef> <paramdef choice=\"opt\"><type>text </type> <parameter> in_zip</" 1092"parameter></paramdef> <paramdef choice=\"opt\"><type>integer </type> " 1093"<parameter>max_results=10</parameter></paramdef> <paramdef><type>norm_addy </" 1094"type> <parameter>OUT addy</parameter></paramdef> <paramdef><type>geometry </" 1095"type> <parameter>OUT geomout</parameter></paramdef> <paramdef><type>integer " 1096"</type> <parameter>OUT rating</parameter></paramdef>" 1097 1098#. Tag: para 1099#: extras_tigergeocoder.xml:277 1100#, no-c-format 1101msgid "" 1102"Takes in 2 streets that intersect and a state, city, zip, and outputs a set " 1103"of possible locations on the first cross street that is at the intersection, " 1104"also includes a point geometry in NAD 83 long lat, a normalized address for " 1105"each location, and the rating. The lower the rating the more likely the " 1106"match. Results are sorted by lowest rating first. Can optionally pass in " 1107"maximum results, defaults to 10. Returns <varname>normalized_address</" 1108"varname> (addy) for each, geomout as the point location in nad 83 long lat, " 1109"and the rating. The lower the rating the more likely the match. Results are " 1110"sorted by lowest rating first. Uses Tiger data (edges,faces,addr), " 1111"PostgreSQL fuzzy string matching (soundex,levenshtein)" 1112msgstr "" 1113"インタセクトする二つのストリート、州コード、市名、郵便番号を引数に取り、最初" 1114"の交差点の可能性のある位置の集合を出力します。集合の要素は、NAD83経度緯度のポ" 1115"イント、正規化された住所、評価値を持ちます。評価値が低いほど合致度が高くなり" 1116"ます。結果は評価値の低い順にソートされます。最大結果数を渡すことができ、デ" 1117"フォルトは10です。<varname>normalized_address</varname> (addy)、NAD83経度緯度" 1118"のポイントとしてgeomout、評価値としてratingを返します。評価値が低いほど合致度" 1119"が高くなります。結果は評価値の低い順にソートされます。Tigerデータ (エッジ、" 1120"フェイス、住所)と、PostgreSQLあいまい文字列合致 (soundex, levenshtein)を使い" 1121"ます。" 1122 1123#. Tag: para 1124#: extras_tigergeocoder.xml:289 1125#, no-c-format 1126msgid "" 1127"The below examples timings are on a 3.0 GHZ single processor Windows 7 " 1128"machine with 2GB ram running PostgreSQL 9.0/PostGIS 1.5 loaded with all of " 1129"MA state Tiger data loaded. Currently a bit slow (3000 ms)" 1130msgstr "" 1131"下の例では、3.0GHz単一プロセッサで2GBメモリのWindows 7機上でPostgreSQL 9.0/" 1132"PostGIS 1.5を走らせ、マサチューセッツ州のTigerデータをロードしています。この" 1133"場合は、少し遅いです (3000ミリ秒)。" 1134 1135#. Tag: para 1136#: extras_tigergeocoder.xml:290 1137#, no-c-format 1138msgid "" 1139"Testing on Windows 2003 64-bit 8GB on PostGIS 2.0 PostgreSQL 64-bit Tiger " 1140"2011 data loaded -- (41ms)" 1141msgstr "" 1142"Windows 2003 64ビット 8GBでPostGIS 2.0、PostgreSQL 64ビット版を動かし、Tiger " 1143"2011データがロードされている場合もテストしています (41ミリ秒)。" 1144 1145#. Tag: programlisting 1146#: extras_tigergeocoder.xml:291 1147#, no-c-format 1148msgid "" 1149"SELECT pprint_addy(addy), st_astext(geomout),rating\n" 1150" FROM geocode_intersection( 'Haverford St','Germania St', 'MA', " 1151"'Boston', '02130',1);\n" 1152" pprint_addy | st_astext | rating\n" 1153"----------------------------------+----------------------------+--------\n" 1154"98 Haverford St, Boston, MA 02130 | POINT(-71.101375 42.31376) | 0" 1155msgstr "" 1156"SELECT pprint_addy(addy), st_astext(geomout),rating\n" 1157" FROM geocode_intersection( 'Haverford St','Germania St', 'MA', " 1158"'Boston', '02130',1);\n" 1159" pprint_addy | st_astext | rating\n" 1160"----------------------------------+----------------------------+--------\n" 1161"98 Haverford St, Boston, MA 02130 | POINT(-71.101375 42.31376) | 0" 1162 1163#. Tag: para 1164#: extras_tigergeocoder.xml:292 1165#, no-c-format 1166msgid "" 1167"Even if zip is not passed in the geocoder can guess (took about 3500 ms on " 1168"the windows 7 box), on the windows 2003 64-bit 741 ms" 1169msgstr "" 1170"郵便番号をジオコーダに渡さない場合でも動作し、Windows 2003 64ビットで741ミリ" 1171"秒でした(Windows 7機で3500ミリ秒)。" 1172 1173#. Tag: programlisting 1174#: extras_tigergeocoder.xml:293 1175#, no-c-format 1176msgid "" 1177"SELECT pprint_addy(addy), st_astext(geomout),rating\n" 1178" FROM geocode_intersection('Weld', 'School', 'MA', " 1179"'Boston');\n" 1180" pprint_addy | st_astext | rating\n" 1181"-------------------------------+--------------------------+--------\n" 1182" 98 Weld Ave, Boston, MA 02119 | POINT(-71.099 42.314234) | 3\n" 1183" 99 Weld Ave, Boston, MA 02119 | POINT(-71.099 42.314234) | 3" 1184msgstr "" 1185"SELECT pprint_addy(addy), st_astext(geomout),rating\n" 1186" FROM geocode_intersection('Weld', 'School', 'MA', " 1187"'Boston');\n" 1188" pprint_addy | st_astext | rating\n" 1189"-------------------------------+--------------------------+--------\n" 1190" 98 Weld Ave, Boston, MA 02119 | POINT(-71.099 42.314234) | 3\n" 1191" 99 Weld Ave, Boston, MA 02119 | POINT(-71.099 42.314234) | 3" 1192 1193#. Tag: para 1194#: extras_tigergeocoder.xml:299 1195#, no-c-format 1196msgid ", <xref linkend=\"Pprint_Addy\"/>, <xref linkend=\"ST_AsText\"/>" 1197msgstr ", <xref linkend=\"Pprint_Addy\"/>, <xref linkend=\"ST_AsText\"/>" 1198 1199#. Tag: refname 1200#: extras_tigergeocoder.xml:305 1201#, no-c-format 1202msgid "Get_Geocode_Setting" 1203msgstr "Get_Geocode_Setting" 1204 1205#. Tag: refpurpose 1206#: extras_tigergeocoder.xml:307 1207#, no-c-format 1208msgid "" 1209"Returns value of specific setting stored in tiger.geocode_settings table." 1210msgstr "" 1211"tiger.geocode_settingsテーブルに格納されている設定のうち指定したものの値を返" 1212"します。" 1213 1214#. Tag: funcprototype 1215#: extras_tigergeocoder.xml:312 1216#, no-c-format 1217msgid "" 1218"<funcdef>text <function>Get_Geocode_Setting</function></funcdef> " 1219"<paramdef><type>text </type> <parameter> setting_name</parameter></paramdef>" 1220msgstr "" 1221"<funcdef>text <function>Get_Geocode_Setting</function></funcdef> " 1222"<paramdef><type>text </type> <parameter> setting_name</parameter></paramdef>" 1223 1224#. Tag: para 1225#: extras_tigergeocoder.xml:322 1226#, no-c-format 1227msgid "" 1228"Returns value of specific setting stored in tiger.geocode_settings table. " 1229"Settings allow you to toggle debugging of functions. Later plans will be to " 1230"control rating with settings. Current list of settings are as follows:" 1231msgstr "" 1232"tiger.geocode_settingsテーブルに格納されている設定のうち指定したものの値を返" 1233"します。設定によって、関数のデバッグの制御が可能です。今後の予定では、評価値" 1234"の制御ができるようにします。現在の設定は次の通りです。" 1235 1236#. Tag: screen 1237#: extras_tigergeocoder.xml:323 1238#, no-c-format 1239msgid "" 1240"name | setting | unit | category " 1241"| short_desc\n" 1242"--------------------------------+---------+---------+-----------" 1243"+------------------------------------------------------------------------------------------------------------------------------\n" 1244" debug_geocode_address | false | boolean | debug | outputs " 1245"debug information in notice log such as queries when geocode_address is " 1246"called if true\n" 1247" debug_geocode_intersection | false | boolean | debug | outputs " 1248"debug information in notice log such as queries when geocode_intersection is " 1249"called if true\n" 1250" debug_normalize_address | false | boolean | debug | outputs " 1251"debug information in notice log such as queries and intermediate expressions " 1252"when normalize_address is called if true\n" 1253" debug_reverse_geocode | false | boolean | debug | if true, " 1254"outputs debug information in notice log such as queries and intermediate " 1255"expressions when reverse_geocode\n" 1256" reverse_geocode_numbered_roads | 0 | integer | rating | For state " 1257"and county highways, 0 - no preference in name,\n" 1258" 1 - prefer " 1259"the numbered highway name, 2 - prefer local state/county name\n" 1260" use_pagc_address_parser | false | boolean | normalize | If set to " 1261"true, will try to use the address_standardizer extension (via " 1262"pagc_normalize_address)\n" 1263" instead of " 1264"tiger normalize_address built one" 1265msgstr "" 1266"name | setting | unit | category " 1267"| short_desc\n" 1268"--------------------------------+---------+---------+-----------" 1269"+------------------------------------------------------------------------------------------------------------------------------\n" 1270" debug_geocode_address | false | boolean | debug | trueの場合" 1271"には、geocode_addressが呼ばれた時に、クエリ等のデバッグ情報をNOTICEログに出力" 1272"します\n" 1273" debug_geocode_intersection | false | boolean | debug | trueの場合" 1274"には、geocode_intersectionが呼ばれた時に、クエリ等のデバッグ情報をNOTICEログ" 1275"に出力します\n" 1276" debug_normalize_address | false | boolean | debug | trueの場合" 1277"には、normalize_addressが呼ばれた時に、クエリや中間表現等のデバッグ情報を" 1278"NOTICEログに出力します\n" 1279" debug_reverse_geocode | false | boolean | debug | trueの場合" 1280"には、reverse_geocodeが呼ばれた時に、クエリや中間表現等のデバッグ情報をNOTICE" 1281"ログに出力します\n" 1282" reverse_geocode_numbered_roads | 0 | integer | rating | 州道名と郡" 1283"道名について、0-どの名前でもよい、1-道路番号優先、2-州/郡名優先\n" 1284" use_pagc_address_parser | false | boolean | normalize | trueの場合" 1285"には、address_standardizer (pagc_normalize_address経由)を使おうと試みます。" 1286 1287#. Tag: para 1288#: extras_tigergeocoder.xml:325 1289#, no-c-format 1290msgid "" 1291"Changed: 2.2.0 : default settings are now kept in a table called " 1292"geocode_settings_default. Use customized settingsa are in geocode_settings " 1293"and only contain those that have been set by user." 1294msgstr "" 1295"Changed: 2.2.0 : デフォルト設定をgeocode_settingsに保存するようにしました。" 1296"ユーザが設定したものだけがgeocode_settings内にあります。" 1297 1298#. Tag: title 1299#: extras_tigergeocoder.xml:332 extras_tigergeocoder.xml:1046 1300#, no-c-format 1301msgid "Example return debugging setting" 1302msgstr "デバッグ設定を返す例" 1303 1304#. Tag: programlisting 1305#: extras_tigergeocoder.xml:333 1306#, no-c-format 1307msgid "" 1308"SELECT get_geocode_setting('debug_geocode_address) As result;\n" 1309"result\n" 1310"---------\n" 1311"false" 1312msgstr "" 1313"SELECT get_geocode_setting('debug_geocode_address) As result;\n" 1314"result\n" 1315"---------\n" 1316"false" 1317 1318#. Tag: refname 1319#: extras_tigergeocoder.xml:345 1320#, no-c-format 1321msgid "Get_Tract" 1322msgstr "Get_Tract" 1323 1324#. Tag: refpurpose 1325#: extras_tigergeocoder.xml:347 1326#, no-c-format 1327msgid "" 1328"Returns census tract or field from tract table of where the geometry is " 1329"located. Default to returning short name of tract." 1330msgstr "" 1331"ジオメトリで指定した位置の米国国勢調査統計区またはtractテーブルのフィールドを" 1332"返します。デフォルトでは、統計区の短縮名を返します。" 1333 1334#. Tag: funcprototype 1335#: extras_tigergeocoder.xml:352 1336#, no-c-format 1337msgid "" 1338"<funcdef>text <function>get_tract</function></funcdef> " 1339"<paramdef><type>geometry </type> <parameter> loc_geom</parameter></paramdef> " 1340"<paramdef choice=\"opt\"><type>text </type> <parameter> output_field=name</" 1341"parameter></paramdef>" 1342msgstr "" 1343"<funcdef>text <function>get_tract</function></funcdef> " 1344"<paramdef><type>geometry </type> <parameter> loc_geom</parameter></paramdef> " 1345"<paramdef choice=\"opt\"><type>text </type> <parameter> output_field=name</" 1346"parameter></paramdef>" 1347 1348#. Tag: para 1349#: extras_tigergeocoder.xml:363 1350#, no-c-format 1351msgid "" 1352"Given a geometry will return the census tract location of that geometry. NAD " 1353"83 long lat is assumed if no spatial ref sys is specified." 1354msgstr "" 1355"ジオメトリを与えると、ジオメトリの位置の米国国勢調査統計区を返します。空間参" 1356"照系を指定しない場合には、NAD83経度緯度と仮定します。" 1357 1358#. Tag: para 1359#: extras_tigergeocoder.xml:364 1360#, no-c-format 1361msgid "" 1362"This function uses the census <varname>tract</varname> whic is not loaded by " 1363"default. If you have already loaded your state table, you can load tract as " 1364"well as bg, and tabblock using the <xref linkend=" 1365"\"Loader_Generate_Census_Script\"/> script." 1366msgstr "" 1367 1368#. Tag: para 1369#: extras_tigergeocoder.xml:366 1370#, no-c-format 1371msgid "" 1372"If you have not loaded your state data yet and want these additional tables " 1373"loaded, do the following" 1374msgstr "" 1375 1376#. Tag: programlisting 1377#: extras_tigergeocoder.xml:367 1378#, no-c-format 1379msgid "" 1380"UPDATE tiger.loader_lookuptables SET load = true WHERE load = false AND " 1381"lookup_name IN('tract', 'bg', 'tabblock');" 1382msgstr "" 1383 1384#. Tag: para 1385#: extras_tigergeocoder.xml:368 1386#, fuzzy, no-c-format 1387msgid "" 1388"then they will be included by the <xref linkend=\"Loader_Generate_Script\"/>." 1389msgstr ", <xref linkend=\"Missing_Indexes_Generate_Script\"/>" 1390 1391#. Tag: programlisting 1392#: extras_tigergeocoder.xml:378 1393#, no-c-format 1394msgid "" 1395"SELECT get_tract(ST_Point(-71.101375, 42.31376) ) As tract_name;\n" 1396"tract_name\n" 1397"---------\n" 1398"1203.01" 1399msgstr "" 1400"SELECT get_tract(ST_Point(-71.101375, 42.31376) ) As tract_name;\n" 1401"tract_name\n" 1402"---------\n" 1403"1203.01" 1404 1405#. Tag: programlisting 1406#: extras_tigergeocoder.xml:379 1407#, no-c-format 1408msgid "" 1409"--this one returns the tiger geoid\n" 1410"SELECT get_tract(ST_Point(-71.101375, 42.31376), 'tract_id' ) As tract_id;\n" 1411"tract_id\n" 1412"---------\n" 1413"25025120301" 1414msgstr "" 1415"-- Tigerの地理識別子を返します\n" 1416"SELECT get_tract(ST_Point(-71.101375, 42.31376), 'tract_id' ) As tract_id;\n" 1417"tract_id\n" 1418"---------\n" 1419"25025120301" 1420 1421#. Tag: para 1422#: extras_tigergeocoder.xml:385 1423#, no-c-format 1424msgid "<para>></para>" 1425msgstr "<para>></para>" 1426 1427#. Tag: refname 1428#: extras_tigergeocoder.xml:391 1429#, no-c-format 1430msgid "Install_Missing_Indexes" 1431msgstr "Install_Missing_Indexes" 1432 1433#. Tag: refpurpose 1434#: extras_tigergeocoder.xml:393 1435#, no-c-format 1436msgid "" 1437"Finds all tables with key columns used in geocoder joins and filter " 1438"conditions that are missing used indexes on those columns and will add them." 1439msgstr "" 1440"ジオコーダで結合や検索条件に使われ、インデックスが付いていなキーカラムを持つ" 1441"全てのテーブルを探し、インデックスを追加します。" 1442 1443#. Tag: funcprototype 1444#: extras_tigergeocoder.xml:398 1445#, no-c-format 1446msgid "" 1447"<funcdef>boolean <function>Install_Missing_Indexes</function></funcdef> " 1448"<paramdef></paramdef>" 1449msgstr "" 1450"<funcdef>boolean <function>Install_Missing_Indexes</function></funcdef> " 1451"<paramdef></paramdef>" 1452 1453#. Tag: para 1454#: extras_tigergeocoder.xml:408 1455#, no-c-format 1456msgid "" 1457"Finds all tables in <varname>tiger</varname> and <varname>tiger_data</" 1458"varname> schemas with key columns used in geocoder joins and filters that " 1459"are missing indexes on those columns and will output the SQL DDL to define " 1460"the index for those tables and then execute the generated script. This is a " 1461"helper function that adds new indexes needed to make queries faster that may " 1462"have been missing during the load process. This function is a companion to " 1463"<xref linkend=\"Missing_Indexes_Generate_Script\"/> that in addition to " 1464"generating the create index script, also executes it. It is called as part " 1465"of the <filename>update_geocode.sql</filename> upgrade script." 1466msgstr "" 1467"ジオコーダで結合や検索条件に使われ、インデックスが付いていなキーカラムを持" 1468"つ、<varname>tiger</varname>スキーマと<varname>tiger_data</varname>スキーマ内" 1469"の全てのテーブルを探し、これらのテーブルにインデックスを追加するためのSQLデー" 1470"タ定義言語を出力し、実行します。これは、クエリの動作速度を上げるのに必要であ" 1471"るのにロード処理で失われたインデックスを追加するのを助ける関数です。インデッ" 1472"クス追加スクリプトの生成と実行を行う<xref linkend=" 1473"\"Missing_Indexes_Generate_Script\"/>の仲間です。この関数は" 1474"<filename>update_geocode.sql</filename>更新スクリプトの一部として呼ばれます。" 1475 1476#. Tag: programlisting 1477#: extras_tigergeocoder.xml:422 1478#, no-c-format 1479msgid "" 1480"SELECT install_missing_indexes();\n" 1481" install_missing_indexes\n" 1482"-------------------------\n" 1483" t" 1484msgstr "" 1485"SELECT install_missing_indexes();\n" 1486" install_missing_indexes\n" 1487"-------------------------\n" 1488" t" 1489 1490#. Tag: refname 1491#: extras_tigergeocoder.xml:435 1492#, no-c-format 1493msgid "Loader_Generate_Census_Script" 1494msgstr "Loader_Generate_Census_Script" 1495 1496#. Tag: refpurpose 1497#: extras_tigergeocoder.xml:437 1498#, no-c-format 1499msgid "" 1500"Generates a shell script for the specified platform for the specified states " 1501"that will download Tiger census state tract, bg, and tabblocks data tables, " 1502"stage and load into <varname>tiger_data</varname> schema. Each state script " 1503"is returned as a separate record." 1504msgstr "" 1505"指定した州について、tract (統計区)、bg (block group, 細分区グループ)、" 1506"tabblock (ブロック)をダウンロードし、<varname>tiger_data</varname>に格納する" 1507"ための、指定したプラットフォーム用のシェルスクリプトを生成します。行ごとに州" 1508"ごとのスクリプトが返されます。" 1509 1510#. Tag: funcprototype 1511#: extras_tigergeocoder.xml:442 1512#, no-c-format 1513msgid "" 1514"<funcdef>setof text <function>loader_generate_census_script</function></" 1515"funcdef> <paramdef><type>text[]</type> <parameter>param_states</parameter></" 1516"paramdef> <paramdef><type>text</type> <parameter>os</parameter></paramdef>" 1517msgstr "" 1518"<funcdef>setof text <function>loader_generate_census_script</function></" 1519"funcdef> <paramdef><type>text[]</type> <parameter>param_states</parameter></" 1520"paramdef> <paramdef><type>text</type> <parameter>os</parameter></paramdef>" 1521 1522#. Tag: para 1523#: extras_tigergeocoder.xml:453 1524#, no-c-format 1525msgid "" 1526"Generates a shell script for the specified platform for the specified states " 1527"that will download Tiger data census state <varname>tract</varname>, block " 1528"groups <varname>bg</varname>, and <varname>tabblocks</varname> data tables, " 1529"stage and load into <varname>tiger_data</varname> schema. Each state script " 1530"is returned as a separate record." 1531msgstr "" 1532"指定した州について、<varname>tract</varname> (統計区)、<varname>bg</varname> " 1533"(block group, 細分区グループ)、<varname>tabblock</varname> (ブロック)をダウン" 1534"ロードし、<varname>tiger_data</varname>に格納するための、指定したプラット" 1535"フォーム用のシェルスクリプトを生成します。行ごとに州ごとのスクリプトが返され" 1536"ます。" 1537 1538#. Tag: para 1539#: extras_tigergeocoder.xml:454 1540#, no-c-format 1541msgid "" 1542"It uses unzip on Linux (7-zip on Windows by default) and wget to do the " 1543"downloading. It uses <xref linkend=\"shp2pgsql_usage\"/> to load in the " 1544"data. Note the smallest unit it does is a whole state. It will only process " 1545"the files in the staging and temp folders." 1546msgstr "" 1547"ダウンロードには、Linuxではunzip (Windowsのデフォルトは7-zip)とwgetとを使いま" 1548"す。データの格納には<xref linkend=\"shp2pgsql_usage\"/>を使います。最小単位は" 1549"州全体です。生成されるスクリプトは、格納準備中の一時フォルダ内にあるファイル" 1550"のみ処理します。" 1551 1552#. Tag: para 1553#: extras_tigergeocoder.xml:456 extras_tigergeocoder.xml:514 1554#, no-c-format 1555msgid "" 1556"It uses the following control tables to control the process and different OS " 1557"shell syntax variations." 1558msgstr "" 1559"プロセスの制御や異なるOSのシェルの書式の制御のために、次の制御テーブルを使い" 1560"ます。" 1561 1562#. Tag: para 1563#: extras_tigergeocoder.xml:460 extras_tigergeocoder.xml:518 1564#: extras_tigergeocoder.xml:578 1565#, no-c-format 1566msgid "" 1567"<varname>loader_variables</varname> keeps track of various variables such as " 1568"census site, year, data and staging schemas" 1569msgstr "" 1570"<varname>loader_variables</varname> 国勢調査ダウンロードサイト、年度、データ" 1571"と準備スキーマといった種々の変数の軌跡を保持します。" 1572 1573#. Tag: para 1574#: extras_tigergeocoder.xml:463 extras_tigergeocoder.xml:521 1575#, no-c-format 1576msgid "" 1577"<varname>loader_platform</varname> profiles of various platforms and where " 1578"the various executables are located. Comes with windows and linux. More can " 1579"be added." 1580msgstr "" 1581"<varname>loader_platform</varname> 種々のプラットフォームのプロファイルと種々" 1582"の実行ファイルを置いてある位置です。windowsとLinux/unixを備えています。追加も" 1583"可能です。" 1584 1585#. Tag: para 1586#: extras_tigergeocoder.xml:466 extras_tigergeocoder.xml:524 1587#: extras_tigergeocoder.xml:584 1588#, no-c-format 1589msgid "" 1590"<varname>loader_lookuptables</varname> each record defines a kind of table " 1591"(state, county), whether to process records in it and how to load them in. " 1592"Defines the steps to import data, stage data, add, removes columns, indexes, " 1593"and constraints for each. Each table is prefixed with the state and inherits " 1594"from a table in the tiger schema. e.g. creates <varname>tiger_data.ma_faces</" 1595"varname> which inherits from <varname>tiger.faces</varname>" 1596msgstr "" 1597"レコードごとにテーブルの種類 (州、国)、レコード処理の有無、ロード方法を定義し" 1598"ています。データインポート方法、データ格納準備、カラム追加、カラム削除、イン" 1599"デックス、制約がそれぞれで定義されています。個々のテーブルは、名前の先頭に州" 1600"コードを持ち、tigerスキーマのテーブルから継承されています。たとえば、" 1601"<varname>tiger.faces</varname>から継承された<varname>tiger_data.ma_faces</" 1602"varname>する、といったことが行われます。" 1603 1604#. Tag: para 1605#: extras_tigergeocoder.xml:470 1606#, no-c-format 1607msgid "" 1608"includes this logic, but if you installed tiger geocoder prior to PostGIS " 1609"2.0.0 alpha5, you'll need to run this on the states you have already done to " 1610"get these additional tables." 1611msgstr "" 1612"は、このロジックを含んでいますが、PostGIS 2.0.0 alpha 5より前にTigerジオコー" 1613"ダをインストールしてLoader_Generate_Scriptを実行した場合には、これを実行する" 1614"必要があります。" 1615 1616#. Tag: para 1617#: extras_tigergeocoder.xml:477 1618#, no-c-format 1619msgid "" 1620"Generate script to load up data for select states in Windows shell script " 1621"format." 1622msgstr "" 1623"Windowsシェルスクリプト書式での選択した州のデータをロードするスクリプトの生" 1624"成。" 1625 1626#. Tag: programlisting 1627#: extras_tigergeocoder.xml:478 1628#, no-c-format 1629msgid "" 1630"SELECT loader_generate_census_script(ARRAY['MA'], 'windows');\n" 1631"-- result --\n" 1632"set STATEDIR=\"\\gisdata\\www2.census.gov\\geo\\pvs\\tiger2010st" 1633"\\25_Massachusetts\"\n" 1634"set TMPDIR=\\gisdata\\temp\\\n" 1635"set UNZIPTOOL=\"C:\\Program Files\\7-Zip\\7z.exe\"\n" 1636"set WGETTOOL=\"C:\\wget\\wget.exe\"\n" 1637"set PGBIN=C:\\projects\\pg\\pg91win\\bin\\\n" 1638"set PGPORT=5432\n" 1639"set PGHOST=localhost\n" 1640"set PGUSER=postgres\n" 1641"set PGPASSWORD=yourpasswordhere\n" 1642"set PGDATABASE=tiger_postgis20\n" 1643"set PSQL=\"%PGBIN%psql\"\n" 1644"set SHP2PGSQL=\"%PGBIN%shp2pgsql\"\n" 1645"cd \\gisdata\n" 1646"\n" 1647"%WGETTOOL% http://www2.census.gov/geo/pvs/tiger2010st/25_Massachusetts/25/ --" 1648"no-parent --relative --accept=*bg10.zip,*tract10.zip,*tabblock10.zip --" 1649"mirror --reject=html\n" 1650"del %TMPDIR%\\*.* /Q\n" 1651"%PSQL% -c \"DROP SCHEMA tiger_staging CASCADE;\"\n" 1652"%PSQL% -c \"CREATE SCHEMA tiger_staging;\"\n" 1653"cd %STATEDIR%\n" 1654"for /r %%z in (*.zip) do %UNZIPTOOL% e %%z -o%TMPDIR%\n" 1655"cd %TMPDIR%\n" 1656"%PSQL% -c \"CREATE TABLE tiger_data.MA_tract(CONSTRAINT pk_MA_tract PRIMARY " 1657"KEY (tract_id) ) INHERITS(tiger.tract); \"\n" 1658"%SHP2PGSQL% -c -s 4269 -g the_geom -W \"latin1\" tl_2010_25_tract10.dbf " 1659"tiger_staging.ma_tract10 | %PSQL%\n" 1660"%PSQL% -c \"ALTER TABLE tiger_staging.MA_tract10 RENAME geoid10 TO " 1661"tract_id; SELECT loader_load_staged_data(lower('MA_tract10'), " 1662"lower('MA_tract')); \"\n" 1663"%PSQL% -c \"CREATE INDEX tiger_data_MA_tract_the_geom_gist ON tiger_data." 1664"MA_tract USING gist(the_geom);\"\n" 1665"%PSQL% -c \"VACUUM ANALYZE tiger_data.MA_tract;\"\n" 1666"%PSQL% -c \"ALTER TABLE tiger_data.MA_tract ADD CONSTRAINT chk_statefp CHECK " 1667"(statefp = '25');\"\n" 1668":" 1669msgstr "" 1670"SELECT loader_generate_census_script(ARRAY['MA'], 'windows');\n" 1671"-- 結果 --\n" 1672"set STATEDIR=\"\\gisdata\\www2.census.gov\\geo\\pvs\\tiger2010st" 1673"\\25_Massachusetts\"\n" 1674"set TMPDIR=\\gisdata\\temp\\\n" 1675"set UNZIPTOOL=\"C:\\Program Files\\7-Zip\\7z.exe\"\n" 1676"set WGETTOOL=\"C:\\wget\\wget.exe\"\n" 1677"set PGBIN=C:\\projects\\pg\\pg91win\\bin\\\n" 1678"set PGPORT=5432\n" 1679"set PGHOST=localhost\n" 1680"set PGUSER=postgres\n" 1681"set PGPASSWORD=yourpasswordhere\n" 1682"set PGDATABASE=tiger_postgis20\n" 1683"set PSQL=\"%PGBIN%psql\"\n" 1684"set SHP2PGSQL=\"%PGBIN%shp2pgsql\"\n" 1685"cd \\gisdata\n" 1686"\n" 1687"%WGETTOOL% http://www2.census.gov/geo/pvs/tiger2010st/25_Massachusetts/25/ --" 1688"no-parent --relative --accept=*bg10.zip,*tract10.zip,*tabblock10.zip --" 1689"mirror --reject=html\n" 1690"del %TMPDIR%\\*.* /Q\n" 1691"%PSQL% -c \"DROP SCHEMA tiger_staging CASCADE;\"\n" 1692"%PSQL% -c \"CREATE SCHEMA tiger_staging;\"\n" 1693"cd %STATEDIR%\n" 1694"for /r %%z in (*.zip) do %UNZIPTOOL% e %%z -o%TMPDIR%\n" 1695"cd %TMPDIR%\n" 1696"%PSQL% -c \"CREATE TABLE tiger_data.MA_tract(CONSTRAINT pk_MA_tract PRIMARY " 1697"KEY (tract_id) ) INHERITS(tiger.tract); \"\n" 1698"%SHP2PGSQL% -c -s 4269 -g the_geom -W \"latin1\" tl_2010_25_tract10.dbf " 1699"tiger_staging.ma_tract10 | %PSQL%\n" 1700"%PSQL% -c \"ALTER TABLE tiger_staging.MA_tract10 RENAME geoid10 TO " 1701"tract_id; SELECT loader_load_staged_data(lower('MA_tract10'), " 1702"lower('MA_tract')); \"\n" 1703"%PSQL% -c \"CREATE INDEX tiger_data_MA_tract_the_geom_gist ON tiger_data." 1704"MA_tract USING gist(the_geom);\"\n" 1705"%PSQL% -c \"VACUUM ANALYZE tiger_data.MA_tract;\"\n" 1706"%PSQL% -c \"ALTER TABLE tiger_data.MA_tract ADD CONSTRAINT chk_statefp CHECK " 1707"(statefp = '25');\"\n" 1708":" 1709 1710#. Tag: para 1711#: extras_tigergeocoder.xml:479 extras_tigergeocoder.xml:541 1712#, no-c-format 1713msgid "Generate sh script" 1714msgstr "shスクリプトの生成" 1715 1716#. Tag: programlisting 1717#: extras_tigergeocoder.xml:480 1718#, no-c-format 1719msgid "" 1720"STATEDIR=\"/gisdata/www2.census.gov/geo/pvs/tiger2010st/25_Massachusetts\"\n" 1721"TMPDIR=\"/gisdata/temp/\"\n" 1722"UNZIPTOOL=unzip\n" 1723"WGETTOOL=\"/usr/bin/wget\"\n" 1724"export PGBIN=/usr/pgsql-9.0/bin\n" 1725"export PGPORT=5432\n" 1726"export PGHOST=localhost\n" 1727"export PGUSER=postgres\n" 1728"export PGPASSWORD=yourpasswordhere\n" 1729"export PGDATABASE=geocoder\n" 1730"PSQL=${PGBIN}/psql\n" 1731"SHP2PGSQL=${PGBIN}/shp2pgsql\n" 1732"cd /gisdata\n" 1733"\n" 1734"wget http://www2.census.gov/geo/pvs/tiger2010st/25_Massachusetts/25/ --no-" 1735"parent --relative --accept=*bg10.zip,*tract10.zip,*tabblock10.zip --mirror --" 1736"reject=html\n" 1737"rm -f ${TMPDIR}/*.*\n" 1738"${PSQL} -c \"DROP SCHEMA tiger_staging CASCADE;\"\n" 1739"${PSQL} -c \"CREATE SCHEMA tiger_staging;\"\n" 1740"cd $STATEDIR\n" 1741"for z in *.zip; do $UNZIPTOOL -o -d $TMPDIR $z; done\n" 1742":\n" 1743":" 1744msgstr "" 1745"STATEDIR=\"/gisdata/www2.census.gov/geo/pvs/tiger2010st/25_Massachusetts\"\n" 1746"TMPDIR=\"/gisdata/temp/\"\n" 1747"UNZIPTOOL=unzip\n" 1748"WGETTOOL=\"/usr/bin/wget\"\n" 1749"export PGBIN=/usr/pgsql-9.0/bin\n" 1750"export PGPORT=5432\n" 1751"export PGHOST=localhost\n" 1752"export PGUSER=postgres\n" 1753"export PGPASSWORD=yourpasswordhere\n" 1754"export PGDATABASE=geocoder\n" 1755"PSQL=${PGBIN}/psql\n" 1756"SHP2PGSQL=${PGBIN}/shp2pgsql\n" 1757"cd /gisdata\n" 1758"\n" 1759"wget http://www2.census.gov/geo/pvs/tiger2010st/25_Massachusetts/25/ --no-" 1760"parent --relative --accept=*bg10.zip,*tract10.zip,*tabblock10.zip --mirror --" 1761"reject=html\n" 1762"rm -f ${TMPDIR}/*.*\n" 1763"${PSQL} -c \"DROP SCHEMA tiger_staging CASCADE;\"\n" 1764"${PSQL} -c \"CREATE SCHEMA tiger_staging;\"\n" 1765"cd $STATEDIR\n" 1766"for z in *.zip; do $UNZIPTOOL -o -d $TMPDIR $z; done\n" 1767":\n" 1768":" 1769 1770#. Tag: refname 1771#: extras_tigergeocoder.xml:493 1772#, no-c-format 1773msgid "Loader_Generate_Script" 1774msgstr "Loader_Generate_Script" 1775 1776#. Tag: refpurpose 1777#: extras_tigergeocoder.xml:495 1778#, no-c-format 1779msgid "" 1780"Generates a shell script for the specified platform for the specified states " 1781"that will download Tiger data, stage and load into <varname>tiger_data</" 1782"varname> schema. Each state script is returned as a separate record. Latest " 1783"version supports Tiger 2010 structural changes and also loads census tract, " 1784"block groups, and blocks tables." 1785msgstr "" 1786"指定したプラットフォーム用の、指定した州のTigerデータをダウンロードし、格納準" 1787"備を行い、<varname>tiger_data</varname>スキーマに格納するシェルスクリプトを生" 1788"成します。行ごとに州ごとのスクリプトが返ります。最新版ではTiger 2010のデータ" 1789"構造変更に対応していて、国勢統計区、細分区グループ、細分区 (tabblocks)テーブ" 1790"ルをダウンロードすることができます。" 1791 1792#. Tag: funcprototype 1793#: extras_tigergeocoder.xml:500 1794#, no-c-format 1795msgid "" 1796"<funcdef>setof text <function>loader_generate_script</function></funcdef> " 1797"<paramdef><type>text[]</type> <parameter>param_states</parameter></paramdef> " 1798"<paramdef><type>text</type> <parameter>os</parameter></paramdef>" 1799msgstr "" 1800"<funcdef>setof text <function>loader_generate_script</function></funcdef> " 1801"<paramdef><type>text[]</type> <parameter>param_states</parameter></paramdef> " 1802"<paramdef><type>text</type> <parameter>os</parameter></paramdef>" 1803 1804#. Tag: para 1805#: extras_tigergeocoder.xml:511 1806#, no-c-format 1807msgid "" 1808"Generates a shell script for the specified platform for the specified states " 1809"that will download Tiger data, stage and load into <varname>tiger_data</" 1810"varname> schema. Each state script is returned as a separate record." 1811msgstr "" 1812"指定したプラットフォーム用の、指定した州のTigerデータをダウンロードし、格納準" 1813"備を行い、<varname>tiger_data</varname>スキーマに格納するシェルスクリプトを生" 1814"成します。行ごとに州ごとのスクリプトが返ります。" 1815 1816#. Tag: para 1817#: extras_tigergeocoder.xml:512 1818#, no-c-format 1819msgid "" 1820"It uses unzip on Linux (7-zip on Windows by default) and wget to do the " 1821"downloading. It uses <xref linkend=\"shp2pgsql_usage\"/> to load in the " 1822"data. Note the smallest unit it does is a whole state, but you can overwrite " 1823"this by downloading the files yourself. It will only process the files in " 1824"the staging and temp folders." 1825msgstr "" 1826"ダウンロードには、Linuxではunzip (Windowsのデフォルトは7-zip)とwgetとを使いま" 1827"す。データの格納には<xref linkend=\"shp2pgsql_usage\"/>を使います。ダウンロー" 1828"ドの最小単位は州全体ですが、ファイルを手動でダウンロードすることで上書きでき" 1829"ます。生成されるスクリプトは、格納準備中の一時フォルダ内にあるファイルのみ処" 1830"理します。" 1831 1832#. Tag: para 1833#: extras_tigergeocoder.xml:527 1834#, no-c-format 1835msgid "" 1836"Availability: 2.0.0 to support Tiger 2010 structured data and load census " 1837"tract (tract), block groups (bg), and blocks (tabblocks) tables ." 1838msgstr "" 1839"Availability: 2.0.0 Tiger 2010構造のデータに対応しました。国勢統計区 " 1840"(tract)、細分区グループ (\"block groups\", bg)、細分区 (tabblocks)テーブルを" 1841"ダウンロードします。" 1842 1843#. Tag: para 1844#: extras_tigergeocoder.xml:528 1845#, no-c-format 1846msgid "" 1847"If you are using pgAdmin 3, be warned that by default pgAdmin 3 truncates " 1848"long text. To fix, change <emphasis>File -> Options -> Query Tool -" 1849"> Query Editor - > Max. characters per column</emphasis> to larger " 1850"than 50000 characters." 1851msgstr "" 1852 1853#. Tag: para 1854#: extras_tigergeocoder.xml:537 1855#, no-c-format 1856msgid "" 1857"Using psql where gistest is your database and <filename>/gisdata/data_load." 1858"sh</filename> is the file to create with the shell commands to run." 1859msgstr "" 1860 1861#. Tag: programlisting 1862#: extras_tigergeocoder.xml:538 1863#, no-c-format 1864msgid "" 1865"<![CDATA[psql -U postgres -h localhost -d gistest -A -t \\\n" 1866" -c \"SELECT Loader_Generate_Script(ARRAY['MA'], 'gistest')\" > /gisdata/" 1867"data_load.sh;]]>" 1868msgstr "" 1869 1870#. Tag: para 1871#: extras_tigergeocoder.xml:539 1872#, no-c-format 1873msgid "" 1874"Generate script to load up data for 2 states in Windows shell script format." 1875msgstr "" 1876"Windowsシェルスクリプト書式で二つの州のデータをロードするスクリプトを生成しま" 1877"す。" 1878 1879#. Tag: programlisting 1880#: extras_tigergeocoder.xml:540 1881#, fuzzy, no-c-format 1882msgid "" 1883"SELECT loader_generate_script(ARRAY['MA','RI'], 'windows') AS result;\n" 1884"-- result --\n" 1885"set TMPDIR=\\gisdata\\temp\\\n" 1886"set UNZIPTOOL=\"C:\\Program Files\\7-Zip\\7z.exe\"\n" 1887"set WGETTOOL=\"C:\\wget\\wget.exe\"\n" 1888"set PGBIN=C:\\Program Files\\PostgreSQL\\9.4\\bin\\\n" 1889"set PGPORT=5432\n" 1890"set PGHOST=localhost\n" 1891"set PGUSER=postgres\n" 1892"set PGPASSWORD=yourpasswordhere\n" 1893"set PGDATABASE=geocoder\n" 1894"set PSQL=\"%PGBIN%psql\"\n" 1895"set SHP2PGSQL=\"%PGBIN%shp2pgsql\"\n" 1896"cd \\gisdata\n" 1897"\n" 1898"cd \\gisdata\n" 1899"%WGETTOOL% ftp://ftp2.census.gov/geo/tiger/TIGER2015/PLACE/tl_*_25_* --no-" 1900"parent --relative --recursive --level=2 --accept=zip --mirror --reject=html\n" 1901"cd \\gisdata/ftp2.census.gov/geo/tiger/TIGER2015/PLACE\n" 1902":\n" 1903":" 1904msgstr "" 1905"SELECT loader_generate_script(ARRAY['MA','RI'], 'windows') AS result;\n" 1906"-- 結果 --\n" 1907"set STATEDIR=\"\\gisdata\\www2.census.gov\\geo\\pvs\\tiger2010st" 1908"\\44_Rhode_Island\"\n" 1909"set TMPDIR=\\gisdata\\temp\\\n" 1910"set UNZIPTOOL=\"C:\\Program Files\\7-Zip\\7z.exe\"\n" 1911"set WGETTOOL=\"C:\\wget\\wget.exe\"\n" 1912"set PGBIN=C:\\Program Files\\PostgreSQL\\8.4\\bin\\\n" 1913"set PGPORT=5432\n" 1914"set PGHOST=localhost\n" 1915"set PGUSER=postgres\n" 1916"set PGPASSWORD=yourpasswordhere\n" 1917"set PGDATABASE=geocoder\n" 1918"set PSQL=\"%PGBIN%psql\"\n" 1919"set SHP2PGSQL=\"%PGBIN%shp2pgsql\"\n" 1920"\n" 1921"%WGETTOOL% http://www2.census.gov/geo/pvs/tiger2010st/44_Rhode_Island/ --no-" 1922"parent --relative --recursive --level=2 --accept=zip,txt --mirror --" 1923"reject=html\n" 1924":\n" 1925":" 1926 1927#. Tag: programlisting 1928#: extras_tigergeocoder.xml:542 1929#, fuzzy, no-c-format 1930msgid "" 1931"SELECT loader_generate_script(ARRAY['MA','RI'], 'sh') AS result;\n" 1932"-- result --\n" 1933"TMPDIR=\"/gisdata/temp/\"\n" 1934"UNZIPTOOL=unzip\n" 1935"WGETTOOL=\"/usr/bin/wget\"\n" 1936"export PGBIN=/usr/lib/postgresql/9.4/bin\n" 1937"-- variables used by psql: https://www.postgresql.org/docs/current/static/" 1938"libpq-envars.html\n" 1939"export PGPORT=5432\n" 1940"export PGHOST=localhost\n" 1941"export PGUSER=postgres\n" 1942"export PGPASSWORD=yourpasswordhere\n" 1943"export PGDATABASE=geocoder\n" 1944"PSQL=${PGBIN}/psql\n" 1945"SHP2PGSQL=${PGBIN}/shp2pgsql\n" 1946"cd /gisdata\n" 1947"\n" 1948"cd /gisdata\n" 1949"wget ftp://ftp2.census.gov/geo/tiger/TIGER2015/PLACE/tl_*_25_* --no-parent --" 1950"relative --recursive --level=2 --accept=zip --mirror --reject=html\n" 1951"cd /gisdata/ftp2.census.gov/geo/tiger/TIGER2015/PLACE\n" 1952"rm -f ${TMPDIR}/*.*\n" 1953":\n" 1954":" 1955msgstr "" 1956"SELECT loader_generate_script(ARRAY['MA','RI'], 'sh') AS result;\n" 1957"-- result --\n" 1958"STATEDIR=\"/gisdata/www2.census.gov/geo/pvs/tiger2010st/44_Rhode_Island\"\n" 1959"TMPDIR=\"/gisdata/temp/\"\n" 1960"UNZIPTOOL=unzip\n" 1961"PGPORT=5432\n" 1962"PGHOST=localhost\n" 1963"PGUSER=postgres\n" 1964"PGPASSWORD=yourpasswordhere\n" 1965"PGDATABASE=geocoder\n" 1966"PSQL=psql\n" 1967"SHP2PGSQ=shp2pgsql\n" 1968"\n" 1969"wget http://www2.census.gov/geo/pvs/tiger2010st/44_Rhode_Island/ --no-parent " 1970"--relative --recursive --level=2 --accept=zip,txt --mirror --reject=html\n" 1971":\n" 1972":" 1973 1974#. Tag: para 1975#: extras_tigergeocoder.xml:549 1976#, fuzzy, no-c-format 1977msgid "" 1978", <xref linkend=\"Loader_Generate_Nation_Script\"/>, <xref linkend=" 1979"\"Drop_State_Tables_Generate_Script\"/>" 1980msgstr ", <xref linkend=\"Missing_Indexes_Generate_Script\"/>" 1981 1982#. Tag: refname 1983#: extras_tigergeocoder.xml:555 1984#, no-c-format 1985msgid "Loader_Generate_Nation_Script" 1986msgstr "Loader_Generate_Nation_Script" 1987 1988#. Tag: refpurpose 1989#: extras_tigergeocoder.xml:557 1990#, no-c-format 1991msgid "" 1992"Generates a shell script for the specified platform that loads in the county " 1993"and state lookup tables." 1994msgstr "" 1995"指定したプラットフォーム用の、国と州のルックアップテーブルをロードするシェル" 1996"スクリプトを生成します。" 1997 1998#. Tag: funcprototype 1999#: extras_tigergeocoder.xml:562 2000#, no-c-format 2001msgid "" 2002"<funcdef>text <function>loader_generate_nation_script</function></funcdef> " 2003"<paramdef><type>text</type> <parameter>os</parameter></paramdef>" 2004msgstr "" 2005"<funcdef>text <function>loader_generate_nation_script</function></funcdef> " 2006"<paramdef><type>text</type> <parameter>os</parameter></paramdef>" 2007 2008#. Tag: para 2009#: extras_tigergeocoder.xml:572 2010#, no-c-format 2011msgid "" 2012"Generates a shell script for the specified platform that loads in the " 2013"<varname>county_all</varname>, <varname>county_all_lookup</varname>, " 2014"<varname>state_all</varname> tables into <varname>tiger_data</varname> " 2015"schema. These inherit respectively from the <varname>county</varname>, " 2016"<varname>county_lookup</varname>, <varname>state</varname> tables in " 2017"<varname>tiger</varname> schema." 2018msgstr "" 2019"<varname>tiger_data</varname>スキーマに<varname>county_all</varname>, " 2020"<varname>county_all_lookup</varname>, <varname>state_all</varname>テーブルを" 2021"ロードする、指定したプラットフォーム用のシェルスクリプトを生成します。それぞ" 2022"れ<varname>tiger</varname>スキーマの<varname>county</varname>, " 2023"<varname>county_lookup</varname>, <varname>state</varname>から継承されます。" 2024 2025#. Tag: para 2026#: extras_tigergeocoder.xml:573 2027#, no-c-format 2028msgid "" 2029"It uses unzip on Linux (7-zip on Windows by default) and wget to do the " 2030"downloading. It uses <xref linkend=\"shp2pgsql_usage\"/> to load in the data." 2031msgstr "" 2032"ダウンロードには、Linuxではunzip (Windowsのデフォルトは7-zip)とwgetとを使いま" 2033"す。データの格納には<xref linkend=\"shp2pgsql_usage\"/>を使います。" 2034 2035#. Tag: para 2036#: extras_tigergeocoder.xml:574 2037#, no-c-format 2038msgid "" 2039"It uses the following control tables <varname>tiger.loader_platform</" 2040"varname>, <varname>tiger.loader_variables</varname>, and <varname>tiger." 2041"loader_lookuptables</varname> to control the process and different OS shell " 2042"syntax variations." 2043msgstr "" 2044"プロセスの制御や異なるOSのシェルの書式の制御のために、制御テーブル" 2045"<varname>tiger.loader_platform</varname>, <varname>tiger.loader_variables</" 2046"varname>, <varname>tiger.loader_lookuptables</varname>を使います。" 2047 2048#. Tag: para 2049#: extras_tigergeocoder.xml:581 2050#, no-c-format 2051msgid "" 2052"<varname>loader_platform</varname> profiles of various platforms and where " 2053"the various executables are located. Comes with windows and linux/unix. More " 2054"can be added." 2055msgstr "" 2056"<varname>loader_platform</varname>には、種々のプラットフォームのプロファイル" 2057"や実行可能ファイルの置いてある位置を持ちます。windowsとLinux/unixを備えていま" 2058"す。追加も可能です。" 2059 2060#. Tag: para 2061#: extras_tigergeocoder.xml:587 2062#, no-c-format 2063msgid "" 2064"Enhanced: 2.4.1 zip code 5 tabulation area (zcta5) load step was fixed and " 2065"when enabled, zcta5 data is loaded as a single table called zcta5_all as " 2066"part of the nation script load." 2067msgstr "" 2068 2069#. Tag: para 2070#: extras_tigergeocoder.xml:589 2071#, no-c-format 2072msgid "" 2073"If you want zip code 5 tabulation area (zcta5) to be included in your nation " 2074"script load, do the following:" 2075msgstr "" 2076 2077#. Tag: programlisting 2078#: extras_tigergeocoder.xml:589 2079#, no-c-format 2080msgid "" 2081"UPDATE tiger.loader_lookuptables SET load = true WHERE table_name = " 2082"'zcta510';" 2083msgstr "" 2084 2085#. Tag: para 2086#: extras_tigergeocoder.xml:590 2087#, fuzzy, no-c-format 2088msgid "" 2089"If you were running <varname>tiger_2010</varname> version and you want to " 2090"reload as state with newer tiger data, you'll need to for the very first " 2091"load generate and run drop statements <xref linkend=" 2092"\"Drop_Nation_Tables_Generate_Script\"/> before you run this script." 2093msgstr "" 2094"<varname>tiger_2010</varname>を実行してから<varname>tiger_2011</varname>の再" 2095"ロードを行うには、このスクリプトを実行する前に、最初に、<xref linkend=" 2096"\"Drop_Nation_Tables_Generate_Script\"/>によって、テーブル削除スクリプトを生" 2097"成、実行する必要があります。" 2098 2099#. Tag: para 2100#: extras_tigergeocoder.xml:597 2101#, no-c-format 2102msgid "Generate script script to load nation data Windows." 2103msgstr "国データをWindowsにロードするスクリプトを生成します。" 2104 2105#. Tag: programlisting 2106#: extras_tigergeocoder.xml:598 2107#, no-c-format 2108msgid "SELECT loader_generate_nation_script('windows');" 2109msgstr "SELECT loader_generate_nation_script('windows');" 2110 2111#. Tag: para 2112#: extras_tigergeocoder.xml:599 2113#, no-c-format 2114msgid "Generate script to load up data for Linux/Unix systems." 2115msgstr "国データをLinux/Unixシステムにロードするスクリプトを生成します。" 2116 2117#. Tag: programlisting 2118#: extras_tigergeocoder.xml:600 2119#, no-c-format 2120msgid "SELECT loader_generate_nation_script('sh');" 2121msgstr "SELECT loader_generate_nation_script('sh');" 2122 2123#. Tag: para 2124#: extras_tigergeocoder.xml:606 2125#, fuzzy, no-c-format 2126msgid ", <xref linkend=\"Drop_Nation_Tables_Generate_Script\"/>" 2127msgstr ", <xref linkend=\"Missing_Indexes_Generate_Script\"/>" 2128 2129#. Tag: refname 2130#: extras_tigergeocoder.xml:612 2131#, no-c-format 2132msgid "Missing_Indexes_Generate_Script" 2133msgstr "Missing_Indexes_Generate_Script" 2134 2135#. Tag: refpurpose 2136#: extras_tigergeocoder.xml:614 2137#, no-c-format 2138msgid "" 2139"Finds all tables with key columns used in geocoder joins that are missing " 2140"indexes on those columns and will output the SQL DDL to define the index for " 2141"those tables." 2142msgstr "" 2143"ジオコーダで結合に使われるキーカラムを持ち、インデックスが付いていないキーカ" 2144"ラムを持つすべてのテーブルを検索し、インデックスを追加するSQLデータ定義言語を" 2145"出力します。" 2146 2147#. Tag: funcprototype 2148#: extras_tigergeocoder.xml:620 2149#, no-c-format 2150msgid "" 2151"<funcdef>text <function>Missing_Indexes_Generate_Script</function></funcdef> " 2152"<paramdef></paramdef>" 2153msgstr "" 2154"<funcdef>text <function>Missing_Indexes_Generate_Script</function></funcdef> " 2155"<paramdef></paramdef>" 2156 2157#. Tag: para 2158#: extras_tigergeocoder.xml:630 2159#, no-c-format 2160msgid "" 2161"Finds all tables in <varname>tiger</varname> and <varname>tiger_data</" 2162"varname> schemas with key columns used in geocoder joins that are missing " 2163"indexes on those columns and will output the SQL DDL to define the index for " 2164"those tables. This is a helper function that adds new indexes needed to make " 2165"queries faster that may have been missing during the load process. As the " 2166"geocoder is improved, this function will be updated to accommodate new " 2167"indexes being used. If this function outputs nothing, it means all your " 2168"tables have what we think are the key indexes already in place." 2169msgstr "" 2170"<varname>tiger</varname>スキーマと<varname>tiger_data</varname>スキーマ内のジ" 2171"オコーダで結合に使われ、インデックスが付いていないキーカラムを持つ全てのテー" 2172"ブルを検索し、インデックスを付けるSQLデータ定義言語を出力します。これは、クエ" 2173"リの動作速度を上げるのに必要であるのにロード処理で失われたインデックスを追加" 2174"するのを助ける関数です。ジオコーダが改善されますが、使用される新しいインデッ" 2175"クスを受け入れるために、この関数は更新されます。この関数の出力が無い場合があ" 2176"りますが、これは、全てのテーブルにインデックスが付いていると考えられます。" 2177 2178#. Tag: programlisting 2179#: extras_tigergeocoder.xml:644 2180#, no-c-format 2181msgid "" 2182"SELECT missing_indexes_generate_script();\n" 2183"-- output: This was run on a database that was created before many " 2184"corrections were made to the loading script ---\n" 2185"CREATE INDEX idx_tiger_county_countyfp ON tiger.county USING " 2186"btree(countyfp);\n" 2187"CREATE INDEX idx_tiger_cousub_countyfp ON tiger.cousub USING " 2188"btree(countyfp);\n" 2189"CREATE INDEX idx_tiger_edges_tfidr ON tiger.edges USING btree(tfidr);\n" 2190"CREATE INDEX idx_tiger_edges_tfidl ON tiger.edges USING btree(tfidl);\n" 2191"CREATE INDEX idx_tiger_zip_lookup_all_zip ON tiger.zip_lookup_all USING " 2192"btree(zip);\n" 2193"CREATE INDEX idx_tiger_data_ma_county_countyfp ON tiger_data.ma_county USING " 2194"btree(countyfp);\n" 2195"CREATE INDEX idx_tiger_data_ma_cousub_countyfp ON tiger_data.ma_cousub USING " 2196"btree(countyfp);\n" 2197"CREATE INDEX idx_tiger_data_ma_edges_countyfp ON tiger_data.ma_edges USING " 2198"btree(countyfp);\n" 2199"CREATE INDEX idx_tiger_data_ma_faces_countyfp ON tiger_data.ma_faces USING " 2200"btree(countyfp);" 2201msgstr "" 2202"SELECT missing_indexes_generate_script();\n" 2203"-- 出力: 多数の修正がロードスクリプトで行われる前のデータベースで実行しまし" 2204"た ---\n" 2205"CREATE INDEX idx_tiger_county_countyfp ON tiger.county USING " 2206"btree(countyfp);\n" 2207"CREATE INDEX idx_tiger_cousub_countyfp ON tiger.cousub USING " 2208"btree(countyfp);\n" 2209"CREATE INDEX idx_tiger_edges_tfidr ON tiger.edges USING btree(tfidr);\n" 2210"CREATE INDEX idx_tiger_edges_tfidl ON tiger.edges USING btree(tfidl);\n" 2211"CREATE INDEX idx_tiger_zip_lookup_all_zip ON tiger.zip_lookup_all USING " 2212"btree(zip);\n" 2213"CREATE INDEX idx_tiger_data_ma_county_countyfp ON tiger_data.ma_county USING " 2214"btree(countyfp);\n" 2215"CREATE INDEX idx_tiger_data_ma_cousub_countyfp ON tiger_data.ma_cousub USING " 2216"btree(countyfp);\n" 2217"CREATE INDEX idx_tiger_data_ma_edges_countyfp ON tiger_data.ma_edges USING " 2218"btree(countyfp);\n" 2219"CREATE INDEX idx_tiger_data_ma_faces_countyfp ON tiger_data.ma_faces USING " 2220"btree(countyfp);" 2221 2222#. Tag: para 2223#: extras_tigergeocoder.xml:651 2224#, no-c-format 2225msgid ", <xref linkend=\"Install_Missing_Indexes\"/>" 2226msgstr ", <xref linkend=\"Install_Missing_Indexes\"/>" 2227 2228#. Tag: refname 2229#: extras_tigergeocoder.xml:657 2230#, no-c-format 2231msgid "Normalize_Address" 2232msgstr "Normalize_Address" 2233 2234#. Tag: refpurpose 2235#: extras_tigergeocoder.xml:659 2236#, no-c-format 2237msgid "" 2238"Given a textual street address, returns a composite <varname>norm_addy</" 2239"varname> type that has road suffix, prefix and type standardized, street, " 2240"streetname etc. broken into separate fields. This function will work with " 2241"just the lookup data packaged with the tiger_geocoder (no need for tiger " 2242"census data)." 2243msgstr "" 2244"文字列で住所が与えられると、道路後置辞、前置辞、正規化された種別、番地、スト" 2245"リート名等をフィールドに分けて持つ<varname>norm_addy</varname>複合型を返しま" 2246"す。tiger_geocoderに同梱されているルックアップデータで動作します (Tigerデータ" 2247"自体は不要です)。" 2248 2249#. Tag: funcprototype 2250#: extras_tigergeocoder.xml:665 2251#, no-c-format 2252msgid "" 2253"<funcdef>norm_addy <function>normalize_address</function></funcdef> " 2254"<paramdef><type>varchar </type> <parameter>in_address</parameter></paramdef>" 2255msgstr "" 2256"<funcdef>norm_addy <function>normalize_address</function></funcdef> " 2257"<paramdef><type>varchar </type> <parameter>in_address</parameter></paramdef>" 2258 2259#. Tag: para 2260#: extras_tigergeocoder.xml:675 extras_tigergeocoder.xml:761 2261#, no-c-format 2262msgid "" 2263"Given a textual street address, returns a composite <varname>norm_addy</" 2264"varname> type that has road suffix, prefix and type standardized, street, " 2265"streetname etc. broken into separate fields. This is the first step in the " 2266"geocoding process to get all addresses into normalized postal form. No other " 2267"data is required aside from what is packaged with the geocoder." 2268msgstr "" 2269"文字列で住所が与えられると、道路後置辞、前置辞、正規化された種別、番地、スト" 2270"リート名等をフィールドに分けて持つ<varname>norm_addy</varname>複合型を返しま" 2271"す。全ての住所を正規化した郵便形式にするジオコーディング処理の第一段階です。" 2272"ジオコーダに同梱されるもの以外で必要な者はありません。" 2273 2274#. Tag: para 2275#: extras_tigergeocoder.xml:677 2276#, no-c-format 2277msgid "" 2278"This function just uses the various direction/state/suffix lookup tables " 2279"preloaded with the tiger_geocoder and located in the <varname>tiger</" 2280"varname> schema, so it doesn't need you to download tiger census data or any " 2281"other additional data to make use of it. You may find the need to add more " 2282"abbreviations or alternative namings to the various lookup tables in the " 2283"<varname>tiger</varname> schema." 2284msgstr "" 2285"tiger_geocoderによって前もってロードされ、<varname>tiger</varname>スキーマに" 2286"格納される、様々な方角/州/後置辞のルックアップテーブルを使います。よって、" 2287"Tigerデータをダウンロードしたり、追加データをする必要はありません。" 2288"<varname>tiger</varname>スキーマ内のルックアップテーブルに略語や別名の追加が" 2289"必要になることがあります。" 2290 2291#. Tag: para 2292#: extras_tigergeocoder.xml:679 extras_tigergeocoder.xml:765 2293#, no-c-format 2294msgid "" 2295"It uses various control lookup tables located in <varname>tiger</varname> " 2296"schema to normalize the input address." 2297msgstr "" 2298"<varname>tiger</varname>スキーマ内に、入力アドレスを正規化するための、多様な" 2299"制御ルックアップテーブルを使います。" 2300 2301#. Tag: para 2302#: extras_tigergeocoder.xml:680 extras_tigergeocoder.xml:766 2303#, no-c-format 2304msgid "" 2305"Fields in the <varname>norm_addy</varname> type object returned by this " 2306"function in this order where () indicates a field required by the geocoder, " 2307"[] indicates an optional field:" 2308msgstr "" 2309"この関数が返す<varname>norm_addy</varname>型オブジェクトのフィールドは、次に" 2310"示す順序です。()はジオコーダの必須フィールド、[]は任意フィールドです。" 2311 2312#. Tag: para 2313#: extras_tigergeocoder.xml:681 2314#, fuzzy, no-c-format 2315msgid "" 2316"(address) [predirAbbrev] (streetName) [streetTypeAbbrev] [postdirAbbrev] " 2317"[internal] [location] [stateAbbrev] [zip] [parsed] [zip4] " 2318"[address_alphanumeric]" 2319msgstr "" 2320"(address) [predirAbbrev] (streetName) [streetTypeAbbrev] [postdirAbbrev] " 2321"[internal] [location] [stateAbbrev] [zip]" 2322 2323#. Tag: para 2324#: extras_tigergeocoder.xml:682 extras_tigergeocoder.xml:774 2325#, no-c-format 2326msgid "" 2327"Enhanced: 2.4.0 norm_addy object includes additional fields zip4 and " 2328"address_alphanumeric." 2329msgstr "" 2330 2331#. Tag: para 2332#: extras_tigergeocoder.xml:685 extras_tigergeocoder.xml:777 2333#, no-c-format 2334msgid "<varname>address</varname> is an integer: The street number" 2335msgstr "<varname>address</varname> 整数: 番地" 2336 2337#. Tag: para 2338#: extras_tigergeocoder.xml:688 extras_tigergeocoder.xml:780 2339#, no-c-format 2340msgid "" 2341"<varname>predirAbbrev</varname> is varchar: Directional prefix of road such " 2342"as N, S, E, W etc. These are controlled using the <varname>direction_lookup</" 2343"varname> table." 2344msgstr "" 2345"<varname>predirAbbrev</varname> varchar型: N, S, E, W等といった道路の方向前置" 2346"辞。<varname>direction_lookup</varname>テーブルに制御されます。" 2347 2348#. Tag: para 2349#: extras_tigergeocoder.xml:691 extras_tigergeocoder.xml:783 2350#, no-c-format 2351msgid "<varname>streetName</varname> varchar" 2352msgstr "<varname>streetName</varname> varchar型" 2353 2354#. Tag: para 2355#: extras_tigergeocoder.xml:694 extras_tigergeocoder.xml:786 2356#, no-c-format 2357msgid "" 2358"<varname>streetTypeAbbrev</varname> varchar abbreviated version of street " 2359"type: e.g. St, Ave, Cir. These are controlled using the " 2360"<varname>street_type_lookup</varname> table." 2361msgstr "" 2362"<varname>streetTypeAbbrev</varname> varchar型 ストリート種別の短縮名: St, " 2363"Ave, Cir等。<varname>street_type_lookup</varname>テーブルに制御されます。" 2364 2365#. Tag: para 2366#: extras_tigergeocoder.xml:697 extras_tigergeocoder.xml:789 2367#, no-c-format 2368msgid "" 2369"<varname>postdirAbbrev</varname> varchar abbreviated directional suffice of " 2370"road N, S, E, W etc. These are controlled using the " 2371"<varname>direction_lookup</varname> table." 2372msgstr "" 2373"<varname>postdirAbbrev</varname> varchar型 N, S, E, W等の道路名の方向後置辞。" 2374"<varname>direction_lookup</varname>テーブルに制御されます。" 2375 2376#. Tag: para 2377#: extras_tigergeocoder.xml:700 extras_tigergeocoder.xml:792 2378#, no-c-format 2379msgid "" 2380"<varname>internal</varname> varchar internal address such as an apartment or " 2381"suite number." 2382msgstr "<varname>internal</varname> varchar型 部屋番号といった内部住所。" 2383 2384#. Tag: para 2385#: extras_tigergeocoder.xml:703 extras_tigergeocoder.xml:795 2386#, no-c-format 2387msgid "" 2388"<varname>location</varname> varchar usually a city or governing province." 2389msgstr "<varname>location</varname> varchar型 通常は市名や県名です。" 2390 2391#. Tag: para 2392#: extras_tigergeocoder.xml:706 extras_tigergeocoder.xml:798 2393#, no-c-format 2394msgid "" 2395"<varname>stateAbbrev</varname> varchar two character US State. e.g MA, NY, " 2396"MI. These are controlled by the <varname>state_lookup</varname> table." 2397msgstr "" 2398"<varname>stateAbbrev</varname> varchar型 MA, NY, MI等のような米国の州名の2文" 2399"字表示です。<varname>state_lookup</varname>テーブルに制御されます。" 2400 2401#. Tag: para 2402#: extras_tigergeocoder.xml:709 extras_tigergeocoder.xml:801 2403#, no-c-format 2404msgid "<varname>zip</varname> varchar 5-digit zipcode. e.g. 02109." 2405msgstr "<varname>zip</varname> varchar型 02109等の5桁の数字です。" 2406 2407#. Tag: para 2408#: extras_tigergeocoder.xml:712 extras_tigergeocoder.xml:804 2409#, no-c-format 2410msgid "" 2411"<varname>parsed</varname> boolean - denotes if addess was formed from " 2412"normalize process. The normalize_address function sets this to true before " 2413"returning the address." 2414msgstr "" 2415"<varname>parsed</varname> 真偽型 - 住所が正規化処理で整形されたかを示します。" 2416"normalize_addressは、住所を返す前にこれをTRUEにします。" 2417 2418#. Tag: para 2419#: extras_tigergeocoder.xml:715 extras_tigergeocoder.xml:807 2420#, fuzzy, no-c-format 2421msgid "" 2422"<varname>zip4</varname> last 4 digits of a 9 digit zip code. Availability: " 2423"PostGIS 2.4.0." 2424msgstr "<varname>zip</varname> varchar型 02109等の5桁の数字です。" 2425 2426#. Tag: para 2427#: extras_tigergeocoder.xml:718 extras_tigergeocoder.xml:810 2428#, no-c-format 2429msgid "" 2430"<varname>address_alphanumeric</varname> Full street number even if it has " 2431"alpha characters like 17R. Parsing of this is better using <xref linkend=" 2432"\"Pagc_Normalize_Address\"/> function. Availability: PostGIS 2.4.0." 2433msgstr "" 2434 2435#. Tag: para 2436#: extras_tigergeocoder.xml:727 2437#, no-c-format 2438msgid "" 2439"Output select fields. Use <xref linkend=\"Pprint_Addy\"/> if you want a " 2440"pretty textual output." 2441msgstr "" 2442"フィールドを選択して出力します。きれいな文字列を求める場合には、<xref " 2443"linkend=\"Pprint_Addy\"/>を使います。" 2444 2445#. Tag: programlisting 2446#: extras_tigergeocoder.xml:728 2447#, no-c-format 2448msgid "" 2449"SELECT address As orig, (g.na).streetname, (g.na).streettypeabbrev\n" 2450" FROM (SELECT address, normalize_address(address) As na\n" 2451" FROM addresses_to_geocode) As g;\n" 2452"\n" 2453" orig | streetname | " 2454"streettypeabbrev\n" 2455"-----------------------------------------------------+---------------" 2456"+------------------\n" 2457" 28 Capen Street, Medford, MA | Capen | St\n" 2458" 124 Mount Auburn St, Cambridge, Massachusetts 02138 | Mount Auburn | St\n" 2459" 950 Main Street, Worcester, MA 01610 | Main | St\n" 2460" 529 Main Street, Boston MA, 02129 | Main | St\n" 2461" 77 Massachusetts Avenue, Cambridge, MA 02139 | Massachusetts | Ave\n" 2462" 25 Wizard of Oz, Walaford, KS 99912323 | Wizard of Oz |" 2463msgstr "" 2464"SELECT address As orig, (g.na).streetname, (g.na).streettypeabbrev\n" 2465" FROM (SELECT address, normalize_address(address) As na\n" 2466" FROM addresses_to_geocode) As g;\n" 2467"\n" 2468" orig | streetname | " 2469"streettypeabbrev\n" 2470"-----------------------------------------------------+---------------" 2471"+------------------\n" 2472" 28 Capen Street, Medford, MA | Capen | St\n" 2473" 124 Mount Auburn St, Cambridge, Massachusetts 02138 | Mount Auburn | St\n" 2474" 950 Main Street, Worcester, MA 01610 | Main | St\n" 2475" 529 Main Street, Boston MA, 02129 | Main | St\n" 2476" 77 Massachusetts Avenue, Cambridge, MA 02139 | Massachusetts | Ave\n" 2477" 25 Wizard of Oz, Walaford, KS 99912323 | Wizard of Oz |" 2478 2479#. Tag: para 2480#: extras_tigergeocoder.xml:737 2481#, no-c-format 2482msgid ", <xref linkend=\"Pprint_Addy\"/>" 2483msgstr ", <xref linkend=\"Pprint_Addy\"/>" 2484 2485#. Tag: refname 2486#: extras_tigergeocoder.xml:743 2487#, no-c-format 2488msgid "Pagc_Normalize_Address" 2489msgstr "" 2490"Pagc_Normalize_Address文字列のストリート住所を与えると、道路後置辞、前置辞、" 2491"標準タイプ、番地、ストリート名等を複数フィールドに分解して持つ" 2492"<varname>norm_addy</varname>複合型を返します。この関数は、tiger_geocoder同梱" 2493"のルックアップテーブルだけを使います (Tigerデータは不要です)。住所標準化エク" 2494"ステンションが必要です。" 2495 2496#. Tag: refpurpose 2497#: extras_tigergeocoder.xml:745 2498#, no-c-format 2499msgid "" 2500"Given a textual street address, returns a composite <varname>norm_addy</" 2501"varname> type that has road suffix, prefix and type standardized, street, " 2502"streetname etc. broken into separate fields. This function will work with " 2503"just the lookup data packaged with the tiger_geocoder (no need for tiger " 2504"census data). Requires address_standardizer extension." 2505msgstr "" 2506"文字列のストリート住所を与えると、道路後置辞、前置辞、標準タイプ、番地、スト" 2507"リート名等を複数フィールドに分解して持つ<varname>norm_addy</varname>複合型を" 2508"返します。この関数は、tiger_geocoder同梱のルックアップテーブルだけを使います " 2509"(Tigerデータは不要です)。住所標準化エクステンションが必要です。" 2510 2511#. Tag: funcprototype 2512#: extras_tigergeocoder.xml:751 2513#, no-c-format 2514msgid "" 2515"<funcdef>norm_addy <function>pagc_normalize_address</function></funcdef> " 2516"<paramdef><type>varchar </type> <parameter>in_address</parameter></paramdef>" 2517msgstr "" 2518"<funcdef>norm_addy <function>pagc_normalize_address</function></funcdef> " 2519"<paramdef><type>varchar </type> <parameter>in_address</parameter></paramdef>" 2520 2521#. Tag: para 2522#: extras_tigergeocoder.xml:763 2523#, no-c-format 2524msgid "" 2525"This function just uses the various pagc_* lookup tables preloaded with the " 2526"tiger_geocoder and located in the <varname>tiger</varname> schema, so it " 2527"doesn't need you to download tiger census data or any other additional data " 2528"to make use of it. You may find the need to add more abbreviations or " 2529"alternative namings to the various lookup tables in the <varname>tiger</" 2530"varname> schema." 2531msgstr "" 2532"この関数は、Tigerジオコーダとともにロードされ、<varname>tiger</varname>スキー" 2533"マに置かれる、種々のpagc_+ルックアップテーブルだけを使うので、Tigerデータや他" 2534"のデータをダウンロードする必要はありません。略語や別名を<varname>tiger</" 2535"varname>スキーマのルックアップテーブルに追加しなければならない場合もありま" 2536"す。" 2537 2538#. Tag: para 2539#: extras_tigergeocoder.xml:767 2540#, no-c-format 2541msgid "" 2542"There are slight variations in casing and formatting over the <xref linkend=" 2543"\"Normalize_Address\"/>." 2544msgstr "" 2545"処理と書式について<xref linkend=\"Normalize_Address\"/>と若干の違いがありま" 2546"す。" 2547 2548#. Tag: para 2549#: extras_tigergeocoder.xml:769 2550#, no-c-format 2551msgid "&address_standardizer_required;" 2552msgstr "&address_standardizer_required;" 2553 2554#. Tag: para 2555#: extras_tigergeocoder.xml:770 2556#, no-c-format 2557msgid "" 2558"(address) [predirAbbrev] (streetName) [streetTypeAbbrev] [postdirAbbrev] " 2559"[internal] [location] [stateAbbrev] [zip]" 2560msgstr "" 2561"(address) [predirAbbrev] (streetName) [streetTypeAbbrev] [postdirAbbrev] " 2562"[internal] [location] [stateAbbrev] [zip]" 2563 2564#. Tag: para 2565#: extras_tigergeocoder.xml:771 2566#, no-c-format 2567msgid "" 2568"The native standardaddr of address_standardizer extension is at this time a " 2569"bit richer than norm_addy since its designed to support international " 2570"addresses (including country). standardaddr equivalent fields are:" 2571msgstr "" 2572"住所標準化エクステンションのstandardaddrは、他国の住所への対応 (countryも含" 2573"む)があるため、norm_addyより若干フィールドが多くなります。standardaddrの、" 2574"norm_addyと等価なフィールドは次の通りです。" 2575 2576#. Tag: para 2577#: extras_tigergeocoder.xml:772 2578#, no-c-format 2579msgid "house_num,predir, name, suftype, sufdir, unit, city, state, postcode" 2580msgstr "house_num,predir, name, suftype, sufdir, unit, city, state, postcode" 2581 2582#. Tag: para 2583#: extras_tigergeocoder.xml:818 2584#, no-c-format 2585msgid "Single call example" 2586msgstr "単一呼び出しの例を示します。" 2587 2588#. Tag: programlisting 2589#: extras_tigergeocoder.xml:819 2590#, no-c-format 2591msgid "" 2592"SELECT addy.*\n" 2593"FROM pagc_normalize_address('9000 E ROO ST STE 999, Springfield, CO') AS " 2594"addy;\n" 2595"\n" 2596"\n" 2597" address | predirabbrev | streetname | streettypeabbrev | postdirabbrev | " 2598"internal | location | stateabbrev | zip | parsed\n" 2599"---------+--------------+------------+------------------+---------------" 2600"+-----------+-------------+-------------+-----+--------\n" 2601" 9000 | E | ROO | ST | | " 2602"SUITE 999 | SPRINGFIELD | CO | | t" 2603msgstr "" 2604"SELECT addy.*\n" 2605"FROM pagc_normalize_address('9000 E ROO ST STE 999, Springfield, CO') AS " 2606"addy;\n" 2607"\n" 2608"\n" 2609" address | predirabbrev | streetname | streettypeabbrev | postdirabbrev | " 2610"internal | location | stateabbrev | zip | parsed\n" 2611"---------+--------------+------------+------------------+---------------" 2612"+-----------+-------------+-------------+-----+--------\n" 2613" 9000 | E | ROO | ST | | " 2614"SUITE 999 | SPRINGFIELD | CO | | t" 2615 2616#. Tag: para 2617#: extras_tigergeocoder.xml:821 2618#, no-c-format 2619msgid "" 2620"Batch call. There are currently speed issues with the way " 2621"postgis_tiger_geocoder wraps the address_standardizer. These will hopefully " 2622"be resolved in later editions. To work around them, if you need speed for " 2623"batch geocoding to call generate a normaddy in batch mode, you are " 2624"encouraged to directly call the address_standardizer standardize_address " 2625"function as shown below which is similar exercise to what we did in <xref " 2626"linkend=\"Normalize_Address\"/> that uses data created in <xref linkend=" 2627"\"Geocode\"/>." 2628msgstr "" 2629"バッチ呼び出しの例です。現在は、postgis_tiger_geocoderはaddress_standardizer" 2630"を使用しているため、速度の問題があります。うまくいけば、今後解決されることで" 2631"しょう。\n" 2632"normaddyへのジオコーディングのバッチ処理で速度が必要な場合には、住所標準化エ" 2633"クステンションのstandaridze_address関数を直接呼ぶことで回避できます。<xref " 2634"linkend=\"Geocode\"/>で生成されたデータを使う<xref linkend=" 2635"\"Normalize_Address\"/>で行っていることと似ています。例を次に示します。" 2636 2637#. Tag: programlisting 2638#: extras_tigergeocoder.xml:825 2639#, no-c-format 2640msgid "" 2641"WITH g AS (SELECT address, ROW((sa).house_num, (sa).predir, (sa).name\n" 2642" , (sa).suftype, (sa).sufdir, (sa).unit , (sa).city, (sa).state, (sa)." 2643"postcode, true)::norm_addy As na\n" 2644" FROM (SELECT address, standardize_address('tiger.pagc_lex'\n" 2645" , 'tiger.pagc_gaz'\n" 2646" , 'tiger.pagc_rules', address) As sa\n" 2647" FROM addresses_to_geocode) As g)\n" 2648"SELECT address As orig, (g.na).streetname, (g.na).streettypeabbrev\n" 2649" FROM g;\n" 2650"\n" 2651" orig | streetname | " 2652"streettypeabbrev\n" 2653"-----------------------------------------------------+---------------" 2654"+------------------\n" 2655" 529 Main Street, Boston MA, 02129 | MAIN | ST\n" 2656" 77 Massachusetts Avenue, Cambridge, MA 02139 | MASSACHUSETTS | AVE\n" 2657" 25 Wizard of Oz, Walaford, KS 99912323 | WIZARD OF |\n" 2658" 26 Capen Street, Medford, MA | CAPEN | ST\n" 2659" 124 Mount Auburn St, Cambridge, Massachusetts 02138 | MOUNT AUBURN | ST\n" 2660" 950 Main Street, Worcester, MA 01610 | MAIN | ST" 2661msgstr "" 2662"WITH g AS (SELECT address, ROW((sa).house_num, (sa).predir, (sa).name\n" 2663" , (sa).suftype, (sa).sufdir, (sa).unit , (sa).city, (sa).state, (sa)." 2664"postcode, true)::norm_addy As na\n" 2665" FROM (SELECT address, standardize_address('tiger.pagc_lex'\n" 2666" , 'tiger.pagc_gaz'\n" 2667" , 'tiger.pagc_rules', address) As sa\n" 2668" FROM addresses_to_geocode) As g)\n" 2669"SELECT address As orig, (g.na).streetname, (g.na).streettypeabbrev\n" 2670" FROM g;\n" 2671"\n" 2672" orig | streetname | " 2673"streettypeabbrev\n" 2674"-----------------------------------------------------+---------------" 2675"+------------------\n" 2676" 529 Main Street, Boston MA, 02129 | MAIN | ST\n" 2677" 77 Massachusetts Avenue, Cambridge, MA 02139 | MASSACHUSETTS | AVE\n" 2678" 25 Wizard of Oz, Walaford, KS 99912323 | WIZARD OF |\n" 2679" 26 Capen Street, Medford, MA | CAPEN | ST\n" 2680" 124 Mount Auburn St, Cambridge, Massachusetts 02138 | MOUNT AUBURN | ST\n" 2681" 950 Main Street, Worcester, MA 01610 | MAIN | ST" 2682 2683#. Tag: para 2684#: extras_tigergeocoder.xml:830 2685#, no-c-format 2686msgid ", <xref linkend=\"Geocode\"/>" 2687msgstr ", <xref linkend=\"Geocode\"/>" 2688 2689#. Tag: refname 2690#: extras_tigergeocoder.xml:836 2691#, no-c-format 2692msgid "Pprint_Addy" 2693msgstr "Pprint_Addy" 2694 2695#. Tag: refpurpose 2696#: extras_tigergeocoder.xml:838 2697#, no-c-format 2698msgid "" 2699"Given a <varname>norm_addy</varname> composite type object, returns a pretty " 2700"print representation of it. Usually used in conjunction with " 2701"normalize_address." 2702msgstr "" 2703"<varname>norm_addy</varname>複合型オブジェクトを与えると、印刷表現を返しま" 2704"す。通常はnormalize_addressと併用します。" 2705 2706#. Tag: funcprototype 2707#: extras_tigergeocoder.xml:843 2708#, no-c-format 2709msgid "" 2710"<funcdef>varchar <function>pprint_addy</function></funcdef> " 2711"<paramdef><type>norm_addy </type> <parameter>in_addy</parameter></paramdef>" 2712msgstr "" 2713"<funcdef>varchar <function>pprint_addy</function></funcdef> " 2714"<paramdef><type>norm_addy </type> <parameter>in_addy</parameter></paramdef>" 2715 2716#. Tag: para 2717#: extras_tigergeocoder.xml:853 2718#, no-c-format 2719msgid "" 2720"Given a <varname>norm_addy</varname> composite type object, returns a pretty " 2721"print representation of it. No other data is required aside from what is " 2722"packaged with the geocoder." 2723msgstr "" 2724"<varname>norm_addy</varname>複合型オブジェクトを与えると、印刷表現を返しま" 2725"す。Tigerジオコーダ同梱のデータ以外は不要です。" 2726 2727#. Tag: para 2728#: extras_tigergeocoder.xml:854 2729#, no-c-format 2730msgid "Usually used in conjunction with <xref linkend=\"Normalize_Address\"/>." 2731msgstr "通常は<xref linkend=\"Normalize_Address\"/>と併用します。" 2732 2733#. Tag: para 2734#: extras_tigergeocoder.xml:862 2735#, no-c-format 2736msgid "Pretty print a single address" 2737msgstr "単一住所の印刷表現" 2738 2739#. Tag: programlisting 2740#: extras_tigergeocoder.xml:863 2741#, no-c-format 2742msgid "" 2743"SELECT pprint_addy(normalize_address('202 East Fremont Street, Las Vegas, " 2744"Nevada 89101')) As pretty_address;\n" 2745" pretty_address\n" 2746"---------------------------------------\n" 2747" 202 E Fremont St, Las Vegas, NV 89101" 2748msgstr "" 2749"SELECT pprint_addy(normalize_address('202 East Fremont Street, Las Vegas, " 2750"Nevada 89101')) As pretty_address;\n" 2751" pretty_address\n" 2752"---------------------------------------\n" 2753" 202 E Fremont St, Las Vegas, NV 89101" 2754 2755#. Tag: para 2756#: extras_tigergeocoder.xml:865 2757#, no-c-format 2758msgid "Pretty print address a table of addresses" 2759msgstr "住所テーブルの印刷表現" 2760 2761#. Tag: programlisting 2762#: extras_tigergeocoder.xml:866 2763#, no-c-format 2764msgid "" 2765"SELECT address As orig, pprint_addy(normalize_address(address)) As " 2766"pretty_address\n" 2767" FROM addresses_to_geocode;\n" 2768"\n" 2769" orig | " 2770"pretty_address\n" 2771"-----------------------------------------------------" 2772"+-------------------------------------------\n" 2773" 529 Main Street, Boston MA, 02129 | 529 Main St, Boston " 2774"MA, 02129\n" 2775" 77 Massachusetts Avenue, Cambridge, MA 02139 | 77 Massachusetts Ave, " 2776"Cambridge, MA 02139\n" 2777" 28 Capen Street, Medford, MA | 28 Capen St, Medford, " 2778"MA\n" 2779" 124 Mount Auburn St, Cambridge, Massachusetts 02138 | 124 Mount Auburn St, " 2780"Cambridge, MA 02138\n" 2781" 950 Main Street, Worcester, MA 01610 | 950 Main St, " 2782"Worcester, MA 01610" 2783msgstr "" 2784"SELECT address As orig, pprint_addy(normalize_address(address)) As " 2785"pretty_address\n" 2786" FROM addresses_to_geocode;\n" 2787"\n" 2788" orig | " 2789"pretty_address\n" 2790"-----------------------------------------------------" 2791"+-------------------------------------------\n" 2792" 529 Main Street, Boston MA, 02129 | 529 Main St, Boston " 2793"MA, 02129\n" 2794" 77 Massachusetts Avenue, Cambridge, MA 02139 | 77 Massachusetts Ave, " 2795"Cambridge, MA 02139\n" 2796" 28 Capen Street, Medford, MA | 28 Capen St, Medford, " 2797"MA\n" 2798" 124 Mount Auburn St, Cambridge, Massachusetts 02138 | 124 Mount Auburn St, " 2799"Cambridge, MA 02138\n" 2800" 950 Main Street, Worcester, MA 01610 | 950 Main St, " 2801"Worcester, MA 01610" 2802 2803#. Tag: refname 2804#: extras_tigergeocoder.xml:879 2805#, no-c-format 2806msgid "Reverse_Geocode" 2807msgstr "Reverse_Geocode" 2808 2809#. Tag: refpurpose 2810#: extras_tigergeocoder.xml:881 2811#, no-c-format 2812msgid "" 2813"Takes a geometry point in a known spatial ref sys and returns a record " 2814"containing an array of theoretically possible addresses and an array of " 2815"cross streets. If include_strnum_range = true, includes the street range in " 2816"the cross streets." 2817msgstr "" 2818"登録されている空間参照系に基づくポイントジオメトリを引数に取り、理論的に可能" 2819"性のある住所の配列と交差するストリートの配列を一つのレコードで返します。" 2820"include_strnum_range = trueの場合には、交差するストリートに番地範囲を追加しま" 2821"す。" 2822 2823#. Tag: funcprototype 2824#: extras_tigergeocoder.xml:886 2825#, no-c-format 2826msgid "" 2827"<funcdef>record <function>Reverse_Geocode</function></funcdef> " 2828"<paramdef><type>geometry </type> <parameter>pt</parameter></paramdef> " 2829"<paramdef choice=\"opt\"><type>boolean </type> " 2830"<parameter>include_strnum_range=false</parameter></paramdef> " 2831"<paramdef><type>geometry[] </type> <parameter>OUT intpt</parameter></" 2832"paramdef> <paramdef><type>norm_addy[] </type> <parameter>OUT addy</" 2833"parameter></paramdef> <paramdef><type>varchar[] </type> <parameter>OUT " 2834"street</parameter></paramdef>" 2835msgstr "" 2836"<funcdef>record <function>Reverse_Geocode</function></funcdef> " 2837"<paramdef><type>geometry </type> <parameter>pt</parameter></paramdef> " 2838"<paramdef choice=\"opt\"><type>boolean </type> " 2839"<parameter>include_strnum_range=false</parameter></paramdef> " 2840"<paramdef><type>geometry[] </type> <parameter>OUT intpt</parameter></" 2841"paramdef> <paramdef><type>norm_addy[] </type> <parameter>OUT addy</" 2842"parameter></paramdef> <paramdef><type>varchar[] </type> <parameter>OUT " 2843"street</parameter></paramdef>" 2844 2845#. Tag: para 2846#: extras_tigergeocoder.xml:900 2847#, no-c-format 2848msgid "" 2849"Takes a geometry point in a known spatial ref and returns a record " 2850"containing an array of theoretically possible addresses and an array of " 2851"cross streets. If include_strnum_range = true, includes the street range in " 2852"the cross streets. include_strnum_range defaults to false if not passed in. " 2853"Addresses are sorted according to which road a point is closest to so first " 2854"address is most likely the right one." 2855msgstr "" 2856"登録されている空間参照系に基づくポイントジオメトリを引数に取り、理論的に可能" 2857"性のある住所の配列と交差するストリートの配列を一つのレコードで返します。" 2858"include_strnum_range = trueの場合には、交差するストリートに番地範囲を追加しま" 2859"す。include_strnum_rangeは、していない場合のデフォルトはFALSEです。住所は、ポ" 2860"イントから近い順の道路でソートされるので、最初の要素が最も正解に近くなりま" 2861"す。" 2862 2863#. Tag: para 2864#: extras_tigergeocoder.xml:903 2865#, no-c-format 2866msgid "" 2867"Why do we say theoretical instead of actual addresses. The Tiger data " 2868"doesn't have real addresses, but just street ranges. As such the theoretical " 2869"address is an interpolated address based on the street ranges. Like for " 2870"example interpolating one of my addresses returns a 26 Court St. and 26 " 2871"Court Sq., though there is no such place as 26 Court Sq. This is because a " 2872"point may be at a corner of 2 streets and thus the logic interpolates along " 2873"both streets. The logic also assumes addresses are equally spaced along a " 2874"street, which of course is wrong since you can have a municipal building " 2875"taking up a good chunk of the street range and the rest of the buildings are " 2876"clustered at the end." 2877msgstr "" 2878"実際の住所ではなく理論的な住所と書いているのには理由があります。Tigerデータは" 2879"本当の住所ではなく、番地の範囲を持っています。そのため、理論的な住所は番地範" 2880"囲に基づいて補間したものです。補間する場合には、たとえば、26 Court Sq.が存在" 2881"しないにもかかわらず、26 Court St. と 26 Court Sq.が返る、といったことがあり" 2882"ます。これは、ポイントが二つのストリートの角にあるのが原因で、両方のストリー" 2883"トに沿って補間を行うためです。住所はストリートに沿って等間隔になっていると仮" 2884"定しています。非常に多くの番地範囲を取ってしまっている自治体の建物があり、他" 2885"の建物がストリートの終わりにかたまっているため、ストリートの方向が悪いです。" 2886 2887#. Tag: para 2888#: extras_tigergeocoder.xml:908 2889#, no-c-format 2890msgid "" 2891"Note: Hmm this function relies on Tiger data. If you have not loaded data " 2892"covering the region of this point, then hmm you will get a record filled " 2893"with NULLS." 2894msgstr "" 2895"ご注意: この関数はTigerデータに依存しています。指定した点を含む領域のデータが" 2896"無い場合には、NULLで満たされた一つのレコードが返されます。" 2897 2898#. Tag: para 2899#: extras_tigergeocoder.xml:909 2900#, no-c-format 2901msgid "Returned elements of the record are as follows:" 2902msgstr "返されるレコードの要素は次の通りです。" 2903 2904#. Tag: para 2905#: extras_tigergeocoder.xml:912 2906#, no-c-format 2907msgid "" 2908"<varname>intpt</varname> is an array of points: These are the center line " 2909"points on the street closest to the input point. There are as many points as " 2910"there are addresses." 2911msgstr "" 2912"<varname>intpt</varname> ポイント配列: 入力ポイントに最も近いストリートの中心" 2913"線のポイントです。住所と同じだけポイントがあります。" 2914 2915#. Tag: para 2916#: extras_tigergeocoder.xml:915 2917#, no-c-format 2918msgid "" 2919"<varname>addy</varname> is an array of norm_addy (normalized addresses): " 2920"These are an array of possible addresses that fit the input point. The first " 2921"one in the array is most likely. Generally there should be only one, except " 2922"in the case when a point is at the corner of 2 or 3 streets, or the point is " 2923"somewhere on the road and not off to the side." 2924msgstr "" 2925"<varname>addy</varname> norm_addy (正規化された住所)の配列: 入力ポイントに合" 2926"わせた、可能性のある住所の配列です。最初の要素が最も可能性が高いものです。一" 2927"般的に、一つだけになるべきですが、ポイントが二つか三つのストリートの角にあっ" 2928"たり、ポイントが道路上のどこかにあって側線から離れている場合には、数出現しま" 2929"す。" 2930 2931#. Tag: para 2932#: extras_tigergeocoder.xml:919 2933#, no-c-format 2934msgid "" 2935"<varname>street</varname> an array of varchar: These are cross streets (or " 2936"the street) (streets that intersect or are the street the point is projected " 2937"to be on)." 2938msgstr "" 2939"<varname>street</varname> varchar型の配列: 交差するストリート (ストリートがイ" 2940"ンタセクトする場合)または一つのストリート (指定したポイントが乗るストリートで" 2941"ある場合)です。" 2942 2943#. Tag: para 2944#: extras_tigergeocoder.xml:923 2945#, no-c-format 2946msgid "" 2947"Enhanced: 2.4.1 if optional zcta5 dataset is loaded, the reverse_geocode " 2948"function can resolve to state and zip even if the specific state data is not " 2949"loaded. Refer to <xref linkend=\"Loader_Generate_Nation_Script\"/> for " 2950"details on loading zcta5 data." 2951msgstr "" 2952 2953#. Tag: para 2954#: extras_tigergeocoder.xml:931 2955#, no-c-format 2956msgid "" 2957"Example of a point at the corner of two streets, but closest to one. This is " 2958"approximate location of MIT: 77 Massachusetts Ave, Cambridge, MA 02139 Note " 2959"that although we don't have 3 streets, PostgreSQL will just return null for " 2960"entries above our upper bound so safe to use. This includes street ranges" 2961msgstr "" 2962"二つの近いストリートの角となる点の例です。MIT (Massachusetts Ave, Cambridge, " 2963"MA 02139 )に近い位置です。ストリートは三つはないですが、PostgreSQLは配列の範" 2964"囲からはみ出してもNULLを返すので安全です。番地範囲を含んでいます。" 2965 2966#. Tag: programlisting 2967#: extras_tigergeocoder.xml:933 2968#, no-c-format 2969msgid "" 2970"SELECT pprint_addy(r.addy[1]) As st1, pprint_addy(r.addy[2]) As st2, " 2971"pprint_addy(r.addy[3]) As st3,\n" 2972" array_to_string(r.street, ',') As cross_streets\n" 2973" FROM reverse_geocode(ST_GeomFromText('POINT(-71.093902 " 2974"42.359446)',4269),true) As r;\n" 2975"\n" 2976" result\n" 2977" ------\n" 2978" st1 | st2 | st3 | " 2979"cross_streets\n" 2980"-------------------------------------------+-----+-----" 2981"+----------------------------------------------\n" 2982" 67 Massachusetts Ave, Cambridge, MA 02139 | | | 67 - 127 " 2983"Massachusetts Ave,32 - 88 Vassar St" 2984msgstr "" 2985"SELECT pprint_addy(r.addy[1]) As st1, pprint_addy(r.addy[2]) As st2, " 2986"pprint_addy(r.addy[3]) As st3,\n" 2987" array_to_string(r.street, ',') As cross_streets\n" 2988" FROM reverse_geocode(ST_GeomFromText('POINT(-71.093902 " 2989"42.359446)',4269),true) As r;\n" 2990"\n" 2991" 結果t\n" 2992" ------\n" 2993" st1 | st2 | st3 | " 2994"cross_streets\n" 2995"-------------------------------------------+-----+-----" 2996"+----------------------------------------------\n" 2997" 67 Massachusetts Ave, Cambridge, MA 02139 | | | 67 - 127 " 2998"Massachusetts Ave,32 - 88 Vassar St" 2999 3000#. Tag: para 3001#: extras_tigergeocoder.xml:935 3002#, no-c-format 3003msgid "" 3004"Here we choose not to include the address ranges for the cross streets and " 3005"picked a location really really close to a corner of 2 streets thus could be " 3006"known by two different addresses." 3007msgstr "" 3008"交差するストリートの番地範囲を含めないことを選択しました。また、二つの異なる" 3009"住所が分かるよう、二つのストリートの角に本当に近い位置を指定しました。" 3010 3011#. Tag: programlisting 3012#: extras_tigergeocoder.xml:937 3013#, no-c-format 3014msgid "" 3015"SELECT pprint_addy(r.addy[1]) As st1, pprint_addy(r.addy[2]) As st2,\n" 3016"pprint_addy(r.addy[3]) As st3, array_to_string(r.street, ',') As cross_str\n" 3017"FROM reverse_geocode(ST_GeomFromText('POINT(-71.06941 42.34225)',4269)) As " 3018"r;\n" 3019"\n" 3020"result\n" 3021"--------\n" 3022" st1 | st2 | st3 | " 3023"cross_str\n" 3024"---------------------------------+---------------------------------+-----" 3025"+------------------------\n" 3026" 5 Bradford St, Boston, MA 02118 | 49 Waltham St, Boston, MA 02118 | | " 3027"Waltham St" 3028msgstr "" 3029"SELECT pprint_addy(r.addy[1]) As st1, pprint_addy(r.addy[2]) As st2,\n" 3030"pprint_addy(r.addy[3]) As st3, array_to_string(r.street, ',') As cross_str\n" 3031"FROM reverse_geocode(ST_GeomFromText('POINT(-71.06941 42.34225)',4269)) As " 3032"r;\n" 3033"\n" 3034"結果\n" 3035"--------\n" 3036" st1 | st2 | st3 | " 3037"cross_str\n" 3038"---------------------------------+---------------------------------+-----" 3039"+------------------------\n" 3040" 5 Bradford St, Boston, MA 02118 | 49 Waltham St, Boston, MA 02118 | | " 3041"Waltham St" 3042 3043#. Tag: para 3044#: extras_tigergeocoder.xml:939 3045#, no-c-format 3046msgid "" 3047"For this one we reuse our geocoded example from <xref linkend=\"Geocode\"/> " 3048"and we only want the primary address and at most 2 cross streets." 3049msgstr "" 3050"<xref linkend=\"Geocode\"/>からジオコーディングの例を再利用しています。主要な" 3051"住所と、せいぜい二つの交差するストリートを求めているだけです。" 3052 3053#. Tag: programlisting 3054#: extras_tigergeocoder.xml:940 3055#, no-c-format 3056msgid "" 3057"SELECT actual_addr, lon, lat, pprint_addy((rg).addy[1]) As int_addr1,\n" 3058" (rg).street[1] As cross1, (rg).street[2] As cross2\n" 3059"FROM (SELECT address As actual_addr, lon, lat,\n" 3060" reverse_geocode( ST_SetSRID(ST_Point(lon,lat),4326) ) As rg\n" 3061" FROM addresses_to_geocode WHERE rating > -1) As foo;\n" 3062"\n" 3063" actual_addr | lon | lat " 3064"| int_addr1 | cross1 | cross2\n" 3065"-----------------------------------------------------+-----------+----------" 3066"+-------------------------------------------+-----------------+------------\n" 3067" 529 Main Street, Boston MA, 02129 | -71.07181 | 42.38359 " 3068"| 527 Main St, Boston, MA 02129 | Medford St |\n" 3069" 77 Massachusetts Avenue, Cambridge, MA 02139 | -71.09428 | 42.35988 " 3070"| 77 Massachusetts Ave, Cambridge, MA 02139 | Vassar St |\n" 3071" 26 Capen Street, Medford, MA | -71.12377 | 42.41101 " 3072"| 9 Edison Ave, Medford, MA 02155 | Capen St | Tesla Ave\n" 3073" 124 Mount Auburn St, Cambridge, Massachusetts 02138 | -71.12304 | 42.37328 " 3074"| 3 University Rd, Cambridge, MA 02138 | Mount Auburn St |\n" 3075" 950 Main Street, Worcester, MA 01610 | -71.82368 | 42.24956 " 3076"| 3 Maywood St, Worcester, MA 01603 | Main St | Maywood Pl" 3077msgstr "" 3078"SELECT actual_addr, lon, lat, pprint_addy((rg).addy[1]) As int_addr1,\n" 3079" (rg).street[1] As cross1, (rg).street[2] As cross2\n" 3080"FROM (SELECT address As actual_addr, lon, lat,\n" 3081" reverse_geocode( ST_SetSRID(ST_Point(lon,lat),4326) ) As rg\n" 3082" FROM addresses_to_geocode WHERE rating > -1) As foo;\n" 3083"\n" 3084" actual_addr | lon | lat " 3085"| int_addr1 | cross1 | cross2\n" 3086"-----------------------------------------------------+-----------+----------" 3087"+-------------------------------------------+-----------------+------------\n" 3088" 529 Main Street, Boston MA, 02129 | -71.07181 | 42.38359 " 3089"| 527 Main St, Boston, MA 02129 | Medford St |\n" 3090" 77 Massachusetts Avenue, Cambridge, MA 02139 | -71.09428 | 42.35988 " 3091"| 77 Massachusetts Ave, Cambridge, MA 02139 | Vassar St |\n" 3092" 26 Capen Street, Medford, MA | -71.12377 | 42.41101 " 3093"| 9 Edison Ave, Medford, MA 02155 | Capen St | Tesla Ave\n" 3094" 124 Mount Auburn St, Cambridge, Massachusetts 02138 | -71.12304 | 42.37328 " 3095"| 3 University Rd, Cambridge, MA 02138 | Mount Auburn St |\n" 3096" 950 Main Street, Worcester, MA 01610 | -71.82368 | 42.24956 " 3097"| 3 Maywood St, Worcester, MA 01603 | Main St | Maywood Pl" 3098 3099#. Tag: para 3100#: extras_tigergeocoder.xml:947 3101#, fuzzy, no-c-format 3102msgid "" 3103", <xref linkend=\"Geocode\"/>, <xref linkend=\"Loader_Generate_Nation_Script" 3104"\"/>" 3105msgstr ", <xref linkend=\"Missing_Indexes_Generate_Script\"/>" 3106 3107#. Tag: refname 3108#: extras_tigergeocoder.xml:953 3109#, no-c-format 3110msgid "Topology_Load_Tiger" 3111msgstr "Topology_Load_Tiger" 3112 3113#. Tag: refpurpose 3114#: extras_tigergeocoder.xml:955 3115#, no-c-format 3116msgid "" 3117"Loads a defined region of tiger data into a PostGIS Topology and " 3118"transforming the tiger data to spatial reference of the topology and " 3119"snapping to the precision tolerance of the topology." 3120msgstr "" 3121"Tigerデータの定義領域をPostGISトポロジにロードして、Tigerデータをトポロジの空" 3122"間参照系に投影変換し、トポロジの許容精度にスナップします。" 3123 3124#. Tag: funcprototype 3125#: extras_tigergeocoder.xml:961 3126#, no-c-format 3127msgid "" 3128"<funcdef>text <function>Topology_Load_Tiger</function></funcdef> " 3129"<paramdef><type>varchar </type> <parameter>topo_name</parameter></paramdef> " 3130"<paramdef><type>varchar </type> <parameter>region_type</parameter></" 3131"paramdef> <paramdef><type>varchar </type> <parameter>region_id</parameter></" 3132"paramdef>" 3133msgstr "" 3134"<funcdef>text <function>Topology_Load_Tiger</function></funcdef> " 3135"<paramdef><type>varchar </type> <parameter>topo_name</parameter></paramdef> " 3136"<paramdef><type>varchar </type> <parameter>region_type</parameter></" 3137"paramdef> <paramdef><type>varchar </type> <parameter>region_id</parameter></" 3138"paramdef>" 3139 3140#. Tag: para 3141#: extras_tigergeocoder.xml:973 3142#, no-c-format 3143msgid "" 3144"Loads a defined region of tiger data into a PostGIS Topology. The faces, " 3145"nodes and edges are transformed to the spatial reference system of the " 3146"target topology and points are snapped to the tolerance of the target " 3147"topology. The created faces, nodes, edges maintain the same ids as the " 3148"original Tiger data faces, nodes, edges so that datasets can be in the " 3149"future be more easily reconciled with tiger data. Returns summary details " 3150"about the process." 3151msgstr "" 3152"Tigerデータの定義領域をPostGISトポロジにロードします。フェイス、ノード、エッ" 3153"ジは対象トポロジの空間参照系に投影変換され、点は対象トポロジの許容精度にス" 3154"ナップされます。生成されたフェイス、ノード、エッジは、元のTigerデータのフェイ" 3155"ス、ノード、エッジの識別値を維持するので、将来、データセットをより簡単にTiger" 3156"データに一致させることができます。処理の詳細に関する要約を返します。" 3157 3158#. Tag: para 3159#: extras_tigergeocoder.xml:976 3160#, no-c-format 3161msgid "" 3162"This would be useful for example for redistricting data where you require " 3163"the newly formed polygons to follow the center lines of streets and for the " 3164"resulting polygons not to overlap." 3165msgstr "" 3166"これはデータの区域改訂に使えますが、ストリートの中心線に沿って新たに形成され" 3167"るポリゴンと重ならないポリゴンとが必要です。" 3168 3169#. Tag: para 3170#: extras_tigergeocoder.xml:978 3171#, no-c-format 3172msgid "" 3173"This function relies on Tiger data as well as the installation of the " 3174"PostGIS topology module. For more information, refer to <xref linkend=" 3175"\"Topology\"/> and <xref linkend=\"installation_configuration\"/>. If you " 3176"have not loaded data covering the region of interest, then no topology " 3177"records will be created. This function will also fail if you have not " 3178"created a topology using the topology functions." 3179msgstr "" 3180"この関数はPostGISトポロジモジュールとTigerデータに依存しています。詳細情報に" 3181"ついては、<xref linkend=\"Topology\"/>と<xref linkend=" 3182"\"installation_configuration\"/>を参照して下さい。対象領域を含むデータを持っ" 3183"ていない場合には、トポロジは作られません。トポロジ関数を使ってトポロジが生成" 3184"されない場合も失敗します。" 3185 3186#. Tag: para 3187#: extras_tigergeocoder.xml:980 3188#, no-c-format 3189msgid "" 3190"Most topology validation errors are a result of tolerance issues where after " 3191"transformation the edges points don't quite line up or overlap. To remedy " 3192"the situation you may want to increase or lower the precision if you get " 3193"topology validation failures." 3194msgstr "" 3195"ほとんどのトポロジ評価エラーは許容範囲の問題です。エッジの投影変換の後にポイ" 3196"ントが準備できなかったり、エッジからずれる場合にあたります。トポロジ評価に失" 3197"敗する状況を改善するには、精度を下げます。" 3198 3199#. Tag: para 3200#: extras_tigergeocoder.xml:982 3201#, no-c-format 3202msgid "Required arguments:" 3203msgstr "必須引数:" 3204 3205#. Tag: para 3206#: extras_tigergeocoder.xml:985 3207#, no-c-format 3208msgid "" 3209"<varname>topo_name</varname> The name of an existing PostGIS topology to " 3210"load data into." 3211msgstr "<varname>topo_name</varname> データを納めるPostGISトポロジの名前" 3212 3213#. Tag: para 3214#: extras_tigergeocoder.xml:988 3215#, no-c-format 3216msgid "" 3217"<varname>region_type</varname> The type of bounding region. Currently only " 3218"<varname>place</varname> and <varname>county</varname> are supported. Plan " 3219"is to have several more. This is the table to look into to define the region " 3220"bounds. e.g <varname>tiger.place</varname>, <varname>tiger.county</varname>" 3221msgstr "" 3222"<varname>region_type</varname> 境界種別。現在は<varname>place</varname> と" 3223"<varname>county</varname>とだけに対応しています。今後増やす予定です。これは境" 3224"界を定義するために見るテーブルです。<varname>tiger.place</varname>や" 3225"<varname>tiger.county</varname>等があたります。" 3226 3227#. Tag: para 3228#: extras_tigergeocoder.xml:991 3229#, no-c-format 3230msgid "" 3231"<varname>region_id</varname> This is what TIGER calls the geoid. It is the " 3232"unique identifier of the region in the table. For place it is the " 3233"<varname>plcidfp</varname> column in <varname>tiger.place</varname>. For " 3234"county it is the <varname>cntyidfp</varname> column in <varname>tiger." 3235"county</varname>" 3236msgstr "" 3237"<varname>region_id</varname> TIGERではgeoidと呼ばれるものです。テーブルで領域" 3238"の一意の識別子です。placeでは<varname>tiger.place</varname>テーブルの" 3239"<varname>plcidfp</varname>カラムで、郡では<varname>tiger.country</varname>" 3240"テーブルの<varname>cntyidfp</varname>カラムで保持します。" 3241 3242#. Tag: title 3243#: extras_tigergeocoder.xml:1000 3244#, no-c-format 3245msgid "Example: Boston, Massachusetts Topology" 3246msgstr "例: マサチューセッツ州ボストン市のトポロジ" 3247 3248#. Tag: para 3249#: extras_tigergeocoder.xml:1001 3250#, no-c-format 3251msgid "" 3252"Create a topology for Boston, Massachusetts in Mass State Plane Feet (2249) " 3253"with tolerance 0.25 feet and then load in Boston city tiger faces, edges, " 3254"nodes." 3255msgstr "" 3256"マサチューセッツ州ボストンのトポロジをマサチューセッツ州フィート平面 (2249)、" 3257"許容範囲0.25フィートで生成し、ボストンのTigerデータのフェイス、エッジ、ノード" 3258"をロードします。" 3259 3260#. Tag: programlisting 3261#: extras_tigergeocoder.xml:1003 3262#, no-c-format 3263msgid "" 3264"SELECT topology.CreateTopology('topo_boston', 2249, 0.25);\n" 3265"createtopology\n" 3266"--------------\n" 3267" 15\n" 3268"-- 60,902 ms ~ 1 minute on windows 7 desktop running 9.1 (with 5 states " 3269"tiger data loaded)\n" 3270"SELECT tiger.topology_load_tiger('topo_boston', 'place', '2507000');\n" 3271"-- topology_loader_tiger --\n" 3272"29722 edges holding in temporary. 11108 faces added. 1875 edges of faces " 3273"added. 20576 nodes added.\n" 3274"19962 nodes contained in a face. 0 edge start end corrected. 31597 edges " 3275"added.\n" 3276"\n" 3277"-- 41 ms --\n" 3278"SELECT topology.TopologySummary('topo_boston');\n" 3279" -- topologysummary--\n" 3280"Topology topo_boston (15), SRID 2249, precision 0.25\n" 3281"20576 nodes, 31597 edges, 11109 faces, 0 topogeoms in 0 layers\n" 3282"\n" 3283"-- 28,797 ms to validate yeh returned no errors --\n" 3284"SELECT * FROM\n" 3285" topology.ValidateTopology('topo_boston');\n" 3286"\n" 3287" error | id1 | id2\n" 3288"-------------------+----------+-----------" 3289msgstr "" 3290"SELECT topology.CreateTopology('topo_boston', 2249, 0.25);\n" 3291"createtopology\n" 3292"--------------\n" 3293" 15\n" 3294"-- Windows 7 デスクトップ PostgreSQL 9.1 (5州のTigerデータを格納)で 60,902ミ" 3295"リ秒 (約1分)\n" 3296"SELECT tiger.topology_load_tiger('topo_boston', 'place', '2507000');\n" 3297"-- topology_loader_tiger --\n" 3298"29722 edges holding in temporary. 11108 faces added. 1875 edges of faces " 3299"added. 20576 nodes added.\n" 3300"19962 nodes contained in a face. 0 edge start end corrected. 31597 edges " 3301"added.\n" 3302"\n" 3303"-- 41ミリ秒 --\n" 3304"SELECT topology.TopologySummary('topo_boston');\n" 3305" -- topologysummary--\n" 3306"Topology topo_boston (15), SRID 2249, precision 0.25\n" 3307"20576 nodes, 31597 edges, 11109 faces, 0 topogeoms in 0 layers\n" 3308"\n" 3309"-- 評価に28,797ミリ秒 エラーなしでよかった --\n" 3310"SELECT * FROM\n" 3311" topology.ValidateTopology('topo_boston');\n" 3312"\n" 3313" error | id1 | id2\n" 3314"-------------------+----------+-----------" 3315 3316#. Tag: title 3317#: extras_tigergeocoder.xml:1007 3318#, no-c-format 3319msgid "Example: Suffolk, Massachusetts Topology" 3320msgstr "例: マサチューセッツ州サフォーク郡のトポロジ" 3321 3322#. Tag: para 3323#: extras_tigergeocoder.xml:1008 3324#, no-c-format 3325msgid "" 3326"Create a topology for Suffolk, Massachusetts in Mass State Plane Meters " 3327"(26986) with tolerance 0.25 meters and then load in Suffolk county tiger " 3328"faces, edges, nodes." 3329msgstr "" 3330"マサチューセッツ州サフォークのトポロジを、マサチューセッツ州メートル平面 " 3331"(26986)、許容範囲0.25メートルで生成し、サフォークのTigerデータのフェイス、" 3332"エッジ、ノードをロードします。" 3333 3334#. Tag: programlisting 3335#: extras_tigergeocoder.xml:1010 3336#, no-c-format 3337msgid "" 3338"SELECT topology.CreateTopology('topo_suffolk', 26986, 0.25);\n" 3339"-- this took 56,275 ms ~ 1 minute on Windows 7 32-bit with 5 states of tiger " 3340"loaded\n" 3341"-- must have been warmed up after loading boston\n" 3342"SELECT tiger.topology_load_tiger('topo_suffolk', 'county', '25025');\n" 3343"-- topology_loader_tiger --\n" 3344" 36003 edges holding in temporary. 13518 faces added. 2172 edges of faces " 3345"added.\n" 3346" 24761 nodes added. 24075 nodes contained in a face. 0 edge start end " 3347"corrected. 38175 edges added.\n" 3348"-- 31 ms --\n" 3349"SELECT topology.TopologySummary('topo_suffolk');\n" 3350" -- topologysummary--\n" 3351" Topology topo_suffolk (14), SRID 26986, precision 0.25\n" 3352"24761 nodes, 38175 edges, 13519 faces, 0 topogeoms in 0 layers\n" 3353"\n" 3354"-- 33,606 ms to validate --\n" 3355"SELECT * FROM\n" 3356" topology.ValidateTopology('topo_suffolk');\n" 3357"\n" 3358" error | id1 | id2\n" 3359"-------------------+----------+-----------\n" 3360" coincident nodes | 81045651 | 81064553\n" 3361" edge crosses node | 81045651 | 85737793\n" 3362" edge crosses node | 81045651 | 85742215\n" 3363" edge crosses node | 81045651 | 620628939\n" 3364" edge crosses node | 81064553 | 85697815\n" 3365" edge crosses node | 81064553 | 85728168\n" 3366" edge crosses node | 81064553 | 85733413" 3367msgstr "" 3368"SELECT topology.CreateTopology('topo_suffolk', 26986, 0.25);\n" 3369"-- Windows 7 32ビット Tigerデータ5州 で 56,275秒 (約1分)かかりました\n" 3370"-- ボストンのロードのあとウォームアップされたに違いありません\n" 3371"SELECT tiger.topology_load_tiger('topo_suffolk', 'county', '25025');\n" 3372"-- topology_loader_tiger --\n" 3373" 36003 edges holding in temporary. 13518 faces added. 2172 edges of faces " 3374"added.\n" 3375" 24761 nodes added. 24075 nodes contained in a face. 0 edge start end " 3376"corrected. 38175 edges added.\n" 3377"-- 31ミリ秒 --\n" 3378"SELECT topology.TopologySummary('topo_suffolk');\n" 3379" -- topologysummary--\n" 3380" Topology topo_suffolk (14), SRID 26986, precision 0.25\n" 3381"24761 nodes, 38175 edges, 13519 faces, 0 topogeoms in 0 layers\n" 3382"\n" 3383"-- 評価に 33,606ミリ秒 --\n" 3384"SELECT * FROM\n" 3385" topology.ValidateTopology('topo_suffolk');\n" 3386"\n" 3387" error | id1 | id2\n" 3388"-------------------+----------+-----------\n" 3389" coincident nodes | 81045651 | 81064553\n" 3390" edge crosses node | 81045651 | 85737793\n" 3391" edge crosses node | 81045651 | 85742215\n" 3392" edge crosses node | 81045651 | 620628939\n" 3393" edge crosses node | 81064553 | 85697815\n" 3394" edge crosses node | 81064553 | 85728168\n" 3395" edge crosses node | 81064553 | 85733413" 3396 3397#. Tag: para 3398#: extras_tigergeocoder.xml:1014 3399#, no-c-format 3400msgid "" 3401", <xref linkend=\"CreateTopoGeom\"/>, <xref linkend=\"TopologySummary\"/>, " 3402"<xref linkend=\"ValidateTopology\"/>" 3403msgstr "" 3404", <xref linkend=\"CreateTopoGeom\"/>, <xref linkend=\"TopologySummary\"/>, " 3405"<xref linkend=\"ValidateTopology\"/>" 3406 3407#. Tag: refname 3408#: extras_tigergeocoder.xml:1020 3409#, no-c-format 3410msgid "Set_Geocode_Setting" 3411msgstr "Set_Geocode_Setting" 3412 3413#. Tag: refpurpose 3414#: extras_tigergeocoder.xml:1022 3415#, no-c-format 3416msgid "Sets a setting that affects behavior of geocoder functions." 3417msgstr "ジオコーダ関数の振る舞いに影響を与える設定を行います。" 3418 3419#. Tag: funcprototype 3420#: extras_tigergeocoder.xml:1027 3421#, no-c-format 3422msgid "" 3423"<funcdef>text <function>Set_Geocode_Setting</function></funcdef> " 3424"<paramdef><type>text </type> <parameter> setting_name</parameter></paramdef> " 3425"<paramdef><type>text </type> <parameter> setting_value</parameter></paramdef>" 3426msgstr "" 3427"<funcdef>text <function>Set_Geocode_Setting</function></funcdef> " 3428"<paramdef><type>text </type> <parameter> setting_name</parameter></paramdef> " 3429"<paramdef><type>text </type> <parameter> setting_value</parameter></paramdef>" 3430 3431#. Tag: para 3432#: extras_tigergeocoder.xml:1038 3433#, no-c-format 3434msgid "" 3435"Sets value of specific setting stored in <varname>tiger.geocode_settings</" 3436"varname> table. Settings allow you to toggle debugging of functions. Later " 3437"plans will be to control rating with settings. Current list of settings are " 3438"listed in <xref linkend=\"Get_Geocode_Setting\"/>." 3439msgstr "" 3440"<varname>tiger.geocode_settings</varname>テーブルに格納されている設定の値を設" 3441"定します。設定によって、関数のデバッグの切り替えができます。今後、評価値の制" 3442"御を設定から行えるようにする予定です。現在の設定リストは<xref linkend=" 3443"\"Get_Geocode_Setting\"/>にあります。" 3444 3445#. Tag: para 3446#: extras_tigergeocoder.xml:1047 3447#, no-c-format 3448msgid "" 3449"If you run <xref linkend=\"Geocode\"/> when this function is true, the " 3450"NOTICE log will output timing and queries." 3451msgstr "" 3452"この関数がTRUEを返す場合に<xref linkend=\"Geocode\"/>を実行すると、時刻とクエ" 3453"リがNOTICEログに出力されます。" 3454 3455#. Tag: programlisting 3456#: extras_tigergeocoder.xml:1048 3457#, no-c-format 3458msgid "" 3459"SELECT set_geocode_setting('debug_geocode_address', 'true') As result;\n" 3460"result\n" 3461"---------\n" 3462"true" 3463msgstr "" 3464"SELECT set_geocode_setting('debug_geocode_address', 'true') As result;\n" 3465"result\n" 3466"---------\n" 3467"true" 3468 3469#, fuzzy 3470#~ msgid ", <xref linkend=\"Loader_Generate_Nation_Script\"/>" 3471#~ msgstr ", <xref linkend=\"Missing_Indexes_Generate_Script\"/>" 3472