Name: Special Events

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: 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 (0)

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 Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat