Can I combine two KMZ files and extract the result of combined kmz's in a csv file or a table with FME?

Hi @gauripearl,

The SpatialFilter is likely the transformer you are looking for. The SpatialFilter will allow you to determine which states contain which cities using a spatial predicate (i.e. Filter contains Candidate). Check out the Determining Spatial Relationships article to learn more!

Once you have determined the spatial relationships, you can use something like the AttributeRemover or AttributeManager to remove, rename, and re-order the attributes before sending the features to a CSV Writer.

I have attached an example which demonstrates a similar task - determining which voting boundaries belong to each neighborhood using data from the Vancouver Open Data Catalogue.

Hope this helps!

Input(s)

Output

Divisions_by_Neighborhood.fmw

Hi @gauripearl,

The SpatialFilter is likely the transformer you are looking for. The SpatialFilter will allow you to determine which states contain which cities using a spatial predicate (i.e. Filter contains Candidate). Check out the Determining Spatial Relationships article to learn more!

Once you have determined the spatial relationships, you can use something like the AttributeRemover or AttributeManager to remove, rename, and re-order the attributes before sending the features to a CSV Writer.

I have attached an example which demonstrates a similar task - determining which voting boundaries belong to each neighborhood using data from the Vancouver Open Data Catalogue.

Hope this helps!

Input(s)

Output

Divisions_by_Neighborhood.fmw

Thank you @chrisatsafe I am getting trouble in opening spatial filter transformer. I get a message that spatial filter transformer is not installed and the workspace is made in newer version of FME. I am using 2018. Do I have an option to install spatial filter transformer in my current FME desktop?

Hi @gauripearl,

The workspace I uploaded was created in FME 2019.0 which is why you are seeing that message. No need to install anything as the SpatialFilter is in previous versions of FME as well. You can add the SpatialFilter to the canvas by typing "SpatialFilter" and selecting it from the quick add menu, or by using the add transformer button, or from the menu Transformers > Add Transformer.

Once you have added the SpatialFilter, connect the Neighborhoods reader to the Filter port and the Voting Division Reader to the Candidate port. In the example I provided, the following parameters were used for the SpatialFilter:

Lastly, connect the Passed port to the AttributeRemover.

Additional Resources:

• Getting Started with FME Desktop: Adding Transformers

Perfect. This worked. I am getting the results. I want the output table to add two columns which contains the name of a city and a state. Feature information contains state and city names if I select a feature but output table does not show names. Title or the name of a feature i.e. name of the state is not a part of description of kmz feature. Thus the output table does not contains name of a state and a city. Is there any way that I can include these names from feature information to final output table?