Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
advanced-chapter-12 CC-BY-4.0 72% 46 568 3,871 46 1 0 0
appendix-appendix-2 CC-BY-4.0 75% 11 98 824 11 0 0 0
appendix-appendix-3 CC-BY-4.0 74% 14 217 1,533 14 0 0 0
appendix-appendix-4 CC-BY-4.0 0 0 0 0 0 0 0
basic-appendix CC-BY-4.0 0 0 0 0 0 0 0
basic-data CC-BY-4.0 74% 28 297 2,045 28 0 0 0
basic-pedestrian CC-BY-4.0 0 0 0 0 0 0 0
basic-plpgsql_function CC-BY-4.0 0 0 0 0 0 0 0
basic-sql_function CC-BY-4.0 0 0 0 0 0 0 0
basic-vehicle CC-BY-4.0 0 0 0 0 0 0 0
examples-boost_dijkstra CC-BY-4.0 0 0 0 0 0 0 0
examples-hanoslav CC-BY-4.0 0 0 0 0 0 0 0
examples-wiki_example CC-BY-4.0 0 0 0 0 0 0 0
general-intro-introduction CC-BY-4.0 70% 34 464 3,381 32 8 0 0
general-intro-osgeolive CC-BY-4.0 52% 81 564 4,359 81 4 0 0
general-intro-overview CC-BY-4.0 50% 61 676 5,846 61 1 0 0
interactions-chapter-10 CC-BY-4.0 91% 13 46 351 13 3 0 0
interactions-chapter-11 CC-BY-4.0 87% 15 378 2,300 14 0 0 0
interactions-chapter-9 CC-BY-4.0 0 0 0 0 1 0 0
un_sdg-appendix CC-BY-4.0 0 0 0 0 0 0 0
un_sdg-data CC-BY-4.0 0 0 0 0 0 0 0
un_sdg-introduction CC-BY-4.0 0 0 0 0 0 0 0
un_sdg-sdg11-cities CC-BY-4.0 0 0 0 0 0 0 0
un_sdg-sdg3-health CC-BY-4.0 0 0 0 0 0 0 0
un_sdg-sdg7-energy CC-BY-4.0 94% 9 105 982 0 0 0 0
Glossary index CC-BY-4.0 66% 9 0 0 9 4 0 0

Overview

Project website workshop.pgrouting.org
Instructions for translators

pgRouting workshop use sphinx markup.
Translation license CC-BY-4.0 advanced-chapter-12 appendix-appendix-2 appendix-appendix-3 appendix-appendix-4 basic-appendix basic-data basic-pedestrian basic-plpgsql_function basic-sql_function basic-vehicle examples-boost_dijkstra examples-hanoslav examples-wiki_example general-intro-introduction general-intro-osgeolive general-intro-overview interactions-chapter-10 interactions-chapter-11 interactions-chapter-9 un_sdg-appendix un_sdg-data un_sdg-introduction un_sdg-sdg11-cities un_sdg-sdg3-health un_sdg-sdg7-energy index
5 hours ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 3,651 36,597 251,824
Source 1,689 16,722 115,120
Translated 91% 3,330 90% 33,184 89% 226,332
Needs editing 1% 12 1% 210 1% 1,672
Read-only 47% 1,719 45% 16,821 46% 116,393
Failing checks 1% 22 1% 76 1% 705
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 8% 309 8% 3,203 9% 23,820
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 4,150 changes
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

Quick numbers

36,597
Hosted words
3,651
Hosted strings
91%
Translated
2
Contributors
and previous 30 days

Trends of last 30 days

+100%
Hosted words
—
+100%
Hosted strings
—
+91%
Translated
—
+100%
Contributors
—
Language Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
English 99% 9 0 0 9 6 0 0
Japanese 40% 196 2,318 16,802 196 10 0 0
Spanish 92% 116 1,095 8,690 104 6 0 0
User avatar cvvergara

Translation completed

  1. pgRouting workshop
  2. un_sdg-sdg3-health
  3. Spanish
Translation completed 5 hours ago
User avatar cvvergara

Translation added

  1. pgRouting workshop
  2. un_sdg-sdg3-health
  3. Spanish
