Skip to main content
Question

Best appraoch to connect to an XML url and export the data to a SHP file format with all data presenting in the correct column format.

  • September 25, 2023
  • 1 reply
  • 8 views
A

I have connected to an third party data source via an XML url and managed to export this to SHP file format.

 

The issue I am having is that the latitude and longitude are not being pulled through into the writer. Equally, the lat/long and name of the data source are showing as there own row in the attribute table not as a column. I have attached a snip for reference.

 

This is my first time using FME so have read a few articles and tried a few differerent transformers to try and get the output I am looking for but to no avail. Any help would be appreciated.

1 Attachments

1 reply

danminneyatsaf
Safer
Forum|alt.badge.img+12

Hey @andyh​ sounds like you want to have some geometry generated for those rows that contain values for the lat/long fields? In FME, you'll need to create this geometry using the VertexCreator transformer. In there, you can set the X Value to your Longitude attribute, and the Y Value to your Latitude attribute. Afterwards, you can use a CoordinateSystemSetter to set the coordinate system before writing out your shapefile.

image 

Hope this helps! If you're still having issues, a small snippet of your source dataset may help us here.

Reply


Helpful Members This Week

Community Stats

31,501
Posts
119,418
Replies
39,118
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

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