Latest Contributions by AndrewRudin

‎02-05-2014

SDE Enterprise 10.2 (Oracle11gR2) and Desktop 10.2. I will use FME to edit the primary SDE. We don't use replication since it has so much overhead. It requires versioning, and globalid's and the schema's have to match between databases (yuck!). Just give me a tool to read a UNIQUE_ID column and a date_field that holds the last time each feature was updated from both databases and figure out the inserts/updates/deletes/unchanged records. Plus FME has much better scheduling abilities. On the publishing SDE I want the geometric network available so our engineers can use it for tracing. It needs to have network flow set to the digitized direction, and this is the one step that forces me to version the data, no matter how hard I try to avoid it. Here's the workflow I was originally going for: I originally planned for the dataset on the primary viewing SDE to be unversioned for simplicity. Our GIS administrators are very leery about having a versioned dataset on such a heavily used database. 1) Editors on the editing SDE make edits in versions. Custom tools populate a UNIQUE_ID field based on an oracle sequence and update a MODIFIED_DATE field. 2) Editor versions are posted to default when their complete 3) Each night, FME workspace runs and compares ID's/dates and pushes inserts/updates/deletes. The FME SDE30 writer will edit the feature classes directly, bypassing edit session and versioning requirements. 4) Once FME script is done all feature classes have the latest data 5) Recreate the geometric network using the arctoolbox tool, since FME doesn't update the background tables that drive the geometric network. 6) Version the dataset 7) Run the set flow toolbox tool to get digitized direction flow 😎 Unversion dataset and choose to have edits in Default version compress to base. This workflow would prevent the database from having to be versioned as little as possible, however steps 5,6, and 8 will definitely require no schema locks to exist. I saw that at 10.2.1 the 'Rebuild' and 'Repair' network tools are in the toolbox now so I guess I dont need to delete and recreate the network after all. To avoid making the schema changes each night I was thinking of instead leaving the dataset on the primary SDE permanently versioned. Then I'd use the slower FME writer that writes to versioned SDE's using proper ESRi edit sessions. It would right directly to the default version. Then I'd probably need to run the Repair and 'Set Flow' tools on the network since I don't think FME is great at handling these while writing features. The last big step is the compress to make sure the edits make it into the base table so the database is nice and clean. If there are users and web maps looking at the default version when the compress happens at night, will it still compress the edits I just made to base?

‎02-05-2014

