Layers:

Layer: Premise (37)

Name: Premise

Display Field: streetname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: eef310124b8f4299aae27a1d5f4bcb8d

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 4514.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

Extent:
XMin: 1564489.8129232824
YMin: 642056.3556095809
XMax: 1708128.8528319448
YMax: 824264.8074823767
Spatial Reference: 102722  (3734)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: <all other values>
UniqueValueInfos:
• Value: Active
  Label: Active
  Description: N/A
  Symbol:
  
• Value: Inactive
  Label: Inactive
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true
Supports Query With LOD Spatial Reference: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: status

Fields:
• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• wsl_id ( modelName: wsl_id, nullable: true, editable: true, defaultValue: null, length: 16, alias: WSL_ID, type: esriFieldTypeString )
• streetnum ( modelName: streetnum, nullable: true, editable: true, defaultValue: null, length: 10, alias: StreetNum, type: esriFieldTypeString )
• dir ( modelName: dir, nullable: true, editable: true, defaultValue: null, length: 6, alias: Dir, type: esriFieldTypeString )
• streetname ( modelName: streetname, nullable: true, editable: true, defaultValue: null, length: 60, alias: StreetName, type: esriFieldTypeString )
• streettype ( modelName: streettype, nullable: true, editable: true, defaultValue: null, length: 10, alias: StreetType, type: esriFieldTypeString )
• postdir ( modelName: postdir, nullable: true, editable: true, defaultValue: null, length: 6, alias: PostDir, type: esriFieldTypeString )
• aptunit ( modelName: aptunit, nullable: true, editable: true, defaultValue: null, length: 10, alias: AptUnit, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 40, alias: City, type: esriFieldTypeString )
• state ( modelName: state, nullable: true, editable: true, defaultValue: null, length: 2, alias: State, type: esriFieldTypeString )
• zip ( modelName: zip, nullable: true, editable: true, defaultValue: null, length: 12, alias: Zip, type: esriFieldTypeString )
• sapaddrnum ( modelName: sapaddrnum, nullable: true, editable: true, defaultValue: null, length: 16, alias: SAPaddrNum, type: esriFieldTypeString )
• keywords ( modelName: keywords, nullable: true, editable: true, defaultValue: null, length: 40, alias: Keywords, type: esriFieldTypeString )
• building ( modelName: building, nullable: true, editable: true, defaultValue: null, length: 40, alias: Building, type: esriFieldTypeString )
• assessorno ( modelName: assessorno, nullable: true, editable: true, defaultValue: null, length: 16, alias: AssessorNo, type: esriFieldTypeString )
• parcelno ( modelName: parcelno, nullable: true, editable: true, defaultValue: null, length: 16, alias: ParcelNo, type: esriFieldTypeString )
• parcelseq ( modelName: parcelseq, nullable: true, editable: true, defaultValue: null, alias: ParcelSeq, type: esriFieldTypeInteger )
• premnum ( modelName: PremNum, nullable: false, editable: true, defaultValue: null, length: 16, alias: PremNum, type: esriFieldTypeString )
• premtype ( modelName: premtype, nullable: true, editable: true, defaultValue: null, length: 4, alias: PremType, type: esriFieldTypeString )
• premaddr ( modelName: premaddr, nullable: true, editable: true, defaultValue: null, length: 255, alias: PremAddr, type: esriFieldTypeString )
• servtype ( modelName: ServType, nullable: true, editable: true, defaultValue: null, length: 16, alias: ServType, type: esriFieldTypeString , Coded Values: [WTR: WTR] , [ALTS: ALTS] , [FIRE: FIRE] , ...7 more... )
• mslat ( modelName: mslat, nullable: true, editable: true, defaultValue: null, alias: MSlat, type: esriFieldTypeDouble )
• mslong ( modelName: mslong, nullable: true, editable: true, defaultValue: null, alias: MSlong, type: esriFieldTypeDouble )
• curblat ( modelName: curblat, nullable: true, editable: true, defaultValue: null, alias: CurbLat, type: esriFieldTypeDouble )
• curblong ( modelName: curblong, nullable: true, editable: true, defaultValue: null, alias: CurbLong, type: esriFieldTypeDouble )
• centroid_x ( modelName: centroid_x, nullable: true, editable: true, defaultValue: null, alias: Centroid_X, type: esriFieldTypeDouble )
• centroid_y ( modelName: centroid_y, nullable: true, editable: true, defaultValue: null, alias: Centroid_Y, type: esriFieldTypeDouble )
• bpname ( modelName: bpname, nullable: true, editable: true, defaultValue: null, length: 145, alias: BPname, type: esriFieldTypeString )
• bpnumber ( modelName: bpnumber, nullable: true, editable: true, defaultValue: null, length: 30, alias: BPnumber, type: esriFieldTypeString )
• phone ( modelName: phone, nullable: true, editable: true, defaultValue: null, length: 30, alias: Phone, type: esriFieldTypeString )
• acctnum ( modelName: acctnum, nullable: true, editable: true, defaultValue: null, length: 20, alias: AcctNum, type: esriFieldTypeString )
• accttype ( modelName: accttype, nullable: true, editable: true, defaultValue: null, length: 1, alias: AcctType, type: esriFieldTypeString )
• regstgrp ( modelName: regstgrp, nullable: true, editable: true, defaultValue: null, length: 16, alias: RegStGrp, type: esriFieldTypeString )
• installnum ( modelName: installnum, nullable: true, editable: true, defaultValue: null, length: 16, alias: InstallNum, type: esriFieldTypeString )
• deviceloc ( modelName: deviceloc, nullable: true, editable: true, defaultValue: null, length: 16, alias: DeviceLoc, type: esriFieldTypeString )
• conobjid ( modelName: conobjid, nullable: true, editable: true, defaultValue: null, length: 16, alias: ConObjID, type: esriFieldTypeString )
• tapdesc ( modelName: tapdesc, nullable: true, editable: true, defaultValue: null, length: 255, alias: TapDesc, type: esriFieldTypeString )
• tapid ( modelName: tapid, nullable: true, editable: true, defaultValue: null, length: 80, alias: TapID, type: esriFieldTypeString )
• installdate ( modelName: installdate, nullable: true, editable: true, defaultValue: null, length: 16, alias: InstallDate, type: esriFieldTypeString )
• conobjsize ( modelName: conobjsize, nullable: true, editable: true, defaultValue: null, length: 100, alias: ConObjSize, type: esriFieldTypeString )
• tapnotes ( modelName: tapnotes, nullable: true, editable: true, defaultValue: null, length: 255, alias: TapNotes, type: esriFieldTypeString )
• tapkilled ( modelName: tapkilled, nullable: true, editable: true, defaultValue: null, length: 24, alias: TapKilled, type: esriFieldTypeString )
• created_user ( modelName: Created_User, nullable: true, editable: false, defaultValue: null, length: 12, alias: Created_User, type: esriFieldTypeString )
• created_date ( modelName: Created_date, nullable: true, editable: false, defaultValue: null, length: 29, alias: Created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: Last_edited_user, nullable: true, editable: false, defaultValue: null, length: 12, alias: Last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: Last_edited_date, nullable: true, editable: false, defaultValue: null, length: 29, alias: Last_edited_date, type: esriFieldTypeDate )
• division ( modelName: Division, nullable: true, editable: true, defaultValue: null, length: 16, alias: Division, type: esriFieldTypeString , Coded Values: [10: 10] , [20: 20] , [30: 30] , ...1 more... )
• status ( modelName: Status, nullable: true, editable: true, defaultValue: null, length: 25, alias: Status, type: esriFieldTypeString , Coded Values: [Active: Active] , [Inactive: Inactive] )
• address ( modelName: Address, nullable: true, editable: true, defaultValue: null, length: 4000, alias: Address, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: globalid, type: esriFieldTypeGlobalID )
Types:
ID: Active
Name: Active
Domains:
• division:
  Inherited
