Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
advanced-chapter-12 CC-BY-4.0 0 0 0 0 0 0 0
appendix-appendix-2 CC-BY-4.0 0 0 0 0 0 0 0
appendix-appendix-3 CC-BY-4.0 0 0 0 0 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 0 0 0 0 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 60% 14 166 1,158 12 4 0 0
general-intro-osgeolive CC-BY-4.0 1% 53 370 2,845 53 0 0 0
general-intro-overview CC-BY-4.0 2% 39 416 3,482 39 0 0 0
Glossary index CC-BY-4.0 0 0 0 0 2 0 0
interactions-chapter-10 CC-BY-4.0 0 0 0 0 0 0 0
interactions-chapter-11 CC-BY-4.0 97% 1 38 223 0 0 0 0
interactions-chapter-9 CC-BY-4.0 0 0 0 0 0 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 1 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 89% 9 105 982 0 1 0 0

Overview

Project website workshop.pgrouting.org
Instructions for translators

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

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 1,632 16,191 111,126
Translated 92% 1,516 93% 15,096 92% 102,436
Needs editing 1% 12 1% 210 1% 1,672
Read-only 1% 30 1% 99 1% 1,273
Failing checks 1% 8 1% 103 1% 566
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 6% 104 5% 885 6% 7,018
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 1,991 changes 0 changes 24 changes 0 changes 2 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes
Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug

Quick numbers

16,191
Hosted words
1,632
Hosted strings
92%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
—
Translated
+92%
—
Contributors
—
User avatar None

Changes committed

  1. pgRouting workshop
  2. un_sdg-sdg3-health
  3. Spanish
Changes committed 4 months ago
User avatar None

Changes committed

  1. pgRouting workshop
  2. un_sdg-sdg7-energy
  3. Spanish
Changes committed 4 months ago
User avatar cvvergara

Translation completed

  1. pgRouting workshop
  2. un_sdg-sdg3-health
  3. Spanish
Translation completed 4 months 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.
4 months 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.
4 months 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.
4 months 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.
4 months 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.
4 months 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.
4 months 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.
4 months ago
Browse all changes for this language