Latest Contributions by RayChilcote

‎11-02-2018

We ran into this problem recently. Big thanks for the references to the specific lock. And that script! More than handling the NULLs, what causes the NULLs? We've dug in and found the cause... at least in our case. Our Compress was failing. Worse, these orphaned locks did not exist before, but did exist after. And it also orphaned some version information, so we began losing edits. We've had 2 items to cause this. First, an orphaned editing service. It was leaving locks across many feature classes. Second, our developers that create the services would sometimes forget to uncheck the schema lock (checked by default) when creating a service. Especially for the orphaned edit service... there are no lock references in the locks tables. When the Compress runs, it only partially completes. Not a partial Compress. It broke in the middle (FAILURE -51) due to a lock it did not foresee (to skip). Data was changed in some locks tables and failed when attempting in others, thereby creating the NULLs at hand. So now my question: is the BUG fix going to simply not error and show NULLs? What is BUG-000110574 going to implement?

‎09-06-2018

Collector doesn't come close to replacing ArcPad. As I stated years ago in this thread, disconnected editing can't be left in the dust. Though this may be 10% of the use market, it's going to count as 90% of the interest of any business that requires such autonomy. For if it is not included, a business will spend (likely more than) 90% of their time trying to get such areas integrated. Though my 22 years in GIS has been 100% Esri, I cannot ignore other industry growth (QGis mobile editing - QField).

‎02-02-2016

From what I see, we will be dealing with the same (our Measure resolution is 8 decimal places). To boot, 7 decimals is just slightly larger than the tolerance Esri set on our data. This dictates the creation of gaps and overlaps.

‎01-28-2015

I posted the same request about 4 months after this (oops). https://c.na9.visual.force.com/apex/ideaView?id=08730000000brpmAAA Definitely a need to not just show (record by record) changes, but the ability to export. I'll expand to say not just Excel. A spatial format of Add/Delete/Modified. It's all there in the recordset that is produced by the tool. We just need that last step.

‎07-18-2014

A geoprocessing tool has been implemented at 10.2. http://resources.arcgis.com/en/help/main/10.2/index.html#//001700000198000000

‎03-07-2013

First, vote up the idea of a geoprocessing tool so we can update many fields (not one at a time in ArcCatalog): http://ideas.arcgis.com/ideaView?id=087300000008IBT&returnUrl=%2Fapex%2FideaList%3Fc%3D09a300000004xET%26category%3DService%2BIdeas%26p%3D2 I purposely moved away from database table updates because of the system table changes. There is also a VB method, but that too accessed the tables directly. Here are the methods I know of: 1. Update using Python and ctypes. This is a heavy work around. Depending on your workflow, might be good. http://gis.stackexchange.com/questions/255/arcgis-change-feature-class-and-field-aliases-in-bulk 2. Currently, I'm using custom python scripting with FeatureClassToFeatureClass_conversion. Basically creates the FeatureClassToFeatureClass_conversion statement. While creating the statement, does a lookup in a csv file for fieldname and the appropriate field alias name. Ctypes above does this same type method. Hate this idea for numerous reasons (not updated in place, more required scripting to obtain other source database features: Domains, subtypes, attribute indexes, etc.). 3. Some Studio incarnation must be out there. I'm a database guy, so come on Application Developers! Chris Fox may have well done this, as stated in his response in MyIdeas. Here's his toolbox as refered to in the MyIdeas suggestion: http://www.arcgis.com/home/item.html?id=4c0bcc95449f4a67822c7f68dc7c6cd4 I tried this, but our local machines are so tied down, I can hardly breathe.:rolleyes: Good luck! Remember, vote up in MyIdeas.

‎03-07-2013

