Question

Writing to Postgres shows missing lines for some rows?

  • 12 February 2021
  • 2 replies
  • 1 view
C

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
Rank
Badge +2

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?

C

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.,

Reply


Community Stats

28,741
Posts
109,578
Replies
36,583
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.