span8
span4
For Oracle spatial tables and views to be recognized by the FME:
|错误执行语句'select“parcel_view”.“parcel_id”,"PARCEL_VIEW"."PRIMARYINDEX","PARCEL_VIEW"."LANDUSE","PARCEL_VIEW"."USES","PARCEL_VIEW"."GEOM" FROM ( SELECT * FROM "PARCEL_VIEW" A WHERE MDSYS.SDO_RELATE( A.GEOM,mdsys.sdo_geometry(2003,NULL,null,mdsys.sdo_elem_info_array(1,1003,3),mdsys.sdo_ordinate_array(3118280.75,10081402,3137693.75,10098911)),'mask=ANYINTERACT querytype=WINDOW') = 'TRUE' ) "PARCEL_VIEW" WHERE 1 = 1' did not succeed;error was `ORA-29902: error in executing ODCIIndexStart() routine
Then the spatial metadata probably does not exist.The highlighted NULL entry in the message above should be the SRID.
When Oracle spatial tables are created using SQL Plus or some other tool there may not be entries in the MDSYS.SDO_GEOM_METADATA table that defines the extents and coordinate system of data.You can check for your metadata entries usiing:
select * from USER_SDO_GEOM_METADATA where table_name='If you don't get any values returned you need to insert the metadata.要添加条目,请发出与此类似的SQL命令:
insert into user_sdo_geom_metadata (table_name,column_name,diminfo,srid) values ('TABLE_NAME','GEOM_COLUMN_NAME',sdo_dim_array(sdo_dim_element('X',80000,100000,0.005),sdo_dim_element('Y',425000,450000,0.005)),32039);
...where the X,Y values define the minimum bounding box of the spatial data.In this case,the values are minX=80000,minY=425000,maxX=100000,maxY=450000 and the SRID value is 32039.
Spatial Views
insert into user_sdo_geom_metadata using select 'RT43495_VIEW',column_name,diminfo,srid from all_sdo_geom_metadata where owner = 'DEV' and table_name = 'RT43495';
In this case the metadata entry is taken from the metadata entry for the table which is being used to generate the view.Don't forget to COMMIT the changes!!thub.nodes.view.add-new-comment10 |4000 characters needed characters left characters exceededUp to 10 attachments (including images) can be used with a maximum of 4.0 MB each and 4.0 MB total.
Related Articles
Performing spatial queries on database tables using the FeatureReader
Writing custom data types to an Oracle table
Read Oracle Sequence Nextval and use in Counter
Making use of Oracle Sequences when working with Oracle Tables
Let the Database Do the Work: Reading
FME is loading features with invalid geometries into my Database
Writing to an Oracle table with Foreign Keys
Performing native spatial queries on database tables using the SQLExecutor
© 2019 亚搏在线Safe Software Inc |法律
- Anonymous
- Sign in
- Create
- New Question
- New Article
- New Idea
- Spaces
- 3D (and BIM)
- Attribute Handling
- Automations (FME Server)
- CAD
- Cloud
- Coordinate Systems
- Custom Transformers
- Database
- Dynamic Workspaces
- FME Cloud API
- FME Cloud Administration
- FME Cloud Getting Started
- FME Desktop 3rd Party Integrations
- FME桌面管理
- FME Desktop Administration & Configuration
- FME Desktop Development
- FME Desktop Getting Started
- FME Desktop Installation
- FME Desktop Licensing
- FME Desktop Plug-In SDK
- FME Desktop Workbench Scripting
- FME Server 3rd Party Integrations
- FME Server Administration
- FME Server Administration & Configuration
- FME Server Development
- FME Server Getting Started
- FME Server Installation
- FME Server Licensing
- Fanouts
- Ideas FME Cloud
- Ideas FME Desktop: Data Inspector
- Ideas FME Desktop: Formats & Systems
- Ideas FME Desktop: Transformers
- Ideas FME Desktop: Workbench
- Ideas FME Server
- Indoor Mapping
- KML
- Lists
- Performance Tuning
- 点云
- Published Parameters
- Raster
- 实时
- Running Multiple Workspaces
- Tabular
- Troubleshooting Techniques
- Vector / GIS
- Web
- 亚搏在线Workflow Design
- XML / GML
- Zip Files
- *FME Desktop
- *FME Server
- *FME Cloud
- *Other
- Explore
- 话题
- Questions
- Articles
- Ideas
- Users
- Badges