{ "currentVersion": 10.6, "id": 6, "name": "CO_Share.DBO.SignWork_1", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "WorkType", "typeIdField": null, "subtypeFieldName": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "WorkType", "type": "esriFieldTypeString", "alias": "Work Type", "length": 50, "domain": { "type": "codedValue", "name": "WS2_WorkType", "description": "Work Type", "codedValues": [ { "name": "Install Sign", "code": "Install" }, { "name": "Replace Sign", "code": "Replace" }, { "name": "Remove Sign", "code": "Remove" }, { "name": "Move Sign", "code": "Move" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspect_da", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "CompletionDate", "type": "esriFieldTypeDate", "alias": "Completion Date", "length": 8, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 150, "domain": null }, { "name": "txtImageNa", "type": "esriFieldTypeString", "alias": "Picture", "length": 125, "domain": null }, { "name": "Route_num", "type": "esriFieldTypeString", "alias": "Route #", "length": 254, "domain": null }, { "name": "Descriptio", "type": "esriFieldTypeString", "alias": "Description", "length": 254, "domain": null }, { "name": "Sign_code", "type": "esriFieldTypeString", "alias": "Sign Code", "length": 254, "domain": null }, { "name": "Height", "type": "esriFieldTypeDouble", "alias": "Height", "domain": null }, { "name": "Width", "type": "esriFieldTypeDouble", "alias": "Width", "domain": null }, { "name": "Sign_statu", "type": "esriFieldTypeString", "alias": "Sign Status", "length": 254, "domain": { "type": "codedValue", "name": "WS2_Status", "description": "Sign Status", "codedValues": [ { "name": "Warehouse", "code": "Warehouse" }, { "name": "On Truck", "code": "On Truck" }, { "name": "Trashed", "code": "Trashed" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Log_point", "type": "esriFieldTypeDouble", "alias": "Log Point", "domain": null }, { "name": "Side_of_ro", "type": "esriFieldTypeString", "alias": "Side of Road", "length": 254, "domain": { "type": "codedValue", "name": "WS2_Side", "description": "Side", "codedValues": [ { "name": "Left", "code": "L" }, { "name": "Right", "code": "R" }, { "name": "Ahead", "code": "A" }, { "name": "Behind", "code": "B" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Symbol_rot", "type": "esriFieldTypeString", "alias": "Sign Faces", "length": 254, "domain": { "type": "codedValue", "name": "WS2_Direction", "description": "Direction", "codedValues": [ { "name": "North", "code": "N" }, { "name": "South", "code": "S" }, { "name": "East", "code": "E" }, { "name": "West", "code": "W" }, { "name": "Northeast", "code": "NE" }, { "name": "Northwest", "code": "NW" }, { "name": "Southeast", "code": "SE" }, { "name": "Southwest", "code": "SW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Offset", "type": "esriFieldTypeDouble", "alias": "Offset", "domain": null }, { "name": "Sign_numb", "type": "esriFieldTypeString", "alias": "New Sign #", "length": 50, "domain": null }, { "name": "Sign_num", "type": "esriFieldTypeString", "alias": "Old Sign #", "length": 50, "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route Name", "length": 50, "domain": null }, { "name": "Work_reason", "type": "esriFieldTypeString", "alias": "Work Reason", "length": 50, "domain": { "type": "codedValue", "name": "WS2_WorkReason", "description": "Work Reason", "codedValues": [ { "name": "Accident", "code": "Accident" }, { "name": "Routine Manitenance", "code": "Routine" }, { "name": "Vandalism", "code": "Vandalism" }, { "name": "Weather", "code": "Weather" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "X", "type": "esriFieldTypeDouble", "alias": "GPS X", "domain": null }, { "name": "Y", "type": "esriFieldTypeDouble", "alias": "GPS Y", "domain": null }, { "name": "SignID", "type": "esriFieldTypeInteger", "alias": "SignID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R283_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2169_SignID", "fields": "SignID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_283", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_283", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "CO_Share.DBO.Signs_1", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SignID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }