Name: Static Indicator Data Table

Display Field:

Type: Table

Description: <div>This Table includes the supporting statistics used to calculate several system indicators presented in the System Performance Dashboard that are static in nature (i.e., not filterable in the Dashboard). The statistics include indicators of the system’s activity, available aircraft services, and pilots based in Minnesota.</div><div><br /></div><div>Refer to the MnSASP Hub User's Guide and the 2022 MnSASP Final Technical Report (Chapter 6. Continuous Aviation Planning) for more information on the MnSASP Hub including a complete list of all data sources and data update frequency (varied across all presented data points). Questions about the MnSASP Hub or the MnSASP study can also be directed to Rylan Juran (MnDOT Aeronautics Airport Planning Director) at rylan.juran@state.mn.us or (651)-234-7190. </div><div><br /></div><div>The State of Minnesota makes no representations or warranties expressed or implied, with respect to the reuse of the data provided herewith regardless of its format or the means of its transmission. There is no guarantee or representation to the user as to the accuracy, currency, suitability, or reliability of this data for any purpose. The user accepts the data “as is.&quot; The State of Minnesota assumes no responsibility for loss or damage incurred as a result of any user’s reliance on this data. All maps and other material provided herein are protected by copyright. Permission is granted to copy and use the materials herein.<br /></div>

Copyright Text: Refer to the MnSASP Hub User's Guide and the 2022 MnSASP Final Technical Report (Chapter 6. Continuous Aviation Planning) for more information on the MnSASP Hub including a complete list of all data sources and data update frequency (varied across all presented data points).

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:

• IndicatorData (type: esriFieldTypeString, alias: IndicatorData, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MROAirportProximity (type: esriFieldTypeInteger, alias: MRO Proximity, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• CSAirportProximity (type: esriFieldTypeInteger, alias: CS Airport Proximity, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• CertifiedPilots (type: esriFieldTypeInteger, alias: Certified Pilots, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• RegisteredAC (type: esriFieldTypeInteger, alias: Registered AC, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• FuelProximity (type: esriFieldTypeInteger, alias: Fuel Proximity, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• TotalSystem (type: esriFieldTypeInteger, alias: Total System, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• FID (type: esriFieldTypeOID, alias: FID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• Fatalities (type: esriFieldTypeInteger, alias: Aviation Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AviationAccidents (type: esriFieldTypeInteger, alias: Aviation Accidents, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RunwayIncursions (type: esriFieldTypeInteger, alias: Runway Incursions, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalPopulation (type: esriFieldTypeInteger, alias: Total MN Population, SQL Type: sqlTypeOther, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/19/2022 7:33:43 PM

Schema Last Edit Date: 5/19/2022 7:33:43 PM

Data Last Edit Date: 5/19/2022 7:33:43 PM

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