Layers:

Layer: WaterMeter Service Line (38)

Name: WaterMeter Service Line

Display Field: AccountName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: abaecec2daaf4462a48ca09186896be1

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: 2508613.4870793074
YMin: 7078095.117434308
XMax: 3.81214904951067E7
YMax: 1.2716343071886972E7
Spatial Reference: 102738  (2276)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: SysOwnPortServLineMatClass
Field 2: CustoOwnPortServLineMatClass
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Galvanized,Non-Lead Copper
  Label: Galvanized | Non-Lead - Copper
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Copper,Galvanized
  Label: Copper | Galvanized
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Copper,Non-Lead Copper
  Label: Copper | Non-Lead - Copper
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Copper,Non-Lead Plastic
  Label: Copper | Plastic
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Other,Non-Lead - Plastic
  Label: Other | Plastic
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Other,Non-Lead Other
  Label: Other | Other
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Other,Unknown Material Unknown
  Label: Other | Material Unknown
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Plastic,Galvanized
  Label: Plastic | Galvanized
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Plastic,Non-Lead Copper
  Label: Plastic | Copper
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Plastic,Non-Lead Plastic
  Label: Plastic | Plastic
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Plastic,Unknown Material Unknown
  Label: Plastic | Material Unknown
  Description: N/A
  Symbol:
  
• Value: Non-Lead Copper,Unknown Material Unknown
  Label: Copper | Material Unknown
  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: 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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: ObjectID )
