View In:   ArcGIS Online Map Viewer

Name: Water Service Line Swordfished

Display Field: INSTALLDATE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 55065febea214b498055aef4d968462c

Copyright Text:

Default Visibility: false

MaxRecordCount: 18000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 2590285.4434062466
YMin: 2077224.955628492
XMax: 2644168.0810475796
YMax: 2117440.1993448213
Spatial Reference: 102714  (2259)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SwordfishComplete
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Swordfish Not Needed
  Label: Swordfish Not Needed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 2
• Value: Both Sides Complete
  Label: Both Sides Complete
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [76, 230, 0, 255]
  Width: 2
• Value: City Side Complete
  Label: City Side Complete
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 2
• Value: Customer Side Complete
  Label: Customer Side Complete
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 2
• Value: Not Complete
  Label: Not Complete
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 85, 0, 255]
  Width: 2
Transparency: 0
Labeling Info:

Feature Draw Order:

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SwordfishComplete

Fields:

• EAMID ( type: esriFieldTypeString, alias: EAM ID, editable: false, nullable: true, length: 25, defaultValue: null, modelName: EAMID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• DIAMETER ( type: esriFieldTypeString, alias: Diameter, editable: false, nullable: true, length: 8, defaultValue: 1, modelName: DIAMETER , Coded Values: [1: 1 Inch] , [1.25: 1.25 Inch] , [1.5: 1.5 Inch] , ...26 more... )
• CitySidePipeMat ( type: esriFieldTypeString, alias: City Side Pipe Material, editable: true, nullable: true, length: 255, defaultValue: LSU, modelName: CitySidePipeMat , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...46 more... )
• CustomSidePipeMat ( type: esriFieldTypeString, alias: Customer Side Pipe Material, editable: true, nullable: true, length: 255, defaultValue: LSU, modelName: CustomSidePipeMat , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...46 more... )
• CityCnnectrs_LeadGalv ( type: esriFieldTypeString, alias: City Side Connectors Lead or Galv, editable: true, nullable: true, length: 50, defaultValue: Unknown, modelName: CityCnnectrs_LeadGalv , Coded Values: [Lead: Lead] , [Unknown: Unknown] , [Galvanized: Galvanized] , ...5 more... )
• CustomerCnnectrs_LeadGalv ( type: esriFieldTypeString, alias: Customer Side Connectors Lead or Galv, editable: true, nullable: true, length: 50, defaultValue: Unknown, modelName: CustomerCnnectrs_LeadGalv , Coded Values: [Lead: Lead] , [Unknown: Unknown] , [Galvanized: Galvanized] , ...5 more... )
• MaterialVerified ( type: esriFieldTypeString, alias: Both Materials Verified, editable: true, nullable: true, length: 255, defaultValue: No, modelName: MaterialVerified , Coded Values: [Yes: Yes] , [No: No] )
• MaterialDateVerified ( type: esriFieldTypeDate, alias: Date Materials Verified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MaterialDateVerified )
• MaterialVerifiedBy ( type: esriFieldTypeString, alias: Materials Verified By, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MaterialVerifiedBy )
• MaterialVerificationTechnique ( type: esriFieldTypeString, alias: Material Verification Technique, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MaterialVerificationTechnique , Coded Values: [Field Verification: Field Verification] , [Desk Review/Historic Documents: Desk Review/Historic Documents] , [Other. See Material Notes: Other. See Material Notes] , ...1 more... )
• MaterialVerificationNotes ( type: esriFieldTypeString, alias: Material Verification Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: MaterialVerificationNotes )
• ExcavationNeeded ( type: esriFieldTypeString, alias: Excavation Needed For Verification, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ExcavationNeeded , Coded Values: [Yes: Yes] , [No: No] )
• SwordfishComplete ( type: esriFieldTypeString, alias: Swordfish Complete, editable: true, nullable: true, length: 255, defaultValue: Not Complete, modelName: SwordfishComplete , Coded Values: [City Side Complete: City Side Complete] , [Customer Side Complete: Customer Side Complete] , [Both Sides Complete: Both Sides Complete] , ...2 more... )
• DateSwordfishComplete ( type: esriFieldTypeDate, alias: Date Swordfish Complete, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateSwordfishComplete )
• 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 Edit User, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• InstallYear ( type: esriFieldTypeString, alias: Install Year, editable: false, nullable: true, length: 4, defaultValue: null, modelName: InstallYear )
• LocationApproved ( type: esriFieldTypeString, alias: Location Approved, editable: false, nullable: true, length: 255, defaultValue: No, modelName: LocationApproved , Coded Values: [Yes: Yes] , [No: No] )
• Address ( type: esriFieldTypeString, alias: Address, editable: false, nullable: true, length: 255, defaultValue: null, modelName: Address )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: Swordfish Not Needed
Name: Swordfish Not Needed
Domains:
• DIAMETER:
  Inherited
• CitySidePipeMat:
  Inherited
• CustomSidePipeMat:
  Inherited
• CityCnnectrs_LeadGalv:
  Inherited
• CustomerCnnectrs_LeadGalv:
  Inherited
• MaterialVerified:
  Inherited
• MaterialVerificationTechnique:
  Inherited
• ExcavationNeeded:
  Inherited
• SwordfishComplete:
  Inherited
• LocationApproved:
  Inherited
• OWNEDBY:
  Inherited
• LIFECYCLE:
  Inherited
• INSTALLEDBY:
  Inherited
• Exception:
  Inherited
• TapClockLocation:
  Inherited
Templates:
• Name: Swordfish Not Needed
  Description:
  Prototype:
  MaterialVerificationNotes: null
  SwordfishComplete: Swordfish Not Needed
  ExcavationNeeded: null
  DateSwordfishComplete: null
  CitySidePipeMat: LSU
  CustomSidePipeMat: LSU
  CityCnnectrs_LeadGalv: Unknown
  CustomerCnnectrs_LeadGalv: Unknown
  MaterialVerified: No
  MaterialDateVerified: null
  MaterialVerifiedBy: null
  MaterialVerificationTechnique: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Both Sides Complete
Name: Both Sides Complete
Domains:
• DIAMETER:
  Inherited
• CitySidePipeMat:
  Inherited
• CustomSidePipeMat:
  Inherited
• CityCnnectrs_LeadGalv:
  Inherited
• CustomerCnnectrs_LeadGalv:
  Inherited
• MaterialVerified:
  Inherited
• MaterialVerificationTechnique:
  Inherited
• ExcavationNeeded:
  Inherited
• SwordfishComplete:
  Inherited
• LocationApproved:
  Inherited
• OWNEDBY:
  Inherited
• LIFECYCLE:
  Inherited
• INSTALLEDBY:
  Inherited
• Exception:
  Inherited
• TapClockLocation:
  Inherited
Templates:
• Name: Both Sides Complete
  Description:
  Prototype:
  MaterialVerificationNotes: null
  SwordfishComplete: Both Sides Complete
  ExcavationNeeded: null
  DateSwordfishComplete: null
  CitySidePipeMat: LSU
  CustomSidePipeMat: LSU
  CityCnnectrs_LeadGalv: Unknown
  CustomerCnnectrs_LeadGalv: Unknown
  MaterialVerified: No
  MaterialDateVerified: null
  MaterialVerifiedBy: null
  MaterialVerificationTechnique: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: City Side Complete
Name: City Side Complete
Domains:
• DIAMETER:
  Inherited
• CitySidePipeMat:
  Inherited
• CustomSidePipeMat:
  Inherited
• CityCnnectrs_LeadGalv:
  Inherited
• CustomerCnnectrs_LeadGalv:
  Inherited
• MaterialVerified:
  Inherited
• MaterialVerificationTechnique:
  Inherited
• ExcavationNeeded:
  Inherited
• SwordfishComplete:
  Inherited
• LocationApproved:
  Inherited
• OWNEDBY:
  Inherited
• LIFECYCLE:
  Inherited
• INSTALLEDBY:
  Inherited
• Exception:
  Inherited
• TapClockLocation:
  Inherited
Templates:
• Name: City Side Complete
  Description:
  Prototype:
  MaterialVerificationNotes: null
  SwordfishComplete: City Side Complete
  ExcavationNeeded: null
  DateSwordfishComplete: null
  CitySidePipeMat: LSU
  CustomSidePipeMat: LSU
  CityCnnectrs_LeadGalv: Unknown
  CustomerCnnectrs_LeadGalv: Unknown
  MaterialVerified: No
  MaterialDateVerified: null
  MaterialVerifiedBy: null
  MaterialVerificationTechnique: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Customer Side Complete
Name: Customer Side Complete
Domains:
• DIAMETER:
  Inherited
• CitySidePipeMat:
  Inherited
• CustomSidePipeMat:
  Inherited
• CityCnnectrs_LeadGalv:
  Inherited
• CustomerCnnectrs_LeadGalv:
  Inherited
• MaterialVerified:
  Inherited
• MaterialVerificationTechnique:
  Inherited
• ExcavationNeeded:
  Inherited
• SwordfishComplete:
  Inherited
• LocationApproved:
  Inherited
• OWNEDBY:
  Inherited
• LIFECYCLE:
  Inherited
• INSTALLEDBY:
  Inherited
• Exception:
  Inherited
• TapClockLocation:
  Inherited
Templates:
• Name: Customer Side Complete
  Description:
  Prototype:
  MaterialVerificationNotes: null
  SwordfishComplete: Customer Side Complete
  ExcavationNeeded: null
  DateSwordfishComplete: null
  CitySidePipeMat: LSU
  CustomSidePipeMat: LSU
  CityCnnectrs_LeadGalv: Unknown
  CustomerCnnectrs_LeadGalv: Unknown
  MaterialVerified: No
  MaterialDateVerified: null
  MaterialVerifiedBy: null
  MaterialVerificationTechnique: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Not Complete
Name: Not Complete
Domains:
• DIAMETER:
  Inherited
• CitySidePipeMat:
  Inherited
• CustomSidePipeMat:
  Inherited
• CityCnnectrs_LeadGalv:
  Inherited
• CustomerCnnectrs_LeadGalv:
  Inherited
• MaterialVerified:
  Inherited
• MaterialVerificationTechnique:
  Inherited
• ExcavationNeeded:
  Inherited
• SwordfishComplete:
  Inherited
• LocationApproved:
  Inherited
• OWNEDBY:
  Inherited
• LIFECYCLE:
  Inherited
• INSTALLEDBY:
  Inherited
• Exception:
  Inherited
• TapClockLocation:
  Inherited
Templates:
• Name: Water Service Line
  Description:
  Prototype:
  ExcavationNeeded: null
  SwordfishComplete: Not Complete
  DateSwordfishComplete: null
  CitySidePipeMat: LSU
  CustomSidePipeMat: LSU
  CityCnnectrs_LeadGalv: Unknown
  CustomerCnnectrs_LeadGalv: Unknown
  MaterialVerified: No
  MaterialDateVerified: null
  MaterialVerifiedBy: null
  MaterialVerificationTechnique: null
  MaterialVerificationNotes: null
  
  Drawing Tool: esriFeatureEditToolLine

---

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

Supports Coordinates Quantization: true

Child Resources:

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