Latest Contributions by RobRader

‎04-21-2011

The resources page for ESRI highlights the need, but provides no way to merge multiple File Geodatabases that have been edited into a single File Geodatabase. Example is: Feature Class A has a globalid column. Feature Class B has a globalID column. Attributed Relationship class is generated between A and B, using thier globalid columns. (needed an always unique key when multiple systems are editing, so Globalids are guranteed to be managed by GDB and unique). Now copies of the file gdb's are made. 1) Original Filegdb is kept. 2) File GDB is edited. 3) Another file GDB is edited. If you take the changed from one file GDB and merge them to the other (by referencing the original), then the globalid field is auto populated. So what is needed is described in detail ( please read this before you post this is not supported) in Esri's workflow diagram here (Option 1 from ESRI is "Convert between GlobalID and GUID columns"): How to copy or load data and preserve GlobalID values The unregister the GlobalID call (IClassSchemaEditEx) is only supported in a non-versioned ArcSDE environment. I can understand the fact you do not support a versioned SDE.... but what about the FileGDB case just outlined? None of this is versioned data (it can't be in file geodatabase). So what ArcObjects work around is there to temporarily unregister the Global ID column, update it with the needed rows, then re-register the column? Only things I can think of are: A: Try using the File GDB SDK to create my own class/dll/tool since ESRI has not released an ArcObject Class. B: Create yet another GUID field, which I populate with the exact same GUID as the GlobalID before the merge, then use it to swizzle the relationships after the merge. About A: I am hoping someone will let me know if A is even an option. About B: Is extremely complex are it would have to be a loop on all relationships when starting the merge process, to find all the relationships that could possibly be effected, then come up with the code to track the edits for the origin and destination changing, then post processing to swizzle the GUIDs. Hoping that someone will have a work around that allows me to de-register the globalid columns as is recommended in the ESRI workflow documentation. All responses are welcome at this time. Rob

‎04-01-2011

State planes are extremely hard to work with. The limitation of ST_Transform to only be able to work with the same exact datum, meant it would not do what was needed in my case. I had to write an external tool for it. Here is an example of what will work: create one projection and a feature class with a single point in it. create a second projection, exact same but shift the easting and northing by a couple of thousand. ST_TRANSFORM will then be able to shift the data for you to the new projection accounting for the new easting and northing. It appears to be extremely limited to this simple use case. If the datum is the same and the work to be completed by the tranform is more in line with a "data shift" you should work. They might want to rename it. -- just noticed the esri icon next to my name. I used to be an employee, but now work for Telvent. So please do not take my comments as an official statement after 2009. All old posts were as an employee, but no longer.

‎03-09-2011

Did you mean ArcGIS Diagrammer instead of ModelBuilder? Not sure why you'd want to use ModelBuilder to model a database, it's more for modeling processes. The answer given by ESRI has been complex models in Model Builder. The statement was made in the context that they are moving away from Visio / XMI. They then point to being able to design and maintain schema changes via model builder. This does not make sense to me and so I was hoping to get more information from anyone that might of actually tried this incredible feat. Has anyone actually put together one of these models in model builder?http://resources.arcgis.com/content/energy-utilities-data-models

‎03-09-2011

No responses on this one. I am hoping that as the Developers conference goes on this week that there might be more interest in this topic. Again: Complex data models are frequently built in VISIO first, then provided in a Geodatabase. There is a push from ESRI to move the design system to model builder. Has anyone successfully done this? How did you manage design reviews? How did you manage revision control? If there is another thread where this is being discussed, please let me know. Rob

‎11-02-2010

A) The key workflow must include all GDB components such as domains. Using a single GDB that has one of every data type and field, would be a great way to validate this tool is working correctly. B) Use ability defines adoption. If the tool is made, please make sure it handles the extremely complex configuration issues that other ESRI tools seem to miss their first time out. - Handle relationship loops. - Handle multiple features with the same alias name. - Handle the export and import of domains, even if they do not appear assigned to a feature class. This is constantly overlooked. - Provide extremely simple logic to pull out the Schema, avoid putting in erroneous logical checks that are not documented or enforced anywhere else. - Fix the XML export so it also follows this logic.

‎06-24-2010

I am using ST_GEOMETRY to create points for old GPS data. The machines used NAD27 state plane VI (0406). The dataset for all of the rest of the data in the geodatabase is NAD83 state plane VI (0406). In comparing the strings for these two it looks like the datums do not match. So there is no way to translate as a 1:1 from one to the other. However... is there some magical projection I can use as an interim step? example of what I am trying to do: SQL> column SR_NAME format A50 SQL> select srid,sr_name from sde.st_spatial_references; SRID SR_NAME ---------- -------------------------------------------------- 0 GCS_WGS_1984 3 NAD_1983_UTM_Zone_11N 5 WGS_1984_UTM_Zone_11N 2 NAD_1927_StatePlane_California_VI_FIPS_0406 4 NAD_1983_StatePlane_California_VI_FIPS_0406_Feet SQL> select sde.st_astext(sde.st_transform(sde.st_point('point(1 1)',0), 5) ) from dual ; SDE.ST_ASTEXT(SDE.ST_TRANSFORM(SDE.ST_POINT('POINT(11)',0),5)) -------------------------------------------------------------------------------- EMPTY SQL> select sde.st_astext(sde.st_transform(sde.st_point('point(1 1)',5), 0) ) from dual ; SDE.ST_ASTEXT(SDE.ST_TRANSFORM(SDE.ST_POINT('POINT(11)',5),0)) -------------------------------------------------------------------------------- POINT ( -121.48874115 0.00000275) now to use the projections I need: SQL> select sde.st_astext(sde.st_transform(sde.st_point('point(1 1)',2), 4) ) from dual ; ERROR: ORA-20603: Spatial References are not compatible. ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 788 ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 2600 Any input on how to know when a projection datum matches might help.

‎04-09-2010

I understand that the process in use by many customer's of building a data model in Visio and then Exporting it to XMI to build their initial data schema is being planned as being replaced by model builder. Has anyone built a complex data model (thinking 350 Feature classes, 25 datasets, 500+ relationships) into a model builder application to see if it will run? I know these exist for some customers in Visio, but looking for a single customer who has done more than a small model in model builder. Feel free to post if you have thoughts or ideas on this question. A) How did you handle "buy off" scenarios between teams? B) How did you revision control the model? C) What sort of model components did you need to complete your project? Rob P.S. I personally can't imagine using the model builder interface to do a "search" on the model or handle the complexities of trying to build and get initial buy off. So just to be clear I am looking for anyone who used model builder for this type of work flow. Rob

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

My Ideas

Latest Contributions by RobRader

Need workaround for Global ID unregistration, back to GUID temporarily.

Re: ST_Transform matching datums.... ?

Re: model builder replacing XMI ?

Re: model builder replacing XMI / VISIO ?

Re: Create a UML Profile of the Geodatabase for Geodatabase Design

ST_Transform matching datums.... ?

model builder replacing XMI ?

ST_Transform matching datums.... ?