Name: Amtrak_StationActivitybyYear

Display Field:

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

Unique ID Field:

Name : FID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• Station (type: esriFieldTypeString, alias: Station, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F_FY16_ON_ (type: esriFieldTypeInteger, alias: FY16 On, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F_FY16_OFF_ (type: esriFieldTypeInteger, alias: FY16 Off, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F_FY16_TOTAL_ (type: esriFieldTypeInteger, alias: FY16 Total, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F_FY17_ON_ (type: esriFieldTypeString, alias: FY17 On, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F_FY17_OFF_ (type: esriFieldTypeString, alias: FY17 Off, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F_FY17_TOTAL_ (type: esriFieldTypeString, alias: FY17 Total, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F_FY18_ON_ (type: esriFieldTypeString, alias: FY18 On, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F_FY18_OFF_ (type: esriFieldTypeString, alias: FY18 Off, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F_FY18_TOTAL_ (type: esriFieldTypeString, alias: FY18 Total, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F_FY19_ON_ (type: esriFieldTypeString, alias: FY19 On, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F_FY19_OFF_ (type: esriFieldTypeString, alias: FY19 Off, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F_FY19_TOTAL_ (type: esriFieldTypeString, alias: FY19 Total, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F_FY20_ON_ (type: esriFieldTypeString, alias: FY20 On, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F_FY20_OFF_ (type: esriFieldTypeString, alias: FY20 Off, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F_FY20_TOTAL_ (type: esriFieldTypeString, alias: FY20 Total, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• F_FY16toFY20_SumOn_ (type: esriFieldTypeInteger, alias: FY16-FY20 Sum On, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F_FY16toFY20_SumOff_ (type: esriFieldTypeInteger, alias: FY16-FY20 Sum Off, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F_FY16toFY20_SumAll_ (type: esriFieldTypeInteger, alias: FY16-FY20 Sum All, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• YEAR (type: esriFieldTypeInteger, alias: Year, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• FY16_Pct (type: esriFieldTypeDouble, alias: FY16 (%), SQL Type: sqlTypeFloat, nullable: true, editable: true)
• FY17_Pct (type: esriFieldTypeString, alias: FY17 (%), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FY18_Pct (type: esriFieldTypeString, alias: FY18 (%), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FY19_PCT (type: esriFieldTypeString, alias: FY19 (%), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• fy20_PCT (type: esriFieldTypeString, alias: FY20 (%), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• fy16_fy20_pct (type: esriFieldTypeDouble, alias: FY16-FY20 (%), SQL Type: sqlTypeFloat, nullable: true, editable: true)
• FID (type: esriFieldTypeOID, alias: FID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/8/2021 7:45:03 PM

Schema Last Edit Date: 12/8/2021 7:45:03 PM

Data Last Edit Date: 12/8/2021 7:45:03 PM

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