Name: hh_member

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 46a89bc18d2f4db1badb69897a9b0e62

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• uniquerowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: RowID, type: esriFieldTypeGUID )
• first_name1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Name:, type: esriFieldTypeString )
• place_work ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.1.2 Place of work, type: esriFieldTypeString , Coded Values: [a: Not applicable] , [b: Travelled to a place of work] , [c: Worked from home] , ...1 more... )
• place_work_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Specify other, type: esriFieldTypeString )
• main_mode ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.1.3 Main mode of Transport, type: esriFieldTypeString , Coded Values: [1a: Not applicable] , [2a: Walk all the way] , [3a: Commuter taxi/minibus taxi] , ...15 more... )
• main_mode_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Specify other, type: esriFieldTypeString )
• dep_time ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.1.4 Depature Time, type: esriFieldTypeString )
• arr_time ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.1.5 Arrival Time, type: esriFieldTypeString )
• edu ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.2 Travel to Educational Institution – Thinking of your typical weekday before COVID-19, describe each household members' travel patterns to Educational Institution., type: esriFieldTypeString )
• edu_method ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.2.1 Method of Schooling, type: esriFieldTypeString , Coded Values: [NA: Not applicable] , [PC: Physical contact classes] , [OC: Online classes] , ...1 more... )
• edu_mode ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.2.2 Main Mode of Transport, type: esriFieldTypeString , Coded Values: [1a: Not applicable] , [2a: Walk all the way] , [3a: Commuter taxi/minibus taxi] , ...15 more... )
• edu_mode_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Specify other, type: esriFieldTypeString )
• ed_dep_time ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.2.3 Depature Time, type: esriFieldTypeString )
• ed_arr_time ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.2.4 Arrival Time, type: esriFieldTypeString )
• shop ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.3 Travel to Shopping – Thinking of your typical weekday before COVID-19, describe each household members' travel patterns for Shopping., type: esriFieldTypeString )
• shop_method ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.3.1 Method of Shopping, type: esriFieldTypeString , Coded Values: [s1: Go to the shop/mall] , [s2: Online/internet shopping] , [s3: A mix of Going to the shop/mall and online/internet shopping] , ...1 more... )
• shop_mode ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.3.2 Main Mode of Shopping, type: esriFieldTypeString , Coded Values: [1a: Not applicable] , [2a: Walk all the way] , [3a: Commuter taxi/minibus taxi] , ...15 more... )
• shop_mode_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Specify other, type: esriFieldTypeString )
• shop_dep_time ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.3.3 Depature Time, type: esriFieldTypeString )
• shop_arr_time ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.3.4 Arrival Time, type: esriFieldTypeString )
• med ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.4 Travel for Medical Purposes – Thinking of your typical weekday before COVID-19, describe each household members' travel patterns for medical purposes., type: esriFieldTypeString )
• med_mode ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.4.1 Main mode of transport for medical purposes, type: esriFieldTypeString , Coded Values: [1a: Not applicable] , [2a: Walk all the way] , [3a: Commuter taxi/minibus taxi] , ...15 more... )
• med_mode_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Specify other, type: esriFieldTypeString )
• med_dep_time ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.4.2 Depature Time, type: esriFieldTypeString )
• med_arr_time ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.4.3 Arrival Time, type: esriFieldTypeString )
• other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.5 Travel to Other Places – Thinking of your typical weekday before COVID-19, describe each household members' travel patterns to various other places excluding work, school, shopping, and medical purposes?, type: esriFieldTypeString )
• other_explained ( nullable: true, editable: true, defaultValue: null, length: 255, alias: "Other places" refer to visits to family and friends, worship, municipality, etc., type: esriFieldTypeString )
• other_trip ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.5.1 Choose one other frequent trip purpose?, type: esriFieldTypeString )
• other_trip_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Specify other, type: esriFieldTypeString )
• other_mode ( nullable: true, editable: true, defaultValue: null, length: 255, alias: 2.5.2 Mode of Transport for Other Trip Purposes, type: esriFieldTypeString )
• other_mode_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Specify other, type: esriFieldTypeString )
• current_travel ( nullable: true, editable: true, defaultValue: null, length: 255, alias: CURRENT HOUSEHOLD TRAVEL PATTERNS, type: esriFieldTypeString )
• num_hh_members2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Number of household Members, type: esriFieldTypeString )
• curr_work_travel_count ( nullable: true, editable: true, defaultValue: null, length: 255, alias: curr_work_travel_count, type: esriFieldTypeString )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Relationships:

• hh_attributes_hh_member (3) -- Related To: hh_attributes (1)
• hh_member_curr_work_travel (4) -- Related To: curr_work_travel (3)

Capabilities: Create,Editing,Uploads,Sync

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: 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: true

Supported Operations:   Apply Edits   Add Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata