Name: Special Events

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: -117.255589999986
YMin: 33.982379999996
XMax: -117.109589999986
YMax: 34.128379999996
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"SpecialEvents","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

Time Info:

Start Time Field: setup
End Time Field: takedown
Track ID Field: null
Time Extent
[11/22/2019 3:15:00 PM UTC, 10/20/2020 6:30:00 PM UTC]

Time Reference: UTC
Time Interval: 0
Time Interval Units:
Has Live Data: false
Export Options:

Use Time: false
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies

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)
• submittype (type: esriFieldTypeString, alias: submittype, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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], [Charityorfundraiser: Charity or Fundraiser], [Childrenorfamily: Children or Family], ... 18 more ...)
• 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], [Approved: Approved], ... 3 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])
• eventurl (type: esriFieldTypeString, alias: Website, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 1000, 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)
• admissionfee (type: esriFieldTypeString, alias: Admission fee, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sponsor (type: esriFieldTypeString, alias: Event Sponsors, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• recurring (type: esriFieldTypeString, alias: Is this a reoccurring 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: Reoccuring Description, SQL Type: sqlTypeOther, length: 150, 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: 255, nullable: true, editable: true)
• eventstart (type: esriFieldTypeDate, alias: Event Start, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• eventend (type: esriFieldTypeDate, alias: Event End, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• takedown (type: esriFieldTypeDate, alias: Setup End, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• concactnote (type: esriFieldTypeString, alias: Setup Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pocname (type: esriFieldTypeString, alias: Point of Contact Name, SQL Type: sqlTypeOther, length: 150, 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)
• address (type: esriFieldTypeString, alias: Business/Organization address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nonprofit (type: esriFieldTypeString, alias: What type of organization is this?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [nonprofit: Non-profit], [buisiness: Business/Organization])
• 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, Coded Values: [Yes: Yes], [No: No])
• 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)
• foodtrucks (type: esriFieldTypeInteger, alias: Number of food trucks, SQL Type: sqlTypeOther, nullable: true, editable: true)
• alcoholserved (type: esriFieldTypeString, alias: Food, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• potablewater (type: esriFieldTypeString, alias: Will you provide potable water?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• 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: Temporary Buildings, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• installdate (type: esriFieldTypeDate, alias: Date installed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dateremoved (type: esriFieldTypeDate, alias: Date removed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• supplier (type: esriFieldTypeString, alias: Supplier name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• structequip (type: esriFieldTypeString, alias: Please list all that apply, 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)
• film (type: esriFieldTypeString, alias: Film, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• commaspec (type: esriFieldTypeString, alias: Other Structures, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• amplifiedsound (type: esriFieldTypeString, alias: Will there be amplified sound?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• ampsoundstart (type: esriFieldTypeDate, alias: Amplified Sound, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ampsoundend (type: esriFieldTypeDate, alias: Amplified sound end time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• trashservices (type: esriFieldTypeString, alias: Will trash services be provided?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• 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?, 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)
• 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])
• numberofprivatesecurity (type: esriFieldTypeInteger, alias: Number of personnel, SQL Type: sqlTypeOther, nullable: true, editable: true)
• agencyname (type: esriFieldTypeString, alias: From what agency?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• policerequested (type: esriFieldTypeString, alias: Requesting Police, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• policejustification (type: esriFieldTypeString, alias: Requesting Police Justification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• medical (type: esriFieldTypeString, alias: Will private medical be provided?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• numberprivatemedical (type: esriFieldTypeInteger, alias: Number of personnel, SQL Type: sqlTypeOther, nullable: true, editable: true)
• emt (type: esriFieldTypeString, alias: Emergency Medical Services, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fire (type: esriFieldTypeString, alias: Fireoworks or flames?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• 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])
• 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: Road closure start, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• roadcloseend (type: esriFieldTypeDate, alias: Road closure end, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• describeroadclose (type: esriFieldTypeString, alias: Please describe activites 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)
• 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)
• submitdt (type: esriFieldTypeDate, alias: Submission Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• eventid (type: esriFieldTypeString, alias: Event ID for joins, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• paymentstatus (type: esriFieldTypeString, alias: paymentstatus, 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)

Templates:

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

Attributes:

Relationships:

• SpecialEvents_SpecialEventComments (1) -- Related To: SpecialEventComments (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/17/2020 5:01:32 PM

Schema Last Edit Date: 9/17/2020 5:01:32 PM

Data Last Edit Date: 9/17/2020 5:01:32 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