|
POST
|
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
07-02-2017
05:45 PM
|
0
|
0
|
4952
|
|
POST
|
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
06-29-2017
11:59 PM
|
0
|
0
|
4952
|
|
POST
|
Found this Esri support article (http://support.esri.com/technical-article/000012057) posted in May 2016 which goes through the steps to create database table, sequence, trigger that is suitable to create a feature class in Oracle Spatial RDBMS and pubish a feature service to allow editing of data. There is a note at the end of the article stating its for Server/Desktop 10.2.2. I have been through the steps using 10.3.1 with no success (publishing error 00166 - SEVERITY High - Layer's ObjectID is not maintained by the database and the feature service is being published with "Create" capability enabled, when being analyised) I was able to create a feature class within the Oracle Spatial RDBMS using the new->feature class right click context menu on the database connection file (.sde) within ArcMap/ArcCatalog and publish a feature service using that feature class with editing being possible when used in a WebMap. I have the correct permissions on the database for the schema I'm connecting to (eg. create table, index, sequence, trigger, package, procedure, function). Does anybody know where the documentation/steps are located to correctly create the feature class using SQL DDL statements only to allow a DBA to perform the task without needing any Esri application (eg. ArcMap/ArcCatalog) Thanks
... View more
06-21-2017
03:53 AM
|
1
|
7
|
6411
|
|
POST
|
Alan, It is. We have used this to summate point data relative close to each other (eg. inspection data from Survey123).
... View more
06-20-2017
08:24 PM
|
0
|
0
|
5116
|
|
POST
|
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
06-20-2017
06:11 PM
|
1
|
2
|
5116
|
|
IDEA
|
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
06-20-2017
03:30 PM
|
0
|
0
|
977
|
|
IDEA
|
i would like to see the functionality of configuring additional fields (eg. workorderid) to pass to Survey123 (eg. custom url) when setting up assignment types to surveys. This would allow a relationship between assignment & survey to be established. I want to use workforce to manage external contractor works with survey123 for asset inspections but is difficult without a relationship to do further analysis (eg. was the survey done/which asset was missed, etc.) Thanks
... View more
06-12-2017
06:18 AM
|
29
|
18
|
10226
|
|
POST
|
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
05-16-2017
06:02 PM
|
1
|
0
|
2469
|
|
POST
|
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
05-15-2017
04:41 AM
|
0
|
0
|
2329
|
|
POST
|
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
05-04-2017
04:40 PM
|
0
|
0
|
1471
|
|
POST
|
James, I have heard that feature services that are hosted are only supported. Is that correct? Thanks
... View more
05-04-2017
03:47 PM
|
0
|
2
|
1471
|
|
POST
|
Alex, How would you like to do this? Python, Javascript?
... View more
04-13-2017
03:21 AM
|
0
|
1
|
1257
|
|
POST
|
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
04-12-2017
12:43 AM
|
0
|
0
|
1872
|
|
POST
|
Dan, Are you able to attach the tutorial as it wants me to sign in to someone's AGOL account. Thanks
... View more
04-07-2017
07:03 PM
|
0
|
0
|
2469
|
| Title | Kudos | Posted |
|---|---|---|
| 3 | 01-18-2026 05:25 PM | |
| 2 | 01-03-2026 05:13 PM | |
| 4 | 11-11-2025 07:59 PM | |
| 1 | 10-10-2025 08:03 PM | |
| 1 | 10-19-2025 08:18 PM |
| Online Status |
Offline
|
| Date Last Visited |
05-12-2026
06:03 PM
|