postgis_branch_32

reference_relationship

	Language	Translated	Unfinished	Unfinished words	Unfinished characters	Untranslated	Checks	Suggestions	Comments
	English		0	0	0	0	7	0	0

	French	0%	273	5,065	46,644	273	2	213	0

	German	0%	273	5,065	46,644	273	6	46	0

	Italian	0%	273	5,065	46,644	273	5	27	0

	Japanese		0	0	0	0	97	0	0

	Korean	0%	273	5,065	46,644	273	6	36	0

	Polish	0%	273	5,065	46,644	273	2	12	0

	Portuguese (Brazil)	0%	273	5,065	46,644	273	6	36	0

	Spanish	0%	273	5,065	46,644	273	4	19	0

Please sign in to see the alerts.

Overview

Project website	postgis.net
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	stable-3.2
Last remote commit	Push to 3.2.6dev milestone `6e2c5206d` Regina Obe authored 22 hours ago
Weblate repository	`https://weblate.osgeo.org/git/postgis_branch_32/postgis/`
File mask	`doc/po/*/reference_relationship.xml.po`

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		2,457		45,585		419,796
Source		273		5,065		46,644
Translated	22%	546	22%	10,130	22%	93,288
Needs editing	0%	0	0%	0	0%	0
Read-only	11%	273	11%	5,065	11%	46,644
Failing checks	5%	135	2%	1,197	3%	14,095
Strings with suggestions	15%	389	8%	3,828	9%	38,537
Untranslated strings	77%	1,911	77%	35,455	77%	326,508

Last 12 months Previous

Activity in last 12 months


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

Quick numbers

45,585

Hosted words

2,457

Hosted strings

22%

Translated

2

Contributors

and previous 30 days

Trends of last 30 days

—

Hosted words

—

—

Hosted strings

—

—

Translated

—

+100%

Contributors

—

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
Translated strings in a certain language	`is:translated AND language:en`	Add

