{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "Signs_Table", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CreatDate", "creatorField": "CreatedBy", "editDateField": "EditDate", "editorField": "EditBy" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "CityOfSheboygan.OWNER.Sign_Pole_WOs", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false }, { "id": 1, "name": "SignPoles", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID_Pole", "composite": false }, { "id": 3, "name": "CityOfSheboygan.OWNER.SignCodeTable2023", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "SignCode_Int", "composite": false } ], "isDataVersioned": false, "isDataArchived": true, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1595446289000 }, "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 }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "A_SignCode", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "A_SignCode", "type": "esriFieldTypeString", "alias": "Sign Code", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "A_SignCode" }, { "name": "A_Surface", "type": "esriFieldTypeString", "alias": "Surface", "domain": { "type": "codedValue", "name": "Signs_Surface", "description": "Sign Surface", "codedValues": [ { "name": "Reflective", "code": "Reflective" }, { "name": "Nonreflective", "code": "Nonreflective" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "A_Surface" }, { "name": "A_Shape", "type": "esriFieldTypeString", "alias": "Shape", "domain": { "type": "codedValue", "name": "Signs_Shape", "description": "Sign Shape", "codedValues": [ { "name": "Xbar", "code": "Xbar" }, { "name": "Shield", "code": "Shield" }, { "name": "Octagon", "code": "Octagon" }, { "name": "Vertical Rectangle", "code": "Vertial Rectangle" }, { "name": "Triangle", "code": "Triangle" }, { "name": "Horizontal Rectangle", "code": "Horizontal Rectangle" }, { "name": "Diagonal", "code": "Diagonal" }, { "name": "Square", "code": "Square" }, { "name": "Pentagon", "code": "Pentagon" }, { "name": "Circle", "code": "Circle" }, { "name": "Tombstone", "code": "Tombstone" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "A_Shape" }, { "name": "A_Color", "type": "esriFieldTypeString", "alias": "Color", "domain": { "type": "codedValue", "name": "Signs_Color", "description": "Sign Color", "codedValues": [ { "name": "Black on White", "code": "Black on White" }, { "name": "Black on Yellow", "code": "Black on Yellow" }, { "name": "White on Red", "code": "White on Red" }, { "name": "White on Green", "code": "White on Green" }, { "name": "White on Black", "code": "White on Black" }, { "name": "Green on White", "code": "Green on White" }, { "name": "Yellow", "code": "Yellow" }, { "name": "Red/Yellow/White", "code": "Red/Yellow/White" }, { "name": "Red on White", "code": "Red on White" }, { "name": "Red", "code": "Red" }, { "name": "Black on Neon Yellow", "code": "Black on Neon Yellow" }, { "name": "Red/Black/White", "code": "Red/Black/White" }, { "name": "Red on Yellow", "code": "Red on Yellow" }, { "name": "White on Brown", "code": "White on Brown" }, { "name": "White and Blue", "code": "White and Blue" }, { "name": "Miscellaneous", "code": "Miscellaneous" }, { "name": "Blue", "code": "Blue" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "A_Color" }, { "name": "A_Dimension1", "type": "esriFieldTypeDouble", "alias": "Dimension 1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "A_Dimension1" }, { "name": "A_Dimension2", "type": "esriFieldTypeDouble", "alias": "Dimension 1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "A_Dimension2" }, { "name": "A_Dimension3", "type": "esriFieldTypeDouble", "alias": "Dimension 3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "A_Dimension3" }, { "name": "A_Material", "type": "esriFieldTypeString", "alias": "Material", "domain": { "type": "codedValue", "name": "Signs_Material", "description": "Sign Material", "codedValues": [ { "name": ".080 Aluminum", "code": ".080 Aluminum" }, { "name": "Wood", "code": "Wood" }, { "name": ".063 Aluminum", "code": ".063 Aluminum" }, { "name": ".100 Aluminum", "code": ".100 Aluminum" }, { "name": "FL Steel", "code": "FL Steel" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "A_Material" }, { "name": "A_AnchorFacing", "type": "esriFieldTypeString", "alias": "Anchor Facing", "domain": { "type": "codedValue", "name": "Sign_AnchorFacing", "description": "Sign Anchor Facing ", "codedValues": [ { "name": "Facing", "code": "Facing" }, { "name": "Opposing", "code": "Opposing" }, { "name": "Parallel", "code": "Parallel" }, { "name": "Oblique", "code": "Oblique" }, { "name": "Parallel Opposing", "code": "Parallel Opposing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "A_AnchorFacing" }, { "name": "A_OrdinanceNumber", "type": "esriFieldTypeString", "alias": "Ordinance Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "A_OrdinanceNumber" }, { "name": "A_Responsibility", "type": "esriFieldTypeString", "alias": "Responsibility", "domain": { "type": "codedValue", "name": "Signs_Responsibility", "description": "Signs Responsibility", "codedValues": [ { "name": "City", "code": "City" }, { "name": "Transit", "code": "Transit" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "A_Responsibility" }, { "name": "B_Destinations", "type": "esriFieldTypeString", "alias": "Destinations", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "B_Destinations" }, { "name": "B_Condition", "type": "esriFieldTypeString", "alias": "Condition", "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "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" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "B_Condition" }, { "name": "B_SignComments", "type": "esriFieldTypeString", "alias": "Sign Comments", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "B_SignComments" }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "Created By", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CreatedBy" }, { "name": "CreatDate", "type": "esriFieldTypeDate", "alias": "Creat Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CreatDate" }, { "name": "EditBy", "type": "esriFieldTypeString", "alias": "EditBy", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EditBy" }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "Edit Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EditDate" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "GUID_Pole", "type": "esriFieldTypeGUID", "alias": "GUID_Pole", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GUID_Pole" }, { "name": "Wayfinding", "type": "esriFieldTypeString", "alias": "Wayfinding Sign?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Wayfinding" }, { "name": "SignOrderFromTop", "type": "esriFieldTypeString", "alias": "Sign Order(from top)", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SignOrderFromTop" }, { "name": "AnchorType", "type": "esriFieldTypeString", "alias": "AnchorType", "domain": { "type": "codedValue", "name": "Sign_AnchorType", "description": "Sign Anchor Type", "codedValues": [ { "name": "Ground", "code": "Ground" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Collar", "code": "Collar" }, { "name": "Clamp", "code": "Clamp" }, { "name": "Band", "code": "Band" }, { "name": "Bracket", "code": "Bracket" }, { "name": "Breakaway", "code": "Breakaway" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AnchorType" }, { "name": "SignDescription", "type": "esriFieldTypeString", "alias": "Sign Description", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "SignDescription" }, { "name": "Original_Install", "type": "esriFieldTypeDate", "alias": "Original Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Original_Install" }, { "name": "DateReplaced", "type": "esriFieldTypeDate", "alias": "Date Replaced", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateReplaced" }, { "name": "MUTCD", "type": "esriFieldTypeString", "alias": "MUTCD Code", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MUTCD" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "POINT_X", "type": "esriFieldTypeDouble", "alias": "POINT_X", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POINT_X" }, { "name": "POINT_Y", "type": "esriFieldTypeDouble", "alias": "POINT_Y", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POINT_Y" }, { "name": "SignCode_Int", "type": "esriFieldTypeInteger", "alias": "Sign Code Integer", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SignCode_Int" }, { "name": "Man_SignDescript", "type": "esriFieldTypeString", "alias": "Manual Sign Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Man_SignDescript" }, { "name": "URL", "type": "esriFieldTypeString", "alias": "URL", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "URL" }, { "name": "SignCode", "type": "esriFieldTypeInteger", "alias": "Enter Sign Code", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SignCode" } ], "indexes": [ { "name": "UUID_354", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_3667_GUID_Po", "fields": "GUID_Pole", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_354", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_3667_SignCod", "fields": "SignCode_Int", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Signs_Table", "description": "", "prototype": { "attributes": { "URL": null, "A_SignCode": null, "A_Surface": null, "A_Shape": null, "A_Color": null, "A_Dimension1": null, "A_Dimension2": null, "A_Dimension3": null, "A_Material": null, "A_AnchorFacing": null, "A_OrdinanceNumber": null, "A_Responsibility": null, "B_Destinations": null, "B_Condition": null, "B_SignComments": null, "SignCode_Int": null, "POINT_Y": null, "POINT_X": null, "Man_SignDescript": null, "SignCode": null, "GUID_Pole": null, "Wayfinding": null, "SignOrderFromTop": null, "AnchorType": null, "SignDescription": null, "Original_Install": null, "DateReplaced": null, "MUTCD": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "71b833423c4948e7b3092f6dc1195e0e" }