Name: CHRC Water Lines

Display Field: Usrdefid

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Project : GIS Data Migration CHRC002Date : May 2015Revision : 1Description - This is a base import of MapInfo .tab files into ESRI Geodatabase

Copyright Text: (c) 2015 - Central Highlands Regional Council (CHRC)

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 554761.4601
YMin: 7279663.8666
XMax: 781440.1898
YMax: 7453898.8715
Spatial Reference: 28355 (28355)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"Assettype","field2":null,"field3":null,"defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":1},"defaultLabel":"Other","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,178,255,255],"width":1.5},"value":"Pipe Main","label":"Pipe Main","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2.5},"value":"Trunk Main","label":"Trunk Main","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSDashDotDot","color":[0,92,230,255],"width":2},"value":"Raw Water Pipe Main","label":"Raw Water Pipe Main","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[0,197,255,255],"width":1.5},"value":"Service Connection","label":"Service Connection","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field: Assettype

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Asset_id (type: esriFieldTypeDouble, alias: Asset_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Usrdefid (type: esriFieldTypeString, alias: Usrdefid, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Active: Active], [As-Built: As-Built], [Blocked: Blocked], ... 9 more ...)
• Assettype (type: esriFieldTypeString, alias: Assettype, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Pipe Main: Pipe Main], [Private Raw Water Main: Private Raw Water Main], [Raw Water Pipe Main: Raw Water Pipe Main], ... 2 more ...)
• Subtype (type: esriFieldTypeString, alias: Subtype, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Assetclass (type: esriFieldTypeString, alias: Assetclass, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: AC], [B/PVC: B/PVC], [CICL: CICL], ... 13 more ...)
• Usnode (type: esriFieldTypeString, alias: Usnode, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Dsnode (type: esriFieldTypeString, alias: Dsnode, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Usdist (type: esriFieldTypeDouble, alias: Usdist, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Dsdist (type: esriFieldTypeDouble, alias: Dsdist, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Widthdia (type: esriFieldTypeDouble, alias: Widthdia, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Height (type: esriFieldTypeDouble, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Length (type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Truelength (type: esriFieldTypeDouble, alias: Truelength, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Area (type: esriFieldTypeDouble, alias: Prod.GISO.ws_pl.Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Depth (type: esriFieldTypeDouble, alias: Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Usinvrtlvl (type: esriFieldTypeDouble, alias: Usinvrtlvl, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Dsinvrtlvl (type: esriFieldTypeDouble, alias: Dsinvrtlvl, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Installyr (type: esriFieldTypeDouble, alias: Installyr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Installmo (type: esriFieldTypeDouble, alias: Installmo, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Hlink (type: esriFieldTypeString, alias: Hlink, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Contractno (type: esriFieldTypeString, alias: Contractno, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Projectid (type: esriFieldTypeString, alias: Projectid, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Cond (type: esriFieldTypeDouble, alias: Cond, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Perf (type: esriFieldTypeDouble, alias: Perf, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Accu (type: esriFieldTypeDouble, alias: Accu, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Critic (type: esriFieldTypeDouble, alias: Critic, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Source (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [As-Built Drawings: As-Built Drawings], [As-Constructed: As-Constructed], [Bryant Edmonston & Associates: Bryant Edmonston & Associates], ... 10 more ...)
• Method (type: esriFieldTypeString, alias: Method, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [Aerial Photo: Aerial Photo], [As-Built: As-Built], [As-Cons: As-Cons], ... 11 more ...)
• Bestguess (type: esriFieldTypeString, alias: Bestguess, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Locality (type: esriFieldTypeString, alias: Locality, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Anakie: Anakie], [Bauhinia: Bauhinia], [Blackwater: Blackwater], ... 15 more ...)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Installcst (type: esriFieldTypeDouble, alias: Installcst, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Baselfopt (type: esriFieldTypeDouble, alias: Baselfopt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Repcst (type: esriFieldTypeDouble, alias: Repcst, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Repcstunit (type: esriFieldTypeString, alias: Repcstunit, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Fairvalue (type: esriFieldTypeDouble, alias: Fairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Fairvalyr (type: esriFieldTypeDouble, alias: Fairvalyr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Fairvalmo (type: esriFieldTypeDouble, alias: Fairvalmo, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Residval (type: esriFieldTypeDouble, alias: Residval, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Unitratef (type: esriFieldTypeDouble, alias: Unitratef, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lastupdate (type: esriFieldTypeDouble, alias: Lastupdate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lastupdtby (type: esriFieldTypeString, alias: Lastupdtby, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Usrdef1 (type: esriFieldTypeString, alias: Usrdef1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Usrdef2 (type: esriFieldTypeString, alias: Usrdef2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Usrdef3 (type: esriFieldTypeString, alias: Usrdef3, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Usrdef4 (type: esriFieldTypeString, alias: Usrdef4, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Usrdef5 (type: esriFieldTypeString, alias: Usrdef5, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Usrdef6 (type: esriFieldTypeString, alias: Usrdef6, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Usrdef7 (type: esriFieldTypeString, alias: Usrdef7, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Usrdef8 (type: esriFieldTypeString, alias: Usrdef8, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Usrdef9 (type: esriFieldTypeString, alias: Usrdef9, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Usrdef10 (type: esriFieldTypeString, alias: Usrdef10, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Source_Table (type: esriFieldTypeString, alias: Source_Table, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Geometry_Validation (type: esriFieldTypeString, alias: Geometry_Validation, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Geometry_Repair_State (type: esriFieldTypeString, alias: Geometry_Repair_State, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: Pipe Main
Name: Pipe Main
Domains:

• Field Name: Status
  Inherited
  
• Field Name: Assettype
  Inherited
  
• Field Name: Material
  Inherited
  
• Field Name: Source
  Inherited
  
• Field Name: Method
  Inherited
  
• Field Name: Locality
  Inherited
  
Templates:

Name: Pipe Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Assettype: Pipe Main

---

ID: Trunk Main
Name: Trunk Main
Domains:

• Field Name: Status
  Inherited
  
• Field Name: Assettype
  Inherited
  
• Field Name: Material
  Inherited
  
• Field Name: Source
  Inherited
  
• Field Name: Method
  Inherited
  
• Field Name: Locality
  Inherited
  
Templates:

Name: Trunk Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Assettype: Trunk Main

---

ID: Raw Water Pipe Main
Name: Raw Water Pipe Main
Domains:

• Field Name: Status
  Inherited
  
• Field Name: Assettype
  Inherited
  
• Field Name: Material
  Inherited
  
• Field Name: Source
  Inherited
  
• Field Name: Method
  Inherited
  
• Field Name: Locality
  Inherited
  
Templates:

Name: Raw Water Pipe Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Assettype: Raw Water Pipe Main

---

ID: Service Connection
Name: Service Connection
Domains:

• Field Name: Status
  Inherited
  
• Field Name: Assettype
  Inherited
  
• Field Name: Material
  Inherited
  
• Field Name: Source
  Inherited
  
• Field Name: Method
  Inherited
  
• Field Name: Locality
  Inherited
  
Templates:

Name: Service Connection
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Assettype: Service Connection

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/24/2018 7:58:53 AM

Schema Last Edit Date: 8/24/2018 7:58:53 AM

Data Last Edit Date: 8/24/2018 7:58:53 AM

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