Name: KCB Master Event

Display Field: OBJECTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

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:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[61,134,175,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: true

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: sqlTypeOther, length: 38, nullable: false, editable: false)
• contact (type: esriFieldTypeString, alias: Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• organizationaffiliation (type: esriFieldTypeString, alias: Are you affiliated with an Organization?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• nameorganization (type: esriFieldTypeString, alias: Name of Organization:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: Address:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• city (type: esriFieldTypeString, alias: City:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• stateaddress (type: esriFieldTypeString, alias: State:, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• zip (type: esriFieldTypeString, alias: Zip:, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• phone (type: esriFieldTypeString, alias: Phone:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• email (type: esriFieldTypeString, alias: Email Address:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• eventdate (type: esriFieldTypeDate, alias: Event Date:, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• eventid (type: esriFieldTypeString, alias: eventid, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• eventidcalc (type: esriFieldTypeString, alias: eventidcalc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• volunteers (type: esriFieldTypeInteger, alias: Number of Participants:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• adoptanarea (type: esriFieldTypeString, alias: Is your event affiliated with Adopt an Area Program?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• affiliatedarea (type: esriFieldTypeString, alias: What is the name of the affiliated area?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cleanercolumbus (type: esriFieldTypeString, alias: Is your event affiliated with Cleaner Columbus Employment Program?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• alleycollection (type: esriFieldTypeString, alias: Does this area have alley collection of refuse?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• removalservice (type: esriFieldTypeString, alias: Will you need trash and waste removal from your cleanup sites?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• collectionlocation (type: esriFieldTypeString, alias: If yes, please give the exact location where trash is to be collected:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• adminapproval (type: esriFieldTypeString, alias: Approval, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [approved: Approved], [rejected: Rejected], [canceled: Canceled], ... 1 more ...)
• standardsupplies (type: esriFieldTypeString, alias: Supplies:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• trashbagsnumber (type: esriFieldTypeInteger, alias: How many Trash Bags?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• glovesnumber (type: esriFieldTypeInteger, alias: How many pairs of Gloves?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• littergrabbernumber (type: esriFieldTypeInteger, alias: How many Litter Grabbers?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• safetyvestsnumber (type: esriFieldTypeInteger, alias: How many Safety Vests?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• additionaltools (type: esriFieldTypeString, alias: Are any other Tools required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• tools (type: esriFieldTypeString, alias: Tools:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pushbroomnumber (type: esriFieldTypeInteger, alias: How many Push Brooms?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cornbroomnumber (type: esriFieldTypeInteger, alias: How many Corn Brooms?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• edgernumber (type: esriFieldTypeInteger, alias: How many Lawn Edgers?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• edgerrotarynumber (type: esriFieldTypeInteger, alias: How many Rotary Lawn Edgers?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hoenumber (type: esriFieldTypeInteger, alias: How many Garden Hoes?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bucketnumber (type: esriFieldTypeInteger, alias: How many Buckets?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• wheelbarrownumber (type: esriFieldTypeInteger, alias: How many Wheelbarrows?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• buttkickernumber (type: esriFieldTypeInteger, alias: How many Butt Kickers?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• weedernumber (type: esriFieldTypeInteger, alias: How many Weeders?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• gardenrakesnumber (type: esriFieldTypeInteger, alias: How many Garden Rakes?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• leafrakesnumber (type: esriFieldTypeInteger, alias: How many Leaf Rakes?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• loppersmallnumber (type: esriFieldTypeInteger, alias: How many Small Loppers?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lopperlargenumber (type: esriFieldTypeInteger, alias: How many Large Loppers?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• shearsgrassnumber (type: esriFieldTypeInteger, alias: How many Grass Shears?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• shearspruningshortnumber (type: esriFieldTypeInteger, alias: How many Short Pruning Shears?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• shearspruninglongnumber (type: esriFieldTypeInteger, alias: How many Long Pruning Shears?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• trowelnumber (type: esriFieldTypeInteger, alias: How many Trowels?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sharpscontainernumber (type: esriFieldTypeInteger, alias: How many Sharps Containers?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mulchfilmnumber (type: esriFieldTypeInteger, alias: Plastic Mulch Film, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bulbplanternumber (type: esriFieldTypeInteger, alias: How many Bulb Planters?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• gardenclawnumber (type: esriFieldTypeInteger, alias: How many Garden Claws?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hammernumber (type: esriFieldTypeInteger, alias: How many Hammers?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tapemeasurenumber (type: esriFieldTypeInteger, alias: How many Tape Measures?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• paintrollernumber (type: esriFieldTypeInteger, alias: How many Paint Rollers?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• paintscrapernumber (type: esriFieldTypeInteger, alias: How many Paint Scrapers?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• paintsprayernumber (type: esriFieldTypeInteger, alias: How many Paint Sprayers?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sandingspongenumber (type: esriFieldTypeInteger, alias: How many Sanding Sponges?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• drillnumber (type: esriFieldTypeInteger, alias: How many Drills?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dropclothnumber (type: esriFieldTypeInteger, alias: How many Drop Cloths?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• yardcartnumber (type: esriFieldTypeInteger, alias: How many Yard Carts?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pickitupnumber (type: esriFieldTypeInteger, alias: How many Pick It Up Signs?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• trashbinnumber (type: esriFieldTypeInteger, alias: How Many Reusable Trash Bins?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• recyclebinnumber (type: esriFieldTypeInteger, alias: How Many Reusable Recycle Bins?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• shovelselection (type: esriFieldTypeString, alias: Shovel Type:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• shovelsmallnumber (type: esriFieldTypeInteger, alias: How many Small Scoop Shovels?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• shovelextrasmallnumber (type: esriFieldTypeInteger, alias: How many Extra Small Shovels?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• shovelmednumber (type: esriFieldTypeInteger, alias: How many Medium Shovels?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• shovellargenumber (type: esriFieldTypeInteger, alias: How many Large Scoop Shovels?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• shovelpointednumber (type: esriFieldTypeInteger, alias: How many Pointed Shovels?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• supplypickup (type: esriFieldTypeDate, alias: Supply Pickup Date:, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• pickupweekenderror (type: esriFieldTypeString, alias: Error:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• supplypickuptime (type: esriFieldTypeString, alias: Pickup Time:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pickupcomments (type: esriFieldTypeString, alias: Remarks:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• supplyreturn (type: esriFieldTypeDate, alias: Supply Return Date:, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• dropoffweekenderror (type: esriFieldTypeString, alias: Error:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• supplyreturntime (type: esriFieldTypeString, alias: Return Time:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• returncomments (type: esriFieldTypeString, alias: Remarks:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hearaboutus (type: esriFieldTypeString, alias: How did you hear about us?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• eventstarttime (type: esriFieldTypeString, alias: Start Time:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• eventendtime (type: esriFieldTypeString, alias: End Time:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• participants (type: esriFieldTypeInteger, alias: Number of Participants:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• garbagebagnumber (type: esriFieldTypeInteger, alias: Number of garbage bags filled:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• othercollection (type: esriFieldTypeString, alias: Unusual Things Collected:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• eventdescription (type: esriFieldTypeString, alias: Tell Us About Your Event! Did you find anything unusual? Do you have a good story you'd like to share?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• timeworked (type: esriFieldTypeDouble, alias: timeworked, SQL Type: sqlTypeOther, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• returnconfirmation (type: esriFieldTypeString, alias: Return Confirmation, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• email_confirmation (type: esriFieldTypeString, alias: Email Confirmation, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: KCB Master Event
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/3/2025 1:44:03 PM

Schema Last Edit Date: 3/21/2025 5:20:20 PM

Data Last Edit Date: 7/3/2025 1:44:03 PM

Supported Operations:   Add Features   Apply Edits   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat