Name: gRegStationInsp

Display Field: STATIONNUMBER

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 45cf79275fbf4482b904c03b083b3cf6

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:

N/A

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: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• STATIONNUMBER ( type: esriFieldTypeString, alias: Station Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StationNumber )
• STATIONDESIGNATION ( type: esriFieldTypeString, alias: Station Designation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StationDesignation )
• STATIONLOCATION ( type: esriFieldTypeString, alias: Station Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StationLocation )
• DATEINSPECTED ( type: esriFieldTypeDate, alias: Date Inspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInspected )
• REGULATORONESIZE ( type: esriFieldTypeString, alias: Regulator One Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RegulatorOneSize , Coded Values: [2: 2"] , [3: 3"] , [4: 4"] , ...5 more... )
• REGULATORONETYPE ( type: esriFieldTypeString, alias: Regulator One Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RegulatorOneType , Coded Values: [American: American] , [Equimeter: Equimeter] , [Fischer: Fischer] , ...4 more... )
• REGULATORONEORIFICESIZE ( type: esriFieldTypeString, alias: Regulator One Orifice Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RegulatorOneOrificeSize )
• REGULATORTWOSIZE ( type: esriFieldTypeString, alias: Regulator Two Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RegulatorTwoSize , Coded Values: [2: 2"] , [3: 3"] , [4: 4"] , ...5 more... )
• REGULATORTWOTYPE ( type: esriFieldTypeString, alias: Regulator Two Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RegulatorTwoType , Coded Values: [American: American] , [Equimeter: Equimeter] , [Fischer: Fischer] , ...4 more... )
• REGULATORTWOORIFICESIZE ( type: esriFieldTypeString, alias: Regulator Two Orifice Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RegulatorTwoOrificeSize )
• STATIONSTRUCTURELOCATION ( type: esriFieldTypeString, alias: Station Structure Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StationStructureLocation , Coded Values: [Pit: Pit] , [Other: Other] , [AboveGround: Above Ground] )
• CGIREADINGLEL ( type: esriFieldTypeDouble, alias: CGI Reading LEL, editable: true, nullable: true, defaultValue: null, modelName: CGIReadingLEL )
• CGIREADINGPERCENTGAS ( type: esriFieldTypeDouble, alias: CGI Reading Percent Gas, editable: true, nullable: true, defaultValue: null, modelName: CGIReadingPercentGas )
• VENTINGSYSTEMCLEAR ( type: esriFieldTypeString, alias: Venting System Clear, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VentingSystemClear , Coded Values: [Yes: Yes] , [No: No] )
• CONDENSATIONREMOVEDFROMDRIPS ( type: esriFieldTypeString, alias: Condensation Removed from Drips, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CondensationRemovedfromDrips , Coded Values: [Y: Yes] , [N: No] , [NA: NA] )
• STATIONVALVESSERVICEDOPERATED ( type: esriFieldTypeString, alias: Station Valves Serviced and Operated, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StationValvesServicedOperated , Coded Values: [Yes: Yes] , [No: No] )
• ATMOSPHERICCORROSIONRANKING ( type: esriFieldTypeString, alias: Atmospheric Corrosion Ranking, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AtmosphericCorrosionRanking , Coded Values: [Excellent: Excellent] , [Good: Good] , [OK: OK] , ...2 more... )
• OVERPRESSUREPROTECTIONTYPE ( type: esriFieldTypeString, alias: Overpressure Protection Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OverpressureProtectoinType , Coded Values: [Monitor: Monitor] , [ReliefValve: Relief Valve] )
• RELIEFVALVEMAKE ( type: esriFieldTypeString, alias: Relief Valve Make, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReliefValveMake , Coded Values: [American: American] , [Equimeter: Equimeter] , [Flowsafe: Flowsafe] , ...3 more... )
• RELIEFVALVETYPE ( type: esriFieldTypeString, alias: Relief Valve Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReliefValveType , Coded Values: [American: American] , [Equimeter: Equimeter] , [Fischer: Fischer] , ...4 more... )
• RELIEFVALVESIZE ( type: esriFieldTypeString, alias: Relief Valve Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReliefValveSize , Coded Values: [10: 10"] , [2: 2"] , [2x3: 2" x 3"] , ...8 more... )
• RELIEFVALVETYPEOFLOADING ( type: esriFieldTypeString, alias: Relief Valve Type of Loading, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReliefValveTypeofLoading , Coded Values: [Deadweight: Deadweight] , [Pilot: Pilot] , [Spring: Spring] , ...1 more... )
• RELIEFVALVETYPEOFLOADINGOTHER ( type: esriFieldTypeString, alias: Relief Valve Type of Loading Other, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReliefValveTypeofLoadingOther )
• RELIEFVALVERANGEOFLOADING ( type: esriFieldTypeString, alias: Relief Valve Range of Loading, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReliefValveRangeofLoading )
• RELIEFVALVESETWITHGAUGE ( type: esriFieldTypeString, alias: Relief Valve Set with Gauge, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReliefValveSetWithGauge , Coded Values: [Yes: Yes] , [No: No] )
• RELIEFVALVEVALVEISOLATION ( type: esriFieldTypeString, alias: Is there an isolating valve under the relief valve?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReliefValveValveIsolation , Coded Values: [Yes: Yes] , [No: No] )
• RELIEFVALVEISOLATIONVALVETYPE ( type: esriFieldTypeString, alias: Isolation Valve Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReliefValveIsolationValveType , Coded Values: [Ball: Ball] , [Butterfly: Butterfly] , [Gate: Gate] , ...1 more... )
• RELIEFVALVEISOLATIONVALVESIZE ( type: esriFieldTypeString, alias: Isolation Valve Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReliefValveIsolationValveSize , Coded Values: [2: 2"] , [3: 3"] , [4: 4"] , ...3 more... )
• RELIEFVALVETAPVLVANDRELIEF ( type: esriFieldTypeString, alias: Is there a tap between isolating valve and relief valve for set point testing with air?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReliefValveTapBetweenIsoVLVandRelief , Coded Values: [Yes: Yes] , [No: No] )
• ACTIONSREQUIRED ( type: esriFieldTypeString, alias: Are further actions required?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ActionsRequired , Coded Values: [Yes: Yes] , [No: No] )
• DESCRIBEREQUIREDACTIONS ( type: esriFieldTypeString, alias: Describe Required Actions, editable: true, nullable: true, length: 200, defaultValue: null, modelName: DescribeRequiredActions )
• ACTIONSTAKENIMMEDIATELY ( type: esriFieldTypeString, alias: Were the Actions Taken Immediately?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ActionsTakenImmediately , Coded Values: [Yes: Yes] , [No: No] )
• DESCRIBEACTIONSTAKEN ( type: esriFieldTypeString, alias: Describe Actions Taken, editable: true, nullable: true, length: 200, defaultValue: null, modelName: DescribeActionsTaken )
• REPAIREDBY ( type: esriFieldTypeString, alias: Repaired By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RepairedBy , Coded Values: [DanDavidson: Dan Davidson] , [RayBriscoe: Ray Briscoe] , [ShawnBentley: Shawn Bentley] )
• REGULATORONEORIFICESIZEOTHER ( type: esriFieldTypeString, alias: Regulator One Orifice Size Other, editable: true, nullable: true, length: 150, defaultValue: null, modelName: REGULATORONEORIFICESIZEOTHER )
• REGULATORTWOORIFICESIZEOTHER ( type: esriFieldTypeString, alias: Regulator Two Orifice Size Other, editable: true, nullable: true, length: 150, defaultValue: null, modelName: REGULATORTWOORIFICESIZEOTHER )
• STATIONMAOPINLETUNIT ( type: esriFieldTypeString, alias: Station MAOP Inlet Unit of Measure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATIONMAOPINLETUNIT , Coded Values: [PSIG: PSIG] , [IWC: IWC] )
• STATIONMAOPOUTLETUNIT ( type: esriFieldTypeString, alias: Station MAOP Outlet Unit of Measure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATIONMAOPOUTLETUNIT , Coded Values: [PSIG: PSIG] , [IWC: IWC] )
• OPERATINGPRESSUREINLETUNIT ( type: esriFieldTypeString, alias: Operating Pressure Inlet Unit of Measure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OPERATINGPRESSUREINLETUNIT , Coded Values: [PSIG: PSIG] , [IWC: IWC] )
• OPERATINGPRESSUREOUTLETUNIT ( type: esriFieldTypeString, alias: Operating Pressure Outlet Unit of Measure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OPERATINGPRESSUREOUTLETUNIT , Coded Values: [PSIG: PSIG] , [IWC: IWC] )
• MONITORSETPOINTUNIT ( type: esriFieldTypeString, alias: Monitor Set Point Unit of Measure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MONITORSETPOINTUNIT , Coded Values: [PSIG: PSIG] , [IWC: IWC] )
• RELIEFVALVESETPOINTUNIT ( type: esriFieldTypeString, alias: Relief Valve Set Point Unit of Measure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RELIEFVALVESETPOINTUNIT , Coded Values: [PSIG: PSIG] , [IWC: IWC] )
• OPERATINGPRESSUREINLET ( type: esriFieldTypeDouble, alias: Operating Pressure Inlet, editable: true, nullable: true, defaultValue: null, modelName: OperatingPressureInlet )
• OPERATINGPRESSUREOUTLET ( type: esriFieldTypeDouble, alias: Operating Pressure Outlet, editable: true, nullable: true, defaultValue: null, modelName: OperatingPressureOutlet )
• STATIONMAOPINLET ( type: esriFieldTypeDouble, alias: Station MAOP Inlet, editable: true, nullable: true, defaultValue: null, modelName: StationMAOPInlet )
• STATIONMAOPOUTLET ( type: esriFieldTypeDouble, alias: Station MAOP Outlet, editable: true, nullable: true, defaultValue: null, modelName: StationMAOPOutlet )
• MONITORSETPOINT ( type: esriFieldTypeDouble, alias: Monitor Set Point, editable: true, nullable: true, defaultValue: null, modelName: MONITORSETPOINT )
• RELIEFVALVESETPOINT ( type: esriFieldTypeDouble, alias: Relief Valve Set Point, editable: true, nullable: true, defaultValue: null, modelName: RELIEFVALVESETPOINT )
• RELIEFMAOPBUILDUP ( type: esriFieldTypeDouble, alias: Relief Valve MAOP Build Up, editable: true, nullable: true, defaultValue: null, modelName: RELIEFMAOPBUILDUP )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• EMAILSENT ( type: esriFieldTypeSmallInteger, alias: Was Email Sent?, editable: true, nullable: true, defaultValue: null, modelName: EMAILSENT )
• STARTSURVEY ( type: esriFieldTypeDate, alias: Survey Start Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: STARTSURVEY )
• ENDSURVEY ( type: esriFieldTypeDate, alias: Survey End Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ENDSURVEY )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• ReportLink ( type: esriFieldTypeString, alias: Report Link, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ReportLink )
• RELIEFMAOPBUILDUPUNIT ( type: esriFieldTypeString, alias: Relief Valve MAOP BuildUp Unit of Measure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RELIEFMAOPBUILDUPUNIT , Coded Values: [PSIG: PSIG] , [IWC: IWC] )
• MONITORMAOPBUILDUP ( type: esriFieldTypeDouble, alias: Monitor MAOP Build Up, editable: true, nullable: true, defaultValue: null, modelName: MONITORMAOPBUILDUP )
• MONITORMAOPBUILDUPUNIT ( type: esriFieldTypeString, alias: Monitor MAOP BuildUp Unit of Measure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MONITORMAOPBUILDUPUNIT , Coded Values: [PSIG: PSIG] , [IWC: IWC] )
• RELATE ( type: esriFieldTypeGUID, alias: RELATE, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RELATE )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• Year ( type: esriFieldTypeString, alias: Year, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Year )

Templates:

• Name: gRegStationInsp
  Description:
  Prototype:
  COMMENTS: null
  RELATE: null
  STATIONNUMBER: null
  STATIONDESIGNATION: null
  STATIONLOCATION: null
  DATEINSPECTED: null
  REGULATORONESIZE: null
  REGULATORONETYPE: null
  REGULATORONEORIFICESIZE: null
  REGULATORTWOSIZE: null
  REGULATORTWOTYPE: null
  REGULATORTWOORIFICESIZE: null
  STATIONSTRUCTURELOCATION: null
  CGIREADINGLEL: null
  CGIREADINGPERCENTGAS: null
  VENTINGSYSTEMCLEAR: null
  CONDENSATIONREMOVEDFROMDRIPS: null
  STATIONVALVESSERVICEDOPERATED: null
  ATMOSPHERICCORROSIONRANKING: null
  OVERPRESSUREPROTECTIONTYPE: null
  RELIEFVALVEMAKE: null
  RELIEFVALVETYPE: null
  RELIEFVALVESIZE: null
  RELIEFVALVETYPEOFLOADING: null
  RELIEFVALVETYPEOFLOADINGOTHER: null
  RELIEFVALVERANGEOFLOADING: null
  RELIEFVALVESETWITHGAUGE: null
  RELIEFVALVEVALVEISOLATION: null
  RELIEFVALVEISOLATIONVALVETYPE: null
  RELIEFVALVEISOLATIONVALVESIZE: null
  RELIEFVALVETAPVLVANDRELIEF: null
  ACTIONSREQUIRED: null
  DESCRIBEREQUIREDACTIONS: null
  ACTIONSTAKENIMMEDIATELY: null
  DESCRIBEACTIONSTAKEN: null
  REPAIREDBY: null
  REGULATORONEORIFICESIZEOTHER: null
  REGULATORTWOORIFICESIZEOTHER: null
  STATIONMAOPINLETUNIT: null
  STATIONMAOPOUTLETUNIT: null
  OPERATINGPRESSUREINLETUNIT: null
  OPERATINGPRESSUREOUTLETUNIT: null
  MONITORSETPOINTUNIT: null
  RELIEFVALVESETPOINTUNIT: null
  OPERATINGPRESSUREINLET: null
  OPERATINGPRESSUREOUTLET: null
  STATIONMAOPINLET: null
  STATIONMAOPOUTLET: null
  MONITORSETPOINT: null
  RELIEFVALVESETPOINT: null
  RELIEFMAOPBUILDUP: null
  Year: null
  EMAILSENT: null
  STARTSURVEY: null
  ENDSURVEY: null
  MONITORMAOPBUILDUPUNIT: null
  MONITORMAOPBUILDUP: null
  RELIEFMAOPBUILDUPUNIT: null
  ReportLink: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• RegulatorStation (0) -- Related To: Regulator Stations (0)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

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

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata