Skip to main content
  • Home
  • Forums
  • FME Form
  • Authoring
  • How to update ESRI Feature Class Metadata down at the Resource/Fields/Entity and Attribute Information level?
Solved

How to update ESRI Feature Class Metadata down at the Resource/Fields/Entity and Attribute Information level?

simon_bell
Contributor
Forum|alt.badge.img+7

We are trying to automate updating the metadata on feature classess, in particular at the level of the Entity and Attribute Information level for the fields in our feature classes.

I have tried both methods of updating from an XML file or directly from the file geodatabase as metadata, but I can't seem to expose the information down to the field level of XML detail.

We are basically trying to update the Definition & Definition Source of all attribute fields in the feature class from an table. see highlighted area below to show help explain.

Is there something simply I am missing

Thanks

 

 

Best answer by simon_bell

Hi Todd,

I'm not sure the feature class I was given is valid, the geodb_metadata_string is being rejected at the XML_Fragmenter. Is there something simple I am overlooking here?

ArcGIS 10.3 is the version this was created in, and ISO 19139 Metadata Implementation Specification is the current Arc Options settings. If I export the metadata to XML none of the attribute fields metadata is included.

Thanks

Simon

2019-07-18_28701-metadata_EDIT.fmwt

View original
Did this help you find an answer to your question?

8 replies

todd_davis
Supporter
Forum|alt.badge.img+21
  • todd_davisSupporter
  • Supporter
  • July 17, 2019

Hi,

What you are looking for is under "eainfo/detailed/attr"

Definition = attrdef

Definition Source = attrdefs

Attached is a workspace that you can point at your geodatabase. It will return individual features for each attribute, providing all of the attribute information.

Thats the structure, and therefore you can make the changes and apply it back to the geodatabase to update the metadata.

metadata.fmw

 

simon_bell
Contributor
Forum|alt.badge.img+7
  • simon_bellContributor
  • Author
  • Contributor
  • Best Answer
  • July 18, 2019

Hi Todd,

I'm not sure the feature class I was given is valid, the geodb_metadata_string is being rejected at the XML_Fragmenter. Is there something simple I am overlooking here?

ArcGIS 10.3 is the version this was created in, and ISO 19139 Metadata Implementation Specification is the current Arc Options settings. If I export the metadata to XML none of the attribute fields metadata is included.

Thanks

Simon

2019-07-18_28701-metadata_EDIT.fmwt

todd_davis
Supporter
Forum|alt.badge.img+21
  • todd_davisSupporter
  • Supporter
  • July 18, 2019
simon_bell wrote:

Hi Todd,

I'm not sure the feature class I was given is valid, the geodb_metadata_string is being rejected at the XML_Fragmenter. Is there something simple I am overlooking here?

ArcGIS 10.3 is the version this was created in, and ISO 19139 Metadata Implementation Specification is the current Arc Options settings. If I export the metadata to XML none of the attribute fields metadata is included.

Thanks

Simon

2019-07-18_28701-metadata_EDIT.fmwt

This is because the XMLFragmenter (and XMLFlattener) don't like the dash in "G:\\GIS\\Freshwater\\20190416_Aotearoa_Environment_Indicators\\Coastal and estuarine water Quality trends 2006–2017" due to the encoding.

So add an "AttributeEncoder" (prior to XMLFragmenter) and set Destination Encoding to "Unicode 8-bit" and it will work

simon_bell
Contributor
Forum|alt.badge.img+7
  • simon_bellContributor
  • Author
  • Contributor
  • July 21, 2019
todd_davis wrote:

This is because the XMLFragmenter (and XMLFlattener) don't like the dash in "G:\\GIS\\Freshwater\\20190416_Aotearoa_Environment_Indicators\\Coastal and estuarine water Quality trends 2006–2017" due to the encoding.

So add an "AttributeEncoder" (prior to XMLFragmenter) and set Destination Encoding to "Unicode 8-bit" and it will work

Thanks Todd,

I don't have the knowlegde yet to finish off the problem. This is the first time I have looked at ESRI metadata in FME, and still trying to figure out how you found out the syntax for finding the XML fragment was "eainfo/detailed", and also the Encoding caused the problem, it isn't that obvious in the logs etc.

The original problem I was asked to solve was a simple update of a client supplied XML file which was read in and used to update an ideal XML fomat. This ideal XML file was then going to be imported to the feature class. This was the basic workspace here

2019-06-27_XML.from.MFE_to_XML.to.MPI.fmwt

We were then asked to also read in a simple spreadsheet and update the Definition and Defininition Source attributes resulting in me posting this original question. This is that spreasheet. Coastal water quality attributes.xls

These values never get exported to the XML files when you export from Arc, so thats when I realised that updating an XML file and importing later wasnt going to work. We needed to be reading and writing back to a feature class metadata directly.

How much do you charge to finish off the problem? to read in the spreadsheet and make the updates to Definition and Definition Source back to the feature class?

Thanks

Simon

todd_davis
Supporter
Forum|alt.badge.img+21
  • todd_davisSupporter
  • Supporter
  • July 21, 2019
simon_bell wrote:

Thanks Todd,

I don't have the knowlegde yet to finish off the problem. This is the first time I have looked at ESRI metadata in FME, and still trying to figure out how you found out the syntax for finding the XML fragment was "eainfo/detailed", and also the Encoding caused the problem, it isn't that obvious in the logs etc.

The original problem I was asked to solve was a simple update of a client supplied XML file which was read in and used to update an ideal XML fomat. This ideal XML file was then going to be imported to the feature class. This was the basic workspace here

2019-06-27_XML.from.MFE_to_XML.to.MPI.fmwt

We were then asked to also read in a simple spreadsheet and update the Definition and Defininition Source attributes resulting in me posting this original question. This is that spreasheet. Coastal water quality attributes.xls

These values never get exported to the XML files when you export from Arc, so thats when I realised that updating an XML file and importing later wasnt going to work. We needed to be reading and writing back to a feature class metadata directly.

How much do you charge to finish off the problem? to read in the spreadsheet and make the updates to Definition and Definition Source back to the feature class?

Thanks

Simon

Give me a call tomorrow. I can give you a bit extra quickly and that might be all you need to get you going. If not, its not going to be much work based in what you have supplied.

Cheers,

Todd

S
  • sdave
  • August 26, 2021
todd_davis wrote:

Hi,

What you are looking for is under "eainfo/detailed/attr"

Definition = attrdef

Definition Source = attrdefs

Attached is a workspace that you can point at your geodatabase. It will return individual features for each attribute, providing all of the attribute information.

Thats the structure, and therefore you can make the changes and apply it back to the geodatabase to update the metadata.

metadata.fmw

 

Hi, I am looking at doing similar things. From where can I look at the metadata.fmw, you have mentioned? Thx

todd_davis
Supporter
Forum|alt.badge.img+21
  • todd_davisSupporter
  • Supporter
  • August 26, 2021
sdave wrote:

Hi, I am looking at doing similar things. From where can I look at the metadata.fmw, you have mentioned? Thx

Here is what I think it was, but it will just get the idea of getting to it, but it's just a basic example.

S
  • sdave
  • August 27, 2021
sdave wrote:

Hi, I am looking at doing similar things. From where can I look at the metadata.fmw, you have mentioned? Thx

Many Thanks for sharing the file.

Reply


Helpful Members This Week

Community Stats

30,942
Posts
117,252
Replies
38,742
Members

Latest FME

Terms & ConditionsCookie settings

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.