[GIS] KML to Layer gives ERROR 000210 in ArcGIS Desktop

arcgis-desktoperror-000210kmz

I keep getting an error when trying to convert a KMZ file in ArcGIS Desktop. It shows up in google earth just fine, and I've never had problems using the KML to Layer tool before.

I keep getting error 000210, and an empty geodatabase is created.The help tool tells me this error could be due to data locking or limited access rights, but author is open to modification of the file – says so on his website. I'm using this shapefile downloaded near the bottom of the page: http://ontariomap.webs.com/

What do you think the problem is?

Best Answer

To me Data Interoperability Extension for Arcmap is working fantastic and ET GeoWizard also seems to work. Find the FileGDB of your data as below-

GDB LINK

Reference

If you read the Make Query Table sidebar help:

Expression (optional)

An SQL expression used to select a subset of records. The syntax for the expression differs slightly depending on the data source. For example, if you're querying file or ArcSDE geodatabases, shapefiles, coverages, dBase, or INFO tables, enclose field names in double quotes:

"MY_FIELD"

If you're querying personal geodatabases, enclose fields in square brackets:

[MY_FIELD]

etc...

That would imply the correct format as:

"Table2"."f1" = "Table1"."f1" AND "Table2"."f2" = "Table1"."f2" AND "Table2"."f3" = "Table1"."f3"

Script

The following python snippet will enable you to run the tool without error:

arcpy.MakeQueryTable_management("Table1;Table2","QueryTable11111","NO_KEY_FIELD","#","Table1.f1 #;Table1.f2 #;Table1.f3 #;Table2.f1 #;Table2.f2 #;Table2.f3 #","/\Table1/\./\f1/\ = /\Table2/\./\f1/\ AND /\Table1/\./\f2/\ = /\Table2/\./\f2/\ AND /\Table1/\./\f3/\ = /\Table2/\./\f3/\")

Result

enter image description here

[GIS] Use Display Expression for KML Popup, SHP to KML ArcGIS

You seem to be encountering NIM099128:

Converting a Map or Layer to Key Markup Language (KML) when a layer has a formatted label expression; the expression displayed in the KML is not what is labeled.

The only workaround listed is to:

Format the labels through the standard label symbology, and not by using an expression.

The problem seems to have first been reported at ArcGIS 10.2.1, and appears to be assigned to a developer to address, but if you need a solution sooner rather than later, then it looks like you may need to develop your own workaround, because I do not think the above will meet your requirements.

Best Answer

Related Solutions

[GIS] Creating join based on multiple fields using ArcGIS Desktop

Reference

Script

Result

[GIS] Use Display Expression for KML Popup, SHP to KML ArcGIS

Related Question