Latest Contributions by Bud

@KoryKramer  Yes.  In Oracle, we can select the domain data from the XML system tables as follows: select substr(extractvalue(codedvalues.column_value,'CodedValue/Code'),1,255) as code, substr(extractvalue(codedvalues.column_value,'CodedValue/Name'),1,255) as description from sde.gdb_items_vw i join sde.gdb_itemtypes it on i.type = it.uuid, table(xmlsequence(xmltype(definition).extract('/GPCodedValueDomain2/CodedValues/CodedValue'))) codedvalues where i.name = 'PIPE_MATERIALS' So we can already use the domain data in queries, reports, labels etc. But what we can't do is store additional information/columns in the domain.  ... View more

@JonEmch Thanks for your comments. Fair points. Maybe my organization should request a demo from Esri Canada about automation in ArcGIS. Will give it some thought. I know there are resources from Esri Inc on Notebook Server.  But a more general "Automation in ArcGIS" session might be more appropriate...rather than pitching a specific product. ... View more

Thanks Sarah. I think that functionality uses Windows Tasks Scheduler on your local computer and only runs if your computer is turned on and logged in. I’m looking for scheduled automations that are server-based, and can send emails, etc. Similar to these examples: - Scheduled emailed reports - Scheduled jobs to pre-compute fields and tables For example, if there are any construction projects in a FC where the status is FUTURE and the date is <= sysdate, then the GIS server should send me an email to tell me about it (aka a report). Or, on a nightly schedule, re-populate a HAS_CURVES field in a polyline FC, since we can't get that information via Arcade attribute rules or SDE.ST_GEOMETRY. I don’t really understand why there isn’t functionality like that…baked right into ArcGIS Pro/Server…that power-users could manage on their own. There is clearly an application server being used by Enterprise / ArcGIS server. It seems to me that power users should be able to to utilize that server to set up scheduled automations (without using windows scheduled tasks on our local computer, or dealing with IT by begging them to manually set up a scheduled task on a server somewhere). As data owners, we can do all sorts of other things in Pro, like publish layers to AGOL/Portal, do lots of things in the enterprise database like create tables, views, triggers, sequences, etc. Why not give us scheduled automation functionality too? Right in the layer properties in Pro? (or something like that) I’ve been told that most enterprise systems have functionality that lets users set up their own scheduled server-based automations. But when I tell people (who work in other enterprise industries) that ArcGIS doesn’t have automation functionality built in, they’re usually quite surprised. A direct quote from a lead IBM developer: "…that lack of automation in ArcGIS sounds painful. And it's a good reminder of some of the things IBM does well, that others don’t." Automation is normally included as standard functionality in enterprise systems. But it seems like an afterthought in ArcGIS -- and isn't practical for non-IT users. ... View more

Like this: select sdo_lrs.geom_segment_end_pt( sdo_geometry('MULTILINESTRING((1 2,3 4),(5 6,7 8))') ) from dual Result: { "point" : { "optimized" : false, "directposition" : [7,8] } } https://livesql.oracle.com/apex/livesql/s/nim5rs77hz9dytq5qxbvox7xd  ... View more

Thanks. I updated the question so that it's clearer. What I meant was, even if the two geometry columns were the same shape type (i.e., both could be polylines), and even if the lines in the two columns were exactly the same other than the spatial type, despite all that...I think the assumption is that ArcGIS will have problems if there are multiple geometry columns. ... View more

I was able to use that query from a user/schema/owner other than SDE (a ROADS user): --Oracle 18c select * from sde.version; It produced the correct information. ... View more

1. Use dot notation: select sde.st_geometry('LINESTRING EMPTY', 26917).len as shape from dual If the shape column wasn't already wrapped in brackets via a function, then we would need to add the brackets: select     (shape).len from     my_fc 2. Or, use a table alias: select     a.shape.len from     my_fc a 3. Or, use the TREAT() function: select     treat(shape as sde.st_geometry).len from     my_fc Although that might be misguided/unnecessary, since wrapping the column in brackets achieves the same thing (brackets is my preferred technique). ... View more