Latest Contributions by yockee

‎04-14-2025

I want to record an insert or update events happening on one spatial table into another table (non spatial) for simple historical purpose. Say for example I have 2 tables SpatialA (date1 DATE, guid VARCHAR38, objectid INT, col1 VARCHAR5 ,shape) and NonSpatialB (date1 DATE, guid VARCHAR38, objectid INT, col1 VARCHAR5). I have trigger on SpatialA table that executes function : CREATE OR REPLACE FUNCTION function_copy() RETURNS TRIGGER AS $BODY$ BEGIN INSERT INTO schema1.NonSpatialB (date1 ,*objectid*) //schema1.NonSpatialB (date1 ,*GUID*) --> I also tried using "GUID" as well VALUES(new.date1,new.objectid); RETURN new; END; $BODY$ language plpgsql; CREATE TRIGGER trig_copy AFTER INSERT ON schema1.SpatialA FOR EACH ROW EXECUTE PROCEDURE function_copy(); The data on SpatialA are updated via Survey123 or FieldMap. When the trigger is enabled, I CANNOT insert nor update a record on SpatialA. The trigger prevents the update or insert event from happening. How do I suppose to write the function so that I can insert into another table? Note: those trigger and function work perfectly when I do insert or update on non spatial table I am using Postgresql13, Arcgis Enterprise 11.0

‎01-22-2025

I have a user called "user1" that creates a non-spatial table (it just contains tabular data) on SCHEMA-x on Postgresql. Now, I want to register this table so that the geodatabase can read it. Here is the privilege that I have granted: GRANT USAGE ON SCHEMA sde TO user1; GRANT USAGE ON SCHEMA SCHEMA-x TO user1; GRANT SELECT, INSERT, UPDATE, DELETE ON new_table TO sde; I login to SDE from Arcgis Pro 11.0 using the owner of SCHEMA-x . I then use tool Register With Geodatabase. This comes up "ERROR 160228: The user does not have permission to execute the operation." So, what do I miss ?

‎01-21-2025

Ok, got it Vince. So, if I have to choose a replication method, what would be the best ? One way or Two way ? thanks

‎01-21-2025

What is the best replication scenario for Feature Service that has picture attachment ? This feature Layer is consumed by Field Map / Survey123 I want to create a backup so that if there is emergency, I can restore it quickly. thanks

‎01-16-2025

I am trying to do an example here : https://developers.arcgis.com/javascript/latest/sample-code/intro-layers/ I replace these parts: <link rel="stylesheet" href="https://js.arcgis.com/4.31/esri/themes/light/main.css" /> <script src="https://js.arcgis.com/4.31/"></script> with my own hosted js on my laptop using XAMPP: <link rel="stylesheet" href="http://localhost/javascript/api/4.31/esri/themes/light/main.css" /> <script src="http://localhost/javascript/api/4.31/"></script> Note: the locally hosted JS scripts are on "http", not "https" I add my own layer hosted on Geoportal on our company web server on this part "const featureLayer = new FeatureLayer({" : so it becomes like this: const featureLayer = new FeatureLayer({ url: "https://companywebserver.com/server/rest/services/Survey/Boundary/FeatureServer/0" }); This web server can be accessed from outside. All links hosted on localhost (script and feature service) work correctly and can be accessed. They give out the same output as the script hosted on arcgis.com The apps works without problem if I use the script hosted on "js.arcgis.com". The FeatureService is loaded successfully. There is popup window requesting login to the Portal item (feature service). This is because I dont use token I guess, but its fine. But, It does not work using locally hosted JS. Here are the errors: 1). Uncaught SyntaxError: Unexpected token '<' (at VM709:1:1) 2). (index):1 Uncaught SyntaxError: Unexpected token '<' (at (index):1:1) 3). There is info on AutoClicker.JS saying "AutoClicker initilize complete" Note: Both errors 1 & 2 point to "<!DOCTYPE html>" Here is the screenshot about the error: Now, to avoid those errors above, I add "type="text/JSX"" to the script tag. They now become: <link rel="stylesheet" href="https://js.arcgis.com/4.31/esri/themes/light/main.css" type="text/JSX"/> <script src="https://js.arcgis.com/4.31/" type="text/JSX"></script> The first 2 errors do not appear. The warning about autoclicker still persist. But there is nothing on the display. It is just a blank white display. The only difference between using JS hosted locally and hosted on arcgis.com is the login popup to the Feature Service hosted on local Geoportal. What seems to be the problems ? How can I fix this ? Many thanks. Need some advice.

‎01-15-2025

