Layers:

Layer: SCUDGIS.DBO.GasMeasurementDevice (0)

Name: SCUDGIS.DBO.GasMeasurementDevice

Display Field: Station_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 2606601.2689633816
YMin: 519662.56506606936
XMax: 2731370.25827004
YMax: 615447.0889198184
Spatial Reference: 102736  (2274)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Station_ID ( type: esriFieldTypeString, alias: Talon SQL Unique ID, length: 50 )
• DeviceFieldID ( type: esriFieldTypeString, alias: Device Site ID (Part of Serial #), length: 50 )
• FacilityID ( type: esriFieldTypeString, alias: Facility Name, length: 80 )
• SortNumber ( type: esriFieldTypeString, alias: Sort Number for System Flow, length: 50 )
• Manufacturer ( type: esriFieldTypeString, alias: Manufactuer, length: 50 )
• ManufacturerModel ( type: esriFieldTypeString, alias: Manufacturer Model, length: 50 )
• DB_Config ( type: esriFieldTypeString, alias: Device Database Number, length: 50 )
• DeviceComments ( type: esriFieldTypeString, alias: Device Comments, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number (Full), length: 50 )
• LocationDescription ( type: esriFieldTypeString, alias: Location Description, length: 100 )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• InServiceDate ( type: esriFieldTypeDate, alias: InServiceDate, length: 8 )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 50 )
• ProjectNumber ( type: esriFieldTypeString, alias: Project Number, length: 50 )
• FacilityStatus ( type: esriFieldTypeString, alias: Facility Status, length: 50 )
• OperationalStatus ( type: esriFieldTypeString, alias: Operational Status, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Misc. Comments, length: 100 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• StationID ( type: esriFieldTypeDouble, alias: StationID )
• Pressure__1 ( type: esriFieldTypeDouble, alias: Pressure #1 )
• Gas_Temperature ( type: esriFieldTypeDouble, alias: Gas Temperature )
• Case_Temperature ( type: esriFieldTypeDouble, alias: Case Temperature )
• Maximum_Pressure__1 ( type: esriFieldTypeDouble, alias: Maximum Pressure #1 )
• Maximum_Pressure__1_Time ( type: esriFieldTypeDouble, alias: Maximum Pressure #1 Time )
• Maximum_Pressure__1_Date ( type: esriFieldTypeDouble, alias: Maximum Pressure #1 Date )
• Minimum_Pressure__1 ( type: esriFieldTypeDouble, alias: Minimum Pressure #1 )
• Minimum_Pressure__1_Time ( type: esriFieldTypeDouble, alias: Minimum Pressure #1 Time )
• Minimum_Pressure__1_Date ( type: esriFieldTypeDouble, alias: Minimum Pressure #1 Date )
• RTU_Wake_Up_Count ( type: esriFieldTypeDouble, alias: RTU Wake Up Count )
• RTU_Time__HHMMSS_ ( type: esriFieldTypeDouble, alias: RTU Time (HHMMSS) )
• RTU_Date__MMDDYY_ ( type: esriFieldTypeDouble, alias: RTU Date (MMDDYY) )
• RTU_Supply_Voltage ( type: esriFieldTypeDouble, alias: RTU Supply Voltage )
• Maint__Mode_Status_Bit_64 ( type: esriFieldTypeDouble, alias: Maint. Mode Status Bit=64 )
• Alarm_log__1 ( type: esriFieldTypeDouble, alias: Alarm log #1 )
• Alarm_Log__2 ( type: esriFieldTypeDouble, alias: Alarm Log #2 )
• Run_Time ( type: esriFieldTypeDouble, alias: Run Time )
• Total_Awake_Hours ( type: esriFieldTypeDouble, alias: Total Awake Hours )
• Total_Time_Hours ( type: esriFieldTypeDouble, alias: Total Time Hours )
• System_Event_Status ( type: esriFieldTypeDouble, alias: System Event Status )
• Pressure__2 ( type: esriFieldTypeDouble, alias: Pressure #2 )
• Maximum_Pressure__2 ( type: esriFieldTypeDouble, alias: Maximum Pressure #2 )
• Maximum_Pressure__2_Time ( type: esriFieldTypeDouble, alias: Maximum Pressure #2 Time )
• Maximum_Pressure__2_Date ( type: esriFieldTypeDouble, alias: Maximum Pressure #2 Date )
• Minimum_Pressure__2 ( type: esriFieldTypeDouble, alias: Minimum Pressure #2 )
• Minimum_Pressure__2_Time ( type: esriFieldTypeDouble, alias: Minimum Pressure #2 Time )
• Minimum_Pressure__2_Date ( type: esriFieldTypeDouble, alias: Minimum Pressure #2 Date )
• Pressure__3 ( type: esriFieldTypeDouble, alias: Pressure #3 )
• Maximum_Pressure__3 ( type: esriFieldTypeDouble, alias: Maximum Pressure #3 )
• Maximum_Pressure__3_Time ( type: esriFieldTypeDouble, alias: Maximum Pressure #3 Time )
• Maximum_Pressure__3_Date ( type: esriFieldTypeDouble, alias: Maximum Pressure #3 Date )
• Minimum_Pressure__3 ( type: esriFieldTypeDouble, alias: Minimum Pressure #3 )
• Minimum_Pressure__3_Time ( type: esriFieldTypeDouble, alias: Minimum Pressure #3 Time )
• Minimum_Pressure__3_Date ( type: esriFieldTypeDouble, alias: Minimum Pressure #3 Date )
• Maximum_Temperature ( type: esriFieldTypeDouble, alias: Maximum Temperature )
• Maximum_Temperature_Time ( type: esriFieldTypeDouble, alias: Maximum Temperature Time )
• Maximum_Temperature_Date ( type: esriFieldTypeDouble, alias: Maximum Temperature Date )
• Minimum_Temperature ( type: esriFieldTypeDouble, alias: Minimum Temperature )
• Minimum_Temperature_Time ( type: esriFieldTypeDouble, alias: Minimum Temperature Time )
• Minimum_Temperature_Date ( type: esriFieldTypeDouble, alias: Minimum Temperature Date )
• Current_Day_Volume_R1 ( type: esriFieldTypeDouble, alias: Current Day Volume R1 )
• Previous_Day_Volume_R1 ( type: esriFieldTypeDouble, alias: Previous Day Volume R1 )
• Accumulated_Volume_R1 ( type: esriFieldTypeDouble, alias: Accumulated Volume R1 )
• Diff_Press_Frequency_R1 ( type: esriFieldTypeDouble, alias: Diff Press/Frequency R1 )
• UncorrVol_Ext_Param_R1 ( type: esriFieldTypeDouble, alias: UncorrVol/Ext Param R1 )
• Corrected_Flow_Rate_R1 ( type: esriFieldTypeDouble, alias: Corrected Flow Rate R1 )
• Current_Day_Flow_Time_R1 ( type: esriFieldTypeDouble, alias: Current Day Flow Time R1 )
• Energy_Flow_Rate_R1 ( type: esriFieldTypeDouble, alias: Energy Flow Rate R1 )
• Pressure_R1 ( type: esriFieldTypeDouble, alias: Pressure R1 )
• Meter_Id_R1 ( type: esriFieldTypeDouble, alias: Meter Id R1 )
• Current_Day_Energy_R1 ( type: esriFieldTypeDouble, alias: Current Day Energy R1 )
• Previous_Day_Energy_R1 ( type: esriFieldTypeDouble, alias: Previous Day Energy R1 )
• Gas_Temperature_R1 ( type: esriFieldTypeDouble, alias: Gas Temperature R1 )
• Total_Energy_MMBTU_R1 ( type: esriFieldTypeDouble, alias: Total Energy MMBTU R1 )
• Station_SpecificGravity ( type: esriFieldTypeDouble, alias: Station SpecificGravity )
• Station_BTU_Content ( type: esriFieldTypeDouble, alias: Station BTU Content )
• Current_Hour_Energy_R1 ( type: esriFieldTypeDouble, alias: Current Hour Energy R1 )
• Previous_Hour_Energy_R1 ( type: esriFieldTypeDouble, alias: Previous Hour Energy R1 )
• Flow_Extension_R1 ( type: esriFieldTypeDouble, alias: Flow Extension R1 )
• C_prime_R1 ( type: esriFieldTypeDouble, alias: C prime R1 )
• fpv_R1 ( type: esriFieldTypeDouble, alias: fpv R1 )
• Inlet_Pressure ( type: esriFieldTypeDouble, alias: Inlet Pressure )
• Outlet_Pressure ( type: esriFieldTypeDouble, alias: Outlet Pressure )
• Saturated_BTU ( type: esriFieldTypeDouble, alias: Saturated BTU )
• Cnfg_Col_7___Aux_Press_1 ( type: esriFieldTypeDouble, alias: Cnfg Col 7 - Aux Press 1 )
• Cnfg_Col_8___Aux_Press_2 ( type: esriFieldTypeDouble, alias: Cnfg Col 8 - Aux Press 2 )
• Cnfg_Col_9___Tank_Level_1 ( type: esriFieldTypeDouble, alias: Cnfg Col 9 - Tank Level 1 )
• Cnfg_Col_10_Tank_Level_2 ( type: esriFieldTypeDouble, alias: Cnfg Col 10-Tank Level 2 )
• Total_Unit__Hours ( type: esriFieldTypeDouble, alias: Total Unit Hours )
• Up_Time_R1 ( type: esriFieldTypeDouble, alias: Up Time R1 )
• Total_Events_R1 ( type: esriFieldTypeDouble, alias: Total Events R1 )
• Total_Alarms_R1 ( type: esriFieldTypeDouble, alias: Total Alarms R1 )
• Quality_Status_R1 ( type: esriFieldTypeDouble, alias: Quality Status R1 )
• Current_Day_Volume_R1_STD ( type: esriFieldTypeDouble, alias: Current Day Volume R1 STD )
• Current_Day_Volume_R2 ( type: esriFieldTypeDouble, alias: Current Day Volume R2 )
• Previous_Day_Volume_R2 ( type: esriFieldTypeDouble, alias: Previous Day Volume R2 )
• Accumulated_Volume_R2 ( type: esriFieldTypeDouble, alias: Accumulated Volume R2 )
• Diff_Press_Frequency_R2 ( type: esriFieldTypeDouble, alias: Diff Press/Frequency R2 )
• UncorrVol_Ext_Param_R2 ( type: esriFieldTypeDouble, alias: UncorrVol/Ext Param R2 )
• Corrected_Flow_Rate_R2 ( type: esriFieldTypeDouble, alias: Corrected Flow Rate R2 )
• Current_Day_Flow_Time_R2 ( type: esriFieldTypeDouble, alias: Current Day Flow Time R2 )
• Energy_Flow_Rate_R2 ( type: esriFieldTypeDouble, alias: Energy Flow Rate R2 )
• Pressure__R2 ( type: esriFieldTypeDouble, alias: Pressure R2 )
• Meter_ID_R2 ( type: esriFieldTypeDouble, alias: Meter ID R2 )
• Current_Day_Energy_2 ( type: esriFieldTypeDouble, alias: Current Day Energy 2 )
• Previous_Day_Energy_2 ( type: esriFieldTypeDouble, alias: Previous Day Energy 2 )
• Gas_Temperature_R2 ( type: esriFieldTypeDouble, alias: Gas Temperature R2 )
• Total_Energy_MMBTU_R2 ( type: esriFieldTypeDouble, alias: Total Energy MMBTU R2 )
• Specific_Gravity_R2 ( type: esriFieldTypeDouble, alias: Specific Gravity R2 )
• BTU_Content_R2 ( type: esriFieldTypeDouble, alias: BTU Content R2 )
• Previous_Day_Flow_Time_R2 ( type: esriFieldTypeDouble, alias: Previous Day Flow Time R2 )
• Current_Hour_Volume_R2 ( type: esriFieldTypeDouble, alias: Current Hour Volume R2 )
• Previous_Hour_Volume_R2 ( type: esriFieldTypeDouble, alias: Previous Hour Volume R2 )
• Current_Hour_Energy_R2 ( type: esriFieldTypeDouble, alias: Current Hour Energy R2 )
• Previous_Hour_Energy_R2 ( type: esriFieldTypeDouble, alias: Previous Hour Energy R2 )
• Flow_Extension_Parm_R2 ( type: esriFieldTypeDouble, alias: Flow Extension Parm R2 )
• C_Prime_R2 ( type: esriFieldTypeDouble, alias: C Prime R2 )
• fpv_R2 ( type: esriFieldTypeDouble, alias: fpv R2 )
• Up_Time_R2 ( type: esriFieldTypeDouble, alias: Up Time R2 )
• Total_Events_R2 ( type: esriFieldTypeDouble, alias: Total Events R2 )
• Total_Alarms_R2 ( type: esriFieldTypeDouble, alias: Total Alarms R2 )
• Quality_Status_R2 ( type: esriFieldTypeDouble, alias: Quality Status R2 )
• Current_Day_Vol_STD_R2 ( type: esriFieldTypeDouble, alias: Current Day Vol STD R2 )
• Current_Day_Volume_R3 ( type: esriFieldTypeDouble, alias: Current Day Volume R3 )
• Previous_Day_Volume_R3 ( type: esriFieldTypeDouble, alias: Previous Day Volume R3 )
• AccumulatedVol_R3 ( type: esriFieldTypeDouble, alias: AccumulatedVol R3 )
• Diff_Press_Frequency_R3 ( type: esriFieldTypeDouble, alias: Diff Press/Frequency R3 )
• UncorrVol_Ext_Param_R3 ( type: esriFieldTypeDouble, alias: UncorrVol/Ext Param R3 )
• Corrected_Flow_Rate_R3 ( type: esriFieldTypeDouble, alias: Corrected Flow Rate R3 )
• Current_Day_Flow_Time_R3 ( type: esriFieldTypeDouble, alias: Current Day Flow Time R3 )
• Energy_Flow_Rate_R3 ( type: esriFieldTypeDouble, alias: Energy Flow Rate R3 )
• Pressure_R3 ( type: esriFieldTypeDouble, alias: Pressure R3 )
• Meter_ID_R3 ( type: esriFieldTypeDouble, alias: Meter ID R3 )
• Current_Day_Energy_R3 ( type: esriFieldTypeDouble, alias: Current Day Energy R3 )
• Previous_Day_Energy_R3 ( type: esriFieldTypeDouble, alias: Previous Day Energy R3 )
• Gas_Temperature_R3 ( type: esriFieldTypeDouble, alias: Gas Temperature R3 )
• Total_Energy_MMBTU_R3 ( type: esriFieldTypeDouble, alias: Total Energy MMBTU R3 )
• Specific_Gravity_R3 ( type: esriFieldTypeDouble, alias: Specific Gravity R3 )
• BTU_Content_R3 ( type: esriFieldTypeDouble, alias: BTU Content R3 )
• Previous_Day_Flow_Time_R3 ( type: esriFieldTypeDouble, alias: Previous Day Flow Time R3 )
• Current_Hour_Volume_R3 ( type: esriFieldTypeDouble, alias: Current Hour Volume R3 )
• Previous_Hour_Volume_R3 ( type: esriFieldTypeDouble, alias: Previous Hour Volume R3 )
• Current_Hour_Energy_R3 ( type: esriFieldTypeDouble, alias: Current Hour Energy R3 )
• Previous_Hour_Energy_R3 ( type: esriFieldTypeDouble, alias: Previous Hour Energy R3 )
• Flow_Extension_Parm_R3 ( type: esriFieldTypeDouble, alias: Flow Extension Parm R3 )
• C_Prime_R3 ( type: esriFieldTypeDouble, alias: C Prime R3 )
• fpv_R3 ( type: esriFieldTypeDouble, alias: fpv R3 )
• Up_Time_R3 ( type: esriFieldTypeDouble, alias: Up Time R3 )
• Total_Events_3 ( type: esriFieldTypeDouble, alias: Total Events 3 )
• Total_Alarms_R3 ( type: esriFieldTypeDouble, alias: Total Alarms R3 )
• Quality_Status_R3 ( type: esriFieldTypeDouble, alias: Quality Status R3 )
• Current_Day_Vol_STD_R3 ( type: esriFieldTypeDouble, alias: Current Day Vol STD R3 )
• ImportExtTime ( type: esriFieldTypeDate, alias: Import Ext Time, length: 8 )
• PressureMPM1 ( type: esriFieldTypeDouble, alias: Pressure 1 )

Tables:

Table: Talon.dbo.tblHistoryDaily (1)

Name: Talon.dbo.tblHistoryDaily

Display Field: MeterID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• HistoryDaily_ID ( type: esriFieldTypeDouble, alias: HistoryDaily_ID )
• Station_ID ( type: esriFieldTypeDouble, alias: Station_ID )
• DataSetNo ( type: esriFieldTypeInteger, alias: DataSetNo )
• DateTime ( type: esriFieldTypeDate, alias: DateTime, length: 8 )
• CorVolume ( type: esriFieldTypeDouble, alias: CorVolume )
• Energy ( type: esriFieldTypeDouble, alias: Energy )
• DP ( type: esriFieldTypeDouble, alias: DP )
• SP ( type: esriFieldTypeDouble, alias: SP )
• FlowTemp ( type: esriFieldTypeDouble, alias: FlowTemp )
• CaseTemp ( type: esriFieldTypeDouble, alias: CaseTemp )
• FlowTime ( type: esriFieldTypeDouble, alias: FlowTime )
• SpecificGrav ( type: esriFieldTypeDouble, alias: SpecificGrav )
• BTUContent ( type: esriFieldTypeDouble, alias: BTUContent )
• ExtParm ( type: esriFieldTypeDouble, alias: ExtParm )
• CPrime ( type: esriFieldTypeDouble, alias: CPrime )
• Fpv ( type: esriFieldTypeDouble, alias: Fpv )
• N2 ( type: esriFieldTypeDouble, alias: N2 )
• CO2 ( type: esriFieldTypeDouble, alias: CO2 )
• OutletPressure ( type: esriFieldTypeDouble, alias: OutletPressure )
• MaxOutletPressure ( type: esriFieldTypeDouble, alias: MaxOutletPressure )
• MaxOutletPressureTime ( type: esriFieldTypeDouble, alias: MaxOutletPressureTime )
• MinOutletPressure ( type: esriFieldTypeDouble, alias: MinOutletPressure )
• MinOutletPressureTime ( type: esriFieldTypeDouble, alias: MinOutletPressureTime )
• SupplyVoltage ( type: esriFieldTypeDouble, alias: SupplyVoltage )
• test1 ( type: esriFieldTypeDouble, alias: test1 )
• test2 ( type: esriFieldTypeDouble, alias: test2 )
• test3 ( type: esriFieldTypeDouble, alias: test3 )
• MeterID ( type: esriFieldTypeString, alias: MeterID, length: 50 )
• PremiseID ( type: esriFieldTypeString, alias: PremiseID, length: 50 )
• test4 ( type: esriFieldTypeDouble, alias: test4 )
• test5 ( type: esriFieldTypeDouble, alias: test5 )
• TableKey ( type: esriFieldTypeDouble, alias: TableKey )
• MaxPress1 ( type: esriFieldTypeDouble, alias: MaxPress1 )
• MinPress1 ( type: esriFieldTypeDouble, alias: MinPress1 )
• Press#2 ( type: esriFieldTypeDouble, alias: Press#2 )
• MaxPress2 ( type: esriFieldTypeDouble, alias: MaxPress2 )
• MinPress2 ( type: esriFieldTypeDouble, alias: MinPress2 )
• TankInc ( type: esriFieldTypeDouble, alias: TankInc )
• TankDec ( type: esriFieldTypeDouble, alias: TankDec )
• AvgCasing ( type: esriFieldTypeDouble, alias: AvgCasing )
• MaxCasing ( type: esriFieldTypeDouble, alias: MaxCasing )
• MinCasing ( type: esriFieldTypeDouble, alias: MinCasing )
• AvgTubing ( type: esriFieldTypeDouble, alias: AvgTubing )
• MaxTubing ( type: esriFieldTypeDouble, alias: MaxTubing )
• MinTubing ( type: esriFieldTypeDouble, alias: MinTubing )
• AvgTankLevel ( type: esriFieldTypeDouble, alias: AvgTankLevel )
• MaxTankLevel ( type: esriFieldTypeDouble, alias: MaxTankLevel )
• MinTankLevel ( type: esriFieldTypeDouble, alias: MinTankLevel )