• UniqueServiceLineID ( type: esriFieldTypeString, alias: Unique Service Line-ID, length: 20 )
• AccountName ( type: esriFieldTypeString, alias: AccountName, length: 100 )
• Address ( type: esriFieldTypeString, alias: Address, length: 255 )
• COA_FullAddress ( type: esriFieldTypeString, alias: COA_FullAddress, length: 80 )
• OriginalInstallDate ( type: esriFieldTypeDate, alias: OriginalInstallDate, length: 8 )
• Size ( type: esriFieldTypeString, alias: Size, length: 255 )
• SubmeterLat ( type: esriFieldTypeDouble, alias: SubmeterLatitude )
• SubmeterLong ( type: esriFieldTypeDouble, alias: SubmeterLongitude )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• PROP_ID ( type: esriFieldTypeDouble, alias: PROP_ID )
• GEO_ID ( type: esriFieldTypeString, alias: GEO_ID, length: 20 )
• CWID ( type: esriFieldTypeString, alias: CWID, length: 20 )
• TYL_AddPoint_ID ( type: esriFieldTypeString, alias: TYL_AddPoint_ID, length: 9 )
• StreetName ( type: esriFieldTypeString, alias: StreetName, length: 60 )
• StreetNumber ( type: esriFieldTypeString, alias: Street Number, length: 10 )
• City ( type: esriFieldTypeString, alias: City, length: 20 )
• Zipcode ( type: esriFieldTypeString, alias: ZipCode, length: 20 )
• AccountID ( type: esriFieldTypeDouble, alias: AccountID )
• CycleRoute ( type: esriFieldTypeString, alias: CycleRoute, length: 255 )
• nSerialNumber ( type: esriFieldTypeString, alias: nSerialNumber, length: 255 )
• nRadioID ( type: esriFieldTypeString, alias: nRadioID, length: 255 )
• SysOwnPortServLineMatClass ( type: esriFieldTypeString, alias: System-Owned Portion Service Line Material Classification, length: 30 , Coded Values: [Lead: Lead] , [Lead-line Galvanized: Lead-Llne Galvanized] , [Galvanized: Galvanized] , ...7 more... )
• CustoOwnPortServLineMatClass ( type: esriFieldTypeString, alias: Customer-Owned Portion Service Line Material Classification, length: 30 , Coded Values: [Lead: Lead] , [Lead-line Galvanized: Lead-Llne Galvanized] , [Galvanized: Galvanized] , ...7 more... )
• CollinCADBldgYearBuilt ( type: esriFieldTypeString, alias: Collin County Appraisal District Original Building Built Year Built, length: 10 )
• ServLineSYSTEMInstallDateRANG ( type: esriFieldTypeString, alias: Service Line Installation Date-Range (System-Owned Portion), length: 50 , Coded Values: [Before1898: Before 1989] , [Between1989and2014: Between 1989 and 2014] , [After2014: After 2014] , ...1 more... )
• ServLineCUSTOMInstallDateRANG ( type: esriFieldTypeString, alias: Service Line Installation Date-Range (Customer-Owned Portion), length: 50 , Coded Values: [Before1898: Before 1989] , [Between1989and2014: Between 1989 and 2014] , [After2014: After 2014] , ...1 more... )
• FireLine ( type: esriFieldTypeString, alias: FireLine/BackFlow, length: 15 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] , ...2 more... )
• OtherLocationIdentifier ( type: esriFieldTypeString, alias: Other Location Identifier, length: 80 , Coded Values: [Xx: Other Sign] )
• BuildingTypeConnect2ServLine ( type: esriFieldTypeString, alias: Building Type Connected to Service Line (Additional Information to Assign Tap Monitoring Tiering), length: 50 , Coded Values: [Single Family Residence: Singe-Family Residence] , [Multiple Family Residence: Multiple Family Residence] , [Building: Building] , ...1 more... )
• IfNonLeadColJWasMatPrevLead ( type: esriFieldTypeString, alias: If Non-Lead in Column J, Was Material Ever Previously Lead?, length: 15 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] , ...2 more... )
• Notes_SystemOwned ( type: esriFieldTypeString, alias: Notes (System Owned), length: 255 )
• Notes_CustomerOwned ( type: esriFieldTypeString, alias: Notes (Customer Owned), length: 255 )
• EntireServLineMaterialClass ( type: esriFieldTypeString, alias: Entire Service Line Material Classification, length: 100 , Coded Values: [Lead: Lead] , [Lead-line Galvanized: Lead-Llne Galvanized] , [Galvanized: Galvanized] , ...7 more... )
• IsThereALeadConnect_OTHER ( type: esriFieldTypeString, alias: Is there a Lead Connector? (Other Potential Sources of Lead), length: 25 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] , ...2 more... )
• IsSolderinService_OTHER ( type: esriFieldTypeString, alias: Is there Lead Solder in the Service Line? (Other Potential Sources of Lead), length: 25 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] , ...2 more... )
• DescOthFitEquiConn2ServCLead ( type: esriFieldTypeString, alias: Describe Other Fittings and Equipment Connected to the Service Line that Contain Lead (Other Potential Sources of Lead), length: 300 )
• PtofEntryorPtofUseTreatPresnt ( type: esriFieldTypeString, alias: Point-of-Entry or Point-of-Use Treatment Present? (Additional Information to Assign Tap Monitoring Tiering), length: 20 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] , ...2 more... )
• InBldgPlumbCoppwLeadSoldBJul8 ( type: esriFieldTypeString, alias: Does the Interior Building Plumbing Contain Copper Pipes with Lead Solder Installed Before July 1, 1988? (Additional Information to Assign Tap Monitoring Tiering), length: 20 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] , ...2 more... )
• ListOthFitnEquipConn2SevLinLead ( type: esriFieldTypeString, alias: List Other Fittings and Equipment Connected to the Service Line that Contain Lead, length: 50 )
• CurrentLCRSamplingSite ( type: esriFieldTypeString, alias: Current LCR Sampling Site? (Additional Information to Assign Tap Monitoring Tiering), length: 20 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] , ...2 more... )
• DateSystemOwnedLSLR ( type: esriFieldTypeDate, alias: Date of System-owned LSLR (Lead Service Line Replacement), length: 8 )
• DateofCustomerOwnedLSLR ( type: esriFieldTypeDate, alias: Date of Customer-owned LSLR (Lead Service Line Replacement), length: 8 )
• HazardCategory ( type: esriFieldTypeString, alias: HazardCategory, length: 60 , Coded Values: [AlternateSource: Alternate Source] , [BoilerHeating: Boiler Heating] , [Carbonator: Carbonator] , ...20 more... )
• hazardcat ( type: esriFieldTypeString, alias: Hazard Category Non-Concatenation, length: 250 )
• SampleSiteSelCriteria_SiteTier ( type: esriFieldTypeString, alias: Sample Site Selection Criteria (Site Tier), length: 100 )
Relationships:
• TECQ_FireLineBackFlowIrrigation (0) -- Related To: FireLineBackFlowIrrigation (1)

