{ "layers": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 0, "name": "SignPoles", "type": "Feature Layer", "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>", "geometryType": "esriGeometryPoint", "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 }, "copyrightText": "City of Sheboygan, Engineering Department", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "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 }, "defaultVisibility": 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 } }, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "HeightApprox", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "HeightApprox", "type": "esriFieldTypeDouble", "alias": "Approximate Pole Height", "domain": null }, { "name": "HeightMeasure", "type": "esriFieldTypeDouble", "alias": "Measured Pole Height", "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 50, "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" } }, { "name": "EditBy", "type": "esriFieldTypeString", "alias": "EditBy", "length": 50, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "CreateBy", "type": "esriFieldTypeString", "alias": "CreateBy", "length": 50, "domain": null }, { "name": "CreateDate", "type": "esriFieldTypeDate", "alias": "CreateDate", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Pole Address", "length": 100, "domain": null }, { "name": "PoleLocation", "type": "esriFieldTypeString", "alias": "Pole Location", "length": 50, "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" } }, { "name": "MountedOn", "type": "esriFieldTypeString", "alias": "Pole (Mounted On)", "length": 50, "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" } }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SIGNS", "type": "esriFieldTypeInteger", "alias": "Number of signs on pole", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "POINT_X", "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "POINT_Y", "domain": null }, { "name": "CountAttachment", "type": "esriFieldTypeInteger", "alias": "Number of Attachments", "domain": null }, { "name": "CountRelatedFeature", "type": "esriFieldTypeInteger", "alias": "Number of related features", "domain": null }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "Installation Date", "length": 8, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeDate", "alias": "ReplacementDate", "length": 8, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Pole Status", "length": 255, "domain": { "type": "codedValue", "name": "Status", "description": "Status of item ", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Future", "code": "Future" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "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": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Sign_Pole_WOs", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "Signs_Table", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1595446289000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "f0438499ad8f4b72a421e851145a5a05" } ], "tables": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 2, "name": "Sign Pole Work Orders", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SignOrder", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "WorkPerformed", "type": "esriFieldTypeString", "alias": "Work Performed", "length": 50, "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" } }, { "name": "DamageType", "type": "esriFieldTypeString", "alias": "Damage Type", "length": 50, "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" } }, { "name": "CostPost", "type": "esriFieldTypeString", "alias": "Post Cost", "length": 50, "domain": null }, { "name": "CostSign", "type": "esriFieldTypeString", "alias": "Sign Cost", "length": 50, "domain": null }, { "name": "WO_Comments", "type": "esriFieldTypeString", "alias": "Work Order Comments", "length": 300, "domain": null }, { "name": "CreateBy", "type": "esriFieldTypeString", "alias": "CreateBy", "length": 50, "domain": null }, { "name": "CreateDate", "type": "esriFieldTypeDate", "alias": "CreateDate", "length": 8, "domain": null }, { "name": "EditBy", "type": "esriFieldTypeString", "alias": "EditBy", "length": 50, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "GUID_Pole", "type": "esriFieldTypeGUID", "alias": "GUID_Pole", "length": 38, "domain": null }, { "name": "AssignmentType", "type": "esriFieldTypeString", "alias": "AssignmentT ype", "length": 50, "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" } }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetType", "type": "esriFieldTypeString", "alias": "Asset Type", "length": 255, "domain": null }, { "name": "WorkDate", "type": "esriFieldTypeString", "alias": "Work Order Date", "length": 255, "domain": null }, { "name": "GUID_Sign", "type": "esriFieldTypeGUID", "alias": "GUID_Sign", "length": 38, "domain": null } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "CityOfSheboygan.OWNER.Signs_Table", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GUID_Sign", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 0, "name": "SignPoles", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GUID_Pole", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,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 }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1595446289000 }, "serviceItemId": "f0438499ad8f4b72a421e851145a5a05" }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 3, "name": "SignCodeTable2023", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "code_text", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID_1", "type": "esriFieldTypeOID", "alias": "OBJECTID_1", "domain": null }, { "name": "code_text", "type": "esriFieldTypeInteger", "alias": "code_text", "domain": null }, { "name": "number_", "type": "esriFieldTypeString", "alias": "number_", "length": 1073741822, "domain": null }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "length": 1073741822, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 1073741822, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 1073741822, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Class", "type": "esriFieldTypeString", "alias": "Sign Class", "length": 50, "domain": { "type": "codedValue", "name": "SignClass", "description": "Class of signs for sign inventory.", "codedValues": [ { "name": "Warning", "code": "Warning" }, { "name": "Marker", "code": "Marker" }, { "name": "Regulatory", "code": "Regulatory" }, { "name": "Custom Sign", "code": "Custom Sign" }, { "name": "Custom Sign - Regulatory", "code": "Custom Sign - Regulatory" }, { "name": "Destination", "code": "Destination" }, { "name": "Regulatory - Parks", "code": "Regulatory - Parks" }, { "name": "School", "code": "School" }, { "name": "Information", "code": "Information" }, { "name": "Bike & Pedestrian", "code": "Bike & Pedestrian" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Custom", "type": "esriFieldTypeString", "alias": "Custom Sign?", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "TimeLimited", "type": "esriFieldTypeString", "alias": "Type", "length": 255, "domain": { "type": "codedValue", "name": "SignTimeLimiting", "description": "Whether a sign has a time or date limit", "codedValues": [ { "name": "Limited Period", "code": "Limited Period" }, { "name": "2 Hour Limit", "code": "2 Hour Limit" }, { "name": "1 Hour Limit", "code": "1 Hour Limit" }, { "name": "3 Hour Limit", "code": "3 Hour Limit" }, { "name": "15 Minute Limit", "code": "15 Minute Limit" }, { "name": "30 Minute Limit", "code": "30 Minute Limit" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DayLimited", "type": "esriFieldTypeString", "alias": "Day Limited", "length": 255, "domain": { "type": "codedValue", "name": "SignDayLimits", "description": "Signs that are limited to specific days", "codedValues": [ { "name": "Except Holidays", "code": "Except Holidays" }, { "name": "Except Saturdays and Sundays", "code": "Except Saturdays and Sundays" }, { "name": "Except Saturdays, Sunday, and Holidays", "code": "Except Saturday, Sunday, and Holidays" }, { "name": "Except Sunday and Holidays", "code": "Except Sunday and Holidays" }, { "name": "School days only", "code": "School days only" }, { "name": "Week days only", "code": "Week days only" }, { "name": "Seasonal Limit", "code": "Seasonal Limit" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "CityOfSheboygan.OWNER.Signs_Table", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "code_text", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,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 }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "f0438499ad8f4b72a421e851145a5a05" }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "Signs_Table", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "A_SignCode", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "A_SignCode", "type": "esriFieldTypeString", "alias": "Sign Code", "length": 50, "domain": null }, { "name": "A_Surface", "type": "esriFieldTypeString", "alias": "Surface", "length": 50, "domain": { "type": "codedValue", "name": "Signs_Surface", "description": "Sign Surface", "codedValues": [ { "name": "Reflective", "code": "Reflective" }, { "name": "Nonreflective", "code": "Nonreflective" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "A_Shape", "type": "esriFieldTypeString", "alias": "Shape", "length": 50, "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" } }, { "name": "A_Color", "type": "esriFieldTypeString", "alias": "Color", "length": 50, "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" } }, { "name": "A_Dimension1", "type": "esriFieldTypeDouble", "alias": "Dimension 1", "domain": null }, { "name": "A_Dimension2", "type": "esriFieldTypeDouble", "alias": "Dimension 1", "domain": null }, { "name": "A_Dimension3", "type": "esriFieldTypeDouble", "alias": "Dimension 3", "domain": null }, { "name": "A_Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "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" } }, { "name": "A_AnchorFacing", "type": "esriFieldTypeString", "alias": "Anchor Facing", "length": 50, "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" } }, { "name": "A_OrdinanceNumber", "type": "esriFieldTypeString", "alias": "Ordinance Number", "length": 50, "domain": null }, { "name": "A_Responsibility", "type": "esriFieldTypeString", "alias": "Responsibility", "length": 50, "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" } }, { "name": "B_Destinations", "type": "esriFieldTypeString", "alias": "Destinations", "length": 300, "domain": null }, { "name": "B_Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 50, "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" } }, { "name": "B_SignComments", "type": "esriFieldTypeString", "alias": "Sign Comments", "length": 300, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "Created By", "length": 50, "domain": null }, { "name": "CreatDate", "type": "esriFieldTypeDate", "alias": "Creat Date", "length": 8, "domain": null }, { "name": "EditBy", "type": "esriFieldTypeString", "alias": "EditBy", "length": 50, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "Edit Date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "GUID_Pole", "type": "esriFieldTypeGUID", "alias": "GUID_Pole", "length": 38, "domain": null }, { "name": "Wayfinding", "type": "esriFieldTypeString", "alias": "Wayfinding Sign?", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SignOrderFromTop", "type": "esriFieldTypeString", "alias": "Sign Order(from top)", "length": 50, "domain": null }, { "name": "AnchorType", "type": "esriFieldTypeString", "alias": "AnchorType", "length": 50, "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" } }, { "name": "SignDescription", "type": "esriFieldTypeString", "alias": "Sign Description", "length": 200, "domain": null }, { "name": "Original_Install", "type": "esriFieldTypeDate", "alias": "Original Install Date", "length": 8, "domain": null }, { "name": "DateReplaced", "type": "esriFieldTypeDate", "alias": "Date Replaced", "length": 8, "domain": null }, { "name": "MUTCD", "type": "esriFieldTypeString", "alias": "MUTCD Code", "length": 50, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "POINT_X", "type": "esriFieldTypeDouble", "alias": "POINT_X", "domain": null }, { "name": "POINT_Y", "type": "esriFieldTypeDouble", "alias": "POINT_Y", "domain": null }, { "name": "SignCode_Int", "type": "esriFieldTypeInteger", "alias": "Sign Code Integer", "domain": null }, { "name": "Man_SignDescript", "type": "esriFieldTypeString", "alias": "Manual Sign Description", "length": 255, "domain": null }, { "name": "URL", "type": "esriFieldTypeString", "alias": "URL", "length": 500, "domain": null }, { "name": "SignCode", "type": "esriFieldTypeInteger", "alias": "Enter Sign Code", "domain": null }, { "name": "SignClass", "type": "esriFieldTypeString", "alias": "Sign Class", "length": 255, "domain": null }, { "name": "SignTableNotes", "type": "esriFieldTypeString", "alias": "Notes from Sign Code", "length": 255, "domain": null }, { "name": "CustomDesign", "type": "esriFieldTypeString", "alias": "Custom Design?", "length": 255, "domain": null }, { "name": "TimeLimited", "type": "esriFieldTypeString", "alias": "Time Limited", "length": 255, "domain": null }, { "name": "DayLimited", "type": "esriFieldTypeString", "alias": "Day Limited", "length": 255, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": { "type": "codedValue", "name": "Status", "description": "Status of item ", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Future", "code": "Future" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "CityOfSheboygan.OWNER.Sign_Pole_WOs", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "SignPoles", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GUID_Pole", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "CityOfSheboygan.OWNER.SignCodeTable2023", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "SignCode_Int", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,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 }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1595446289000 }, "serviceItemId": "f0438499ad8f4b72a421e851145a5a05" } ] }