View In:   ArcGIS Online Map Viewer

Name: Gas Construction Inspection

Display Field: AssetType

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: c7ded8620a6e4278bb5891420a5e9902

Copyright Text:

Default Visibility: true

MaxRecordCount: 10000

Supported Query Formats: JSON, geoJSON

Min Scale: 72225

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: -8327022.366934523
YMin: 496515.79882855713
XMax: 1502270.66768156
YMax: 625805.9487123042
Spatial Reference: 102723  (3735)

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• AssetType ( type: esriFieldTypeString, alias: Asset Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssetType , Coded Values: [Main: Main] , [Service: Service] , [Valve: Valve] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Location )
• BarCode ( type: esriFieldTypeString, alias: Bar Code, editable: true, nullable: true, length: 250, defaultValue: null, modelName: BarCode )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Manufacturer , Coded Values: [American: American Steel Pipe] , [Charter: Charter Plastics] , [Performance: Performance] , ...9 more... )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Material , Coded Values: [PE: PE] , [Steel: Steel] , [Cast: Cast] , ...1 more... )
• Diameter ( type: esriFieldTypeString, alias: Diameter, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Diameter , Coded Values: [.25: 1/4"] , [.5: 1/2"] , [.75: 3/4"] , ...16 more... )
• WallThickness ( type: esriFieldTypeString, alias: Wall Thickness, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WallThickness )
• SDR ( type: esriFieldTypeString, alias: SDR, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SDR )
• InstallationDate ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• InstalledBy ( type: esriFieldTypeString, alias: Installed By, editable: true, nullable: true, length: 25, defaultValue: null, modelName: InstalledBy , Coded Values: [Hamilton: City of Hamilton] , [Contractor: Contractor] )
• InstallationMethod ( type: esriFieldTypeString, alias: Installation Method, editable: true, nullable: true, length: 25, defaultValue: null, modelName: InstallationMethod , Coded Values: [OpenTrench: Open Trench] , [DirectionalDrill: Directional Drill] , [JackBore: Jack and Bore] )
• CoverDepth ( type: esriFieldTypeString, alias: Cover Depth (inches), editable: true, nullable: true, length: 15, defaultValue: null, modelName: CoverDepth )
• OperatingPressure ( type: esriFieldTypeString, alias: Operating Pressure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OperatingPressure , Coded Values: [Distribution: Distribution] , [Intermediate: Intermediate] , [Medium: Medium] , ...2 more... )
• TracerWire ( type: esriFieldTypeString, alias: Tracer Wire, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TracerWire , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• FusionJointLocation ( type: esriFieldTypeString, alias: Fusion Joint Location, editable: true, nullable: true, length: 5, defaultValue: null, modelName: FusionJointLocation , Coded Values: [Y: Yes] , [N: No] )
• FusionJointType ( type: esriFieldTypeString, alias: Fusion Joint Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FusionJointType , Coded Values: [ElectroFusion: Electro-Fusion] , [ButtFusion: Butt Fusion] )
• QualifiedPersonnel ( type: esriFieldTypeString, alias: Qualified Personnel, editable: true, nullable: true, length: 50, defaultValue: null, modelName: QualifiedPersonnel )
• CoatingType ( type: esriFieldTypeString, alias: Coating Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CoatingType , Coded Values: [CTE: Coal Tar Enamel] , [MW: Mil Wrap] , [UVTP: UV Tape] , ...6 more... )
• CathodicProtection ( type: esriFieldTypeString, alias: Cathodic Protection, editable: true, nullable: true, length: 5, defaultValue: null, modelName: CathodicProtection , Coded Values: [Y: Yes] , [N: No] )
• MultiMeterService ( type: esriFieldTypeString, alias: Service Serving Multiple Meters, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MultiMeterService , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• ServiceStub ( type: esriFieldTypeString, alias: Service Stub, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ServiceStub , Coded Values: [Y: Yes] , [N: No] )
• ValveType ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ValveType , Coded Values: [Main: Main] , [Curb: Curb] , [Drip: Drip] )
• MeasureDetails ( type: esriFieldTypeString, alias: Measurement Details, editable: true, nullable: true, length: 250, defaultValue: null, modelName: MeasureDetails )
• ValveConnection ( type: esriFieldTypeString, alias: Valve Connection, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ValveConnection , Coded Values: [Fusion: Fusion] , [Stab: Stab] )
• ValveFusionJoint ( type: esriFieldTypeString, alias: Valve Fusion Joint Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ValveFusionJoint , Coded Values: [ElectroFusion: Electro-Fusion] , [ButtFusion: Butt Fusion] )
• QualifiedFusion ( type: esriFieldTypeString, alias: Qualified Fusion Personnel, editable: true, nullable: true, length: 50, defaultValue: null, modelName: QualifiedFusion )
• QualifiedStab ( type: esriFieldTypeString, alias: Qualified Stab Personnel, editable: true, nullable: true, length: 50, defaultValue: null, modelName: QualifiedStab )
• CriticalValve ( type: esriFieldTypeString, alias: Critical Valve, editable: true, nullable: true, length: 5, defaultValue: null, modelName: CriticalValve , Coded Values: [Y: Yes] , [N: No] )
• ExcessFlowValve ( type: esriFieldTypeString, alias: Excess Flow Valve, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ExcessFlowValve , Coded Values: [Y: Yes] , [N: No] )
• ExcessFlowModel ( type: esriFieldTypeString, alias: Excess Flow Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ExcessFlowModel )
• FittingConnection ( type: esriFieldTypeString, alias: Fitting Connection, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FittingConnection , Coded Values: [Fusion: Fusion] , [Stab: Stab] )
• FittingFusionJoint ( type: esriFieldTypeString, alias: Fitting Fusion Joint Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FittingFusionJoint , Coded Values: [ElectroFusion: Electro-Fusion] , [ButtFusion: Butt Fusion] )
• TestDate ( type: esriFieldTypeDate, alias: Test Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TestDate )
• TestDuration ( type: esriFieldTypeString, alias: Test Duration, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TestDuration )
• TestPressure ( type: esriFieldTypeString, alias: Test Pressure, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TestPressure )
• TestType ( type: esriFieldTypeString, alias: Test Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TestType )
• ValveClass ( type: esriFieldTypeString, alias: Valve Class, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ValveClass , Coded Values: [Plug: Plug] , [Gate: Gate] , [Ball: Ball] , ...1 more... )
• FittingClass ( type: esriFieldTypeString, alias: Fitting Class, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FittingClass , Coded Values: [90: 90 Degree] , [45: 45 Degree] , [22.5: 22 1/2 Degree] , ...8 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Comments )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
• x ( type: esriFieldTypeDouble, alias: x, editable: true, nullable: true, defaultValue: null, modelName: x )
• y ( type: esriFieldTypeDouble, alias: y, editable: true, nullable: true, defaultValue: null, modelName: y )
• horizontalAccuracy ( type: esriFieldTypeDouble, alias: horizontalAccuracy, editable: true, nullable: true, defaultValue: null, modelName: horizontalAccuracy )
• Inspector ( type: esriFieldTypeString, alias: Inspector Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspector , Coded Values: [Davidson: Dan Davidson] , [Briscoe: Ray Briscoe] , [Bowers: Bill Bowers] , ...8 more... )
• Contractor ( type: esriFieldTypeString, alias: Contractor Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Contractor , Coded Values: [MVC: Miami Valley Construction] , [RLA: RLA Utilities] , [JDC: JD Curry] , ...2 more... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ABANDONED ( type: esriFieldTypeString, alias: Abandoned Yes or No, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ABANDONED , Coded Values: [No: No] , [Yes: Yes] , [NA: NA] )
• GIS ( type: esriFieldTypeString, alias: Updated in GIS Yes or No, editable: true, nullable: true, length: 5, defaultValue: null, modelName: GIS , Coded Values: [No: No] , [Yes: Yes] , [NA: NA] )

Templates:

• Name: Gas Construction Inspection
  Description:
  Prototype:
  ABANDONED: null
  AssetType: null
  Location: null
  BarCode: null
  Manufacturer: null
  Material: null
  Diameter: null
  WallThickness: null
  SDR: null
  InstallationDate: null
  InstalledBy: null
  InstallationMethod: null
  CoverDepth: null
  OperatingPressure: null
  TracerWire: null
  FusionJointLocation: null
  FusionJointType: null
  QualifiedPersonnel: null
  CoatingType: null
  CathodicProtection: null
  MultiMeterService: null
  ServiceStub: null
  ValveType: null
  MeasureDetails: null
  ValveConnection: null
  ValveFusionJoint: null
  QualifiedFusion: null
  QualifiedStab: null
  CriticalValve: null
  ExcessFlowValve: null
  ExcessFlowModel: null
  FittingConnection: null
  FittingFusionJoint: null
  TestDate: null
  TestDuration: null
  TestPressure: null
  TestType: null
  ValveClass: null
  FittingClass: null
  Comments: null
  GIS: null
  Contractor: null
  Inspector: null
  horizontalAccuracy: null
  y: null
  x: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

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

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