PostGIS Requirements
The PostgreSQL database server and PostGIS spatial extension should be installed by an administrator. Network connections and authentication requires editing of the pg_hba.conf configuration file. For information on configuring PostgreSQL and PostGIS please refer to the product documentation:
For requirements on spatial tables, PostGIS will be very similar to SQL Server Spatial.
A spatial table should have a primary key defined to ensure rows can be identified uniquely. The preferred mechanism is to define the primary key column as IDENTITY.
-
If the primary key column has an IDENTITY specification, it will be used for ID generation.
-
If the primary key does not have an IDENTITY specification then:
It is preferred that the table contain rows of like data type.
| For a numeric primary key OpenCities Map will query for the maximum value and increment that by one when adding a new record . |
| For other column types OpenCities Map will attempt to store the UUID that XFM uses internally. |