{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "SRTSF", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ProjectID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ProjectID", "type": "esriFieldTypeString", "alias": "ProjectID", "length": 36, "domain": null }, { "name": "StepID", "type": "esriFieldTypeString", "alias": "StepID", "length": 50, "domain": null }, { "name": "IsComplete", "type": "esriFieldTypeSmallInteger", "alias": "IsComplete", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SRTS_NAS", "type": "esriFieldTypeString", "alias": "SRTS_NAS", "length": 250, "domain": null }, { "name": "SRTS_SAC", "type": "esriFieldTypeString", "alias": "SRTS_SAC", "length": 250, "domain": null }, { "name": "SRTS_SA_Title", "type": "esriFieldTypeString", "alias": "SRTS_SA_Title", "length": 250, "domain": null }, { "name": "SRTS_SA_Tel", "type": "esriFieldTypeString", "alias": "SRTS_SA_Tel", "length": 50, "domain": null }, { "name": "SRTS_SA_Email", "type": "esriFieldTypeString", "alias": "SRTS_SA_Email", "length": 250, "domain": null }, { "name": "SRTS_SA_Add1", "type": "esriFieldTypeString", "alias": "SRTS_SA_Add1", "length": 250, "domain": null }, { "name": "SRTS_SA_Add2", "type": "esriFieldTypeString", "alias": "SRTS_SA_Add2", "length": 250, "domain": null }, { "name": "SRTS_SA_City", "type": "esriFieldTypeString", "alias": "SRTS_SA_City", "length": 50, "domain": null }, { "name": "SRTS_SA_Pin", "type": "esriFieldTypeString", "alias": "SRTS_SA_Pin", "length": 50, "domain": null }, { "name": "SRTS_MAC", "type": "esriFieldTypeString", "alias": "SRTS_MAC", "length": 250, "domain": null }, { "name": "SRTS_MA_Title", "type": "esriFieldTypeString", "alias": "SRTS_MA_Title", "length": 250, "domain": null }, { "name": "SRTS_MA_Tel", "type": "esriFieldTypeString", "alias": "SRTS_MA_Tel", "length": 50, "domain": null }, { "name": "SRTS_MA_Email", "type": "esriFieldTypeString", "alias": "SRTS_MA_Email", "length": 250, "domain": null }, { "name": "SRTS_MA_Add1", "type": "esriFieldTypeString", "alias": "SRTS_MA_Add1", "length": 250, "domain": null }, { "name": "SRTS_MA_Add2", "type": "esriFieldTypeString", "alias": "SRTS_MA_Add2", "length": 250, "domain": null }, { "name": "SRTS_MA_Pin", "type": "esriFieldTypeString", "alias": "SRTS_MA_Pin", "length": 50, "domain": null }, { "name": "SRTS_MA_City", "type": "esriFieldTypeString", "alias": "SRTS_MA_City", "length": 250, "domain": null }, { "name": "A1", "type": "esriFieldTypeSmallInteger", "alias": "A1", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "A2", "type": "esriFieldTypeString", "alias": "A2", "length": 50, "domain": null }, { "name": "A3", "type": "esriFieldTypeString", "alias": "A3", "length": 50, "domain": null }, { "name": "date", "type": "esriFieldTypeDate", "alias": "SRTS_Date", "length": 8, "domain": null }, { "name": "A4", "type": "esriFieldTypeString", "alias": "A4", "length": 50, "domain": null }, { "name": "A5", "type": "esriFieldTypeString", "alias": "A5", "length": 50, "domain": null }, { "name": "A6", "type": "esriFieldTypeString", "alias": "A6", "length": 50, "domain": null }, { "name": "A7", "type": "esriFieldTypeString", "alias": "A7", "length": 50, "domain": null }, { "name": "A8", "type": "esriFieldTypeString", "alias": "A8", "length": 50, "domain": null }, { "name": "A9", "type": "esriFieldTypeString", "alias": "A9", "length": 50, "domain": null }, { "name": "A10", "type": "esriFieldTypeString", "alias": "A10", "length": 50, "domain": null }, { "name": "A11", "type": "esriFieldTypeString", "alias": "A11", "length": 50, "domain": null }, { "name": "A12", "type": "esriFieldTypeString", "alias": "A12", "length": 50, "domain": null }, { "name": "A13", "type": "esriFieldTypeString", "alias": "A13", "length": 50, "domain": null }, { "name": "A13_Desc", "type": "esriFieldTypeString", "alias": "A13_Desc", "length": 250, "domain": null }, { "name": "A14", "type": "esriFieldTypeString", "alias": "A14", "length": 3000, "domain": null }, { "name": "A15", "type": "esriFieldTypeString", "alias": "A15", "length": 50, "domain": null }, { "name": "A16", "type": "esriFieldTypeString", "alias": "A16", "length": 50, "domain": null }, { "name": "A17", "type": "esriFieldTypeString", "alias": "A17", "length": 50, "domain": null }, { "name": "A18", "type": "esriFieldTypeString", "alias": "A18", "length": 50, "domain": null }, { "name": "A19", "type": "esriFieldTypeString", "alias": "A19", "length": 50, "domain": null }, { "name": "A20", "type": "esriFieldTypeString", "alias": "A20", "length": 50, "domain": null }, { "name": "A21", "type": "esriFieldTypeString", "alias": "A21", "length": 50, "domain": null }, { "name": "A22", "type": "esriFieldTypeString", "alias": "A22", "length": 50, "domain": null }, { "name": "A23", "type": "esriFieldTypeString", "alias": "A23", "length": 50, "domain": null }, { "name": "A24", "type": "esriFieldTypeString", "alias": "A24", "length": 50, "domain": null }, { "name": "A25", "type": "esriFieldTypeSmallInteger", "alias": "A25", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "A26", "type": "esriFieldTypeString", "alias": "A26", "length": 3000, "domain": null }, { "name": "A27", "type": "esriFieldTypeSmallInteger", "alias": "A27", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "A28", "type": "esriFieldTypeString", "alias": "A28", "length": 50, "domain": null }, { "name": "Per_Old", "type": "esriFieldTypeString", "alias": "Per", "length": 50, "domain": null }, { "name": "A29", "type": "esriFieldTypeString", "alias": "A29", "length": 50, "domain": null }, { "name": "A30", "type": "esriFieldTypeString", "alias": "A30", "length": 50, "domain": null }, { "name": "A31", "type": "esriFieldTypeString", "alias": "A31", "length": 50, "domain": null }, { "name": "A32", "type": "esriFieldTypeString", "alias": "A32", "length": 50, "domain": null }, { "name": "A33", "type": "esriFieldTypeString", "alias": "A33", "length": 50, "domain": null }, { "name": "A34", "type": "esriFieldTypeString", "alias": "A34", "length": 50, "domain": null }, { "name": "A35", "type": "esriFieldTypeString", "alias": "A35", "length": 50, "domain": null }, { "name": "A36", "type": "esriFieldTypeString", "alias": "A36", "length": 50, "domain": null }, { "name": "A37", "type": "esriFieldTypeString", "alias": "A37", "length": 50, "domain": null }, { "name": "A38", "type": "esriFieldTypeString", "alias": "A38", "length": 50, "domain": null }, { "name": "A39", "type": "esriFieldTypeString", "alias": "A39", "length": 50, "domain": null }, { "name": "A40", "type": "esriFieldTypeString", "alias": "A40", "length": 50, "domain": null }, { "name": "A41", "type": "esriFieldTypeString", "alias": "A41", "length": 50, "domain": null }, { "name": "A42", "type": "esriFieldTypeString", "alias": "A42", "length": 50, "domain": null }, { "name": "A43", "type": "esriFieldTypeString", "alias": "A43", "length": 50, "domain": null }, { "name": "A44", "type": "esriFieldTypeString", "alias": "A44", "length": 50, "domain": null }, { "name": "A45", "type": "esriFieldTypeString", "alias": "A45", "length": 50, "domain": null }, { "name": "A46", "type": "esriFieldTypeString", "alias": "A46", "length": 50, "domain": null }, { "name": "A47", "type": "esriFieldTypeString", "alias": "A47", "length": 50, "domain": null }, { "name": "A48", "type": "esriFieldTypeString", "alias": "A48", "length": 50, "domain": null }, { "name": "A49", "type": "esriFieldTypeString", "alias": "A49", "length": 50, "domain": null }, { "name": "A50", "type": "esriFieldTypeString", "alias": "A50", "length": 50, "domain": null }, { "name": "A51", "type": "esriFieldTypeString", "alias": "A51", "length": 50, "domain": null }, { "name": "A52", "type": "esriFieldTypeString", "alias": "A52", "length": 50, "domain": null }, { "name": "A53", "type": "esriFieldTypeString", "alias": "A53", "length": 50, "domain": null }, { "name": "A54", "type": "esriFieldTypeString", "alias": "A54", "length": 50, "domain": null }, { "name": "A55", "type": "esriFieldTypeString", "alias": "A55", "length": 50, "domain": null }, { "name": "A56", "type": "esriFieldTypeString", "alias": "A56", "length": 50, "domain": null }, { "name": "A57", "type": "esriFieldTypeString", "alias": "A57", "length": 50, "domain": null }, { "name": "A58", "type": "esriFieldTypeString", "alias": "A58", "length": 50, "domain": null }, { "name": "A59", "type": "esriFieldTypeString", "alias": "A59", "length": 50, "domain": null }, { "name": "A60", "type": "esriFieldTypeString", "alias": "A60", "length": 50, "domain": null }, { "name": "Per", "type": "esriFieldTypeSmallInteger", "alias": "Per", "domain": { "type": "codedValue", "name": "dPer", "description": "Per Week, Month, Year", "codedValues": [ { "name": "Week", "code": 0 }, { "name": "Month", "code": 1 }, { "name": "Year", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "B1", "type": "esriFieldTypeString", "alias": "B1", "length": 3000, "domain": null }, { "name": "B2", "type": "esriFieldTypeString", "alias": "B2", "length": 3000, "domain": null }, { "name": "B3", "type": "esriFieldTypeSmallInteger", "alias": "B3", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "B4", "type": "esriFieldTypeString", "alias": "B4", "length": 250, "domain": null }, { "name": "B5", "type": "esriFieldTypeString", "alias": "B5", "length": 250, "domain": null }, { "name": "B6", "type": "esriFieldTypeSmallInteger", "alias": "B6", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "B7", "type": "esriFieldTypeString", "alias": "B7", "length": 3000, "domain": null }, { "name": "B8", "type": "esriFieldTypeSmallInteger", "alias": "B8", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "B9", "type": "esriFieldTypeSmallInteger", "alias": "B9", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "II1", "type": "esriFieldTypeString", "alias": "II1", "length": 500, "domain": null }, { "name": "II2", "type": "esriFieldTypeString", "alias": "II2", "length": 250, "domain": null }, { "name": "III1", "type": "esriFieldTypeString", "alias": "III1", "length": 250, "domain": null }, { "name": "III2", "type": "esriFieldTypeString", "alias": "III2", "length": 3000, "domain": null }, { "name": "III3", "type": "esriFieldTypeString", "alias": "III3", "length": 3000, "domain": null }, { "name": "III4", "type": "esriFieldTypeString", "alias": "III4", "length": 3000, "domain": null }, { "name": "III5", "type": "esriFieldTypeString", "alias": "III5", "length": 3000, "domain": null }, { "name": "III6", "type": "esriFieldTypeString", "alias": "III6", "length": 3000, "domain": null }, { "name": "III7", "type": "esriFieldTypeString", "alias": "III7", "length": 3000, "domain": null }, { "name": "III8", "type": "esriFieldTypeString", "alias": "III8", "length": 3000, "domain": null }, { "name": "III9", "type": "esriFieldTypeString", "alias": "III9", "length": 3000, "domain": null }, { "name": "III10", "type": "esriFieldTypeString", "alias": "III10", "length": 3000, "domain": null }, { "name": "III11", "type": "esriFieldTypeSmallInteger", "alias": "III11", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "III12", "type": "esriFieldTypeString", "alias": "III12", "length": 3000, "domain": null }, { "name": "III13", "type": "esriFieldTypeSmallInteger", "alias": "III13", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "III14", "type": "esriFieldTypeString", "alias": "III14", "length": 3000, "domain": null }, { "name": "III15", "type": "esriFieldTypeSmallInteger", "alias": "III15", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "III16", "type": "esriFieldTypeString", "alias": "III16", "length": 3000, "domain": null }, { "name": "III17", "type": "esriFieldTypeSmallInteger", "alias": "III17", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "III18", "type": "esriFieldTypeString", "alias": "III18", "length": 3000, "domain": null }, { "name": "III19", "type": "esriFieldTypeSmallInteger", "alias": "III19", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "III20", "type": "esriFieldTypeString", "alias": "III20", "length": 3000, "domain": null }, { "name": "III21", "type": "esriFieldTypeSmallInteger", "alias": "III21", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "III22", "type": "esriFieldTypeString", "alias": "III22", "length": 3000, "domain": null }, { "name": "III23", "type": "esriFieldTypeSmallInteger", "alias": "III23", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "III24", "type": "esriFieldTypeString", "alias": "III24", "length": 3000, "domain": null }, { "name": "SRTSFApprovedBy", "type": "esriFieldTypeString", "alias": "SRTSApprovedBy", "length": 250, "domain": null }, { "name": "SRTSFDateApproved", "type": "esriFieldTypeDate", "alias": "SRTSFDateApproved", "length": 8, "domain": null }, { "name": "projDesc", "type": "esriFieldTypeString", "alias": "projDesc", "length": 3000, "domain": null }, { "name": "projObj", "type": "esriFieldTypeString", "alias": "projObj", "length": 500, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "length": 3000, "domain": null }, { "name": "routeList", "type": "esriFieldTypeString", "alias": "routeList", "length": 1073741822, "domain": null } ], "indexes": [ { "name": "R186_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I227ProjectID", "fields": "ProjectID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "3c4f0f7daec04b25a89fdd7972695b62" }