Name: Service Points

Display Field: CUSTOMERNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

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: 3017498.83585401
YMin: 590507.810423285
XMax: 3086380.28692617
YMax: 680293.397194892
Spatial Reference: 102682 (3452)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"Material_Classification_for_the","field2":"","field3":"","fieldDelimiter":",","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":15,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"defaultLabel":"","uniqueValueInfos":[{"value":"Lead Status Unknown","label":"Lead Status Unknown","description":"","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":15,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}}}]},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field: Material_Classification_for_the

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• LEGACYID (type: esriFieldTypeString, alias: LEGACYID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BADGE_NBR (type: esriFieldTypeString, alias: BADGE NBR, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• COMM_MODULE_1 (type: esriFieldTypeString, alias: COMM_MODULE_1, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• COMM_MODULE_2 (type: esriFieldTypeString, alias: COMM_MODULE_2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PREMISE_ID (type: esriFieldTypeString, alias: PREMISE ID, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• METER_SIZE (type: esriFieldTypeString, alias: METER SIZE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [NO INFO: NO INFO], [34: 3/4"], [112: 1-1/2"], ... 7 more ...)
• SERVICE_TYPE (type: esriFieldTypeString, alias: SERVICE TYPE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [W-BULK: Bulk Water], [W-COM: Commercial], [W-CWONLY: Commercial (Water Only)], ... 25 more ...)
• SMART_METER (type: esriFieldTypeString, alias: SMART METER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AMI: AMI], [AMI-DD: AMI DEDUCT], [BOXONLY: BOX ONLY], ... 5 more ...)
• MANUFACTURER (type: esriFieldTypeString, alias: MANUFACTURER, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [BADGER: Badger], [BERMAD: Bermad], [ELSTER: Elster], ... 10 more ...)
• MODEL (type: esriFieldTypeString, alias: MODEL, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [COMPND: Compound], [POSDISPL: Positive Displacement], [TURBINE: Turbine], ... 2 more ...)
• METER_TYPE (type: esriFieldTypeString, alias: METER TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [COMPND3: Compound-3], [COMPND4: Compound-4], [COMPND6: Compound-6], ... 16 more ...)
• DIAL1_NBR (type: esriFieldTypeString, alias: DIAL1 NBR, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true, Coded Values: [0: 0], [4: 4], [5: 5], ... 4 more ...)
• DIAL2_NBR (type: esriFieldTypeString, alias: DIAL2 NBR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [0: 0], [4: 4], [5: 5], ... 4 more ...)
• MULTIPLIER1 (type: esriFieldTypeDouble, alias: MULTIPLIER1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MULTIPLIER2 (type: esriFieldTypeDouble, alias: MULTIPLIER2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STOCK_NBR (type: esriFieldTypeString, alias: STOCK NBR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• INSTALL_DATE (type: esriFieldTypeDate, alias: INSTALL DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GPSDATE (type: esriFieldTypeDate, alias: GPS DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GPSBY (type: esriFieldTypeString, alias: GPSBY, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• XLUS (type: esriFieldTypeDouble, alias: X-LUS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YLUS (type: esriFieldTypeDouble, alias: Y-LUS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINID (type: esriFieldTypeString, alias: MAINID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ENABLED (type: esriFieldTypeSmallInteger, alias: ENABLED, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• CUSTOMERNAME (type: esriFieldTypeString, alias: CUSTOMER NAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AB: ABANDONED], [IS: IN SERVICE], [NA: NOT CONFIRMED], ... 3 more ...)
• LOC_COMMENTS (type: esriFieldTypeString, alias: LOC COMMENTS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USAGELAST1 (type: esriFieldTypeInteger, alias: USAGE LAST 1 (GAL), SQL Type: sqlTypeOther, nullable: true, editable: true)
• USAGELAST12 (type: esriFieldTypeInteger, alias: USAGE LAST 12 AVG (GAL), SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPS (type: esriFieldTypeString, alias: GPS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [1: YES], [2: NO], [3: CAN NOT LOCATE], ... 2 more ...)
• SERVICE_ID (type: esriFieldTypeString, alias: SERVICE_ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CYCLE (type: esriFieldTypeString, alias: CYCLE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ROUTE (type: esriFieldTypeString, alias: ROUTE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• OP_AREA (type: esriFieldTypeString, alias: OP_AREA, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• INSTALL_TYPE (type: esriFieldTypeString, alias: INSTALL_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [LS: LONG SIDE], [SS: SHORT SIDE], [NOINFO: NO INFO])
• ADDRESS (type: esriFieldTypeString, alias: ADDRESS_CCB, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• PHONE_TYPE (type: esriFieldTypeString, alias: PHONE TYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PHONE (type: esriFieldTypeDouble, alias: PHONE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REMOVE_DATE (type: esriFieldTypeDate, alias: REMOVE DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ERP_BOIL (type: esriFieldTypeString, alias: ERP_BOIL, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [N/A: N/A], [DAY CARE: DAY CARE], [DIALYSIS: DIALYSIS], ... 11 more ...)
• LID_TYPE (type: esriFieldTypeString, alias: LID_TYPE, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [ALUMINUM: ALUMINUM], [COMPOSITE: COMPOSITE], [STEEL: STEEL])
• CREATEUSER (type: esriFieldTypeString, alias: CREATEUSER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DATECREATED (type: esriFieldTypeDate, alias: DATECREATED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTUSER (type: esriFieldTypeString, alias: LASTUSER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DATEMODIFIED (type: esriFieldTypeDate, alias: DATEMODIFIED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MODULE_TYPE (type: esriFieldTypeString, alias: MODULE_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [HONEYWELL: Honeywell], [NONE: None], [BADGER: Badger])
• ACCT_ID (type: esriFieldTypeString, alias: ACCT_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Street_Address (type: esriFieldTypeString, alias: Street Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Zip (type: esriFieldTypeInteger, alias: Zip, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Unique_Service_Line_ID (type: esriFieldTypeDouble, alias: Unique Service Line ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• System_Owned_Service_Line_Mater (type: esriFieldTypeString, alias: System-Owned Service Line Material, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PWSID__Autofill_ (type: esriFieldTypeString, alias: PWSID (Autofill), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• System_Name__Autofill_ (type: esriFieldTypeString, alias: System Name (Autofill), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Customer_Owned_Service_Line_Mat (type: esriFieldTypeString, alias: Customer-Owned Service Line Material, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Material_Classification_for_the (type: esriFieldTypeString, alias: Material Classification for the Entire Service Line (Autofill), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Types:

ID: Lead Status Unknown
Name: Lead Status Unknown
Domains:

• Field Name: METER_SIZE
  Inherited
  
• Field Name: SERVICE_TYPE
  Inherited
  
• Field Name: SMART_METER
  Inherited
  
• Field Name: MANUFACTURER
  Inherited
  
• Field Name: MODEL
  Inherited
  
• Field Name: METER_TYPE
  Inherited
  
• Field Name: DIAL1_NBR
  Inherited
  
• Field Name: DIAL2_NBR
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: STATUS
  Inherited
  
• Field Name: GPS
  Inherited
  
• Field Name: INSTALL_TYPE
  Inherited
  
• Field Name: ERP_BOIL
  Inherited
  
• Field Name: LID_TYPE
  Inherited
  
• Field Name: MODULE_TYPE
  Inherited
  
Templates:

Name: Lead Status Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Material_Classification_for_the: Lead Status Unknown
• ENABLED: 1
• STATUS: OS
• USAGELAST1: 0
• USAGELAST12: 0

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/27/2024 8:10:48 PM

Schema Last Edit Date: 11/27/2024 8:10:48 PM

Data Last Edit Date: 11/27/2024 8:10:48 PM

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