Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/loading_data/uk/units/?format=api
{ "count": 73, "next": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/units/?format=api&page=2", "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Loading spatial data" ], "previous_source": "", "target": [ "" ], "id_hash": -9072465843247242629, "content_hash": -9072465843247242629, "location": "../../en/loading_data.rst:4", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/104115/?format=api", "priority": 100, "id": 2360647, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=021820623062227b", "url": "https://weblate.osgeo.org/api/units/2360647/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.831910Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Supported by a wide variety of libraries and applications, PostGIS provides many options for loading data." ], "previous_source": "", "target": [ "" ], "id_hash": 759990065547533707, "content_hash": 759990065547533707, "location": "../../en/loading_data.rst:6", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://weblate.osgeo.org/api/units/104127/?format=api", "priority": 100, "id": 2360648, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=8a8c06f021c95d8b", "url": "https://weblate.osgeo.org/api/units/2360648/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.838673Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "We will first load our working data from a database backup file, then review some standard ways of loading different GIS data formats using common tools." ], "previous_source": "", "target": [ "" ], "id_hash": -2742854678331041612, "content_hash": -2742854678331041612, "location": "../../en/loading_data.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://weblate.osgeo.org/api/units/104129/?format=api", "priority": 100, "id": 2360649, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=59ef6c33cb8f58b4", "url": "https://weblate.osgeo.org/api/units/2360649/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.841452Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Loading the Backup File" ], "previous_source": "", "target": [ "" ], "id_hash": -2912740276573230250, "content_hash": -2912740276573230250, "location": "../../en/loading_data.rst:12", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://weblate.osgeo.org/api/units/104131/?format=api", "priority": 100, "id": 2360650, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=5793de269be12b56", "url": "https://weblate.osgeo.org/api/units/2360650/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.844684Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "In the PgAdmin browser, **right-click** on the **nyc** database icon, and then select the **Restore...** option." ], "previous_source": "", "target": [ "" ], "id_hash": -6206493694140551957, "content_hash": -6206493694140551957, "location": "../../en/loading_data.rst:14", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://weblate.osgeo.org/api/units/104133/?format=api", "priority": 100, "id": 2360651, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=29de1ade5c0ceceb", "url": "https://weblate.osgeo.org/api/units/2360651/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.848235Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Browse to the location of your workshop data data directory, and select the :file:`nyc_data.backup` file." ], "previous_source": "", "target": [ "" ], "id_hash": 7087935383164883599, "content_hash": 7087935383164883599, "location": "../../en/loading_data.rst:19", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://weblate.osgeo.org/api/units/104135/?format=api", "priority": 100, "id": 2360652, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=e25d67ad7077128f", "url": "https://weblate.osgeo.org/api/units/2360652/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.851167Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Click on the **Restore options** tab, scroll down to the **Do not save** section and toggle **Owner** to **Yes**." ], "previous_source": "", "target": [ "" ], "id_hash": -5638883401942114228, "content_hash": -5638883401942114228, "location": "../../en/loading_data.rst:24", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://weblate.osgeo.org/api/units/104137/?format=api", "priority": 100, "id": 2360653, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=31bea96c0964e04c", "url": "https://weblate.osgeo.org/api/units/2360653/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.854124Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Click the **Restore** button. The database restore should run to completion without errors." ], "previous_source": "", "target": [ "" ], "id_hash": -2443561732028858471, "content_hash": -2443561732028858471, "location": "../../en/loading_data.rst:29", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 8, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/104139/?format=api", "priority": 100, "id": 2360654, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=5e16b98d1fae7f99", "url": "https://weblate.osgeo.org/api/units/2360654/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.856666Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "After the load is complete, right click the **nyc** database, and select the **Refresh** option to update the client information about what tables exist in the database." ], "previous_source": "", "target": [ "" ], "id_hash": 6449845381453981977, "content_hash": 6449845381453981977, "location": "../../en/loading_data.rst:34", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 9, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://weblate.osgeo.org/api/units/104141/?format=api", "priority": 100, "id": 2360655, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=d9827433a1c22919", "url": "https://weblate.osgeo.org/api/units/2360655/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.859354Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "If you want to practice loading data from the native spatial formats, instead of using the PostgreSQL db backup files just covered, the next couple of sections will guide you thru loading using various command-line tools and QGIS DbManager. Note you can skip these sections, if you have already loaded the data with pgAdmin." ], "previous_source": "", "target": [ "" ], "id_hash": 9122157938003002848, "content_hash": 9122157938003002848, "location": "../../en/loading_data.rst:41", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 10, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 54, "source_unit": "https://weblate.osgeo.org/api/units/1575868/?format=api", "priority": 100, "id": 2360656, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=fe986a5037adc5e0", "url": "https://weblate.osgeo.org/api/units/2360656/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.862080Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Loading with ogr2ogr" ], "previous_source": "", "target": [ "" ], "id_hash": -6694681638122310255, "content_hash": -6694681638122310255, "location": "../../en/loading_data.rst:48", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 11, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/104142/?format=api", "priority": 100, "id": 2360657, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=2317b6852363b591", "url": "https://weblate.osgeo.org/api/units/2360657/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.865057Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ ":file:`ogr2ogr` is a commandline utility for converting data between GIS data formats, including common file formats and common spatial databases." ], "previous_source": "", "target": [ "" ], "id_hash": -5935547584329385180, "content_hash": -5935547584329385180, "location": "../../en/loading_data.rst:50", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 12, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://weblate.osgeo.org/api/units/104143/?format=api", "priority": 100, "id": 2360658, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=2da0b2eb809e7b24", "url": "https://weblate.osgeo.org/api/units/2360658/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.867763Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "**Windows**:" ], "previous_source": "", "target": [ "" ], "id_hash": 5601705313362125601, "content_hash": 5601705313362125601, "location": "../../en/loading_data.rst:55", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 13, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/104149/?format=api", "priority": 100, "id": 2360659, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=cdbd414dab5e2321", "url": "https://weblate.osgeo.org/api/units/2360659/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.870195Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Builds of ogr2ogr can be downloaded from `GIS Internals <https://www.gisinternals.com/release.php>`_." ], "previous_source": "", "target": [ "" ], "id_hash": -3608503736455876081, "content_hash": -3608503736455876081, "location": "../../en/loading_data.rst:53", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 14, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/104163/?format=api", "priority": 100, "id": 2360660, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=4dec04f869e0b20f", "url": "https://weblate.osgeo.org/api/units/2360660/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.872723Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "ogr2ogr is included as part of `QGIS Install <https://qgis.org/en/site/forusers/download.html>`_ and accessible via OSGeo4W Shell -" ], "previous_source": "", "target": [ "" ], "id_hash": 9044863278842947838, "content_hash": 9044863278842947838, "location": "../../en/loading_data.rst:54", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 15, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://weblate.osgeo.org/api/units/473877/?format=api", "priority": 100, "id": 2360661, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=fd85cf3af968a8fe", "url": "https://weblate.osgeo.org/api/units/2360661/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.875516Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Builds of ogr2ogr can be downloaded from `MS4W <https://ms4w.com/download.html>`_." ], "previous_source": "", "target": [ "" ], "id_hash": 2948296201389703629, "content_hash": 2948296201389703629, "location": "../../en/loading_data.rst:55", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 16, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://weblate.osgeo.org/api/units/104170/?format=api", "priority": 100, "id": 2360662, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=a8ea73c6407781cd", "url": "https://weblate.osgeo.org/api/units/2360662/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.878470Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "**MacOS**:" ], "previous_source": "", "target": [ "" ], "id_hash": 8663547209998100133, "content_hash": 8663547209998100133, "location": "../../en/loading_data.rst:59", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 17, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/104171/?format=api", "priority": 100, "id": 2360663, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=f83b1a493ac366a5", "url": "https://weblate.osgeo.org/api/units/2360663/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.881159Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "If you installed `Postgres.app <https://postgresapp.com/>`_, then you will find :file:`ogr2ogr` in the :file:`/Applications/Postgres.app/Contents/Versions/*/bin` directory." ], "previous_source": "", "target": [ "" ], "id_hash": 774714957819633415, "content_hash": 774714957819633415, "location": "../../en/loading_data.rst:58", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 18, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/104172/?format=api", "priority": 100, "id": 2360664, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=8ac0572647055f07", "url": "https://weblate.osgeo.org/api/units/2360664/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.883682Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Finally, if you have installed `HomeBrew <https://brew.sh/>`_ you can install the **gdal** package to get access to :file:`ogr2ogr`" ], "previous_source": "", "target": [ "" ], "id_hash": 7992080959024426500, "content_hash": 7992080959024426500, "location": "../../en/loading_data.rst:59", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 19, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://weblate.osgeo.org/api/units/104177/?format=api", "priority": 100, "id": 2360665, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=eee99349d2d06e04", "url": "https://weblate.osgeo.org/api/units/2360665/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.886167Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "**Linux**:" ], "previous_source": "", "target": [ "" ], "id_hash": 2404124918020114617, "content_hash": 2404124918020114617, "location": "../../en/loading_data.rst:62", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 20, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/104190/?format=api", "priority": 100, "id": 2360666, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=a15d2ae0164108b9", "url": "https://weblate.osgeo.org/api/units/2360666/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.888710Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "If you installed QGIS from packages, :file:`ogr2ogr` should be installed and on your PATH already as part of the **gdal** or *libgdal** packages." ], "previous_source": "", "target": [ "" ], "id_hash": 5959490749554667095, "content_hash": 5959490749554667095, "location": "../../en/loading_data.rst:62", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://weblate.osgeo.org/api/units/1514199/?format=api", "priority": 100, "id": 2360667, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=d2b45d43116eae57", "url": "https://weblate.osgeo.org/api/units/2360667/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.891129Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "The postgis workshop data directory includes a :file:`2000/` sub-directory, which contains shape files from the 2000 census, that were obsoleted by data from the 2010 census. We can practice data loading using those files, to avoid creating name collisions with the data we already loaded using the backup file. Be sure to be in the :file:`2000/` sub-directory with the shell when doing these instructions:" ], "previous_source": "", "target": [ "" ], "id_hash": -3841009433665441611, "content_hash": -3841009433665441611, "location": "../../en/loading_data.rst:64", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 22, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://weblate.osgeo.org/api/units/473878/?format=api", "priority": 100, "id": 2360668, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=4ab1fe45477270b5", "url": "https://weblate.osgeo.org/api/units/2360668/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.893860Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Rather than passing the password in the connection string, we put it in the environment, so it won't be visible in the process list while the command runs." ], "previous_source": "", "target": [ "" ], "id_hash": -8967689530265040306, "content_hash": -8967689530265040306, "location": "../../en/loading_data.rst:71", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 23, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://weblate.osgeo.org/api/units/104224/?format=api", "priority": 100, "id": 2360669, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=038c5de294900a4e", "url": "https://weblate.osgeo.org/api/units/2360669/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.910937Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Note that on Windows, you will need to use ``set`` instead of ``export``." ], "previous_source": "", "target": [ "" ], "id_hash": -5773282886466828409, "content_hash": -5773282886466828409, "location": "../../en/loading_data.rst:73", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 24, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/473879/?format=api", "priority": 100, "id": 2360670, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=2fe12dcd8c4d8787", "url": "https://weblate.osgeo.org/api/units/2360670/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.913557Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "For more visual clarity, these lines are displayed with ``\\``, but they should be written in one line on your shell." ], "previous_source": "", "target": [ "" ], "id_hash": 7307016251969473845, "content_hash": 7307016251969473845, "location": "../../en/loading_data.rst:88", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 25, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://weblate.osgeo.org/api/units/473880/?format=api", "priority": 100, "id": 2360671, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=e567bc9122a58d35", "url": "https://weblate.osgeo.org/api/units/2360671/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.917982Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "The :file:`ogr2ogr` has a **huge** number of options, and we're only using a handful of them here. Here is a line-by-line explanation of the command." ], "previous_source": "", "target": [ "" ], "id_hash": 3951570453447955659, "content_hash": 3951570453447955659, "location": "../../en/loading_data.rst:90", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 26, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://weblate.osgeo.org/api/units/104222/?format=api", "priority": 100, "id": 2360672, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=b6d6cc641eb1d4cb", "url": "https://weblate.osgeo.org/api/units/2360672/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.920938Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "The executable name! You may need to ensure the executable location is in your `PATH` or use the full path to the executable, depending on your setup." ], "previous_source": "", "target": [ "" ], "id_hash": 1043319911366414569, "content_hash": 1043319911366414569, "location": "../../en/loading_data.rst:96", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 27, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://weblate.osgeo.org/api/units/104226/?format=api", "priority": 100, "id": 2360673, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=8e7a9dee801650e9", "url": "https://weblate.osgeo.org/api/units/2360673/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.923468Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "The **nln** option stands for \"new layer name\", and sets the table name that will be created in the target database." ], "previous_source": "", "target": [ "" ], "id_hash": 8479344140564378527, "content_hash": 8479344140564378527, "location": "../../en/loading_data.rst:102", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 28, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://weblate.osgeo.org/api/units/104228/?format=api", "priority": 100, "id": 2360674, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=f5acae9202a1339f", "url": "https://weblate.osgeo.org/api/units/2360674/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.926053Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "The **nlt** option stands for \"new layer type\". For shape file input in particular, the new layer type is often a \"multi-part geometry\", so the system needs to be told in advance to use \"MultiPolygon\" instead of \"Polygon\" for the geometry type." ], "previous_source": "", "target": [ "" ], "id_hash": 1645394180968707246, "content_hash": 1645394180968707246, "location": "../../en/loading_data.rst:108", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 29, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://weblate.osgeo.org/api/units/104230/?format=api", "priority": 100, "id": 2360675, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=96d59d4a382274ae", "url": "https://weblate.osgeo.org/api/units/2360675/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.928565Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "The **lco** option stands for \"layer create option\". Different drivers have different create options, and we are using three options for the `PostgreSQL driver <https://gdal.org/drivers/vector/pg.html>`_ here." ], "previous_source": "", "target": [ "" ], "id_hash": -2204656181998831273, "content_hash": -2204656181998831273, "location": "../../en/loading_data.rst:116", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 30, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://weblate.osgeo.org/api/units/104242/?format=api", "priority": 100, "id": 2360676, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=61677ce21c173957", "url": "https://weblate.osgeo.org/api/units/2360676/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.931181Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "**GEOMETRY_NAME** sets the column name for the geometry column. We prefer \"geom\" over the default, so that our tables match the standard column names in the workshop." ], "previous_source": "", "target": [ "" ], "id_hash": 5519191851440735961, "content_hash": 5519191851440735961, "location": "../../en/loading_data.rst:118", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 31, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://weblate.osgeo.org/api/units/104258/?format=api", "priority": 100, "id": 2360677, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=cc981bbf385b06d9", "url": "https://weblate.osgeo.org/api/units/2360677/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.933838Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "**FID** sets the primary key column name. Again we prefer \"gid\" which is the standard used in the workshop." ], "previous_source": "", "target": [ "" ], "id_hash": -5403105051369115059, "content_hash": -5403105051369115059, "location": "../../en/loading_data.rst:119", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 32, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://weblate.osgeo.org/api/units/104274/?format=api", "priority": 100, "id": 2360678, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=350450952906724d", "url": "https://weblate.osgeo.org/api/units/2360678/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.936429Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "**PRECISION** controls how numeric fields are represented in the database. The default when loading a shape file is to use the database \"numeric\" type, which is more precise but sometimes harder to work with than simple number types like \"integer\" and \"double precision\". We use \"NO\" to turn off the \"numeric\" type." ], "previous_source": "", "target": [ "" ], "id_hash": -5005069551392182382, "content_hash": -5005069551392182382, "location": "../../en/loading_data.rst:120", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 33, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://weblate.osgeo.org/api/units/104281/?format=api", "priority": 100, "id": 2360679, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=3a8a6bc2d1252f92", "url": "https://weblate.osgeo.org/api/units/2360679/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.939032Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "The order of arguments in :file:`ogr2ogr` is, roughly: executable, then options, then **destination** location, then **source location**. So this is the destination, the connection string for our PostgreSQL database. The \"Pg:\" portion is the driver name, and then the `connection string <https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING>`_ is contained in quotation marks (because it might have embedded spaces)." ], "previous_source": "", "target": [ "" ], "id_hash": -2750497074036533304, "content_hash": -2750497074036533304, "location": "../../en/loading_data.rst:126", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 34, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 53, "source_unit": "https://weblate.osgeo.org/api/units/104284/?format=api", "priority": 100, "id": 2360680, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=59d4457be24d17c8", "url": "https://weblate.osgeo.org/api/units/2360680/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.941691Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "The source data set in this case is the shape file we are reading. It is possible to read multiple layers in one invocation by putting the connection string here, and then following it with a list of layer names, but in this case we have just the one shape file to load." ], "previous_source": "", "target": [ "" ], "id_hash": -1726745731386467962, "content_hash": -1726745731386467962, "location": "../../en/loading_data.rst:132", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 35, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 53, "source_unit": "https://weblate.osgeo.org/api/units/104287/?format=api", "priority": 100, "id": 2360681, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=68095de7ef499986", "url": "https://weblate.osgeo.org/api/units/2360681/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.944248Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Shapefiles? What's that?" ], "previous_source": "", "target": [ "" ], "id_hash": 7580432013303277714, "content_hash": 7580432013303277714, "location": "../../en/loading_data.rst:136", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 36, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/104290/?format=api", "priority": 100, "id": 2360682, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=e9331ac0d4f0e892", "url": "https://weblate.osgeo.org/api/units/2360682/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.946758Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "You may be asking yourself -- \"What's this shapefile thing?\" A \"shapefile\" commonly refers to a collection of files with ``.shp``, ``.shx``, ``.dbf``, and other extensions on a common prefix name (e.g., nyc_census_blocks). The actual shapefile relates specifically to files with the ``.shp`` extension. However, the ``.shp`` file alone is incomplete for distribution without the required supporting files." ], "previous_source": "", "target": [ "" ], "id_hash": -2117083613669674300, "content_hash": -2117083613669674300, "location": "../../en/loading_data.rst:138", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 37, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 58, "source_unit": "https://weblate.osgeo.org/api/units/104293/?format=api", "priority": 100, "id": 2360683, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=629e9bab8f6b32c4", "url": "https://weblate.osgeo.org/api/units/2360683/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.949296Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Mandatory files:" ], "previous_source": "", "target": [ "" ], "id_hash": 4885761884402372043, "content_hash": 4885761884402372043, "location": "../../en/loading_data.rst:140", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 38, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/104300/?format=api", "priority": 100, "id": 2360684, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=c3cdb68c48f24dcb", "url": "https://weblate.osgeo.org/api/units/2360684/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.951818Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "``.shp``—shape format; the feature geometry itself" ], "previous_source": "", "target": [ "" ], "id_hash": -2612437880557416401, "content_hash": -2612437880557416401, "location": "../../en/loading_data.rst:142", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 39, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://weblate.osgeo.org/api/units/104315/?format=api", "priority": 100, "id": 2360685, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=5bbec196c399d02f", "url": "https://weblate.osgeo.org/api/units/2360685/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.962319Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "``.shx``—shape index format; a positional index of the feature geometry" ], "previous_source": "", "target": [ "" ], "id_hash": 3384144049530428449, "content_hash": 3384144049530428449, "location": "../../en/loading_data.rst:143", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 40, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/104332/?format=api", "priority": 100, "id": 2360686, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=aef6e51545035c21", "url": "https://weblate.osgeo.org/api/units/2360686/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.964958Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "``.dbf``—attribute format; columnar attributes for each shape, in dBase III" ], "previous_source": "", "target": [ "" ], "id_hash": 4159943631333789392, "content_hash": 4159943631333789392, "location": "../../en/loading_data.rst:144", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 41, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/104344/?format=api", "priority": 100, "id": 2360687, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=b9bb16b13f4c8ed0", "url": "https://weblate.osgeo.org/api/units/2360687/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.967340Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Optional files include:" ], "previous_source": "", "target": [ "" ], "id_hash": 5676408518765536455, "content_hash": 5676408518765536455, "location": "../../en/loading_data.rst:146", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 42, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/104346/?format=api", "priority": 100, "id": 2360688, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=cec6a779110564c7", "url": "https://weblate.osgeo.org/api/units/2360688/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.969964Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "``.prj``—projection format; the coordinate system and projection information, a plain text file describing the projection using well-known text format" ], "previous_source": "", "target": [ "" ], "id_hash": -8754532052531909367, "content_hash": -8754532052531909367, "location": "../../en/loading_data.rst:148", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 43, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://weblate.osgeo.org/api/units/104348/?format=api", "priority": 100, "id": 2360689, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=0681a77b52106d09", "url": "https://weblate.osgeo.org/api/units/2360689/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.972349Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "The :file:`shp2pgsql` utility makes shape data usable in PostGIS by converting it from binary data into a series of SQL commands that are then run in the database to load the data." ], "previous_source": "", "target": [ "" ], "id_hash": 3347748918530221649, "content_hash": 3347748918530221649, "location": "../../en/loading_data.rst:150", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/104350/?format=api", "priority": 100, "id": 2360690, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=ae7597e77e312651", "url": "https://weblate.osgeo.org/api/units/2360690/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.975026Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Loading with shp2pgsql" ], "previous_source": "", "target": [ "" ], "id_hash": -3089692673797412648, "content_hash": -3089692673797412648, "location": "../../en/loading_data.rst:154", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 45, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/104352/?format=api", "priority": 100, "id": 2360691, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=551f34e2112da8d8", "url": "https://weblate.osgeo.org/api/units/2360691/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.977516Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "The :file:`shp2pgsql` converts Shape files into SQL. It is a conversion utility that is part of the PostGIS code base and ships with PostGIS packages. If you installed PostgreSQL locally on your computer, you may find that :file:`shp2pgsql` has been installed along with it, and it is available in the executable directory of your installation." ], "previous_source": "", "target": [ "" ], "id_hash": 7907709145924390249, "content_hash": 7907709145924390249, "location": "../../en/loading_data.rst:156", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 46, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://weblate.osgeo.org/api/units/104353/?format=api", "priority": 100, "id": 2360692, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=edbdd39245ee4d69", "url": "https://weblate.osgeo.org/api/units/2360692/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.981529Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Unlike :file:`ogr2ogr`, :file:`shp2pgsql` does not connect directly to the destination database, it just emits the SQL equivalent to the input shape file. It is up to the user to pass the SQL to the database, either with a \"pipe\" or by saving the SQL to file and then loading it." ], "previous_source": "", "target": [ "" ], "id_hash": -1722047684347996426, "content_hash": -1722047684347996426, "location": "../../en/loading_data.rst:158", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 47, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://weblate.osgeo.org/api/units/104371/?format=api", "priority": 100, "id": 2360693, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=681a0ec1402756f6", "url": "https://weblate.osgeo.org/api/units/2360693/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.985329Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Here is an example invocation, loading the same data as before:" ], "previous_source": "", "target": [ "" ], "id_hash": 2706343583823964205, "content_hash": 2706343583823964205, "location": "../../en/loading_data.rst:160", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 48, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://weblate.osgeo.org/api/units/104373/?format=api", "priority": 100, "id": 2360694, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=a58edd2691fc282d", "url": "https://weblate.osgeo.org/api/units/2360694/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.988217Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "Here is a line-by-line explanation of the command." ], "previous_source": "", "target": [ "" ], "id_hash": 2032737123643161951, "content_hash": 2032737123643161951, "location": "../../en/loading_data.rst:174", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 49, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://weblate.osgeo.org/api/units/104375/?format=api", "priority": 100, "id": 2360695, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=9c35bba4e07ffd5f", "url": "https://weblate.osgeo.org/api/units/2360695/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.990844Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/uk/?format=api", "source": [ "The executable program! It reads the source data file, and emits SQL which can be directed to a file or piped to :file:`psql` to load directly into the database." ], "previous_source": "", "target": [ "" ], "id_hash": -553712046321447667, "content_hash": -553712046321447667, "location": "../../en/loading_data.rst:180", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 50, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://weblate.osgeo.org/api/units/104377/?format=api", "priority": 100, "id": 2360696, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/uk/?checksum=7850d1d3db27cd0d", "url": "https://weblate.osgeo.org/api/units/2360696/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-08-12T18:26:22.993423Z" } ] }