anonymous Suggestion added postgis_branch_32 / reference_relationship — French	English SELECT ST_PointInsideCircle(ST_Point(1,2), 0.5, 2, 3); st_pointinsidecircle ------------------------ t French 104 characters edited SELECT ST_PointInsideCircle(ST_Point(1,2), 0.5, 2, 3); st_pointinsidecircle ------------------------ t 6 days ago
anonymous Suggestion added postgis_branch_32 / reference_relationship — French	English Changed: 2.2.0 In prior versions this was called ST_Point_Inside_Circle French 98 characters edited Modifié : 2.2.0 Dans les versions précédentes, cette fonction était appelée ST_Point_Inside_Circle 6 days ago
anonymous Suggestion added postgis_branch_32 / reference_relationship — French	English Availability: 1.2 French 19 characters edited Disponibilité : 1.2 6 days ago
anonymous Suggestion added postgis_branch_32 / reference_relationship — French	English Does not use spatial indexes. Use <xref linkend="ST_DWithin"/> instead. French 79 characters edited N'utilise pas les index spatiaux. Utilisez plutôt <xref linkend="ST_DWithin"/>. 6 days ago
anonymous Suggestion added postgis_branch_32 / reference_relationship — French	English Returns true if the geometry is a point and is inside the circle with center <varname>center_x</varname>,<varname>center_y</varname> and radius <varname>radius</varname>. French 184 characters edited Retourne true si la géométrie est un point et se trouve à l'intérieur du cercle de centre <varname>center_x</varname>,<varname>center_y</varname> et de rayon <varname>radius</varname>. 6 days ago
anonymous Suggestion added postgis_branch_32 / reference_relationship — French	English <funcdef>boolean <function>ST_PointInsideCircle</function></funcdef> <paramdef><type>geometry </type> <parameter>a_point</parameter></paramdef> <paramdef><type>float </type> <parameter>center_x</parameter></paramdef> <paramdef><type>float </type> <parameter>center_y</parameter></paramdef> <paramdef><type>float </type> <parameter>radius</parameter></paramdef> French 360 characters edited <funcdef>boolean <function>ST_PointInsideCircle</function></funcdef> <paramdef><type>geometry </type> <parameter>a_point</parameter></paramdef> <paramdef><type>float </type> <parameter>center_x</parameter></paramdef> <paramdef><type>float </type> <parameter>center_y</parameter></paramdef> <paramdef><type>float </type> <parameter>radius</parameter></paramdef> 6 days ago
anonymous Suggestion added postgis_branch_32 / reference_relationship — French	English ST_PointInsideCircle French 20 characters edited ST_PointInsideCircle 6 days ago
anonymous Suggestion added postgis_branch_32 / reference_relationship — French	English , <xref linkend="ST_3DDWithin"/> French 32 characters edited , <xref linkend="ST_3DDWithin"/> 6 days ago
anonymous Suggestion added postgis_branch_32 / reference_relationship — French	English -- Find the nearest hospital to each school -- that is within 3000 units of the school. -- We do an ST_DWithin search to utilize indexes to limit our search list -- that the non-indexable ST_Distance needs to process -- If the units of the spatial reference is meters then units would be meters SELECT DISTINCT ON (s.gid) s.gid, s.school_name, s.geom, h.hospital_name FROM schools s LEFT JOIN hospitals h ON ST_DWithin(s.geom, h.geom, 3000) ORDER BY s.gid, ST_Distance(s.geom, h.geom); -- The schools with no close hospitals -- Find all schools with no hospital within 3000 units -- away from the school. Units is in units of spatial ref (e.g. meters, feet, degrees) SELECT s.gid, s.school_name FROM schools s LEFT JOIN hospitals h ON ST_DWithin(s.geom, h.geom, 3000) WHERE h.gid IS NULL; -- Find broadcasting towers that receiver with limited range can receive. -- Data is geometry in Spherical Mercator (SRID=3857), ranges are approximate. -- Create geometry index that will check proximity limit of user to tower CREATE INDEX ON broadcasting_towers using gist (geom); -- Create geometry index that will check proximity limit of tower to user CREATE INDEX ON broadcasting_towers using gist (ST_Expand(geom, sending_range)); -- Query towers that 4-kilometer receiver in Minsk Hackerspace can get -- Note: two conditions, because shorter LEAST(b.sending_range, 4000) will not use index. SELECT b.tower_id, b.geom FROM broadcasting_towers b WHERE ST_DWithin(b.geom, 'SRID=3857;POINT(3072163.4 7159374.1)', 4000) AND ST_DWithin(b.geom, 'SRID=3857;POINT(3072163.4 7159374.1)', b.sending_range); French 1979 characters edited -- Trouvez l'hôpital le plus proche de chaque école -- Nous effectuons une recherche ST_DWithin afin d'utiliser des index pour limiter notre liste de recherche. -- Nous effectuons une recherche ST_DWithin pour utiliser les index afin de limiter notre liste de recherche. -- Nous faisons une recherche ST_DWithin pour utiliser des index afin de limiter notre liste de recherche. -- Si l'unité de la référence spatiale est le mètre, l'unité sera le mètre. SELECT DISTINCT ON (s.gid) s.gid, s.school_name, s.geom, h.hospital_name FROM schools s LEFT JOIN hospitals h ON ST_DWithin(s.geom, h.geom, 3000) ORDER BY s.gid, ST_Distance(s.geom, h.geom); -- Les écoles qui n'ont pas d'hôpital à proximité -- Trouver toutes les écoles qui n'ont pas d'hôpital à moins de 3000 unités -- de l'école. Les unités sont des unités de référence spatiale (par exemple, mètres, pieds, degrés). SELECT s.gid, s.school_name FROM schools s LEFT JOIN hospitals h ON ST_DWithin(s.geom, h.geom, 3000) WHERE h.gid IS NULL; -- Trouver les tours de radiodiffusion que les récepteurs à portée limitée peuvent recevoir. -- Les données sont des géométries en Mercator sphérique (SRID=3857), les portées sont approximatives. -- Créer un index géométrique qui vérifiera la limite de proximité de l'utilisateur par rapport à la tour. CREATE INDEX ON broadcasting_towers using gist (geom); -- Créer un index géométrique qui vérifiera la limite de proximité de la tour par rapport à l'utilisateur CREATE INDEX ON broadcasting_towers using gist (ST_Expand(geom, sending_range)); -- Interroger les tours que le récepteur de 4 kilomètres dans le Hackerspace de Minsk peut obtenir. -- Note : deux conditions, parce que le plus court LEAST(b.sending_range, 4000) n'utilisera pas l'index. SELECT b.tower_id, b.geom FROM broadcasting_towers b WHERE ST_DWithin(b.geom, 'SRID=3857;POINT(3072163.4 7159374.1)', 4000) AND ST_DWithin(b.geom, 'SRID=3857;POINT(3072163.4 7159374.1)', b.sending_range); 6 days ago
anonymous Suggestion added postgis_branch_32 / reference_relationship — French	English Prior to 1.3, <xref linkend="ST_Expand"/> was commonly used in conjunction with && and ST_Distance to test for distance, and in pre-1.3.4 this function used that logic. From 1.3.4, ST_DWithin uses a faster short-circuit distance function. French 316 characters edited Avant la version 1.3, <xref linkend="ST_Expand"/> était couramment utilisé en conjonction avec && et ST_Distance pour tester la distance, et avant la version 1.3.4, cette fonction utilisait cette logique. À partir de la version 1.3.4, ST_DWithin utilise une fonction de distance de court-circuit plus rapide. 6 days ago

Browse all component changes