Final step is to find the total population served by the hospital based on travel-time. Use the query from `Exercise 16: Generalising the served roads`_ as a subquery to get all the edges in the roads served. Note that ``s.population`` is added in line 14 which gives the population. After getting the population for each edge/road, use ``sum()`` to get the total population which is dependant on the hospital.
El último paso es encontrar la población total atendida por el hospital en función del tiempo de viaje. Utilizar la consulta del `Ejercicio 16: Generalización de las carreteras servidas`_ como subconsulta para obtener todos los bordes de las carreteras servidas. Tenga en cuenta que se agrega ``s.population`` en la línea 14, que proporciona la población. Después de obtener la población de cada borde/carretera, utilizar ``sum()`` para obtener la población total que depende del hospital.
5 hours ago
User avatar cvvergara

Translation added

  1. pgRouting workshop
  2. un_sdg-sdg3-health
  3. Spanish
Now the next step is to estimate the dependant population. Official source of population is Census conducted by the government. But for this exercise, population will be estimated from the ``area`` as well as the ``category`` of the building. This area will be stored in the nearest roads. Following steps explain this process in detail.
Ahora el siguiente paso es estimar la población dependiente. La fuente oficial de población es el censo realizado por el gobierno. Pero para este ejercicio, la población se estimará tanto a partir del ``area`` como del ``category`` del edificio. Esta zona se almacenará en las carreteras más cercanas. Los siguientes pasos explican este proceso en detalle.
5 hours ago
User avatar cvvergara

Translation added

  1. pgRouting workshop
  2. un_sdg-sdg3-health
  3. Spanish
Following figure shows the visualised output of the above query. The lines highlighted by ``red`` colour show the area from where the hospital can be reached within 10 minutes of walking at the speed of ``1 m/s``. It is evident from the output figure that some of the roads which are near to the hospital are not highlighted. For example, to roads in the north of the hospital. This is because the only one edge per road vertex was selected by the query. Next section will solve this issue by doing a small modification in the query.
La siguiente figura muestra el resultado visualizado de la consulta anterior. Las líneas resaltadas en color rojo muestran el área desde donde se puede llegar al hospital en 10 minutos caminando a una velocidad de ``1 m/s``. De la cifra de resultados se desprende claramente que algunas de las carreteras cercanas al hospital no están resaltadas. Por ejemplo, a carreteras del norte del hospital. Esto se debe a que la consulta seleccionó el único borde por vértice de la carretera. La siguiente sección resolverá este problema haciendo una pequeña modificación en la consulta.
5 hours ago
User avatar cvvergara

Translation added

  1. pgRouting workshop
  2. un_sdg-sdg3-health
  3. Spanish
First step in pre processing is to set the search path for ``Roads`` and ``Buildings`` data. `Search path` is a list of schemas helps the system determine how a particular table is to be imported. In this case, search path of roads table is set to roads and buildings schema. ``\dn`` is used to list down all the present schemas. ``SHOW search_path`` command shows the current search path. ``SET search_path`` is used to set the search path to ``roads`` and ``buildings``. Finally, ``\dt`` is used to verify if the Schema have bees changed correctly. Following code snippets show the steps as well as the outputs.
El primer paso en el procesamiento previo es establecer la ruta de búsqueda para los datos ``Roads`` y ``Buildings``. `Search path` es una lista de esquemas que ayuda al sistema a determinar cómo se importará una tabla en particular. En este caso, la ruta de búsqueda de la tabla de carreteras se establece en el esquema de carreteras y edificios. ``\dn`` se utiliza para enumerar todos los esquemas presentes. El comando ``SHOW search_path`` muestra la ruta de búsqueda actual. ``SET search_path`` se utiliza para establecer la ruta de búsqueda en ``Roads`` y ``Buildings``. Finalmente, ``\dt`` se usa para verificar si el esquema ha cambiado correctamente. Los siguientes fragmentos de código muestran los pasos y los resultados.
5 hours ago
User avatar cvvergara

Translation changed

  1. pgRouting workshop
  2. un_sdg-sdg3-health
  3. Spanish