Tables:

Table: FireLineBackFlowIrrigation (1)

Name: FireLineBackFlowIrrigation

Display Field: sitetype

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: abaecec2daaf4462a48ca09186896be1

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: ObjectID )
• siteid ( type: esriFieldTypeDouble, alias: siteid )
• sitetype ( type: esriFieldTypeString, alias: sitetype, length: 255 )
• udf2 ( type: esriFieldTypeString, alias: udf2, length: 255 )
• udf1 ( type: esriFieldTypeDouble, alias: udf1 )
• company ( type: esriFieldTypeString, alias: company, length: 255 )
• contact ( type: esriFieldTypeString, alias: contact, length: 255 )
• address ( type: esriFieldTypeString, alias: address, length: 255 )
• city ( type: esriFieldTypeString, alias: city, length: 255 )
• phone ( type: esriFieldTypeString, alias: phone, length: 255 )
• email ( type: esriFieldTypeString, alias: email, length: 255 )
• hazid ( type: esriFieldTypeDouble, alias: hazid )
• hazardcat ( type: esriFieldTypeString, alias: hazardcat, length: 255 )
• lasttest ( type: esriFieldTypeDate, alias: lasttest, length: 8 )
• lastteststatus ( type: esriFieldTypeString, alias: lastteststatus, length: 255 )
• lasttestcompany ( type: esriFieldTypeString, alias: lasttestcompany, length: 255 )
• testdue ( type: esriFieldTypeDate, alias: testdue, length: 8 )
• protection ( type: esriFieldTypeString, alias: protection, length: 255 )
• devicestatus ( type: esriFieldTypeString, alias: devicestatus, length: 255 )
• serialnum ( type: esriFieldTypeString, alias: serialnum, length: 255 )
• location ( type: esriFieldTypeString, alias: location, length: 255 )
• location2 ( type: esriFieldTypeString, alias: location2, length: 255 )
• meter ( type: esriFieldTypeDouble, alias: meter )
• LastNoticeSent ( type: esriFieldTypeDouble, alias: LastNoticeSent )
• noticenumtddate ( type: esriFieldTypeDate, alias: noticenumtddate, length: 8 )
• mailingcompany ( type: esriFieldTypeString, alias: mailingcompany, length: 255 )
• mailingcontact ( type: esriFieldTypeString, alias: mailingcontact, length: 255 )
• mailingaddress ( type: esriFieldTypeString, alias: mailingaddress, length: 255 )
• mailingcity ( type: esriFieldTypeString, alias: mailingcity, length: 255 )
• mailingstate ( type: esriFieldTypeString, alias: mailingstate, length: 255 )
• mailingzip ( type: esriFieldTypeDouble, alias: mailingzip )
• sendnotices ( type: esriFieldTypeSmallInteger, alias: sendnotices )
• F32 ( type: esriFieldTypeString, alias: F32, length: 255 )
• IndexUDF1 ( type: esriFieldTypeDouble, alias: IndexUDF1 )
• F34 ( type: esriFieldTypeString, alias: F34, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• 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 )
• UDF1_01 ( type: esriFieldTypeString, alias: UDF1_01, length: 50 )
Relationships:
• WaterMeter (0) -- Related To: WaterMeter Service Line (38)