Oracle Spatial Materials

Oracle Spatial

Sdo_geometry in Oracle Spatial

SHP to Oracle Spatial

Common Oracle Spatial errors

Oracle Spatial developer's Guide

Oracle Spatial SRID:

1. user_sdo_geom_metadata storesSRIDValue

After creating the sdo_geometry table, update the SRID field corresponding to each space table. Otherwise, the SRID cannot be null when written in Java.ORA-13365: Layer SRID does not match the SRID of the geometric object.

2. MDSYS. cs_srs stores the SRID value index, commonly used 4326

3. If the new table is a 3D table, that is, check coordinates include Z values used for 3D data, sdo_gtype is 3001 instead of 2001 at the insertion point.

Otherwise, an error is reported,ORA-13364: Layer dimension does not match the dimension of the geometric object