IDEA
|
Go to Conversion tools - To Geodatabase - Feature class to Feature class. This tool has a field map where you can right click the Global ID field and delete it (if you don't need it) This will save a new copy of the layer without the Global IDs. Then you will be able to perform your spatial join. Remember, this is assuming you don't need the Global ID field.
... View more
12-13-2021
01:46 PM
|
0
|
0
|
848
|
POST
|
This is the log file. I am interested in the intersecting feature attempts with CP test location. I got it to work the first time, as you will see in the file. But when I deleted the features and tried again, it did not work. Update intersecting feature works. So do the other methods listed in the log file. I need to find out if our audit extension is interfering with the AA rules.
... View more
05-17-2017
11:13 AM
|
0
|
0
|
588
|
POST
|
This is the log file. I am interested in the intersecting feature attempts with CP test location. I got it to work the first time, as you will see in the file. But when I deleted the features and tried again, it did not work. Update intersecting feature works. So do the other methods listed in the log file. I need to find out if our audit extension is interfering with the AA rules.
... View more
05-17-2017
11:12 AM
|
0
|
0
|
588
|
POST
|
Edit Log Started at: 5/17/2017 1:03:13 PM ----------------------------------------- Attribute Assistant start editing Process Count: 0 Unwiring the events ####################################################### CP_Test_Location - ON_CREATE Starting AA *********************************************************** ############ 5/17/2017 1:03:30 PM ################ Setting sort order: Field - RUNORDER Querying table for Last Value for layer: CP_Test_Location Query Used: (TABLENAME = '*' OR TABLENAME = 'CP_Test_Location' OR TABLENAME like 'CP_Test_Location|*' OR TABLENAME like 'CP_Test_Location|%') AND VALUEMETHOD = 'Last_Value' Number of results: 0 Querying table for rules for layer: CP_Test_Location Query Used: (TABLENAME = '*' OR TABLENAME = 'CP_Test_Location' OR TABLENAME like 'CP_Test_Location|*' OR TABLENAME like 'CP_Test_Location|%') AND ON_CREATE = 1 Number of results: 2 Looping through the rows ------------------------------------------------ Row Info Row Number 1 TableName: CP_Test_Location FieldName: CPCNTRLNUM_A ValueInfo: Gas_Main_Dec30th_2016|CPCNTRLNUM|F ValueMethod: INTERSECTING_FEATURE On Create: 1 On Change: 0 Checking for Subtype Restriction Field Name: CORCON Control Number A was found at index: 22 Trying: INTERSECTING_FEATURE Starting to process rule Value Info is: Gas_Main_Dec30th_2016|CPCNTRLNUM|F Layer Found: Gas_Main_Dec30th_2016 CPCNTRLNUM: at 68 map tolerance: 1.5625000000058 spatial tolerance: 0.00328083333333333 Using Layer: Gas_Main_Dec30th_2016 Searching on Layer Selected features count:1 Searching on Selection Set Cursor created Starting Loop of found features Checking Class Different FCs Setting Value: 801345456 Value Set Feature count: 0 Option: First Finished: INTERSECTING_FEATURE ------------------------------------------------ ------------------------------------------------ Row Info Row Number 2 TableName: CP_Test_Location FieldName: ValueInfo: Gas_Main_Dec30th_2016|CPSYSTEMSTATUS|UP ValueMethod: UPDATE_INTERSECTING_FEATURE On Create: 1 On Change: 1 Checking for Subtype Restriction Field is not specified, empty, or set for all. Trying: UPDATE_INTERSECTING_FEATURE Getting Value Info Checking values UP at index -1 Value used UP Finished: UPDATE_INTERSECTING_FEATURE ------------------------------------------------ DONE --------------------------------------- ####################################################### Gas_Main_Dec30th_2016 - Created through AA rules - Running ON_CHANGE Starting AA *********************************************************** ############ 5/17/2017 1:03:30 PM ################ Setting sort order: Field - RUNORDER Querying table for Last Value for layer: Gas_Main_Dec30th_2016 Query Used: (TABLENAME = '*' OR TABLENAME = 'Gas_Main_Dec30th_2016' OR TABLENAME like 'Gas_Main_Dec30th_2016|*' OR TABLENAME like 'Gas_Main_Dec30th_2016|%') AND VALUEMETHOD = 'Last_Value' Number of results: 0 Querying table for rules for layer: Gas_Main_Dec30th_2016 Query Used: (TABLENAME = '*' OR TABLENAME = 'Gas_Main_Dec30th_2016' OR TABLENAME like 'Gas_Main_Dec30th_2016|*' OR TABLENAME like 'Gas_Main_Dec30th_2016|%') AND ON_CHANGE = 1 Number of results: 1 Looping through the rows ------------------------------------------------ Row Info Row Number 1 TableName: Gas_Main_Dec30th_2016 FieldName: OPERATINGSTATUS ValueInfo: RETPL|Retired_Gas_Main ValueMethod: COPY_FEATURE On Create: 0 On Change: 1 Checking for Subtype Restriction Field Name: Operating Status was found at index: 65 Trying: COPY_FEATURE Feature and valueinfo is valid Splitting up value info: RETPL|Retired_Gas_Main COPY_FEATURE: Field listed in the Field Name did not change, skipping Finished: COPY_FEATURE DONE --------------------------------------- ####################################################### Wiring the events Process Count: 0 Unwiring the events ####################################################### CP_Test_Location - ON_CREATE Starting AA *********************************************************** ############ 5/17/2017 1:03:54 PM ################ Setting sort order: Field - RUNORDER Querying table for Last Value for layer: CP_Test_Location Query Used: (TABLENAME = '*' OR TABLENAME = 'CP_Test_Location' OR TABLENAME like 'CP_Test_Location|*' OR TABLENAME like 'CP_Test_Location|%') AND VALUEMETHOD = 'Last_Value' Number of results: 0 Querying table for rules for layer: CP_Test_Location Query Used: (TABLENAME = '*' OR TABLENAME = 'CP_Test_Location' OR TABLENAME like 'CP_Test_Location|*' OR TABLENAME like 'CP_Test_Location|%') AND ON_CREATE = 1 Number of results: 2 Looping through the rows ------------------------------------------------ Row Info Row Number 1 TableName: CP_Test_Location FieldName: CPCNTRLNUM_A ValueInfo: Gas_Main_Dec30th_2016|CPCNTRLNUM|F ValueMethod: INTERSECTING_FEATURE On Create: 1 On Change: 0 Checking for Subtype Restriction Field Name: CORCON Control Number A was found at index: 22 Trying: INTERSECTING_FEATURE Starting to process rule Value Info is: Gas_Main_Dec30th_2016|CPCNTRLNUM|F Layer Found: Gas_Main_Dec30th_2016 CPCNTRLNUM: at 68 map tolerance: 1.5625000000058 spatial tolerance: 0.00328083333333333 Using Layer: Gas_Main_Dec30th_2016 Searching on Layer No Selected features No Selected Features Cursor created Starting Loop of found features Checking Class Different FCs Setting Value: Value Set Feature count: 0 Option: First Finished: INTERSECTING_FEATURE ------------------------------------------------ ------------------------------------------------ Row Info Row Number 2 TableName: CP_Test_Location FieldName: ValueInfo: Gas_Main_Dec30th_2016|CPSYSTEMSTATUS|UP ValueMethod: UPDATE_INTERSECTING_FEATURE On Create: 1 On Change: 1 Checking for Subtype Restriction Field is not specified, empty, or set for all. Trying: UPDATE_INTERSECTING_FEATURE Getting Value Info Checking values UP at index -1 Value used UP Finished: UPDATE_INTERSECTING_FEATURE ------------------------------------------------ DONE --------------------------------------- ####################################################### Gas_Main_Dec30th_2016 - Created through AA rules - Running ON_CHANGE Starting AA *********************************************************** ############ 5/17/2017 1:03:54 PM ################ Setting sort order: Field - RUNORDER Querying table for Last Value for layer: Gas_Main_Dec30th_2016 Query Used: (TABLENAME = '*' OR TABLENAME = 'Gas_Main_Dec30th_2016' OR TABLENAME like 'Gas_Main_Dec30th_2016|*' OR TABLENAME like 'Gas_Main_Dec30th_2016|%') AND VALUEMETHOD = 'Last_Value' Number of results: 0 Querying table for rules for layer: Gas_Main_Dec30th_2016 Query Used: (TABLENAME = '*' OR TABLENAME = 'Gas_Main_Dec30th_2016' OR TABLENAME like 'Gas_Main_Dec30th_2016|*' OR TABLENAME like 'Gas_Main_Dec30th_2016|%') AND ON_CHANGE = 1 Number of results: 1 Looping through the rows ------------------------------------------------ Row Info Row Number 1 TableName: Gas_Main_Dec30th_2016 FieldName: OPERATINGSTATUS ValueInfo: RETPL|Retired_Gas_Main ValueMethod: COPY_FEATURE On Create: 0 On Change: 1 Checking for Subtype Restriction Field Name: Operating Status was found at index: 65 Trying: COPY_FEATURE Feature and valueinfo is valid Splitting up value info: RETPL|Retired_Gas_Main COPY_FEATURE: Field listed in the Field Name did not change, skipping Finished: COPY_FEATURE DONE --------------------------------------- ####################################################### Wiring the events Process Count: 0 Unwiring the events ####################################################### CP_Test_Location - ON_CREATE Starting AA *********************************************************** ############ 5/17/2017 1:04:14 PM ################ Setting sort order: Field - RUNORDER Querying table for Last Value for layer: CP_Test_Location Query Used: (TABLENAME = '*' OR TABLENAME = 'CP_Test_Location' OR TABLENAME like 'CP_Test_Location|*' OR TABLENAME like 'CP_Test_Location|%') AND VALUEMETHOD = 'Last_Value' Number of results: 0 Querying table for rules for layer: CP_Test_Location Query Used: (TABLENAME = '*' OR TABLENAME = 'CP_Test_Location' OR TABLENAME like 'CP_Test_Location|*' OR TABLENAME like 'CP_Test_Location|%') AND ON_CREATE = 1 Number of results: 2 Looping through the rows ------------------------------------------------ Row Info Row Number 1 TableName: CP_Test_Location FieldName: CPCNTRLNUM_A ValueInfo: Gas_Main_Dec30th_2016|CPCNTRLNUM|F ValueMethod: INTERSECTING_FEATURE On Create: 1 On Change: 0 Checking for Subtype Restriction Field Name: CORCON Control Number A was found at index: 22 Trying: INTERSECTING_FEATURE Starting to process rule Value Info is: Gas_Main_Dec30th_2016|CPCNTRLNUM|F Layer Found: Gas_Main_Dec30th_2016 CPCNTRLNUM: at 68 map tolerance: 1.5625000000058 spatial tolerance: 0.00328083333333333 Using Layer: Gas_Main_Dec30th_2016 Searching on Layer No Selected features No Selected Features Cursor created Starting Loop of found features Checking Class Different FCs Setting Value: Value Set Feature count: 0 Option: First Finished: INTERSECTING_FEATURE ------------------------------------------------ ------------------------------------------------ Row Info Row Number 2 TableName: CP_Test_Location FieldName: ValueInfo: Gas_Main_Dec30th_2016|CPSYSTEMSTATUS|UP ValueMethod: UPDATE_INTERSECTING_FEATURE On Create: 1 On Change: 1 Checking for Subtype Restriction Field is not specified, empty, or set for all. Trying: UPDATE_INTERSECTING_FEATURE Getting Value Info Checking values UP at index -1 Value used UP Finished: UPDATE_INTERSECTING_FEATURE ------------------------------------------------ DONE --------------------------------------- ####################################################### Gas_Main_Dec30th_2016 - Created through AA rules - Running ON_CHANGE Starting AA *********************************************************** ############ 5/17/2017 1:04:14 PM ################ Setting sort order: Field - RUNORDER Querying table for Last Value for layer: Gas_Main_Dec30th_2016 Query Used: (TABLENAME = '*' OR TABLENAME = 'Gas_Main_Dec30th_2016' OR TABLENAME like 'Gas_Main_Dec30th_2016|*' OR TABLENAME like 'Gas_Main_Dec30th_2016|%') AND VALUEMETHOD = 'Last_Value' Number of results: 0 Querying table for rules for layer: Gas_Main_Dec30th_2016 Query Used: (TABLENAME = '*' OR TABLENAME = 'Gas_Main_Dec30th_2016' OR TABLENAME like 'Gas_Main_Dec30th_2016|*' OR TABLENAME like 'Gas_Main_Dec30th_2016|%') AND ON_CHANGE = 1 Number of results: 1 Looping through the rows ------------------------------------------------ Row Info Row Number 1 TableName: Gas_Main_Dec30th_2016 FieldName: OPERATINGSTATUS ValueInfo: RETPL|Retired_Gas_Main ValueMethod: COPY_FEATURE On Create: 0 On Change: 1 Checking for Subtype Restriction Field Name: Operating Status was found at index: 65 Trying: COPY_FEATURE Feature and valueinfo is valid Splitting up value info: RETPL|Retired_Gas_Main COPY_FEATURE: Field listed in the Field Name did not change, skipping Finished: COPY_FEATURE DONE --------------------------------------- ####################################################### Wiring the events Attribute Assistant start editing Process Count: 0 Unwiring the events ####################################################### CP_Test_Location - ON_CREATE Starting AA *********************************************************** ############ 5/17/2017 1:04:59 PM ################ Setting sort order: Field - RUNORDER Querying table for Last Value for layer: CP_Test_Location Query Used: (TABLENAME = '*' OR TABLENAME = 'CP_Test_Location' OR TABLENAME like 'CP_Test_Location|*' OR TABLENAME like 'CP_Test_Location|%') AND VALUEMETHOD = 'Last_Value' Number of results: 0 Querying table for rules for layer: CP_Test_Location Query Used: (TABLENAME = '*' OR TABLENAME = 'CP_Test_Location' OR TABLENAME like 'CP_Test_Location|*' OR TABLENAME like 'CP_Test_Location|%') AND ON_CREATE = 1 Number of results: 2 Looping through the rows ------------------------------------------------ Row Info Row Number 1 TableName: CP_Test_Location FieldName: CPCNTRLNUM_A ValueInfo: Gas_Main_Dec30th_2016|CPCNTRLNUM|F ValueMethod: INTERSECTING_FEATURE On Create: 1 On Change: 0 Checking for Subtype Restriction Field Name: CORCON Control Number A was found at index: 22 Trying: INTERSECTING_FEATURE Starting to process rule Value Info is: Gas_Main_Dec30th_2016|CPCNTRLNUM|F Layer Found: Gas_Main_Dec30th_2016 CPCNTRLNUM: at 68 map tolerance: 1.5625000000058 spatial tolerance: 0.00328083333333333 Using Layer: Gas_Main_Dec30th_2016 Searching on Layer No Selected features No Selected Features Cursor created Starting Loop of found features Checking Class Different FCs Setting Value: Value Set Feature count: 0 Option: First Finished: INTERSECTING_FEATURE ------------------------------------------------ ------------------------------------------------ Row Info Row Number 2 TableName: CP_Test_Location FieldName: ValueInfo: Gas_Main_Dec30th_2016|CPSYSTEMSTATUS|UP ValueMethod: UPDATE_INTERSECTING_FEATURE On Create: 1 On Change: 1 Checking for Subtype Restriction Field is not specified, empty, or set for all. Trying: UPDATE_INTERSECTING_FEATURE Getting Value Info Checking values UP at index -1 Value used UP Finished: UPDATE_INTERSECTING_FEATURE ------------------------------------------------ DONE --------------------------------------- ####################################################### Gas_Main_Dec30th_2016 - Created through AA rules - Running ON_CHANGE Starting AA *********************************************************** ############ 5/17/2017 1:05:00 PM ################ Setting sort order: Field - RUNORDER Querying table for Last Value for layer: Gas_Main_Dec30th_2016 Query Used: (TABLENAME = '*' OR TABLENAME = 'Gas_Main_Dec30th_2016' OR TABLENAME like 'Gas_Main_Dec30th_2016|*' OR TABLENAME like 'Gas_Main_Dec30th_2016|%') AND VALUEMETHOD = 'Last_Value' Number of results: 0 Querying table for rules for layer: Gas_Main_Dec30th_2016 Query Used: (TABLENAME = '*' OR TABLENAME = 'Gas_Main_Dec30th_2016' OR TABLENAME like 'Gas_Main_Dec30th_2016|*' OR TABLENAME like 'Gas_Main_Dec30th_2016|%') AND ON_CHANGE = 1 Number of results: 1 Looping through the rows ------------------------------------------------ Row Info Row Number 1 TableName: Gas_Main_Dec30th_2016 FieldName: OPERATINGSTATUS ValueInfo: RETPL|Retired_Gas_Main ValueMethod: COPY_FEATURE On Create: 0 On Change: 1 Checking for Subtype Restriction Field Name: Operating Status was found at index: 65 Trying: COPY_FEATURE Feature and valueinfo is valid Splitting up value info: RETPL|Retired_Gas_Main COPY_FEATURE: Field listed in the Field Name did not change, skipping Finished: COPY_FEATURE DONE --------------------------------------- ####################################################### Wiring the events Attribute Assistant is being suspended Attribute Assistant is being turn off Attribute Assistant is being turn off ************************************** Closing Log File 5/17/2017 1:05:11 PM
... View more
05-17-2017
11:10 AM
|
0
|
1
|
588
|
POST
|
I have a problem here. While keeping all parameters the same in the dynamic table, I have an intersecting feature rule that is supposed to pull a control number from a gas main to a test location point when a new test location is created on said gas main. On creation of the new feature, the AA is not populating the control number for the test point. However, when creating a service line, using the same rule with the same parameters, it works. This method seems to be working for line to line intersects, but not line to point. Any idea what could be going on here? I have made sure that all layer names, field names, and parameters are good. I have also verfied that the test point is being snapped to the gas main when creating a feature.
... View more
05-01-2017
04:16 PM
|
0
|
5
|
1603
|
Online Status |
Offline
|
Date Last Visited |
12-13-2021
03:17 PM
|