Latest Contributions by KimberlyGarbade

Is there a way to view a list of all the sessions you attended while at the 2025 UC in San Diego?  I had my badge scanned at the door of each session, but I don't see where I can see a list of those scans.  I used the app to find sessions, but I never logged into it, but if my badge links to an ID in a database somewhere there should be a query that can run pretty easily, right? ... View more

I have a table that contains no spatial data.  It exists in an SDE enterprise geodatabase (SQL Server).  The table contains log information generated by an FME process; data related to if a certain process ran successfully or not and why or why not.  Again, this table contains no spatial data, but it is registered with the GDB.  My question (and I should know this after 100 years) is can I use straight up SQL Server SQL commands to update the table (using SQL Executor in FME) or do I have to use a Writer that points specifically to an "Esri geodatabase (SDE)" format.  Basically my question is can I edit a non-spatial table that is registered with the geodatabase using native SQL commands and cut an Esri client out of the picture?  The native SQL just seems much faster without the overhead. At different times I've heard Yes, I've heard No, I've heard Yes but you shouldn't, I've heard Yes and it didn't hurt anything.... but nothing official. Thank you for your time. ... View more

I have a branch versioned geodatabase in SQL Server.  The database contains 300,000 features spread across 14 feature classes.  One of the attributes of each feature in the GDB is “PlanningDistrict” (each of the 300,000 features has a district populated).  The value is populated automatically by arcade scripts during data entry.  Recently the planning districts were redrawn (many added, some deleted, all reshaped), so now I have to update literally every feature in the database.  The actual calculation of the new data is not a big deal (we’ll just use Arcade), but what I’d like to know is what are the implications of versioning, what should I turn on and off (I.E. versioning, the arcade scripts, etc.)?  What is the best/recommended way of going about this.  More information is that we do have a few outstanding versions with edits at the moment. ... View more

I have a hosted feature layer on AGOL.  This layer is editable.  When a new feature is added I have to create a new "SmartID" prefaced with the side of town it falls within based on overlay analysis and then using the next highest value from a database sequence (IE VALV-N-0001 the next one could be VALV-S-0002).  I originally wrote this pretty fast in the Pro I published the service from using Arcade, an Attribute rule and a database sequence....Come to find out Attribute rule don't work in AGOL....OUCH....I thought I'd come up with a work around using a Template/Form for data entry in AGOL and using Arcade again to create a calculated value in the AssetID field, but now I find out that AGOL (I guess) doesn't know what database sequences are either since Arcade doesn't understand "nextsequencevalue" in the context of the Form (and I definitely had a database sequence contained in the database I publish from, but I guess it doesn't get published automatically and I can't find how to publish the sequence for use in AGOL).... AGOL also (to the best of my knowledge) doesn't have an iterating data type I can use as a sequence replacement.... What am I missing!?  There has to be a way to assign the next highest ID (other than ObjectID) to a new asset created in AGOL?  Any help would be appreciated. ... View more