Latest Contributions by SandraLuken

We have rules to automatically update the created_by/created_date columns for all feature classes. However, one of our editing workflows is to copy data from one feature class to another, preserving most attributes along the way - including the created_by/created_date columns. Is there anyway to add in a rule exception for this feature class, not to change those values even though we have * rules to update these values for all other feature classes? We have 30 features classes to which the * rules apply and 4 feature classes to which they do not, really want to avoid having to explicitly set the created_by/created_date rules for the 30 feature classes. ... View more

We have been able to successfully reproduce two editors working in the same sde geodatabase creating new features with the same ID as generated by Attribute Assistant and the GENERATE_ID method. This has been confirmed looking through the log files from the individual PC's. The DynamicValue and GenerateID tables are not registered as versioned and actually the DynamicValue table is not editable by the editors, only the GenerateID table. The editors are editing against default and not using their own explicit versions. ArcGIS 10.1 SP1 (build 3143) SDE 10.0 SP5 Oracle 10g Sandra ... View more

We have a fully functioning production WMX geodatabase, however we would like to use database cloning on a weekly basis to create a QA version of this environment for testing, development and training purposes. What are the necessary steps we need to run after the database clone to ensure that the QA version and supporting documents are properly configured to work independently of production? We have heard that the same mxds can be used in both production and QA, and will automatically change the database connection depending on the established default geodatabase. However we are having trouble making this work. Appreciated any pointers you might have. ArcGIS 10.0 SP5 Oracle11g Sandra ... View more

ArcGIS 10 SP5 Can you reverse geocode against a composite locator but only return a result from a specific locator within the composite? I was hoping there was a way to do something like the following. http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Locators/ESRI_Geocode_USA/GeocodeServer/reverseGeocode?location=-117.195681386,34.057517097&distance=0&loc=ADDRESS Unfortunately the API documentation does not mention this functionality, so am wondering if others have found an alternate solution. Thanks, Sandra ... View more

ArcGIS Desktop 10.0 SP5 Reference Data in SDE 10.0 SP3 (Oracle11g) Locator stored in a file geodatabase v10 Locator settings Style: General - Single Field Data Sources: both are stored in the same SDE geodatabase [INDENT][/INDENT]Primary table: point feature class [INDENT][/INDENT]Alternate name table: table The problem is encountered when there is any attempt to rebuild this locator. Error messages such as ERROR 000005: Could not open the address locator, are received. After the rebuild process is run, the locator becomes corrupt and cannot be repaired and it must be recreated. This sounds similar to NIM089058, EXCEPT, the data source has not moved, changed names, permissions or schema. In fact I have never been able to rebuild this locator through ArcGIS Desktop or Model Builder, and for a brief period of time thought that this could be rebuilt via Python, but that too is failing. I am now no longer able to rebuild a locator with this type of configuration. This is a huge problem for us, as using Python to recreate the locator is not an option because of the locator settings (such as spelling sensitivity) that can only be updated manually after the locator is built. Thank you for your help, Sandra ... View more

ArcGIS Desktop 10.0 SP5 ArcSDE 10.0 SP2, Oracle11g We have an address locator , stored in a file geodatabase with reference data stored in SDE, that has been corrupted and can no longer be repaired or rebuilt. There is an automated process that runs weekly to rebuild the locator, but it seems that this is corrupting the locator if the reference data is not found at the time of the rebuild ("not found" for us could mean a network hiccup at the wrong time). We have since added error handling into the script to trap for the condition of a failed rebuild and to restore the previous version of the locator, but we are still left with a few questions: 1. Why does the missing reference data source corrupt the locator and not leave it in a state of needing repair? 2. Is there any way to recover from a corrupt locator? Currently we are presented with no option to re-select the reference data, so must recreate the locator from scratch. 3. Why are not all of the locator settings contained in the create locator tool? We often tweak the spelling sensitivity etc which must be done manually after a locator is built. Any help is greatly appreciated. Sandra ... View more

We have found that using Oracle to gather databases statistics will not complete successfully (i.e. processes for 24hours and never finishes). Looking at the spatial and attribute indexes on the feature classes via ArcCatalog everything appears as expected and indicates that there is a spatial index. Using SQL Developer to query the S***_IDX$ tables, it is noticed that they are indeed populated with information. However the SDE.ST_GEOMERTY_INDEX table has null values for columns such as BLEVEL, LEAF_BLOCKS, CLUSTERING_FACTOR. If the spatial index is recalculated (via command line or via ArcCatalog) and then the feature class analyzed, these values are updated and Oracle's gather statistics will then complete in a matter of minutes. Two questions: 1. Why are these columns empty in the first place? We often use the FeatureClassToFeatureClass tool to load data. 2. Why is does the Oracle gather statistics operation fail if the statistics on the spatial indexes are missing? Oracle 11g (Unix) SDE 10.0 SP3 (Windows) ArcGIS Desktop 10.0 SP3 Sandra ... View more

The ArcGIS 10 GDBT release announcement indicated the following functionality: - Table and Index Statistics for geodatabase stored in an Oracle database After installation I see the options for Edit Information, Versioning Lineage, Spatial Index, User Information and Version Information. Nothing for Table and Index statistics. Am I missing permissions to use this functionality? We are using Oracle 11g GDB's with ArcGIS 10 SP3. Sandra ... View more

ArcGIS Desktop 10.0 SP3 Love the attribute transfer tool, except when it does not save my attribute mappings between ArcMap sessions. The unfortunate part is that the attribute mappings might save in a particular map document several times, but then it will stop saving the mappings so they need to be recreated each time the document is opened. Starting with a new document or different data does not help either. With potentially a large number of unique mappings (so auto-match does not help) this can be very time consuming. Originally I thought this was due to broken data sources in the map document, but this does not appear to be the consistent reason for the attribute mappings to disappear. Any others experiencing in consistent behaviour with the attribute transfer tool? Thank you, Sandra ... View more