Home > SQL Developer Dialog Boxes ... > Maintain Spatial Metadata
This dialog box is displayed if you select a table and specify Update Spatial Metadata. Internally, SQL Developer uses the information in this box to modify the relevant row in the xxx_SDO_GEOM_METADATA and xxx_SDO_INDEX_INFO views, which are documented in Oracle Spatial and Graph Developer's Guide.
Table Name: Name of a feature table that has a column of type SDO_GEOMETRY.
Spatial Index Name: Name of the spatial index associated with the specified combination of table and column names.
Spatial Column: Name of the column of type SDO_GEOMETRY in the specified feature table.
Coordinate System: The SRID (spatial reference identifier) value for the coordinate system for all geometries in the column, or null if no specific coordinate system should be associated with the geometries. For example, 8307 is the SRID value for the "WGS 84 longitude/latitude" coordinate system.
Spatial Dimensions: The dimensional information (DIMINFO column in USER_SDO_GEOM_METADATA). Note that for geodetic layers, you must specify the dimensional extents in the index metadata as -180,180 for longitude and -90,90 for latitude, and the tolerance value is interpreted as meters.
Name: Name of the dimension, for example, X
or Longitude
.
Lower Boundary: Lower-left point of the dimension. For geodetic data, must be -180 for longitude and -90 for latitude.
Upper Boundary: Upper-right point of the dimension. For geodetic data, must be 180 for longitude and 90 for latitude.
Tolerance: A level of precision with spatial data, reflecting the distance that two points can be apart and still be considered the same (for example, to accommodate rounding errors). For geodetic data, tolerance is specified as meters. (Tolerance is explained in detail in Oracle Spatial and Graph Developer's Guide.)
Related Topics