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
|
530
|
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
|
1518
|
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
|
2612
|
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
|
1079
|
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
|
997
|
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
|
2597
|
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
|
1046
|
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
|
2562
|
IDEA
|
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
08-10-2020
05:09 PM
|
1
|
0
|
506
|
POST
|
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
08-08-2020
11:53 AM
|
0
|
1
|
695
|
POST
|
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
08-05-2020
09:31 PM
|
0
|
0
|
374
|
POST
|
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
08-05-2020
08:48 PM
|
0
|
0
|
648
|
IDEA
|
Thanks Ben Walker. That helps. Khaled Hassen : I, too, would like to see a writeup about using webhooks with AGOL.
... View more
08-05-2020
07:25 PM
|
1
|
0
|
2597
|
IDEA
|
Hi Khaled Hassen, Could you explain a bit more about what you mean by this line? "Just enable changeTracking in your service and you should see creating a webhook in the service admin URL." Where can I find this functionality in ArcGIS Online? Thank you.
... View more
08-04-2020
09:04 PM
|
0
|
1
|
2597
|
Title | Kudos | Posted |
---|---|---|
1 | 05-10-2024 10:22 PM | |
1 | 05-22-2024 10:21 PM | |
1 | 06-12-2024 06:39 AM | |
3 | Friday | |
1 | 04-04-2024 11:08 AM |