I am trying to come up with a compress workflow. I was hoping someone had clarification for what happens to states when users or web map services are looking at the data when a compress is run. Here is the scenario: We have a primary SDE that all general users and all web services access to use GIS data. Then we have an editing SDE where GIS editors modify the data. That data is then synced to the primary SDe nightly. Currently the primary SDE is entirely unversioned, however now we want to host a dataset with a geometric network. To update this dataset the primary SDE will need to have versions(we'd probably just edit default directly) and once the sync is complete we'd need to a compress. However its my understanding that if there is a lock on states in an SDE then the compress will ignore the lineage for the state that's being viewed. So I'm not sure we'd get an effective compress if lots of users and web maps are looking at DEFAULT. I'd like to avoid kicking everyone off the server if I can, even if its at night since the web services are accessed external to our organization. There really isnt any other editing on the server... only nightly python/FME data pushes through non-versioned operations. Thanks for any help you can provide

‎09-12-2013

I'm having trouble getting a SELECT query in PL/SQL to actually return records from a version in my Oracle SDE. I tried with a query layer too but I just can't seem to get the EXEC sde.version_util.set_current_version('') command to work. I'm using a 10.1 SP1 client. My test SDE database is 10.2 Here's how to recreate my little test environment: 1. In ArcCatalog, create a new point feature class on the SDE named 'MY_FC' 2. Version the feature class 3. Right click on the feature class, then click Manage, and then Create Versioned View. This created a view named MY_FC_VW 4. Create a geodatabase version on the SDE named 'MY_VERSION'. It will be a child of the default version 5. Open ArcMap, add the feature class, point it to the version, and add one point to it, then save edits and stop editing So now the goal is to run a query from PL/SQL that will return that new point record while it is in that child version, and this is where I get lost. I'm using the ESRI help as a guide (http://resources.arcgis.com/en/help/main/10.1/index.html#/in_Oracle/006z0000000v000000/) 6. Open PL/SQL and connect to the database 7. Open a SQL window and run the command EXEC sde.version_util.set_current_version('MY_VERSION') -This is when I get an error ORA-00900: Invalid SQL Statement. -A coworker recommended trying to run this command in the PL/SQL command window as the following: BEGIN EXEC sde.version_util.set_current_version('MY_VERSION') END; -But then I couldn't figure out how to run the select statement and see a returned record. Anyone have any ideas? I ultimately just need to run a query external of ArcGIS that returns all the records in a feature class for a particular version in the geodatabase, and then extract those records to a csv file.

‎06-11-2013

I have just upgraded to Workflow Manager 10.1 I am trying to test out the new "Export Job to File" function as a way to archive old jobs that no longer need to be in our system every day. However, when i select a job from a query and then right click on it, the "export job to file" option is greyed out. Is there something I have to do after upgrading to 10.1 to enable this option? I have every security privilege. Thank you

‎08-22-2012

Anyone running into problems with compatibility of model builder models between 10.0 and 10.1? We are in the process of upgrading our power users to 10.1 for testing and I noticed the problem below when trying to work on a new model. I created a model in an SDE toolbox at 10.1. When users with 10.0 clients try to browse for it, the toolbox is present, but the model is not visible. I was looking for a way to downgrade my model, but there is no option for that. In addition, if I create a model in an SDE using a 10.0 client, and then modify that model with a 10.1 client, the contents of the model are not visible from the 10.0 PC. So not sure if this is a fluke or by design.

‎07-12-2012

Whats the latest version of ArcGIS Diagrammer for 10.0 and where is it housed now? I have 10.0.1. Reason I ask is I've run into a problem publishing the schema for a feature class that contains subtypes. I've narrowed the problem down to either the import of the XML into Digrammer, or the publishing from Diagrammer to XML based on the test below... 1. Have an existing working schema on an SDE 10.0 SP3(Oracle11g) database which contains subtypes. 2. Export to xml schema with ArcGIS tool. -I've attached the XML created for my problem layer at this point. 3. Just to prove this schema is valid, try reimporting into SDE and it works. 4. Now open that XML from step 2 into ArcGIS Diagrammer, and immediately publish it to another XML. 5. When you import this second XML into SDE, I get an error about reading a string at column 80,232 of line 1 or something like that. Feature classes without subtypes assigned do not create errors when put through the same test above. Thanks for any help you can provide -Andrew

‎06-13-2012

forgot to say, I'm at ArcGIS Desktop(and Data Reviewer) 10, sp3. SDE is Oracle11g

‎06-13-2012

When I try and do a table to table check and try to it up to compare a date field on either table, all date fields are removed as options in the drop-down list. Is there a reason date fields can't be used with this field like numeric fields? I'm using the 'Comapre attributes' option on the check so that I can just select the two or 3 fields I want to use for the comparison. Ultimately what I'm trying to do is find differences in dates between two copies of the same feature class on different SDE's. I have a detention pond polygon feature class on one server, and a published copy on another. Both have a UNIQUE_ID field and a DATE_UPDATED field. For the check, I want to match up the records on both sides using the UNIQUE_ID field, and then look to see which records have the DATE_UPDATED field value greater one one server.

‎06-06-2012

When I try to move a layer into the BaseMap layer group I get an arror if that layer's source is an SDE connection that doesn't save username, password, or version. I have many of these types of layers in the MXD's we use. Even though I entered the credentials for these layers when I open the MXD, when I try to drag all of them into the Basemap Group layer, I get asked for the username and password for EVERY one of them, and then they don't work. This limitation prevents us from taking advantage of the Basemap layer in many of our most used MXD's. And having every user just login with one global SDE login so we can save the credentials in the layers is not an option for us, nor is it a best practice for database administration....

‎06-06-2012

In the ArcPy Mapping Module, please add the property named 'serviceProperties' to the TableView class. This property exists on the 'feature layer' class and allows ptyhon programmers like myself identify what server a particular SDE layer is coming from. I am trying to write a Python tool to repoint all the sources in a particular MXD from one server to another. However the MXD contains layers and table views from multiple SDE's, I just want to repoint the data from one SDE(Like repointing data sources from a Test SDE to a production SDE). The 'replacedatasource' method for repointing layers is insufficient, since it relies on me the programmer knowing what the path is to the SDE connection file used to add the table to the map. However, since I am just the programmer, I have no idea what the name of particular SDE connections users added data from. I'd rather just search each layer and tableview and check the service or server line to see if the name of a particular server is there. If it is I can run my code to repoint the layer to a different server.

‎04-30-2012

I'm looking into the possibility of using cartographic representation to store a standardized symbology for data on our SDE. I've run into a few stumbling blocks and hope someone might have some answers.... 1) I have a pipe layer I like to symbolize by category using a field named 'TYPE'. When I created the representation on the feature class, I gave it an LYR file with my categories in it, and it created a representation with 12 or so rules for the 12 different categories. It also populated the RULEID field on each feature with the appropriate rule. Now I'm trying to go in and create a new feature in the edit session. When I change the value in the 'TYPE' field, the appropriate representation rule is not being populated in the RULEID field. Is it possible to have the RULEID field auto-populated when another field changes value? Or is this something that has to be populated separately? 2)Is there some sort of rule or limitations to how the representation itself is named? I tried to name the representation on my pipe layer to something generic like 'PRIMARY' so that people would know which representation is the 'standard or popular' way of symbolizing the data if there are multiple representations. However I was told by the software this name was invalid; and I couldn't find any restrictions in the help on naming conventions. 3). There in SDE(Oracle) specifically are the individual symbology for the rules stored? I can't find a table and I'm not good at navigating the new SDE10 XML structure yet.