• servtype:
  Inherited
• status:
  Inherited
Templates:
• Name: Active
  Description:
  Prototype:
  bpname: null
  postdir: null
  installdate: null
  keywords: null
  streetname: null
  city: null
  acctnum: null
  tapdesc: null
  streetnum: null
  premaddr: null
  dir: null
  parcelseq: null
  mslat: null
  building: null
  division: null
  bpnumber: null
  sapaddrnum: null
  premnum:
  conobjsize: null
  curblat: null
  state: null
  tapnotes: null
  assessorno: null
  aptunit: null
  zip: null
  installnum: null
  parcelno: null
  address: null
  mslong: null
  centroid_x: null
  servtype: null
  centroid_y: null
  deviceloc: null
  accttype: null
  tapid: null
  streettype: null
  curblong: null
  phone: null
  conobjid: null
  regstgrp: null
  wsl_id: null
  premtype: null
  status: Active
  tapkilled: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Inactive
Name: Inactive
Domains:
• division:
  Inherited
• servtype:
  Inherited
• status:
  Inherited
Templates:
• Name: Inactive
  Description:
  Prototype:
  bpname: null
  postdir: null
  installdate: null
  keywords: null
  streetname: null
  city: null
  acctnum: null
  tapdesc: null
  streetnum: null
  premaddr: null
  dir: null
  parcelseq: null
  mslat: null
  building: null
  division: null
  bpnumber: null
  sapaddrnum: null
  premnum:
  conobjsize: null
  curblat: null
  state: null
  tapnotes: null
  assessorno: null
  aptunit: null
  zip: null
  installnum: null
  parcelno: null
  address: null
  mslong: null
  centroid_x: null
  servtype: null
  centroid_y: null
  deviceloc: null
  accttype: null
  tapid: null
  streettype: null
  curblong: null
  phone: null
  conobjid: null
  regstgrp: null
  wsl_id: null
  premtype: null
  status: Inactive
  tapkilled: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• WTRSAPMETER (0) -- Related To: wtrSAPMeter (29)

