postgis-workshop/loading_data — Chinese (Simplified) @ OSGeo Weblate: Finally, if you have installed `HomeBrew <https://brew.sh/>`

Translation

English

Chinese (Simplified)

Needs editing

Skip

	English	Chinese (Simplified)	Actions
	Loading the Backup File	加载备份文件
	In the PgAdmin browser, right-click on the nyc database icon, and then select the Restore... option.	在 PgAdmin 浏览器中，右键单击 nyc 数据库图标，然后选择还原... 选项。
	Browse to the location of your workshop data data directory, and select the :file:`nyc_data.backup` file.	浏览到您的工作数据目录位置，然后选择 :file:`nyc_data.backup` 文件。
	Click on the Restore options tab, scroll down to the Do not save section and toggle Owner to Yes.	点击还原选项标签，滚动到不保存部分，将所有者切换到是。
	Click the Restore button. The database restore should run to completion without errors.	点击还原按钮。数据库还原应该会在没有错误的情况下完成。
	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.	在加载完成后，右键单击nyc数据库，然后选择刷新选项以更新客户端有关数据库中存在哪些表的信息。
	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.	如果您想要练习从本地空间格式加载数据，而不是使用刚刚介绍的PostgreSQL数据库备份文件，接下来的几个部分将引导您通过使用各种命令行工具和QGIS DbManager加载。请注意，如果您已经使用pgAdmin加载了数据，可以跳过这些部分。
	Loading with ogr2ogr	使用ogr2ogr加载数据
	:file:`ogr2ogr` is a commandline utility for converting data between GIS data formats, including common file formats and common spatial databases.	:file:`ogr2ogr`是一个命令行实用程序，用于在GIS数据格式之间进行转换，包括常见文件格式和常见空间数据库。
	Windows:	Windows:
	Builds of ogr2ogr can be downloaded from `GIS Internals <https://www.gisinternals.com/release.php>`_.	可以从`GIS Internals <https://www.gisinternals.com/release.php>`_下载ogr2ogr的构建版本。
	ogr2ogr is included as part of `QGIS Install <https://qgis.org/en/site/forusers/download.html>`_ and accessible via OSGeo4W Shell -	ogr2ogr包含在`QGIS安装包 <https://qgis.org/en/site/forusers/download.html>`_中，并可以通过OSGeo4W Shell访问 -
	Builds of ogr2ogr can be downloaded from `MS4W <https://ms4w.com/download.html>`_.	ogr2ogr的构建版本可以从`MS4W <https://ms4w.com/download.html>`_下载。
	MacOS:	MacOS:
	If you installed `Postgres.app <https://postgresapp.com/>`_, then you will find :file:`ogr2ogr` in the :file:`/Applications/Postgres.app/Contents/Versions/*/bin` directory.	如果您安装了`Postgres.app <https://postgresapp.com/>`_，那么您会在 :file:`/Applications/Postgres.app/Contents/Versions/*/bin` 目录中找到 :file:`ogr2ogr`。
	Finally, if you have installed `HomeBrew <https://brew.sh/>`_ you can install the gdal package to get access to :file:`ogr2ogr`	最后，如果您已安装了`HomeBrew <https://brew.sh/>`_ 您可以安装gdal软件包以获取对 :file:`ogr2ogr` 的访问。
	Linux:	Linux:
	If you installed QGIS from packages, :file:`ogr2ogr` should be installed and on your PATH already as part of the gdal or libgdal* packages.	如果您从软件包安装了QGIS，:file:`ogr2ogr`应该已经安装并在您的PATH上，作为gdal或libgdal软件包的一部分。
	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:	PostGIS的工作数据目录包含一个:file:`2000/`子目录，其中包含来自2000年人口普查的shape文件，这些文件已被2010年人口普查的数据所淘汰。我们可以使用这些文件来练习数据加载，以避免与使用备份文件已加载的数据发生名称冲突。在执行这些说明时，请确保在shell中位于:file:`2000/`子目录中：
	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.	与在连接字符串中传递密码不同，我们将密码放在环境中，这样在运行命令时它不会在进程列表中可见。
	Note that on Windows, you will need to use ``set`` instead of ``export``.	请注意在Windows上，您将需要使用`set`而不是`export`。
	For more visual clarity, these lines are displayed with ``\``, but they should be written in one line on your shell.	为了更清晰可见，这些行使用``\``显示，但在您的shell上应该写在一行上。
	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.	:file:`ogr2ogr`有大量的选项，而我们在这里只使用了其中的一小部分。下面是对该命令的逐行解释。
	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.	可执行文件的名称！您可能需要确保可执行文件的位置在您的`PATH`中，或者根据您的设置使用完整的可执行文件路径。
	The nln option stands for "new layer name", and sets the table name that will be created in the target database.	nln选项代表“新图层名称”，并设置将在目标数据库中创建的表名称。
	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.	nlt选项代表“新图层类型”。特别是对于shape文件输入，新图层类型通常是“多部分几何”，因此系统需要事先告知使用“MultiPolygon”而不是“Polygon”作为几何类型。
	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.	lco选项代表“图层创建选项”。不同的驱动程序具有不同的创建选项，我们在这里使用了`PostgreSQL驱动程序 <https://gdal.org/drivers/vector/pg.html>`_的三个选项。
	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.	GEOMETRY_NAME设置几何列的列名。我们倾向于使用"geom"而不是默认值，以使我们的表与研讨会中的标准列名匹配。
	FID sets the primary key column name. Again we prefer "gid" which is the standard used in the workshop.	FID设置主键列名。同样，我们更喜欢使用"gid"，这是研讨会中使用的标准。
	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.	PRECISION控制数字字段在数据库中的表示方式。在加载shape文件时，默认情况下使用数据库的“numeric”类型，这更精确，但有时比“integer”和“double precision”等简单数值类型更难处理。我们使用"NO"来关闭"numeric"类型。
	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).	在 :file:`ogr2ogr` 中，参数的顺序大致是：可执行文件，然后是选项，然后是目标位置，然后是源位置。因此，这是目标，我们PostgreSQL数据库的连接字符串。 "Pg:" 部分是驱动程序名称，然后 `connection string <https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING>`_ 包含在引号中（因为它可能包含嵌入的空格）。

