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: 71b833423c4948e7b3092f6dc1195e0e

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: true
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• HeightApprox ( type: esriFieldTypeDouble, alias: Approximate Pole Height, editable: true, nullable: true, defaultValue: null, modelName: HeightApprox )
• HeightMeasure ( type: esriFieldTypeDouble, alias: Measured Pole Height, editable: true, nullable: true, defaultValue: null, modelName: HeightMeasure )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Condition , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• EditBy ( type: esriFieldTypeString, alias: EditBy, editable: false, nullable: true, length: 50, defaultValue: null, modelName: EditBy )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• CreateBy ( type: esriFieldTypeString, alias: CreateBy, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreateBy )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Address ( type: esriFieldTypeString, alias: Pole Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Address )
• PoleLocation ( type: esriFieldTypeString, alias: Pole Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PoleLocation , Coded Values: [MED: MED] , [NW Corner: NW Corner] , [NE Corner: NE Corner] , ...7 more... )
• MountedOn ( type: esriFieldTypeString, alias: Pole (Mounted On), editable: true, nullable: true, length: 50, defaultValue: null, modelName: MountedOn , Coded Values: [Square M Post: Square M Post] , [Wood Post: Wood Post] , [Channel Post: Channel Post] , ...11 more... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SIGNS ( type: esriFieldTypeInteger, alias: Number of signs on pole, editable: true, nullable: true, defaultValue: null, modelName: SIGNS )
• Longitude ( type: esriFieldTypeDouble, alias: POINT_X, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• Latitude ( type: esriFieldTypeDouble, alias: POINT_Y, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• CountAttachment ( type: esriFieldTypeInteger, alias: Number of Attachments, editable: true, nullable: true, defaultValue: null, modelName: CountAttachment )
• CountRelatedFeature ( type: esriFieldTypeInteger, alias: Number of related features, editable: true, nullable: true, defaultValue: null, modelName: CountRelatedFeature )
• InstallationDate ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ReplacementDate ( type: esriFieldTypeDate, alias: ReplacementDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ReplacementDate )
Templates:
• Name: SignPoles
  Description:
  Prototype:
  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
  
  Drawing Tool: esriFeatureEditToolPoint
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:

Service Item Id: 71b833423c4948e7b3092f6dc1195e0e

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: true
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• WorkPerformed ( type: esriFieldTypeString, alias: Work Performed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WorkPerformed , 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DamageType , Coded Values: [Vehicle Accident: Vehicle Accident] , [Vandalism: Vandalism] , [Faded/Rusted: Faded/Rusted] , ...6 more... )
• CostPost ( type: esriFieldTypeString, alias: Post Cost, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CostPost )
• CostSign ( type: esriFieldTypeString, alias: Sign Cost, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CostSign )
• WO_Comments ( type: esriFieldTypeString, alias: Work Order Comments, editable: true, nullable: true, length: 300, defaultValue: null, modelName: WO_Comments )
• CreateBy ( type: esriFieldTypeString, alias: CreateBy, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreateBy )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• EditBy ( type: esriFieldTypeString, alias: EditBy, editable: false, nullable: true, length: 50, defaultValue: null, modelName: EditBy )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• GUID_Pole ( type: esriFieldTypeGUID, alias: GUID_Pole, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID_Pole )
• AssignmentType ( type: esriFieldTypeString, alias: AssignmentT ype, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssignmentType , Coded Values: [General Ordinance: General Ordinance] , [Engineering Judgement: Engineering Judgement] )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AssetType ( type: esriFieldTypeString, alias: Asset Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AssetType )
• WorkDate ( type: esriFieldTypeString, alias: Work Order Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WorkDate )
• GUID_Sign ( type: esriFieldTypeGUID, alias: GUID_Sign, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID_Sign )
Templates:
• Name: Sign Pole Work Orders
  Description:
  Prototype:
  WorkDate: null
  WorkPerformed: null
  DamageType: null
  CostPost: null
  CostSign: null
  WO_Comments: null
  AssetType: null
  AssignmentType: null
  GUID_Pole: null
  GUID_Sign: null
  
  Drawing Tool: esriFeatureEditToolNone
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:

Service Item Id: 71b833423c4948e7b3092f6dc1195e0e

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: true
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID_1 ( type: esriFieldTypeOID, alias: OBJECTID_1, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID_1 )
• code_text ( type: esriFieldTypeInteger, alias: code_text, editable: true, nullable: true, defaultValue: null, modelName: code_text )
• number_ ( type: esriFieldTypeString, alias: number_, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: number_ )
• description ( type: esriFieldTypeString, alias: description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: description )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: created_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 1073741822, defaultValue: null, modelName: last_edited_user )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
• Name: SignCodeTable2023
  Description:
  Prototype:
  number_: null
  description: null
  code_text: null
  
  Drawing Tool: esriFeatureEditToolNone
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:

Service Item Id: 71b833423c4948e7b3092f6dc1195e0e

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: true
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• A_SignCode ( type: esriFieldTypeString, alias: Sign Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: A_SignCode )
• A_Surface ( type: esriFieldTypeString, alias: Surface, editable: true, nullable: true, length: 50, defaultValue: null, modelName: A_Surface , Coded Values: [Reflective: Reflective] , [Nonreflective: Nonreflective] )
• A_Shape ( type: esriFieldTypeString, alias: Shape, editable: true, nullable: true, length: 50, defaultValue: null, modelName: A_Shape , Coded Values: [Xbar: Xbar] , [Shield: Shield] , [Octagon: Octagon] , ...8 more... )
• A_Color ( type: esriFieldTypeString, alias: Color, editable: true, nullable: true, length: 50, defaultValue: null, modelName: A_Color , 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, editable: true, nullable: true, defaultValue: null, modelName: A_Dimension1 )
• A_Dimension2 ( type: esriFieldTypeDouble, alias: Dimension 1, editable: true, nullable: true, defaultValue: null, modelName: A_Dimension2 )
• A_Dimension3 ( type: esriFieldTypeDouble, alias: Dimension 3, editable: true, nullable: true, defaultValue: null, modelName: A_Dimension3 )
• A_Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: A_Material , Coded Values: [.080 Aluminum: .080 Aluminum] , [Wood: Wood] , [.063 Aluminum: .063 Aluminum] , ...4 more... )
• A_AnchorFacing ( type: esriFieldTypeString, alias: Anchor Facing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: A_AnchorFacing , Coded Values: [Facing: Facing] , [Opposing: Opposing] , [Parallel: Parallel] , ...2 more... )
• A_OrdinanceNumber ( type: esriFieldTypeString, alias: Ordinance Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: A_OrdinanceNumber )
• A_Responsibility ( type: esriFieldTypeString, alias: Responsibility, editable: true, nullable: true, length: 50, defaultValue: null, modelName: A_Responsibility , Coded Values: [City: City] , [Transit: Transit] , [Other: Other] )
• B_Destinations ( type: esriFieldTypeString, alias: Destinations, editable: true, nullable: true, length: 300, defaultValue: null, modelName: B_Destinations )
• B_Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: B_Condition , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• B_SignComments ( type: esriFieldTypeString, alias: Sign Comments, editable: true, nullable: true, length: 300, defaultValue: null, modelName: B_SignComments )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreatedBy )
• CreatDate ( type: esriFieldTypeDate, alias: Creat Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatDate )
• EditBy ( type: esriFieldTypeString, alias: EditBy, editable: false, nullable: true, length: 50, defaultValue: null, modelName: EditBy )
• EditDate ( type: esriFieldTypeDate, alias: Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• GUID_Pole ( type: esriFieldTypeGUID, alias: GUID_Pole, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID_Pole )
• Wayfinding ( type: esriFieldTypeString, alias: Wayfinding Sign?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Wayfinding , Coded Values: [Yes: Yes] , [No: No] )
• SignOrderFromTop ( type: esriFieldTypeString, alias: Sign Order(from top), editable: true, nullable: true, length: 50, defaultValue: null, modelName: SignOrderFromTop )
• AnchorType ( type: esriFieldTypeString, alias: AnchorType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AnchorType , Coded Values: [Ground: Ground] , [Concrete: Concrete] , [Collar: Collar] , ...5 more... )
• SignDescription ( type: esriFieldTypeString, alias: Sign Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SignDescription )
• Original_Install ( type: esriFieldTypeDate, alias: Original Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Original_Install )
• DateReplaced ( type: esriFieldTypeDate, alias: Date Replaced, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateReplaced )
• MUTCD ( type: esriFieldTypeString, alias: MUTCD Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MUTCD )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X, editable: true, nullable: true, defaultValue: null, modelName: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y, editable: true, nullable: true, defaultValue: null, modelName: POINT_Y )
• SignCode_Int ( type: esriFieldTypeInteger, alias: Sign Code Integer, editable: true, nullable: true, defaultValue: null, modelName: SignCode_Int )
• Man_SignDescript ( type: esriFieldTypeString, alias: Manual Sign Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Man_SignDescript )
• URL ( type: esriFieldTypeString, alias: URL, editable: true, nullable: true, length: 500, defaultValue: null, modelName: URL )
• SignCode ( type: esriFieldTypeInteger, alias: Enter Sign Code, editable: true, nullable: true, defaultValue: null, modelName: SignCode )
Templates:
• Name: Signs_Table
  Description:
  Prototype:
  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
  
  Drawing Tool: esriFeatureEditToolNone
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)