User's Guide and Reference

Index

A B C D E F G I J L M N O P Q R S T U W X Y Z
A
  • AIX
  • installing DB2 Spatial Extender (1425)
  • where macro definitions for constants are stored (1592)
  • where reference data is stored (1440)
  • angular units (2089), (2090)
  • applications
  • guidelines for writing (1569)
  • stored procedures (1589)
  • ArcExplorer
  • downloading (1432)
  • using as interface (1405), (1558)
  • AsBinaryShape (1915), (1918)
  • attribute data (1391)
  • automatic geocoding (1523)
  • azimuthal projections (2103)
    • B
  • B tree indexes (1662)
  • batch geocoding (1517)
  • boundary (1674), (1717)
    • C
  • catalog views
  • DB2GSE.COORD_REF_SYS (1650)
  • DB2GSE.GEOMETRY_ COLUMNS (1653)
  • DB2GSE.SPATIAL_ GEOCODER (1656)
  • DB2GSE.SPATIAL_REF_SYS (1659)
  • class (1691)
  • conic projections (2099)
  • coordinate systems (2077), (2078)
  • DB2GSE.COORD_REF_SYS catalog view (1651)
  • deriving spatial reference systems from (1456)
  • description (1395), (1448)
  • coordinates
  • description (1394)
  • X coordinates
  • description (1450)
  • properties of geometries (1699)
  • Y coordinates
  • description (1452)
  • properties of geometries (1702)
  • Z coordinates
  • description (1454)
  • properties of geometries (1703)
  • Create Spatial Index window (1553)
  • Create Spatial Layer window
  • for registering a table column as a layer (1506)
  • for registering a view column as a layer (1509)
  • Create Spatial Reference window (1477), (1479)
    • D
  • data items (1396)
  • databases
  • disabling support for spatial operations
  • db2gse.gse_disable_db (1601)
  • sample program (1575)
  • enabling for spatial operations
  • DB2 Control Center menu choices (1445)
  • db2gse.gse_enable_db (1611)
  • discussion (1443)
  • sample program (1574)
  • DB2 Control Center
  • Create Spatial Index window (1554)
  • Create Spatial Layer window
  • for registering a table column as a layer (1507)
  • for registering a view column as a layer (1510)
  • Create Spatial Reference window (1478), (1480)
  • Export Spatial Data window (1545), (1547), (1549)
  • Import Spatial Data window (1537), (1540), (1542)
  • invoking DB2 Spatial Extender from (1435)
  • Run Geocoder window (1527), (1529), (1532)
  • DB2 instance update utility (db2iupdt) (1433)
  • DB2 Spatial Extender
  • applications
  • guidelines for writing (1570)
  • stored procedures (1590)
  • catalog views (1648)
  • configuration (1416)
  • error, warning, and informational messages (1647)
  • installing
  • hardware and software requirements (1418)
  • on AIX (1426)
  • on Windows NT (1423)
  • verification (1428)
  • interfaces to (1402)
  • invoking from DB2 Control Center (1436)
  • purpose (1388)
  • resources
  • for spatial operations (1442)
  • reference data (1439)
  • summary (1437)
  • sample program
  • compiling and running (1430)
  • description (1572)
  • spatial functions (1917)
  • stored procedures (1591)
  • tasks, summaries of
  • carried out by stored procedures (1594)
  • overview (1406)
  • sample program (1573)
  • scenario (1413)
  • DB2GSE.COORD_REF_SYS (1649)
  • DB2GSE.GEOMETRY_COLUMNS (1652)
  • db2gse.gse_disable_autogc (1595)
  • db2gse.gse_disable_db (1599)
  • db2gse.gse_disable_sref (1602)
  • db2gse.gse_enable_autogc (1605)
  • db2gse.gse_enable_db (1609)
  • db2gse.gse_enable_idx (1612)
  • db2gse.gse_enable_sref (1615)
  • db2gse.gse_export_shape (1618)
  • db2gse.gse_import_sde (1621)
  • db2gse.gse_import_shape (1624)
  • db2gse.gse_register_gc (1627)
  • db2gse.gse_register_layer (1630)
  • db2gse.gse_run_gc (1634)
  • db2gse.gse_unregist_gc (1637)
  • db2gse.gse_unregist_layer (1640)
  • DB2GSE.SPATIAL_GEOCODER (1655)
  • DB2GSE.SPATIAL_REF_SYS (1658)
  • db2iupdt (DB2 instance update utility) (1434)
  • default geocoder (1515)
  • dimension (1733)
  • disk space requirements (1420)
    • E
  • EBNF (Extended Backus Naur) (2080)
  • empty or not empty (1725)
  • enabling databases for spatial operations
  • DB2 Control Center menu choices (1446)
  • description (1408)
  • discussion (1444)
  • envelope (1664), (1729)
  • EnvelopesIntersect (1823), (1921)
  • error messages (1644)
  • ESRI shape representations
  • associated spatial functions (1897)
  • discussion (2148)
  • Export Spatial Data window (1544), (1546), (1548)
  • exterior (1672), (1715)
    • F
  • false M
  • specifying (1463), (1495)
  • false X
  • specifying (1460), (1483)
  • false Y
  • specifying (1464), (1489)
  • false Z
  • specifying (1462), (1491)
    • G
  • geocentric coordinate system (2086)
  • geocoders
  • DB2GSE.SPATIAL_ GEOCODER catalog view (1657)
  • default geocoder (1514)
  • disabling automatic geocoding
  • db2gse.gse_disable_autogc (1597)
  • Run Geocoder window (1530)
  • sample program (1583)
  • enabling automatic geocoding
  • Create Spatial Layer window (1505)
  • db2gse.gse_enable_autogc (1607)
  • discussion (1499), (1522)
  • sample program (1582)
  • non-default geocoders
  • discussion (1513)
  • using db2gse.gse_register_gc to register (1629)
  • using db2gse.gse_unregist_gc to unregister (1639)
  • running in batch mode
  • db2gse.gse_run_gc (1636)
  • discussion (1518)
  • Run Geocoder window (1525)
  • sample program (1579), (1584)
  • geocoding
  • batch (1516)
  • description (1398)
  • discussion (1512)
  • incremental (1520)
  • precision (1414)
  • geodetic datums (2093)
  • GEOGCS keyword (2081), (2083), (2084)
  • geographic features
  • associated data types (1503)
  • description (1386)
  • represented by data (1390)
  • geographic information system (GIS)
  • creating (1407)
  • description (1387)
  • using (1410)
  • geometries
  • correspondence with spatial data types (1689)
  • discussion (1669)
  • linestrings (1678), (1761)
  • multilinestrings (1685), (1800)
  • multipoints (1683), (1794)
  • multipolygons (1687), (1806)
  • points (1676), (1745)
  • polygons (1680), (1778)
  • properties
  • boundary (1675), (1718)
  • class (1692)
  • dimension (1734)
  • empty or not empty (1726)
  • envelope (1665), (1730)
  • exterior (1673), (1716)
  • interior (1671), (1714)
  • measures (1710)
  • simple or non-simple (1722)
  • spatial reference system identifier (SRID) (1738)
  • X coordinates (1698)
  • Y coordinates (1701)
  • Z coordinates (1705)
  • spatial index grids (1666)
  • GeometryFromShape (1901), (1920)
  • grid indexes (1551)
    • I
  • Import Spatial Data window (1536), (1539), (1541)
  • incremental geocoding (1521)
  • informational messages (1646)
  • installing DB2 Spatial Extender
  • hardware and software requirements (1417)
  • on AIX (1424)
  • on Windows NT (1421)
  • verification (1427)
  • interfaces to DB2 Spatial Extender (1401)
  • interior (1670), (1713)
  • Is3d (1706), (1923)
  • IsMeasured (1711), (1925)
    • J
  • Java 2 Runtime Environment (JRE) v1.2.2 (1431)
    • L
  • layers
  • DB2GSE.GEOMETRY_ COLUMNS catalog view (1654)
  • description (1411)
  • registering table columns as
  • Create Spatial Layer window (1504)
  • db2gse.gse_register_layer (1632)
  • sample program (1578)
  • registering view columns as
  • Create Spatial Layer window (1508)
  • db2gse.gse_register_layer (1633)
  • sample program (1585)
  • using db2gse.gse_unregist_layer to unregister (1642)
  • linear rings (2147)
  • linear units (2087), (2088)
  • LineFromShape (1905), (1927)
  • linestrings (1679), (1760), (1762)
  • LocateAlong (1849), (1929)
  • LocateBetween (1851), (1931)
    • M
  • M (1758), (1933)
  • M units
  • specifying (1474), (1498)
  • map projection parameters (2106)
  • map projections (2096), (2098)
  • Measured shape types in XY spaces (2155)
  • measures
  • description (1455), (1709)
  • properties of geometries (1708)
  • messages (1643)
  • MLine FromShape (1935)
  • MLineFromShape (1911)
  • MPointFromShape (1909), (1937)
  • MPolyFromShape (1913), (1939)
  • multilinestrings (1684), (1799)
  • MultiPoint byte stream contents (2152)
  • MultiPointM byte stream contents (2157), (2158)
  • multipoints (1682), (1793)
  • MultiPointZ byte stream contents (2163), (2164)
  • multipolygons (1686), (1805)
    • N
  • NDR encoding (2140), (2142), (2143)
    • O
  • offset factors
  • specifying (1459), (1482)
    • P
  • pattern matrices (1814)
  • planar projections (2104)
  • Point byte stream contentse (2151)
  • PointFromShape (1903), (1941)
  • PointM byte stream contentse (2156)
  • points (1677), (1744)
  • PointZ byte stream contents (2162)
  • PolyFromShape (1907), (1943)
  • Polygon byte stream contents (2154)
  • PolygonM byte stream contents (2160)
  • polygons (1681), (1777)
  • PolygonZ byte stream contents (2166)
  • PolyLine byte stream contents (2153)
  • PolyLineM byte stream contents (2159)
  • PolyLineZ byte stream contents (2165)
  • POSC/EPSB coordinate system model (2079)
  • precision
  • geocoding (1415), (1524)
  • preserving for spatial reference systems (1457)
  • prime meridians (2094), (2095)
  • PROJCS keyword (2082)
  • projections
  • azimuthal (2102)
  • conic (2100)
  • map
  • parameters (2105)
  • types (2097)
  • planar (2101)
    • Q
  • queries
  • exploiting spatial indexes (1566)
  • interfaces for submitting (1404), (1557)
  • sample program (1587)
  • types of spatial functions to use (1560)
  • using spatial predicate functions (1563)
    • R
  • reference data (1438)
  • Run Geocoder window (1526), (1528), (1531)
    • S
  • sample program
  • compiling and running (1429)
  • description (1571)
  • scale factors
  • specifying (1469), (1488)
  • scenario of tasks (1412)
  • shapes
  • in XY space (2150)
  • in XYZ space (2161)
  • ShapeToSQL (1899), (1945)
  • simple or non-simple (1721)
  • software requirements (1419)
  • source data (1392)
  • spatial columns (1511)
  • spatial data
  • derived from attribute data (1397)
  • derived from other spatial data
  • discussion (1399)
  • spatial functions that derive the data (1840)
  • exporting
  • db2gse.gse_export_shape (1620)
  • discussion (1534)
  • Export Spatial Data window (1543)
  • sample program (1588)
  • file formats
  • ESRI shape representations (1898), (2149)
  • WKB (well-known binary) representations (1878), (2125)
  • WKT (well-known text) representations (1860), (2108)
  • importing
  • db2gse.gse_import_shape (1626)
  • db2gse.gse_import_sde (1623)
  • discussion (1400), (1533)
  • Import Spatial Data window (1535), (1538)
  • sample program (1580)
  • nature of (1393)
  • spatial data types (1501)
  • correspondence with geometries (1688)
  • description (1502)
  • spatial functions
  • .ST_Area (1948)
  • AsBinaryShape (1916), (1919)
  • categorized by operations performed (1561)
  • EnvelopesIntersect (1824), (1922)
  • GeometryFromShape (1902)
  • Is3d (1707), (1924)
  • IsMeasured (1712), (1926)
  • LineFromShape (1906), (1928)
  • LocateAlong (1850), (1930)
  • LocateBetween (1852), (1932)
  • M (1759), (1934)
  • MLine FromShape (1936)
  • MLineFromShape (1912)
  • MPointFromShape (1910), (1938)
  • MPolyFromShape (1914), (1940)
  • PointFromShape (1904), (1942)
  • PolyFromShape (1908), (1944)
  • predicates (1564)
  • ShapeToSQL (1900), (1946)
  • ST_Area (1780), (1808)
  • ST_AsBinary (1896), (1950)
  • ST_AsText (1876), (1952)
  • ST_Boundary (1720), (1954)
  • ST_Buffer (1848), (1956)
  • ST_Centroid (1788), (1810), (1958)
  • ST_Contains (1834), (1960)
  • ST_ConvexHull (1854)
  • ST_Convexhull (1962)
  • ST_CoordDim (1749), (1964)
  • ST_Crosses (1830), (1966)
  • ST_Difference (1844), (1968)
  • ST_Dimension (1736), (1970)
  • ST_Disjoint (1820), (1972)
  • ST_Distance (1838), (1974)
  • ST_Endpoint (1766), (1976)
  • ST_Envelope (1732), (1978)
  • ST_Equals (1816), (1980)
  • ST_ExteriorRing (1782), (1982)
  • ST_GeometryFromText (1984)
  • ST_GeometryN (1798), (1988)
  • ST_GeometryType (1694), (1990)
  • ST_GeomFromText (1864), (2110)
  • ST_GeomFromWKB (1882), (1986), (2127)
  • ST_InteriorRingN (1786), (1992)
  • ST_Intersection (1842), (1994)
  • ST_Intersects (1822), (1996)
  • ST_IsClosed (1776), (1804), (1998)
  • ST_IsEmpty (1728), (2000)
  • ST_IsRing (1774), (2002)
  • ST_IsSimple (1724), (2004)
  • ST_IsValid (1696), (2006)
  • ST_Length (1770), (1802), (2008)
  • ST_LineFromText (1866), (2010), (2114)
  • ST_LineFromWKB (1886), (2012), (2131)
  • ST_MLineFromText (1872), (2014), (2120)
  • ST_MLineFromWKB (1892), (2016), (2137)
  • ST_MPointFromText (1870), (2018), (2118)
  • ST_MPointFromWKB (1890), (2020), (2135)
  • ST_MPolyFromText (1874), (2022), (2122)
  • ST_MPolyFromWKB (1894), (2024), (2139)
  • ST_NumGeometries (1796), (2026)
  • ST_NumInteriorRing (1784), (2028)
  • ST_NumPoints (1772), (2030)
  • ST_OrderingEquals (1818), (2032)
  • ST_Overlaps (1828), (2034)
  • ST_Perimeter (1792), (2036)
  • ST_Point (1747), (2042)
  • ST_PointFromText (1751), (2038), (2112)
  • ST_PointFromWKB (1884), (2040), (2129)
  • ST_PointN (1768), (2044)
  • ST_PointOnSurface (1790), (2046)
  • ST_PolyFromText (1868), (2048), (2116)
  • ST_PolyFromWKB (1888), (2050), (2133)
  • ST_Polygon (1857), (2052)
  • ST_Relate (1836), (2054)
  • ST_SRID (1740), (2056)
  • ST_StartPoint (1764), (2058)
  • ST_SymmetricDiff (2060)
  • ST_Touches (1826), (2062)
  • ST_Transform (1742), (2064)
  • ST_Union (1846), (2066)
  • ST_Within (1832), (2068)
  • ST_WKBToSQL (1880), (2070)
  • ST_WKTToSQL (1862), (2072)
  • ST_X (1753), (2074)
  • ST_Y (1755), (2076)
  • types
  • associated with instantiable geometries (1743)
  • associated with properties of geometries (1690)
  • data exchange (1858)
  • functions that compare geometries (1812)
  • functions that generate geometries (1839)
  • functions that show relationships between geometries (1811)
  • predicate functions (1813)
  • using to exploit spatial indexes (1568)
  • Z (1757)
  • spatial indexes (1661)
  • creating
  • Create Spatial Index window (1550)
  • db2gse.gse_enable_idx (1614)
  • determining grid size (1555), (1668)
  • sample program (1581)
  • exploiting (1567)
  • grid indexes (1552)
  • how they are generated (1663)
  • using (1667)
  • spatial information
  • description (1389)
  • retrieving and analyzing
  • exploiting spatial indexes (1565)
  • interfaces to use (1403), (1556)
  • sample program (1586)
  • types of spatial functions to use (1559)
  • using spatial predicate functions (1562)
  • spatial reference system identifier (SRID) (1737)
  • spatial reference systems
  • creating
  • Create Spatial Reference window (1476)
  • db2gse.gse_enable_sref (1617)
  • discussion (1447)
  • sample program (1576)
  • DB2GSE.SPATIAL_REF_SYS catalog view (1660)
  • description (1409)
  • dropping
  • db2gse.gse_disable_sref (1604)
  • sample program (1577)
  • specifying parameters
  • false M (1466), (1496)
  • false X (1461), (1484)
  • false Y (1465), (1490)
  • false Z (1467), (1492)
  • M units (1472), (1497)
  • offset factors (1458), (1481)
  • scale factors (1468), (1487)
  • XY units (1470), (1485)
  • Z units (1473), (1493)
  • spheroids (2091), (2092)
  • SRID (spatial reference system identifier) (2123)
  • stored procedures
  • db2gse.gse_disable_autogc (1596)
  • db2gse.gse_disable_db (1600)
  • db2gse.gse_disable_sref (1603)
  • db2gse.gse_enable_autogc (1606)
  • db2gse.gse_enable_db (1610)
  • db2gse.gse_enable_idx (1613)
  • db2gse.gse_enable_sref (1616)
  • db2gse.gse_export_shape (1619)
  • db2gse.gse_import_sde (1622)
  • db2gse.gse_import_shape (1625)
  • db2gse.gse_register_gc (1628)
  • db2gse.gse_register_layer (1631)
  • db2gse.gse_run_gc (1635)
  • db2gse.gse_unregist_gc (1638)
  • db2gse.gse_unregist_layer (1641)
  • ST_Area (1779), (1807), (1947)
  • ST_AsBinary (1895), (1949)
  • ST_AsText (1875), (1951)
  • ST_Boundary (1719), (1953)
  • ST_Buffer (1847), (1955)
  • ST_Centroid (1787), (1809), (1957)
  • ST_Contains (1833), (1959)
  • ST_ConvexHull (1853)
  • ST_Convexhull (1961)
  • ST_CoordDim (1748), (1963)
  • ST_Crosses (1829), (1965)
  • ST_Difference (1843), (1967)
  • ST_Dimension (1735), (1969)
  • ST_Disjoint (1819), (1971)
  • ST_Distance (1837), (1973)
  • ST_Endpoint (1765), (1975)
  • ST_Envelope (1731), (1977)
  • ST_Equals (1815), (1979)
  • ST_ExteriorRing (1781), (1981)
  • ST_GeometryFromText (1983)
  • ST_GeometryN (1797), (1987)
  • ST_GeometryType (1693), (1989)
  • ST_GeomFromText (1863), (2109)
  • ST_GeomFromWKB (1881), (1985), (2126)
  • ST_InteriorRingN (1785), (1991)
  • ST_Intersection (1841), (1993)
  • ST_Intersects (1821), (1995)
  • ST_IsClosed (1775), (1803), (1997)
  • ST_IsEmpty (1727), (1999)
  • ST_IsRing (1773), (2001)
  • ST_IsSimple (1723), (2003)
  • ST_IsValid (1695), (2005)
  • ST_Length (1769), (1801), (2007)
  • ST_LineFromText (1865), (2009), (2113)
  • ST_LineFromWKB (1885), (2011), (2130)
  • ST_MLineFromText (1871), (2013), (2119)
  • ST_MLineFromWKB (1891), (2015), (2136)
  • ST_MPointFromText (1869), (2017), (2117)
  • ST_MPointFromWKB (1889), (2019), (2134)
  • ST_MPolyFromText (1873), (2021), (2121)
  • ST_MPolyFromWKB (1893), (2023), (2138)
  • ST_NumGeometries (1795), (2025)
  • ST_NumInteriorRing (1783), (2027)
  • ST_NumPoints (1771), (2029)
  • ST_OrderingEquals (1817), (2031)
  • ST_Overlaps (1827), (2033)
  • ST_Perimeter (1791), (2035)
  • ST_Point (1746), (2041)
  • ST_PointFromText (1750), (2037), (2111)
  • ST_PointFromWKB (1883), (2039), (2128)
  • ST_PointN (1767), (2043)
  • ST_PointOnSurface (1789), (2045)
  • ST_PolyFromText (1867), (2047), (2115)
  • ST_PolyFromWKB (1887), (2049), (2132)
  • ST_Polygon (1856), (2051)
  • ST_Relate (1835), (2053)
  • ST_SRID (1739), (2055)
  • ST_StartPoint (1763), (2057)
  • ST_SymmetricDiff (2059)
  • ST_Touches (1825), (2061)
  • ST_Transform (1741), (2063)
  • ST_Union (1845), (2065)
  • ST_Within (1831), (2067)
  • ST_WKBToSQL (1879), (2069)
  • ST_WKTToSQL (1861), (2071)
  • ST_X (1752), (2073)
  • ST_Y (1754), (2075)
    • T
  • tessellation (1855)
  • triggers
  • disabling automatic geocoding
  • db2gse.gse_disable_autogc (1598)
  • enabling automatic geocoding
  • db2gse.gse_enable_autogc (1608)
  • using to invoke geocoder (1500), (1519)
    • U
  • UNIT keyword (2085)
    • W
  • warning messages (1645)
  • Windows NT
  • installing DB2 Spatial Extender (1422)
  • where macro definitions for constants are stored (1593)
  • where reference data is stored (1441)
  • WKB (well-known binary) representations
  • associated spatial functions (1877)
  • discussion (2124)
  • WKBGeometry (2146)
  • WKBGeometry byte streams (2145)
  • WKT (well-known text) representations
  • associated spatial functions (1859)
  • discussion (2107)
    • X
  • X coordinates
  • description (1449)
  • property of geometries (1697)
  • XDR encoding (2141), (2144)
  • XY units
  • specifying (1471), (1486)
    • Y
  • Y coordinates
  • description (1451)
  • property of geometries (1700)
    • Z
  • Z (1756)
  • Z coordinates
  • description (1453)
  • property of geometries (1704)
  • Z units
  • specifying (1475), (1494)

    • [ Top of Page | Previous Page | Next Page ]