Latest Contributions by yockee

I have successfully (sort of..) exported attachments that contain many photos. Here is what I do in order: 1. Copy the Feature Class.  2. Paste it on the target SDE geodatabase Postgresql. This will copy the whole thing, including the relationship class Error comes up. Not all pictures are copied but the whole objects in the Feature Class are copied. 3. I create a new the attachment table with random name. Then turn it into UNLOGGED (ALTER TABLE mytable SET UNLOGGED;)  then start copying. After 4 hours, the whole attachments are copied successfully. No errors.  4. I set the table back to LOG. 5. Rename the attachment table above to the original hoping that it will sync automatically 6. Reindex the table. Then I do random check. Seems that the attachment picture is wrong. One object should have a picture of "mountain", but instead I get "sea".  How can I fix the relationship table ? I am using: Arcgis Pro 11.0 and Arcgis Enterprise 11.0 with Postgresql 17 thanks       ... View more

I have Point feature class with 200K data with photos (blob) on it. Each row has around 1MB+ photo in File GDB. So, in total there are around minimum 200K*1Mb of blob data. Now, I want to somehow reduce the photo size for each record upon loading data into SDE Geodatabase. How can I do this ? I have storage limitation on SDE Geodatabase. ... View more

I want to update attribute on a layer (area) based on the intersection with another layer (point). Suppose I have Layer PointA. I draw an object on Layer AreaB. The intersected objects on PointA by AreaB are then calculated and the value is put into a colomn on Layer AreaB, automatically if possible.   I am running Arcgis Enterprise 11.0 with Postgresql SDE 13.12   How to achieve this using Smart Editor Widget ?   Thanks ... View more

i have a scenario like this: There are 10-20 surveyors that will be doing a survey using Arcis Fieldmap/123. The data collected then will be used by another non-gis apps to measures their performances on daily basis.  Thing is, I do not want to publish the data from Enterprise geodatabase (postgresql 13, arcgis enterprise 11.0. running on AWS) directly as Feature Service in our local Portal. I would rather publish the replica and then synch it with the parent. What is the best possible approach for this workflow ? Which replication to use ? How to synch the replica to the parent? Many thanks ... View more

I am using Arcgis enterprise 11.0, Arcgis pro 11.0 and Postgresql 13.. Suddenly, I can't create feature class, can't even identify object. The error are: 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. Database user name and current user schema do not match. [Connection to PostgreSQL server is lost. :SQLSTATE=] [dbgis.tgk_city.testfc123456] Underlying DBMS error [no connection to the server :SQLSTATE=ž] [dbgis.sde.GDB_Items] Failure to access the DBMS server [Failure to access the DBMS server] Underlying DBMS error [no connection to the server :SQLSTATE=ž] [dbgis.sde.GDB_Items] Then I restart the ArcMap. I can open the geodatabase from Arcgis Pro. I can see all the feature classes. I can do "identify" to an object. But, when I want to create FC, that error comes up again. I can NOT connect to the geodatabase any longer. Even accessing from PGAdmin does not work too ! The connection suddenly just closed. Then, I restarted the Database, the Physical Server (its on AWS) and Arcgis Pro. I can connect again. I can see all the Feature classes. But, when I want to add a new FC, its just dropping connection just in the end of the process. I was able to do many things in the past weeks, such as: - creating new Feature Class - adding new attributes - adding data, editing, copying and pasting - giving data access permission to specific users   it seems that there is problem in maintaining the connection.   Please help.      ... View more

I want to publish feature Service from Feature Class in SDE geodatabase (in postgresql 13) to lokal geoportal. In SDE, I have 3 new users: dataowner, dataeditor, dataviewer. There is another user "admingis". It is the old data owner. I used to publish FS using this "admingis" account. Whereas in Geoportal, I have users: useradvance (Creator) and admingis (Creator) I have changed all Feature Classes to their correct data owner (not "admingis" anymore). I do not want to use "admingis" anymore  So, Which account do I have to use to publish Feature Service ? Does "dataowner" from postgresql have to be registered in Portal ? If so, how to do it ?   thanks ... View more

I want to separate data into schema based on their administrative location (city). For example: Schema 1 will hold data for City 1, Schema 2 will hold data for City 2. I am using postgresql 13. I am thinking of these options but can't decide the pros and cons:  PS: i don't know if the second picture is possible thanks  ... View more

I want to update the intersected data using build in webgis. Here is the flow: I have 2 layers, Operational area (layer 1) and Building (layer 2) . Both are Feature Services. Supervisor will then plott an area of operation on Layer 1 for user X. This area then will intersect the underlying building on Layer 2. The attribute of selected Buildings then will be updated either by bulk or one by one, to show that these Buildings will be surveyed by X.   How to achieve this by default web app builder ? My goal is to develop webgis apps using minimal coding and utilizing default webgis apps ... View more