Find Duplicate Attributes in an ESRI Geodatabase

I snapped this idea from, I have been looking for a GP tool that can be used to find and list duplicate attribute values in an attribute table since ArcGIS 9.3.  I was able to find a SQL script for this purpose in the GDB Management Island at the 2012 UC, but I would have to Remote Desktop into another machine to run this process. If the duplicate ID values can be found and listed using a GP tool, that would be helpful in my organization's workflow process. 

Until ESRI implements this, here is a quick script (download here) I wrote for you guys to do just that.

  • Open ArcMap
  • Go to customize
  • Go to Commands 
  • Scroll until UI Controls
  • Click NeW UIControl and select button
  • Drag the new button anywhere in the toolbars
  • Right click on the new button and click view source (make sure you are still in customize mode)
  • Paste the code and run
  • You must first select the layer you want to find the duplicates in and then click the button, there you will be prompted to type-in the field name


Esri Maps for Microsoft Office Launched

It's the 2012 Esri International User Conference, expect more Esri news in the coming days, meanwhile, Mandown made me aware of the launch of Esri Maps for Office.

Here's the official list of features, and the summary from the Mandown blog: "With Esri Maps for Office, business professionals can quickly create interactive maps from their data in a Microsoft Excel spreadsheet. These live maps, which can be based on any geographic component, such as customer locations or sales by ZIP Code, can be simply added to Microsoft PowerPoint presentations or shared through Esri’s cloud mapping platform, ArcGIS Online. Maps shared through ArcGIS Online can then be distributed throughout an organization or embedded into mobile or web applications."

Of course this isn't the first solution to build maps directly from MS Excel, but the first deep integration with MS Office from Esri.

Advanced Utility Network Analyst

Advanced Utility Network Analyst (AUNA) is an extension for ESRI Utility Network Analyst tracing toolbar, Create, save and publish trace tasks with no code at all.

You can watch a full video about the tool here

I subscribed to the private beta but I still didn't recieve the download.


Batch Geonews: iD OpenStreetMap Editor, GeoIQ Acquired by Esri, Predicting People's Location, and more

Here's the recent geonews in batch mode.

On the open source and open data front:

On the Esri front:

In the drones category:

In the car navigation category:

In the everything else category:

In the maps category:

Batch Geonews: AutoCAD Worm, QGIS Cloud, Map Calls, Shapefile Spatial Index Revealed, and more

Here's the recent geonews in batch mode.

On the open source front:

On the Esri front:

On the web mapping front:

In the miscellaneous category:

In the maps category:

Esri Rolls Out ArcGIS Map Services For The Cloud and Other Esri News

Here's recent Esri-related geonews.

Mandown links to the CW article named Esri rolls out ArcGIS map services for the cloud: "Esri today [June 14th] rolled out an ambitious cloud offering for government and enterprise customers that allows users to create data-driven maps and map services without ArcGIS servers or desktop software. [...] "One way to describe it -- and here's a big sentence -- is that ArcGIS Online is a mapping platform, a new geospatial enterprise platform but especially focusing in on mapping," said Esri founder and President Jack Dangermond [...] "It has other services in there, like geocoding services across the enterprise or spatial analysis services that can be deployed across the enterprise, but the basic thing that most people recognize it for is that it has really cool maps." Related, Spatially Adjusted shares two entries on ArcGIS Online Service Credits.

Mandown shares several other Esri-related news, including:

More creative Maps

ANDREW ZOLNAI BLOG "turning stats into maps" update: I ran across these interesting web-mapping innovations:

- incredible detail helsp contrast cross-Europe travel taday vs, Roman times

- web data creation are contrasted for citizen weather stations and celestial measurements

   (as well as contrasting celestial measurements across 250 years time span)

- with Jubilee events in England a beautiful map of one of the many events under way 


Batch Geonews: ArcGIS 10.1, Bing Maps using Nokia, GeoPDF, GPS Camera Banned in China, Zombie Geography, India RISAT-1, FearSquare, and more

Here's the recent geonews in batch mode, covering the last few weeks (which have been crazy to me).

From the Esri front:

From the Microsoft front:

Discussed over Slashdot:

Directions Mag articles:

In the miscellaneous category:

In the maps category:

Ah... it feels good to be current on geonews once again!

Release of the GIS Cloud Publisher extension for ESRI ArcMap

A single click solution to get your maps from desktop to the Cloud!

The extension is free and compatible with ESRI ArcMap 9.x and 10.x. You can download it from the following link: GIS Cloud Publisher for ArcMap (600kB)

Publishing GIS projects with traditional GIS tools is not easy. You have to set up your own server, being that a server from a commercial vendor or open-source, and follow that with maintaining the server and services, uploading your data from desktop, reconfiguring maps and generating tiles to be optimized for the Web, not to mention mobile and tablets. All these are, for the most part, daunting and/or expensive tasks.


A map in ArcMap


GIS Cloud already gives you a way to easily build and publish your maps on the Cloud, but there are still lots of maps and projects sitting on your desktops. Of course it is possible to upload all that data to GIS Cloud, but then you would have to go through the process of creating and setting up those maps once again.

We have always been focused on making your GIS workflows more efficient to save you time and money. Therefore we are releasing today a GIS Cloud Publisher extension for one of the most popular desktop GIS tools out there: ESRI ArcMap

The GIS Cloud Publisher for ArcMap extension enables you to publish your maps from ArcMap to GIS Cloud with only one click. It automatically uploads your data, symbology, layer structure and spatial references. The idea is that what you see in your desktop GIS is instantly replicated on your GIS Cloud account. Once your maps and data are on GIS Cloud, they are easily published to the public or embedded into your website/blog without a need for having your own servers.


GIS Cloud Publisher Extension


After one click your entire map with the data is in GIS Cloud:

Your desktop GIS map on GIS Cloud

Also you can share it over a link like this:

The extension is free and compatible with ESRI ArcMap 9.x and 10.x. You can download it from the following link: GIS Cloud Publisher for ArcMap (600kB)

Read more about it at GIS Cloud’s blog:

About GIS Cloud:

GIS Cloud is a leading cloud platform delivering simple and easy to use geo platform, applications and solutions. Company is focused on providing geo services for visualizing and publishing spatial data through its innovative HTML5 mapping technology.

The mission of GIS Cloud is not only to supplement desktop solutions, but to extend and enrich their capabilities through the potential cloud computing provides.

With a strong focus on using latest web and cloud technologies, company believes in moving traditional GIS industry into to the world of modern web based software.

Dino Ravnic, co-founder and CEO
[email protected]
London - Zagreb


Cloud Futures #3: Bridging the Gap

Bloggage update: Bridging the gap between desktop and on-line GIS follows the first and second instalment, online vector GIS and spatial data validation. GisCloud introduced a free Esri extension to load features and attributes to its file system. This follows other services such as Arc2Earth and  Arc2Google, except in the vector domain. Having both Esri @ home and a private cloud I put this new extension through its paces...

Syndicate content