Latest Contributions by RobertBorchert

‎12-08-2015

I have used it but found it to not be as helpful for what your trying to do. it will result in a new table that has FID's that you then need to match up, It will not show you unique results. Using that tool to find identical results would still result in you having to manually delete entries. If you only have a hundred or so duplicates that isn't a big deal

‎12-08-2015

Just to clarify are you looking to delete duplicate records in a Table or a Feature Class which has an attribute Table. If it is JUST a table. open it in Access. Copy all the records and paste them into an Excel Document. Paste as Text Select your columns that contain the duplicate data and click on the Data Tab>Sort & Filter>Advanced In the pop up window select the unique records only option. It will strip out all duplicates. Save your table and replace the table in your database. For goodness sake make a back up first.

‎12-08-2015

Or more specifically it appears to be on the roof of the school

‎12-08-2015

Try this. start a blank MXD session. Add only the XY table and create the event from the XY. Then export that to a database that's in the projection you want. When using decimal degree data it seems to default to the proper projection for displaying the raw data. I just did it with the xy you posted and it comes up as Alexander Valley School.

‎12-08-2015

Since writing my last reply I then saw Mark Boucher answer and it reminds me of something I do. I created a simple batch file to automatically back up the databases I work with on my computer and compress them automatically. I simply click the icon first thing every morning and it starts the programs I want every morning (email, browser, ArcGIS), compresses my active databases and backs them up to the network. Editing on a personal computer, as Mark wrote, is significantly faster in our environment then working off a hard drive on a server somewhere

‎12-01-2015

I would like to see an option that will lock a layer. Often I have a layer that I need to be able to select so I can see it's attributes. However, I don't want to be able to move them. Example. I am working with staking data in an electric distribution system. I am snapping conductor and assemblies to poles. I need to be able to select the pole so I can see what it's attachements are but I want to NOT be able to move that pole.

‎12-01-2015

I would like to see an option that will lock a layer. Often I have a layer that I need to be able to select so I can see it's attributes. However, I don't want to be able to move them. Example. I am working with staking data in an electric distribution system. I am snapping conductor and assemblies to poles. I need to be able to select the pole so I can see what it's attachements are but I want to NOT be able to move that pole.

‎12-01-2015

Good idea. Howeve, if you lower the resolution on your monitor your fonts will get bigger. Not a great fix but it works.

‎11-04-2015

As the Select by Attribtues has a Clear Button I would like to see one added to the Select by Location Tool. Arguably it is a lot easier already to manually clear the Select by Attributes tool by selecting and deleting.

‎10-19-2015

Are you in a geometric network? If so have you tried deleting the GMN and rebuilding it? be advised if you do and your in SDE you should compress/compact it several time first.

‎09-18-2015

I would like to see the ability to sort a string that has numbers at the beginning as a Number. i.e. I have addresses 1 Main Street, 10 Main Street, 2 Main Street. It is going to sort them in that order.

‎09-18-2015

This is all a good idea. What I mostly want though is the ability to find only in the extent visible in the window. Example. I am trying to find a customer that is supposed to be at 141 Main Street. Well you may have 25 cities in your map and most of them have a main street. I would like to be able to navigate to the given city then do a FIND for Main Street and I will result in all the customers with a Main Street address. I can then sort them and find the approximate location between two addresses

‎09-14-2015

Often it is easier to find features using the FIND tool. i.e. the Binoculars Icon More specific searches can be made in individual feature classes with the Select by Attributes Tool. You can also open feature class table and from there use the Find and Replace Tool. What I would like to see is a more advanced FIND tool. The user Right Clicks on a feature class and one of the options would be FIND but it would be specific to that feature class. Say for example I have all the municipals in my state open and I want to quickly navigate to a particular one. I right click on the municipals layer and select FIND. Type in the name of the muni and all the matching names pop up. Now this could be done with the Basic FIND tool but if you have a lot of layers open it can take some time and it can be filtered by change the layers to the particular feature but what I am proposing would streamline that. This would also be handy from ArcCatalog to quickly find an attribute amongst a lot of data to see if it exists.

‎09-03-2015

I have been trying to find a work around for this for some time. The best I can come up with is to add a data driven page name to the attributes for what you want to display. In my case it is customer location id's and names. You can add the table to the layout. This may not work for roads if there is more than on part of a given road name. The use the data driven page option for defintion query. However, it works best to have a second copy of the feature in question. The bad part is yout have to manually refresh the table each time you change a data driven page.

‎08-26-2015

Where do you do that?

Online Status	Offline
Date Last Visited	‎06-02-2026 05:27 AM

My Ideas

Latest Contributions by RobertBorchert

Re: Deleting duplicates from a table in ArcGis

Re: Deleting duplicates from a table in ArcGis

Re: Projection Problem

Re: Projection Problem

Re: Better method than APPEND?

Make editable layer select-able but not editable

Make editable layer select-able but not editable

Re: Font size in ArcGIS

Add Clear Button to Select by Location

Re: Attribute Assistant - NEAREST_FEATURE_ATTRIBUTES - Empty Geometry

Sort String like a number if it leads with a number

Re: Enhance find features functionality

Advance FIND Option

Re: Mapbook Street Index

Re: Group Definition Query

Re: Store username of logged in user when completi...

Create Links in PDF

Load Data into a Feature Class should only show ma...

Print Layout from Pro without defaulting to Map Se...

Re: Branch Versioning vs Traditional

Electric Generation and Transmission