Name: Service Line Inspections
Display Field:
Type: Feature Layer
Geometry Type: esriGeometryPoint
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Min. Scale: 1155582
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -11797997.6239599
YMin: 383429.884531403
XMax: -10778193.4677485
YMax: 3735806.46431613
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"RedSphere.png","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15}}}
HasZ: false
HasM: false
Has Attachments: true
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- CUSTID (type: esriFieldTypeDouble, alias: CUSTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LOCID (type: esriFieldTypeDouble, alias: LOCID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PROPID (type: esriFieldTypeString, alias: PROPID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- BILLADD1 (type: esriFieldTypeString, alias: BILLADD1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- BILLADD2 (type: esriFieldTypeString, alias: BILLADD2, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- ZIP (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- PHONE (type: esriFieldTypeString, alias: PHONE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- METERNUM (type: esriFieldTypeString, alias: METERNUM, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- CYCLE (type: esriFieldTypeDouble, alias: CYCLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ROUTE (type: esriFieldTypeDouble, alias: ROUTE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CYCLEROUTE (type: esriFieldTypeString, alias: CYCLEROUTE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- SIZE (type: esriFieldTypeString, alias: SIZE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- SERVICE (type: esriFieldTypeString, alias: SERVICE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- CLASSTYPE (type: esriFieldTypeString, alias: CLASSTYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
- status (type: esriFieldTypeString, alias: status, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true, Coded Values: [Pending Inspection: Pending Inspection], [Completed Inspection: Completed Inspection], [Management Review: Management Review], ... 9 more ...)
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- METERSEQ (type: esriFieldTypeInteger, alias: METERSEQ, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SERVICESEQ (type: esriFieldTypeInteger, alias: SERVICESEQ, SQL Type: sqlTypeOther, nullable: true, editable: true)
- serviceLineSizePublic (type: esriFieldTypeString, alias: Service Line Size (Public), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [050: 050], [075: 075], [100: 100], ... 3 more ...)
- otherServiceLineSizePublic (type: esriFieldTypeString, alias: Other Service Line Size (Public), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- serviceLineSizePrivate (type: esriFieldTypeString, alias: Service Line Size (Private), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [050: 050], [075: 075], [100: 100], ... 5 more ...)
- otherServiceLineSizePrivate (type: esriFieldTypeString, alias: Other Service Line Size (Private), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- notes (type: esriFieldTypeString, alias: Notes/Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- inspectionDateTime (type: esriFieldTypeDate, alias: Date and Time of Inspection, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- serviceLineMaterialPublic (type: esriFieldTypeString, alias: Material (Public), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Copper: Copper], [Ductile: Ductile], [Galvanized Steel: Galvanized Steel], ... 5 more ...)
- otherServiceLineMaterialPublic (type: esriFieldTypeString, alias: Other Material (Public), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- serviceLineMaterialPrivate (type: esriFieldTypeString, alias: Material (Private), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Copper: Copper], [Ductile: Ductile], [Galvanized Steel: Galvanized Steel], ... 6 more ...)
- otherServiceLineMaterialPrivate (type: esriFieldTypeString, alias: Other Material (Private), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- correctMeterSize (type: esriFieldTypeString, alias: Correct Meter Size, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- isMeterSizeCorrect (type: esriFieldTypeString, alias: Is meter size correct?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO])
- workOrderNumber (type: esriFieldTypeString, alias: Work Order Number, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- leadNotificationPacketSent (type: esriFieldTypeDate, alias: Lead Notification Packet Sent, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- certifiedLetterNum (type: esriFieldTypeString, alias: Certified Letter Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- tapCardServiceLineMaterialPublic (type: esriFieldTypeString, alias: Tap Card Material (City), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Copper: Copper], [Ductile: Ductile], [Galvanized Steel: Galvanized Steel], ... 5 more ...)
- tapCardOtherServiceLineMaterialPublic (type: esriFieldTypeString, alias: Tap Card Other Material (City), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- tapCardServiceLineMaterialPrivate (type: esriFieldTypeString, alias: Tap Card Material (Customer), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Copper: Copper], [Ductile: Ductile], [Galvanized Steel: Galvanized Steel], ... 5 more ...)
- tapCardOtherServiceLineMaterialPrivate (type: esriFieldTypeString, alias: Tap Card Other Material (Customer), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- tapCardFileName (type: esriFieldTypeString, alias: Tap Card File Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- tapCardAttached (type: esriFieldTypeString, alias: Tap Card Attached, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes])
- tapReceiptFileName (type: esriFieldTypeString, alias: Tap Receipt File Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- tapReceiptAttached (type: esriFieldTypeString, alias: Tap Receipt Attached, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes])
- tapAttachmentType (type: esriFieldTypeString, alias: Tap Attachment Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Card: Card], [Receipt: Receipt], [Both: Both])
- tapCardTapReceiptMatch (type: esriFieldTypeString, alias: Tap Card/Receipt Match, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- yearBuilt (type: esriFieldTypeInteger, alias: Year Built, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dataDeterminedMaterial (type: esriFieldTypeString, alias: Data Determined Tap Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes])
- tapDateOriginal (type: esriFieldTypeDate, alias: Original Tap Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- tapQAQC (type: esriFieldTypeString, alias: Tap QA/QC, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [Completed: Completed])
- tapUpsizeDate (type: esriFieldTypeDate, alias: Tap Upsize Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- LSLRDatePublic (type: esriFieldTypeDate, alias: LSLR Date (City), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- LSLRDatePrivate (type: esriFieldTypeDate, alias: LSLR Date (Customer), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- tapUpsizeMaterial (type: esriFieldTypeString, alias: Tap Upsize Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Copper: Copper], [Ductile: Ductile], [Galvanized Steel: Galvanized Steel], ... 5 more ...)
- leadPredictedProbability (type: esriFieldTypeDouble, alias: Lead Predicted Probability, SQL Type: sqlTypeOther, nullable: true, editable: true)
- leadPredictedOutcome (type: esriFieldTypeString, alias: Lead Predicted Outcome, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- LSLIID (type: esriFieldTypeString, alias: LSLI ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- GRRReplacementType (type: esriFieldTypeString, alias: Replacement Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [GRR: GRR], [Lead on Block: Lead on Block])
- GRRCitySideReplaced (type: esriFieldTypeString, alias: GRR City Side Replaced, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- GRRCustomerSideReplaced (type: esriFieldTypeString, alias: GRR Customer Side Replaced, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- GRRReplacementStatus (type: esriFieldTypeString, alias: GRR Replacement Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Pending Replacement (City and Customer Side): Pending Replacement (City and Customer Side)], [City Side Replaced: City Side Replaced], [Customer Side Replace: Customer Side Replaced], ... 1 more ...)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 12/4/2025 8:17:37 PM
Schema Last Edit Date: 12/4/2025 8:17:37 PM
Data Last Edit Date: 12/4/2025 8:17:37 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Attachments
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat