Question

SDF reader with multiple geometry columns

david_r
Rank
Userlevel 4

Hi, a user has an SDF file with several geometry columns:

https://knowledge.safe.com/questions/40984/how-to-select-the-right-geometry-column-in-sdf-fil.html

Is this supported by FME, if so, how? I couldn't find any setting for this in the SDF reader.

4 replies

takashi
Rank
Userlevel 2
Badge +17
I'm also interested in this subject. I'm wondering if the SDF reader can read a multiple geometry as an aggregate and each part of the aggregate has the geometry column name as its geometry name or a trait. However, I don't have any sample SDF dataset containing multiple geometry features, so cannot confirm that unfortunately.

 

In addition, I would like to know how to write multiple geometry features into a new SDF dataset with the SDF writer.

 

fmelizard
Rank
Userlevel 4
Badge +13

Thanks @david_r and @takashi. I will find a technical or strategic expert to respond to the initial questions as well as your follow up questions. Thanks!

fmelizard
Rank
Userlevel 4
Badge +13

Hi @david_r and @takashi. Dean replied to https://knowledge.safe.com/questions/40984/how-to-select-the-right-geometry-column-in-sdf-fil.html

takashi
Rank
Userlevel 2
Badge +17

Hi @david_r and @takashi. Dean replied to https://knowledge.safe.com/questions/40984/how-to-select-the-right-geometry-column-in-sdf-fil.html

Hi @NatalieAtSafe, yes I know that the Quick Fact describes that the SDF reader/writer doesn't support aggregates, but surprisingly, in my observation, the reader/writer can read/write aggregates in fact.

 

In addition, the SDF writer has a parameter called Geometry Column Name, and the help doc says "A comma-separated list of the geometry column names for writing". I therefore thought that the SDF writer supports multiple geometry and the user could specify the geometry column names through the parameter. However, the writer seems to write a multiple geometry as just an aggregate.

 

See also the attached workspace: sdf-vs-mutliple-geometry.fmw

 

Reply


Community Stats

28,707
Posts
109,479
Replies
36,552
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.