Name: Sentiment_Table

Display Field: Survey_ID

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Survey_ID (type: esriFieldTypeInteger, alias: Survey ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Gender (type: esriFieldTypeString, alias: Gender, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Race (type: esriFieldTypeString, alias: Race, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Age (type: esriFieldTypeString, alias: Age, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Ethnicity (type: esriFieldTypeString, alias: Ethnicity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Zip_Code (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ZipCodeText (type: esriFieldTypeInteger, alias: ZipCodeText, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Employment (type: esriFieldTypeString, alias: Employment, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Education (type: esriFieldTypeString, alias: Education, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• OccupancyStatus (type: esriFieldTypeString, alias: OccupancyStatus, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Income (type: esriFieldTypeString, alias: Income, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Important1 (type: esriFieldTypeString, alias: Important1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EnergyQ1 (type: esriFieldTypeString, alias: EnergyQ1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EnergyQ2 (type: esriFieldTypeString, alias: EnergyQ2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EnergyQ3 (type: esriFieldTypeString, alias: EnergyQ3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PlanningQ1 (type: esriFieldTypeString, alias: PlanningQ1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PlanningQ2 (type: esriFieldTypeString, alias: PlanningQ2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PlanningQ3 (type: esriFieldTypeString, alias: PlanningQ3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PlanningQ4 (type: esriFieldTypeString, alias: PlanningQ4, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TransportQ1 (type: esriFieldTypeString, alias: TransportQ1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TransportQ2 (type: esriFieldTypeString, alias: TransportQ2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TransportQ3 (type: esriFieldTypeString, alias: TransportQ3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TransportQ4 (type: esriFieldTypeString, alias: TransportQ4, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WasteQ1 (type: esriFieldTypeString, alias: WasteQ1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WasteQ2 (type: esriFieldTypeString, alias: WasteQ2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WasteQ3 (type: esriFieldTypeString, alias: WasteQ3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CCHazardsQ1 (type: esriFieldTypeString, alias: CCHazardsQ1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CCHazardsQ2 (type: esriFieldTypeString, alias: CCHazardsQ2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CCHazardsQ3 (type: esriFieldTypeString, alias: CCHazardsQ3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CCHazardsQ4 (type: esriFieldTypeString, alias: CCHazardsQ4, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CCHazardsQ5 (type: esriFieldTypeString, alias: CCHazardsQ5, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CCHazardsQ6 (type: esriFieldTypeString, alias: CCHazardsQ6, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CCHazardsQ7 (type: esriFieldTypeString, alias: CCHazardsQ7, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CCHazardsQ8 (type: esriFieldTypeString, alias: CCHazardsQ8, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ImplementQ1 (type: esriFieldTypeString, alias: ImplementQ1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ImplementQ2 (type: esriFieldTypeString, alias: ImplementQ2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ImplementQ3 (type: esriFieldTypeString, alias: ImplementQ3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ImplementQ4 (type: esriFieldTypeString, alias: ImplementQ4, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ImplementQ5 (type: esriFieldTypeString, alias: ImplementQ5, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Important2 (type: esriFieldTypeString, alias: Important2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EquityQ1 (type: esriFieldTypeString, alias: EquityQ1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EquityQ2 (type: esriFieldTypeString, alias: EquityQ2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EquityQ3 (type: esriFieldTypeString, alias: EquityQ3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EquityQ4 (type: esriFieldTypeString, alias: EquityQ4, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EquityQ5 (type: esriFieldTypeString, alias: EquityQ5, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EquityQ6 (type: esriFieldTypeString, alias: EquityQ6, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EquityQ7 (type: esriFieldTypeString, alias: EquityQ7, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EquityQ8 (type: esriFieldTypeString, alias: EquityQ8, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EquityQ9 (type: esriFieldTypeString, alias: EquityQ9, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SupportQ1 (type: esriFieldTypeString, alias: SupportQ1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SupportQ2 (type: esriFieldTypeString, alias: SupportQ2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SupportQ3 (type: esriFieldTypeString, alias: SupportQ3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SupportQ4 (type: esriFieldTypeString, alias: SupportQ4, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SupportQ5 (type: esriFieldTypeString, alias: SupportQ5, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SupportQ6 (type: esriFieldTypeString, alias: SupportQ6, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ParticipateQ1 (type: esriFieldTypeString, alias: ParticipateQ1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ParticipateQ2 (type: esriFieldTypeString, alias: ParticipateQ2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ParticipateQ3 (type: esriFieldTypeString, alias: ParticipateQ3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ParticipateQ4 (type: esriFieldTypeString, alias: ParticipateQ4, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ParticipateQ5 (type: esriFieldTypeString, alias: ParticipateQ5, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ParticipateQ6 (type: esriFieldTypeString, alias: ParticipateQ6, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Important1_SCORE (type: esriFieldTypeInteger, alias: Important1-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EnergyQ1_SCORE (type: esriFieldTypeString, alias: EnergyQ1-SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EnergyQ2_SCORE (type: esriFieldTypeString, alias: EnergyQ2-SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EnergyQ3_SCORE (type: esriFieldTypeString, alias: EnergyQ3-SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PlanningQ1_SCORE (type: esriFieldTypeDouble, alias: PlanningQ1-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PlanningQ2_SCORE (type: esriFieldTypeDouble, alias: PlanningQ2-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PlanningQ3_SCORE (type: esriFieldTypeDouble, alias: PlanningQ3-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PlanningQ4_SCORE (type: esriFieldTypeDouble, alias: PlanningQ4-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TransportQ1_SCORE (type: esriFieldTypeDouble, alias: TransportQ1-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TransportQ2_SCORE (type: esriFieldTypeDouble, alias: TransportQ2-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TransportQ3_SCORE (type: esriFieldTypeDouble, alias: TransportQ3-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TransportQ4_SCORE (type: esriFieldTypeDouble, alias: TransportQ4-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WasteQ1_SCORE (type: esriFieldTypeDouble, alias: WasteQ1-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WasteQ2_SCORE (type: esriFieldTypeDouble, alias: WasteQ2-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WasteQ3_SCORE (type: esriFieldTypeDouble, alias: WasteQ3-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CCHazardsQ1_SCORE (type: esriFieldTypeInteger, alias: CCHazardsQ1-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CCHazardsQ2_SCORE (type: esriFieldTypeInteger, alias: CCHazardsQ2-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CCHazardsQ3_SCORE (type: esriFieldTypeInteger, alias: CCHazardsQ3-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CCHazardsQ4_SCORE (type: esriFieldTypeInteger, alias: CCHazardsQ4-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CCHazardsQ5_SCORE (type: esriFieldTypeInteger, alias: CCHazardsQ5-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CCHazardsQ6_SCORE (type: esriFieldTypeInteger, alias: CCHazardsQ6-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CCHazardsQ7_SCORE (type: esriFieldTypeInteger, alias: CCHazardsQ7-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CCHazardsQ8_SCORE (type: esriFieldTypeInteger, alias: CCHazardsQ8-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ImplementQ1_SCORE (type: esriFieldTypeInteger, alias: ImplementQ1-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ImplementQ2_SCORE (type: esriFieldTypeInteger, alias: ImplementQ2-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ImplementQ3_SCORE (type: esriFieldTypeInteger, alias: ImplementQ3-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ImplementQ4_SCORE (type: esriFieldTypeInteger, alias: ImplementQ4-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ImplementQ5_SCORE (type: esriFieldTypeInteger, alias: ImplementQ5-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Important2_SCORE (type: esriFieldTypeInteger, alias: Important2-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EquityQ1_SCORE (type: esriFieldTypeDouble, alias: EquityQ1-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EquityQ2_SCORE (type: esriFieldTypeDouble, alias: EquityQ2-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EquityQ4_SCORE (type: esriFieldTypeDouble, alias: EquityQ4-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EquityQ5_SCORE (type: esriFieldTypeDouble, alias: EquityQ5-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EquityQ6_SCORE (type: esriFieldTypeDouble, alias: EquityQ6-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EquityQ7_SCORE (type: esriFieldTypeDouble, alias: EquityQ7-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EquityQ8_SCORE (type: esriFieldTypeDouble, alias: EquityQ8-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EquityQ9_SCORE (type: esriFieldTypeDouble, alias: EquityQ9-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SupportQ1_SCORE (type: esriFieldTypeDouble, alias: SupportQ1-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SupportQ2_SCORE (type: esriFieldTypeDouble, alias: SupportQ2-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SupportQ3_SCORE (type: esriFieldTypeDouble, alias: SupportQ3-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SupportQ4_SCORE (type: esriFieldTypeDouble, alias: SupportQ4-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SupportQ5_SCORE (type: esriFieldTypeDouble, alias: SupportQ5-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ParticipateQ1_SCORE (type: esriFieldTypeString, alias: ParticipateQ1-SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ParticipateQ2_SCORE (type: esriFieldTypeString, alias: ParticipateQ2-SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ParticipateQ4_SCORE (type: esriFieldTypeString, alias: ParticipateQ4-SCORE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ParticipateQ5_SCORE (type: esriFieldTypeInteger, alias: ParticipateQ5-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ParticipateQ6_SCORE (type: esriFieldTypeInteger, alias: ParticipateQ6-SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ZipText (type: esriFieldTypeString, alias: ZipText, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• C1_Sort (type: esriFieldTypeInteger, alias: C1_Sort, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comment1 (type: esriFieldTypeString, alias: Comment1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• C1_Score (type: esriFieldTypeString, alias: C1_Score, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• C1_sentiment (type: esriFieldTypeString, alias: C1_sentiment, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• C2_Sort (type: esriFieldTypeInteger, alias: C2_Sort, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comment2 (type: esriFieldTypeString, alias: Comment2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• C2_Score (type: esriFieldTypeInteger, alias: C2_Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C2_sentiment (type: esriFieldTypeString, alias: C2_sentiment, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• C3_sort (type: esriFieldTypeInteger, alias: C3_sort, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comment3 (type: esriFieldTypeString, alias: Comment3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• C3_Score (type: esriFieldTypeInteger, alias: C3_Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C3_sentiment (type: esriFieldTypeString, alias: C3_sentiment, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• C4_Sort (type: esriFieldTypeInteger, alias: C4_Sort, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comment4 (type: esriFieldTypeString, alias: Comment4, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• C4_Score (type: esriFieldTypeInteger, alias: C4_Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C4_sentiment (type: esriFieldTypeString, alias: C4_sentiment, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• C5_Sort (type: esriFieldTypeInteger, alias: C5_Sort, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comment5 (type: esriFieldTypeString, alias: Comment5, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• C5_Score (type: esriFieldTypeInteger, alias: C5_Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C5_sentiment (type: esriFieldTypeString, alias: C5_sentiment, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• C1_Photo (type: esriFieldTypeString, alias: C1_Photo, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• C1_neutral (type: esriFieldTypeString, alias: C1_neutral, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• Comment__negative (type: esriFieldTypeInteger, alias: Comment#_negative, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comment__positive (type: esriFieldTypeInteger, alias: Comment#_positive, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comment__mixed (type: esriFieldTypeInteger, alias: Comment#_mixed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comment__neutral (type: esriFieldTypeInteger, alias: Comment#_neutral, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C1_negative (type: esriFieldTypeInteger, alias: C1_negative, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C1_positive (type: esriFieldTypeInteger, alias: C1_positive, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C1_mixed (type: esriFieldTypeInteger, alias: C1_mixed, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Sentiment_Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• Sentiment (0) -- Related To: Sentiment (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/9/2022 10:44:29 PM

Schema Last Edit Date: 5/9/2022 10:44:29 PM

Data Last Edit Date: 5/9/2022 10:44:29 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat