Adding related table to ArcGIS Online feature layer

24629
67
Jump to solution
01-08-2019 10:26 AM
EricGardecki1
New Contributor II

I'm trying to figure out how to add a relationship class (related table one-to-many) to a feature layer within AGOL. I do not have ArcGIS Desktop or Server (do have QGIS but I don't think that will help here).

The only info I was able to find led me to believe that it may be possible by editing the service definition JSON but I can't find any reference as to how to edit it to make it work.

What are my options here?

Also, is viewing/editing/adding to related tables supported in AGOL web apps yet (not just Collector)?

Thanks!!

0 Kudos
67 Replies
SavannahWinstanley1
New Contributor II

I apologize if this is somewhere in this thread already but is there a detailed guide for someone unfamiliar working with REST API on how to use the API in ArcGIS Online to add one feature service as a related feature class to another.

The two services I need to relate are a line feature service and a workforce assignments layer generated from the line feature service: The end goal is to have the line feature layer that is generating the assignments layer relate back to the assignments in workforce so you can see work status for the full feature, and create a kind of "work log" for the line features. If there is a simpler/other workaround for this let me know. 

line feature service:https://services.arcgis.com/hNKc1r3SBL6SVC6I/arcgis/rest/services/Winter_Haven_Street_Sweeping_Miles...  https://services.arcgis.com/hNKc1r3SBL6SVC6I/arcgis/rest/services/assignments_28181aca2529487a976fc8...

assignments service:

https://services.arcgis.com/hNKc1r3SBL6SVC6I/arcgis/rest/services/assignments_28181aca2529487a976fc8... 

I've found the API input below but am unsure how to proceed. I can provide you with the JSON for each feature service mentioned if that's helpful!

Upload Item/Add to Definition API input

Thanks!

0 Kudos
KhaledHassen
Esri Contributor

Hi Savannah,

Updating the item above will not help you and not the right way to do this.

If you need to relate two services, the only way is to create a join view. So you will end up with a view of the two services joined into one layer. I can send you more info about this if this is what you can use. But this is the only way we have currently that joined two separate feature services.

You will need to create an empty feature service view and then add a view layer. I can send you the json you need to use to create the join feature service view.

Thanks

Khaled Hassen

Online FeatureService Dev. Lead

0 Kudos
KevinMacLeodCAI
Occasional Contributor II

 

@KhaledHassen  is it possible to create a Relate table as a hosted table on an Organization, if the feature class dataset itself was on another server (on an ArcGIS Enterprise SDE 10.7.1 server)?  For example let's say one entity had an SDE server with some datasets. But, they wanted to collaborate with another agency who has their own AGOL Org. And they wanted the relate tables there on their own Org so they can keep domains updated themselves on a relate table? (With the data living on the separate SDE on agency 1's Enterprise Server)

0 Kudos
KevinMacLeodCAI
Occasional Contributor II

@KhaledHassen  greetings, and another question.

1. Is it possible to create a table in ArcGIS Online? (it appears only possible through Pro or ArcMap, which is ok, though it would be nice to be able to simply click "Create" in AGOL, then create a table.)

 

2. Is it possible to create a relate, in ArcGIS Online with this new table? 

 

This is an extremely common question / workflow. For example, I have a layer of street signs. The town has now asked if we can track inspections in ArcGIS Online. So a record of each inspection can be kept. (like how inspection tables are used as digital forms for Collector sometimes) It seems... no?  Since we already created the feature class, but when it was created there was no related table. It seems like either you have to create the related table at the same time, but you can't go back, and create a hosted table (upload a table) and relate it to an existing hosted feature class after the fact?  

And.... I know, I could probably upload the table, make a hosted View then add that to a webmap. But if the feature class was already added to webmaps.. that means redoing the webmaps and all settings, etc. And actually, I don't even know if that would work, since I recall records can't be added to a hosted table. (Is that still the case? This is limiting, and hopefully will be implemented)  So, was just wanting to ask this question to see if maybe now it was possible to create a hosted table and a relate on AGOL now?  Or if not hopefully it can be a Feature Enhancement.  Thank you all for any advice or thoughts. 

0 Kudos
HermanLouie1
New Contributor II

