Skip to main content
Question

Convert kml with attachments to geodatabase

  • May 27, 2022
  • 5 replies
  • 412 views
A
Forum|alt.badge.img

Hei

 

I am trying to convert a kml file into a geodatabase, because the kml file has attached pictures that were taken. If I do it via arcgis software I don't get the information, just the points. Via FME I can get the points, the information about the points, and that existes some jpg files attached to the points, but not the jpg files.

Shapefiles don't allow to attach files into, but geodatabase allows that.

 

Someone with experience on that?

In attachment you can find an example to teste.

 

Thank you in advance,

Artur

5 replies

debbiatsafe
Safer
Forum|alt.badge.img+21
  • debbiatsafeSafer
  • Safer
  • 648 replies
  • May 28, 2022

Hello @arturmlribeiro​ 

I would recommend exposing the kml_document _path on the KML reader's Document feature type to get the path to the JPEG files. This attribute contains the temporary file path of where FME has extracted the KMZ file and the parent directory should contain the image directory with the JPG photos.

Use the kml_document_path format attribute from the KML reader's Document feature type to get JPG pathsYou should then be able to use this information to write attachments as shown in this article. I will see if I can create an example of this workflow next week.

debbiatsafe
Safer
Forum|alt.badge.img+21
  • debbiatsafeSafer
  • Safer
  • 648 replies
  • May 30, 2022

Hello @arturmlribeiro​ 

I would recommend exposing the kml_document _path on the KML reader's Document feature type to get the path to the JPEG files. This attribute contains the temporary file path of where FME has extracted the KMZ file and the parent directory should contain the image directory with the JPG photos.

Use the kml_document_path format attribute from the KML reader's Document feature type to get JPG pathsYou should then be able to use this information to write attachments as shown in this article. I will see if I can create an example of this workflow next week.

Attached is an example workspace reading from KML and writing to a feature class with attachments. As noted in the writing geodatabase attachment article, both the relationship class and attachments table must be created in ArcGIS beforehand as FME can only write to an existing relationship class.

In addition, it is recommended not to use partial runs with the workspace as kml_document_path is a temporary file path.

A
Forum|alt.badge.img

Attached is an example workspace reading from KML and writing to a feature class with attachments. As noted in the writing geodatabase attachment article, both the relationship class and attachments table must be created in ArcGIS beforehand as FME can only write to an existing relationship class.

In addition, it is recommended not to use partial runs with the workspace as kml_document_path is a temporary file path.

Hei @debbiatsafe​ 

Thank you so much for your answer. During weekend I tried to follow the image above FilenamePartExtractor and FeaturerReader without success.

Running you workflow I encounter a few problems that made it no continue. I activated the relationship on the database after the first run so it will accept attachments, but I continue to encounter error messages again

 

 

A
Forum|alt.badge.img

Attached is an example workspace reading from KML and writing to a feature class with attachments. As noted in the writing geodatabase attachment article, both the relationship class and attachments table must be created in ArcGIS beforehand as FME can only write to an existing relationship class.

In addition, it is recommended not to use partial runs with the workspace as kml_document_path is a temporary file path.

Extract from the log file is attached

Edit session in on

edit_session" data-fileid="0694Q00000GIXqdQAHI will take a look again tomorrow. In the meanwhile, if you understand what I am doing wrong, feel free :)

 

debbiatsafe
Safer
Forum|alt.badge.img+21
  • debbiatsafeSafer
  • Safer
  • 648 replies
  • May 30, 2022

Attached is an example workspace reading from KML and writing to a feature class with attachments. As noted in the writing geodatabase attachment article, both the relationship class and attachments table must be created in ArcGIS beforehand as FME can only write to an existing relationship class.

In addition, it is recommended not to use partial runs with the workspace as kml_document_path is a temporary file path.

Try deleting the geodatabase writer and adding a new one. Remember to set the Transaction Type to 'Edit Session' after adding the new writer. It may also help to delete the feature class, recreate it, and re-enable attachments for the feature class before running the workspace.


Community Stats

32,065
Posts
121,738
Replies
39,692
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.