Name: HHTSAggregate_Table

Display Field: O_PURPOSE

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)
• LINKTRIPID (type: esriFieldTypeString, alias: LINKTRIPID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HH_ID (type: esriFieldTypeInteger, alias: HH_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSON_ID (type: esriFieldTypeBigInteger, alias: PERSON_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DAY_ID (type: esriFieldTypeBigInteger, alias: DAY_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• O_PURPOSE (type: esriFieldTypeString, alias: O_PURPOSE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D_PURPOSE (type: esriFieldTypeString, alias: D_PURPOSE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TRIP_MODE (type: esriFieldTypeString, alias: TRIP_MODE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• O_PUR_AGG1 (type: esriFieldTypeString, alias: O_PUR_AGG1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• O_PUR_AGG1_VALUE (type: esriFieldTypeInteger, alias: Trip Origin 1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Home], [2: Work / Volunteer / Civic], [3: School/School Related], ... 7 more ...)
• O_PUR_AGG1_VALUE_DISPLAY (type: esriFieldTypeString, alias: O_PUR_AGG1_VALUE_DISPLAY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• O_PUR_AGG2 (type: esriFieldTypeString, alias: O_PUR_AGG2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• O_PUR_AGG2_VALUE (type: esriFieldTypeInteger, alias: Trip Origin, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Home], [2: Work / Volunteer / Civic], [3: School/School Related], ... 4 more ...)
• O_PUR_AGG2_VALUE_DISPLAY (type: esriFieldTypeString, alias: O_PUR_AGG2_VALUE_DISPLAY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D_PUR_AGG1 (type: esriFieldTypeString, alias: D_PUR_AGG1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D_PUR_AGG1_VALUE (type: esriFieldTypeInteger, alias: Trip Destination 1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Home], [2: Work / Volunteer / Civic], [3: School/School Related], ... 7 more ...)
• D_PUR_AGG1_VALUE_DISPLAY (type: esriFieldTypeString, alias: D_PUR_AGG1_VALUE_DISPLAY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D_PUR_AGG2 (type: esriFieldTypeString, alias: D_PUR_AGG2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D_PUR_AGG2_VALUE (type: esriFieldTypeInteger, alias: Trip Destination, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Home], [2: Work / Volunteer / Civic], [3: School/School Related], ... 4 more ...)
• D_PUR_AGG2_VALUE_DISPLAY (type: esriFieldTypeString, alias: D_PUR_AGG2_VALUE_DISPLAY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MODE_AGG1 (type: esriFieldTypeString, alias: MODE_AGG1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MODE_AGG1_VALUE (type: esriFieldTypeInteger, alias: Travel Mode 1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Single occupancy vehicles], [2: High occupancy vehicles], [3: Regional Transit], ... 7 more ...)
• MODE_AGG1_VALUE_DISPLAY (type: esriFieldTypeString, alias: MODE_AGG1_VALUE_DISPLAY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MODE_AGG2 (type: esriFieldTypeString, alias: MODE_AGG2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MODE_AGG2_VALUE (type: esriFieldTypeInteger, alias: Travel Mode, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Automobile], [2: Transit], [3: Walk/Bike], ... 3 more ...)
• MODE_AGG2_VALUE_DISPLAY (type: esriFieldTypeString, alias: MODE_AGG2_VALUE_DISPLAY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HOME_CNTY (type: esriFieldTypeInteger, alias: HOME_CNTY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HOME_COUNTY (type: esriFieldTypeString, alias: HOME_COUNTY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HOME_MUNICIPALITY (type: esriFieldTypeString, alias: HOME_MUNICIPALITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HOME_LON (type: esriFieldTypeInteger, alias: HOME_LON, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HOME_LAT (type: esriFieldTypeInteger, alias: HOME_LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HOME_MPO (type: esriFieldTypeString, alias: HOME_MPO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HOME_TOWN (type: esriFieldTypeString, alias: HOME_TOWN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NUM_PEOPLE (type: esriFieldTypeString, alias: NUM_PEOPLE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NUM_WORK (type: esriFieldTypeString, alias: NUM_WORK, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NUM_VEH (type: esriFieldTypeString, alias: NUM_VEH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INCOME_BRD (type: esriFieldTypeString, alias: INCOME_BRD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HH_WEIGHT (type: esriFieldTypeString, alias: HH_WEIGHT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HHSIZE_AGG (type: esriFieldTypeString, alias: HHSIZE_AGG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HHSIZE_AGG_VALUE (type: esriFieldTypeInteger, alias: Number of Household members, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1 person], [2: 2 people], [3: 3 people], ... 1 more ...)
• HHSIZE_AGG_VALUE_DISPLAY (type: esriFieldTypeString, alias: HHSIZE_AGG_VALUE_DISPLAY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WORKER_AGG (type: esriFieldTypeString, alias: WORKER_AGG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WORKER_AGG_VALUE (type: esriFieldTypeInteger, alias: Number of workers, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 0 workers], [2: 1 worker], [3: 2 workers], ... 1 more ...)
• WORKER_AGG_VALUE_DISPLAY (type: esriFieldTypeString, alias: WORKER_AGG_VALUE_DISPLAY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NUMVEH_AGG (type: esriFieldTypeString, alias: NUMVEH_AGG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NUMVEH_AGG_VALUE (type: esriFieldTypeInteger, alias: Number of vehicles, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 0 vehicles], [2: 1 vehicle], [3: 2 vehicles], ... 1 more ...)
• NUMVEH_AGG_VALUE_DISPLAY (type: esriFieldTypeString, alias: NUMVEH_AGG_VALUE_DISPLAY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INCOME_AGG (type: esriFieldTypeString, alias: INCOME_AGG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INCOME_AGG_VALUE (type: esriFieldTypeInteger, alias: Income, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Under $25,000], [2: $25,000-$49,999], [3: $50,000 to $99,999], ... 3 more ...)
• INCOME_AGG_VALUE_DISPLAY (type: esriFieldTypeString, alias: INCOME_AGG_VALUE_DISPLAY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AGE (type: esriFieldTypeString, alias: AGE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AFRICAN_AMERICAN_OR_BLACK (type: esriFieldTypeInteger, alias: AFRICAN_AMERICAN_OR_BLACK, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AMERICAN_INDIAN_OR_ALASKA_NATIVE (type: esriFieldTypeInteger, alias: AMERICAN_INDIAN_OR_ALASKA_NATIVE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASIAN (type: esriFieldTypeInteger, alias: ASIAN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NATIVE_HAWAIIAN_OR_OTHER_PACIFIC_ISLANDER (type: esriFieldTypeInteger, alias: NATIVE_HAWAIIAN_OR_OTHER_PACIFIC_ISLANDER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WHITE (type: esriFieldTypeInteger, alias: WHITE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OTHER_RACE (type: esriFieldTypeInteger, alias: OTHER_RACE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GENDER (type: esriFieldTypeString, alias: GENDER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PER_WEIGHT (type: esriFieldTypeString, alias: PER_WEIGHT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AGE_AGG (type: esriFieldTypeString, alias: AGE_AGG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AGE_AGG_VALUE (type: esriFieldTypeInteger, alias: Age, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Children <5], [2: Children (5-17)], [3: Young Adult (18-24)], ... 3 more ...)
• AGE_AGG_VALUE_DISPLAY (type: esriFieldTypeString, alias: AGE_AGG_VALUE_DISPLAY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RACE_AGG (type: esriFieldTypeString, alias: RACE_AGG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RACE_AGG_VALUE (type: esriFieldTypeInteger, alias: Race, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: African Amercian or Black], [2: American Indian or Alaska Native/Native Hawaiian or other Pacific Islander], [3: Asian], ... 4 more ...)
• RACE_AGG_VALUE_DISPLAY (type: esriFieldTypeString, alias: RACE_AGG_VALUE_DISPLAY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GENDER_AGG (type: esriFieldTypeString, alias: GENDER_AGG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GENDER_AGG_VALUE (type: esriFieldTypeInteger, alias: Gender, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Female], [2: Male], [3: Non-binary], ... 2 more ...)
• GENDER_AGG_VALUE_DISPLAY (type: esriFieldTypeString, alias: GENDER_AGG_VALUE_DISPLAY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ETL_BATCH_ID (type: esriFieldTypeString, alias: ETL_BATCH_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ETL_INSERT_BY (type: esriFieldTypeString, alias: ETL_INSERT_BY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ETL_INSERT_TIMESTAMP (type: esriFieldTypeDate, alias: ETL_INSERT_TIMESTAMP, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ETL_UPDATE_TIMESTAMP (type: esriFieldTypeDate, alias: ETL_UPDATE_TIMESTAMP, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Column1 (type: esriFieldTypeBigInteger, alias: Column1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRIPWEIGHT (type: esriFieldTypeDouble, alias: Trip Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: HHTSAggregate_Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/24/2026 5:55:16 PM

Schema Last Edit Date: 7/24/2026 4:42:28 PM

Data Last Edit Date: 7/24/2026 5:55:16 PM

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