Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/loading_data/en/units/?format=api
{ "count": 73, "next": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/units/?format=api&page=2", "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "Loading spatial data" ], "previous_source": "", "target": [ "Loading spatial data" ], "id_hash": -9072465843247242629, "content_hash": -9072465843247242629, "location": "../../en/loading_data.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": 3, "source_unit": "https://weblate.osgeo.org/api/units/104115/?format=api", "priority": 100, "id": 104115, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=021820623062227b", "url": "https://weblate.osgeo.org/api/units/104115/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:56.829007Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "Supported by a wide variety of libraries and applications, PostGIS provides many options for loading data." ], "previous_source": "", "target": [ "Supported by a wide variety of libraries and applications, PostGIS provides many options for loading data." ], "id_hash": 759990065547533707, "content_hash": 759990065547533707, "location": "../../en/loading_data.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": 16, "source_unit": "https://weblate.osgeo.org/api/units/104127/?format=api", "priority": 100, "id": 104127, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=8a8c06f021c95d8b", "url": "https://weblate.osgeo.org/api/units/104127/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:56.860453Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "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." ], "id_hash": -2742854678331041612, "content_hash": -2742854678331041612, "location": "../../en/loading_data.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": 26, "source_unit": "https://weblate.osgeo.org/api/units/104129/?format=api", "priority": 100, "id": 104129, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=59ef6c33cb8f58b4", "url": "https://weblate.osgeo.org/api/units/104129/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:56.884119Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "Loading the Backup File" ], "previous_source": "", "target": [ "Loading the Backup File" ], "id_hash": -2912740276573230250, "content_hash": -2912740276573230250, "location": "../../en/loading_data.rst:12", "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": 4, "source_unit": "https://weblate.osgeo.org/api/units/104131/?format=api", "priority": 100, "id": 104131, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=5793de269be12b56", "url": "https://weblate.osgeo.org/api/units/104131/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:56.906887Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "In the PgAdmin browser, **right-click** on the **nyc** database icon, and then select the **Restore...** option." ], "previous_source": "", "target": [ "In the PgAdmin browser, **right-click** on the **nyc** database icon, and then select the **Restore...** option." ], "id_hash": -6206493694140551957, "content_hash": -6206493694140551957, "location": "../../en/loading_data.rst:14", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 5, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 16, "source_unit": "https://weblate.osgeo.org/api/units/104133/?format=api", "priority": 100, "id": 104133, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=29de1ade5c0ceceb", "url": "https://weblate.osgeo.org/api/units/104133/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:56.929925Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "Browse to the location of your workshop data data directory, and select the :file:`nyc_data.backup` file." ], "previous_source": "", "target": [ "Browse to the location of your workshop data data directory, and select the :file:`nyc_data.backup` file." ], "id_hash": 7087935383164883599, "content_hash": 7087935383164883599, "location": "../../en/loading_data.rst:19", "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": 15, "source_unit": "https://weblate.osgeo.org/api/units/104135/?format=api", "priority": 100, "id": 104135, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=e25d67ad7077128f", "url": "https://weblate.osgeo.org/api/units/104135/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:56.957626Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "Click on the **Restore options** tab, scroll down to the **Do not save** section and toggle **Owner** to **Yes**." ], "id_hash": -5638883401942114228, "content_hash": -5638883401942114228, "location": "../../en/loading_data.rst:24", "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": 19, "source_unit": "https://weblate.osgeo.org/api/units/104137/?format=api", "priority": 100, "id": 104137, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=31bea96c0964e04c", "url": "https://weblate.osgeo.org/api/units/104137/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:56.982717Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "Click the **Restore** button. The database restore should run to completion without errors." ], "previous_source": "", "target": [ "Click the **Restore** button. The database restore should run to completion without errors." ], "id_hash": -2443561732028858471, "content_hash": -2443561732028858471, "location": "../../en/loading_data.rst:29", "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": 13, "source_unit": "https://weblate.osgeo.org/api/units/104139/?format=api", "priority": 100, "id": 104139, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=5e16b98d1fae7f99", "url": "https://weblate.osgeo.org/api/units/104139/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.007238Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "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." ], "id_hash": 6449845381453981977, "content_hash": 6449845381453981977, "location": "../../en/loading_data.rst:34", "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": 27, "source_unit": "https://weblate.osgeo.org/api/units/104141/?format=api", "priority": 100, "id": 104141, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=d9827433a1c22919", "url": "https://weblate.osgeo.org/api/units/104141/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.032117Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "Loading with ogr2ogr" ], "previous_source": "", "target": [ "Loading with ogr2ogr" ], "id_hash": -6694681638122310255, "content_hash": -6694681638122310255, "location": "../../en/loading_data.rst:48", "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": 3, "source_unit": "https://weblate.osgeo.org/api/units/104142/?format=api", "priority": 100, "id": 104142, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=2317b6852363b591", "url": "https://weblate.osgeo.org/api/units/104142/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.056178Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ ":file:`ogr2ogr` is a commandline utility for converting data between GIS data formats, including common file formats and common spatial databases." ], "id_hash": -5935547584329385180, "content_hash": -5935547584329385180, "location": "../../en/loading_data.rst:50", "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": 20, "source_unit": "https://weblate.osgeo.org/api/units/104143/?format=api", "priority": 100, "id": 104143, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=2da0b2eb809e7b24", "url": "https://weblate.osgeo.org/api/units/104143/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.078977Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "**Windows**:" ], "previous_source": "", "target": [ "**Windows**:" ], "id_hash": 5601705313362125601, "content_hash": 5601705313362125601, "location": "../../en/loading_data.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": 1, "source_unit": "https://weblate.osgeo.org/api/units/104149/?format=api", "priority": 100, "id": 104149, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=cdbd414dab5e2321", "url": "https://weblate.osgeo.org/api/units/104149/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.102820Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "Builds of ogr2ogr can be downloaded from `GIS Internals <https://www.gisinternals.com/release.php>`_." ], "previous_source": "", "target": [ "Builds of ogr2ogr can be downloaded from `GIS Internals <https://www.gisinternals.com/release.php>`_." ], "id_hash": -3608503736455876081, "content_hash": -3608503736455876081, "location": "../../en/loading_data.rst:53", "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": 10, "source_unit": "https://weblate.osgeo.org/api/units/104163/?format=api", "priority": 100, "id": 104163, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=4dec04f869e0b20f", "url": "https://weblate.osgeo.org/api/units/104163/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.126019Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "Builds of ogr2ogr can be downloaded from `MS4W <https://ms4w.com/download.html>`_." ], "previous_source": "", "target": [ "Builds of ogr2ogr can be downloaded from `MS4W <https://ms4w.com/download.html>`_." ], "id_hash": 2948296201389703629, "content_hash": 2948296201389703629, "location": "../../en/loading_data.rst:55", "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": 9, "source_unit": "https://weblate.osgeo.org/api/units/104170/?format=api", "priority": 100, "id": 104170, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=a8ea73c6407781cd", "url": "https://weblate.osgeo.org/api/units/104170/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.179872Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "**MacOS**:" ], "previous_source": "", "target": [ "**MacOS**:" ], "id_hash": 8663547209998100133, "content_hash": 8663547209998100133, "location": "../../en/loading_data.rst:59", "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": 1, "source_unit": "https://weblate.osgeo.org/api/units/104171/?format=api", "priority": 100, "id": 104171, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=f83b1a493ac366a5", "url": "https://weblate.osgeo.org/api/units/104171/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.210054Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "If you installed `Postgres.app <https://postgresapp.com/>`_, then you will find :file:`ogr2ogr` in the :file:`/Applications/Postgres.app/Contents/Versions/*/bin` directory." ], "id_hash": 774714957819633415, "content_hash": 774714957819633415, "location": "../../en/loading_data.rst:58", "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": 14, "source_unit": "https://weblate.osgeo.org/api/units/104172/?format=api", "priority": 100, "id": 104172, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=8ac0572647055f07", "url": "https://weblate.osgeo.org/api/units/104172/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.238389Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "Finally, if you have installed `HomeBrew <https://brew.sh/>`_ you can install the **gdal** package to get access to :file:`ogr2ogr`" ], "id_hash": 7992080959024426500, "content_hash": 7992080959024426500, "location": "../../en/loading_data.rst:59", "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": 18, "source_unit": "https://weblate.osgeo.org/api/units/104177/?format=api", "priority": 100, "id": 104177, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=eee99349d2d06e04", "url": "https://weblate.osgeo.org/api/units/104177/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.286186Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "**Linux**:" ], "previous_source": "", "target": [ "**Linux**:" ], "id_hash": 2404124918020114617, "content_hash": 2404124918020114617, "location": "../../en/loading_data.rst:62", "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": 1, "source_unit": "https://weblate.osgeo.org/api/units/104190/?format=api", "priority": 100, "id": 104190, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=a15d2ae0164108b9", "url": "https://weblate.osgeo.org/api/units/104190/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.310576Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "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." ], "id_hash": 3951570453447955659, "content_hash": 3951570453447955659, "location": "../../en/loading_data.rst:90", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 104222, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=b6d6cc641eb1d4cb", "url": "https://weblate.osgeo.org/api/units/104222/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.388868Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "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." ], "id_hash": -8967689530265040306, "content_hash": -8967689530265040306, "location": "../../en/loading_data.rst:71", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 104224, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=038c5de294900a4e", "url": "https://weblate.osgeo.org/api/units/104224/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.418435Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "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." ], "id_hash": 1043319911366414569, "content_hash": 1043319911366414569, "location": "../../en/loading_data.rst:96", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 104226, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=8e7a9dee801650e9", "url": "https://weblate.osgeo.org/api/units/104226/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.443211Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "The **nln** option stands for \"new layer name\", and sets the table name that will be created in the target database." ], "id_hash": 8479344140564378527, "content_hash": 8479344140564378527, "location": "../../en/loading_data.rst:102", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 104228, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=f5acae9202a1339f", "url": "https://weblate.osgeo.org/api/units/104228/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.467067Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "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." ], "id_hash": 1645394180968707246, "content_hash": 1645394180968707246, "location": "../../en/loading_data.rst:108", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 104230, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=96d59d4a382274ae", "url": "https://weblate.osgeo.org/api/units/104230/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.490586Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "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." ], "id_hash": -2204656181998831273, "content_hash": -2204656181998831273, "location": "../../en/loading_data.rst:116", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 104242, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=61677ce21c173957", "url": "https://weblate.osgeo.org/api/units/104242/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.514774Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "**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." ], "id_hash": 5519191851440735961, "content_hash": 5519191851440735961, "location": "../../en/loading_data.rst:118", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 104258, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=cc981bbf385b06d9", "url": "https://weblate.osgeo.org/api/units/104258/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.538192Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "**FID** sets the primary key column name. Again we prefer \"gid\" which is the standard used in the workshop." ], "id_hash": -5403105051369115059, "content_hash": -5403105051369115059, "location": "../../en/loading_data.rst:119", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 104274, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=350450952906724d", "url": "https://weblate.osgeo.org/api/units/104274/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.562506Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "**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." ], "id_hash": -5005069551392182382, "content_hash": -5005069551392182382, "location": "../../en/loading_data.rst:120", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 104281, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=3a8a6bc2d1252f92", "url": "https://weblate.osgeo.org/api/units/104281/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.587052Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "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)." ], "id_hash": -2750497074036533304, "content_hash": -2750497074036533304, "location": "../../en/loading_data.rst:126", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 104284, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=59d4457be24d17c8", "url": "https://weblate.osgeo.org/api/units/104284/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.612313Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "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." ], "id_hash": -1726745731386467962, "content_hash": -1726745731386467962, "location": "../../en/loading_data.rst:132", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 104287, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=68095de7ef499986", "url": "https://weblate.osgeo.org/api/units/104287/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.637446Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "Shapefiles? What's that?" ], "previous_source": "", "target": [ "Shapefiles? What's that?" ], "id_hash": 7580432013303277714, "content_hash": 7580432013303277714, "location": "../../en/loading_data.rst:136", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 104290, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=e9331ac0d4f0e892", "url": "https://weblate.osgeo.org/api/units/104290/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.660890Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "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." ], "id_hash": -2117083613669674300, "content_hash": -2117083613669674300, "location": "../../en/loading_data.rst:138", "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": 58, "source_unit": "https://weblate.osgeo.org/api/units/104293/?format=api", "priority": 100, "id": 104293, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=629e9bab8f6b32c4", "url": "https://weblate.osgeo.org/api/units/104293/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.683971Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "Mandatory files:" ], "previous_source": "", "target": [ "Mandatory files:" ], "id_hash": 4885761884402372043, "content_hash": 4885761884402372043, "location": "../../en/loading_data.rst:140", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 104300, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=c3cdb68c48f24dcb", "url": "https://weblate.osgeo.org/api/units/104300/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.707922Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "``.shp``—shape format; the feature geometry itself" ], "previous_source": "", "target": [ "``.shp``—shape format; the feature geometry itself" ], "id_hash": -2612437880557416401, "content_hash": -2612437880557416401, "location": "../../en/loading_data.rst:142", "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": 6, "source_unit": "https://weblate.osgeo.org/api/units/104315/?format=api", "priority": 100, "id": 104315, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=5bbec196c399d02f", "url": "https://weblate.osgeo.org/api/units/104315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.730714Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "``.shx``—shape index format; a positional index of the feature geometry" ], "previous_source": "", "target": [ "``.shx``—shape index format; a positional index of the feature geometry" ], "id_hash": 3384144049530428449, "content_hash": 3384144049530428449, "location": "../../en/loading_data.rst:143", "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": 10, "source_unit": "https://weblate.osgeo.org/api/units/104332/?format=api", "priority": 100, "id": 104332, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=aef6e51545035c21", "url": "https://weblate.osgeo.org/api/units/104332/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.755365Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "``.dbf``—attribute format; columnar attributes for each shape, in dBase III" ], "previous_source": "", "target": [ "``.dbf``—attribute format; columnar attributes for each shape, in dBase III" ], "id_hash": 4159943631333789392, "content_hash": 4159943631333789392, "location": "../../en/loading_data.rst:144", "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": 10, "source_unit": "https://weblate.osgeo.org/api/units/104344/?format=api", "priority": 100, "id": 104344, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=b9bb16b13f4c8ed0", "url": "https://weblate.osgeo.org/api/units/104344/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.780317Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "Optional files include:" ], "previous_source": "", "target": [ "Optional files include:" ], "id_hash": 5676408518765536455, "content_hash": 5676408518765536455, "location": "../../en/loading_data.rst:146", "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": 3, "source_unit": "https://weblate.osgeo.org/api/units/104346/?format=api", "priority": 100, "id": 104346, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=cec6a779110564c7", "url": "https://weblate.osgeo.org/api/units/104346/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.805287Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "``.prj``—projection format; the coordinate system and projection information, a plain text file describing the projection using well-known text format" ], "id_hash": -8754532052531909367, "content_hash": -8754532052531909367, "location": "../../en/loading_data.rst:148", "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": 19, "source_unit": "https://weblate.osgeo.org/api/units/104348/?format=api", "priority": 100, "id": 104348, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=0681a77b52106d09", "url": "https://weblate.osgeo.org/api/units/104348/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.831083Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "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." ], "id_hash": 3347748918530221649, "content_hash": 3347748918530221649, "location": "../../en/loading_data.rst:150", "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/104350/?format=api", "priority": 100, "id": 104350, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=ae7597e77e312651", "url": "https://weblate.osgeo.org/api/units/104350/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.859027Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "Loading with shp2pgsql" ], "previous_source": "", "target": [ "Loading with shp2pgsql" ], "id_hash": -3089692673797412648, "content_hash": -3089692673797412648, "location": "../../en/loading_data.rst:154", "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": 3, "source_unit": "https://weblate.osgeo.org/api/units/104352/?format=api", "priority": 100, "id": 104352, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=551f34e2112da8d8", "url": "https://weblate.osgeo.org/api/units/104352/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.884255Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "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." ], "id_hash": 7907709145924390249, "content_hash": 7907709145924390249, "location": "../../en/loading_data.rst:156", "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": 55, "source_unit": "https://weblate.osgeo.org/api/units/104353/?format=api", "priority": 100, "id": 104353, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=edbdd39245ee4d69", "url": "https://weblate.osgeo.org/api/units/104353/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.907482Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "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." ], "id_hash": -1722047684347996426, "content_hash": -1722047684347996426, "location": "../../en/loading_data.rst:158", "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": 50, "source_unit": "https://weblate.osgeo.org/api/units/104371/?format=api", "priority": 100, "id": 104371, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=681a0ec1402756f6", "url": "https://weblate.osgeo.org/api/units/104371/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.945129Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "Here is an example invocation, loading the same data as before:" ], "previous_source": "", "target": [ "Here is an example invocation, loading the same data as before:" ], "id_hash": 2706343583823964205, "content_hash": 2706343583823964205, "location": "../../en/loading_data.rst:160", "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": 11, "source_unit": "https://weblate.osgeo.org/api/units/104373/?format=api", "priority": 100, "id": 104373, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=a58edd2691fc282d", "url": "https://weblate.osgeo.org/api/units/104373/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:57.976890Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "Here is a line-by-line explanation of the command." ], "previous_source": "", "target": [ "Here is a line-by-line explanation of the command." ], "id_hash": 2032737123643161951, "content_hash": 2032737123643161951, "location": "../../en/loading_data.rst:174", "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": 8, "source_unit": "https://weblate.osgeo.org/api/units/104375/?format=api", "priority": 100, "id": 104375, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=9c35bba4e07ffd5f", "url": "https://weblate.osgeo.org/api/units/104375/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:58.004283Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?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": [ "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." ], "id_hash": -553712046321447667, "content_hash": -553712046321447667, "location": "../../en/loading_data.rst:180", "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": 29, "source_unit": "https://weblate.osgeo.org/api/units/104377/?format=api", "priority": 100, "id": 104377, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=7850d1d3db27cd0d", "url": "https://weblate.osgeo.org/api/units/104377/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:58.030463Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "The **D** flag tells the program to generate \"dump format\" which is much faster to load than the default \"insert format\"." ], "previous_source": "", "target": [ "The **D** flag tells the program to generate \"dump format\" which is much faster to load than the default \"insert format\"." ], "id_hash": 5826908742750426474, "content_hash": 5826908742750426474, "location": "../../en/loading_data.rst:186", "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": 21, "source_unit": "https://weblate.osgeo.org/api/units/104379/?format=api", "priority": 100, "id": 104379, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=d0dd56a11641d56a", "url": "https://weblate.osgeo.org/api/units/104379/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:58.054671Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "The **I** flag tells the program to create a spatial index on the table after loading is complete." ], "previous_source": "", "target": [ "The **I** flag tells the program to create a spatial index on the table after loading is complete." ], "id_hash": 2318966129168132529, "content_hash": 2318966129168132529, "location": "../../en/loading_data.rst:192", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 52, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://weblate.osgeo.org/api/units/104381/?format=api", "priority": 100, "id": 104381, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=a02e9f68773aa9b1", "url": "https://weblate.osgeo.org/api/units/104381/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:58.077718Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "The **s** flag tells the program what the \"spatial reference identifier (SRID)\" of the data is. The source data for this workshop is all in \"UTM 18\", for which the SRID is **26918** (see below)." ], "previous_source": "", "target": [ "The **s** flag tells the program what the \"spatial reference identifier (SRID)\" of the data is. The source data for this workshop is all in \"UTM 18\", for which the SRID is **26918** (see below)." ], "id_hash": 2149002810293500626, "content_hash": 2149002810293500626, "location": "../../en/loading_data.rst:198", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 53, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://weblate.osgeo.org/api/units/104394/?format=api", "priority": 100, "id": 104394, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=9dd2caab88dc3ad2", "url": "https://weblate.osgeo.org/api/units/104394/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:58.100979Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "The source shape file to read." ], "previous_source": "", "target": [ "The source shape file to read." ], "id_hash": -1360285370234199356, "content_hash": -1360285370234199356, "location": "../../en/loading_data.rst:205", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 54, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://weblate.osgeo.org/api/units/104400/?format=api", "priority": 100, "id": 104400, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=6d1f4ba9b207a2c4", "url": "https://weblate.osgeo.org/api/units/104400/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:58.123895Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "The table name to use when creating the destination table." ], "previous_source": "", "target": [ "The table name to use when creating the destination table." ], "id_hash": -4344215127782838333, "content_hash": -4344215127782838333, "location": "../../en/loading_data.rst:211", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 55, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/104402/?format=api", "priority": 100, "id": 104402, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=43b63f5ba0a02fc3", "url": "https://weblate.osgeo.org/api/units/104402/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:58.146857Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/loading_data/en/?format=api", "source": [ "The utility program is generating a stream of SQL. The \"|\" operator takes that stream and uses it as input to the :file:`psql` database terminal program. The arguments to :file:`psql` are just the connection string for the destination database." ], "previous_source": "", "target": [ "The utility program is generating a stream of SQL. The \"|\" operator takes that stream and uses it as input to the :file:`psql` database terminal program. The arguments to :file:`psql` are just the connection string for the destination database." ], "id_hash": 4595295397999040406, "content_hash": 4595295397999040406, "location": "../../en/loading_data.rst:217", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 56, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://weblate.osgeo.org/api/units/104404/?format=api", "priority": 100, "id": 104404, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/loading_data/en/?checksum=bfc5c4d14bb85796", "url": "https://weblate.osgeo.org/api/units/104404/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:58.170334Z" } ] }