topic Re: Create a feature class in Spatiotemporal Data Store in ArcGIS GeoEvent Server Questions

Create a feature class in Spatiotemporal Data Store

JerryStafurik — Fri, 04 Jan 2019 00:23:08 GMT

I have a feature class in a file geodatabase, that I would like to use as a template to create a new feature class in a Spatiotemporal data store and publish a feature service in Portal using this feature class.

If I use the 'Copy to Data Store' tool from GeoAnalytics Tools, this fails as the feature class is empty. If I create a 'dummy' record, it will create a new feature class in the data store, but creates new system fields (OBJECTID1, shapeLenght1, etc.), while keeping the existing system fields (OBJECTID, shapeLength). These fields also get published in the feature service, which is very confusing for end users, and not best practice in terms of data duplication, etc. I cannot change the structure of the feature class either, to remove the fields.

If I share a layer from ArcGIS Pro, I don't get a choice to publish to the Spatiotemporal data store.

How can I create a new empty and clean (without field duplication) feature class in the Spatiotemporal data store, which I can use to publish a feature service from in Portal using ArcGIS Pro or ArcPy?

Re: Create a feature class in Spatiotemporal Data Store

SarahAmbrose — Sun, 12 Dec 2021 16:53:57 GMT

Hi Jerry Stafurik‌,

I have two ideas about how you can do this. One though GeoAnalytics, and one without GeoAnalytics.

Through GeoAnalytics. Create a text file with the field names you are interested in, and one dummy row. For example, I created one that looked like this:
```
Field1,Field2,Field3
1,10.6,Hello
```
I then registered it as a big data file share, and used that as the input to Copy to Data Store. It created a layer with the following fields:
```
Field1, Field2, Field3, globalid, OBJECTID
```
The other way to do this, is to create a layer using the portal sharing API. You can use this endpoint to create a service: Create Service—ArcGIS REST API: Users, groups, and content | ArcGIS for Developers . To specify that you want to save it to spatiotemporal add the following:
```
"options":{"dataSourceType":"spatiotemporal"}
```
So your JSON might look something like this (sorry about the formatting - I recommend copying it in to a JSON viewer 😞

{                "currentVersion": 10.6,                "serviceDescription": "",                "hasVersionedData": false,                "supportsDisconnectedEditing": false,                "hasStaticData": true,                "maxRecordCount": 2000,                "supportedQueryFormats": "JSON",                "capabilities": "Query",                "description": "",                "copyrightText": "",                "allowGeometryUpdates": false,                "syncEnabled": false,                "editorTrackingInfo": {                                "enableEditorTracking": false,                                "enableOwnershipAccessControl": false,                                "allowOthersToUpdate": true,                                "allowOthersToDelete": true                },                "xssPreventionInfo": {                                "xssPreventionEnabled": true,                                "xssPreventionRule": "InputOnly",                                "xssInputRule": "rejectInvalid"                },                "tables": [],                "name": "mylayer",                "options":{"dataSourceType":"spatiotemporal"}  }

And then you can populate the values using the add to definition endpoint of the service. https:/<url>/<hosted server WA>/rest/admin/services/Hosted/mylayer/FeatureServer/addToDefinition . Make sure /admin/ is included in your URL, otherwise you won't see the addDefinition option.

Additionally, the following table outlines some of the differences between spatiotemporal and relational. At 10.6.1, you are not able to delete columns from a layer hosted in the spatiotemporal big data store.

Please let me know if you have any follow up questions.

Sarah Ambrose

Product Engineer, GeoAnalytics Team

Re: Create a feature class in Spatiotemporal Data Store

JerryStafurik — Mon, 07 Jan 2019 07:02:54 GMT

Hi Sarah,

Thanks for your response. Using the sample 'Create Service' JSON for the REST API interface, will create a feature service without a table in the data store. How can I specify the table/feature class to be created, including the field definitions?

Thanks,

Jerry

Re: Create a feature class in Spatiotemporal Data Store

SarahAmbrose — Mon, 07 Jan 2019 17:20:44 GMT

Hi Jerry Stafurik,

You can use the REST call addToDefinition on the feature service. The documentation for that call is outlined here: Add to Definition (Feature Service)—ArcGIS REST API: Services Directory | ArcGIS for Developers

You will access it by going to the following URL of the FS you created, https:/<url>/<hosted server WA>/rest/admin/services/Hosted/mylayer/FeatureServer/addToDefinition, and modify the JSON to outline the feature service you are interested in creating.

- Sarah

Re: Create a feature class in Spatiotemporal Data Store

LeonAus — Thu, 06 Feb 2020 04:03:49 GMT

Hi Sarah,

When I try and use the addToDefinition call on my 10.6.1 portal feature service (using the admin page or a python script) I get this response:

{  "error": {   "code": 403,   "subcode": 2,   "message": "Access to admin resources are not allowed, Signed Request needed for 'AddToDefinition' with table",   "details": []  } }

How do I get past this problem? I have successfully signed into the admin page so I don't think it's a permission issue.

(I am not the only person getting this problem - https://community.esri.com/thread/244629-portal-1071-throws-error-with-addtodefinition-endpoint-in-rest-api )

Thanks,

Leon.

Re: Create a feature class in Spatiotemporal Data Store

GauravMaske1 — Mon, 10 Feb 2020 18:47:34 GMT

Hi Leon / Jerry,

Please try the answer provided in the this following thread and let me know if works for you - Portal 10.7.1 throws error with AddToDefinition endpoint in REST API.

Re: Create a feature class in Spatiotemporal Data Store

GillPaterson — Tue, 21 Apr 2020 23:38:58 GMT

Hi,

Is the portal sharing API Create Service still the best option for creating a feature service with a spatiotemporal datasource in 10.8?

Thanks,

Gill

Re: Create a feature class in Spatiotemporal Data Store

GauravMaske1 — Wed, 22 Apr 2020 00:13:36 GMT

Yes. It is still the only option to create feature service with a spatiotemporal data source without using GeoAnalytics or GeoEvent Server.

Re: Create a feature class in Spatiotemporal Data Store

GillPaterson — Wed, 22 Apr 2020 00:50:03 GMT

Thank you!

Re: Create a feature class in Spatiotemporal Data Store

AmarG1 — Wed, 27 Jan 2021 23:53:33 GMT

Hi Sarah,

When I do AddToDefinition on feature service created in STBDS with "supportsLod":true in "advancedQueryCapabilities", the created feature layer has the setting to false. What is the correct way to set Lod?

Following is a portion of my AddToDefinition:

{
"layers": [
{
"allowGeometryUpdates": false,
"capabilities": "Create,Editing,Uploads,Query,Update,Delete,Extract",

...

"advancedQueryCapabilities":{

...

"supportsLod":true,

...

"lodInfos": [...],

...

]

}

--Thanks