Name: Sharps_Box_Maintenance___DEV2

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

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: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Sharps Box Maintenance - DEV2","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, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sharps_box_globalid (type: esriFieldTypeString, alias: Sharps Box ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SharpsBoxName (type: esriFieldTypeString, alias: 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: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [new: new], [reviewed: reviewed], [approved: approved])
• Installation (type: esriFieldTypeString, alias: Installation - dev only, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Removal (type: esriFieldTypeString, alias: Removal - dev only, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RepairField (type: esriFieldTypeString, alias: RepairField - dev only, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RepairNotField (type: esriFieldTypeString, alias: RepairNotField - dev only, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• EmergencyWorkHrs (type: esriFieldTypeString, alias: EmergencyWorkHrs - dev only, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• EmergencyAfterHrs (type: esriFieldTypeString, alias: EmergencyAfterHrs - dev only, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• HoursWorked (type: esriFieldTypeDouble, alias: Hours Worked, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SharpsBoxAccess (type: esriFieldTypeString, alias: Operational, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• Condition (type: esriFieldTypeString, alias: Condition, 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: 50, 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)
• VisitCharge (type: esriFieldTypeDouble, alias: Charge for Visit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TransportCharge (type: esriFieldTypeDouble, alias: Charge for Transport, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisposalCharge (type: esriFieldTypeDouble, alias: Charge for 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, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SurveyVersion (type: esriFieldTypeString, alias: SurveyVersion, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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)
• 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], [removal: Remove sharps collection box], ... 4 more ...)
• IsActive (type: esriFieldTypeString, alias: IsActive, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• ServiceSchedule (type: esriFieldTypeString, alias: ServiceSchedule, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)

Templates:

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

Attributes:

• IsActive: Yes

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/14/2025 11:32:12 PM

Schema Last Edit Date: 1/14/2025 11:32:12 PM

Data Last Edit Date: 11/5/2024 11:21:19 PM

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