span8
span4
span8
span4
FME is loading features into my database such as Microsoft SQL Server Spatial,Oracle Spatial,Postgis or DB2 which the GeometryOGCValidator is passing as valid but the database tools are tagging as invalid.
FME implements the OGC definitions found athttp://www.opengeospatial.org/standards/sfa/.In particular,see section 6.1 for the Geometry Object Model,and what it means for various geometries to be valid or simple.
However each spatial database implementation of these rules differs slightly and this is why sometimes a feature will pass through the GeometryOGCValidator but the database still flags it as invalid.
It most often happens with self intersecting features,so sometimes running the features through the SelfIntersector can be useful.
SELECT *,来自[user].[schema].[tablename]的gem.isvalidDetailed(),其中gem.stisvalid()=0
UPDATE [user].[schema].[tablename] SET GEOM=GEOM.MakeValid() WHERE GEOM.STIsValid()=0
SELECT sdo_geom.validate_geometry_with_context ([tablename].GEOM,[tolerance]) FROM [tablename] WHERE sdo_geom.validate_geometry(GEOM,0.5) <>'TRUE'
SELECT * FROM [schema].[tablename] WHERE ST_isvalid(GEOM) <>'TRUE'
DB2 Spatial Extender also offers an ST_isValid function which will return invalid geometries.
Viewing and Inspecting PostGIS Data
Converting to PostGIS: Create,Drop or Truncate a Table
Converting to PostGIS: Write to an Existing Table
Performing spatial queries on database tables using the FeatureReader
Adding metadata entries for Oracle spatial tables or views
PostGIS Error if Access Not Granted to Geometry Table
Viewing and Inspecting SQL Server Data
Connect to an Oracle Service Name (not Oracle SID)
Converting from PostgreSQL to MapInfo (Non-Spatial to Spatial)
Executing SQL commands within a workspace using the SQLExecutor
© 2019 亚搏在线Safe Software Inc |法律