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.
Page 1 / 1
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
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.