How is a feature class stored in PostgreSQL?
Feature classes a geodatabase in PostgreSQL databases use one of two geometry storage types: ST_Geometry or PostGIS geometry. All feature classes have a base table (also called a business table), which stores attribute information, an Object ID, and a Shape field.
How to access St geometry column in PostgreSQL?
Use ArcGIS to access PostgreSQL tables with ST_Geometry columns. If you use SQL to create a table with an ST_Geometry column, you can access the data through SQL, custom third-party applications, and ArcGIS. When you connect to the database from ArcGIS, you can view, perform analyses, or load data into tables that contain an ST_Geometry column.
How to create feature classes in PostGIS database?
If you install PostGIS and your database is created using the PostGIS template, you can use its extended well-known text (EWKT) and extended well-known binary (EWKB) spatial types to create feature classes. When you use this, a geometry column is added to the business table to store the feature geometry.
Can a feature class be renamed in PG _ geometry?
Because there is no PostGIS function to update the table name stored in the public.geometry_columns table, you cannot rename feature classes created using PG_GEOMETRY storage. Renaming the feature class would leave an orphaned row in the public.geometry_storage table.
Where does the St geometry column go in PostgreSQL?
By default, feature classes created in geodatabases in a PostgreSQL database management system (DBMS) use ST_Geometry storage. That means an ST_Geometry column is added to the business table of the feature class to store the spatial attribute. ST_Geometry is an abstract noninstantiable superclass, the subclasses of which are instantiable.
What are the different types of feature classes in ArcGIS?
There are seven types of feature classes you can create in ArcGIS for Desktop: point, multipoint, line, polygon, annotation, dimension, and multipatch. You can tell what type of feature class it is in the Catalog tree based on the icon.