Latest Contributions by Bud

@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

On a related note, I thought this was interesting (Oracle): If you create a function-based index, a virtual column is added implicitly. create table t1(n number); create index i1 on t1(abs(n)); insert into t1 values (-123); commit; col column_name format a15 select column_name, hidden_column, virtual_column from user_tab_cols where table_name='T1'; COLUMN_NAME     HID VIR --------------- --- --- N               NO  NO SYS_NC00002$    YES YES select n, SYS_NC00002$ from t1;               N SYS_NC00002$ --------------- ------------            -123          123 https://community.oracle.com/tech/developers/discussion/comment/16835670#Comment_16835670 I know from experience that function-based indexes don’t break ArcGIS: How To: Create Oracle Spatial function-based indexing I wonder if that means we could create a hidden virtual column (via an SQL client), and ArcGIS wouldn’t have a problem with it, because it’s hidden? I imagine the only way you could see the column in ArcGIS is via a query layer or a view. So that’s not totally ideal. And the automatic column name isn’t very user-friendly. Although I suppose we could give it an alias in the query. Ultimately, I’m not sure how useful that is. We can just do the calculation in a view or query layer. A hidden virtual column doesn’t have any advantage. But it’s interesting to think about. Hidden virtual column created by FBI: Is the column name stable?   ... View more