[New Feature of ArcGIS 10.2] ArcGIS 10.2 released PostgreSQL native data as a key service

1. ArcGIS 10.2 supports native data publishing as a factor Server

Is there a need to publish your existing spatial data as a factor service? Is there a need to display non-ESRI data as a service on the Web end?
ArcGIS 10.2 for Server adds this capability. ArcGIS 10.2 for server can publish the spatial data in the native database as a factor service.
We all know that the relational databases currently support spatial data, such as PostgreSQL pg_geometry, Oracle sdo_geometry, and SQL Server geometry, if user data is already in these formats, how can we publish it as a key service?
ESRI supported the element service in ArcGIS 10.0. Because the element Service provides the online editing function, it is favored by many users. However, there is a condition for the release of the element service, that is, the data must be stored in the SDE database. If the user's spatial data is already the space data type of the native database, to publish the element service, we need to transfer the data to the SDE database.
Of course, ESRI will also consider user needs and respond accordingly to user needs. ArcGIS 10.2 for server can directly expose such native spatial data as a factor service, in this way, data conversion and other operations are saved. what's even more exciting is that such capabilities do not require the support of Sde.
The following uses the PostgreSQL database as an example.
To support spatial data, PostgreSQL requires an extension-postgisThis extension is similar to Oracle spatial. Postgis is a product developed by refractions research. It is used to add support for postgis spatial data types for PostgreSQL databases. Postgis complies with the simple element specification of the Structured Query Language (SQL) of the Open Geospatial Alliance (OGC. It uses OGC to familiarize itself with binary
(WKB) and recognizable text (WKT) indicate ry. In fact, postgis adds a space type to PostgreSQL.

2. Install postgis

There are two ways to install postgis: 1. It can be supported from the connector for server (9.0 series, 9.1 series and 9.2 series of postgresql); 2. It can also be installed on the stack that comes with PostgreSQL.
Builder. Here I am the latter.

2.1 Open stack Builder

2.2 select space extension. You can select other auxiliary functions as needed.

2.3 select the download directory

2.4 select the check box before creating a spatial database

Wait a moment. After the installation is complete, the template_postgis_20 and Other templates and postgis20 databases will be created in PostgreSQL as follows:

3. Data Preparation

Postgis provides a tool to convert shape data into pg_geometry. However, this tool is not used here, but to convert data through ArcMap, arcMap allows you to create element classes, import data, and export data in a PostgreSQL database. These functions greatly simplify data conversion and facilitate data conversion.
Before operating data, you must firstCreate ipvs Mode.

Next, use direct connection to connect to the PostgreSQL database and connect to it in the catalog directory on the Right of ArcMap.

At this time, I copied a polygon data from Geodatabase TO THE postgis20 database as the native space data in the database. Then, load it into ArcMap and save the map document.

After adding the database, we can see the data in ipvssql, as shown in.

4. Release element services

When publishing, the database must be registered and can be set in the server attribute in advance.

Select Register database. In the displayed dialog box, name the database on the left. Then, use the import method to find the connected database and select it, as shown in the figure on the right. Click OK.

Now, you can release the element service. Under the fiel menu, find share as and select service.

Author: Little drunk, ivorymjl