Layers:

Layer: Water Service Connection (0)

Name: Water Service Connection

Display Field: ACCOUNTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1523885.067741707
YMin: 524687.2976408452
XMax: 1717866.907090366
YMax: 712687.5255919397
Spatial Reference: 102722  (3734)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: FieldVerified
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [117, 153, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label: <all other values>
UniqueValueInfos:
• Value: NO
  Label: NO
  Description:
  Symbol:
  
• Value: YES
  Label: YES
  Description:
  Symbol:
  
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ACCOUNTID ( type: esriFieldTypeString, alias: Account Number, length: 30 )
• SERVICETYPE ( type: esriFieldTypeString, alias: Service Type, length: 50 , Coded Values: [1: Water] , [2: Sewer] , [3: Water and Sewer] , ...2 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, length: 200 )
• LOCATIONID ( type: esriFieldTypeString, alias: Location Identifier, length: 20 )
• CRITICAL ( type: esriFieldTypeSmallInteger, alias: CriticalCustomer )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [1: NWWSD] , [-1: Private] , [-2: Other] )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By , Coded Values: [1: NWWSD] , [2: Perrysburg] , [3: Private] , ...1 more... )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, length: 8 )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, length: 50 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• ConnectionType ( type: esriFieldTypeString, alias: ConnectionType, length: 50 , Coded Values: [MP: Meter Pit] , [CS: Curb Stop] )
• Svc_Address ( type: esriFieldTypeString, alias: Svc_Address, length: 75 )
• Status ( type: esriFieldTypeString, alias: Status, length: 75 , Coded Values: [1: Service On] , [2: Service Off] , [3: Pending] )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 200 )
• GPS_Located ( type: esriFieldTypeString, alias: GPS_Located, length: 50 , Coded Values: [GPS: Located and GPS] , [NGPS: Not Located needs GPS] , [FV: Not GPS But Field Verified] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Copper ( type: esriFieldTypeString, alias: Copper, length: 125 )
• GPSDate ( type: esriFieldTypeDate, alias: GPS Date, length: 8 )
• Link ( type: esriFieldTypeString, alias: Link, length: 125 )
• Source ( type: esriFieldTypeString, alias: Source, length: 50 )
• StealthChangedOut ( type: esriFieldTypeString, alias: Stealth Changed Out, length: 25 , Coded Values: [NO: NO] , [YES: YES] , [INACTIVE: INACTIVE] , ...1 more... )
• DateChangeOut ( type: esriFieldTypeDate, alias: Date ofChange Out, length: 8 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 175 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• leadsvcline ( type: esriFieldTypeString, alias: Lead Service Line, length: 50 , Coded Values: [NO: NO] , [YES: YES] , [INACTIVE: INACTIVE] , ...1 more... )
• PitType ( type: esriFieldTypeString, alias: Pit Type, length: 50 , Coded Values: [S: Single] , [T: Tandem] )
• FieldVerifiedBy ( type: esriFieldTypeString, alias: Field Verified By, length: 50 , Coded Values: [cb: Chris Blake] , [cf: Chad Feehan] , [tm: Tom McGrain] , ...23 more... )
• FieldVerifiedNotes ( type: esriFieldTypeString, alias: Field Notes, length: 75 , Coded Values: [Needs Attention-Ops: Needs Attention-Ops] , [Needs Attention-GIS: Needs Attention-GIS] , [Verified: Verified] , ...1 more... )
• FieldVerifiedDate ( type: esriFieldTypeDate, alias: Date Field Verified, length: 8 )
• AdditionalNotes ( type: esriFieldTypeString, alias: Additional Notes, length: 200 )
• PrjNum ( type: esriFieldTypeString, alias: Project Number, length: 25 )
• PWSID ( type: esriFieldTypeString, alias: PWS ID, length: 25 )
• TypeofAttention ( type: esriFieldTypeString, alias: Type of Attention, length: 125 , Coded Values: [Good: Good] , [Can't Locate: Can't Locate] , [Needs Repaired: Needs Repaired] , ...5 more... )
• LocationNo ( type: esriFieldTypeString, alias: LocationNo, length: 50 )
• MeterTechCrew ( type: esriFieldTypeString, alias: Meter Tech Crew, length: 50 , Coded Values: [ds: Don Straub] )
• dateofmetertechvisit ( type: esriFieldTypeDate, alias: Date of Meter Tech Visit, length: 8 )
• MeterTechNotes ( type: esriFieldTypeString, alias: Meter Tech Notes, length: 200 )
• ServiceConnectionInspectedforLe ( type: esriFieldTypeString, alias: Service Connection Inspected for Leaks, length: 50 , Coded Values: [lf: Leak Found] , [nlf: No Leak Found] , [pl: Possible Leak-Follow Up Needed] , ...1 more... )
• DateofLeakInspection ( type: esriFieldTypeDate, alias: Date of Leak Inspection, length: 8 )
• LeakInspector ( type: esriFieldTypeString, alias: Leak Inspector, length: 50 , Coded Values: [cb: Chris Blake] , [cf: Chad Feehan] , [tm: Tom McGrain] , ...5 more... )
• LeakInspectorNotes ( type: esriFieldTypeString, alias: Leak Inspector Notes, length: 225 )
• DateFixed ( type: esriFieldTypeDate, alias: Date Fixed, length: 8 )
• FieldVerified ( type: esriFieldTypeString, alias: Field Verified, length: 25 , Coded Values: [YES: YES] , [NO: NO] , [FOLLOW UP: FOLLOW UP] )
• WhoseAttentionNeeded ( type: esriFieldTypeString, alias: Whose Attention Needed, length: 50 , Coded Values: [OPs: OPs] , [GIS: GIS] , [Meter Tech: Meter Tech] )
• SrvcConnectionLoc ( type: esriFieldTypeString, alias: Service Connection Location, length: 50 , Coded Values: [Sidewalk: Sidewalk] , [Driveway: Driveway] , [Curb: Curb] , ...11 more... )

Layer: Water_Main (1)

Name: Water_Main

Display Field: Prj_Name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Water pipes connecting between manholes, pump stations and other features

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 1496226.3407399356
YMin: 1.7881393432617188E-7
XMax: 1814108.0552759916
YMax: 714991.4527620673
Spatial Reference: 102722  (3734)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: Ownership
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [232, 190, 255, 255]
Width: 2
Default Label: <all other values>
UniqueValueInfos:
• Value: NWWSD
  Label: NWWSD
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 38, 115, 255]
  Width: 3
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Main_Size ( type: esriFieldTypeDouble, alias: Main_Size , Coded Values: [1: 1] , [2: 2] , [2.5: 2 1/2] , ...28 more... )
• Material ( type: esriFieldTypeString, alias: Material, length: 5 , Coded Values: [AC: AC] , [C900: C900] , [CIP: CIP] , ...21 more... )
• Joint_Type ( type: esriFieldTypeString, alias: Joint_Type, length: 10 , Coded Values: [MECHANICAL: MECHANICAL] , [PUSH-ON: PUSH-ON] , [FUSED: FUSED] )
• Poly_Wrap ( type: esriFieldTypeString, alias: Poly_Wrap, length: 3 , Coded Values: [NO: NO] , [YES: YES] )
• Lining ( type: esriFieldTypeString, alias: Lining, length: 6 , Coded Values: [CEMENT: CEMENT] , [PVC: PVC] , [RESIN: RESIN] , ...1 more... )
• Encasement ( type: esriFieldTypeString, alias: Encasement, length: 3 , Coded Values: [NO: NO] , [YES: YES] )
• Length ( type: esriFieldTypeDouble, alias: Length )
• As_Built ( type: esriFieldTypeString, alias: As_Built, length: 3 , Coded Values: [YES: YES] , [NO: NO] )
• Yr_Install ( type: esriFieldTypeSmallInteger, alias: Yr_Install )
• Project_Num ( type: esriFieldTypeString, alias: Project_Num, length: 16 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 100 )
• Supplier ( type: esriFieldTypeString, alias: Supplier, length: 5 , Coded Values: [BG: Bowling Green] , [FOS: Fostoria] , [PB: Perrysburg] , ...7 more... )
• Ownership ( type: esriFieldTypeString, alias: Ownership, length: 10 )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• GBALINK ( type: esriFieldTypeInteger, alias: GBALINK )
• WM_ID ( type: esriFieldTypeString, alias: WM_ID, length: 15 )
• INGBAMS ( type: esriFieldTypeSmallInteger, alias: INGBAMS )
• Line_Type ( type: esriFieldTypeString, alias: Line Type, length: 50 , Coded Values: [Hyd Lead: Hydrant Lead] , [Main: Water Main] , [Service: Service line to customer] , ...2 more... )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• Previous_Owner ( type: esriFieldTypeString, alias: Previous_Owner, length: 25 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SourcePDF ( type: esriFieldTypeString, alias: SourcePDF, length: 100 )
• HyperlinkPDF ( type: esriFieldTypeString, alias: HyperlinkPDF, length: 200 )
• HLINK2 ( type: esriFieldTypeString, alias: Hyperlink, length: 125 )
• PrjLinks ( type: esriFieldTypeString, alias: PrjLinks, length: 200 )
• MapCreate ( type: esriFieldTypeString, alias: MapCreate, length: 225 )
• MapCreate2 ( type: esriFieldTypeString, alias: MapCreate2, length: 225 )
• wLineStatus ( type: esriFieldTypeString, alias: wLineStatus, length: 50 , Coded Values: [Active: Active] , [under construction: Under Construction] , [Abandoned: Abandoned] , ...2 more... )
• Prj_Status ( type: esriFieldTypeString, alias: Project Status, length: 100 )
• Prj_Name ( type: esriFieldTypeString, alias: Project Name, length: 50 )
• AssetType ( type: esriFieldTypeString, alias: AssetType, length: 75 )
• TotalMiles ( type: esriFieldTypeSingle, alias: TotalMiles )
• ServiceLineType ( type: esriFieldTypeString, alias: Service Line Type, length: 50 , Coded Values: [Copper: Copper] , [Lead: Lead] , [PVC: PVC] )
• ServiceAddress ( type: esriFieldTypeString, alias: Service Address, length: 125 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Condition ( type: esriFieldTypeString, alias: Asset Condition Rating, length: 200 , Coded Values: [0: Excellent-Asset New or Nearly New, No Known Suspected Condition] , [2: Good-Asset has Few Known Suspected Issues] , [4: Fair-Asset has Known or Suspected Issues that will Impact Assets ability to perform in Next Several Years] , ...3 more... )
• EstimatedLifeReached ( type: esriFieldTypeString, alias: Estimated Life, length: 75 , Coded Values: [NO: NO] , [YES: YES] , [YES-FOLLOW UP NEEDED: YES-FOLLOW UP NEEDED] )
• NumRepairs ( type: esriFieldTypeSmallInteger, alias: Number of Main Repairs )
• LFPrj ( type: esriFieldTypeSmallInteger, alias: Lineal Feet of Project )
• PWSID ( type: esriFieldTypeString, alias: PWS ID, length: 50 )
• Conseqoffailure ( type: esriFieldTypeString, alias: Consequence of Failure, length: 200 , Coded Values: [1: Very Minor Effect on Service or Financial Impact] , [2: Minor Service Interuption with Minor Financial Impact] , [4: Severe Service Impact with Major Financial Impact] , ...2 more... )
• ConnectionsPerPrj ( type: esriFieldTypeSmallInteger, alias: Number of Services per Project )
• Occurences ( type: esriFieldTypeString, alias: Occurences, length: 200 , Coded Values: [5: Monthly or Greater Frequency (Regularly)] , [4: 4 Times per Year (Quarterly)] , [3: About Once per Year (Annually)] , ...2 more... )
• AssetNotes ( type: esriFieldTypeString, alias: Asset Notes, length: 225 )
• NumNonlineRepairs ( type: esriFieldTypeSmallInteger, alias: Number of Non-Line Repairs )
• DateofRepair ( type: esriFieldTypeDate, alias: Date of Repair, length: 8 )
• EstimatedLife ( type: esriFieldTypeString, alias: Estimated Life, length: 75 )
• MainInspectedforLeaks ( type: esriFieldTypeString, alias: Main Inspected for Leaks, length: 255 , Coded Values: [lf: Leak Found] , [nlf: No Leak Found] , [pl: Possible Leak-Follow Up Needed] , ...1 more... )
• LeakInspector ( type: esriFieldTypeString, alias: Leak Inspector, length: 25 , Coded Values: [cb: Chris Blake] , [cf: Chad Feehan] , [tm: Tom McGrain] , ...5 more... )
• DateInspected ( type: esriFieldTypeDate, alias: Date Inspected, length: 8 )
• LeakInspectorNotes ( type: esriFieldTypeString, alias: Leak Inspector Notes, length: 225 )
• FieldPiclink ( type: esriFieldTypeString, alias: Field Picture Link, length: 75 )
• fieldpicweblink ( type: esriFieldTypeString, alias: fieldpicweblink, length: 150 )
• TFL ( type: esriFieldTypeDouble, alias: Total Lineal Feet )
• SHAPE.len ( type: esriFieldTypeDouble, alias: SHAPE.len )