Latest Contributions by Bud

Please consider adding a midpoint attribute to the ST_GEOMETRY datatype (and a MIDPOINT accessor function). Otherwise, it is unnecessarily difficult to calculate the midpoint of a line using SQL/ST_GEOMETRY. Please note that the midpoint should be the true midpoint: half of the distance along the polyline (not the middle vertex, which would not be the true midpoint). Thank you. ... View more

  I want to create an Oracle 18c materialized view with the fast refresh option on a remote table (in an enterprise GDB). I can do this successfully without a SHAPE column: create materialized view log on source_system.workorder with primary key; grant select source_system.mlog$_workorder to schema_for_dblink; create materialized view my_gis_schema.wo_mv build immediate refresh fast start with sysdate next sysdate + (15/(60*60*24)) as select cast(workorderid as number(38,0)) as objectid, --workorderid is a fake primary key; it has a NOT NULL constraint and a unique index wonum, status, --other fields longitudex, latitudey from source_system.workorder@my_dblink Problem: I want to store the XY coordinates from the source table in a SHAPE column in the MV. Unfortunately, my options seem pretty limited: Oracle doesn’t seem to support SDE.ST_GEOMETRY in MVs (more info here and here). The SQL would be:  sde.st_geometry(longitudex,latitudey,null,null, 26917 ) as shape Additionally, Oracle doesn't seem to support SDO_GEOMETRY in MVs on a remote table with the fast refresh option:  ORA-12015: cannot create a fast refresh materialized view from a complex query The SQL would be:  sdo_geometry(2001, 26917, sdo_point_type(longitudex,latitudey, null), null, null) as shape Question: Is there a way to include a SHAPE column in a materialized view on a remote table with the fast refresh option? ... View more

In unversioned feature classes, we can control privileges through Catalog for SELECT, INSERT, UPDATE, DELETE (using any combination).   However, with versioned feature classes, we can only control INSERT, UPDATE, and DELETE as a group (all-or-nothing).   We can't allow INSERTS and UPDATES, yet prevent DELETES.   It would be great if we could prevent just DELETES in versioned feature classes.   Thanks! ... View more

Regarding the planned feature snapping functionality in Collector and Field Maps (Android): Would it be possible for ESRI to enhance the functionality, in either Collector or Field Maps (Android), so that it can grab a field value from the snapping feature?   In other words: In addition to getting the geometry from the snapping feature, what if a field value were also taken from the snapping feature and inserted into a field in the current/new feature? Could that be done?   If that were possible, I think it would effectively solve the classic parent-child problem that users often face when collecting GIS data. As far as I know, the only other way to enter a parent feature's ID into a new child feature is to type in the ID manually. Which is time-consuming and error-prone. Cheers. ... View more

In an external system, I want to make an HTTP GET request —to— ArcGIS Notebooks for Server. In ArcGIS Notebooks for Server, I would have a Python function that would process the request and return a response. Is it possible to send an HTTP GET request to ArcGIS Notebook Server? ... View more

Can ArcGIS Notebook Server be used to access filenames in a folder? For example, as a nightly task: Reload an enterprise geodatabase table with a list of construction drawing PDFs that are stored in a network folder. Thank you. ... View more

I have some questions about ArcGIS Notebook Server: What are the licensing requirements for ArcGIS Notebook Server? I believe my organization is currently licensed for ArcGIS Enterprise 10.7.1 Standard. I do not have administrator privileges for ArcGIS Server, etc.. Would I need to be assigned some sort of administrator role in order to use ArcGIS Notebook Server? Thank you. ... View more