Latest Contributions by AnthonyRyanEQL

I have managed to create the SQL that will consistently allow me to publish a map service with feature access from. SQL Create Table TESTTAB1008(                          OBJECTID INTEGER,                          SHAPE MDSYS.SDO_GEOMETRY,                          TEXT_DATATYPE NVARCHAR2(50),                          Constraint PK_TESTTAB1008_OBJECTID Primary Key(OBJECTID)                              Using Index (Create Unique Index IDX_TESTTAB1008_OBJECTID On TESTTAB1008(OBJECTID))                         ); Comment on Column TESTTAB1008.OBJECTID Is 'ESRI auto-incrementing'; Delete From USER_SDO_GEOM_METADATA Where TABLE_NAME='TESTTAB1008'   And COLUMN_NAME='SHAPE'; Insert Into USER_SDO_GEOM_METADATA     Values (             'TESTTAB1008',             'SHAPE',             MDSYS.SDO_DIM_ARRAY(                                 MDSYS.SDO_DIM_ELEMENT('Longitude', -180, 180, .00000005),                                 MDSYS.SDO_DIM_ELEMENT('Latitude', -90, 90, .00000005)                                ),             4283); Create Index IDX_TESTTAB1008_SHAPE On TESTTAB1008(SHAPE)     INDEXTYPE Is MDSYS.SPATIAL_INDEX Parameters('SDO_COMMIT_INTERVAL = 1000') NOPARALLEL; Select OBJECT_ID From ALL_OBJECTS Where OBJECT_TYPE='TABLE'   And OWNER='PLANTRATING_MAIN'   And OBJECT_NAME='TESTTAB1008'; Create Sequence SEQ_9197425  -- OBJECT_ID from above query MinValue 1 Start With 1 Increment By 1 MaxValue 2147483647 NoCache Order; Create Or Replace Trigger BIFER_9197425  -- OBJECT_ID from above query     Before Insert     On TESTTAB1008     For Each Row         Declare             Begin         -- Assign the primary to the new record --         Select SEQ_9197425.NextVal Into :new.OBJECTID From DUAL;             End; Grant Select On TESTTAB1008 To Public; Commit; The next problem is it won't allow me to insert data via a webmap created in Portal 10.3.1 It's generating an error without the editor popping up Console error Request body Response body Results in Oracle database Our database is Oracle Spatial 10g using Oracle 11g client on my desktop with Oracle 12c client on ArcGIS server The feature class in Oracle has a SRID set against it (SRID: 4283 - GDA94) The feature class I created before using the database connection's new->feature class right click context menu uses the same SRID without any issues. Does this happen with your version? ... View more

Rex, Thank you for the SQL. I had to alter the trigger relating to getting the next value from the sequence to get it work. It worked the first time I ran the SQL. Made some changes to table name, etc. to minic a new feature class and no luck (getting the same error as above). Currently doing more testing. It is very odd behavour. ... View more

Alan, It is. We have used this to summate point data relative close to each other (eg. inspection data from Survey123). ... View more

Alan, Esri on their GitHub site have a js cluster code (https://github.com/Esri/cluster-layer-js) you could use. As you zoom in & out of the map the number in the circle changes based on the number of points near that site. Also, Other people have done things similar eg. https://github.com/nickcam/FlareClusterLayer Hope this helps ... View more

Agreed. We have a 10.3.1 platform at the moment and I would like to start looking at the new functionality of Enterprise Portal. Having the ability to go and purchase 10 L2 named users for a portal license would be fanastic instead of having to go back Esri account managers, etc. ... View more

There is more information (presentations) and videos from this year's Dev Summit (http://proceedings.esri.com/library/userconf/devsummit17/index.html). Have a look around and I used information from 'ArcGIS Enterprise: Architecting Your Deployment' to start designing my 10.5 platform ... View more

Yasser, I'm using Portal 10.3.1 with custom roles. ... View more

Yasser, Click the edit icon for that role. You will see a bunch of checkboxes relating to the action that user can perform. To disable adding items to your portal - Under 'General Privileges' look for 'Content' and uncheck 'Create, update, and delete' checkbox option. Regards ... View more

James, Will be looking forward to that release so I can use our on premise Portal/non hosting Server/Enterprise geodatabase combination. Also, will IWA be supported? We use single sign on in our platform Thanks ... View more

James, I have heard that feature services that are hosted are only supported. Is that correct? Thanks ... View more

Alex, How would you like to do this? Python, Javascript? ... View more

John, What is the resolution of the imagery & how much time did it take to process? I'm using a Win 10 PC with i7-4790 @ 3.6GHz CPU 16Gb RAM with 256Gb SSD drive with 36 x 7Mb 4592x3056pixel 24bit colour jpgs files and this takes approx 21minutes to process into a 3D textured mesh. Thanks ... View more

Dan, Are you able to attach the tutorial as it wants me to sign in to someone's AGOL account. Thanks ... View more