Layers:

Layer: SignPoles (0)

Name: SignPoles

Display Field: HeightApprox

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><P STYLE="font-size:16ptmargin:7 0 7 0;"><SPAN>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><P STYLE="font-size:16ptmargin:7 0 7 0;"><SPAN><SPAN>For additional information, please contact andrew.bartell@sheboyganwi.gov</SPAN></SPAN></P></DIV>

Service Item Id: f0438499ad8f4b72a421e851145a5a05

Copyright Text: City of Sheboygan, Engineering Department

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 139107.27750216052
YMin: 151947.01154007018
XMax: 226657.58107574657
YMax: 206046.12742298841
Spatial Reference: 103458  (103458)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• HeightApprox ( type: esriFieldTypeDouble, alias: Approximate Pole Height )
• HeightMeasure ( type: esriFieldTypeDouble, alias: Measured Pole Height )
• Condition ( type: esriFieldTypeString, alias: Condition, length: 50 , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• EditBy ( type: esriFieldTypeString, alias: EditBy, length: 50 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• CreateBy ( type: esriFieldTypeString, alias: CreateBy, length: 50 )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Address ( type: esriFieldTypeString, alias: Pole Address, length: 100 )
• PoleLocation ( type: esriFieldTypeString, alias: Pole Location, length: 50 , Coded Values: [MED: MED] , [NW Corner: NW Corner] , [NE Corner: NE Corner] , ...7 more... )
• MountedOn ( type: esriFieldTypeString, alias: Pole (Mounted On), length: 50 , Coded Values: [Square M Post: Square M Post] , [Wood Post: Wood Post] , [Channel Post: Channel Post] , ...11 more... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SIGNS ( type: esriFieldTypeInteger, alias: Number of signs on pole )
• Longitude ( type: esriFieldTypeDouble, alias: POINT_X )
• Latitude ( type: esriFieldTypeDouble, alias: POINT_Y )
• CountAttachment ( type: esriFieldTypeInteger, alias: Number of Attachments )
• CountRelatedFeature ( type: esriFieldTypeInteger, alias: Number of related features )
• InstallationDate ( type: esriFieldTypeDate, alias: Installation Date, length: 8 )
• ReplacementDate ( type: esriFieldTypeDate, alias: ReplacementDate, length: 8 )
Relationships:
• Sign_Pole_WOs (0) -- Related To: Sign Pole Work Orders (2)
• Signs_Table (1) -- Related To: Signs_Table (1)

Tables:

Table: Sign Pole Work Orders (2)

Name: Sign Pole Work Orders

Display Field: SignOrder

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: f0438499ad8f4b72a421e851145a5a05

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• WorkPerformed ( type: esriFieldTypeString, alias: Work Performed, length: 50 , Coded Values: [Replace Sign and Post: Replace Sign and Post] , [Breakaway and Post: Breakaway and Post] , [Sign: Sign] , ...8 more... )
• DamageType ( type: esriFieldTypeString, alias: Damage Type, length: 50 , Coded Values: [Vehicle Accident: Vehicle Accident] , [Vandalism: Vandalism] , [Faded/Rusted: Faded/Rusted] , ...6 more... )
• CostPost ( type: esriFieldTypeString, alias: Post Cost, length: 50 )
• CostSign ( type: esriFieldTypeString, alias: Sign Cost, length: 50 )
• WO_Comments ( type: esriFieldTypeString, alias: Work Order Comments, length: 300 )
• CreateBy ( type: esriFieldTypeString, alias: CreateBy, length: 50 )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, length: 8 )
• EditBy ( type: esriFieldTypeString, alias: EditBy, length: 50 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• GUID_Pole ( type: esriFieldTypeGUID, alias: GUID_Pole, length: 38 )
• AssignmentType ( type: esriFieldTypeString, alias: AssignmentT ype, length: 50 , Coded Values: [General Ordinance: General Ordinance] , [Engineering Judgement: Engineering Judgement] )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• AssetType ( type: esriFieldTypeString, alias: Asset Type, length: 255 )
• WorkDate ( type: esriFieldTypeString, alias: Work Order Date, length: 255 )
• GUID_Sign ( type: esriFieldTypeGUID, alias: GUID_Sign, length: 38 )
Relationships:
• CityOfSheboygan.OWNER.Signs_Table (2) -- Related To: Signs_Table (1)
• SignPoles (0) -- Related To: SignPoles (0)

Table: SignCodeTable2023 (3)

Name: SignCodeTable2023

Display Field: code_text

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: f0438499ad8f4b72a421e851145a5a05

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID_1 ( type: esriFieldTypeOID, alias: OBJECTID_1 )
• code_text ( type: esriFieldTypeInteger, alias: code_text )
• number_ ( type: esriFieldTypeString, alias: number_, length: 1073741822 )
• description ( type: esriFieldTypeString, alias: description, length: 1073741822 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 1073741822 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 1073741822 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
Relationships:
• CityOfSheboygan.OWNER.Signs_Table (3) -- Related To: Signs_Table (1)

Table: Signs_Table (1)

Name: Signs_Table

Display Field: A_SignCode

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: f0438499ad8f4b72a421e851145a5a05

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• A_SignCode ( type: esriFieldTypeString, alias: Sign Code, length: 50 )
• A_Surface ( type: esriFieldTypeString, alias: Surface, length: 50 , Coded Values: [Reflective: Reflective] , [Nonreflective: Nonreflective] )
• A_Shape ( type: esriFieldTypeString, alias: Shape, length: 50 , Coded Values: [Xbar: Xbar] , [Shield: Shield] , [Octagon: Octagon] , ...8 more... )
• A_Color ( type: esriFieldTypeString, alias: Color, length: 50 , Coded Values: [Black on White: Black on White] , [Black on Yellow: Black on Yellow] , [White on Red: White on Red] , ...14 more... )
• A_Dimension1 ( type: esriFieldTypeDouble, alias: Dimension 1 )
• A_Dimension2 ( type: esriFieldTypeDouble, alias: Dimension 1 )
• A_Dimension3 ( type: esriFieldTypeDouble, alias: Dimension 3 )
• A_Material ( type: esriFieldTypeString, alias: Material, length: 50 , Coded Values: [.080 Aluminum: .080 Aluminum] , [Wood: Wood] , [.063 Aluminum: .063 Aluminum] , ...4 more... )
• A_AnchorFacing ( type: esriFieldTypeString, alias: Anchor Facing, length: 50 , Coded Values: [Facing: Facing] , [Opposing: Opposing] , [Parallel: Parallel] , ...2 more... )
• A_OrdinanceNumber ( type: esriFieldTypeString, alias: Ordinance Number, length: 50 )
• A_Responsibility ( type: esriFieldTypeString, alias: Responsibility, length: 50 , Coded Values: [City: City] , [Transit: Transit] , [Other: Other] )
• B_Destinations ( type: esriFieldTypeString, alias: Destinations, length: 300 )
• B_Condition ( type: esriFieldTypeString, alias: Condition, length: 50 , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• B_SignComments ( type: esriFieldTypeString, alias: Sign Comments, length: 300 )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, length: 50 )
• CreatDate ( type: esriFieldTypeDate, alias: Creat Date, length: 8 )
• EditBy ( type: esriFieldTypeString, alias: EditBy, length: 50 )
• EditDate ( type: esriFieldTypeDate, alias: Edit Date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• GUID_Pole ( type: esriFieldTypeGUID, alias: GUID_Pole, length: 38 )
• Wayfinding ( type: esriFieldTypeString, alias: Wayfinding Sign?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• SignOrderFromTop ( type: esriFieldTypeString, alias: Sign Order(from top), length: 50 )
• AnchorType ( type: esriFieldTypeString, alias: AnchorType, length: 50 , Coded Values: [Ground: Ground] , [Concrete: Concrete] , [Collar: Collar] , ...5 more... )
• SignDescription ( type: esriFieldTypeString, alias: Sign Description, length: 200 )
• Original_Install ( type: esriFieldTypeDate, alias: Original Install Date, length: 8 )
• DateReplaced ( type: esriFieldTypeDate, alias: Date Replaced, length: 8 )
• MUTCD ( type: esriFieldTypeString, alias: MUTCD Code, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y )
• SignCode_Int ( type: esriFieldTypeInteger, alias: Sign Code Integer )
• Man_SignDescript ( type: esriFieldTypeString, alias: Manual Sign Description, length: 255 )
• URL ( type: esriFieldTypeString, alias: URL, length: 500 )
• SignCode ( type: esriFieldTypeInteger, alias: Enter Sign Code )
Relationships:
• CityOfSheboygan.OWNER.Sign_Pole_WOs (2) -- Related To: Sign Pole Work Orders (2)
• SignPoles (1) -- Related To: SignPoles (0)
• CityOfSheboygan.OWNER.SignCodeTable2023 (3) -- Related To: SignCodeTable2023 (3)