Name: Corvallis_TrafficPole

Display Field: POLE_TYPE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text: City of Corvallis, Oregon Geographic Information System Services

Min. Scale: 577791

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -13732447.7397489
YMin: 5516519.00246962
XMax: -13718814.7150237
YMax: 5558990.95727982
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[76,47,135,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

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)
• POLE_TYPE (type: esriFieldTypeString, alias: Pole Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Pedestrian: Pedestrian], [Signal: Signal], [Other: Other])
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Steel: Steel], [Wood: Wood])
• OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [BC: Benton County], [City: City of Corvallis], [ODOT: Oregon Dept. of Transportation])
• MAINTAINED_BY (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [City: City of Corvallis])
• CONSTRUCTION_FUND (type: esriFieldTypeString, alias: Construction Fund, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [BC: Benton County], [City: City of Corvallis], [City/State: City of Corvallis/State of Oregon], ... 2 more ...)
• COOP_AGREEMENT (type: esriFieldTypeString, alias: Coop Agreement, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• INSTALL_DATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSPECTED_DATE (type: esriFieldTypeDate, alias: Inspected Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PED_PUSH (type: esriFieldTypeString, alias: Pedestrian Push Button, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Box: Box], [H-Type: H-Type], [H-Type/Box: H-Type/Box], ... 1 more ...)
• PED_AUDIBLE (type: esriFieldTypeString, alias: Pedestrian Audible, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• MASTER_ARM (type: esriFieldTypeSmallInteger, alias: Mast Arm, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMMENT (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• X_COORD (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y_COORD (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRAFFIC_POLE_ID (type: esriFieldTypeInteger, alias: Traffic Pole ID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• INTERSECTION_ID (type: esriFieldTypeInteger, alias: Intersection ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPAN_WIRE (type: esriFieldTypeInteger, alias: Span Wire, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STREET_LIGHTS (type: esriFieldTypeInteger, alias: Street Lights, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ILLUMINATED_SIGN (type: esriFieldTypeInteger, alias: Illuminated Signs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PED_COUNTDOWN (type: esriFieldTypeString, alias: Pedestrian Countdown, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• PED_HEAD (type: esriFieldTypeInteger, alias: Pedestrian Head, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0], [1: 1], [2: 2])
• STRUCT_ID (type: esriFieldTypeString, alias: STRUCT_ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CABINET_ID (type: esriFieldTypeInteger, alias: Cabinet ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DESCRIPTION (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• USEFUL_LIFE (type: esriFieldTypeSmallInteger, alias: Useful Life, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VALUE (type: esriFieldTypeSmallInteger, alias: Value, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: Created By, 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 By, 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)
• SYS_ID (type: esriFieldTypeDouble, alias: SYS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Corvallis_TrafficPole
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• TRAFFIC_POLE_ID: 0
• INTERSECTION_ID: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/28/2025 5:54:10 PM

Schema Last Edit Date: 1/29/2024 7:48:08 PM

Data Last Edit Date: 1/28/2025 5:54:10 PM

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