Zen

Translation

Tag: para
The code is built into a single PostgreSQL extension library called <code>address_standardizer</code> which can be installed with <code>CREATE EXTENSION address_standardizer;</code>. In addition to the address_standardizer extension, a sample data extension called <code>address_standardizer_data_us</code> extensions is built, which contains gaz, lex, and rules tables for US data. This extensions can be installed via: <code>CREATE EXTENSION address_standardizer_data_us;</code>
523/4800 · 480

Sign in to save the translation.

English Spanish Actions
If you have lots of RAM and few developers:
 
<link xlink:href="http://www.postgresql.org/docs/current/static/runtime-config-resource.html#GUC-MAINTENANCE-WORK-MEM">maintenance_work_mem</link> - the memory size used for VACUUM, CREATE INDEX, etc.
 
Default: 16-64MB
 
Generally too low - ties up I/O, locks objects while swapping memory
 
Recommend 32MB to 1GB on production servers w/lots of RAM, but depends on the # of concurrent users. If you have lots of RAM and few developers:
 
max_parallel_workers_per_gather
 
This setting is only available for PostgreSQL 9.6+ and will only affect PostGIS 2.3+, since only PostGIS 2.3+ supports parallel queries. If set to higher than 0, then some queries such as those involving relation functions like <code>ST_Intersects</code> can use multiple processes and can run more than twice as fast when doing so. If you have a lot of processors to spare, you should change the value of this to as many processors as you have. Also make sure to bump up <code>max_worker_processes</code> to at least as high as this number.
 
Default: 0
 
Sets the maximum number of workers that can be started by a single <varname>Gather</varname> node. Parallel workers are taken from the pool of processes established by <varname>max_worker_processes</varname>. Note that the requested number of workers may not actually be available at run time. If this occurs, the plan will run with fewer workers than expected, which may be inefficient. Setting this value to 0, which is the default, disables parallel query execution.
 
PostGIS Extras
Extras de PostGIS
This chapter documents features found in the extras folder of the PostGIS source tarballs and source repository. These are not always packaged with PostGIS binary releases, but are usually PL/pgSQL based or standard shell scripts that can be run as is.
Este capítulo documenta las características encontradas en la carpeta Extras de fuente de tarballs y fuente de repositorio de PostGIS. Estos no siempre son empaquetados con las versiones binarias de PostGIS, pero son generalmente plpgsql básicos o scripts de shell estándar que pueden ser ejectuados tal cual.
&extras_address_standardizer; &extras_tigergeocoder;
 
Address Standardizer
Normalizador de Direcciones
This is a fork of the <link xlink:href="http://www.pagcgeo.org/docs/html/pagc-11.html">PAGC standardizer</link> (original code for this portion was <link xlink:href="http://sourceforge.net/p/pagc/code/360/tree/branches/sew-refactor/postgresql">PAGC PostgreSQL Address Standardizer</link>).
Esta es una bifurcación <link xlink:href="http://www.pagcgeo.org/docs/html/pagc-11.html">del estandarizador PAGC</link> (el código original para esta parte era <link xlink:href="http://sourceforge.net/p/pagc/code/360/tree/branches/sew-refactor/postgresql">el estandarizador de direcciones PAGC PostgreSQL</link>).
The address standardizer is a single line address parser that takes an input address and normalizes it based on a set of rules stored in a table and helper lex and gaz tables.
El normalizador de direcciones es un analizador de direcciones de una sola línea que toma una dirección de entrada y la normaliza basándose en un conjunto de reglas almacenadas en una tabla y en las tablas de lex y gaz
The code is built into a single PostgreSQL extension library called <code>address_standardizer</code> which can be installed with <code>CREATE EXTENSION address_standardizer;</code>. In addition to the address_standardizer extension, a sample data extension called <code>address_standardizer_data_us</code> extensions is built, which contains gaz, lex, and rules tables for US data. This extensions can be installed via: <code>CREATE EXTENSION address_standardizer_data_us;</code>
El código está construido en una única librería de extensiones postgresql llamada <code>address_standardizer</code> que puede ser instalada con <code>CREATE EXTENSION address_standardizer;</code>. A demás de la extensión address_standardizer, una extensión de datos de ejemplo llamada <code>address_standardizer_data_us</code> es construida, la cual contiene tablas de gaz, lex, y rules para datos de Estados Unidos. Estas extensiones se pueden instalar mediante <code>CREATE EXTENSION address_standardizer_data_us;</code>
The code for this extension can be found in the PostGIS <filename>extensions/address_standardizer</filename> and is currently self-contained.
El código para esta extensión se puede encontrar en PostGIS <filename>extensions/address_standardizer</filename> y es actualmente autocontenido.
For installation instructions refer to: <xref linkend="installing_pagc_address_standardizer"/>.
Para instrucciones de instalación, consulte: <xref linkend="installing_pagc_address_standardizer"/>.
How the Parser Works
Cómo funciona el analizador
The parser works from right to left looking first at the macro elements for postcode, state/province, city, and then looks micro elements to determine if we are dealing with a house number street or intersection or landmark. It currently does not look for a country code or name, but that could be introduced in the future.
El analizador trabaja de derecha a izquierda localizando primero los macro elementos para el codigo postal, estado/provincia, ciudad y a continuación los micro elementos para determinar si se esta tratando con un número de casa y calle o una interterseccion de calle o un hito. Actualmente no busca por un código o nombre de país, pero podría ser introducido en el futuro.
Country code
Código de país
Assumed to be US or CA based on: postcode as US or Canada state/province as US or Canada else US
Se supone que es de EE. UU. o CA según: código postal de estado/provincia como EE. UU. o Canadá, como EE. UU. o Canadá más EE. UU. .
Postcode/zipcode
Código postal
These are recognized using Perl compatible regular expressions. These regexs are currently in the parseaddress-api.c and are relatively simple to make changes to if needed.
Éstos se reconocen utilizando expresiones regulares compatibles con Perl. Estos regexs están actualmente en el parseaddress-api.c y es relativamente simple hacer cambios si es necesario.
State/province
Estado/provincia
These are recognized using Perl compatible regular expressions. These regexs are currently in the parseaddress-api.c but could get moved into includes in the future for easier maintenance.
Éstos son reconocidos utilizando expresiones regulares compatibles con Perl. Estos regexs están actualmente en el parseaddress-api.c pero podrían ser movidos e incluidos en el futuro para facilitar el mantenimiento.
Address Standardizer Types
Tipos de Address Standardizer
This section lists the PostgreSQL data types installed by Address Standardizer extension. Note we describe the casting behavior of these which is very important especially when designing your own functions.
Esta sección lista los tipos de datos PostgreSQL instalados por la extensión Address Standardizer. Tenga en cuenta que describimos el comportamiento de fusión de estos que es muy importante, especialmente al diseñar sus propias funciones.
A composite type that consists of the elements of an address. This is the return type for <varname>standardize_address</varname> function.
Un tipo compuesto que consiste en los elementos de una dirección. Este es el tipo de retorno para la función <varname>standardize_address </varname>.
Description
Descripción
A composite type that consists of elements of an address. This is the return type for <xref linkend="standardize_address"/> function. Some descriptions for elements are borrowed from <link xlink:href="http://www.pagcgeo.org/docs/html/pagc-12.html#ss12.1">PAGC Postal Attributes</link>.
Un tipo compuesto que consta de elementos de una dirección. Este es el tipo de retorno de la <xref linkend="standardize_address"/>función. Algunas descripciones de los elementos se han tomado de <link xlink:href="http://www.pagcgeo.org/docs/html/pagc-12.html#ss12.1">Atributos postales de PAGC.</link>

Loading…

User avatar None

String updated in the repository

  1. postgis
  2. PostGIS Manual
  3. Spanish
The code is built into a single PostgreSQL extension library called <code>address_standardizer</code> which can be installed with <code>CREATE EXTENSION address_standardizer;</code>. In addition to the address_standardizer extension, a sample data extension called <code>address_standardizer_data_us</code> extensions is built, which contains gaz, lex, and rules tables for US data. This extensions can be installed via: <code>CREATE EXTENSION address_standardizer_data_us;</code>
El código está construido en una única librería de extensiones postgresql llamada <code>address_standardizer</code> que puede ser instalada con <code>CREATE EXTENSION address_standardizer;</code>. A demás de la extensión address_standardizer, una extensión de datos de ejemplo llamada <code>address_standardizer_data_us</code> es construida, la cual contiene tablas de gaz, lex, y rules para datos de Estados Unidos. Estas extensiones se pueden instalar mediante <code>CREATE EXTENSION address_standardizer_data_us;</code>
a year ago
Browse all string changes

Things to check

Double space

Translation contains double space

Fix string

Reset

Glossary

English Spanish
No related strings found in the glossary.

String information

Source string description
Tag: para
Flags
no-c-format
String age
a year ago
Last updated
a year ago
Source string age
a year ago
Translation file
doc/po/es/postgis-manual.po, string 107