|
POST
|
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
10-18-2021
10:06 PM
|
2
|
1
|
1985
|
|
IDEA
|
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
09-18-2021
09:19 PM
|
0
|
0
|
956
|
|
POST
|
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
08-27-2021
05:18 AM
|
0
|
1
|
1434
|
|
POST
|
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
05-06-2021
07:03 AM
|
0
|
1
|
1453
|
|
POST
|
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
05-06-2021
06:55 AM
|
0
|
1
|
1487
|
|
IDEA
|
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
02-15-2021
06:45 PM
|
2
|
0
|
1024
|
|
IDEA
|
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
02-08-2021
06:27 AM
|
0
|
0
|
770
|
|
POST
|
Is the view registered with the geodatabase? Can you tell us about the unique ID column? Is it 100% guaranteed to be unique? Is it based on a static column or is it generated/calculated? In ArcGIS Desktop, if you open the attribute table, and navigate to the last record, are you able to select all records? (I'm just trying to get a sense of what's working and what isn't.) I had similar issues. It happened after I made a change to the SQL of a registered view. In my case, I dropped the view and recreated it, and re-registered it. That seemed to fix my selection issues.
... View more
01-23-2021
07:40 AM
|
1
|
0
|
2179
|
|
POST
|
Oh, you poor soul! My team has spent the last 1.5 years trying to get Maximo Spatial working properly. After dozens of bug reports and hundreds of hours of effort, it's still not working quite right. Unfortunately, I can't help with the token stuff (I'm not the map service administrator in my organization), but you could try: 1. Asking IBM support 2. Posting a question on the Maximo Spatial Community forum 3. Asking IBM staff directly (such as jmaior@br.ibm.com) Good luck.
... View more
01-06-2021
01:47 PM
|
1
|
0
|
3913
|
|
POST
|
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
12-11-2020
01:24 PM
|
0
|
0
|
1373
|
|
IDEA
|
CREATE OR REPLACE TRIGGER D202574_custom BEFORE INSERT ON D202574 FOR EACH ROW DECLARE v_upd_row NUMBER; BEGIN SELECT COUNT(1) INTO v_upd_row FROM A202574 WHERE objectid = :new.sde_deletes_row_id AND sde_state_id = :new.deleted_at; IF v_upd_row = 0 THEN raise_application_error(-20001, 'Deleting has been disabled via a custom trigger.'); END IF; END ;
... View more
08-29-2020
10:35 AM
|
0
|
0
|
1382
|
|
IDEA
|
Solved: Steps for accessing edited features' attributes from an AGOL webhook URL: AGOL webhook to Integromat/Google Sheets
... View more
08-26-2020
06:35 PM
|
0
|
1
|
3829
|
|
IDEA
|
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
08-22-2020
04:46 PM
|
2
|
1
|
1431
|
|
IDEA
|
In the attribute table of a point feature class in ArcGIS Pro: Give users the option to turn on dynamic, read-only columns that represent each feature's X and Y coordinates. The fields would have similar properties to that of the SHAPE column in the attribute table. This would be helpful for day-to-day GIS analysis activities. And would eliminate the need for users to calculate or generate the X and Y columns themselves.
... View more
08-10-2020
05:27 PM
|
7
|
1
|
3610
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 02-29-2024 06:03 AM | |
| 1 | 03-01-2024 08:46 AM | |
| 4 | a week ago | |
| 1 | 01-16-2024 10:57 AM | |
| 1 | 01-15-2024 02:11 PM |