‎03-12-2012

A lot of our users would prefer to store just a link to a folder. That way they don't have to micromanage all the attachments on each feature if there are alot of related documents. This works only if a group happens to have related data already organized with one folder setup for every feature...but if you give people the option they can decide which way is best for their organization

‎03-12-2012

A lot of our users would prefer to store just a link to a folder. That way they don't have to micromanage all the attachments on each feature if there are alot of related documents. This works only if a group happens to have related data already organized with one folder setup for every feature...but if you give people the option they can decide which way is best for their organization

‎03-08-2012

Add the ability when enabling attachments on feature classes, I have the option to store just a link to files in the attachments table. I would much rather store Photos, Documents, and other files related to a feature in a place on a shared drive so anyone and any application can easily get to them without ArcGIS. I don't want to store blobs for photos and documents in our database. Storing blobs in SDE means any other application we write that needs to see those attachments will have to tack on some ArcObjects code to pull out the file. This would be similar to the difference between managed and unmanaged raster catalogs.

‎03-08-2012

Add the ability when enabling attachments on feature classes, I have the option to store just a link to files in the attachments table. I would much rather store Photos, Documents, and other files related to a feature in a place on a shared drive so anyone and any application can easily get to them without ArcGIS. I don't want to store blobs for photos and documents in our database. Storing blobs in SDE means any other application we write that needs to see those attachments will have to tack on some ArcObjects code to pull out the file. This would be similar to the difference between managed and unmanaged raster catalogs.

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by AndrewRudin

Re: SDE compress with locks

SDE compress with locks

How to query a versioned view in PL/SQL Developer?

WMX 'Export Job to File' not working

Model Builder Models - 10.1/10.0 compatibility

ArcGIS Diagrammer for 10.0 subtype bug

Re: Date fields not usable in Table to Table check?

Date fields not usable in Table to Table check?

Make Basemap layer in ArcMap work with SDE layers with no username/password saved

Add 'serviceProperties' property to the Arcpy TableView class

Using Cartographic Representation as default SDE symbology

Re: UnManaged Attachments

Re: UnManaged Attachments

UnManaged Attachments

UnManaged Attachments

Re: How to identify donut holes with the Field Cal...

Create blank MXD from python?

Create blank MXD from python?

How to add data from ArcGIS Online to ArcGIS Pro?

Is there a way to view Socrata data on an ArcGIS O...