{ "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 } ], "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 } ], "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 } ], "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" } ] }