Name: StreetSignPoles

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -18119468.4825989
YMin: -45615050.08477
XMax: 18775635.1492656
YMax: 20012320.8280104
Spatial Reference: 2967 (2967)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,255,197,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FACILITYID (type: esriFieldTypeString, alias: Facility Identifier, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ATTACHID (type: esriFieldTypeString, alias: Attachment ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SIGNTYPE (type: esriFieldTypeString, alias: Sign Type 1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [General Information: General Information], [Guide: Guide], [Object Marker: Object Marker], ... 6 more ...)
• SIGNHEIGHT (type: esriFieldTypeDouble, alias: Height (in), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGNWIDTH (type: esriFieldTypeDouble, alias: Width (in), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGNSTYLE (type: esriFieldTypeString, alias: Style, SQL Type: sqlTypeOther, length: 130, nullable: true, editable: true, Coded Values: [R1-1: Stop Sign], [R1-2: Yield], [R1-3W: 3 Way Stop], ... 107 more ...)
• SIGNTEXT (type: esriFieldTypeString, alias: Sign Text 1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FACING (type: esriFieldTypeString, alias: Facing Direction, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [East: East], [North: North], [South: South], ... 9 more ...)
• HORIZCLEAR (type: esriFieldTypeString, alias: Horizontal Clearance, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• HORIZFROM (type: esriFieldTypeString, alias: Horizontal From, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• VERTFROM (type: esriFieldTypeString, alias: Vertical From, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• ANGLE (type: esriFieldTypeSmallInteger, alias: Angle (Degrees), SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISTTOTOP (type: esriFieldTypeDouble, alias: Distance to Top of Pole, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REFLCOAT (type: esriFieldTypeString, alias: Reflective Coating, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SHEETING (type: esriFieldTypeString, alias: Sheeting Type 1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Baked Enamel: Baked Enamel], [Engineering Grade: Engineering Grade], [High Intensity: High Intensity], ... 2 more ...)
• SUPMATERIAL (type: esriFieldTypeString, alias: Supplemental Materials, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Excellent: Excellent], [Very Good: Very Good], [Good: Good], ... 4 more ...)
• OWNEDBY (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Private], [-2: Other], [1: City of Greenwood], ... 6 more ...)
• MAINTBY (type: esriFieldTypeSmallInteger, alias: Managed By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Private], [-2: Other], [1: City of Greenwood])
• LASTUPDATE (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTEDITOR (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LOCDESC (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• MUTCD (type: esriFieldTypeString, alias: MUTCD, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• SIGNCOLOR (type: esriFieldTypeString, alias: Sign Color, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Blue: Blue], [Brown: Brown], [FYG (Fluorescent yellow-green): FYG (Fluorescent yellow-green)], ... 6 more ...)
• SIGNSHAPE (type: esriFieldTypeString, alias: Sign Shape, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Circle: Circle], [Crossbuck: Crossbuck], [Diamond: Diamond], ... 6 more ...)
• INSTALLMONTH (type: esriFieldTypeSmallInteger, alias: Install Month Sign 1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 01], [2: 02], [3: 03], ... 9 more ...)
• INSTALLYEAR (type: esriFieldTypeSmallInteger, alias: Install Year Sign 1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Prior to 1998], [1998: 1998], [1999: 1999], ... 18 more ...)
• VISIBILITY (type: esriFieldTypeString, alias: Visibility, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Clear: Clear], [Foliage: Foliage], [Other Obstruction: Other Obstruction])
• CONFORMITY (type: esriFieldTypeString, alias: Conformity, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• STREET1 (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1ST BO-MAR ST: 1ST BO-MAR ST], [2ND BO-MAR ST: 2ND BO-MAR ST], [99 N I 65 OFF: 99 N I 65 OFF], ... 1927 more ...)
• STREET2 (type: esriFieldTypeString, alias: Intersect Street, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1ST BO-MAR ST: 1ST BO-MAR ST], [2ND BO-MAR ST: 2ND BO-MAR ST], [99 N I 65 OFF: 99 N I 65 OFF], ... 1927 more ...)
• LANENUM (type: esriFieldTypeSmallInteger, alias: Lane Number, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Single], [9: Multi])
• DATECOLLECTED (type: esriFieldTypeDate, alias: Date Collected, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HEIGHTMUTCD (type: esriFieldTypeSmallInteger, alias: Height MUTCD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WIDTHMUTCD (type: esriFieldTypeSmallInteger, alias: Width MUTCD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PHOTO (type: esriFieldTypeString, alias: Photo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TWPSEC (type: esriFieldTypeString, alias: Township Section, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SignType2 (type: esriFieldTypeString, alias: Sign Type 2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [General Information: General Information], [Guide: Guide], [Object Marker: Object Marker], ... 6 more ...)
• SignText2 (type: esriFieldTypeString, alias: Sign Text 2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• SignSheeting2 (type: esriFieldTypeString, alias: Sign Sheeting 2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Baked Enamel: Baked Enamel], [Engineering Grade: Engineering Grade], [High Intensity: High Intensity], ... 2 more ...)
• Sign2InstallMonth (type: esriFieldTypeSmallInteger, alias: Sign 2 Install Month, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 01], [2: 02], [3: 03], ... 9 more ...)
• Sign2InstallYear (type: esriFieldTypeSmallInteger, alias: Sign 2 Install Year, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Prior to 1998], [1998: 1998], [1999: 1999], ... 18 more ...)
• SignType3 (type: esriFieldTypeString, alias: Sign Type 3, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [General Information: General Information], [Guide: Guide], [Object Marker: Object Marker], ... 6 more ...)
• SignText3 (type: esriFieldTypeString, alias: Sign Text 3, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• SignSheeting3 (type: esriFieldTypeString, alias: Sign Sheeting 3, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Baked Enamel: Baked Enamel], [Engineering Grade: Engineering Grade], [High Intensity: High Intensity], ... 2 more ...)
• Sign3InstallMonth (type: esriFieldTypeSmallInteger, alias: Sign 3 Install Month, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 01], [2: 02], [3: 03], ... 9 more ...)
• Sign3InstallYear (type: esriFieldTypeSmallInteger, alias: Sign 3 Install Year, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Prior to 1998], [1998: 1998], [1999: 1999], ... 18 more ...)
• SignType4 (type: esriFieldTypeString, alias: Sign Type 4, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [General Information: General Information], [Guide: Guide], [Object Marker: Object Marker], ... 6 more ...)
• SignText4 (type: esriFieldTypeString, alias: Sign Text 4, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• SignSheeting4 (type: esriFieldTypeString, alias: Sign Sheeting 4, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Baked Enamel: Baked Enamel], [Engineering Grade: Engineering Grade], [High Intensity: High Intensity], ... 2 more ...)
• Sign4InstallMonth (type: esriFieldTypeSmallInteger, alias: Sign 4 Install Month, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 01], [2: 02], [3: 03], ... 9 more ...)
• Sign4InstallYear (type: esriFieldTypeSmallInteger, alias: Sign 4 Install Year, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Prior to 1998], [1998: 1998], [1999: 1999], ... 18 more ...)
• PoleType (type: esriFieldTypeString, alias: Pole Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Channel: Channel], [Other: Other], [Signal / Light Pole: Signal / Light Pole], ... 7 more ...)
• LaneNumber (type: esriFieldTypeSmallInteger, alias: Lane Number, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Single], [9: Multi])
• PostNumber (type: esriFieldTypeSmallInteger, alias: Post Number, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [3: 3], [4: 4], ... 1 more ...)
• PoleInstallMonth (type: esriFieldTypeSmallInteger, alias: Pole Install Month, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 01], [2: 02], [3: 03], ... 9 more ...)
• PoleInstallYear (type: esriFieldTypeSmallInteger, alias: Pole Install Year, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Prior to 1998], [1998: 1998], [1999: 1999], ... 18 more ...)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: StreetSignPoles
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/10/2020 6:46:08 PM

Schema Last Edit Date: 1/10/2020 6:46:08 PM

Data Last Edit Date: 1/10/2020 6:46:08 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat