Layers:

Layer: Sharps_Box_Maintenance___Prod (0)


Name: Sharps_Box_Maintenance___Prod

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Min. Scale: 2311163

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -122.75698205514
YMin: 45.4603648807927
XMax: -122.537811575188
YMax: 45.5899425117988
Spatial Reference: 4326 (4326)


Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Sharps Box Maintenance - Prod","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

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: globalid

Type ID Field:

Fields:
• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• ContractorName (type: esriFieldTypeString, alias: Contractor Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Rapid Response: Rapid Response])
• sharps_box_globalid (type: esriFieldTypeString, alias: Sharps Boxes ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SharpsBoxName (type: esriFieldTypeString, alias: Name of Sharps Box, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MaintenanceDate (type: esriFieldTypeDate, alias: Date Serviced, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MaintenanceStatus (type: esriFieldTypeString, alias: MaintenanceStatus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [new: new], [reviewed: reviewed], [approved: approved])
• ServiceType (type: esriFieldTypeString, alias: Service Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [standard: Standard Service], [installation: Installation of sharps collection box], [remove: Remove sharps collection box], ... 4 more ...)
• HoursWorked (type: esriFieldTypeDouble, alias: Hours Worked, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SharpsBoxAccess (type: esriFieldTypeString, alias: Collection Box Is Operational and Accessible, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• Condition (type: esriFieldTypeString, alias: Condition of Box, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [good: Good], [fair: Fair], [poor: Poor])
• Blockage (type: esriFieldTypeString, alias: Blockage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• Graffiti (type: esriFieldTypeString, alias: Graffiti, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BoxCleaning (type: esriFieldTypeString, alias: BoxCleaning, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Litter (type: esriFieldTypeString, alias: Litter, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Disinfectant (type: esriFieldTypeString, alias: Disinfectant, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Disposal (type: esriFieldTypeString, alias: Disposal, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SharpsPercent (type: esriFieldTypeDouble, alias: Percent of the Sharps Collection Box Filled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 50%], [0.75: 75%], [1: 100%])
• GarbagePercent (type: esriFieldTypeDouble, alias: Percent Garbage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0%], [0.125: less than 25%], [0.25: 25%], ... 3 more ...)
• SharpsApprox (type: esriFieldTypeInteger, alias: SharpsApprox, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ServiceCharge (type: esriFieldTypeDouble, alias: Charge for Sharps Box Service, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TransportCharge (type: esriFieldTypeDouble, alias: Charge for Sharps Transport, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisposalCharge (type: esriFieldTypeDouble, alias: Charge for Sharps Disposal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GraffitiCharge (type: esriFieldTypeDouble, alias: Charge for Graffiti Removal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EmergencyCharge (type: esriFieldTypeDouble, alias: Charge for Emergency Service, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InstallationCharge (type: esriFieldTypeDouble, alias: Charge for Installation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RemovalCharge (type: esriFieldTypeDouble, alias: Charge for Removal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RepairCharge (type: esriFieldTypeDouble, alias: Charge for Repair, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalCharge (type: esriFieldTypeDouble, alias: Total Cost of Maintenance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SurveyVersion (type: esriFieldTypeDouble, alias: SurveyVersion, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsActive (type: esriFieldTypeString, alias: IsActive, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• ServiceSchedule (type: esriFieldTypeString, alias: ServiceSchedule, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Monday/Thursday: Monday/Thursday])

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/10/2025 10:00:28 PM

Schema Last Edit Date: 4/10/2025 10:00:28 PM

Data Last Edit Date: 4/10/2025 10:00:28 PM