Latest Contributions by Bud

  What are some SQL data analysis books/resources that you like? 1. For example, I like the Profiling: Distributions and Profiling: Data Quality sections in this book:  SQL for Data Analysis by Cathy Tanimura 2. When I was first learning SQL, I liked these books (they're clear and short):  SQL by Ben Forta (generic SQL; 5th edition) Oracle PL/SQL by Ben Forta (1st edition) Microsoft SQL Server T-SQL (2nd edition) 3.  And these video courses cover advanced SQL topics like window functions:  Advanced SQL Queries in Oracle and SQL Server by Scott Hecht; PluralSight video course SQL Data Wrangling in Oracle by Scott Hecht; PluralSight video course Are there any others you would suggest? ... View more

Oracle:  It would be really helpful if we could get a function in ST_Geometry that would let us select the vertices of a feature as rows. Oracle’s SDO_Geometry has a function called GetVertices. It is extremely handy. https://docs.oracle.com/en/database/oracle/oracle-database/21/spatl/SDO_UTIL-reference.html#GUID-9CF1E8A9-EBCB-4938-BBB6-C2AAFE4897A7 We need to be able to easily access ST_Geometry feature vertices using SQL -- without using clunky workarounds like cross joins or custom types/functions. ... View more

What levels of the ArcGIS Enterprise stack support (or don't support) scheduled jobs? Y - GIS server operating system (example: Windows scheduled tasks, SDE connection, and ArcPy script) Y - Database (example: Oracle scheduler; making use of spatial datatypes & functions) N - ArcGIS Server N - ArcGIS Portal Y - ArcGIS Notebook Server Y - 3rd party applications (example: FME) Types of GIS scheduled jobs: Precompute calculated fields or entire tables Scheduled queries and reports --> email results via SMTP What are our options? Is the above list correct? Thanks.     ... View more

ArcGIS Enterprise; Oracle I want to set up a scheduled report based on Oracle GDB data: The report/task would run weekly and would be emailed to a list of recipients (via an SMTP server) The filetype could be anything (PDF, excel, or just a table in an email). The important part is that people get notified of records in a resultset by email — so that they can follow-up as needed. The report would be emailed out if the resultset/count meets certain conditions (i.e. send the report if the resultset has >0 records). Question: Are there any mechanisms in ArcGIS Enterprise that would allow users to create and manage scheduled reports? ... View more

  Is it possible to send scheduled/emailed reports via ArcGIS Notebook Server scheduled tasks?   An example of a scheduled report would be: Report/task runs weekly Emailed to a list of recipients (via an STMP server) The report filetype could be anything; the important part is that people get notified of records in a resultset by email — so that they can follow-up as needed. The report would be emailed out if the resultset/count meets certain conditions (i.e. send the report if the resultset has >0 records). ... View more

It would be helpful if a timestamp column could be added to the SDE.GDB_ITEMS table (Oracle). Reason: So we can know when a GDB item, such as a domain, was last updated. Example: For integrations to external systems, we need to know if any domain descriptions have been changed, so that we can re-sync the data to the external system. Currently, there is no way to know if/when the values in a domain have been changed. Thank you. ... View more

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