{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "MUTCD_Look_Up", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "ID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ID", "type": "esriFieldTypeDouble", "alias": "ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ID" }, { "name": "SIGN_CLASS", "type": "esriFieldTypeString", "alias": "SIGN_CLASS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SIGN_CLASS" }, { "name": "SIGN_TYPE", "type": "esriFieldTypeString", "alias": "SIGN_TYPE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SIGN_TYPE" }, { "name": "MUTCD", "type": "esriFieldTypeString", "alias": "MUTCD", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MUTCD" }, { "name": "SIGN_SHAPE", "type": "esriFieldTypeString", "alias": "SIGN_SHAPE", "domain": { "type": "codedValue", "name": "Sign_Shapes", "description": "Sign Shapes", "codedValues": [ { "name": "Round", "code": "Round" }, { "name": "Square", "code": "Square" }, { "name": "Rectangle", "code": "Rectangle" }, { "name": "Triangle", "code": "Triangle" }, { "name": "Diamond", "code": "Diamond" }, { "name": "Octagon", "code": "Octagon" }, { "name": "Pentagon", "code": "Pentagon" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SIGN_SHAPE" }, { "name": "SIGN_SIZE", "type": "esriFieldTypeString", "alias": "SIGN_SIZE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SIGN_SIZE" }, { "name": "SIGN_COLOR", "type": "esriFieldTypeString", "alias": "SIGN_COLOR", "domain": { "type": "codedValue", "name": "Sign_Color", "description": "Color of signs", "codedValues": [ { "name": "Black on Fluorescent Pink", "code": "Black on Fluorescent Pink" }, { "name": "Black on Fluorescent Yellow-Green", "code": "Black on Fluorescent Yellow-Green" }, { "name": "Black on Orange", "code": "Black on Orange" }, { "name": "Black on Red", "code": "Black on Red" }, { "name": "Black on White", "code": "Black on White" }, { "name": "Black on Yellow", "code": "Black on Yellow" }, { "name": "Green on White", "code": "Green on White" }, { "name": "Red on Black", "code": "Red on Black" }, { "name": "Red on White", "code": "Red on White" }, { "name": "White on Black", "code": "White on Black" }, { "name": "White on Blue", "code": "White on Blue" }, { "name": "White on Brown", "code": "White on Brown" }, { "name": "White on Green", "code": "White on Green" }, { "name": "White on Red", "code": "White on Red" }, { "name": "Yellow on Black", "code": "Yellow on Black" }, { "name": "Yellow on Blue", "code": "Yellow on Blue" }, { "name": "Other", "code": "Other" }, { "name": "Black and Red On White", "code": "Black and Red on White" }, { "name": "White on Red and Blue", "code": "White on Red and Blue" }, { "name": "Green and Black on White", "code": "Green and Black on White" }, { "name": "Custom", "code": "Custom" }, { "name": "Red and Black and White on Fluorescent Green", "code": "Red and Black and White on Fluorescent Green" }, { "name": "Red and Black and White on Fluorescent Yello", "code": "Red and Black and White on Fluorescent Yellow" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SIGN_COLOR" }, { "name": "RETRO_CLR_1", "type": "esriFieldTypeString", "alias": "RETRO_CLR_1", "domain": { "type": "codedValue", "name": "Sign_Individual_Colors", "description": "Sign Individual Colors", "codedValues": [ { "name": "White", "code": "White" }, { "name": "Black", "code": "Black" }, { "name": "Blue", "code": "Blue" }, { "name": "Brown", "code": "Brown" }, { "name": "Green", "code": "Green" }, { "name": "Orange", "code": "Orange" }, { "name": "Purple", "code": "Purple" }, { "name": "Red", "code": "Red" }, { "name": "Yellow", "code": "Yellow" }, { "name": "Fluorescent Yellow Green", "code": "Fluorescent Yellow Green" }, { "name": "Fluorescent Pink", "code": "Fluorescent Pink" }, { "name": "Fluorescent Yellow", "code": "Fluorescent Yellow" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "RETRO_CLR_1" }, { "name": "RETRO_CLR_2", "type": "esriFieldTypeString", "alias": "RETRO_CLR_2", "domain": { "type": "codedValue", "name": "Sign_Individual_Colors", "description": "Sign Individual Colors", "codedValues": [ { "name": "White", "code": "White" }, { "name": "Black", "code": "Black" }, { "name": "Blue", "code": "Blue" }, { "name": "Brown", "code": "Brown" }, { "name": "Green", "code": "Green" }, { "name": "Orange", "code": "Orange" }, { "name": "Purple", "code": "Purple" }, { "name": "Red", "code": "Red" }, { "name": "Yellow", "code": "Yellow" }, { "name": "Fluorescent Yellow Green", "code": "Fluorescent Yellow Green" }, { "name": "Fluorescent Pink", "code": "Fluorescent Pink" }, { "name": "Fluorescent Yellow", "code": "Fluorescent Yellow" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "RETRO_CLR_2" }, { "name": "RETRO_CLR_3", "type": "esriFieldTypeString", "alias": "RETRO_CLR_3", "domain": { "type": "codedValue", "name": "Sign_Individual_Colors", "description": "Sign Individual Colors", "codedValues": [ { "name": "White", "code": "White" }, { "name": "Black", "code": "Black" }, { "name": "Blue", "code": "Blue" }, { "name": "Brown", "code": "Brown" }, { "name": "Green", "code": "Green" }, { "name": "Orange", "code": "Orange" }, { "name": "Purple", "code": "Purple" }, { "name": "Red", "code": "Red" }, { "name": "Yellow", "code": "Yellow" }, { "name": "Fluorescent Yellow Green", "code": "Fluorescent Yellow Green" }, { "name": "Fluorescent Pink", "code": "Fluorescent Pink" }, { "name": "Fluorescent Yellow", "code": "Fluorescent Yellow" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "RETRO_CLR_3" }, { "name": "SHEET_TYP", "type": "esriFieldTypeString", "alias": "SHEET_TYP", "domain": { "type": "codedValue", "name": "Sheeting_Type", "description": "Type of sign facing", "codedValues": [ { "name": "Beaded", "code": "Beaded" }, { "name": "Prismatic", "code": "Prismatic" }, { "name": "Beaded (Type I - Eng. Grade)", "code": "Beaded (Type I - Eng. Grade)" }, { "name": "Beaded (Type II - Super Eng. Grade)", "code": "Beaded (Type II - Super Eng. Grade)" }, { "name": "Beaded (Type III - High Intensity)", "code": "Beaded (Type III - High Intensity)" }, { "name": "Prismatic (Type III)", "code": "Prismatic (Type III)" }, { "name": "Prismatic (Type IV)", "code": "Prismatic (Type IV)" }, { "name": "Prismatic (Type V)", "code": "Prismatic (Type V)" }, { "name": "Prismatic (Type VI)", "code": "Prismatic (Type VI)" }, { "name": "Prismatic (Type VII)", "code": "Prismatic (Type VII)" }, { "name": "Prismatic (Type VIII)", "code": "Prismatic (Type VIII)" }, { "name": "Prismatic (Type IX)", "code": "Prismatic (Type IX)" }, { "name": "Prismatic (Type X)", "code": "Prismatic (Type X)" }, { "name": "3M Diamond Grade DG3", "code": "3M Diamond Grade DG3" }, { "name": "Avery Dennison Omniview", "code": "Avery Dennison Omniview" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SHEET_TYP" }, { "name": "IN_TOSA", "type": "esriFieldTypeString", "alias": "IN_TOSA", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "IN_TOSA" }, { "name": "COMM", "type": "esriFieldTypeString", "alias": "COMM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "COMM" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R53_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_53", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MUTCD_Look_Up", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 5000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 5000, "maxRecordCountFactor": 1 }