Name: ElectionResults_JoinTable

Display Field: jurisdictionname

Type: Table

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

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: globalid

Type ID Field:

Fields:

• contest (type: esriFieldTypeString, alias: Contest, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• category (type: esriFieldTypeString, alias: Contest Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Elected Office: Elected Office], [Proposition: Proposition])
• jurisdictionname (type: esriFieldTypeString, alias: Jurisdiction Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• candidate (type: esriFieldTypeString, alias: Candidate, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• party (type: esriFieldTypeString, alias: Party, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Liberal Party: L], [Progressive Conservative Party: PC], [Green Party of New Brunswick: PVNBGP], ... 6 more ...)
• round (type: esriFieldTypeInteger, alias: Round, SQL Type: sqlTypeOther, nullable: true, editable: true)
• numvotes (type: esriFieldTypeInteger, alias: Number of Votes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• DIST_ID (type: esriFieldTypeString, alias: DIST_ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• P_ID (type: esriFieldTypeString, alias: P_ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Seats (type: esriFieldTypeInteger, alias: Seats, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Electoral_District (type: esriFieldTypeString, alias: Electoral_District, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• jurisdictionname_1730223281857 (type: esriFieldTypeString, alias: Jurisdiction Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• jurisdictiontype (type: esriFieldTypeString, alias: Jurisdiction Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Electoral Districts: Electoral Districts], [Polling Divisions: Polling Divisions])
• regvoters (type: esriFieldTypeInteger, alias: Registered Voters, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ballotscast (type: esriFieldTypeInteger, alias: Ballots Cast, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mail (type: esriFieldTypeInteger, alias: Mail-in Ballots, SQL Type: sqlTypeOther, nullable: true, editable: true)
• earlyvote (type: esriFieldTypeInteger, alias: Early Voting, In Person Ballots, SQL Type: sqlTypeOther, nullable: true, editable: true)
• electionday (type: esriFieldTypeInteger, alias: Election Day Ballots, SQL Type: sqlTypeOther, nullable: true, editable: true)
• reported (type: esriFieldTypeDouble, alias: Percent Reported, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 100])
• globalid_1730223281857 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_date_1730223281857 (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• created_user_1730223281857 (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• last_edited_date_1730223281857 (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user_1730223281857 (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeOther, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeOther, nullable: true, editable: false)
• DIST_ID_1730223281857 (type: esriFieldTypeString, alias: DIST_ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• P_ID_1730223281857 (type: esriFieldTypeString, alias: P_ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Electoral_District_1730223281857 (type: esriFieldTypeString, alias: Electoral_District, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/23/2025 6:08:40 PM

Schema Last Edit Date: 10/29/2024 4:50:41 PM

Data Last Edit Date: 10/29/2024 5:21:05 PM

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