Question,
How do you tell FME to output data into a certain SDO_GEOMETRY?
Based on the SDSFIE standards (USAF data), I have four types of tables
in Oracle to store information, of type Area, Point, Line, and Site.
Site can store both Area and Point features within the same row, so
there are two geometry columns, GEOMETRY_A and GEOMETRY_P for those
tables.
To get FME to translate data for a complete dataset, I set up one
reader for all the shapefiles, and three Oracle writers, one for each
type of Area, Line, and Point. Each writer specifies which column to
store the geometry in (GEOMETRY_A, GEOMETRY_L or GEOMETRY_P), which
has been verified by looking at the config file in a text editor.
Now, when I match up point shapefiles to the point Oracle writer, Area
to Area, etc all I get are Area conversions. Why? Because FME seems to
ignore all the subsequent writers (area is first), and just use the
first, even though they are correctly set to their own type of writer.
A second (and related item) with the SITE type is that even if I
disable all items except for the point items, and make certain the
configuration file NEVER even mentions the GEOMETRY_A column (just
GEOMETRY_P), it still writes the point objects into the first
SDO_GEOMETRY column it finds (GEOMETRY_A). Very frustrating.
Is there an easy way to specific columns, and get FME to actually pay
attention? Or will I have to create views for all the _SITE type
tables to be able to actually store point objects?
Thanks in advance,
Bryan
Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our
Professional Services team. Visit www.safe.com/services for details.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
