postgis/using_postgis_query.xml — German @ OSGeo Weblate

Translation status

109	Strings		3%	Browse Translate
2,128	Words		3%	Browse Translate

Strings status

109	All strings — 2,128 words	Browse Translate Zen
1	Approved strings — 2 words	Browse Translate Zen
4	Translated strings — 71 words	Browse Translate Zen
3	Strings waiting for review — 69 words	Browse Translate Zen
105	Unfinished strings — 2,057 words	Browse Translate Zen
105	Untranslated strings — 2,057 words	Browse Translate Zen
105	Unfinished strings without suggestions — 2,057 words	Browse Translate Zen
1	Strings with any failing checks — 48 words	Browse Translate Zen
1	Translated strings with any failing checks — 48 words	Browse Translate Zen
1	Failing check: Double space — 48 words	Browse Translate Zen
1	Failing check: XML markup — 48 words	Browse Translate Zen

Other components

Component	Translated	Unfinished	Unfinished words	Unfinished characters	Untranslated	Checks	Suggestions	Comments
reference_coverage CC-BY-3.0	0%	33	720	5,456	33	2	0	0

reference_version.xml	2%	95	775	8,980	95	1	0	0

administration.xml	2%	86	1,984	14,529	86	0	0	0

reference_srs.xml	2%	108	2,083	20,010	108	3	0	0

reference_cluster.xml	2%	67	1,517	13,248	67	1	0	0

database_tuning.xml	3%	32	541	3,875	32	0	0	0

reference_overlay.xml	3%	148	2,979	25,688	148	4	0	0

reference_sfcgal.xml	4%	184	3,478	27,719	146	7	0	0

reference_relationship.xml	4%	290	5,395	49,111	283	12	0	0

reference_bbox.xml	5%	111	1,983	18,989	111	1	0	0

Browse all components

Overview

Project website	postgis.net
Project maintainers	komzpa cvvergara strk robe
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://git.osgeo.org/gitea/postgis/postgis.git`
Repository branch	master
Last remote commit	Show obtained output on failure, in oriented_envelope test `36fcdd626` Sandro Santilli authored 22 hours ago
Last commit in Weblate	Translated reference_coverage using Weblate (French) `af45bca00` Vincent Bre authored 2 weeks ago
Weblate repository	`https://weblate.osgeo.org/git/postgis/postgis/`
File mask	`doc/po/*/using_postgis_query.xml.po`
Translation file	Download `doc/po/de/using_postgis_query.xml.po`
Last change	Aug. 23, 2022, 6:38 a.m.
Last author	Juergen E. Fischer

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		109		2,128		16,517
Approved	1%	1	1%	2	1%	15
Waiting for review	2%	3	3%	69	3%	514
Translated	3%	4	3%	71	3%	529
Needs editing	0%	0	0%	0	0%	0
Read-only	0%	0	0%	0	0%	0
Failing checks	1%	1	2%	48	2%	348
Strings with suggestions	0%	0	0%	0	0%	0
Untranslated strings	96%	105	96%	2,057	96%	15,988

Last 12 months Previous

Activity in last 12 months


May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr

Quick numbers

2,128

Hosted words

109

Hosted strings

Translated

Contributors

and previous 30 days

Trends of last 30 days

—

Hosted words

—

Hosted strings

—

Translated

—

Contributors

—

