Skip to main content
  • EN

Hi, I'm pretty new but this workbench should be straightforward I thought 🙂

I have an Excel Sheet with 40 land parcels of interest that I want to display on a map.

 

So I used a feature joiner to get the spatial information (from a spatial dataset) for these 40 land parcels based on a parcel number. All looks good. My output has the 40 polygons with all the attribute data.

 

So then I used the EsriReprojector to project to Web Mercator Auxiliary Sphere. That's the projection used at work in ArcGIS Online.

 

All looking good in the data inspector. Polygons look good, attributes look good, coordinate system is what I want. no errors in FME.

 

However, THEN the problem starts. I can write this to a geodatabase, but the coordinate system disappears and becomes UNKNOWN during this last stage of writing the output. So, suddenly the coordinate system disappears.

 

I just wonder if this could be because of my FME version (2018.0)?

Or am I doing something wrong. Because it all seems straight forward.

 

I add a writer

Format: Esri Geodatabase (File Geodatab)

Dataset: the output .gdb

Coordinate System: same as source

Feature Class or Table Definition: Automatic

 

Geometry: geodb_polygon

 

I can open the output feature layer in ArcGIS Pro (version 3.0.3) and it looks ok but the coordinate system is gone.

 

thanks for your help.

Hi mary,

After the reprojection, and you go to Data inspector, the feature information should show the coordinate system value. Click on a feature

image 

You may need to inspect the feature information prior to the ESRIreprojector and check that the transformer has the SOURCE cs set correctly. This way is can do the DEST coord sys projection with the correct library.

 

Another option might be to use CSmapreprojector which has a "read from feature" option for the inputimage 

 

Can you attach your FMW workspace? imageAlso you will need to upgrade 2018 FME should you already be using Arcpro 3. Both software need to be aligned in the versions according to this https://community.safe.com/s/article/notes-on-fme-and-esri-versions-and-compatibility

Hi mary,

After the reprojection, and you go to Data inspector, the feature information should show the coordinate system value. Click on a feature

image 

You may need to inspect the feature information prior to the ESRIreprojector and check that the transformer has the SOURCE cs set correctly. This way is can do the DEST coord sys projection with the correct library.

 

Another option might be to use CSmapreprojector which has a "read from feature" option for the inputimage 

 

Can you attach your FMW workspace? imageAlso you will need to upgrade 2018 FME should you already be using Arcpro 3. Both software need to be aligned in the versions according to this https://community.safe.com/s/article/notes-on-fme-and-esri-versions-and-compatibility

thank you. Yes after reprojection I go into data inspector and the Coordinate System is correct.

However as I then add a writer and write to a file geodatabase the output returns an unknown coordinate system.

Also the writer asks me for a feature type ("select feature type") which I find weird. Because I can only select between the files that are in my reader. But my output file is a whole different file.

Maybe one of my settings in the writer is incorrect, I will play a bit more.

@mary​ I can't reproduce the issue that you report. I've attached an example workspace (FME 2018). If you can reproduce the issue here then we can take another look.

In your workflow, I would suspect that it is in the FeatureJoiner that you're loosing your spatial reference

@mary​ I can't reproduce the issue that you report. I've attached an example workspace (FME 2018). If you can reproduce the issue here then we can take another look.

In your workflow, I would suspect that it is in the FeatureJoiner that you're loosing your spatial reference

Hi, it's definitely the writer where I lose the spatial reference, today I tried again with a fresh brain. The setting I changed is 'set feature class or table definition' to automatic. And I wasn't prompted to select feature type, and it worked. Thanks for thinking along with me!

On your writer, try manually setting your coordinate system to your desired coordinate system. If it's a custom coordinate system, you will need to define that in FME. Just a hunch on my part, but I think this may be your issue. FME can only write the coordinate information if it recognizes the coordinate system from your source dataset. More on that here: Adding Custom Coordinate System (safe.com)

Reply


Community Stats

30,126
Posts
114,364
Replies
37,763
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.