Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/indexing/en/units/?format=api
{ "count": 62, "next": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/units/?format=api&page=2", "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Spatial Indexing" ], "previous_source": "", "target": [ "Spatial Indexing" ], "id_hash": -4942850726789348867, "content_hash": -4942850726789348867, "location": "../../en/indexing.rst:4", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99054/?format=api", "priority": 100, "id": 99054, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=3b677773cbf081fd", "url": "https://weblate.osgeo.org/api/units/99054/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.445802Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Recall that spatial index is one of the three key features of a spatial database. Indexes make using a spatial database for large data sets possible. Without indexing, any search for a feature would require a \"sequential scan\" of every record in the database. Indexing speeds up searching by organizing the data into a search tree which can be quickly traversed to find a particular record." ], "previous_source": "", "target": [ "Recall that spatial index is one of the three key features of a spatial database. Indexes make using a spatial database for large data sets possible. Without indexing, any search for a feature would require a \"sequential scan\" of every record in the database. Indexing speeds up searching by organizing the data into a search tree which can be quickly traversed to find a particular record." ], "id_hash": 3252020004996335654, "content_hash": 3252020004996335654, "location": "../../en/indexing.rst:6", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 2, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 66, "source_unit": "https://weblate.osgeo.org/api/units/99058/?format=api", "priority": 100, "id": 99058, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=ad217ef6f0454826", "url": "https://weblate.osgeo.org/api/units/99058/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.479934Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Spatial indices are one of the greatest assets of PostGIS. In the previous example building spatial joins requires comparing whole tables with each other. This can get very costly: joining two tables of 10,000 records each without indexes would require 100,000,000 comparisons; with indexes the cost could be as low as 20,000 comparisons." ], "previous_source": "", "target": [ "Spatial indices are one of the greatest assets of PostGIS. In the previous example building spatial joins requires comparing whole tables with each other. This can get very costly: joining two tables of 10,000 records each without indexes would require 100,000,000 comparisons; with indexes the cost could be as low as 20,000 comparisons." ], "id_hash": -8243536903018016406, "content_hash": -8243536903018016406, "location": "../../en/indexing.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 3, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 53, "source_unit": "https://weblate.osgeo.org/api/units/99061/?format=api", "priority": 100, "id": 99061, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=0d9912dce2c9916a", "url": "https://weblate.osgeo.org/api/units/99061/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.502477Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Our data load file already included spatial indexes for all the tables, so in order to demonstrate the efficacy of indexes we will have to first remove them." ], "previous_source": "", "target": [ "Our data load file already included spatial indexes for all the tables, so in order to demonstrate the efficacy of indexes we will have to first remove them." ], "id_hash": 6102767692057298305, "content_hash": 6102767692057298305, "location": "../../en/indexing.rst:10", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 4, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://weblate.osgeo.org/api/units/99064/?format=api", "priority": 100, "id": 99064, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=d4b162e1cfce4581", "url": "https://weblate.osgeo.org/api/units/99064/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.525349Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Let's run a query on ``nyc_census_blocks`` **without** our spatial index." ], "previous_source": "", "target": [ "Let's run a query on ``nyc_census_blocks`` **without** our spatial index." ], "id_hash": 8447122015727556524, "content_hash": 8447122015727556524, "location": "../../en/indexing.rst:12", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 5, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/99067/?format=api", "priority": 100, "id": 99067, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=f53a34b7f1d297ac", "url": "https://weblate.osgeo.org/api/units/99067/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.547677Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Our first step is to **remove** the index." ], "previous_source": "", "target": [ "Our first step is to **remove** the index." ], "id_hash": 4560246295555155269, "content_hash": 4560246295555155269, "location": "../../en/indexing.rst:14", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 6, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://weblate.osgeo.org/api/units/99070/?format=api", "priority": 100, "id": 99070, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=bf493fd836db2545", "url": "https://weblate.osgeo.org/api/units/99070/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.570139Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "The ``DROP INDEX`` statement drops an existing index from the database system. For more information, see the PostgreSQL `documentation <http://www.postgresql.org/docs/current/interactive/sql-dropindex.html>`_." ], "previous_source": "", "target": [ "The ``DROP INDEX`` statement drops an existing index from the database system. For more information, see the PostgreSQL `documentation <http://www.postgresql.org/docs/current/interactive/sql-dropindex.html>`_." ], "id_hash": -8346478778256849431, "content_hash": -8346478778256849431, "location": "../../en/indexing.rst:22", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 7, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://weblate.osgeo.org/api/units/99073/?format=api", "priority": 100, "id": 99073, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=0c2b59c5d0aa05e9", "url": "https://weblate.osgeo.org/api/units/99073/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.593436Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Now, watch the \"Timing\" meter at the lower right-hand corner of the pgAdmin query window and run the following. Our query searches through every single census block in order to identify blocks that contain subway stops that start with \"B\"." ], "previous_source": "", "target": [ "Now, watch the \"Timing\" meter at the lower right-hand corner of the pgAdmin query window and run the following. Our query searches through every single census block in order to identify blocks that contain subway stops that start with \"B\"." ], "id_hash": 6711167777849573658, "content_hash": 6711167777849573658, "location": "../../en/indexing.rst:24", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 8, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://weblate.osgeo.org/api/units/99075/?format=api", "priority": 100, "id": 99075, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=dd22db8962c5811a", "url": "https://weblate.osgeo.org/api/units/99075/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.616232Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "The ``nyc_census_blocks`` table is very small (only a few thousand records) so even without an index, the query only takes **300 ms** on my test computer." ], "previous_source": "", "target": [ "The ``nyc_census_blocks`` table is very small (only a few thousand records) so even without an index, the query only takes **300 ms** on my test computer." ], "id_hash": -2522944692718457536, "content_hash": -2522944692718457536, "location": "../../en/indexing.rst:40", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 9, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://weblate.osgeo.org/api/units/99077/?format=api", "priority": 100, "id": 99077, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=5cfcb32b4a8f2d40", "url": "https://weblate.osgeo.org/api/units/99077/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.638773Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Now add the spatial index back in and run the query again." ], "previous_source": "", "target": [ "Now add the spatial index back in and run the query again." ], "id_hash": -780518797274771865, "content_hash": -780518797274771865, "location": "../../en/indexing.rst:42", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 10, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://weblate.osgeo.org/api/units/99079/?format=api", "priority": 100, "id": 99079, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=752b0a4a0bec0e67", "url": "https://weblate.osgeo.org/api/units/99079/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.662429Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "The ``USING GIST`` clause tells PostgreSQL to use the generic index structure (GIST) when building the index. If you receive an error that looks like ``ERROR: index row requires 11340 bytes, maximum size is 8191`` when creating your index, you have likely neglected to add the ``USING GIST`` clause." ], "previous_source": "", "target": [ "The ``USING GIST`` clause tells PostgreSQL to use the generic index structure (GIST) when building the index. If you receive an error that looks like ``ERROR: index row requires 11340 bytes, maximum size is 8191`` when creating your index, you have likely neglected to add the ``USING GIST`` clause." ], "id_hash": -1011665868981774439, "content_hash": -1011665868981774439, "location": "../../en/indexing.rst:50", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 11, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 49, "source_unit": "https://weblate.osgeo.org/api/units/99082/?format=api", "priority": 100, "id": 99082, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=71f5d7408ff45799", "url": "https://weblate.osgeo.org/api/units/99082/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.684473Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "On my test computer the time drops to **50 ms**. The larger your table, the larger the relative speed improvement of an indexed query will be." ], "previous_source": "", "target": [ "On my test computer the time drops to **50 ms**. The larger your table, the larger the relative speed improvement of an indexed query will be." ], "id_hash": 3741900197718199947, "content_hash": 3741900197718199947, "location": "../../en/indexing.rst:52", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 12, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://weblate.osgeo.org/api/units/99084/?format=api", "priority": 100, "id": 99084, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=b3ede66785f50e8b", "url": "https://weblate.osgeo.org/api/units/99084/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.707340Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "How Spatial Indexes Work" ], "previous_source": "", "target": [ "How Spatial Indexes Work" ], "id_hash": 111192857323907572, "content_hash": 111192857323907572, "location": "../../en/indexing.rst:55", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 13, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://weblate.osgeo.org/api/units/99087/?format=api", "priority": 100, "id": 99087, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=818b09508a5a29f4", "url": "https://weblate.osgeo.org/api/units/99087/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.729595Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Standard database indexes create a hierarchical tree based on the values of the column being indexed. Spatial indexes are a little different -- they are unable to index the geometric features themselves and instead index the bounding boxes of the features." ], "previous_source": "", "target": [ "Standard database indexes create a hierarchical tree based on the values of the column being indexed. Spatial indexes are a little different -- they are unable to index the geometric features themselves and instead index the bounding boxes of the features." ], "id_hash": -379466015802497926, "content_hash": -379466015802497926, "location": "../../en/indexing.rst:57", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 14, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://weblate.osgeo.org/api/units/99090/?format=api", "priority": 100, "id": 99090, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=7abbddab4bc2647a", "url": "https://weblate.osgeo.org/api/units/99090/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.752031Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "In the figure above, the number of lines that intersect the yellow star is **one**, the red line. But the bounding boxes of features that intersect the yellow box is **two**, the red and blue ones." ], "previous_source": "", "target": [ "In the figure above, the number of lines that intersect the yellow star is **one**, the red line. But the bounding boxes of features that intersect the yellow box is **two**, the red and blue ones." ], "id_hash": 8162415942772632395, "content_hash": 8162415942772632395, "location": "../../en/indexing.rst:62", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 15, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://weblate.osgeo.org/api/units/99093/?format=api", "priority": 100, "id": 99093, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=f146ba0db9f2ab4b", "url": "https://weblate.osgeo.org/api/units/99093/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.774391Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "The way the database efficiently answers the question \"what lines intersect the yellow star\" is to first answer the question \"what boxes intersect the yellow box\" using the index (which is very fast) and then do an exact calculation of \"what lines intersect the yellow star\" **only for those features returned by the first test**." ], "previous_source": "", "target": [ "The way the database efficiently answers the question \"what lines intersect the yellow star\" is to first answer the question \"what boxes intersect the yellow box\" using the index (which is very fast) and then do an exact calculation of \"what lines intersect the yellow star\" **only for those features returned by the first test**." ], "id_hash": -8325376786599492657, "content_hash": -8325376786599492657, "location": "../../en/indexing.rst:64", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 16, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://weblate.osgeo.org/api/units/99096/?format=api", "priority": 100, "id": 99096, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=0c7651ec1d7443cf", "url": "https://weblate.osgeo.org/api/units/99096/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.797970Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "For a large table, this \"two pass\" system of evaluating the approximate index first, then carrying out an exact test can radically reduce the amount of calculations necessary to answer a query." ], "previous_source": "", "target": [ "For a large table, this \"two pass\" system of evaluating the approximate index first, then carrying out an exact test can radically reduce the amount of calculations necessary to answer a query." ], "id_hash": 7725541580733762820, "content_hash": 7725541580733762820, "location": "../../en/indexing.rst:66", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 17, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://weblate.osgeo.org/api/units/99098/?format=api", "priority": 100, "id": 99098, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=eb36a322d1254d04", "url": "https://weblate.osgeo.org/api/units/99098/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.867494Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Both PostGIS and Oracle Spatial share the same \"R-Tree\" [#RTree]_ spatial index structure. R-Trees break up data into rectangles, and sub-rectangles, and sub-sub rectangles, etc. It is a self-tuning index structure that automatically handles variable data density, differing amounts of object overlap, and object size." ], "previous_source": "", "target": [ "Both PostGIS and Oracle Spatial share the same \"R-Tree\" [#RTree]_ spatial index structure. R-Trees break up data into rectangles, and sub-rectangles, and sub-sub rectangles, etc. It is a self-tuning index structure that automatically handles variable data density, differing amounts of object overlap, and object size." ], "id_hash": -292272880265531264, "content_hash": -292272880265531264, "location": "../../en/indexing.rst:68", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 18, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://weblate.osgeo.org/api/units/99102/?format=api", "priority": 100, "id": 99102, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=7bf1a35d2a4af080", "url": "https://weblate.osgeo.org/api/units/99102/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.890131Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Spatially Indexed Functions" ], "previous_source": "", "target": [ "Spatially Indexed Functions" ], "id_hash": -6998197568451649036, "content_hash": -6998197568451649036, "location": "../../en/indexing.rst:74", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 19, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/99106/?format=api", "priority": 100, "id": 99106, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=1ee16863b86fe1f4", "url": "https://weblate.osgeo.org/api/units/99106/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.912441Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Only a subset of functions will automatically make use of a spatial index, if one is available." ], "previous_source": "", "target": [ "Only a subset of functions will automatically make use of a spatial index, if one is available." ], "id_hash": -2957367352215127122, "content_hash": -2957367352215127122, "location": "../../en/indexing.rst:76", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 20, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://weblate.osgeo.org/api/units/99109/?format=api", "priority": 100, "id": 99109, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=56f5520fdce13bae", "url": "https://weblate.osgeo.org/api/units/99109/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.934496Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "`ST_Intersects <http://postgis.net/docs/ST_Intersects.html>`_" ], "previous_source": "", "target": [ "`ST_Intersects <http://postgis.net/docs/ST_Intersects.html>`_" ], "id_hash": 6876279281867251486, "content_hash": 6876279281867251486, "location": "../../en/indexing.rst:78", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99112/?format=api", "priority": 100, "id": 99112, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=df6d739324135f1e", "url": "https://weblate.osgeo.org/api/units/99112/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.957118Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "`ST_Contains <http://postgis.net/docs/ST_Contains.html>`_" ], "previous_source": "", "target": [ "`ST_Contains <http://postgis.net/docs/ST_Contains.html>`_" ], "id_hash": -901029894910086792, "content_hash": -901029894910086792, "location": "../../en/indexing.rst:79", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 22, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99141/?format=api", "priority": 100, "id": 99141, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=737ee6159de07178", "url": "https://weblate.osgeo.org/api/units/99141/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.226485Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "`ST_Within <http://postgis.net/docs/ST_Within.html>`_" ], "previous_source": "", "target": [ "`ST_Within <http://postgis.net/docs/ST_Within.html>`_" ], "id_hash": -6881193822029590541, "content_hash": -6881193822029590541, "location": "../../en/indexing.rst:80", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 23, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99155/?format=api", "priority": 100, "id": 99155, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=208116ad4f504ff3", "url": "https://weblate.osgeo.org/api/units/99155/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.248635Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "`ST_DWithin <http://postgis.net/docs/ST_DWithin.html>`_" ], "previous_source": "", "target": [ "`ST_DWithin <http://postgis.net/docs/ST_DWithin.html>`_" ], "id_hash": 554853698545848552, "content_hash": 554853698545848552, "location": "../../en/indexing.rst:81", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 24, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99162/?format=api", "priority": 100, "id": 99162, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=87b33c7fc42310e8", "url": "https://weblate.osgeo.org/api/units/99162/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.296456Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "`ST_ContainsProperly <http://postgis.net/docs/ST_ContainsProperly.html>`_" ], "previous_source": "", "target": [ "`ST_ContainsProperly <http://postgis.net/docs/ST_ContainsProperly.html>`_" ], "id_hash": -22885470395221386, "content_hash": -22885470395221386, "location": "../../en/indexing.rst:82", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 25, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99172/?format=api", "priority": 100, "id": 99172, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=7faeb1c932933a76", "url": "https://weblate.osgeo.org/api/units/99172/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.320194Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "`ST_CoveredBy <http://postgis.net/docs/ST_CoveredBy.html>`_" ], "previous_source": "", "target": [ "`ST_CoveredBy <http://postgis.net/docs/ST_CoveredBy.html>`_" ], "id_hash": 1313556159018850827, "content_hash": 1313556159018850827, "location": "../../en/indexing.rst:83", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 26, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99186/?format=api", "priority": 100, "id": 99186, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=923ab05dfad85a0b", "url": "https://weblate.osgeo.org/api/units/99186/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.343395Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "`ST_Covers <http://postgis.net/docs/ST_Covers.html>`_" ], "previous_source": "", "target": [ "`ST_Covers <http://postgis.net/docs/ST_Covers.html>`_" ], "id_hash": 6780706238689212564, "content_hash": 6780706238689212564, "location": "../../en/indexing.rst:84", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 27, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99188/?format=api", "priority": 100, "id": 99188, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=de19e865fb587894", "url": "https://weblate.osgeo.org/api/units/99188/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.366743Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "`ST_Overlaps <http://postgis.net/docs/ST_Overlaps.html>`_" ], "previous_source": "", "target": [ "`ST_Overlaps <http://postgis.net/docs/ST_Overlaps.html>`_" ], "id_hash": 1453129042912478962, "content_hash": 1453129042912478962, "location": "../../en/indexing.rst:85", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 28, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99190/?format=api", "priority": 100, "id": 99190, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=942a8d2a5f9a06f2", "url": "https://weblate.osgeo.org/api/units/99190/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.390946Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "`ST_Crosses <http://postgis.net/docs/ST_Crosses.html>`_" ], "previous_source": "", "target": [ "`ST_Crosses <http://postgis.net/docs/ST_Crosses.html>`_" ], "id_hash": 5488717470116205290, "content_hash": 5488717470116205290, "location": "../../en/indexing.rst:86", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 29, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99192/?format=api", "priority": 100, "id": 99192, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=cc2bd77566c1d2ea", "url": "https://weblate.osgeo.org/api/units/99192/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.414196Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "`ST_DFullyWithin <http://postgis.net/docs/ST_DFullyWithin.html>`_" ], "previous_source": "", "target": [ "`ST_DFullyWithin <http://postgis.net/docs/ST_DFullyWithin.html>`_" ], "id_hash": -2219881997076301839, "content_hash": -2219881997076301839, "location": "../../en/indexing.rst:87", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 30, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99194/?format=api", "priority": 100, "id": 99194, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=61316515c8fb77f1", "url": "https://weblate.osgeo.org/api/units/99194/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.438026Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "`ST_3DIntersects <http://postgis.net/docs/ST_3DIntersects.html>`_" ], "previous_source": "", "target": [ "`ST_3DIntersects <http://postgis.net/docs/ST_3DIntersects.html>`_" ], "id_hash": -7683118195171773068, "content_hash": -7683118195171773068, "location": "../../en/indexing.rst:88", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 31, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99196/?format=api", "priority": 100, "id": 99196, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=156014b559723574", "url": "https://weblate.osgeo.org/api/units/99196/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.462600Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "`ST_3DDWithin <http://postgis.net/docs/ST_3DDWithin.html>`_" ], "previous_source": "", "target": [ "`ST_3DDWithin <http://postgis.net/docs/ST_3DDWithin.html>`_" ], "id_hash": 4318468670002832493, "content_hash": 4318468670002832493, "location": "../../en/indexing.rst:89", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 32, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99203/?format=api", "priority": 100, "id": 99203, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=bbee4860092c246d", "url": "https://weblate.osgeo.org/api/units/99203/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.486785Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "`ST_3DDFullyWithin <http://postgis.net/docs/ST_3DDFullyWithin.html>`_" ], "previous_source": "", "target": [ "`ST_3DDFullyWithin <http://postgis.net/docs/ST_3DDFullyWithin.html>`_" ], "id_hash": -8329565531486882029, "content_hash": -8329565531486882029, "location": "../../en/indexing.rst:90", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 33, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99217/?format=api", "priority": 100, "id": 99217, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=0c677047f262f713", "url": "https://weblate.osgeo.org/api/units/99217/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.510821Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "`ST_LineCrossingDirection <http://postgis.net/docs/ST_LineCrossingDirection.html>`_" ], "previous_source": "", "target": [ "`ST_LineCrossingDirection <http://postgis.net/docs/ST_LineCrossingDirection.html>`_" ], "id_hash": -4013956399633373279, "content_hash": -4013956399633373279, "location": "../../en/indexing.rst:91", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 34, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99225/?format=api", "priority": 100, "id": 99225, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=484b8febdff267a1", "url": "https://weblate.osgeo.org/api/units/99225/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.534684Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "`ST_OrderingEquals <http://postgis.net/docs/ST_OrderingEquals.html>`_" ], "previous_source": "", "target": [ "`ST_OrderingEquals <http://postgis.net/docs/ST_OrderingEquals.html>`_" ], "id_hash": 8883204810123361857, "content_hash": 8883204810123361857, "location": "../../en/indexing.rst:92", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 35, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99227/?format=api", "priority": 100, "id": 99227, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=fb477bb5a671be41", "url": "https://weblate.osgeo.org/api/units/99227/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.557502Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "`ST_Equals <http://postgis.net/docs/ST_Equals.html>`_" ], "previous_source": "", "target": [ "`ST_Equals <http://postgis.net/docs/ST_Equals.html>`_" ], "id_hash": -8189105361436822395, "content_hash": -8189105361436822395, "location": "../../en/indexing.rst:93", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 36, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99229/?format=api", "priority": 100, "id": 99229, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=0e5a740fbf4fb485", "url": "https://weblate.osgeo.org/api/units/99229/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.579301Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "The first four are the ones most commonly used in queries, and `ST_DWithin <http://postgis.net/docs/ST_DWithin.html>`_ is very important for doing \"within a distance\" or \"within a radius\" style queries while still getting a performance boost from the index." ], "previous_source": "", "target": [ "The first four are the ones most commonly used in queries, and `ST_DWithin <http://postgis.net/docs/ST_DWithin.html>`_ is very important for doing \"within a distance\" or \"within a radius\" style queries while still getting a performance boost from the index." ], "id_hash": 4079585171001736730, "content_hash": 4079585171001736730, "location": "../../en/indexing.rst:95", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 37, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://weblate.osgeo.org/api/units/99231/?format=api", "priority": 100, "id": 99231, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=b89d991934827e1a", "url": "https://weblate.osgeo.org/api/units/99231/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.601539Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Index-Only Queries" ], "previous_source": "", "target": [ "Index-Only Queries" ], "id_hash": -4892638177143069855, "content_hash": -4892638177143069855, "location": "../../en/indexing.rst:101", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 39, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99261/?format=api", "priority": 100, "id": 99261, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=3c19db800cdf6361", "url": "https://weblate.osgeo.org/api/units/99261/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.646263Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Most of the commonly used functions in PostGIS (:command:`ST_Contains`, :command:`ST_Intersects`, :command:`ST_DWithin`, etc) include an index filter automatically. But some functions (e.g., :command:`ST_Relate`) do not include an index filter." ], "previous_source": "", "target": [ "Most of the commonly used functions in PostGIS (:command:`ST_Contains`, :command:`ST_Intersects`, :command:`ST_DWithin`, etc) include an index filter automatically. But some functions (e.g., :command:`ST_Relate`) do not include an index filter." ], "id_hash": 5719797697078564040, "content_hash": 5719797697078564040, "location": "../../en/indexing.rst:103", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 40, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://weblate.osgeo.org/api/units/99271/?format=api", "priority": 100, "id": 99271, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=cf60cdb3617714c8", "url": "https://weblate.osgeo.org/api/units/99271/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.667966Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "To do a bounding-box search using the index (and no filtering), make use of the :command:`&&` operator. For geometries, the :command:`&&` operator means \"bounding boxes overlap or touch\" in the same way that for numbers the :command:`=` operator means \"values are the same\"." ], "previous_source": "", "target": [ "To do a bounding-box search using the index (and no filtering), make use of the :command:`&&` operator. For geometries, the :command:`&&` operator means \"bounding boxes overlap or touch\" in the same way that for numbers the :command:`=` operator means \"values are the same\"." ], "id_hash": -8587135309433986678, "content_hash": -8587135309433986678, "location": "../../en/indexing.rst:105", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 41, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://weblate.osgeo.org/api/units/99286/?format=api", "priority": 100, "id": 99286, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=08d45deec2f9218a", "url": "https://weblate.osgeo.org/api/units/99286/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.693689Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Let's compare an index-only query for the population of the 'West Village' to a more exact query. Using :command:`&&` our index-only query looks like the following:" ], "previous_source": "", "target": [ "Let's compare an index-only query for the population of the 'West Village' to a more exact query. Using :command:`&&` our index-only query looks like the following:" ], "id_hash": -1295035046493765888, "content_hash": -1295035046493765888, "location": "../../en/indexing.rst:107", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 42, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://weblate.osgeo.org/api/units/99305/?format=api", "priority": 100, "id": 99305, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=6e071c7c920ebf00", "url": "https://weblate.osgeo.org/api/units/99305/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.721611Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Now let's do the same query using the more exact :command:`ST_Intersects` function." ], "previous_source": "", "target": [ "Now let's do the same query using the more exact :command:`ST_Intersects` function." ], "id_hash": 9087405733267931119, "content_hash": 9087405733267931119, "location": "../../en/indexing.rst:121", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 43, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://weblate.osgeo.org/api/units/99320/?format=api", "priority": 100, "id": 99320, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=fe1cf35e05487fef", "url": "https://weblate.osgeo.org/api/units/99320/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.745794Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "A much lower answer! The first query summed up every block whose bounding box intersects the neighborhood's bounding box; the second query only summed up those blocks that intersect the neighborhood itself." ], "previous_source": "", "target": [ "A much lower answer! The first query summed up every block whose bounding box intersects the neighborhood's bounding box; the second query only summed up those blocks that intersect the neighborhood itself." ], "id_hash": -8969398914784967568, "content_hash": -8969398914784967568, "location": "../../en/indexing.rst:135", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 44, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://weblate.osgeo.org/api/units/99322/?format=api", "priority": 100, "id": 99322, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=03864b357b77c470", "url": "https://weblate.osgeo.org/api/units/99322/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.768732Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Analyzing" ], "previous_source": "", "target": [ "Analyzing" ], "id_hash": 6113097274254378089, "content_hash": 6113097274254378089, "location": "../../en/indexing.rst:138", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 45, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/99324/?format=api", "priority": 100, "id": 99324, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=d4d6159515574469", "url": "https://weblate.osgeo.org/api/units/99324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.791749Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "The PostgreSQL query planner intelligently chooses when to use or not to use indexes to evaluate a query. Counter-intuitively, it is not always faster to do an index search: if the search is going to return every record in the table, traversing the index tree to get each record will actually be slower than just sequentially reading the whole table from the start." ], "previous_source": "", "target": [ "The PostgreSQL query planner intelligently chooses when to use or not to use indexes to evaluate a query. Counter-intuitively, it is not always faster to do an index search: if the search is going to return every record in the table, traversing the index tree to get each record will actually be slower than just sequentially reading the whole table from the start." ], "id_hash": -515617727162225842, "content_hash": -515617727162225842, "location": "../../en/indexing.rst:140", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 46, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 63, "source_unit": "https://weblate.osgeo.org/api/units/99332/?format=api", "priority": 100, "id": 99332, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=78d82868b499eb4e", "url": "https://weblate.osgeo.org/api/units/99332/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.814676Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Knowing the size of the query rectangle is not enough to pin down whether a query will return a large number or small number of records. Below, the red square is small, but will return many more records than the blue square." ], "previous_source": "", "target": [ "Knowing the size of the query rectangle is not enough to pin down whether a query will return a large number or small number of records. Below, the red square is small, but will return many more records than the blue square." ], "id_hash": -48405699325197326, "content_hash": -48405699325197326, "location": "../../en/indexing.rst:142", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 47, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://weblate.osgeo.org/api/units/99347/?format=api", "priority": 100, "id": 99347, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=7f540745de9e03f2", "url": "https://weblate.osgeo.org/api/units/99347/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.837337Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "In order to figure out what situation it is dealing with (reading a small part of the table versus reading a large portion of the table), PostgreSQL keeps statistics about the distribution of data in each indexed table column. By default, PostgreSQL gathers statistics on a regular basis. However, if you dramatically change the contents of your table within a short period of time, the statistics will not be up-to-date." ], "previous_source": "", "target": [ "In order to figure out what situation it is dealing with (reading a small part of the table versus reading a large portion of the table), PostgreSQL keeps statistics about the distribution of data in each indexed table column. By default, PostgreSQL gathers statistics on a regular basis. However, if you dramatically change the contents of your table within a short period of time, the statistics will not be up-to-date." ], "id_hash": -7482497219989809477, "content_hash": -7482497219989809477, "location": "../../en/indexing.rst:146", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 48, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 70, "source_unit": "https://weblate.osgeo.org/api/units/99362/?format=api", "priority": 100, "id": 99362, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=1828d46c21a8d6bb", "url": "https://weblate.osgeo.org/api/units/99362/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.859754Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "To ensure the statistics match your table contents, it is wise the to run the ``ANALYZE`` command after bulk data loads and deletes in your tables. This force the statistics system to gather data for all your indexed columns." ], "previous_source": "", "target": [ "To ensure the statistics match your table contents, it is wise the to run the ``ANALYZE`` command after bulk data loads and deletes in your tables. This force the statistics system to gather data for all your indexed columns." ], "id_hash": -2910599137442415458, "content_hash": -2910599137442415458, "location": "../../en/indexing.rst:148", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 49, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://weblate.osgeo.org/api/units/99375/?format=api", "priority": 100, "id": 99375, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=579b7981692fbc9e", "url": "https://weblate.osgeo.org/api/units/99375/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.883360Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "The ``ANALYZE`` command asks PostgreSQL to traverse the table and update its internal statistics used for query plan estimation (query plan analysis will be discussed later)." ], "previous_source": "", "target": [ "The ``ANALYZE`` command asks PostgreSQL to traverse the table and update its internal statistics used for query plan estimation (query plan analysis will be discussed later)." ], "id_hash": -6572501559126693673, "content_hash": -6572501559126693673, "location": "../../en/indexing.rst:150", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 50, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://weblate.osgeo.org/api/units/99391/?format=api", "priority": 100, "id": 99391, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=24c9c8a7928d68d7", "url": "https://weblate.osgeo.org/api/units/99391/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.907645Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/indexing/en/?format=api", "source": [ "Vacuuming" ], "previous_source": "", "target": [ "Vacuuming" ], "id_hash": 2119412846128446040, "content_hash": 2119412846128446040, "location": "../../en/indexing.rst:157", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 51, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/99406/?format=api", "priority": 100, "id": 99406, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/indexing/en/?checksum=9d69aac121e2ba58", "url": "https://weblate.osgeo.org/api/units/99406/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.931341Z" } ] }