Layers:

Layer: GISTrans.GISPUB.UTIL_Sign (0)

Name: GISTrans.GISPUB.UTIL_Sign

Display Field: SignName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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: 540186.1907721311
YMin: 136509.1993688047
XMax: 631350.061265558
YMax: 222936.76240572333
Spatial Reference: 202011  (202011)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: SignType
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [138, 0, 99, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label:
UniqueValueInfos:
• Value: 0
  Label: Hazard
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [168, 59, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 1
  Label: Miscellaneous
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [138, 112, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 5
  Label: Parks and Rec, Indoor
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [0, 132, 158, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 6
  Label: Parks and Rec, Outdoor
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [0, 86, 133, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 7
  Label: Prop Man, Indoor
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [130, 0, 102, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 8
  Label: Prop Man, Outdoor
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [168, 118, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 2
  Label: Regulatory
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [114, 163, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 3
  Label: School
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [163, 0, 158, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 4
  Label: Warning
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [7, 0, 140, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
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: SignType

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FeatureUniqueID ( type: esriFieldTypeString, alias: FeatureUniqueID, length: 8 )
• SignType ( type: esriFieldTypeSmallInteger, alias: SignType )
• SignIdentifier ( type: esriFieldTypeString, alias: SignIdentifier, length: 50 , Coded Values: [9524002: 9 Button Black/Yellow - 18"] , [9524009: BRDG Clearance Marker (L) - 18"x36"] , [9524010: BRDG Clearance Marker (R) - 18"x36"] , ...5 more... )
• PartNumber ( type: esriFieldTypeString, alias: PartNumber, length: 50 )
• SignName ( type: esriFieldTypeString, alias: SignName, length: 50 )
• SignDepartmet ( type: esriFieldTypeString, alias: SignDepartmet, length: 50 )
• MUTCD ( type: esriFieldTypeString, alias: MUTCD, length: 50 )
• RouteSystem ( type: esriFieldTypeString, alias: RouteSystem, length: 50 , Coded Values: [01: Interstate] , [02: US Highway] , [03: MN Highway] , ...40 more... )
• RouteNumber ( type: esriFieldTypeString, alias: RouteNumber, length: 10 )
• BuildingName ( type: esriFieldTypeString, alias: BuildingName, length: 50 )
• BuildingAddress ( type: esriFieldTypeString, alias: BuildingAddress, length: 50 )
• BuildingFloor ( type: esriFieldTypeSmallInteger, alias: BuildingFloor )
• RoomNumber ( type: esriFieldTypeString, alias: RoomNumber, length: 10 )
• LocationDescription ( type: esriFieldTypeString, alias: LocationDescription, length: 255 )
• Municipality ( type: esriFieldTypeString, alias: Municipality, length: 50 , Coded Values: [02393979: Arden Hills] , [02394183: Blaine] , [02394738: Falcon Heights] , ...61 more... )
• RouteID ( type: esriFieldTypeString, alias: RouteID, length: 20 )
• RoadMileage ( type: esriFieldTypeDouble, alias: RoadMileage )
• OwnerType ( type: esriFieldTypeString, alias: OwnerType, length: 30 , Coded Values: [County: County] , [State: State] , [City: City] )
• OwnerName ( type: esriFieldTypeString, alias: OwnerName, length: 50 )
• MaintenanceType ( type: esriFieldTypeString, alias: MaintenanceType, length: 30 , Coded Values: [County: County] , [State: State] , [City: City] )
• MainteanceName ( type: esriFieldTypeString, alias: MainteanceName, length: 50 )
• Status ( type: esriFieldTypeString, alias: Status, length: 20 , Coded Values: [Active: Active] , [Retired: Retired] , [Planned: Planned] , ...3 more... )
• ActiveDate ( type: esriFieldTypeDate, alias: ActiveDate, length: 8 )
• RetiredDate ( type: esriFieldTypeDate, alias: RetiredDate, length: 8 )
• FacingDirection ( type: esriFieldTypeString, alias: FacingDirection, length: 20 , Coded Values: [E: E] , [N: N] , [NE: NE] , ...5 more... )
• Source ( type: esriFieldTypeString, alias: Source, length: 50 , Coded Values: [Grainger: Grainger] , [Sign Source: Sign Source] , [Fast Sign: Fast Sign] , ...2 more... )
• SignSizeInches ( type: esriFieldTypeString, alias: SignSizeInches, length: 30 )
• SignSeries ( type: esriFieldTypeString, alias: SignSeries, length: 50 )
• BaseType ( type: esriFieldTypeString, alias: BaseType, length: 50 , Coded Values: [Sonotube: Sonotube] , [Concrete Pad: Concrete Pad] , [Sidewalk/Asphalt: Sidewalk/Asphalt] , ...6 more... )
• BaseSize ( type: esriFieldTypeString, alias: BaseSize, length: 50 )
• PostType ( type: esriFieldTypeString, alias: PostType, length: 50 , Coded Values: [Telespar: Telespar] , [Galvanized-U-Channel: Galvanized-U-Channel] , [Black-U-Channel: Black-U-Channel] , ...8 more... )
• NumberOfPosts ( type: esriFieldTypeSmallInteger, alias: NumberOfPosts )
• NumberSigns ( type: esriFieldTypeSmallInteger, alias: NumberSigns )
• PrimarySign ( type: esriFieldTypeString, alias: PrimarySign, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• StickerDate ( type: esriFieldTypeDate, alias: StickerDate, length: 8 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• CreatedBy ( type: esriFieldTypeString, alias: CreatedBy, length: 50 )
• CreatedDate ( type: esriFieldTypeDate, alias: CreatedDate, length: 8 )
• EditedBy ( type: esriFieldTypeString, alias: EditedBy, length: 50 )
• EditedDate ( type: esriFieldTypeDate, alias: EditedDate, length: 8 )
• GlobalUniqueID ( type: esriFieldTypeString, alias: GlobalUniqueID, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• CustomSign ( type: esriFieldTypeString, alias: CustomSign, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• Condition ( type: esriFieldTypeString, alias: Condition, length: 1 , Coded Values: [5: New] , [4: Good] , [3: Fair] , ...3 more... )
• RouteSection ( type: esriFieldTypeString, alias: RouteSection, length: 1 , Coded Values: [A: A] , [B: B] , [C: C] , ...23 more... )
• Park ( type: esriFieldTypeString, alias: Park, length: 50 )
• Trail ( type: esriFieldTypeString, alias: Trail, length: 50 )
• Arena ( type: esriFieldTypeString, alias: Arena, length: 50 )
• GolfCourse ( type: esriFieldTypeString, alias: GolfCourse, length: 50 )
• FacilityName ( type: esriFieldTypeString, alias: FacilityName, length: 75 )
• ActionCode ( type: esriFieldTypeString, alias: ActionCode, length: 20 , Coded Values: [Reset - A: Reset - A] , [Remove - B: Remove - B] , [Replace - C: Replace - C] , ...2 more... )
• PWStickerDate ( type: esriFieldTypeString, alias: PWStickerDate, length: 4 , Coded Values: [2000: 2000] , [2001: 2001] , [2002: 2002] , ...28 more... )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 20 )
• LegacyCondition ( type: esriFieldTypeSmallInteger, alias: LegacyCondition , Coded Values: [0: Good] , [1: Poor] , [2: Replace] )
Types:
ID: 0
Name: Hazard
Domains:
• SignIdentifier:
  Inherited
• RouteSystem:
  Inherited
• Municipality:
  Inherited
• OwnerType:
  Inherited
• MaintenanceType:
  Inherited
• Status:
  Inherited
• FacingDirection:
  Inherited
• BaseType:
  Inherited
• PostType:
  Inherited
• PrimarySign:
  Inherited
• ActionCode:
  Inherited

---

ID: 1
Name: Miscellaneous
Domains:
• SignIdentifier:
  Coded Values: [9513009: Arrow R & L - 21"x15"] , [9513004: Arrow R or L - 21"x15"] , [9513005: Begin - 24"x12"] , ...9 more...
• RouteSystem:
  Inherited
• Municipality:
  Inherited
• OwnerType:
  Inherited
• MaintenanceType:
  Inherited
• Status:
  Inherited
• FacingDirection:
  Inherited
• BaseType:
  Inherited
• PostType:
  Inherited
• PrimarySign:
  Inherited
• ActionCode:
  Inherited

---

ID: 2
Name: Regulatory
Domains:
• SignIdentifier:
  Coded Values: [9518005: All Way - 18"x6"] , [9518013: All Way - 36"x12"] , [9518068: Begin RT TRN LN/ Yield Bikes - 36"x30"] , ...52 more...
• RouteSystem:
  Inherited
• Municipality:
  Inherited
• OwnerType:
  Inherited
• MaintenanceType:
  Inherited
• Status:
  Inherited
• FacingDirection:
  Inherited
• BaseType:
  Inherited
• PostType:
  Inherited
• PrimarySign:
  Inherited
• ActionCode:
  Inherited

---

ID: 3
Name: School
Domains:
• SignIdentifier:
  Coded Values: [9519006: Down Arrow R or L - 24"x18"] , [9519005: Pent. School Crossing - 30"] , [9519008: Pent. School Crossing - 36"] , ...1 more...
• RouteSystem:
  Inherited
• Municipality:
  Inherited
• OwnerType:
  Inherited
• MaintenanceType:
  Inherited
• Status:
  Inherited
• FacingDirection:
  Inherited
• BaseType:
  Inherited
• PostType:
  Inherited
• PrimarySign:
  Inherited
• ActionCode:
  Inherited

---

ID: 4
Name: Warning
Domains:
• SignIdentifier:
  Coded Values: [9523038: "Mile" Plaque - 24"x18"] , [9523023: Bike Crossing - 30"] , [9523070: Blind Driveway/Inter. Ahead - 30"] , ...62 more...
• RouteSystem:
  Inherited
• Municipality:
  Inherited
• OwnerType:
  Inherited
• MaintenanceType:
  Inherited
• Status:
  Inherited
• FacingDirection:
  Inherited
• BaseType:
  Inherited
• PostType:
  Inherited
• PrimarySign:
  Inherited
• ActionCode:
  Inherited

---

ID: 7
Name: Prop Man, Indoor
Domains:
• SignIdentifier:
  Coded Values: [Aed: Aed] , [Braille: Braille] , [Building Hours: Building Hours] , ...20 more...
• RouteSystem:
  Inherited
• Municipality:
  Inherited
• OwnerType:
  Inherited
• MaintenanceType:
  Inherited
• Status:
  Inherited
• FacingDirection:
  Inherited
• BaseType:
  Inherited
• PostType:
  Inherited
• PrimarySign:
  Inherited

---

ID: 8
Name: Prop Man, Outdoor
Domains:
• SignIdentifier:
  Coded Values: [Address: Address] , [Directional Arrow: Directional Arrow] , [Do Not Enter: Do Not Enter] , ...7 more...
• RouteSystem:
  Inherited
• Municipality:
  Inherited
• OwnerType:
  Inherited
• MaintenanceType:
  Inherited
• Status:
  Inherited
• FacingDirection:
  Inherited
• BaseType:
  Inherited
• PostType:
  Inherited
• PrimarySign:
  Inherited

---

ID: 5
Name: Parks and Rec, Indoor
Domains:
• SignIdentifier:
  Coded Values: [Temporary: Temporary] , [Descriptive/informational: Descriptive/informational] , [Rules: Rules]
• RouteSystem:
  Inherited
• Municipality:
  Inherited
• OwnerType:
  Inherited
• MaintenanceType:
  Inherited
• Status:
  Inherited
• FacingDirection:
  Inherited
• BaseType:
  Inherited
• PostType:
  Inherited
• PrimarySign:
  Inherited

---

ID: 6
Name: Parks and Rec, Outdoor
Domains:
• SignIdentifier:
  Coded Values: [Aquatic Invasive Species(AIS): Aquatic Invasive Species(AIS)] , [Descriptive/Informational: Descriptive/Informational] , [Kiosk, Primary: Kiosk, Primary] , ...11 more...
• RouteSystem:
  Inherited
• Municipality:
  Inherited
• OwnerType:
  Inherited
• MaintenanceType:
  Inherited
• Status:
  Inherited
• FacingDirection:
  Inherited
• BaseType:
  Inherited
• PostType:
  Inherited
• PrimarySign:
  Inherited

---

Tables:

Table: GISTrans.dbo.AssetCount (1)

Name: GISTrans.dbo.AssetCount

Display Field: TrafficSignalCount

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

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:
• TrafficSignalCount ( type: esriFieldTypeOID, alias: TrafficSignalCount )
• InletCount ( type: esriFieldTypeInteger, alias: InletCount )
• OutfallCount ( type: esriFieldTypeInteger, alias: OutfallCount )
• SignCount ( type: esriFieldTypeInteger, alias: SignCount )
• TreeTrenchCount ( type: esriFieldTypeInteger, alias: TreeTrenchCount )
• IBasinCount ( type: esriFieldTypeInteger, alias: IBasinCount )
• AprinCount ( type: esriFieldTypeInteger, alias: AprinCount )
• BridgeCount ( type: esriFieldTypeInteger, alias: BridgeCount )
• CurbcutCount ( type: esriFieldTypeInteger, alias: CurbcutCount )
• FeatureTrailCount ( type: esriFieldTypeInteger, alias: FeatureTrailCount )