Loading…

zcw5

Translation changed

English

Chinese (Simplified) 1 character edited Current translation Translated

3 months ago

zcw5

Translation added

English

Chinese (Simplified) 82 characters edited Translated

3 months ago

None

String updated in the repository

English

Chinese (Simplified) 0 characters edited Empty

3 months ago

Browse all string changes

Things to check

Mismatched full stop

Source and translation do not both end with a full stop

Reset

Glossary

English	Chinese (Simplified)
GDAL	GDAL	glossary 1
GDAL，地理数据抽象库，用来读写矢量、栅格数据
Geospatial Data Abstraction Library used for reading and writing vector and raster data

String information

Source string location

../../en/loading_data.rst:59

String age

3 months ago

Last updated

3 months ago

Source string age

2 years ago

Translation file

postgis-intro/sources/locale/zh_Hans/LC_MESSAGES/loading_data.po, string 19

	English	Chinese (Simplified)	Actions
	Loading the Backup File	加载备份文件
	In the PgAdmin browser, right-click on the nyc database icon, and then select the Restore... option.	在 PgAdmin 浏览器中，右键单击 nyc 数据库图标，然后选择还原... 选项。
	Browse to the location of your workshop data data directory, and select the :file:`nyc_data.backup` file.	浏览到您的工作数据目录位置，然后选择 :file:`nyc_data.backup` 文件。
	Click on the Restore options tab, scroll down to the Do not save section and toggle Owner to Yes.	点击还原选项标签，滚动到不保存部分，将所有者切换到是。
	Click the Restore button. The database restore should run to completion without errors.	点击还原按钮。数据库还原应该会在没有错误的情况下完成。
	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.	在加载完成后，右键单击nyc数据库，然后选择刷新选项以更新客户端有关数据库中存在哪些表的信息。
	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.	如果您想要练习从本地空间格式加载数据，而不是使用刚刚介绍的PostgreSQL数据库备份文件，接下来的几个部分将引导您通过使用各种命令行工具和QGIS DbManager加载。请注意，如果您已经使用pgAdmin加载了数据，可以跳过这些部分。
	Loading with ogr2ogr	使用ogr2ogr加载数据
	:file:`ogr2ogr` is a commandline utility for converting data between GIS data formats, including common file formats and common spatial databases.	:file:`ogr2ogr`是一个命令行实用程序，用于在GIS数据格式之间进行转换，包括常见文件格式和常见空间数据库。
	Windows:	Windows:
	Builds of ogr2ogr can be downloaded from `GIS Internals <https://www.gisinternals.com/release.php>`_.	可以从`GIS Internals <https://www.gisinternals.com/release.php>`_下载ogr2ogr的构建版本。
	ogr2ogr is included as part of `QGIS Install <https://qgis.org/en/site/forusers/download.html>`_ and accessible via OSGeo4W Shell -	ogr2ogr包含在`QGIS安装包 <https://qgis.org/en/site/forusers/download.html>`_中，并可以通过OSGeo4W Shell访问 -
	Builds of ogr2ogr can be downloaded from `MS4W <https://ms4w.com/download.html>`_.	ogr2ogr的构建版本可以从`MS4W <https://ms4w.com/download.html>`_下载。
	MacOS:	MacOS:
	If you installed `Postgres.app <https://postgresapp.com/>`_, then you will find :file:`ogr2ogr` in the :file:`/Applications/Postgres.app/Contents/Versions/*/bin` directory.	如果您安装了`Postgres.app <https://postgresapp.com/>`_，那么您会在 :file:`/Applications/Postgres.app/Contents/Versions/*/bin` 目录中找到 :file:`ogr2ogr`。
	Finally, if you have installed `HomeBrew <https://brew.sh/>`_ you can install the gdal package to get access to :file:`ogr2ogr`	最后，如果您已安装了`HomeBrew <https://brew.sh/>`_ 您可以安装gdal软件包以获取对 :file:`ogr2ogr` 的访问。
	Linux:	Linux:
	If you installed QGIS from packages, :file:`ogr2ogr` should be installed and on your PATH already as part of the gdal or libgdal* packages.	如果您从软件包安装了QGIS，:file:`ogr2ogr`应该已经安装并在您的PATH上，作为gdal或libgdal软件包的一部分。
	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:	PostGIS的工作数据目录包含一个:file:`2000/`子目录，其中包含来自2000年人口普查的shape文件，这些文件已被2010年人口普查的数据所淘汰。我们可以使用这些文件来练习数据加载，以避免与使用备份文件已加载的数据发生名称冲突。在执行这些说明时，请确保在shell中位于:file:`2000/`子目录中：
	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.	与在连接字符串中传递密码不同，我们将密码放在环境中，这样在运行命令时它不会在进程列表中可见。
	Note that on Windows, you will need to use ``set`` instead of ``export``.	请注意在Windows上，您将需要使用`set`而不是`export`。
	For more visual clarity, these lines are displayed with ``\``, but they should be written in one line on your shell.	为了更清晰可见，这些行使用``\``显示，但在您的shell上应该写在一行上。
	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.	:file:`ogr2ogr`有大量的选项，而我们在这里只使用了其中的一小部分。下面是对该命令的逐行解释。
	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.	可执行文件的名称！您可能需要确保可执行文件的位置在您的`PATH`中，或者根据您的设置使用完整的可执行文件路径。
	The nln option stands for "new layer name", and sets the table name that will be created in the target database.	nln选项代表“新图层名称”，并设置将在目标数据库中创建的表名称。
	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.	nlt选项代表“新图层类型”。特别是对于shape文件输入，新图层类型通常是“多部分几何”，因此系统需要事先告知使用“MultiPolygon”而不是“Polygon”作为几何类型。
	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.	lco选项代表“图层创建选项”。不同的驱动程序具有不同的创建选项，我们在这里使用了`PostgreSQL驱动程序 <https://gdal.org/drivers/vector/pg.html>`_的三个选项。
	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.	GEOMETRY_NAME设置几何列的列名。我们倾向于使用"geom"而不是默认值，以使我们的表与研讨会中的标准列名匹配。
	FID sets the primary key column name. Again we prefer "gid" which is the standard used in the workshop.	FID设置主键列名。同样，我们更喜欢使用"gid"，这是研讨会中使用的标准。
	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.	PRECISION控制数字字段在数据库中的表示方式。在加载shape文件时，默认情况下使用数据库的“numeric”类型，这更精确，但有时比“integer”和“double precision”等简单数值类型更难处理。我们使用"NO"来关闭"numeric"类型。
	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).	在 :file:`ogr2ogr` 中，参数的顺序大致是：可执行文件，然后是选项，然后是目标位置，然后是源位置。因此，这是目标，我们PostgreSQL数据库的连接字符串。 "Pg:" 部分是驱动程序名称，然后 `connection string <https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING>`_ 包含在引号中（因为它可能包含嵌入的空格）。