Latest Contributions by yockee

I am trying to populate a column's value based on sequence. I create the sequence: CREATE SEQUENCE sch1.incrementbyone_seq; ALTER SEQUENCE sch1.incrementbyone_seq OWNED BY sch1.featurepoint1.seqnumber_; This does not work, the "seqnumber_" coloumn never gets populated. I have made sure that the owner and the schema name of the sequence are the same and located on the same schema as the Featurepoint1 Feature Class The sequence itself is correct when its is called by a query  "SELECT nextval('sch1.incrementbyone_seq');" it gives out the correct number. How do I enable the sequence to be called when editing happens ? Then I try using a trigger and function: Function: new.seqnumber:= nextval('sch1.incrementbyone_seq'); Trigger: before INSERT OR UPDATE ON sch1.featurepoint1 FOR EACH ROW EXECUTE PROCEDURE function_name(); It works perfectly.  Whats the difference between using and not using trigger ? Why the trigger works ?       ... View more

I created a survey form using Survey123. There are coloumns to store coordinate with formulae : round(pulldata("@geopoint", ${location}, "x"),5) and round(pulldata("@geopoint", ${location}, "y"),5) This works fine on Android but gives out error "invalid number" on Iphone. The coordinates are different very slightly (only the last digit is different, not much). Due to this error, the survey can not be sent from Iphone. I am using Iphone 12 and 14 to test it. All the Location -> Integrated Provider setting are the same between Android and Iphones. I am using SDE Postgresql 16, Enterprise 11.0 need advice/  help to fix this. Thanks   Update : I get around it by changing DOT "." into COMMA "," on the Iphone. This is NOT *convenient* because I want to lock the coordinates (users don't have the authority to update these fields). I need it to work automatically on both Iphone and Android.   ... View more

How do I limit the addition of point using Collection Settings in Field Map ? I want to be able to collect point to only within specified distance from the target. I have tried and find out that  The Accuracy setting can not limit the  collection to within specified distance, it only gives out warning but does not prevent the actual addition of point. I also use Web App -> App Settings -> Use GPS Location enabled (see the second picture). This does not have any effect as well. I have checked the coordinate does not reflect the current location where I am standing at. thanks           ... View more

I am about to embark on a survey project using Field Map. The data are stored on postgresql 16 using Enterprise 11.0. What settings / configurations should I consider ? What values do I set into ? The survey will involve: - 70 surveyor using mobile phone accessing Field Map. Probably will have 20-30 concurrrent insert to database. - point Feature Class that contain data to be inserted. There are around 30 cloumns to be filled in. This will contain some photos too, small size around 10 - 50 kb. Editing attributes will happen here, including insert photos (small size, 10-50kb). - Polygon Feature Class that contain photos and 4 attributes only for confirmatory process. This will be used as guidance only, no editing here. - QC processes using arcgis pro. this will access geodatabase directly and accessing survey data via feature service. This will compare the newly inserted data and the old data. There will be around 5 - 10 people doing the QC. Here is the current configuration:   ... View more

I create a blob colomn on a Feature Class. I have populated this colomn by the value from another table using normal query (update ajt_gis.point SET gbr = (select data from ajt_gis.point__attach) where objectid = 2; Actually I want to conduct a survey with this scenario : This survey involves viewing the old picture by the surveyor to make sure that they are in the right place. Then the surveyor will take another picture (new picture) of the building. So the data has 2 pictures  : old and new. The Old one is stored in the blob colomn of Feature Class whereas the New one is stored in the attachment.  Is it possible ? How do I possibly view this blob colomn on the Feature Class using web map / arcgis desktop / apps by arcgis ? I know I can view the picture by using attachment. I am using Enterprise 11.0 with Postgres 16   ... View more