jef New translation postgis / using_postgis_query.xml — German	English Spatial relationships indicate how two geometries interact with one another. They are a fundamental capability for querying geometry. German 140 characters edited Current translation Translated Räumliche Beziehungen geben an wie zwei Geometrien miteinander interagieren. Sie sind die fundamentale Fähigkeit zum Abfragen von Geometrie. 9 months ago
jef New translation postgis / using_postgis_query.xml — German	English Determining Spatial Relationships German 33 characters edited Current translation Translated Räumliche Beziehungen feststellen 9 months ago
jef Translation changed postgis / using_postgis_query.xml — German	English The <emphasis>raison d'etre</emphasis> of spatial databases is to perform queries inside the database which would ordinarily require desktop GIS functionality. Using PostGIS effectively requires knowing what spatial functions are available, how to use them in queries, and ensuring that appropriate indexes are in place to provide good performance. German 1 character edited Current translation Translated Der Sinn von räumlichen Datenbanken liegt darin Abfragen in der Datenbank ausführen zu können, die normalerweise Desktop-GIS-Funktionionalität verlangen würden. Um PostGIS effektiv verwenden zu können muss man die verfügbaren räumlichen Funktionen kennen, wissen wie sie in Abfragen verwendet werden und sicherstellen, dass für gute Performanz die passenden Indizes vorhanden sind. 9 months ago
jef New translation postgis / using_postgis_query.xml — German	English The <emphasis>raison d'etre</emphasis> of spatial databases is to perform queries inside the database which would ordinarily require desktop GIS functionality. Using PostGIS effectively requires knowing what spatial functions are available, how to use them in queries, and ensuring that appropriate indexes are in place to provide good performance. German 383 characters edited Translated Der Sinn von räumlichen Datenbanken liegt darin Abfragen in der Datenbank ausführen zu können, die normalerweise Desktop-GIS-Funktionionalität verlangen würden. Um PostGIS effektiv verwenden zu können muss man die verfügbaren räumlichen Funktionen kennen, wissen wie sie in Abfragen verwendet werden und sicherstellen, dass für gute Performanz die passenden Indizes vorhanden sind. 9 months ago
jef New contributor postgis / using_postgis_query.xml — German	New contributor 9 months ago
None New strings to translate postgis / using_postgis_query.xml — German	18 new strings to translate appeared to the translation. a year ago
None Resource update postgis / using_postgis_query.xml — German	The "`doc/po/de/using_postgis_query.xml.po`" file was changed. a year ago
None String updated in the repository postgis / using_postgis_query.xml — German	English SELECT gid, name, ST_Area(geom) AS area FROM bc_municipality WHERE ST_NRings(geom) > 1 ORDER BY area DESC LIMIT 1; gid \| name \| area -----+--------------+------------------ 12 \| SPALLUMCHEEN \| 257374619.430216 German 0 characters edited Current translation a year ago
None String updated in the repository postgis / using_postgis_query.xml — German	English SELECT sum(ST_Length(r.geom))/1000 AS kilometers FROM bc_roads r JOIN bc_municipality m ON ST_Intersects(m.geom, r.geom WHERE r.name = 'Douglas St' AND m.name = 'VICTORIA'; kilometers ------------------ 4.89151904172838 German 0 characters edited Current translation a year ago
None String updated in the repository postgis / using_postgis_query.xml — German	English CREATE TABLE pg_roads as SELECT ST_Intersection(r.geom, m.geom) AS intersection_geom, ST_Length(r.geom) AS rd_orig_length, r.* FROM bc_roads AS r JOIN bc_municipality AS m ON ST_Intersects(r.geom, m.geom) WHERE m.name = 'PRINCE GEORGE'; German 0 characters edited Current translation a year ago

Browse all translation changes

Quick downloads

109	File in original format as translated in the repository	gettext PO file
109	All strings, converted files enriched with comments; suitable for offline translation	CSV	gettext MO	gettext PO	TBX	TMX	XLIFF 1.1 with gettext extensions	XLIFF 1.1	XLSX
105	Unfinished strings, converted files enriched with comments; suitable for offline translation	CSV	gettext MO	gettext PO	TBX	TMX	XLIFF 1.1 with gettext extensions	XLIFF 1.1	XLSX

Customize download

Search

Advanced query builder

Query examples

Review strings changed by other users	`changed:>=2023-04-29 AND NOT changed_by:anonymous`	Add
Translated strings	`state:>=translated`	Add
Strings with comments	`has:comment`	Add
Strings with any failing checks	`has:check`	Add
Strings with suggestions from others	`has:suggestion AND NOT suggestion_author:anonymous`	Add
Approved strings with suggestions	`state:approved AND has:suggestion`	Add
All untranslated strings added the past month	`added:>=2023-04-29 AND state:<=needs-editing`	Add