Latest Contributions by BruceHarold

"Dynamic" means a translation can output whatever attribution is in the input, but HTML in popups cannot be interrogated this way so we are reduced to hard coding field handling.  This is why KML is a risky format for sharing.  I edited the tool so that it will ignore failed features, see if that helps. If possible ask for KML with a schema object in it - then you can go dynamic. ... View more

Hi Veronica The ETL tool looks for the field names in your sample file:  FID, NUM, NORTHING, EASTING, ELEV, DESC_, SOURCE, SET_BY, DATE and NOTES.  Only those elements in the kml_description popup HTML will be output, and if the values found don't cast to the data types set up in the ETL tool then it will fail.  Often with ETL tools you can make processing dynamic but only when inputs have a schema, and HTML doesn't, so we are stuck with specific fields. If you have a handful of elements then it is feasible to have a few ETL tools, but if every KML file is a unique experience then it gets harder. ... View more

Hi Veronica, I get a similar message stream except no error, I get 4 CTRL features from the sample KML file written to a new file geodatabase.  You will need to edit the ETL tool I gave you to have paths that are correct on your computer. Before trying to translate the data check you can view it in ArcGIS Earth, the KML will need to have identical elements as the one you supplied. ... View more

Yes, you'll need 10.4.1. ... View more

Hi Veronica In the attached zipfile is an ArcGIS 10.4.1 toolbox file, in that is a Spatial ETL tool that imports your CTRL points to a file geodatabase. If your source KML files have differing attribution you will need to make an ETL tool for each 'schema' in the KML description HTML values. You will need the Data Interoperability extension installed and enabled to see the Spatial ETL tool.  You can get an evaluation license if you don't already have a license. ... View more

ArcGIS Data Interoperability extension has a GeometryValidator transformer that can enforce right (or left) hand rule orientation of polygon boundaries. ... View more

Hi Bob If you have your angles then you need to test they are within +/- 11.25 degrees of these azimuth breaks: N:0 NNE:22.5 NE:45 ENE:67.5 ... and so on. BTW, the values are easy to calculate (obviously) but in a shameless plug for Esri's geocoding open file:///C:/Program%20Files%20(x86)/ArcGIS/Desktop10.4/Locators/USAddress.lot.xml in Firefox and navigate to the Spatial Operators elements - very few people know you can prepend spatial operators to street addresses and geocode "off road". ... View more

Here is a function: # North azimuth bearing of a line segment (degrees) def NorthAzimuth(x1,y1,x2,y2):     degBearing = math.degrees(math.atan2((x2 - x1),(y2 - y1)))     if (degBearing < 0):         degBearing += 360.0     return degBearing ... View more

I use a pattern of subprocesses and independent workspaces, here: http://www.arcgis.com/home/item.html?id=b3c7c6273ef54e91aa57a073aa873eca  ... View more

Hi See if my tool is an option for you: http://www.arcgis.com/home/item.html?id=da9efbe1232f426ead182213f53c8cd8  Bruce ... View more

Hi I edited the input parameters to be a little easier to navigate from the GP dialog, but you'll still need to edit the values. Also included is another ETL tool that creates a feature class EXPANDEDADDRESSES of extra site addresses implied by ranges in NUMBER_LAST > NUMBER_FIRST.  I'm not sure that is always valid but if so append the points to the ADDRESS feature class. Also fixed an omission, formatting DATE type fields. ... View more

The ETL tool parameters (the wildcard reading of the PSV files) will probably need adjusting. It is easiest to edit the ETL tool (which opens Workbench) and adjust the paths to your data. The Model that makes the ADDRESS feature class does not expand house number ranges, I'll make something that does that.  You can email me at work [email protected]. ... View more

Hi I'm in a class today and a bit rushed but attached is a TBX with a Spatial ETL tool and model in it that will create a fetaure class ADDRESS from GNAF pipe-delimited data. You can then make a locator.  When i find time I may clean this up and post it as a GP sample. ... View more

You can call 64bit arcpy from a standalone script, the trick is to set PYTHONPATH to the 64bit site-packages directory then start a subprocess that inherits the environment variable and runs 64bit. Similar to the code in this sample: arcgis.com/home/item.html?id=b3c7c6273ef54e91aa57a073aa873eca ... View more