Name: Education_PublicOutreach_Activities

Display Field: EventName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: f06fa64d351d436e9aa37a4bb92c5e9b

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ED_PO_ID ( type: esriFieldTypeDouble, alias: ED_PO_ID, editable: true, nullable: true, defaultValue: null, modelName: ED_PO_ID )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Address )
• EventLocation ( type: esriFieldTypeString, alias: Education Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EventLocation )
• EventName ( type: esriFieldTypeString, alias: Event Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EventName )
• EventType ( type: esriFieldTypeString, alias: Event Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EventType , Coded Values: [ED: Education (School)] , [PO: Public Outreach (Non-school)] )
• EventSpecifics ( type: esriFieldTypeString, alias: Event Specifics, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EventSpecifics , Coded Values: [Classroom: Classroom Activity] , [Clean-Up: Clean-Up] , [Festival_Booth: Festival_Booth] , ...11 more... )
• ActivitySpecifics ( type: esriFieldTypeString, alias: Activity Specifics, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ActivitySpecifics )
• StartDate ( type: esriFieldTypeDate, alias: Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: StartDate )
• EndDate ( type: esriFieldTypeDate, alias: End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EndDate )
• NumberReached ( type: esriFieldTypeInteger, alias: NumberReached, editable: true, nullable: true, defaultValue: null, modelName: NumberReached )
• Representatives ( type: esriFieldTypeString, alias: Representatives, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Representatives )
• Giveaways ( type: esriFieldTypeString, alias: Giveaways, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaways , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• Giveaway1 ( type: esriFieldTypeString, alias: Giveaway1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway1 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty1 ( type: esriFieldTypeInteger, alias: Qty1, editable: true, nullable: true, defaultValue: null, modelName: Qty1 )
• Giveaway2 ( type: esriFieldTypeString, alias: Giveaway2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway2 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty2 ( type: esriFieldTypeInteger, alias: Qty2, editable: true, nullable: true, defaultValue: null, modelName: Qty2 )
• Giveaway3 ( type: esriFieldTypeString, alias: Giveaway3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway3 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty3 ( type: esriFieldTypeInteger, alias: Qty3, editable: true, nullable: true, defaultValue: null, modelName: Qty3 )
• Giveaway4 ( type: esriFieldTypeString, alias: Giveaway4, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway4 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty4 ( type: esriFieldTypeInteger, alias: Qty4, editable: true, nullable: true, defaultValue: null, modelName: Qty4 )
• Giveaway5 ( type: esriFieldTypeString, alias: Giveaway5, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway5 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty5 ( type: esriFieldTypeInteger, alias: Qty5, editable: true, nullable: true, defaultValue: null, modelName: Qty5 )
• Giveaway6 ( type: esriFieldTypeString, alias: Giveaway6, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway6 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty6 ( type: esriFieldTypeInteger, alias: Qty6, editable: true, nullable: true, defaultValue: null, modelName: Qty6 )
• Giveaway7 ( type: esriFieldTypeString, alias: Giveaway7, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway7 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty7 ( type: esriFieldTypeInteger, alias: Qty7, editable: true, nullable: true, defaultValue: null, modelName: Qty7 )
• Giveaway8 ( type: esriFieldTypeString, alias: Giveaway8, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway8 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty8 ( type: esriFieldTypeInteger, alias: Qty8, editable: true, nullable: true, defaultValue: null, modelName: Qty8 )
• Giveaway9 ( type: esriFieldTypeString, alias: Giveaway9, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway9 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty9 ( type: esriFieldTypeInteger, alias: Qty9, editable: true, nullable: true, defaultValue: null, modelName: Qty9 )
• Giveaway10 ( type: esriFieldTypeString, alias: Giveaway10, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway10 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty10 ( type: esriFieldTypeInteger, alias: Qty10, editable: true, nullable: true, defaultValue: null, modelName: Qty10 )
• Giveaway11 ( type: esriFieldTypeString, alias: Giveaway11, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway11 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty11 ( type: esriFieldTypeInteger, alias: Qty11, editable: true, nullable: true, defaultValue: null, modelName: Qty11 )
• Giveaway12 ( type: esriFieldTypeString, alias: Giveaway12, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway12 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty12 ( type: esriFieldTypeInteger, alias: Qty12, editable: true, nullable: true, defaultValue: null, modelName: Qty12 )
• Giveaway13 ( type: esriFieldTypeString, alias: Giveaway13, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway13 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty13 ( type: esriFieldTypeInteger, alias: Qty13, editable: true, nullable: true, defaultValue: null, modelName: Qty13 )
• Giveaway14 ( type: esriFieldTypeString, alias: Giveaway14, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway14 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty14 ( type: esriFieldTypeInteger, alias: Qty14, editable: true, nullable: true, defaultValue: null, modelName: Qty14 )
• Giveaway15 ( type: esriFieldTypeString, alias: Giveaway15, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway15 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty15 ( type: esriFieldTypeInteger, alias: Qty15, editable: true, nullable: true, defaultValue: null, modelName: Qty15 )
• Giveaway16 ( type: esriFieldTypeString, alias: Giveaway16, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway16 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty16 ( type: esriFieldTypeInteger, alias: Qty16, editable: true, nullable: true, defaultValue: null, modelName: Qty16 )
• Giveaway17 ( type: esriFieldTypeString, alias: Giveaway17, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway17 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty17 ( type: esriFieldTypeInteger, alias: Qty17, editable: true, nullable: true, defaultValue: null, modelName: Qty17 )
• Giveaway18 ( type: esriFieldTypeString, alias: Giveaway18, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway18 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty18 ( type: esriFieldTypeInteger, alias: Qty18, editable: true, nullable: true, defaultValue: null, modelName: Qty18 )
• Giveaway19 ( type: esriFieldTypeString, alias: Giveaway19, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway19 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty19 ( type: esriFieldTypeInteger, alias: Qty19, editable: true, nullable: true, defaultValue: null, modelName: Qty19 )
• Giveaway20 ( type: esriFieldTypeString, alias: Giveaway20, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway20 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty20 ( type: esriFieldTypeInteger, alias: Qty20, editable: true, nullable: true, defaultValue: null, modelName: Qty20 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Giveaway21 ( type: esriFieldTypeString, alias: Giveaway21, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway21 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty21 ( type: esriFieldTypeInteger, alias: Qty21, editable: true, nullable: true, defaultValue: null, modelName: Qty21 )
• Giveaway22 ( type: esriFieldTypeString, alias: Giveaway22, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway22 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty22 ( type: esriFieldTypeInteger, alias: Qty22, editable: true, nullable: true, defaultValue: null, modelName: Qty22 )
• Giveaway23 ( type: esriFieldTypeString, alias: Giveaway23, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway23 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty23 ( type: esriFieldTypeInteger, alias: Qty23, editable: true, nullable: true, defaultValue: null, modelName: Qty23 )
• Giveaway24 ( type: esriFieldTypeString, alias: Giveaway24, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway24 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty24 ( type: esriFieldTypeInteger, alias: Qty24, editable: true, nullable: true, defaultValue: null, modelName: Qty24 )
• Giveaway25 ( type: esriFieldTypeString, alias: Giveaway25, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway25 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty25 ( type: esriFieldTypeInteger, alias: Qty25, editable: true, nullable: true, defaultValue: null, modelName: Qty25 )
• Giveaway26 ( type: esriFieldTypeString, alias: Giveaway26, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway26 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty26 ( type: esriFieldTypeInteger, alias: Qty26, editable: true, nullable: true, defaultValue: null, modelName: Qty26 )
• Giveaway27 ( type: esriFieldTypeString, alias: Giveaway27, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway27 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty27 ( type: esriFieldTypeInteger, alias: Qty27, editable: true, nullable: true, defaultValue: null, modelName: Qty27 )
• Giveaway28 ( type: esriFieldTypeString, alias: Giveaway28, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway28 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty28 ( type: esriFieldTypeInteger, alias: Qty28, editable: true, nullable: true, defaultValue: null, modelName: Qty28 )
• Giveaway29 ( type: esriFieldTypeString, alias: Giveaway29, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway29 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty29 ( type: esriFieldTypeInteger, alias: Qty29, editable: true, nullable: true, defaultValue: null, modelName: Qty29 )
• Giveaway30 ( type: esriFieldTypeString, alias: Giveaway30, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Giveaway30 , Coded Values: [A NEW ITEM: A NEW ITEM] , [ADOPT_DownstreamFriend: ADOPT_DownstreamFriend] , [ADOPT_Keychain: ADOPT_Keychain] , ...57 more... )
• Qty30 ( type: esriFieldTypeInteger, alias: Qty30, editable: true, nullable: true, defaultValue: null, modelName: Qty30 )

Templates:

• Name: Education_PublicOutreach_Activities
  Description:
  Prototype:
  Giveaway30: null
  Qty29: null
  ED_PO_ID: null
  Address: null
  EventLocation: null
  EventName: null
  EventType: null
  EventSpecifics: null
  ActivitySpecifics: null
  StartDate: null
  EndDate: null
  NumberReached: null
  Representatives: null
  Giveaways: null
  Giveaway1: null
  Qty1: null
  Giveaway2: null
  Qty2: null
  Giveaway3: null
  Qty3: null
  Giveaway4: null
  Qty4: null
  Giveaway5: null
  Qty5: null
  Giveaway6: null
  Qty6: null
  Giveaway7: null
  Qty7: null
  Giveaway8: null
  Qty8: null
  Giveaway9: null
  Qty9: null
  Giveaway10: null
  Qty10: null
  Giveaway11: null
  Qty11: null
  Giveaway12: null
  Qty12: null
  Giveaway13: null
  Qty13: null
  Giveaway14: null
  Qty14: null
  Giveaway15: null
  Qty15: null
  Giveaway16: null
  Qty16: null
  Giveaway17: null
  Qty17: null
  Giveaway18: null
  Qty18: null
  Giveaway19: null
  Qty19: null
  Giveaway20: null
  Qty20: null
  Qty30: null
  Giveaway29: null
  Qty28: null
  Giveaway28: null
  Qty27: null
  Giveaway21: null
  Qty21: null
  Giveaway22: null
  Qty22: null
  Giveaway23: null
  Qty23: null
  Giveaway24: null
  Qty24: null
  Giveaway25: null
  Qty25: null
  Giveaway26: null
  Qty26: null
  Giveaway27: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PW_GDB.PWGISEDITOR.PW_GDB_SW_Education_PublicOutreach (0) -- Related To: SW_Education_Outreach (0)

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata