View In:   ArcGIS Online Map Viewer

Name: HCCG_PIPE_Data.dbo.Case_Main_AllData Events

Display Field: UnderTaker_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 26000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

XMin: 0
YMin: 0
XMax: 2742409.924
YMax: 4743149.85
Spatial Reference: 102443  (3826)

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

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• CID ( type: esriFieldTypeDouble, alias: CID, editable: true, nullable: false, defaultValue: null, modelName: CID )
• Case_ID ( type: esriFieldTypeString, alias: Case_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Case_ID )
• Case_ShowID ( type: esriFieldTypeString, alias: Case_ShowID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Case_ShowID )
• KEYIN ( type: esriFieldTypeString, alias: KEYIN, editable: true, nullable: true, length: 20, defaultValue: null, modelName: KEYIN )
• Reason ( type: esriFieldTypeString, alias: Reason, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Reason )
• Case_Purpose ( type: esriFieldTypeString, alias: Case_Purpose, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Case_Purpose )
• Case_Type1 ( type: esriFieldTypeString, alias: Case_Type1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Case_Type1 )
• Case_Type2 ( type: esriFieldTypeString, alias: Case_Type2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Case_Type2 )
• Company_ID ( type: esriFieldTypeString, alias: Company_ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Company_ID )
• Pipe_Type ( type: esriFieldTypeString, alias: Pipe_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Pipe_Type )
• EditPipe ( type: esriFieldTypeString, alias: EditPipe, editable: true, nullable: true, length: 1, defaultValue: null, modelName: EditPipe )
• UnderTaker_Name ( type: esriFieldTypeString, alias: UnderTaker_Name, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UnderTaker_Name )
• UnderTaker_Tel ( type: esriFieldTypeString, alias: UnderTaker_Tel, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UnderTaker_Tel )
• Create_Date ( type: esriFieldTypeDate, alias: Create_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Create_Date )
• Edit_Date ( type: esriFieldTypeDate, alias: Edit_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Edit_Date )
• Construction_Time ( type: esriFieldTypeString, alias: Construction_Time, editable: true, nullable: true, length: 24, defaultValue: null, modelName: Construction_Time )
• Start_Date ( type: esriFieldTypeDate, alias: Start_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Start_Date )
• End_Date ( type: esriFieldTypeDate, alias: End_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: End_Date )
• Accept_Time ( type: esriFieldTypeString, alias: Accept_Time, editable: true, nullable: true, length: 24, defaultValue: null, modelName: Accept_Time )
• Accept_Start_Date ( type: esriFieldTypeDate, alias: Accept_Start_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Accept_Start_Date )
• Accept_End_Date ( type: esriFieldTypeDate, alias: Accept_End_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Accept_End_Date )
• Construction_Place ( type: esriFieldTypeString, alias: Construction_Place, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Construction_Place )
• pMemo ( type: esriFieldTypeString, alias: pMemo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: pMemo )
• State_ID ( type: esriFieldTypeString, alias: State_ID, editable: true, nullable: true, length: 5, defaultValue: null, modelName: State_ID )
• Cen_X ( type: esriFieldTypeDouble, alias: Cen_X, editable: true, nullable: true, defaultValue: null, modelName: Cen_X )
• Cen_Y ( type: esriFieldTypeDouble, alias: Cen_Y, editable: true, nullable: true, defaultValue: null, modelName: Cen_Y )
• UnitID ( type: esriFieldTypeInteger, alias: UnitID, editable: true, nullable: true, defaultValue: null, modelName: UnitID )
• WorkPaper_NO ( type: esriFieldTypeString, alias: WorkPaper_NO, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WorkPaper_NO )
• Pipe_Deadline ( type: esriFieldTypeDate, alias: Pipe_Deadline, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Pipe_Deadline )
• BD_LIC ( type: esriFieldTypeString, alias: BD_LIC, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BD_LIC )
• Project_CaseNo ( type: esriFieldTypeString, alias: Project_CaseNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Project_CaseNo )
• Termination_Memo ( type: esriFieldTypeString, alias: Termination_Memo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Termination_Memo )
• Termination_Date ( type: esriFieldTypeDate, alias: Termination_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Termination_Date )
• Terminator ( type: esriFieldTypeString, alias: Terminator, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Terminator )
• Termination_Reapply ( type: esriFieldTypeDate, alias: Termination_Reapply, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Termination_Reapply )
• Expr1 ( type: esriFieldTypeString, alias: Expr1, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Expr1 )
• State_Name ( type: esriFieldTypeString, alias: State_Name, editable: true, nullable: true, length: 20, defaultValue: null, modelName: State_Name )
• Next_ID ( type: esriFieldTypeString, alias: Next_ID, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Next_ID )
• Pri_ID ( type: esriFieldTypeString, alias: Pri_ID, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Pri_ID )
• AID ( type: esriFieldTypeDouble, alias: AID, editable: true, nullable: true, defaultValue: null, modelName: AID )
• Expr2 ( type: esriFieldTypeString, alias: Expr2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Expr2 )
• addid ( type: esriFieldTypeInteger, alias: addid, editable: true, nullable: true, defaultValue: null, modelName: addid )
• Town ( type: esriFieldTypeString, alias: Town, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Town )
• road ( type: esriFieldTypeString, alias: road, editable: true, nullable: true, length: 40, defaultValue: null, modelName: road )
• sect ( type: esriFieldTypeString, alias: sect, editable: true, nullable: true, length: 20, defaultValue: null, modelName: sect )
• lane ( type: esriFieldTypeString, alias: lane, editable: true, nullable: true, length: 20, defaultValue: null, modelName: lane )
• alley ( type: esriFieldTypeString, alias: alley, editable: true, nullable: true, length: 10, defaultValue: null, modelName: alley )
• no ( type: esriFieldTypeString, alias: no, editable: true, nullable: true, length: 10, defaultValue: null, modelName: no )
• addr ( type: esriFieldTypeString, alias: addr, editable: true, nullable: true, length: 2147483647, defaultValue: null, modelName: addr )
• 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 )
• UID ( type: esriFieldTypeDouble, alias: UID, editable: true, nullable: true, defaultValue: null, modelName: UID )
• Expr3 ( type: esriFieldTypeInteger, alias: Expr3, editable: true, nullable: true, defaultValue: null, modelName: Expr3 )
• UnitName ( type: esriFieldTypeString, alias: UnitName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UnitName )
• UnitType ( type: esriFieldTypeString, alias: UnitType, editable: true, nullable: true, length: 1, defaultValue: null, modelName: UnitType )
• BCode1 ( type: esriFieldTypeString, alias: BCode1, editable: true, nullable: true, length: 2, defaultValue: null, modelName: BCode1 )
• BCode2 ( type: esriFieldTypeString, alias: BCode2, editable: true, nullable: true, length: 2, defaultValue: null, modelName: BCode2 )
• Default_LIC ( type: esriFieldTypeDouble, alias: Default_LIC, editable: true, nullable: true, defaultValue: null, modelName: Default_LIC )
• TownName ( type: esriFieldTypeString, alias: TownName, editable: true, nullable: true, length: 6, defaultValue: null, modelName: TownName )

Templates:

• Name: HCCG_PIPE_Data.dbo.Case_Main_AllData Events
  Description:
  Prototype:
  Default_LIC: null
  CID: 0
  Case_ID: null
  Case_ShowID: null
  KEYIN: null
  Reason: null
  Case_Purpose: null
  Case_Type1: null
  Case_Type2: null
  Company_ID: null
  Pipe_Type: null
  EditPipe: null
  UnderTaker_Name: null
  UnderTaker_Tel: null
  Create_Date: null
  Edit_Date: null
  Construction_Time: null
  Start_Date: null
  End_Date: null
  Accept_Time: null
  Accept_Start_Date: null
  Accept_End_Date: null
  Construction_Place: null
  pMemo: null
  State_ID: null
  Cen_X: null
  Cen_Y: null
  UnitID: null
  WorkPaper_NO: null
  Pipe_Deadline: null
  BD_LIC: null
  Project_CaseNo: null
  Termination_Memo: null
  Termination_Date: null
  Terminator: null
  Termination_Reapply: null
  Expr1: null
  State_Name: null
  Next_ID: null
  Pri_ID: null
  AID: null
  Expr2: null
  addid: null
  Town: null
  road: null
  sect: null
  lane: null
  alley: null
  no: null
  addr: null
  X: null
  Y: null
  UID: null
  Expr3: null
  UnitName: null
  UnitType: null
  BCode1: null
  BCode2: null
  TownName: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

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