Skip to main content
Solved

Spatialite line features written in FME viewed in ArcMap creates an unexpected view


geogaard
Contributor
Forum|alt.badge.img+15

I am creating a Spatialite database with FME 2016.1 64 bit. I have both polygons and lines. Polygons shows up perfectly, but the lines are all over the place. I have added a picture showing the lines that should have depicted a road network in a municipality. Have anyone had the same experience or any idea why the lines drawn like this? I have been trying to adjust how ArcMap reads the data with the "query dialogue" but no success. My ArcGIS version is 10.3.1

Best answer by takashi

Hi @geogaard, if you read the SpatiaLite data with FME Data Inspector, how is it displayed?

View original
Did this help you find an answer to your question?

11 replies

takashi
Influencer
  • Best Answer
  • April 12, 2016

Hi @geogaard, if you read the SpatiaLite data with FME Data Inspector, how is it displayed?


geogaard
Contributor
Forum|alt.badge.img+15
  • Author
  • Contributor
  • April 12, 2016
takashi wrote:

Hi @geogaard, if you read the SpatiaLite data with FME Data Inspector, how is it displayed?

Hi @takashi here is the view in inspector. This is also what I would expect ArcMap to show.


redgeographics
Celebrity
Forum|alt.badge.img+49

You say polygons come across just fine, so I'm assuming it's not a projection issue. Are you doing any kind of processing in between or just doing a simple a-to-b conversion?


takashi
Influencer
  • April 12, 2016
geogaard wrote:

Hi @takashi here is the view in inspector. This is also what I would expect ArcMap to show.

OK. I was able to reproduce similar symptom to yours. It seems that ArcMap does not display 3D SpatiaLite lines from FME correctly. I don't know which is wrong, ArcMap or FME. As a meantime workaround, try writing the data in 2D. You can use the 2DForcer transformer to change 3D to 2D.


geogaard
Contributor
Forum|alt.badge.img+15
  • Author
  • Contributor
  • April 12, 2016
redgeographics wrote:

You say polygons come across just fine, so I'm assuming it's not a projection issue. Are you doing any kind of processing in between or just doing a simple a-to-b conversion?

It's just a simple a-to-b conversion. Not doing anything different with the lines contra the polygons.


geogaard
Contributor
Forum|alt.badge.img+15
  • Author
  • Contributor
  • April 12, 2016
takashi wrote:

OK. I was able to reproduce similar symptom to yours. It seems that ArcMap does not display 3D SpatiaLite lines from FME correctly. I don't know which is wrong, ArcMap or FME. As a meantime workaround, try writing the data in 2D. You can use the 2DForcer transformer to change 3D to 2D.

Thank you. You are right, there seems to be a problem with 3D data. Once in 2D it works as expected.


takashi
Influencer
  • April 12, 2016
geogaard wrote:

Thank you. You are right, there seems to be a problem with 3D data. Once in 2D it works as expected.

I'm wondering if the unexpected shapes caused by a bug in FME. Hope someone from Safe will investigate this.


mark2atsafe
Safer
Forum|alt.badge.img+44
  • Safer
  • April 12, 2016
geogaard wrote:

Thank you. You are right, there seems to be a problem with 3D data. Once in 2D it works as expected.

I've looked and I don't find any previous reports of this problem. Can @geogaard can you submit a case to our support team to report the problem? See http://www.safe.com/support - please include the version of FME and ArcGIS you are using. Thanks


takashi
Influencer
  • April 13, 2016
geogaard wrote:

Thank you. You are right, there seems to be a problem with 3D data. Once in 2D it works as expected.

Hi @Mark2AtSafe, I also reported my reproduction to your support team - C113837. Regards.


mark2atsafe
Safer
Forum|alt.badge.img+44
  • Safer
  • April 13, 2016
takashi wrote:

Hi @Mark2AtSafe, I also reported my reproduction to your support team - C113837. Regards.

Thanks Takashi. I warned the developers that there was a problem coming their way, so hopefully they will have a head start on fixing it.


Forum|alt.badge.img

Thanks a lot, @HeatherS and @geogaard 

This is EXACTLY what I need to write cross-plattform spatiaLite. Just change these default FME options: 

DONT use generic geometry (you have  to choose geometrytype explisit, in my case wkb_line_xyz). 

DONT compress geometry column. 

I haven't checked this thoroughly, but now it seems to work fine in both QGIS and arc map. 

QGIS does spew out some non-helpful complaints in the log, though: 

query fails: SELECT styleQML FROM layer_styles WHERE f_table_catalog=<my sqlite file> 
AND table_schema='' 
AND f_table_name=<my tableAND f_geometry_column='GEOMETRY' 
ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings