Name: Corvallis_StreetLight

Display Field: TYPE_LT

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

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

Min. Scale: 288896

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -13728627.4883725
YMin: 5543505.59922989
XMax: -13718163.9144367
YMax: 5559461.66908923
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[72,101,168,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)
• REGION (type: esriFieldTypeSmallInteger, alias: Region, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TYPE_LT (type: esriFieldTypeString, alias: Light Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [ORNAMENT: Ornament], [ORNAMENTAL: Ornamental], [VERTICAL: Vertical], ... 7 more ...)
• WATTAGE (type: esriFieldTypeSmallInteger, alias: Wattage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WIRE_LOC (type: esriFieldTypeString, alias: Wire Location, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [AERIAL: Aerial], [BURIED: Buried])
• OWNER_PL (type: esriFieldTypeString, alias: Pole Owner, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [BC: BC], [CPI: CPI], [OSU: OSU], ... 4 more ...)
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [FIBERGLASS: Fiber Glass], [WOOD: Wood], [NA: NA], ... 2 more ...)
• TYPE (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [SINGLE: Single], [TRIPLE: Triple], [DUAL: Dual])
• USAGE (type: esriFieldTypeString, alias: Usage, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [SIGNAL: Signal], [LIGHT: Light], [UTILITY: Utility])
• OWNER_LT (type: esriFieldTypeString, alias: Owner Light, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [BC: BC], [CPI: CPI], [OSU: OSU], ... 4 more ...)
• LAMP_TYPE (type: esriFieldTypeString, alias: Lamp Type, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• LABEL (type: esriFieldTypeSmallInteger, alias: Label, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LUMENS (type: esriFieldTypeInteger, alias: Lumens, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STRUCT_ID (type: esriFieldTypeString, alias: Structure ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CUSTOMER (type: esriFieldTypeString, alias: Customer, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true, Coded Values: [OSU: OSU], [CITY OF CORVALLIS: City of Corvallis], [PRIVATE: Private], ... 3 more ...)
• X_COORD (type: esriFieldTypeDouble, alias: X Coordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y_COORD (type: esriFieldTypeDouble, alias: Y Coordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STRUCT_ID_OLD (type: esriFieldTypeString, alias: Old Structure ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• INSTALL_DATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DESCRIPTION (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 500, 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)
• USEFUL_LIFE (type: esriFieldTypeSmallInteger, alias: Useful Life, SQL Type: sqlTypeOther, 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_StreetLight
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/11/2024 3:56:43 PM

Schema Last Edit Date: 7/11/2024 3:56:43 PM

Data Last Edit Date: 1/29/2024 7:48:03 PM

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