Layer: OSSWorkOrders_ExportTable (ID:2)

Name: OSSWorkOrders_ExportTable

Display Field: SiteName

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Scheduled (type: esriFieldTypeDate, alias: Scheduled, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
FiscalYear (type: esriFieldTypeSmallInteger, alias: Fiscal Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
BagPickup (type: esriFieldTypeString, alias: Bag Pick-Up, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Assigned: Assigned], [On Hold: On Hold], [Completed: Completed])
CompleteDate (type: esriFieldTypeDate, alias: Completed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Hours (type: esriFieldTypeSmallInteger, alias: Hours, SQL Type: sqlTypeOther, nullable: true, editable: true)
Clients (type: esriFieldTypeSmallInteger, alias: Clients, SQL Type: sqlTypeOther, nullable: true, editable: true)
SiteSupervisors (type: esriFieldTypeSmallInteger, alias: Supervisors on Site, SQL Type: sqlTypeOther, nullable: true, editable: true)
BagsTrash (type: esriFieldTypeSmallInteger, alias: Bags of Trash, SQL Type: sqlTypeOther, nullable: true, editable: true)
lbsTrash (type: esriFieldTypeDouble, alias: lbs of Trash, SQL Type: sqlTypeOther, nullable: true, editable: true)
TonsTrash (type: esriFieldTypeDouble, alias: Tons of Trash, SQL Type: sqlTypeOther, nullable: true, editable: true)
BagsRecyclable (type: esriFieldTypeSmallInteger, alias: Bags of Recyclables, SQL Type: sqlTypeOther, nullable: true, editable: true)
lbsRecyclable (type: esriFieldTypeDouble, alias: lbs of Recyclables, SQL Type: sqlTypeOther, nullable: true, editable: true)
TonsRecyclables (type: esriFieldTypeDouble, alias: Tons of Recyclables, SQL Type: sqlTypeOther, nullable: true, editable: true)
BagsGlass (type: esriFieldTypeSmallInteger, alias: Bags of Glass, SQL Type: sqlTypeOther, nullable: true, editable: true)
lbsGlass (type: esriFieldTypeDouble, alias: lbs of Glass, SQL Type: sqlTypeOther, nullable: true, editable: true)
TonsGlass (type: esriFieldTypeDouble, alias: Tons of Glass, SQL Type: sqlTypeOther, nullable: true, editable: true)
InvasiveBags (type: esriFieldTypeSmallInteger, alias: Invasive Bags, SQL Type: sqlTypeOther, nullable: true, editable: true)
Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
GUID (type: esriFieldTypeGUID, alias: GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LastEditor (type: esriFieldTypeString, alias: LastEditor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
LastEditDate (type: esriFieldTypeDate, alias: LastEditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Volunteers (type: esriFieldTypeInteger, alias: Volunteers, SQL Type: sqlTypeOther, nullable: true, editable: true)
Countystaff (type: esriFieldTypeInteger, alias: County Staff, SQL Type: sqlTypeOther, nullable: true, editable: true)
Trash_type1 (type: esriFieldTypeString, alias: Most Common Trash Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Plastic Bags: Plastic Bags], [Wrappers: Wrappers], [Packing Material: Packing Material], ... 5 more ...)
Trash_type2 (type: esriFieldTypeString, alias: Second Most Common Trash Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Plastic Bags: Plastic Bags], [Wrappers: Wrappers], [Packing Material: Packing Material], ... 5 more ...)
Trash_type3 (type: esriFieldTypeString, alias: Third Most Common Trash Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Plastic Bags: Plastic Bags], [Wrappers: Wrappers], [Packing Material: Packing Material], ... 5 more ...)
Recycle_type1 (type: esriFieldTypeString, alias: Most Common Recycle Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Plastic Bottles: Plastic Bottles], [Plastic Containers: Plastic Containers], [Metal Cans: Metal Cans], ... 1 more ...)
Recycle_type2 (type: esriFieldTypeString, alias: Second Most Common Recycle Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Plastic Bottles: Plastic Bottles], [Plastic Containers: Plastic Containers], [Metal Cans: Metal Cans], ... 1 more ...)
Large_bulky_items (type: esriFieldTypeString, alias: Large Bulky Items, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Small_bulky_items (type: esriFieldTypeString, alias: Small Bulky Items, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Electronic_items (type: esriFieldTypeString, alias: Electronic Items, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Hazardous_waste (type: esriFieldTypeString, alias: Hazardous Waste, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
OBJECTID_1 (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
SiteName (type: esriFieldTypeString, alias: Site Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Shelter (type: esriFieldTypeString, alias: Shelter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NHH - Kennedy: NHH - Kennedy], [NHH - Bailey's: NHH - Bailey's], [TLC: TLC], ... 1 more ...)
SiteID (type: esriFieldTypeString, alias: SiteID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Program (type: esriFieldTypeString, alias: Program, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
IllegalDump (type: esriFieldTypeString, alias: Illegal Dump, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes])
OrgType (type: esriFieldTypeString, alias: Public or Private, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Public: Public], [Private: Private], [Public/Private: Public/Private])
Region (type: esriFieldTypeSmallInteger, alias: Region, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 1 more ...)
BOSDistrict (type: esriFieldTypeString, alias: BOS District, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Braddock: Braddock], [Drainsville: Drainsville], [Dranesville: Dranesville], ... 17 more ...)
VDOT_ROW (type: esriFieldTypeString, alias: VDOT ROW, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes])
SiteLog (type: esriFieldTypeString, alias: Site Logistics, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
Uniform (type: esriFieldTypeString, alias: Uniform, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Long pants, long sleeves, safety vest, boots, hard hat, safety glasses: Long pants, long sleeves, safety vest, boots, hard hat, safety glasses], [Uniform 1: Uniform 1])
WorkType (type: esriFieldTypeString, alias: Type of Work, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Litter Removal: Litter Removal], [Invasives Removal: Invasives Removal], [Litter & Invasives Removal: Litter & Invasives Removal], ... 9 more ...)
Tools (type: esriFieldTypeString, alias: Tools, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Bags, trash grabbers, safety sign: Bags, trash grabbers, safety sign], [Wire cutters, shovels, clippers/pruners, loppers, bags, trash grabbers, safety sign: Wire cutters, shovels, clippers/pruners, loppers, bags, trash grabbers, safety sign], [Tools 1: Tools 1])
Notices (type: esriFieldTypeString, alias: Notices, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
Safety (type: esriFieldTypeString, alias: Safety, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
SiteDesc (type: esriFieldTypeString, alias: Site Description, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
GlobalID_1 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, 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)
SiteFreq (type: esriFieldTypeString, alias: Site Frequency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Annually: Annually], [6 months: 6 months], [3 months: 3 months], ... 4 more ...)
Reviewed (type: esriFieldTypeString, alias: Reviewed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
POC (type: esriFieldTypeString, alias: POC, SQL Type: sqlTypeOther, length: 600, nullable: true, editable: true)
X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/1/2026 2:06:35 PM

Schema Last Edit Date: 4/1/2026 2:06:35 PM

Data Last Edit Date: 2/3/2026 3:19:08 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Query Attachments Generate Renderer Validate SQL Get Estimates ConvertFormat