Latest Contributions by BruceHarold

Tiffany, use raw text notation for data like that, you have '\t' in the path, which is a tab when read. i.e put 'r' ahead of your string: r"C:\\Users\\tselvidge\\AppData\\Roaming\\ESRI\\Desktop10.3\\ArcCatalog\\[email protected]\\ArcDEV.GISOWNER.ParcelAddrFacet_geo" ... View more

Hi You should connect to ArcGIS Online in your session and use the World Service. you will get street addresses. Regards ... View more

Hi FME 2016 supports insert, update and delete for feature services, including multiple service layers.  This functionality will come to Esri's Data Interoperability extension too, later this year. ... View more

Hi, the SearchCursor was just fo rme to get hold of a feature to create GeoJSON. I guess you're dealing with that as an input. ... View more

Hi Here is a code snippet: I found a multipart polygon from some polygon features I had laying around: with arcpy.da.SearchCursor('Suburbs','shape@') as cursor:     for row in cursor:         gj = row[0].__geo_interface__         if row[0].partCount > 1:             print('Biggie')             break Biggie The variable 'gj' now has GeoJSON in it.  Grab the array from geometry made from it and create a new geometry with a spatial reference aPoly = arcpy.Polygon(arcpy.AsShape(gj,False).getPart(),arcpy.SpatialReference(2193)) Check the spatial reference: aPoly.spatialReference.name 'NZGD_2000_New_Zealand_Transverse_Mercator' Regards ... View more

Hi You need to make a geometry instance from the array you get out of the geometry feature made by AsShape(). The spatial reference is read only with any geometry object. If your geometry collection is all polygons then AsShape(<geojsondictionary>,False) should make a multipart polygon. If you have a big GeoJSON handling problem then consider the Data Interoperability extension, it can read GeoJSON input and write Esri geometry with less pain :-). Regards BTW, Jason S. no longer works here ... View more

Hi If you have the Data Interchangeability extension then there are a lot of tools there for handling Excel as a format and nulls in data.  Like the other contributors say, Excel doesn't support a schema so getting it into a georelational environment can be challenging. Regards ... View more

Hi You might consider leveraging the World Geocode Service for his function.  Here is an example that filters on street names in Belton TX that are 'Davis Streets': http://geocode.arcgis.com/arcgis/rest/services/World/GeocodeServer/find?text=Davis%20St%20Belton%20TX&category=Street%20… The example only finds a single candidate, but there is spelling handling, like this search for Jackson St with a typo: http://geocode.arcgis.com/arcgis/rest/services/World/GeocodeServer/find?text=Jacksin%20St%20Belton%20TX&category=Street%… Regards ... View more

Hi findAddressCandidates does not return the Status field which would contain a value 'T' if an address was a tie, but geocodeAddresses does, which is another reason to use that call. Score is not a reliable metric on its own; even within a single category there can be multiple locators that supply candidates, and a 100% match to a street name is still worse than a 99% match to a rooftop because of a small typo. You can safely go with the candidate order returned by geocodeAddresses.  Rank is a loaded word because there is a returned field 'Rank' used to boost place names by population (think Paris, France versus Paris, TX).  The candidates are ordered by positional quality. Regards ... View more

The Data Interoperability extension can write images into cells in an Excel spreadsheet. It isn't clear what format your data (other than BMP files) are in but if it is something DI can read (or it can be made so) then you should be able to make an XLS or XLSX with your images embedded. ... View more