I'm in a similar situation where I have 1000's Street Lights (read-only as they are updated every night) and having Painting Records (with pictures) for these points, sometimes with multiple painting records (I'll be uploading historical) 

How to create a RELATIONSHIP CLASS with an AGOL Feature Layer (hosted)?  Any luck?

0 Kudos
DavidBuehler
Occasional Contributor III

@KhaledHassen -  I have a successfully created the table and relationship, however nothing pushes and/or errors out in Fieldmaps/Collector/Web map.  Cannot see or push to the related table.

Here is the hosted service:

https://services2.arcgis.com/SZYqn7iYnvAZ1Q4U/arcgis/rest/services/rrtestv5/FeatureServer 

I get a service error code 1000 Unable to submit.  Thoughts?

 

0 Kudos
KhaledHassen
Esri Contributor

Pl. provide me with some info and I can double check. What API you are calling, applyEdits, etc,?

I see the layer has the relationship set correctly. 

0 Kudos
DavidBuehler
Occasional Contributor III

Background - Feature layer is related to the table (table was created in Survey123 Connect in order to get the bind type of GUID) based on GlobalID and GUID.  Feature layer will be an existing set of features that now need maintenance records (hence the related records table).

Ideally,  it would be used in Field Maps and/or Collector.  Which currently do not push the related record back though it shows the table is there as a related record table.  Which then I would assume would also so in any web maps.  Web map has the see related records box checked.

Not sure what else I can share with you.  If you need something else please let me know because if this can be figured out this a game changer for lots of people.

 

Here is the JSON for the service:

 

{
"adminServiceInfo" : {
"name" : "rrtestv5",
"type" : "FeatureServer",
"cacheMaxAge" : 0,
"status" : "Started",
"database" : {
"datasource" : {
"name" : "db"
}
}
},
"currentVersion" : 10.81,
"serviceItemId" : "fabfe8d3af784fb7a16cc3942bd1bedf",
"serviceDescription" : "",
"hasVersionedData" : false,
"supportsDisconnectedEditing" : false,
"hasStaticData" : false,
"hasSharedDomains" : false,
"maxRecordCount" : 2000,
"supportedQueryFormats" : "JSON",
"supportsVCSProjection" : false,
"supportedExportFormats" : "csv,shapefile,sqlite,gpkg,filegdb,featureCollection,geojson,excel",
"capabilities" : "Create,Delete,Query,Update,Editing,Sync",
"description" : "",
"copyrightText" : "",
"spatialReference" : {
"wkid" : 102100,
"latestWkid" : 3857
},
"initialExtent" : {
"xmin" : -10064729.121092074,
"ymin" : 5558924.3042244306,
"xmax" : -10005952.429953229,
"ymax" : 5578801.8141854359,
"spatialReference" : {
"wkid" : 102100,
"latestWkid" : 3857
}
},
"fullExtent" : {
"xmin" : -10064729.121092074,
"ymin" : 5558924.3042244306,
"xmax" : -10005952.429953229,
"ymax" : 5578801.8141854359,
"spatialReference" : {
"wkid" : 102100,
"latestWkid" : 3857
}
},
"allowGeometryUpdates" : true,
"units" : "esriMeters",
"supportsAppend" : true,
"supportsSharedDomains" : true,
"supportsWebHooks" : true,
"supportsTemporalLayers" : true,
"layerOverridesEnabled" : true,
"size" : 16384,
"syncEnabled" : true,
"syncCapabilities" : {
"supportsAsync" : true,
"supportsRegisteringExistingData" : true,
"supportsSyncDirectionControl" : true,
"supportsPerLayerSync" : true,
"supportsPerReplicaSync" : true,
"supportsSyncModelNone" : true,
"supportsRollbackOnFailure" : true,
"supportsAttachmentsSyncDirection" : true,
"supportsBiDirectionalSyncForServer" : true
},
"supportsApplyEditsWithGlobalIds" : true,
"supportsReturnDeleteResults" : true,
"supportsLayerOverrides" : true,
"supportsTilesAndBasicQueriesMode" : true,
"supportsQueryContingentValues" : true,
"supportedContingentValuesFormats" : "JSON, PBF",
"supportsContingentValuesJson" : 2,
"editorTrackingInfo" : {
"enableEditorTracking" : true,
"enableOwnershipAccessControl" : false,
"allowOthersToQuery" : true,
"allowOthersToUpdate" : true,
"allowOthersToDelete" : false,
"allowAnonymousToQuery" : true,
"allowAnonymousToUpdate" : true,
"allowAnonymousToDelete" : true
},
"xssPreventionInfo" : {
"xssPreventionEnabled" : true,
"xssPreventionRule" : "InputOnly",
"xssInputRule" : "rejectInvalid"
},
"layers" : [
{
"adminLayerInfo" : {
"tableName" : "db_42239.user_42239.rrtestv5_POINT_LAYER",
"geometryField" : {"name" : "Shape"},
"xssTrustedFields" : ""
},
"id" : 0,
"enableUseOfScaleOutReplicasWhenEditable" : true,
"name" : "Point layer",
"type" : "Feature Layer",
"displayField" : "",
"description" : "",
"copyrightText" : "",
"defaultVisibility" : true,
"editFieldsInfo" : {
"creationDateField" : "CreationDate",
"creatorField" : "Creator",
"editDateField" : "EditDate",
"editorField" : "Editor"
},
"editingInfo" : {
"lastEditDate" : 1629315116344
},
"relationships" : [
{
"id" : 1,
"name" : "myRel",
"relatedTableId" : 1,
"cardinality" : "esriRelCardinalityOneToMany",
"role" : "esriRelRoleOrigin",
"keyField" : "globalid",
"composite" : true
}
],
"isDataVersioned" : false,
"hasContingentValuesDefinition" : false,
"supportsAppend" : true,
"supportsCalculate" : true,
"supportsASyncCalculate" : true,
"supportsTruncate" : false,
"supportsAttachmentsByUploadId" : true,
"supportsAttachmentsResizing" : true,
"supportsRollbackOnFailureParameter" : true,
"supportsStatistics" : true,
"supportsExceedsLimitStatistics" : true,
"supportsAdvancedQueries" : true,
"supportsValidateSql" : true,
"supportsCoordinatesQuantization" : true,
"supportsLayerOverrides " : true,
"supportsTilesAndBasicQueriesMode" : true,
"supportsFieldDescriptionProperty" : true,
"supportsQuantizationEditMode" : true,
"supportsApplyEditsWithGlobalIds" : true,
"supportsReturningQueryGeometry" : true,
"advancedQueryCapabilities" : {
"supportsPagination" : true,
"supportsPaginationOnAggregatedQueries" : true,
"supportsQueryRelatedPagination" : true,
"supportsQueryWithDistance" : true,
"supportsReturningQueryExtent" : true,
"supportsStatistics" : true,
"supportsOrderBy" : true,
"supportsDistinct" : true,
"supportsQueryWithResultType" : true,
"supportsSqlExpression" : true,
"supportsAdvancedQueryRelated" : true,
"supportsCountDistinct" : true,
"supportsPercentileStatistics" : true,
"supportsQueryAttachments" : true,
"supportsReturningGeometryCentroid" : false,
"supportsQueryWithDatumTransformation" : true,
"supportsHavingClause" : true,
"supportsOutFieldSQLExpression" : true,
"supportsMaxRecordCountFactor" : true,
"supportsTopFeaturesQuery" : true,
"supportsDisjointSpatialRel" : true,
"supportsQueryWithCacheHint" : true,
"supportsQueryAttachmentsWithReturnUrl" : true,
"supportsQueryAnalytic" : true
},
"useStandardizedQueries" : true,
"geometryType" : "esriGeometryPoint",
"minScale" : 0,
"maxScale" : 0,
"extent" : {
"xmin" : -10064729.121092074,
"ymin" : 5558924.3042244306,
"xmax" : -10005952.429953229,
"ymax" : 5578801.8141854359,
"spatialReference" : {
"wkid" : 102100,
"latestWkid" : 3857
}
},
"drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"RedSphere.png","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15}}},
"allowGeometryUpdates" : true,
"hasAttachments" : true,

"attachmentProperties" : [
{
"name" : "id",
"fieldName" : "ATTACHMENTID",
"isEnabled" : true
},
{
"name" : "globalId",
"fieldName" : "AttachmentGlobalID",
"isEnabled" : true
},
{
"name" : "name",
"fieldName" : "ATT_NAME",
"isEnabled" : true
},
{
"name" : "size",
"fieldName" : "DATA_SIZE",
"isEnabled" : true
},
{
"name" : "contentType",
"fieldName" : "CONTENT_TYPE",
"isEnabled" : true
},
{
"name" : "keywords",
"fieldName" : "Keywords",
"isEnabled" : true
},
{
"name" : "exifInfo",
"fieldName" : "ExifInfo",
"isEnabled" : true
}
],
"htmlPopupType" : "esriServerHTMLPopupTypeNone",
"hasM" : false,
"hasZ" : false,
"objectIdField" : "OBJECTID",
"globalIdField" : "GlobalID",
"typeIdField" : "",
"fields" : [
{
"name" : "OBJECTID",
"type" : "esriFieldTypeOID",
"alias" : "OBJECTID",
"sqlType" : "sqlTypeOther",
"nullable" : false,
"editable" : false,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "GlobalID",
"type" : "esriFieldTypeGlobalID",
"alias" : "",
"sqlType" : "sqlTypeOther",
"length" : 38,
"nullable" : false,
"editable" : false,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "CreationDate",
"type" : "esriFieldTypeDate",
"alias" : "CreationDate",
"sqlType" : "sqlTypeOther",
"length" : 8,
"nullable" : true,
"editable" : false,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Creator",
"type" : "esriFieldTypeString",
"alias" : "Creator",
"sqlType" : "sqlTypeOther",
"length" : 128,
"nullable" : true,
"editable" : false,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "EditDate",
"type" : "esriFieldTypeDate",
"alias" : "EditDate",
"sqlType" : "sqlTypeOther",
"length" : 8,
"nullable" : true,
"editable" : false,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Editor",
"type" : "esriFieldTypeString",
"alias" : "Editor",
"sqlType" : "sqlTypeOther",
"length" : 128,
"nullable" : true,
"editable" : false,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "facid",
"type" : "esriFieldTypeString",
"alias" : "FacilityID",
"sqlType" : "sqlTypeOther",
"length" : 256,
"nullable" : true,
"editable" : true,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Comments",
"type" : "esriFieldTypeString",
"alias" : "Comments",
"sqlType" : "sqlTypeOther",
"length" : 256,
"nullable" : true,
"editable" : true,
"visible" : true,
"domain" : null,
"defaultValue" : null
}
],
"indexes" : [
{
"name" : "GlobalID_Index",
"fields" : "GlobalID",
"isAscending" : false,
"isUnique" : true,
"description" : ""
},
{
"name" : "user_42239.rrtestv5_POINT_LAYER_Shape_sidx",
"fields" : "Shape",
"isAscending" : false,
"isUnique" : false,
"description" : "Shape Index"
},
{
"name" : "PK__rrtestv5__F4B70D855C3DCA2D",
"fields" : "OBJECTID",
"isAscending" : true,
"isUnique" : true,
"description" : "clustered, unique, primary key"
},
{
"name" : "CreationDateIndex",
"fields" : "CreationDate",
"isAscending" : true,
"isUnique" : false,
"description" : "CreationDate Field index"
},
{
"name" : "CreatorIndex",
"fields" : "Creator",
"isAscending" : false,
"isUnique" : false,
"description" : "Creator Field index"
},
{
"name" : "EditDateIndex",
"fields" : "EditDate",
"isAscending" : true,
"isUnique" : false,
"description" : "EditDate Field index"
},
{
"name" : "EditorIndex",
"fields" : "Editor",
"isAscending" : false,
"isUnique" : false,
"description" : "Editor Field index"
}
],
"dateFieldsTimeReference" : {
"timeZone" : "UTC",
"respectsDaylightSaving" : false
},
"preferredTimeReference" : null,
"types" : [],
"templates" : [
{
"name" : "New Feature",
"description" : "",
"drawingTool" : "esriFeatureEditToolPoint",
"prototype" : {
"attributes" : {
"facid" : null,
"Comments" : null
}
}
}
],
"supportedQueryFormats" : "JSON, geoJSON, PBF",
"supportedAppendFormats" : "sqlite,gpkg,shapefile,filegdb,featureCollection,geojson,csv,excel,imageCollection",
"supportedExportFormats" : "csv,shapefile,sqlite,gpkg,filegdb,featureCollection,geojson,excel",
"supportedContingentValuesFormats" : "JSON, PBF",
"hasStaticData" : false,
"maxRecordCount" : 2000,
"standardMaxRecordCount" : 32000,
"standardMaxRecordCountNoGeometry" : 32000,
"tileMaxRecordCount" : 8000,
"maxRecordCountFactor" : 1,
"capabilities" : "Create,Delete,Query,Update,Editing,Sync",
"exceedsLimitFactor" : 1
},
{
"adminLayerInfo" : {
"tableName" : "db_42239.user_42239.rrtestv5_RRTESTV5T2", "geometryField" : null,
"xssTrustedFields" : ""
},
"id" : 1,
"enableUseOfScaleOutReplicasWhenEditable" : true,
"name" : "rrtestv5t2",
"type" : "Table",
"displayField" : "",
"description" : "",
"copyrightText" : "",
"defaultVisibility" : true,
"editingInfo" : {
"lastEditDate" : 1629314788379
},
"relationships" : [
{
"id" : 1,
"name" : "myRel",
"relatedTableId" : 0,
"cardinality" : "esriRelCardinalityOneToMany",
"role" : "esriRelRoleDestination",
"keyField" : "GUIDID",
"composite" : true
}
],
"isDataVersioned" : false,
"hasContingentValuesDefinition" : false,
"supportsAppend" : true,
"supportsCalculate" : true,
"supportsASyncCalculate" : true,
"supportsTruncate" : false,
"supportsAttachmentsByUploadId" : true,
"supportsAttachmentsResizing" : true,
"supportsRollbackOnFailureParameter" : true,
"supportsStatistics" : true,
"supportsExceedsLimitStatistics" : true,
"supportsAdvancedQueries" : true,
"supportsValidateSql" : true,
"supportsCoordinatesQuantization" : true,
"supportsLayerOverrides " : true,
"supportsTilesAndBasicQueriesMode" : true,
"supportsFieldDescriptionProperty" : true,
"supportsQuantizationEditMode" : true,
"supportsApplyEditsWithGlobalIds" : true,
"advancedQueryCapabilities" : {
"supportsPagination" : true,
"supportsPaginationOnAggregatedQueries" : true,
"supportsQueryRelatedPagination" : true,
"supportsQueryWithDistance" : true,
"supportsReturningQueryExtent" : true,
"supportsStatistics" : true,
"supportsOrderBy" : true,
"supportsDistinct" : true,
"supportsQueryWithResultType" : true,
"supportsSqlExpression" : true,
"supportsAdvancedQueryRelated" : true,
"supportsCountDistinct" : true,
"supportsPercentileStatistics" : true,
"supportsReturningGeometryCentroid" : false,
"supportsQueryWithDatumTransformation" : true,
"supportsHavingClause" : true,
"supportsOutFieldSQLExpression" : true,
"supportsMaxRecordCountFactor" : true,
"supportsTopFeaturesQuery" : true,
"supportsQueryWithCacheHint" : true,
"supportsQueryAnalytic" : true
},
"useStandardizedQueries" : true,
"allowGeometryUpdates" : true,
"hasAttachments" : false,
"htmlPopupType" : "esriServerHTMLPopupTypeNone",
"hasM" : false,
"hasZ" : false,
"globalIdField" : "globalid",
"typeIdField" : "",
"fields" : [
{
"name" : "objectid",
"type" : "esriFieldTypeOID",
"alias" : "ObjectID",
"sqlType" : "sqlTypeOther",
"nullable" : false,
"editable" : false,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "globalid",
"type" : "esriFieldTypeGlobalID",
"alias" : "GlobalID",
"sqlType" : "sqlTypeGUID",
"length" : 38,
"nullable" : false,
"editable" : false,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "FACILITYID",
"type" : "esriFieldTypeString",
"alias" : "Facility ID",
"sqlType" : "sqlTypeOther",
"length" : 50,
"nullable" : true,
"editable" : true,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "DATE",
"type" : "esriFieldTypeDate",
"alias" : "Date",
"sqlType" : "sqlTypeOther",
"length" : 255,
"nullable" : true,
"editable" : true,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "INSPECTOR",
"type" : "esriFieldTypeString",
"alias" : "Inspector",
"sqlType" : "sqlTypeOther",
"length" : 50,
"nullable" : true,
"editable" : true,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "CONDITION",
"type" : "esriFieldTypeString",
"alias" : "Condition",
"sqlType" : "sqlTypeOther",
"length" : 50,
"nullable" : true,
"editable" : true,
"visible" : true,
"domain" :
{
"type" : "codedValue",
"name" : "cvd_CONDITION",
"codedValues" : [
{
"name" : "Excellent",
"code" : "Excellent"
},
{
"name" : "Very Good",
"code" : "Very Good"
},
{
"name" : "Good",
"code" : "Good"
},
{
"name" : "Fair",
"code" : "Fair"
},
{
"name" : "Poor",
"code" : "Poor"
},
{
"name" : "Very Poor",
"code" : "Very Poor"
},
{
"name" : "Unknown",
"code" : "Unknown"
}
]
},
"defaultValue" : null
},
{
"name" : "COMMENTS",
"type" : "esriFieldTypeString",
"alias" : "Comments",
"sqlType" : "sqlTypeOther",
"length" : 1000,
"nullable" : true,
"editable" : true,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "GUIDID",
"type" : "esriFieldTypeGUID",
"alias" : "GUID",
"sqlType" : "sqlTypeOther",
"length" : 38,
"nullable" : true,
"editable" : true,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "CreationDate",
"type" : "esriFieldTypeDate",
"alias" : "CreationDate",
"sqlType" : "sqlTypeOther",
"length" : 8,
"nullable" : true,
"editable" : false,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Creator",
"type" : "esriFieldTypeString",
"alias" : "Creator",
"sqlType" : "sqlTypeOther",
"length" : 128,
"nullable" : true,
"editable" : false,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "EditDate",
"type" : "esriFieldTypeDate",
"alias" : "EditDate",
"sqlType" : "sqlTypeOther",
"length" : 8,
"nullable" : true,
"editable" : false,
"visible" : true,
"domain" : null,
"defaultValue" : null
},
{
"name" : "Editor",
"type" : "esriFieldTypeString",
"alias" : "Editor",
"sqlType" : "sqlTypeOther",
"length" : 128,
"nullable" : true,
"editable" : false,
"visible" : true,
"domain" : null,
"defaultValue" : null
}
],
"indexes" : [
{
"name" : "UK_rrtestv5_RRTESTV5T2_globalid",
"fields" : "globalid",
"isAscending" : true,
"isUnique" : true,
"description" : "nonclustered, unique"
},
{
"name" : "PK__rrtestv5__5242E6323C0B1297",
"fields" : "objectid",
"isAscending" : true,
"isUnique" : true,
"description" : "clustered, unique, primary key"
}
],
"dateFieldsTimeReference" : {
"timeZone" : "UTC",
"respectsDaylightSaving" : false
},
"preferredTimeReference" : null,
"types" : [],
"templates" : [],
"supportedQueryFormats" : "JSON, geoJSON, PBF",
"supportedAppendFormats" : "sqlite,gpkg,shapefile,filegdb,featureCollection,geojson,csv,excel",
"supportedExportFormats" : "csv,shapefile,sqlite,gpkg,filegdb,featureCollection,geojson,excel",
"supportedContingentValuesFormats" : "JSON, PBF",
"hasStaticData" : false,
"maxRecordCount" : 2000,
"standardMaxRecordCount" : 32000,
"tileMaxRecordCount" : 8000,
"maxRecordCountFactor" : 1,
"capabilities" : "Create,Delete,Query,Update,Editing,Sync",
"exceedsLimitFactor" : 1
}
]
}

 

0 Kudos