First step is to pre-process the data obtained from :ref:`un_sdg/data:Data for Sustainable Development Goals`. This section will work the graph that is going to be used for processing. While building the graph, the data has to be inspected to determine if there is any invalid data. This is a very important step to make sure that the data is of required quality. pgRouting can also be used to do some Data Adjustments. This will be discussed in further sections.
El primer paso es preprocesar los datos obtenidos de :ref:`un_sdg/data:Datos para los Objetivos de Desarrollo Sostenible`. En esta sección se trabajará el gráfico que se va a utilizar para el procesamiento. Al construir el gráfico, los datos deben inspeccionarse para determinar si hay datos no válidos. Este es un paso muy importante para asegurarse de que los datos sean de la calidad requerida. pgRouting también se puede utilizar para realizar algunos ajustes de datos. Esto se discutirá en secciones posteriores.
5 hours ago
User avatar cvvergara

Translation changed

  1. pgRouting workshop
  2. un_sdg-sdg7-energy
  3. Spanish
First step is to pre-process the data obtained from :ref:`un_sdg/data:Data for Sustainable Development Goals`. This section will work the graph that is going to be used for processing. While building the graph, the data has to be inspected to determine if there is any invalid data. This is a very important step to make sure that the data is of required quality. pgRouting can also be used to do some Data Adjustments. This will be discussed in further sections.
El primer paso es preprocesar los datos obtenidos de :ref:`un_sdg/data:Datos para los Objetivos de Desarrollo Sostenible`. En esta sección se trabajará el gráfico que se va a utilizar para el procesamiento. Al construir el gráfico, los datos deben inspeccionarse para determinar si hay datos no válidos. Este es un paso muy importante para asegurarse de que los datos sean de la calidad requerida. pgRouting también se puede utilizar para realizar algunos ajustes de datos. Esto se discutirá en secciones posteriores.
5 hours ago
User avatar cvvergara

Translation added

  1. pgRouting workshop
  2. un_sdg-sdg3-health
  3. Spanish
`Good Health and Well Being` is the 3rd Sustainable Development Goal which aspires to ensure health and well-being for all, including a bold commitment to end the epidemics like AIDS, tuberculosis, malaria and other communicable diseases by 2030. It also aims to achieve universal health coverage, and provide access to safe and effective medicines and vaccines for all. Supporting research and development for vaccines is an essential part of this process as well as expanding access to affordable medicines. Hospitals are a very important part of a well functioning health infrastructure. An appropriate planning is required for optimal distribution of the population of an area to its hospitals. Hence, it is very important to estimate the number of dependant people living near the hospital for better planning which would ultimately help in achieving universal coverage of health services. This chapter will focus on solving one such problem.
`Buena salud y bienestar` es el tercer Objetivo de Desarrollo Sostenible que aspira garantizar la salud y el bienestar para todos, incluido un compromiso audaz para poner fin a epidemias como el SIDA, la tuberculosis, la malaria y otras enfermedades transmisibles para 2030. También pretende lograr la cobertura sanitaria universal y proporcionar acceso a medicamentos y vacunas seguros y eficaces para todos. Apoyar la investigación y el desarrollo de vacunas es una parte esencial de este proceso, así como ampliar el acceso a medicamentos asequibles. Los hospitales son una parte muy importante de una infraestructura sanitaria que funcione bien. Se requiere una planificación adecuada para la distribución óptima de la población de una zona a sus hospitales. Por lo tanto, es muy importante estimar el número de personas dependientes que viven cerca del hospital para una mejor planificación que, en última instancia, ayudaría a lograr la cobertura universal de los servicios de salud. Este capítulo se centrará en resolver uno de esos problemas.
5 hours ago
User avatar None

Resource updated

  1. pgRouting workshop
  2. basic-pedestrian
  3. Spanish
The "locale/es/LC_MESSAGES/basic/pedestrian.po" file was changed. 4 weeks ago
User avatar None

String updated in the repository

  1. pgRouting workshop
  2. basic-pedestrian
  3. Spanish
:ref:`basic/appendix:**Exercise**: 6 (**Chapter:** Pedestrian)`
:ref:`basic/appendix:**Exercise**: 6 (**Chapter:** Pedestrian)`
4 weeks ago
Browse all project changes