{ "layers": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 0, "name": "SignPoles", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "

This is a dataset of all sign poles in the City of Sheboygan. This dataset was created to be a base for the tables related to signs. This dataset is continually being updated, and should be considered current and accurate. This dataset is considered the authoritative source for all sign poles in the City of Sheboygan.<\/SPAN><\/P>

For additional information, please contact andrew.bartell@sheboyganwi.gov<\/SPAN><\/SPAN><\/P><\/DIV>", "copyrightText": "City of Sheboygan, Engineering Department", "editFieldsInfo": { "creationDateField": "CreateDate", "creatorField": "CreateBy", "editDateField": "EditDate", "editorField": "EditBy" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Sign_Pole_WOs", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false }, { "id": 1, "name": "Signs_Table", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "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": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "extent": { "xmin": 139107.27750216052, "ymin": 151947.01154007018, "xmax": 226657.58107574657, "ymax": 206046.12742298841, "spatialReference": { "wkid": 103458, "latestWkid": 103458, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -18187000, "falseY": -48539200, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 103458, "latestWkid": 103458, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -18187000, "falseY": -48539200, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "46abbcf9578f700d676c13e9ae355e9b", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAcAAAAHCAYAAADEUlfTAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAs0lEQVQImU3Ouw7BYABA4aP+uCVt4pqGwSBhr8XlAQwMEolJ4gFMHsPuGQw8QWMwEVNnXkAk1KWSdtD+DER861mO4EMHWgoYEiQwBhCAHgmFpr10pttUtfDm4TC3z23/9SoLoDXI5mojPR8GqKsatu+XzNt1KBQwitFYgT8NVVOWt6shJBz2nksnmfrFnecGEiwBTBYXuwr0KvGEsnbuwcq5bwFTADyl7M/Op+H31gJM4PgGLyA5MHzX1fsAAAAASUVORK5CYII=", "contentType": "image/png", "width": 5, "height": 5, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "HeightApprox", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "HeightApprox", "type": "esriFieldTypeDouble", "alias": "Approximate Pole Height", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HeightApprox" }, { "name": "HeightMeasure", "type": "esriFieldTypeDouble", "alias": "Measured Pole Height", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HeightMeasure" }, { "name": "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": "Condition" }, { "name": "EditBy", "type": "esriFieldTypeString", "alias": "EditBy", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EditBy" }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EditDate" }, { "name": "CreateBy", "type": "esriFieldTypeString", "alias": "CreateBy", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CreateBy" }, { "name": "CreateDate", "type": "esriFieldTypeDate", "alias": "CreateDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CreateDate" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Pole Address", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Address" }, { "name": "PoleLocation", "type": "esriFieldTypeString", "alias": "Pole Location", "domain": { "type": "codedValue", "name": "Signs_Location", "description": "Sign Location", "codedValues": [ { "name": "MED", "code": "MED" }, { "name": "NW Corner", "code": "NW Corner" }, { "name": "NE Corner", "code": "NE Corner" }, { "name": "SE Corner", "code": "SE Corner" }, { "name": "SW Corner", "code": "SW Corner" }, { "name": "Island", "code": "Island" }, { "name": "Mid Block", "code": "Mid Block" }, { "name": "Rotary", "code": "Rotary" }, { "name": "End", "code": "End" }, { "name": "Alley", "code": "Alley" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PoleLocation" }, { "name": "MountedOn", "type": "esriFieldTypeString", "alias": "Pole (Mounted On)", "domain": { "type": "codedValue", "name": "Signs_MountedOn", "description": "", "codedValues": [ { "name": "Square M Post", "code": "Square M Post" }, { "name": "Wood Post", "code": "Wood Post" }, { "name": "Channel Post", "code": "Channel Post" }, { "name": "Mast Arm", "code": "Mast Arm" }, { "name": "Guard Rail", "code": "Guard Rail" }, { "name": "Pipe", "code": "Pipe" }, { "name": "Power Pole", "code": "Power Pole" }, { "name": "Flash Beacon", "code": "Flash Beacon" }, { "name": "Structure", "code": "Structure" }, { "name": "Light Pole", "code": "Light Pole" }, { "name": "Signal Pole", "code": "Signal Pole" }, { "name": "Flag Pole", "code": "Flag Pole" }, { "name": "Tree", "code": "Tree" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MountedOn" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SIGNS", "type": "esriFieldTypeInteger", "alias": "Number of signs on pole", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SIGNS" }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "POINT_X", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Longitude" }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "POINT_Y", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Latitude" }, { "name": "CountAttachment", "type": "esriFieldTypeInteger", "alias": "Number of Attachments", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CountAttachment" }, { "name": "CountRelatedFeature", "type": "esriFieldTypeInteger", "alias": "Number of related features", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CountRelatedFeature" }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "Installation Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallationDate" }, { "name": "ReplacementDate", "type": "esriFieldTypeDate", "alias": "ReplacementDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ReplacementDate" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "UUID_353", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_353", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S289_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "SignPoles", "description": "", "prototype": { "attributes": { "InstallationDate": null, "HeightApprox": null, "HeightMeasure": null, "Condition": null, "CountAttachment": null, "Latitude": null, "Longitude": null, "SIGNS": null, "ReplacementDate": null, "Address": null, "PoleLocation": null, "MountedOn": null, "CountRelatedFeature": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "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": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "71b833423c4948e7b3092f6dc1195e0e" } ], "tables": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 2, "name": "Sign Pole Work Orders", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CreateDate", "creatorField": "CreateBy", "editDateField": "EditDate", "editorField": "EditBy" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "CityOfSheboygan.OWNER.Signs_Table", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID_Sign", "composite": false }, { "id": 0, "name": "SignPoles", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID_Pole", "composite": false } ], "isDataVersioned": false, "isDataArchived": true, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "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": "SignOrder", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "WorkPerformed", "type": "esriFieldTypeString", "alias": "Work Performed", "domain": { "type": "codedValue", "name": "Signs_WorkPerformed", "description": "Signs Work Performed", "codedValues": [ { "name": "Replace Sign and Post", "code": "Replace Sign and Post" }, { "name": "Breakaway and Post", "code": "Breakaway and Post" }, { "name": "Sign", "code": "Sign" }, { "name": "Reattach Sign", "code": "Reattach Sign" }, { "name": "Breakaway Post and Sign", "code": "Breakaway Post an Sign" }, { "name": "Sign and Post", "code": "Sign and Post" }, { "name": "Replace Post", "code": "Replace Post" }, { "name": "Relocate", "code": "Relocate" }, { "name": "Replace Sign", "code": "Replace Sign" }, { "name": "Breakaway", "code": "Breakaway" }, { "name": "Relocate and Replace Sign", "code": "Relocate and Replace Sign" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WorkPerformed" }, { "name": "DamageType", "type": "esriFieldTypeString", "alias": "Damage Type", "domain": { "type": "codedValue", "name": "Signs_DamageType", "description": "Signs Damage Type", "codedValues": [ { "name": "Vehicle Accident", "code": "Vehicle Accident" }, { "name": "Vandalism", "code": "Vandalism" }, { "name": "Faded/Rusted", "code": "Faded/Rusted" }, { "name": "Storm Damage", "code": "Storm Damage" }, { "name": "Construction", "code": "Construction" }, { "name": "Visual Probe", "code": "Visual Probe" }, { "name": "Relocate", "code": "Relocate" }, { "name": "Code/Color Change", "code": "Code/Color Change" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DamageType" }, { "name": "CostPost", "type": "esriFieldTypeString", "alias": "Post Cost", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CostPost" }, { "name": "CostSign", "type": "esriFieldTypeString", "alias": "Sign Cost", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CostSign" }, { "name": "WO_Comments", "type": "esriFieldTypeString", "alias": "Work Order Comments", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "WO_Comments" }, { "name": "CreateBy", "type": "esriFieldTypeString", "alias": "CreateBy", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CreateBy" }, { "name": "CreateDate", "type": "esriFieldTypeDate", "alias": "CreateDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CreateDate" }, { "name": "EditBy", "type": "esriFieldTypeString", "alias": "EditBy", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EditBy" }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "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": "AssignmentType", "type": "esriFieldTypeString", "alias": "AssignmentT ype", "domain": { "type": "codedValue", "name": "Signs_AssignmentType", "description": "Signs Assignment Type", "codedValues": [ { "name": "General Ordinance", "code": "General Ordinance" }, { "name": "Engineering Judgement", "code": "Engineering Judgement" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AssignmentType" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetType", "type": "esriFieldTypeString", "alias": "Asset Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetType" }, { "name": "WorkDate", "type": "esriFieldTypeString", "alias": "Work Order Date", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WorkDate" }, { "name": "GUID_Sign", "type": "esriFieldTypeGUID", "alias": "GUID_Sign", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GUID_Sign" } ], "indexes": [ { "name": "UUID_356", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_3672_GUID_Po", "fields": "GUID_Pole", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_356", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_3672_GUID_Si", "fields": "GUID_Sign", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Sign Pole Work Orders", "description": "", "prototype": { "attributes": { "WorkDate": null, "WorkPerformed": null, "DamageType": null, "CostPost": null, "CostSign": null, "WO_Comments": null, "AssetType": null, "AssignmentType": null, "GUID_Pole": null, "GUID_Sign": 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" }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 3, "name": "SignCodeTable2023", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 3, "name": "CityOfSheboygan.OWNER.Signs_Table", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "code_text", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID_1", "globalIdField": "GlobalID", "displayField": "code_text", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID_1", "type": "esriFieldTypeOID", "alias": "OBJECTID_1", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID_1" }, { "name": "code_text", "type": "esriFieldTypeInteger", "alias": "code_text", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "code_text" }, { "name": "number_", "type": "esriFieldTypeString", "alias": "number_", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "number_" }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "description" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "created_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" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R461_SDE_ROWID_UK", "fields": "OBJECTID_1", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_6232_code_te", "fields": "code_text", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_461", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "SignCodeTable2023", "description": "", "prototype": { "attributes": { "number_": null, "description": null, "code_text": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "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": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "71b833423c4948e7b3092f6dc1195e0e" }, { "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" } ] }