I am having trouble in finding map extent (bounding box). How can I easily find out the extent and its format ? Suppose I have this code sample: const view = new MapView({ container: "viewDiv", map: map, extent: { // autocasts as new Extent() xmin: -9177811, ymin: 4247000, xmax: -9176791, ymax: 4247784, spatialReference: 102100 I want to direct the extent (xmin/max, ymin/max) to a particular city with spatial reference 102100. How to do that ? And also, spatialReference 102100 (line 11) is deprecated and changed to EPSG 3857. (https://spatialreference.org/ref/esri/102100/) . Do I have to change the "spatialReference: 102100" to "spatialReference: 3857" ? Thanks

‎01-07-2025

Hi @George_Thompson , I found an article somewhere that after applying the patch, the problem still persist. So, I am not taking the risk. I just found the work arounds: 1. Using downgraded Opera and turn off the auto updater. OR 2. Using downgraded Chrome (v 104) : turn off autoupdater and modify the registry: - rename the autoupdater file to anything you want (I just add sufix "OFF") on the installation directory. This will make the autoupdater fail to run, which is what we want - find a key on the registry somewhere in "Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Google\Update" set the Default to 0 Hope it helps.

‎12-15-2024

I want to create materialized view on arcgis pro 3.1.0 using postgres 13 and Enterprise 11.0. How to do this ? All I find is : https://pro.arcgis.com/en/pro-app/3.2/help/sharing/analyzer-warning-messages/24139-creating-a-materialized-view-or-snapshot-is-recommended-for-query-layer.htm I can not find article / tutorial about it. Please guide me to a correct material / reading. Thanks

‎12-01-2024

Hi @VinceAngelo do I have to turn off the corresponding map service, stop editing using DML queries and quit any arcgis pro apps that access the feature class during the index rebuild ? Thanks

‎11-25-2024

I have these error and I am willing to fix it by setting the rowid value to its maximum+1. These errors happen when I try to add an attachment photo as attachment: Error: Underlying DBMS error [ERROR: duplicate key value violates unique constraint "r83_sde_rowid_uk" DETAIL: Key (attachmentid)=(801) already exists. (akt_survey.akt_gis.sur_property__attach)::SQLSTATE=23505] [Survey_Property__ATTACH]. Error: Underlying DBMS error [ERROR: duplicate key value violates unique constraint "r83_sde_rowid_uk" DETAIL: Key (attachmentid)=(1201) already exists. (akt_survey.akt_gis.sur_property__attach)::SQLSTATE=23505] [Survey_Property__ATTACH]. Error: Underlying DBMS error [ERROR: duplicate key value violates unique constraint "r83_sde_rowid_uk" DETAIL: Key (attachmentid)=(1202) already exists. (akt_survey.akt_gis.sur_property__attach)::SQLSTATE=23505] [Survey_Property__ATTACH] what happened before was: 1. I have polygon that already contains attachment, namely OLDPOLY 2. Convert these polygon into point using Feature to Point. I name this FC as NEWPOINT 3. Enable attachment on this NEWPOINT 4. Load all attachment using sql query from OLDPOLY to NEWPOINT: Insert Into NEWPOINT select * from OLDPOLY 5. Publish this NEWPOINT as feature service and create apps using FieldMap 6. Begin updating data. I take a new picture and try to upload it. Then those errors come up. I do a query "select max(attachmentid) from sur_property__attach" . It says 300800. It seems that the sequence needs to be moved to the maximum value of current attachmentid (300800) + 1. How can I solve this problem ? How to find that "r83_sde_rowid_uk" ? i am using Postgresql geodatabase

‎11-25-2024

This is November 2024. Has it been supported now ? thanks

‎11-22-2024

fast forward to 2024.. This error still exists. 😘

‎11-22-2024

I try Edge with IE Mode. It works actually. The signin page and all navigational menu appear. I also tried downgrading Chrome. It actually works BUT I can't stop Chrome from upgrading automatically.

‎11-22-2024

I try to export an XLSX / CSV file to Domain using Table to Domain GP tool. I get "Error:999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.". It worked fine yesterday. I have been doing this many times and this is the first time its happening. Then I try it on another SDE Geodatabase just to make sure. The Domain is created succesfully. Then I use this domain and copy-paste it manually to the other server that was failed. It is a success. Both geodabatases are using Postgres 16. What might be the cause of Table to Domain GP tool failure on one server ? How do I check an alternative error message because the default error message is not helpfull ? Thanks

‎11-20-2024

Finally I know the problem: its the numbering format on Iphone.. I change the Numbering format on the IPhone, from "xy,xy.xy" to "xy.xy,xy" Now Survey123 works on both OSs

Online Status	Offline
Date Last Visited	‎12-14-2025 06:17 PM

My Ideas

Latest Contributions by yockee

Trigger for historical

Register With Geodatabase fails due to lack of permission

Re: Replication for enterprise geodatabase having picture attachment

Replication for enterprise geodatabase having picture attachment

featureservice can not be displayed using javascript hosted locally

Finding map extent for javascript api and spatial reference

Re: Missing "signin" and other links in geoportal

Postgre materialized view on argis 3.1.0

Re: reindex using "reindex" command in postgresql

ROWID can not be inserted due to duplicate

Re: Conditional Field List

Re: Domain to table

Re: Missing "signin" and other links in geoportal

Table to Domain failed Error 999999 on enterprise geodatabase

Re: Invalid number for coordinate on Iphone

Re: Conditional Field List

Editing WFS-T via QGIS

Re: Finding distance between paired points

can not create Feature Class due to connection los...

Re: Feature Dataset performance