sql-and-enterprise-geodatabases
configure-oracle-extproc
overview-geodatabase-system-tables
Relationship queries
XML column queries
Spatial queries
Example Finding domain owners
Example Resolving domain codes to description values
Example Discovering domain usage
Example Finding subtype codes and descriptions
Example Finding the geodatabase release
Returning a list of relationship classes
Determining which data is versioned
Archive_View_Name
Geometry_Columns
GlobalID_Name
Is_Archive_Enabled
Is_Simple
Is_Versioned
Is_Replicated
RowID_Name
Version_View_Name
SQL access to geodatabase data
What type of data can be edited using SQL
enable-sql-access-from-arcgis-desktop
views-in-geodatabase
Example Creating a view in DB2 with SQL
Example Creating a view in Informix with SQL
Example Creating a view in Oracle with SQL
Example Creating a view in PostgreSQL with SQL
Example Creating a view in SQL Server with SQL
What is an archive view
Editing nonversioned geodatabase data in DB2 using SQL
Editing nonversioned geodatabase data in Informix using SQL
Editing nonversioned geodatabase data in Oracle using SQL
Editing nonversioned geodatabase data in PostgreSQL using SQL
Editing nonversioned geodatabase data in SQL Server using SQL
Next_RowID
What is a versioned view
read-db2-versioned-data-using-sql
read-informix-versioned-data-using-sql
read-oracle-versioned-data-using-sql
read-postgresql-versioned-data-with-sql
read-sqlserver-versioned-data-with-sql
overview-edit-versioned-data-with-sql
edit-versioned-data-using-sql-db2
edit-versioned-data-using-sql-informix
edit-versioned-data-using-sql-oracle
edit-versioned-data-using-sql-postgresql
edit-versioned-data-using-sql-sqlserver
Inserting a value into a Global ID column in DB2 using SQL
Inserting a value into a Global ID column in Informix using SQL
Inserting a value into a Global ID column in Oracle using SQL
Inserting a value into a Global ID column in PostgreSQL using SQL
Inserting a value into a Global ID column in SQL Server using SQL
Next_GlobalID
What is the ST_Geometry storage type
sql-and-st-geometry
SQL implementation differences for the ST_Geometry type
load-sqlite-stgeometry-library
Geometry validation
spatial-indexes-and-stgeometry
When are spatial indexes used
The Rtree index
spatial-grid-index
guidelines-to-choose-spatial-index-grid-size
Tips on using a spatial grid index
Enhance ArcGIS functionality using ST_Geometry
Spatial SQL queries on tables with an ST_Geometry column
Using spatial views on tables with an ST_Geometry column
Workflow Using SQL with existing feature classes
Rules for creating spatial tables to be used with ArcGIS
Create tables with an ST_Geometry column
Register an ST_Geometry column
Unregister an ST_Geometry column
Create spatial references using SQL
Insert features to a table with an ST_Geometry column
Create spatial indexes on tables with an ST_Geometry column
Update values in an ST_Geometry column
Delete values from an ST_Geometry spatial column
Registering a table with the geodatabase
Workflow Creating a table with SQL and registering it with the geodatabase
A quick tour of SQL functions used with ST_Geometry
Constructor functions
Geometry properties
Spatial accessor functions
Spatial relationships
Relational functions for ST_Geometry
Spatial operations
Spatial operation functions for ST_Geometry
Parametric circles and ellipses
ST_Aggr_ConvexHull
ST_Aggr_Intersection
ST_Aggr_Union
ST_Area
ST_AsBinary
ST_AsText
ST_Boundary
ST_Buffer
ST_Centroid
ST_Contains
ST_ConvexHull
ST_CoordDim
ST_Crosses
ST_Curve
ST_Difference
ST_Dimension
ST_Disjoint
ST_Distance
ST_DWithin
ST_EndPoint
ST_Entity
ST_Envelope
ST_EnvIntersects
ST_Equals
ST_Equalsrs
ST_ExteriorRing
ST_GeomCollection
ST_GeomCollFromWKB
ST_Geometry
ST_GeometryN
ST_GeometryType
st_geomfromcollection
ST_GeomFromText
ST_GeomFromWKB
ST_GeoSize
ST_InteriorRingN
ST_Intersection
ST_Intersects
ST_Is3d
ST_IsClosed
ST_IsEmpty
ST_IsMeasured
ST_IsRing
ST_IsSimple
ST_Length
ST_LineFromText
ST_LineFromWKB
ST_LineString
ST_M
ST_MaxM
ST_MaxX
ST_MaxY
ST_MaxZ
ST_MinM
ST_MinX
ST_MinY
ST_MinZ
ST_MLineFromText
ST_MLineFromWKB
ST_MPointFromText
ST_MPointFromWKB
ST_MPolyFromText
ST_MPolyFromWKB
ST_MultiCurve
ST_MultiLineString
ST_MultiPoint
ST_MultiPolygon
ST_MultiSurface
ST_NumGeometries
ST_NumInteriorRing
ST_NumPoints
ST_OrderingEquals
ST_Overlaps
ST_Perimeter
ST_Point
ST_PointFromText
ST_PointFromWKB
ST_PointN
ST_PointOnSurface
ST_PolyFromText
ST_PolyFromWKB
ST_Polygon
ST_Relate
ST_SRID
ST_StartPoint
ST_Surface
ST_SymmetricDiff
ST_Touches
ST_Transform
ST_Union
ST_Within
ST_X
ST_Y
ST_Z
What is SQL
What are spatial types
What is an SRID
Spatial references
object-id
Essential terms for using SQL with geodatabases