Did find the command AnalyzeDatasets_management. Having Datasets as part of the name is quite misleading.:( If this performs statistics on the table indexes, why is Feature still in the documentation for Analyze_management?:confused:

‎03-06-2013

ArcGIS 10.1 SP1, data is in SDE, Oracle 11.2.0.2.0 Upon loading a feature class, I have always Analyzed the feature class. Created a python script as I've done this so much. After updating my scripts to 10.1 syntax (arcpy, <tool>_Management or <tool>_management, camel case changes, etc), I have hit a stump. Via a python script: Analyze on the BUSINESS component works fine. Analyze on the FEATURE component gives the following: Traceback (most recent call last): File "<interactive input>", line 1, in <module> File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\management.py", line 13516, in Analyze raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000800: The value is not a member of BUSINESS. Failed to execute (Analyze). We didn't spend long at 10.0. But I do notice a difference in the ArcCatalog GUI between 9.3.1 and 10.1. At 9.3.1, Business and Feature (as well as Raster, Adds, Deletes...) could be Analyzed separately. At 10.1, once you hit Analyze, it's off and running. Now whether or not this automatically runs STATS on each component type, I don't know. The 10.1 documentation still shows that each component type can be Analyzed (via arcpy): http://resources.arcgis.com/en/help/main/10.1/index.html#//0017000000n2000000 In ArcToolbox at 10.1, once an SDE featureclass is selected, the options reduce to one checkbox. BUSINESS. What's up with FEATURES? Is this just not possible/needed? Have I missed something? Anything I should know before creating and digging through into Oracle traces? Guess I could try to create and export a model, though generally I write a script right from the beginning.

‎02-12-2013

In the middle of Crystal Reports' lifespan with Esri, I attended CrystalReports workshops at 2 UC conferences. At both, users asked if a map could be included in the report (imagine that?! A reporting tool in a map application that shows maps!). The 2 Business Objects presenters simply looked at each other, totally lost. Then said it couldn't be done. There were tricks to do this with CrystalReports. Create a report in CrystalReports with an image, add a live link to that image, which is the exported map. But this had it's challenges. The map proportions to begin with. And a lot of programming for the attribute data to get updated (subject data, then point in polygon for several feature classes). Not an easy thing. Still this is needed. Kind of like getting turn-by-turn directions and no possibility of maps. Some people are happy with the one-way reporting. But not good for us spatial thinkers. Grouping functionality (sums, subreports, graphs) needs to be continued and easier to create than CrystalReports.

‎01-14-2013

AlterAliasName (attribute) via Geoprocessing tool is badly needed. With so many databases going to services, managing aliased fields is becoming more frequent. Managing dozens of fields across dozens (hundreds) of datasets is becoming unmanageable, in particular when consistency is desired. I use python and ctypes to do the update for now (calling the alteralias in ArcObjects). But this is a seriously heavy workaround for something that should be less than 10 lines long.

‎08-01-2012

Transform the data using the Project method: http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=project_(data_management) If any exist, read up and use the best Geographic Transformation method.

‎08-01-2012

In Select by Attributes, can do a SELECT IN statement with mdb or SDE with: [NAME] IN (SELECT [NAME] FROM RoadLinework_FC As Tmp GROUP BY [NAME] HAVING Count( [NAME]) > 1) fgdb has issues with certain SQL functions. While most work, others (including "GROUP BY") don't. This is really RDBMS dependent (also for syntax). And when it can be done, biggest trick is to ensure a 1:1 return, not 1:many or many:1. Or, as said above, "It's fixed in 10"

‎06-22-2012

Could be a whole new product. ArcApp for <device>. New business market as well (what if it were sold for $20 on an app/i store). I'd buy one personally. Organization I work for would buy many versus dropping ArcPad due to limited use and development. Seems to me the first one to have totally disconnected editing (no caching) via common devices is going to win. Checking data in/out is a huge bonus. Bluetoothing to a better GPS will take care of the precision for low-grade on board GPS devices. Web/Cloud editing has its market. But the independent/disconnected environment has a huge market and is being left behind.

‎06-22-2012

Extremely painful if you don't know who has the lock. Shutting down the instance is a workaround (albeit, the best we have to guarantee an update!). If you have access to the RDBMS (and some people don't, so a tool WOULD be better), here's a sql statement that will show what machine has the lock (useful for direct connect, really not useful for those utilizing an ArcSDE service or virtualized PCs): select a.lock_type, b.table_name, c.owner, to_char(c.start_time, 'MON-DD-YY HH24:MI:SS') START_TIME, c.nodename from sde.table_locks a, sde.table_registry b, sde.process_information c where a.sde_id = c.sde_id and a.registration_id = b.registration_id;

‎04-30-2012

Ran into the same thing making a cover page for my maps. Change the scalebar. Make the page. zoom to my normal pages. Change the scale bar. Then print pages 2 through X. It is frustrating. Multiple page layouts (long promised, still waiting) could help solve this. Issue has to do with the map scale being stored/calculated each map refresh. You can actually zoom out or in, use the back button, and your scale has changed (and many times, your scalebar).

Online Status	Offline
Date Last Visited	‎10-14-2021 04:35 PM

My Ideas

Latest Contributions by RayChilcote

Re: Error trying to view locks

Re: ArcPad for Android

Re: Configure Roads & Hwys to a specified precision

Re: Version Changes - Ability to export results

Re: Update Field Aliases

Re: Updating Field Alias Names Using SQL Management Studio ----> ArcSDE 10.x

Re: Analyze_management fails for FEATURE component type

Analyze_management fails for FEATURE component type

Re: Better Reporting

Re: Update Field Aliases

Re: Need help projecting data....again

Re: Any tools that allow "GROUP BY" or "DISTINCT" in queries on file gdb data

Re: ArcPad for Android

Re: Identify Source of Schema Lock

Re: Data Driven Pages Scale Bar

Re: Kill only old connections

Privilege assignment in SDE

Re: Error trying to view locks

Re: Error trying to view locks

Re: ArcGIS should allow the ability to permanently...