Who should read this book
Conventions
How to send your comments
Who should read this book
Conventions
How to send your comments
The purpose of DB2 Spatial Extender
Data that represents geographic features
How data represents geographic features
The nature of spatial data
Where spatial data comes from
How to create and use a DB2 Spatial Extender GIS
Interfaces to DB2 Spatial Extender and associated functionality
Tasks you perform to create and use a DB2 Spatial Extender GIS
Scenario: An insurance company updates its GIS
DB2 Spatial Extender configuration
System requirements
Supported operating systems
Required database software
Disk space requirements
Installing DB2 Spatial Extender
Before you begin
Installing DB2 Spatial Extender on Windows NT systems
Installing DB2 Spatial Extender on AIX systems
Verifying the installation
Post-installation considerations
Downloading ArcExplorer
Running the DB2 instance update utility (db2iupdt)
What's next?
Inventory of resources
Reference data
Resources that enable a database for spatial operations
Enabling a database for spatial operations
Creating a spatial reference system
About coordinate and spatial reference systems
Creating a spatial reference system from the Control Center
About spatial data types
Data types for single-unit features
Data types for multi-unit features
A data type for all features
Defining a spatial column for a table, registering this column as a layer, and enabling a geocoder to maintain it
Registering a view column as a layer
Using geocoders
About geocoding
Running the geocoder in batch mode
Importing and exporting data
About importing and exporting
Importing data to a new or existing table
Importing data to an existing table
Exporting data to a shape file
Using the Control Center to create a spatial index
Determining grid cell sizes
Methods of performing spatial analysis
Building a spatial query
Spatial functions and SQL
Spatial predicates and SQL
Using the sample program
The sample program steps
db2gse.gse_disable_autogc
db2gse.gse_disable_db
db2gse.gse_disable_sref
db2gse.gse_enable_autogc
db2gse.gse_enable_db
db2gse.gse_enable_idx
db2gse.gse_enable_sref
db2gse.gse_export_shape
db2gse.gse_import_sde
db2gse.gse_import_shape
db2gse.gse_register_gc
db2gse.gse_register_layer
db2gse.gse_run_gc
db2gse.gse_unregist_gc
db2gse.gse_unregist_layer
DB2GSE.COORD_REF_SYS
DB2GSE.GEOMETRY_COLUMNS
DB2GSE.SPATIAL_GEOCODER
DB2GSE.SPATIAL_REF_SYS
A sample program fragment
B tree indexes
Ways to create a spatial index
How a spatial index is generated
Guidelines on using a spatial index
Selecting the grid cell size
Selecting the number of levels
About geometries
Properties of geometries and associated functions
Class
X and Y coordinates
Z coordinates
Measures
Interior, boundary, and exterior
Simple or non-simple
Empty or not empty
Envelope
Dimension
Spatial reference system identifier
Instantiable geometries and associated functions
Points
Linestrings
Polygons
Multipoints
Multilinestrings
Multipolygons
Functions that show relationships and comparisons, generate geometries, and convert values' formats
Functions that show relationships or comparisons between geographic features
Functions that generate new geometries from existing ones
Functions that convert the format of a geometry's values
AsBinaryShape
GeometryFromShape
EnvelopesIntersect
Is3d
IsMeasured
LineFromShape
LocateAlong
LocateBetween
M
MLine FromShape
MPointFromShape
MPolyFromShape
PointFromShape
PolyFromShape
ShapeToSQL
ST_Area
ST_AsBinary
ST_AsText
ST_Boundary
ST_Buffer
ST_Centroid
ST_Contains
ST_ConvexHull
ST_CoordDim
ST_Crosses
ST_Difference
ST_Dimension
ST_Disjoint
ST_Distance
ST_Endpoint
ST_Envelope
ST_Equals
ST_ExteriorRing
ST_GeometryFromText
ST_GeomFromWKB
ST_GeometryN
ST_GeometryType
ST_InteriorRingN
ST_Intersection
ST_Intersects
ST_IsClosed
ST_IsEmpty
ST_IsRing
ST_IsSimple
ST_IsValid
ST_Length
ST_LineFromText
ST_LineFromWKB
ST_MLineFromText
ST_MLineFromWKB
ST_MPointFromText
ST_MPointFromWKB
ST_MPolyFromText
ST_MPolyFromWKB
ST_NumGeometries
ST_NumInteriorRing
ST_NumPoints
ST_OrderingEquals
ST_Overlaps
ST_Perimeter
ST_PointFromText
ST_PointFromWKB
ST_Point
ST_PointN
ST_PointOnSurface
ST_PolyFromText
ST_PolyFromWKB
ST_Polygon
ST_Relate
ST_SRID
ST_StartPoint
ST_SymmetricDiff
ST_Touches
ST_Transform
ST_Union
ST_Within
ST_WKBToSQL
ST_WKTToSQL
ST_X
ST_Y
Z
Overview of coordinate systems
Supported linear units
Supported angular units
Supported spheroids
Supported geodetic datums
Supported prime meridians
Supported map projections
Conic projections
Azimuthal or planar projections
Map projection parameters
The OGC well-known text representations
The OGC well-known binary (WKB) representations
Numeric type definitions
XDR (Big Endian) encoding of numeric types
NDR (Little Endian) encoding of numeric types
Conversion between NDR and XDR
Description of WKBGeometry byte streams
Assertions for the WKB representation
The ESRI shape representations
Shape types in XY space
Measured shape types in XY space
Shape types in XYZ space