Latest Contributions by RPGIS

Hi, I encountered an issue regarding creating a relationship feature class in a test sde database. The issue that I encountered is the script will create the relationship class, but for some reason none of the data relates for some reason. At first, I thought it might be due to none of the related features having data in them as a possibility. I ran the same script with data in both of the features and it worked. I don't know why this would be an issue or if anyone else has had similar issues, but I would like to know if there is a way to make certain that this won't happen again next time the script runs.       # Import arcpy da modules from arcpy.da import ( # Import functions/classes pertaining to editing features in databases Editor as Editing, SearchCursor as Searching, InsertCursor as Inserting, UpdateCursor as Updating, # Import functions/classes pertaining to looping or creating item lists ListDomains, Walk, ListVersions, ListContingentValues ) # Import arcpy management modules from arcpy.management import ( # Creating features CreateFeatureDataset as MakeDataset, CreateFeatureclass, CreateTable , # Feature field modifications AddField, AlterField as ModifyField , DeleteField , # Creating, deleting, or modifying domains CreateDomain, AlterDomain, AddCodedValueToDomain as AddCode, DeleteCodedValueFromDomain as DeleteCode, SetValueForRangeDomain as SetRange, DeleteDomain, AssignDomainToField, RemoveDomainFromField , # Attribute rules EnableAttributeRules, DisableAttributeRules, AddAttributeRule, AlterAttributeRule, DeleteAttributeRule , # Creating feature relations CreateRelationshipClass as MakeRelation, AddRelate, RemoveRelate , # Establishing roles and users CreateRole, ChangePrivileges, CreateDatabaseUser, ChangePrivileges, UpdatePortalDatasetOwner , # Updating licensing information UpdateEnterpriseGeodatabaseLicense as LicenseUpdate , # Enabling or disabeling editor tracking on features EnableEditorTracking as TrackEdits, DisableEditorTracking as StopTrackEdits , # Managing versions CreateVersion, ChangeVersion, AlterVersion, DeleteVersion , RegisterAsVersioned , UnregisterAsVersioned , # Creating contingent values CreateFieldGroup , AlterFieldGroup , DeleteFieldGroup , AddContingentValue , RemoveContingentValue , # Add global ids AddGlobalIDs , # Create database connections CreateDatabaseConnection , # Manage layer symbology from existing layer ApplySymbologyFromLayer , # Make a feature layer MakeFeatureLayer , SaveToLayerFile ) # Create relationship table between certain feature classes def RelateFeatures( InputDatabase, RelateFeaturesDictionary ): Tab = ' ' * 4 print ( f'Creating relationship classes for relations in { list( RelateFeaturesDictionary ) }' ) # Important variables Relationships = 'Relationships' Origin, Destination, ToLabel, FromLabel, Field = 'Origin', 'Destination', 'ToLabel', 'FromLabel', 'Field' To, From, Both, Neither = 'FORWARD', 'BACKWARD', 'BOTH', 'NONE' Attributed, NotAttributed = 'ATTRIBUTED', 'NONE' Simple, Composite = 'SIMPLE', 'COMPOSITE' OneCardinality, OneManyCardinality, ManyCardinality = 'ONE_TO_ONE', 'ONE_TO_MANY', 'MANY_TO_MANY' # Important feature classes and tables FeatureClasses = { filename : Combine( InputDatabase, filename ) for root, directory, filenames in Walk( InputDatabase, datatype='FeatureClass' ) for filename in filenames } Tables = { filename : Combine( InputDatabase, filename ) for root, directory, filenames in Walk( InputDatabase, datatype='Table' ) for filename in filenames } # Get all relationship feature classes Relationships = { filename : Combine( InputDatabase, filename ) for root, directory, filenames in Walk(InputDatabase, datatype='RelationshipClass') for filename in filenames } ValidateExistingRelationships = [ RelateName for RelateName in RelateFeaturesDictionary for ExistingRelation in Relationships if RelateName in ExistingRelation ] # Create the relationships for each named relation in the dictionary for Relation in RelateFeaturesDictionary: OriginName = RelateFeaturesDictionary[ Relation ][ Origin ] DestinationName = RelateFeaturesDictionary[ Relation ][ Destination ] RelationshipClass = Combine( InputDatabase, Relation ) OriginFeature = None DestinationFeature = None OriginLabel = RelateFeaturesDictionary[ Relation ][ ToLabel ] DestinationLabel = RelateFeaturesDictionary[ Relation ][ FromLabel ] KeyField = RelateFeaturesDictionary[ Relation ][ Field ] # Get the origin feature from either feature classes or tables for Name in FeatureClasses: Fullname = None if '.' in Name: Fullname = Name.split( '.' )[ -1 ] if Fullname == OriginName: OriginFeature = FeatureClasses[ Name ] # Get the destination feature from either feature classes or tables for Name in Tables: Fullname = None if '.' in Name: Fullname = Name.split( '.' )[ -1 ] if Fullname == DestinationName: DestinationFeature = Tables[ Name ] # Create the relationship class if the relationship class does not exist if Relation not in ValidateExistingRelationships: NewRelation = MakeRelation( OriginFeature, DestinationFeature, RelationshipClass, Simple, OriginLabel, DestinationLabel, To, OneManyCardinality, NotAttributed, KeyField, KeyField ) print ( f'{ Tab }{ NewRelation } has been created between { RootName( OriginFeature ) } as the origin and { RootName( DestinationFeature ) } as the destination' ) print ( '\n' ) return # Core relationship features Relationships = { 'Relationship Name' : { Origin : FeatureA, Destination : TableA, ToLabel : 'To Message', FromLabel : 'From Message', Field : 'Selected Field Name' } } # Create relationships RelateFeatures( MainDatabase, Relationships )       ... View more

Hi,   I ran into a bit of an issue regarding domain values from a list of domains in a database. I don't know if there are limitations regarding a .fgdb vs .sde databases, but I wanted to see if there was a way to get either the range values or the coded values from an .sde database. I wrote a script to access it, which seems to work partially, but I am not sure why it isn't working on an .sde database. Any help on this would be appreciated.   import arcpy, os, datetime from arcpy import ListFields, CreateFileGDB_management as CreateGDB, Point from arcpy.da import Editor as Editing, SearchCursor as Searching, InsertCursor as Inserting, UpdateCursor as Updating, Walk, ListDomains as GetDomains from arcpy.management import CopyFeatures as ReplicateFeature, CreateFeatureDataset as MakeDataset, CreateRelationshipClass as MakeRelation, CreateTable, AddField from arcpy.conversion import ExportTable as ReplicateTable from datetime import datetime, timedelta from os import chdir as SetDirectory, mkdir as CreateDirectory from os.path import basename as RootName, join as Combine, exists as Existing, dirname as ParentDirectory, isfile # Get coded domains and descriptions for populating specific fields def CodedDomains(Database, SpecifiedDomain): DomainValues = None if '.gdb' in Database: for Domain in GetDomains(Database): if Domain.name == SpecifiedDomain: DomainValues = Domain.codedValues return DomainValues CodedValues = CodedDomains(Database, DomainName) for Code, Value in CodedValues.items(): print (f'"{Code}": "{Value}",') ... View more

Hi, General question, is it possible to use the attributes rules to insert records from one table to another using arcade. I can't seem to find any documentation stating that it is but I am hoping to get some answers. If this isn't possible, then I will stick with modifying my python script in conjunction with the other attribute rules that I have already created. ... View more