Name: Special_Events

Display Field: orgname

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: 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":{"color":[90,65,140,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,0,0,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"}}},"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)
• submittype (type: esriFieldTypeString, alias: submittype, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Special Event: Special Event], [Standard: Standard], [Simplified: Simplified])
• eventnm (type: esriFieldTypeString, alias: Event Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• eventtype (type: esriFieldTypeString, alias: Event Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Autoormotorcycle: Auto or Motorcycle], [Blockparty: Block Party], [Charityorfundraiser: Charity or Fundraiser], ... 20 more ...)
• tags (type: esriFieldTypeString, alias: Event Tags, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• permitid (type: esriFieldTypeString, alias: Event ID, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• permitstatus (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true, Coded Values: [Submitted: Submitted], [Under Review: Under Review], [Pending Approval: Pending Approval], ... 7 more ...)
• sitemapcomplete (type: esriFieldTypeString, alias: Site Map Complete, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• safetyplancomplete (type: esriFieldTypeString, alias: Safety Plan Complete, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• sponsor (type: esriFieldTypeString, alias: Event Sponsors, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• opentopublic (type: esriFieldTypeString, alias: Open to Public, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• attendance (type: esriFieldTypeInteger, alias: Estimated Attendance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• multiday (type: esriFieldTypeString, alias: Is this a multi-day event?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• dailyattendance (type: esriFieldTypeInteger, alias: Est. Daily Attendance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• admissionfee (type: esriFieldTypeString, alias: Admission fee, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• donations (type: esriFieldTypeString, alias: Will donations, contributions, etc. be accepted during the event?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• othercities (type: esriFieldTypeString, alias: Has this event been held in other cities?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• recurring (type: esriFieldTypeString, alias: Is this a recurring event?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• recurringtype (type: esriFieldTypeString, alias: Frequency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Annual: Annual], [Monthly: Monthly], [Weekly: Weekly], ... 1 more ...)
• recurringdesc (type: esriFieldTypeString, alias: Recurring Description, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• eventdesc (type: esriFieldTypeString, alias: Event Location, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• sitemaptext (type: esriFieldTypeString, alias: sitemaptext, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• understandsitemap (type: esriFieldTypeString, alias: Understand site map, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• datenote (type: esriFieldTypeString, alias: Please indicate below the time you begin setting up temporary assets for the event, the start/end of the event, and take down of temporary assets, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• setup (type: esriFieldTypeDate, alias: Setup Start, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• eventstart (type: esriFieldTypeDate, alias: Event Start, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• eventend (type: esriFieldTypeDate, alias: Event End, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• takedown (type: esriFieldTypeDate, alias: Setup End, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• multipledays (type: esriFieldTypeString, alias: Multiday Start and End Time, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• raindate (type: esriFieldTypeDate, alias: Rain Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• rainlocation (type: esriFieldTypeString, alias: Rain location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• concactnote (type: esriFieldTypeString, alias: Setup Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• orgname (type: esriFieldTypeString, alias: Organization Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• pocname (type: esriFieldTypeString, alias: Point of Contact Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pocphone (type: esriFieldTypeString, alias: Point of Contact Phone, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• pocemail (type: esriFieldTypeString, alias: Point of Contact Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• nonprofit (type: esriFieldTypeString, alias: Type of organization, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [nonprofit: Non-profit], [business: Business/Private Corporation], [community: Community Group], ... 2 more ...)
• nonprofit501c3 (type: esriFieldTypeString, alias: 501c3 status, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• contact2name (type: esriFieldTypeString, alias: Point of Contact Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• contact2phone (type: esriFieldTypeString, alias: Point of Contact Phone, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• contact2email (type: esriFieldTypeString, alias: Point of Contact Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• dayofcontactnote (type: esriFieldTypeString, alias: Contact Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sameapp (type: esriFieldTypeString, alias: Day of Contact Same as Applicant, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• docname_read (type: esriFieldTypeString, alias: Point of Contact Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• docphone_read (type: esriFieldTypeString, alias: Point of Contact Phone, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• docemail_read (type: esriFieldTypeString, alias: Point of Contact Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• docname_edit (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• docphone_edit (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• docemail_edit (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• docname (type: esriFieldTypeString, alias: docname, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• docphone (type: esriFieldTypeString, alias: docphone, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• docemail (type: esriFieldTypeString, alias: docemail, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• foodserved (type: esriFieldTypeString, alias: Will food or beverage be sold or given away?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• foodprep (type: esriFieldTypeString, alias: Food, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• alcoholserved (type: esriFieldTypeString, alias: Will alcohol be served at the event?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• typeofalcohol (type: esriFieldTypeString, alias: Alcohol, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• alcoholpermit (type: esriFieldTypeString, alias: Alcohol Permit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• potablewater (type: esriFieldTypeString, alias: Will you provide potable water?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• equipment (type: esriFieldTypeString, alias: Will the event have any of the following special equipment?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• amusementrides (type: esriFieldTypeString, alias: Amusement Rides, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pettingzoos (type: esriFieldTypeString, alias: Petting Zoos, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dunktanks (type: esriFieldTypeString, alias: Dunk Tanks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ponyrides (type: esriFieldTypeString, alias: Pony Rides, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inflatables (type: esriFieldTypeString, alias: Inflatables, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tentscanopies (type: esriFieldTypeString, alias: Will the event have tents or canopies?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• canopies (type: esriFieldTypeString, alias: Tents and sizes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• installdate (type: esriFieldTypeDate, alias: Set up, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• dateremoved (type: esriFieldTypeDate, alias: Take down, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• supplier (type: esriFieldTypeString, alias: Supplier name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• structequip (type: esriFieldTypeString, alias: Other equipment used at the event, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• boothsbleach (type: esriFieldTypeString, alias: Booths, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• banners (type: esriFieldTypeString, alias: Banners, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• generators (type: esriFieldTypeString, alias: Generators, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• commaspec (type: esriFieldTypeString, alias: Other Structures, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dprfacility (type: esriFieldTypeString, alias: Is the event location at a City park, trail, or DPR facility?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• dprrental (type: esriFieldTypeString, alias: Events in Durham Parks and Rec facilities require a separate DPR facility rental application. The application fee must be paid in full in order to book the space, so please consider completing the DPR facility rental application before submitting this special event permit application., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dprpermit (type: esriFieldTypeString, alias: Have you submitted the DPR application and deposit?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• amplifiedsound (type: esriFieldTypeString, alias: Will there be amplified sound?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• trashservices (type: esriFieldTypeString, alias: Are you requesting the City's trash and/or recycling services be provided at the event?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• trashnote (type: esriFieldTypeString, alias: If the event coordinator wishes to use receptacles provided by the City, a Cart Request Form must be submitted 3 weeks prior to the event. Event coordinators should contact the Solid Waste Department at (919) 560-4186 or visit the City's special event page for the required form to submit. Please see the chart in the Special Event Guidelines for the recommended number of carts based on the number of attendees and related fees., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• trashinfo (type: esriFieldTypeString, alias: Trash and Recycling plan, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• restroomsprovided (type: esriFieldTypeString, alias: Will restrooms be provided at the event?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• restrooms (type: esriFieldTypeString, alias: Restroom plan, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• covidplan (type: esriFieldTypeString, alias: Covid-19 plan, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• alcoholpolice (type: esriFieldTypeString, alias: For events on public property at which any type of alcohol will be served, Event Coordinators are required to hire off-duty law enforcement officers (e.g., Durham Police Department officers, Durham County Sheriff's deputies, etc.) as event security, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• policerequested (type: esriFieldTypeString, alias: Are you specifically requesting City police resources for this event?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• policehire (type: esriFieldTypeString, alias: If you are hiring Durham Police Department officers for your event, you are responsible for contacting the City of Durham Police Department Secondary Employment Coordinator at (919) 560-4322, ext. 29183 to schedule the officers for your event. Fees are due by cash or check within 15 days of the event. More information is available on the City's website at https://durhamnc.gov/190/Secondary-Employment-Information., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• policejustification (type: esriFieldTypeString, alias: Requesting Police Justification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• privatesecurity (type: esriFieldTypeString, alias: Will you be providing private security?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• agencyname (type: esriFieldTypeString, alias: Name of security agency and number of personnel, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• medical (type: esriFieldTypeString, alias: What is your plan for providing emergency medical services?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• medicalnote (type: esriFieldTypeString, alias: To request County EMS, please submit the Request for Special Event Coverage form, available to download at http://www.dconc.gov/home/showdocument?id=24741. Fees apply; a schedule and more information can be found in the Special Event Guidelines., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• emt (type: esriFieldTypeString, alias: Emergency Medical Services, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fire (type: esriFieldTypeString, alias: Fireworks or flames?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• firenote (type: esriFieldTypeString, alias: If fireworks are planned for your event, please contact the Fire Marshal's Office at (919) 560-4242, ext. 19246 or ext. 19240 to discuss required safety measures, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roadclosures (type: esriFieldTypeString, alias: Will the event require roads to be closed (temporary, partial or full)?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• sidewalkclosures (type: esriFieldTypeString, alias: Will the event require sidewalks to be closed?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• typeofroadclosure (type: esriFieldTypeString, alias: Please select the type(s) of road closure, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• requestedroadclosures (type: esriFieldTypeString, alias: Requested Road Closures, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• roadclosestart (type: esriFieldTypeDate, alias: Start time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• roadcloseend (type: esriFieldTypeDate, alias: End time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• describeroadclose (type: esriFieldTypeString, alias: Please describe activities and set up that will take place on the road(s), SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• reservedparking (type: esriFieldTypeString, alias: Blocked Parking?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• reservedspaces (type: esriFieldTypeString, alias: Reserved parking spaces, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• staffparking (type: esriFieldTypeString, alias: Staff parking plan, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• vendorparking (type: esriFieldTypeString, alias: Vendor parking plan, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• attendeeparking (type: esriFieldTypeString, alias: Attendee parking, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• media (type: esriFieldTypeString, alias: Media Plan, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• eventurl (type: esriFieldTypeString, alias: Website, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• notificationprocedure (type: esriFieldTypeString, alias: Please review and adhere to the City's notification procedures, which are located in the Special Event Guidelines document, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• submitdt (type: esriFieldTypeDate, alias: Submission Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• conditions (type: esriFieldTypeString, alias: Submitting this Special Event Permit Application does not provide permission to conduct your planned event. Please do not send out publicity, flyers, or other media prior to receiving confirmation of approval. Your confirmation will be in the form of a PERMIT, issued to the organization and/or person responsible for conducting the event. Applicants agree to remove all props and items brought into the public areas and clean up all litter and debris that result from the event the same day as the event (unless explicit arrangements are made otherwise). Issuance of a permit does NOT grant applicants permission to tow vehicles from reserved or closed areas., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• acknowledgmenta (type: esriFieldTypeString, alias: I certify that all of the information included in this application and in all supporting documentation is true and accurate to the best of my knowledge., SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• acknowledgmentb (type: esriFieldTypeString, alias: I have read, understood, and agree to the City of Durham Special Event Guidelines and to any rules, regulations, and fees outlined in it., SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• acknowledgmentc (type: esriFieldTypeString, alias: I have reviewed the City of Durham Special Events calendar and acknowledge that requesting a date that is already in use by multiple permitted events and/or very large events puts my event at risk of being denied due to insufficient City resources such as traffic control or security., SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• acknowledgmentd (type: esriFieldTypeString, alias: I and/or the sponsoring organization(s) agree to abide by the laws, rules, regulations, and deadlines of the City of Durham., SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• eventid (type: esriFieldTypeString, alias: Event ID for joins, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• permitnum (type: esriFieldTypeString, alias: Your Permit ID:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• 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)
• attendancemax (type: esriFieldTypeInteger, alias: Max. Attendance at One Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
• entry (type: esriFieldTypeString, alias: Attendee Entry, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• contactlessentry (type: esriFieldTypeString, alias: No-contact plan, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• safetycoordinator (type: esriFieldTypeString, alias: Safety Coordinator, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• positivecase (type: esriFieldTypeString, alias: CoVID Positive plan, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• pointsofinterest (type: esriFieldTypeString, alias: Gathering at Points of Interest, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• pointsofentryexit (type: esriFieldTypeString, alias: Gathering at Entry/Exit, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• maskplan (type: esriFieldTypeString, alias: Distancing and Mask plan, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• screeningplan (type: esriFieldTypeString, alias: Screening plan, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• cleaningplan (type: esriFieldTypeString, alias: Cleaning plan, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• healthmanagement (type: esriFieldTypeString, alias: Health Management plan, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• foodsafetyplan (type: esriFieldTypeString, alias: Food/Beverage Safety plan, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• healthprocedures (type: esriFieldTypeString, alias: Health and Safety procedures, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• username (type: esriFieldTypeString, alias: Username, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• acknowledgeguidelines (type: esriFieldTypeString, alias: I have reviewed the City's Special Events webpage and the Special Event Guidelines, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes])
• stage (type: esriFieldTypeString, alias: Will the event have one or more stages?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• stagespecs (type: esriFieldTypeString, alias: Stage specifications, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• stageinstalldate (type: esriFieldTypeDate, alias: Set up, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• stagedateremoved (type: esriFieldTypeDate, alias: Take down, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• stagesupplier (type: esriFieldTypeString, alias: Supplier name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• descriptionCount (type: esriFieldTypeString, alias: Character Count for Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• busiestattendance (type: esriFieldTypeInteger, alias: Est. Busiest Attendance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• organizerage (type: esriFieldTypeString, alias: Organizer 21+, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• dprreservation (type: esriFieldTypeString, alias: DPR Reservation Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• socialmedianote (type: esriFieldTypeString, alias: socialmedianote, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• facebookurl (type: esriFieldTypeString, alias: Facebook Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• instagramurl (type: esriFieldTypeString, alias: Instagram Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• twitterurl (type: esriFieldTypeString, alias: Twitter Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• conditions1 (type: esriFieldTypeString, alias: conditions1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tentspermit (type: esriFieldTypeString, alias: Canopy and tent requirements, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• watermeter (type: esriFieldTypeString, alias: Water Meter, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• electricity (type: esriFieldTypeString, alias: Electricity, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• watermeternote (type: esriFieldTypeString, alias: watermeternote, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• electricitynote (type: esriFieldTypeString, alias: electricitynote, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• stagesize (type: esriFieldTypeString, alias: stagesize, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• stagestreet (type: esriFieldTypeString, alias: stagestreet, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• stagedpr (type: esriFieldTypeString, alias: stagedpr, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• stagedprnote (type: esriFieldTypeString, alias: stagedprnote, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• stagedeposit (type: esriFieldTypeString, alias: stagedeposit, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• stagedepositreservation (type: esriFieldTypeString, alias: stagedepositreservation, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ruleviolation (type: esriFieldTypeString, alias: Rule Violation, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes])
• rulecomment (type: esriFieldTypeString, alias: Violation Comment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• stagedatecomplete (type: esriFieldTypeDate, alias: Stage set up complete, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• bonfire (type: esriFieldTypeString, alias: Bonfire or Open Flame, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fireworks (type: esriFieldTypeString, alias: Fireworks or Pyrotechnics, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• generatornumber (type: esriFieldTypeInteger, alias: How many?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• generatortime (type: esriFieldTypeString, alias: generatortime, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Weekday Day: Monday-Friday, 8AM-4PM], [Weekday Evening: Monday-Thursday, after 4PM], [Weekend: Friday after 4PM-Sunday])
• hasraindate (type: esriFieldTypeString, alias: Event has Rain Date, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• understandstage (type: esriFieldTypeString, alias: Stage Acknowledgment, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes])
• understandclosure (type: esriFieldTypeString, alias: Road Closure Acknowledgment, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes])

Templates:

Name: Special_Events
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• submittype:
• eventnm:
• eventtype:
• tags:
• permitid:
• permitstatus:
• sitemapcomplete:
• safetyplancomplete:
• description:
• sponsor:
• opentopublic:
• attendance: 0
• multiday:
• dailyattendance: 0
• admissionfee:
• donations:
• othercities:
• recurring:
• recurringtype:
• recurringdesc:
• eventdesc:
• sitemaptext:
• understandsitemap:
• datenote:
• multipledays:
• rainlocation:
• concactnote:
• orgname:
• pocname:
• address:
• pocphone:
• pocemail:
• nonprofit:
• nonprofit501c3:
• contact2name:
• contact2phone:
• contact2email:
• dayofcontactnote:
• sameapp:
• docname_read:
• docphone_read:
• docemail_read:
• docname_edit:
• docphone_edit:
• docemail_edit:
• docname:
• docphone:
• docemail:
• foodserved:
• foodprep:
• alcoholserved:
• typeofalcohol:
• alcoholpermit:
• potablewater:
• equipment:
• amusementrides:
• pettingzoos:
• dunktanks:
• ponyrides:
• inflatables:
• tentscanopies:
• canopies:
• supplier:
• structequip:
• boothsbleach:
• banners:
• generators:
• commaspec:
• dprfacility:
• dprrental:
• dprpermit:
• amplifiedsound:
• trashservices:
• trashnote:
• trashinfo:
• restroomsprovided:
• restrooms:
• covidplan:
• alcoholpolice:
• policerequested:
• policehire:
• policejustification:
• privatesecurity:
• agencyname:
• medical:
• medicalnote:
• emt:
• fire:
• firenote:
• roadclosures:
• sidewalkclosures:
• typeofroadclosure:
• requestedroadclosures:
• describeroadclose:
• reservedparking:
• reservedspaces:
• staffparking:
• vendorparking:
• attendeeparking:
• media:
• eventurl:
• notificationprocedure:
• conditions:
• acknowledgmenta:
• acknowledgmentb:
• acknowledgmentc:
• acknowledgmentd:
• eventid:
• permitnum:

Relationships:

• Special_EventComments (0) -- Related To: Special_EventComments (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/21/2026 9:29:40 PM

Schema Last Edit Date: 8/21/2026 9:29:40 PM

Data Last Edit Date: 8/21/2026 9:29:40 PM

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