Skip to main content
Question

Writing to Postgres shows missing lines for some rows?

  • February 12, 2021
  • 2 replies
  • 26 views

Hi all,

​I recently converted data in fme from dgn to osgb.

I then published to postgres table. I can see all the attributes including the shape column. I can see numbers and data in each field and each row.

The weird part of this now is, I go to Arcgis Pro and try to view data. Majority of dataset 1000 records work fine but there is like 50 rows which when I click zoom in, it does not have the polyline to display even though all the attributes have been generated including shape column.

I checked FME inspector and everything works fine

I tried in geodatabase it works fine but just issue is with postgis.

Any idea on what this issue could be would be huge help. I also did not generate srid for postgres if it helps.​

2 replies

chrisatsafe
Contributor
Forum|alt.badge.img+2
  • Contributor
  • February 16, 2021

Hi @cardiofaz​ ,

 

Just to confirm, is this a PostGIS table or an SDE on Postgresql? Additionally, if you read the table into FME and pass the features through a GeometryFilter (filtering for line geometry), do all of the features have line geometry or are those same 50 unfiltered?


  • Author
  • February 24, 2021

Sorry for delay getting back but this has worked. Thanks for this seems to be way to detect this. Not yet sure root cause but at least it gives me a start to identify the issue.,


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