Latest Contributions by Bud

Related post: Idea: Support invisible SDO_GEOMETRY columns (That title is misleading — the page does have a related discussion...about why I can't just switch to SDO_GEOMETRY.) ... View more

I also (sometimes) have the same issue when simply trying to add the view to the map. The map crashes. Sometimes, the view crashes ArcMap 10.7.1 and ArcGIS Pro 2.6.8 — when I add the view to the map. Other times, the exact same view works fine. It doesn’t crash. It seems to go in cycles for me. It works for a few hours or days, then it doesn’t. Then it works again. I tried creating a new FC — by copy/pasting it in Catalog. I thought maybe there was an issue with the FC. But that didn't work either. The map still crashes. create or replace view bc_atn_copy_vw as ( select /*+ INDEX (bc_atn_copy atn_bc_copy_idx) */ --https://support.esri.com/en/technical-article/000009658 cast(rownum as number(38,0)) as rownum_unique_id, st_startpoint(shape) as shape from infrastr.bc_atn_copy where st_startpoint(shape) is not null --https://stackoverflow.com/a/59581129/5576771 ) ... View more

So you don't see an "Expand full message" button like this? When I hit that button, it displays the proper formatting with line breaks. To be honest though, I see different behavior for different message threads. Not sure why. Maybe I'm missing something. Also, it's a long shot, but I wonder if the type of line break affects things at all? (ENTER vs. SHIFT+ENTER) ... View more

If I understand correctly, SDO_GEOMETRY has similar attributes. Additionally, SDO_GEOMETRY has methods (aka member functions): Get_Dims Get_GeoJson Get_GType Get_LRS_Dim Get_WKB Get_WKT ST_CoordDim ST_IsValid Techniques for selecting an object's attribute Replace value in SDO_ELEM_INFO_ARRAY varray Modify SDO_ELEM_INFO_ARRAY of existing geometry   ... View more

@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