Latest Contributions by RexRobichaux2

Hello Ahmad,   Although this doesn't really answer your question regarding the versioning toolbar or the GDB administration GUI- perhaps the Create Version GP tool (also scriptable) might provide what you are looking for since it is based on the input .sde connection file (to the respective database)- and therefore specific to the database you choose. Hope this helps! -Rex ... View more

Hello Chris,   The only methods that I can think of that might work for you depending upon the nature of the data and your needs would be to create new SQL views in the database using our current select / sql queries. Once you create these views in SQL, they could be consumed in ArcGIS clients so long as they have the necessary prerequisites (spatial or non-spatial). For example, I used a similar query to create a non-spatial tabular SQL view which can be added in ArcMap and viewed: Create view Acres (Acres, acrescount) as select Acres, COUNT(*) from dbo.CITYBND where DATA = 'Elm City' group by Acres; The other option which might work would be to create definition queries within your existing tables / feature classes although this will vary depending on the nature of the SQL statements used. I hope this is helpful! ... View more

Hello Chris,    I have this SQL query that might be relevant for what you are trying to do- if nothing else I think it will allow you to modify it depending upon if you're interested in associated domains and if domains are used in conjunction with subtypes (looks like they are from your screenshot). As you suggested- subtypes and domains are largely managed / stored within the gdb_items and gdb_itemtypes tables (if your geodatabase is dbo schema just change table owner schema from sde. to dbo.- the rest should work as is): SELECT distinct st.SubtypeCode, st.SubtypeName, st.DomainName, dom.DomainCode, dom.DomainValue FROM   (SELECT   subtype.value('SubtypeCode[1]' , 'nvarchar(max)') AS "SubtypeCode", subtype.value('SubtypeName[1]' , 'nvarchar(max)') AS "SubtypeName",   subtype.value('descendant::Dom ainName[1]', 'nvarchar(max)') AS "DomainName" FROM   dbo.GDB_ITEMS AS items INNER JOIN dbo.GDB_ITEMTYPES AS itemtypes ON   items.Type = itemtypes.UUID CROSS APPLY   items.Definition.nodes('//Subt ypes/Subtype') AS Subtypes(subtype)) st INNER JOIN (SELECT items.Name, codedValue.value('Code[1]', 'nvarchar(max)') AS "DomainCode", codedValue.value('Name[1]', 'nvarchar(max)') AS "DomainValue" FROM dbo.GDB_ITEMS AS items INNER JOIN dbo.GDB_ITEMTYPES AS itemtypes ON items.Type = itemtypes.UUID CROSS APPLY items.Definition.nodes ('//CodedValues/CodedValue') AS CodedValues(codedValue)) dom ON st.DomainName = dom.Name   ... View more

Hello Kathleen,    Thanks for posting up your question. The answer really depends upon what you need out of your potential UID / OID field. Generally speaking, if your data is currently in feature class / file geodatabase format chances are that your five feature classes already have OID (something like an OBJECTID field) fields as it's required by ArcGIS. That said, if they for some reason lack a unique identifier field, you have a few options, you can either copy and paste each feature class in the same file geodatabase which will create a copy with a new unique / OID field, or if you want a unique field in the form of a global ID, you can right click each feature class < Manage < Add Global IDs.    Keep in mind that if the records / rows in each feature class vary, their respective OID values will also vary accordingly. More information on OID fields can be found here: Fundamentals of ObjectID fields—Help | ArcGIS Desktop  I hope this information is helpful!  -Rex ... View more

Hello Brandi,   This is Rex with Support Services. We expect PostgreSQL 10.3 supportability to begin with the upcoming 10.6.1 / Pro 2.2 releases. I hope this is helpful! ... View more

Hi Nathan,   Based on this part "   how do I relate these two tables by connecting (cross join) several fields such as "street name = street name and house number = house number"" - I'd say the easiest thing for you might be to concatenate / combine the multiple fields that you wish to cross-reference in each table into single columns, and then base your join or relate (depending upon cardinatlity) on the newly merged field in each. What is the expected cardinality? I'm guessing 1:M where one city can be related to many restaurants correct? About joining and relating tables—Help | ArcGIS for Desktop  ... View more

Hello Michael,   Thanks for bringing this behavior in Pro to light. Would it be possible for you to share a simple / sample query layer syntax with an example subset selection that I could test this out with? Also- does the same query layer and selection subset function as expected in ArcMap? Thanks in advance! Best- Rex  Geodatabase‌ Managing Data‌ ... View more

Hello Blake,    There are two possible options for enabling editor tracking to record time in database time / local time, by using the dataset's   Properties   dialog box, or by using the   Enable Editor Tracking   tool. The following instructions describe these methods. Using the dataset's Properties dialog box Right-click the dataset in the   Catalog   window and click   Properties. Click the   Editor Tracking   tab and check the Enable editor tracking   option. Set the fields to be updated when a feature is created or edited. Note:The desired fields must be an existing field with Date data type. Click the Fields tab to define a new field prior to enabling editor tracking. For more information regarding adding a new field, refer to the following web help document, ArcGIS for Desktop Help: Adding fields. Specify the dates to be recorded in   Database Time. Using the Enable Editor Tracking tool The tool allows users to select the local database time for the date field in the attribute table. For more information about the Enable Editor Tracking tool, refer to the following web help document,   ArcGIS Help: Enable Editor Tracking . Note:Unlike enabling the editor tracking in a dataset's properties, the Enable Editor Tracking tool does not require an existing date field. Users can add a new field automatically by checking the Add fields if they don't exist option. Note:Recording the time in the database’s time zone is recommended only if users are certain all edits are to be performed within the same time zone. Note:These procedures only change the time option in the set feature class. To enable the editor tracking on multiple feature classes, Python code is required. I hope this is helpful for you! Best- Rex ... View more

Hello Sendhil,   There is a chance you are running into an older 10.0-10.2 defect:  NIM095025: Load object tool from ArcMap fails to load a standalone table into a standalone table and produces the error “No Targets Available: Cannot load, no targets match the geometry type of the selected source(s)”.  The workaround for this defect was to attempt the load operation through ArcCatalog instead of ArcMap. With that in mind- I'd consider trying the load through Catalog to see if that works for you. If it does, it's likely related to the above bug- if not, then there might be something annotation or data specific prohibiting the load from completing successfully. I hope this is helpful! ... View more

Hello Janaki,   It looks like the port #5432 is still being referenced as the instance name. What is the machine name of VM#2 (the PostgreSQL Server machine)? Try entering the machine name where Postgres is running as the instance input (Is it maybe  geodb01b or  geodb01a?)? See if that runs successfully.  ... View more