Latest Contributions by JohnMDye

I'm toying with the Map Viewer template but one of the things I don't like about it when in small-screen/phone layout is the 50/50 vertical split between the data and the map. Ideally, I'd like it to be all map and for map selections to trigger a slide-up panel containing feature info as laid out according to my needs. The only way I've seen to use those sliding panels is via Map Widgets/Tools. Is there a way to have a map centric view with your featureInfo being populated into one of these sliding widget panels? ... View more

Currently, attribute rules are only enforced and applied if edits are made through ArcGIS Pro or a Branch Versioned Feature Service. This is okay, but since Attribute Rules are essentially a method for implementing database triggers, they should be enforced at the Database level. How the data is edited on a Feature Class in a File or Enterprise Geodatabase should be (mostly) irrelevant.   If I want to update it with a SQL script, that shouldn't be a problem. If I want to update it with a Python script, that shouldn't be a problem. If I want to update it in ArcMap, ArcGlobe, ArcScene, that shouldn't be a problem.   Bake the logic directly into the File and Enterprise Geodatabase so that I can update the data however I want and not have to worry about what client my customer is using to edit my data with. ... View more

Consider the following Geodatabase Feature Class and table: Accounts Feature Class (12 million records, updated monthly) OBJECT ID CUST_ID FIRST_NAME LAST_NAME OPEN_DATE GEOMETRY 1 0956732561 Jane Doe 12/31/2017 Point ... ... ... ... ... ... Transactions table (80,000 records, updated hourly with a 30 day window) OBJECT ID TRX_DATE CUST_NUM AMOUNT 1 04/17/2019 14:21:56 0956732561 2.31 ... ... ... ... Desired Result TransactionsFC feature class (80,000 records, updated on the fly as Transactions Table is updated) OBJECT ID TRX_DATE CUST_NUM AMOUNT GEOMETRY 1 04/17/2019 14:21:56 0956732561 2.31 Point ... ... ... ... ... Now, I don't get any kind of geographic identifier in my transactions table. No address, no coordinates, no zip code, nothing. There is absolutely nothing to base any kind of geometry off of in that table nor can I get it. What I need to do is create a new and separate feature class of the transactions which uses the geometry of its associated feature in the Accounts feature class. As a one time job, this is easily doable by joining the Transactions table to the Accounts Feature Class by CUST_ID and CUST_NUM and then exporting that to a new feature class. There are a couple of problems that prevent me from doing that: Update Cadence: My transactions table is updated hourly, with a 30 day window of transactions to the hour. So any record older than 30 days to the hour is deleted, any new transactions that have occurred within the last hour are added, and any records which have had updates are updated. Runtime: Doing a join between a 12m feature dataset and an 80k record table takes an abysmally long time and given the update cadence, it basically turns into a never ending geoprocessing queue. By the time one job run has finished, there may be another one or two in queue that need to be performed. So I'm trying to create an Attribute Rule on the Transactions table, that would do the following: Requirement 1: Whenever a new record is added to the Transactions Table: Get the Customer_NUM of the new record Get the corresponding CUSTOMER_ID of the feature in the Accounts feature class If there isn't a corresponding CUSTOMER_ID in the Accounts feature class, the transaction most likely is from a new Customer that was created within the last month which has not been added to my Accounts feature class. Do nothing. Create a new feature in Transactions Feature Class, populating it with all of the attributes for the new Transaction record in the Transactions table, but using the Geometry from the corresponding Account feature in Accounts feature class Requirement 2: Whenever an existing record is deleted from the Transactions Table: Delete the corresponding Transaction feature from the Transactions feature class. Requirement 3: Whenever an existing record in the Transactions Table is updated: Update all of the attributes in the corresponding Transaction feature in the Transactions feature class, but do not change the geometry. I started playing with attribute rules in Pro (version 2.4.1) and while these attribute rules would need to work in an Oracle Enterprise Geodatabase for now, I'm just testing in a File Geodatabase. I started trying to build an Attribute Rule on the Transactions table which would create new records in the TransactionsFC feature class as new records are added to the Transactions table (Requirement 1) but it doesn't seem to be working. var transaction = $feature; var transactionID = $feature.CUST_NUM; var accounts = Filter(FeatureSetByName($datastore, 'ACCOUNTS', ["CUST_ID"], true), "CUST_ID = @transactionID"); // If no customer accounts found, must be new customer if (IsEmpty(accounts)) { // do nothing return } // If one or more customer accounts found if (Count(accounts) >= 1) { // take the first account feature var account= First(accounts) // return an edit operation return { "edit" : [{ // on the TransactionsFC feature class "className" : "TransactionsFC", // which adds a new feature "adds" : [{ // with the following attributes from the Loss record "attributes" : { "CUST_NUM" : transactionID }, // and the geometry from the account "geometry" : account }] }] } }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ The expression validates fine but obviously I'm missing something. Whenever a new record is created in the Transactions table, a new record is not created in the TransactionsFC with the appropriate attributes and geometry. Any help is appreciated. ... View more

So fed up. This was so impossibly easy in ArcMap. I have a hosted feature service in ArcGIS Online. I have ArcGIS Pro. I add the Hosted Feature Service to a map in ArcGIS Pro by: Selecting Add Data > Data in the Layer Group of the Map Tab in ArcGIS Pro Selecting Portal > My Content > My Hosted Feature Layer then clicking Open The Hosted Feature Service gets added to my map in ArcGIS Pro. I make my edits and update my symbology. I am trying to push my edits to ArcGIS Online by: Right clicking on my Hosted Feature Service in my map and selecting Share > Overwrite Web Layer Click Yes to confirm that changes to my current web layer will be lost Select Portal > My Content > My Hosted Feature Layer to be overwritten, and click OK Click OK to confirm overwriting of Web Layer Keep default setting to use description from the web layer Enter required tags and summary Keep configuration as-is Click Analyze I keep getting the following error:  00102: does not contain a required layer type for —ArcGIS Pro | Documentation  There also doen't seem to be an equivalent capability to just create a local copy for editing like there was in ArcMap. Yes, the Hosted Feature Service has editing enabled Yes, I am the owner Yes, I am signed into the Portal Yes, Sync is disabled (which is another mind-boggling limitation that makes no sense at all) Thanks for your help in advance.  ... View more