Language Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
English CC-BY-4.0 0 0 0 0 0 0 0
Spanish CC-BY-4.0 0 0 0 0 0 0 0
Please sign in to see the alerts.

Overview

Project website workshop.pgrouting.org
Instructions for translators

pgRouting workshop use sphinx markup.
Translation license Creative Commons Attribution 4.0 International
Translation process
  • Translations can be made directly.
  • Translation suggestions can be made.
  • Any authenticated user can contribute.
  • The translation uses bilingual files.
Source code repository https://github.com/pgRouting/workshop
Repository branch develop
Last remote commit Update locale: commit ce6638ad c941ea9c
github-actions[bot] authored 3 weeks ago
Last commit in Weblate Translated using Weblate (Spanish) 21afa5ff
Celia Virginia Vergara Castillo authored 5 months ago
Weblate repository https://weblate.osgeo.org/git/pgrouting-workshop/index/
File mask locale/*/LC_MESSAGES/un_sdg/sdg3-health.po
11 days ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 284 4,732 30,124
Source 142 2,366 15,062
Translated 100% 284 100% 4,732 100% 30,124
Needs editing 0% 0 0% 0 0% 0
Read-only 55% 157 51% 2,441 52% 15,957
Failing checks 0% 0 0% 0 0% 0
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 0% 0 0% 0 0% 0
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 310 changes 0 changes 8 changes 0 changes 1 change 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep

Quick numbers

4,732
Hosted words
284
Hosted strings
100%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

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

Changes committed

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

Translation completed

  1. pgRouting workshop
  2. un_sdg-sdg3-health
  3. Spanish
Translation completed 5 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.
5 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.
5 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.
5 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.
5 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.
5 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.
5 months ago
User avatar None

Changes committed

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

Translation changed

  1. pgRouting workshop
  2. un_sdg-sdg3-health
  3. Spanish
:ref:`un_sdg/appendix:**Exercise:** 20 (**Chapter:** SDG 3)`
:ref:`un_sdg/appendix:**Ejercicio:** 20 (**Capítulo:** ODS 3)`
6 months ago
Browse all component changes