I am having no trouble reading the parcel polygon portal service, its just not bringing over the shape column, so I am unable to write the data to our SQL database.
Question
Esri ArcGIS Portal Feature Service Reader not reading shape column so I am unable to write to SQL arcsde featureclass
+73- Celebrity
When you read the data in and inspect it in FME, is it coming through as a spatial feature? IE can you see the geometry? If so, take a look at the GeometryExtractor transformer. You can use that to extract the features geom to an attribute to write into a database
+3- Contributor
When you read the data in and inspect it in FME, is it coming through as a spatial feature? IE can you see the geometry? If so, take a look at the GeometryExtractor transformer. You can use that to extract the features geom to an attribute to write into a database
It seems like the issue is the writer. I've tried every table handling method, use existing, drop and create, truncate existing, and each tries to write the shape column as an [image] field type? I have the GeometryExtractor set to Microsoft SQL Server Binary, Geometry format, and an output name of Shape. The outpout Shape field type is [buffer]. I do a quick StringConcaternator and TimeStamper and successfully see a spatial preview of my expected data, then it gets to the writer and completes successfully, but I am not able to view the parcel data in ArcGIS Pro since the Shape column is set to [image] for some reason.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.