Layer: wtrServiceLateral (42)

Name: wtrServiceLateral

Display Field: stname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: eef310124b8f4299aae27a1d5f4bcb8d

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 6000.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

Extent:
XMin: 1599359.8450927734
YMin: 672105.771118179
XMax: 1707612.573486358
YMax: 754176.604675293
Spatial Reference: 102722  (3734)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: svctype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Domestic
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 255, 255]
  Width: 2
• Value: 2
  Label: Fire
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 255, 255]
  Width: 3
• Value: 3
  Label: Irrigation
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 255, 255]
  Width: 3
• Value: 4
  Label: Null
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [115, 223, 255, 255]
  Width: 2
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true
Supports Query With LOD Spatial Reference: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: svctype

Fields:
• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• assetid ( modelName: AssetID, nullable: true, editable: true, defaultValue: null, length: 20, alias: AssetID, type: esriFieldTypeString )
• legacyid ( modelName: LegacyID, nullable: true, editable: true, defaultValue: null, length: 20, alias: LegacyID, type: esriFieldTypeString )
• installationdate ( modelName: InstallationDate, nullable: true, editable: true, defaultValue: null, length: 29, alias: InstallationDate, type: esriFieldTypeDate )
• location ( modelName: Location, nullable: true, editable: true, defaultValue: null, length: 250, alias: Location, type: esriFieldTypeString )
• status ( modelName: Status, nullable: true, editable: true, defaultValue: null, length: 10, alias: Status, type: esriFieldTypeString , Coded Values: [A: Abandoned] , [EOC: End of Contract] , [P: Abandoned and Filled] , ...9 more... )
• source ( modelName: Source, nullable: true, editable: true, defaultValue: null, length: 20, alias: Source, type: esriFieldTypeString , Coded Values: [ATL: Atlas] , [ASB: As Built] , [FVE: Field Verified] , ...14 more... )
• comments ( modelName: Comments, nullable: true, editable: true, defaultValue: null, length: 250, alias: Comments, type: esriFieldTypeString )
• svctype ( modelName: SvcType, nullable: true, editable: true, defaultValue: 1, alias: Type, type: esriFieldTypeInteger )
• diameter ( modelName: Diameter, nullable: true, editable: true, defaultValue: null, alias: Service Size, type: esriFieldTypeDouble , Coded Values: [0.625: 5/8] , [0.75: 3/4] , [1: 1] , ...9 more... )
• asbuilt ( modelName: Asbuilt, nullable: true, editable: true, defaultValue: null, length: 20, alias: Asbuilt, type: esriFieldTypeString )
• tapmaindiam ( modelName: TapMainDiam, nullable: true, editable: true, defaultValue: null, alias: Tapped Main Diameter, type: esriFieldTypeDouble , Coded Values: [4: 4] , [6: 6] , [8: 8] , ...16 more... )
• address ( modelName: Address, nullable: true, editable: true, defaultValue: null, length: 60, alias: Address, type: esriFieldTypeString )
• depthofcover ( modelName: DepthOfCover, nullable: true, editable: true, defaultValue: null, alias: Depth of Main at Tap, type: esriFieldTypeDouble )
• stnumber ( modelName: StNumber, nullable: true, editable: true, defaultValue: null, length: 25, alias: Street Number, type: esriFieldTypeString )
• stname ( modelName: StName, nullable: true, editable: true, defaultValue: null, length: 50, alias: Street Name, type: esriFieldTypeString )
• length ( modelName: Length, nullable: true, editable: true, defaultValue: null, alias: Pipe Length, type: esriFieldTypeDouble )
• wo ( modelName: WO, nullable: true, editable: true, defaultValue: null, length: 7, alias: WO, type: esriFieldTypeString )
• overtap ( modelName: OverTap, nullable: true, editable: true, defaultValue: null, length: 3, alias: OverTap, type: esriFieldTypeString , Coded Values: [NO: NO] , [YES: YES] )
• split ( modelName: Split, nullable: true, editable: true, defaultValue: null, length: 10, alias: Split, type: esriFieldTypeString , Coded Values: [NO: NO] , [YES: YES] )
• urllink ( modelName: URLLink, nullable: true, editable: true, defaultValue: null, length: 200, alias: URLLink, type: esriFieldTypeString )
• date_material_verified ( modelName: Date_Material_Verified, nullable: true, editable: true, defaultValue: null, length: 29, alias: Date_Material_Verified, type: esriFieldTypeDate )
• cityownedmaterial ( modelName: Material, nullable: true, editable: true, defaultValue: null, length: 30, alias: CityOwnedMaterial, type: esriFieldTypeString , Coded Values: [LEAD: LEAD] , [GALVANIZED: GALVANIZED] , [UNKNOWN: UNKNOWN] , ...4 more... )
• customerownedmaterial ( modelName: Mat_Cust, nullable: true, editable: true, defaultValue: null, length: 30, alias: Customer Owned Material, type: esriFieldTypeString , Coded Values: [LEAD: LEAD] , [GALVANIZED: GALVANIZED] , [UNKNOWN: UNKNOWN] , ...4 more... )
• datecitymaterialreplaced ( modelName: DateLeadReplaced, nullable: true, editable: true, defaultValue: null, length: 29, alias: Date City Material Replaced, type: esriFieldTypeDate )
• datecustomermaterialreplaced ( modelName: DateCustSideReplaced, nullable: true, editable: true, defaultValue: null, length: 29, alias: DateCustomerMaterialReplaced, type: esriFieldTypeDate )
• datekilled ( modelName: DateKilled, nullable: true, editable: true, defaultValue: null, length: 29, alias: Date Killed, type: esriFieldTypeDate )
• city ( modelName: Owner, nullable: true, editable: true, defaultValue: null, length: 50, alias: City, type: esriFieldTypeString )
• zipcode ( modelName: CustomerType, nullable: true, editable: true, defaultValue: null, length: 20, alias: ZipCode, type: esriFieldTypeString )
• plan_hyperlink ( modelName: Plan, nullable: true, editable: true, defaultValue: null, length: 150, alias: Plan Hyperlink, type: esriFieldTypeString )
• longitude ( modelName: X, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• latitude ( modelName: Y, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• pwsid ( modelName: PWSID, nullable: true, editable: true, defaultValue: null, length: 25, alias: PWSID, type: esriFieldTypeString )
• county ( modelName: County, nullable: true, editable: true, defaultValue: null, length: 50, alias: County, type: esriFieldTypeString )
• premise ( modelName: ConObj, nullable: true, editable: true, defaultValue: null, length: 50, alias: Premise, type: esriFieldTypeString )
• requiredreplacement ( modelName: RequiredReplacement, nullable: true, editable: true, defaultValue: null, length: 50, alias: RequiredReplacement, type: esriFieldTypeString , Coded Values: [LEAD: LEAD] , [GALVANIZED: GALVANIZED] , [UNKNOWN: UNKNOWN] )
• planname ( modelName: PlanName, nullable: true, editable: true, defaultValue: null, length: 30, alias: PlanName, type: esriFieldTypeString )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: globalid, type: esriFieldTypeGlobalID )
Types:
ID: 1
Name: Domestic
Domains:
• split:
  Inherited
• diameter:
  Inherited
• customerownedmaterial:
  Inherited
• tapmaindiam:
  Inherited
• cityownedmaterial:
  Inherited
• source:
  Inherited
• overtap:
  Inherited
• status:
  Inherited
Templates:
• Name: Domestic
  Description:
  Prototype:
  city: null
  pwsid: null
  installationdate: null
  latitude: null
  county: null
  requiredreplacement: null
  date_material_verified: null
  source: null
  urllink: null
  split: null
  diameter: null
  premise: null
  planname: null
  wo: null
  asbuilt: null
  depthofcover: null
  longitude: null
  comments: null
  address: null
  customerownedmaterial: null
  tapmaindiam: null
  datekilled: null
  svctype: 1
  length: null
  datecitymaterialreplaced: null
  zipcode: null
  assetid: null
  cityownedmaterial: null
  stnumber: null
  legacyid: null
  location: null
  overtap: null
  plan_hyperlink: null
  datecustomermaterialreplaced: null
  status: null
  stname: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: Fire
Domains:
• split:
  Inherited
• diameter:
  Inherited
• customerownedmaterial:
  Inherited
• tapmaindiam:
  Inherited
• cityownedmaterial:
  Inherited
• source:
  Inherited
• overtap:
  Inherited
• status:
  Inherited
Templates:
• Name: Fire
  Description:
  Prototype:
  city: null
  pwsid: null
  installationdate: null
  latitude: null
  county: null
  requiredreplacement: null
  date_material_verified: null
  source: null
  urllink: null
  split: null
  diameter: null
  premise: null
  planname: null
  wo: null
  asbuilt: null
  depthofcover: null
  longitude: null
  comments: null
  address: null
  customerownedmaterial: null
  tapmaindiam: null
  datekilled: null
  svctype: 2
  length: null
  datecitymaterialreplaced: null
  zipcode: null
  assetid: null
  cityownedmaterial: null
  stnumber: null
  legacyid: null
  location: null
  overtap: null
  plan_hyperlink: null
  datecustomermaterialreplaced: null
  status: null
  stname: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 3
Name: Irrigation
Domains:
• split:
  Inherited
• diameter:
  Inherited
• customerownedmaterial:
  Inherited
• tapmaindiam:
  Inherited
• cityownedmaterial:
  Inherited
• source:
  Inherited
• overtap:
  Inherited
• status:
  Inherited
Templates:
• Name: Irrigation
  Description:
  Prototype:
  city: null
  pwsid: null
  installationdate: null
  latitude: null
  county: null
  requiredreplacement: null
  date_material_verified: null
  source: null
  urllink: null
  split: null
  diameter: null
  premise: null
  planname: null
  wo: null
  asbuilt: null
  depthofcover: null
  longitude: null
  comments: null
  address: null
  customerownedmaterial: null
  tapmaindiam: null
  datekilled: null
  svctype: 3
  length: null
  datecitymaterialreplaced: null
  zipcode: null
  assetid: null
  cityownedmaterial: null
  stnumber: null
  legacyid: null
  location: null
  overtap: null
  plan_hyperlink: null
  datecustomermaterialreplaced: null
  status: null
  stname: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 4
Name: Unknown
Domains:
• split:
  Inherited
• diameter:
  Inherited
• customerownedmaterial:
  Inherited
• tapmaindiam:
  Inherited
• cityownedmaterial:
  Inherited
• source:
  Inherited
• overtap:
  Inherited
• status:
  Coded Values: [I: In Service] , [R: Removed] , [K: Killed] , ...2 more...
Templates:
• Name: Null
  Description:
  Prototype:
  city: null
  pwsid: null
  installationdate: null
  latitude: null
  county: null
  requiredreplacement: null
  date_material_verified: null
  source: null
  urllink: null
  split: null
  diameter: null
  premise: null
  planname: null
  wo: null
  asbuilt: null
  depthofcover: null
  longitude: null
  comments: null
  address: null
  customerownedmaterial: null
  tapmaindiam: null
  datekilled: null
  svctype: 4
  length: null
  datecitymaterialreplaced: null
  zipcode: null
  assetid: null
  cityownedmaterial: null
  stnumber: null
  legacyid: null
  location: null
  overtap: null
  plan_hyperlink: null
  datecustomermaterialreplaced: null
  status: null
  stname: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Tables:

Table: wtrSAPMeter (29)

Name: wtrSAPMeter

Display Field: mtrserial

Type: Table

Geometry Type: N/A

Description:

Service Item Id: eef310124b8f4299aae27a1d5f4bcb8d

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( modelName: OBJECTID, nullable: false, editable: true, defaultValue: null, alias: OBJECTID, type: esriFieldTypeInteger )
• devicecat ( modelName: devicecat, nullable: true, editable: true, defaultValue: null, length: 24, alias: DeviceCat, type: esriFieldTypeString )
• equipnum ( modelName: equipnum, nullable: true, editable: true, defaultValue: null, length: 15, alias: Unique Identifier, type: esriFieldTypeString )
• created_user ( modelName: created_user, nullable: true, editable: true, defaultValue: null, length: 12, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: true, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: true, defaultValue: null, length: 12, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: true, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• objectid_1 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID_1, alias: OBJECTID_1 )
• mtrserial ( modelName: mtrserial, nullable: true, editable: true, defaultValue: null, length: 15, alias: MtrSerial, type: esriFieldTypeString )
• premnum ( modelName: premnum, nullable: true, editable: true, defaultValue: null, length: 15, alias: PremNum, type: esriFieldTypeString )
• mtrservid ( modelName: mtrservid, nullable: true, editable: true, defaultValue: null, length: 16, alias: MtrServID, type: esriFieldTypeString )
• mtrmanuf ( modelName: MtrManuf, nullable: true, editable: true, defaultValue: null, length: 25, alias: MtrManuf, type: esriFieldTypeString , Coded Values: [A_American: A_American] , [B_Badger: B_Badger] , [C_Carlon: C_Carlon] , ...14 more... )
• mtrmodel ( modelName: mtrmodel, nullable: true, editable: true, defaultValue: null, length: 25, alias: MtrModel, type: esriFieldTypeString )
• mtrsize ( modelName: MtrSize, nullable: true, editable: true, defaultValue: null, length: 6, alias: MtrSize, type: esriFieldTypeString , Coded Values: [3/4": 3/4"] , [5/8": 5/8"] , [1": 1"] , ...10 more... )
• mtrstatus ( modelName: MtrStatus, nullable: true, editable: true, defaultValue: null, length: 4, alias: MtrStatus, type: esriFieldTypeString , Coded Values: [AVLB: AVLB] , [DLFL: DLFL] , [ESTO: ESTO] , ...2 more... )
• stkrmloca ( modelName: stkrmloca, nullable: true, editable: true, defaultValue: null, length: 25, alias: StkRmLoca, type: esriFieldTypeString )
• low ( modelName: low, nullable: true, editable: true, defaultValue: null, alias: Low, type: esriFieldTypeDouble )
• med ( modelName: med, nullable: true, editable: true, defaultValue: null, alias: Med, type: esriFieldTypeDouble )
• high ( modelName: high, nullable: true, editable: true, defaultValue: null, alias: High, type: esriFieldTypeDouble )
• pipematcs ( modelName: pipematcs, nullable: true, editable: true, defaultValue: null, alias: PipeMatCS, type: esriFieldTypeInteger )
• mtrlat ( modelName: mtrlat, nullable: true, editable: true, defaultValue: null, alias: MtrLat, type: esriFieldTypeDouble )
• mtrlong ( modelName: mtrlong, nullable: true, editable: true, defaultValue: null, alias: MtrLong, type: esriFieldTypeDouble )
• manufdate ( modelName: manufdate, nullable: true, editable: true, defaultValue: null, length: 29, alias: ManufDate, type: esriFieldTypeDate )
• receiveddt ( modelName: receiveddt, nullable: true, editable: true, defaultValue: null, length: 29, alias: ReceivedDt, type: esriFieldTypeDate )
• installdt ( modelName: installdt, nullable: true, editable: true, defaultValue: null, length: 29, alias: InstallDt, type: esriFieldTypeDate )
• warrntydt ( modelName: warrntydt, nullable: true, editable: true, defaultValue: null, length: 29, alias: WarrntyDt, type: esriFieldTypeDate )
• installnum ( modelName: InstallNum, nullable: true, editable: true, defaultValue: null, length: 20, alias: InstallNum, type: esriFieldTypeString )
• installtype ( modelName: installtype, nullable: true, editable: true, defaultValue: null, length: 20, alias: InstallType, type: esriFieldTypeString )
• ratecat ( modelName: ratecat, nullable: true, editable: true, defaultValue: null, length: 10, alias: RateCat, type: esriFieldTypeString )
• creationdate ( modelName: creationdate, nullable: true, editable: false, defaultValue: null, length: 29, alias: CreationDate, type: esriFieldTypeDate )
• creator ( modelName: creator, nullable: true, editable: false, defaultValue: null, length: 255, alias: Creator, type: esriFieldTypeString )
• editdate ( modelName: editdate, nullable: true, editable: false, defaultValue: null, length: 29, alias: EditDate, type: esriFieldTypeDate )
• editor ( modelName: editor, nullable: true, editable: false, defaultValue: null, length: 255, alias: Editor, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: globalid, type: esriFieldTypeGlobalID )
Templates:
• Name: wtrSAPMeter
  Description:
  Prototype:
  devicecat: null
  installtype: null
  receiveddt: null
  mtrmanuf: null
  equipnum: null
  mtrlat: null
  warrntydt: null
  med: null
  manufdate: null
  installdt: null
  high: null
  low: null
  mtrlong: null
  premnum: null
  mtrsize: null
  last_edited_date: null
  installnum: null
  mtrstatus: null
  created_user: null
  ratecat: null
  mtrservid: null
  mtrserial: null
  pipematcs: null
  last_edited_user: null
  mtrmodel: null
  stkrmloca: null
  created_date: null
  objectid: 0
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Premise (0) -- Related To: Premise (37)