Layers:

Layer: LCRR Laterals (0)


Name: LCRR Laterals

Display Field: STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service laterals, in general, come off Distribution type water mains.

There are cases where service laterals come off of hydrant laterals

and other service laterals. Connectivity between service laterals and

water mains need only be graphic as no tracing will be conducted

through service laterals. Service laterals are placed perpendicular

to the water main arc with exceptions such as cul-de-sacs or services

with offsets. Service laterals extend to the PARCEL coverage right-

of-way line. When no right-of-way line exists, or when the right-of-

way line is offset less than 20' from the water main, the graphic

service length will be 20'. Directionality for service lateral arcs

is required so when issuing an arctext command text will display

properly. The FNODE of a service lateral will be placed on the water main.

Each service lateral, except out_at_main, will have a meter point feature

at its terminus.

SERVICE_LATERAL arcs are categorized and symbolized by there purpose,

which is specified through the USE attribute in the SERVICE_LATERALS_ATR.

The following are the USE values for SERVICE_LATERAL arcs:

RESIDENTIAL

Provides service to a property for residential use

COMMERCIAL

Provides service to a property for a commercial use.

FIRE

Provides service for a fire prevention system.

LANDSCAPE

Provides service for non-residential landscape purposes

PARK

Provides service to a city park.

TEMPORARY

Provides service to a property on a temporary basis.

OUT_AT_MAIN

An abandoned service. When a service is abandoned it is generally

not removed from the database for financial tracking purposes.

o LATERAL arcs

Used for depicting air valve and hydrant features, not essential for network

tracing. LATERAL arcs are for graphic purposes only. Connectivity

between lateral arcs and other water main arcs need only be graphic.

These arcs will have an air valve or hydrant point feature at their terminus.

There will be some cases where a lateral arc will not have a point at its

terminus (fire hydrant stub). Directionality is not required for lateral

arcs. In general these arcs shall snap and be perpendicular to water main

lines and extend to the ROW line of the Parcel coverage. In cases where

no ROW exists, or the hydrant/av is in a median a standard length of 25'

is to be used. Manually drawn lateral arcs for indicating offsets and other

special cases do not conform to the above standard length requirements.

o DRAIN_LINE arcs

Used mainly in facility areas for depicting drain lines, not essential for

network tracing These lines have no connectivity with any other arc type.

o MISC arcs

Used for special graphic purposes in facility areas, not essential for

network tracing. These lines have no connectivity with any other arc type.



Copyright Text: City of Riverside CA

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: 6175450.2884118
YMin: 2263260.60600756
XMax: 6243099.51630205
YMax: 2316378.75994164
Spatial Reference: 102646 (2230)


Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SUBTYPECD","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":1.3},"value":"25","label":"Residential Lateral"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":1.3},"value":"24","label":"Commercial Lateral"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[168,0,0,255],"width":1.3},"value":"26","label":"Fire Lateral"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[48,204,51,255],"width":1.3},"value":"29","label":"Park Lateral"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":1.3},"value":"34","label":"Unknown Lateral"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":1.3},"value":"33","label":"Unknown Lateral"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,241,252,255],"toColor":[215,241,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[250,179,252,255],"toColor":[250,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,250,179,255],"toColor":[252,250,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,185,182,255],"toColor":[252,185,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,192,252,255],"toColor":[182,192,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,192,255],"toColor":[182,252,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,232,210,255],"toColor":[252,232,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,210,242,255],"toColor":[252,210,242,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[197,252,227,255],"toColor":[197,252,227,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,215,252,255],"toColor":[182,215,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[240,252,210,255],"toColor":[240,252,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,211,255],"toColor":[252,179,211,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,217,255],"toColor":[252,212,217,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field: SUBTYPECD

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SUBTYPECD (type: esriFieldTypeInteger, alias: SubtypeCD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AssetTag (type: esriFieldTypeInteger, alias: Asset Tag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• APN (type: esriFieldTypeString, alias: APN, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ADDRESSNUM (type: esriFieldTypeInteger, alias: Address Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STREETNAME (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LOCATIONDESCRIPTION (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ASBUILT (type: esriFieldTypeString, alias: As Built, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PLANNUMBER (type: esriFieldTypeString, alias: Plan Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WorkOrderID (type: esriFieldTypeString, alias: Work Order ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• DATASOURCE (type: esriFieldTypeString, alias: Data Source, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [AM: Atlas Map], [AB: As-Built], [DE: Design], ... 7 more ...)
• PREMISEID (type: esriFieldTypeInteger, alias: Premise ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SERVICECARDNUMBER (type: esriFieldTypeInteger, alias: Service Card Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PRESSUREZONECODE (type: esriFieldTypeString, alias: Pressure Zone Code, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0001: 001], [0002: 002], [0071: 071], ... 49 more ...)
• PRESSUREZONENAME (type: esriFieldTypeString, alias: Pressure Zone Name, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Zone 925: Zone 925], [Chicago 1100: Chicago 1100], [Victoria 1100 East: Victoria 1100 East], ... 52 more ...)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InstallDate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BRASS: Brass], [CCP: Concrete Steel Cylinder], ... 23 more ...)
• DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EARLIEST_CONSTRUCTION_DATE (type: esriFieldTypeInteger, alias: Earliest Construction Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UpdatedAddress (type: esriFieldTypeString, alias: Updated Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• material_ (type: esriFieldTypeString, alias: RPU Side Updated Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BRASS: Brass], [CCP: Concrete Steel Cylinder], ... 23 more ...)
• diameter_dbl (type: esriFieldTypeDouble, alias: RPU Side Updated Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 0.5"], [0.75: 0.75"], [1: 1"], ... 12 more ...)
• RPUUpdatedInstallDate (type: esriFieldTypeDate, alias: RPU Side Updated Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RPUUpdatedPremiseID (type: esriFieldTypeInteger, alias: RPU Side Updated Premise ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RPUVerificationSource (type: esriFieldTypeString, alias: RPU Side Verification Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [As-Builts: As-Builts], [Blue Slip/Tap Card: Blue Slip/Tap Card], [Construction Permit: Construction Permit], ... 6 more ...)
• RPUAsBuiltImprvmtReference (type: esriFieldTypeString, alias: RPU Side As-Built / Imporvement Plan Reference, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TractMapReference (type: esriFieldTypeString, alias: RPU Side Tract Map Reference, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• notes_ (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LeadGooseneck_ (type: esriFieldTypeString, alias: Lead Gooseneck, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• TestLocation (type: esriFieldTypeString, alias: Test Location, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Meter: Meter], [Building: Building], [Other: Other])
• OtherLocation (type: esriFieldTypeString, alias: Other Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TestType (type: esriFieldTypeString, alias: Test Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [3M Test Kit: 3M Test Kit], [Excavation: Excavation], [Other: Other], ... 3 more ...)
• OtherTest (type: esriFieldTypeString, alias: Other Test, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InspectedMaterialType (type: esriFieldTypeString, alias: Inspected Material Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BRASS: Brass], [CCP: Concrete Steel Cylinder], ... 23 more ...)
• InspectedLineSize (type: esriFieldTypeDouble, alias: Inspected Line Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 0.5"], [0.75: 0.75"], [1: 1"], ... 12 more ...)
• InspectorName (type: esriFieldTypeString, alias: Inspector Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Al Orozco: Al Orozco], [Brad Kelvington: Brad Kelvington], [Danny Bertotti: Danny Bertotti], ... 7 more ...)
• InspectionDate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Inspectionnotes (type: esriFieldTypeString, alias: Inspection Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CUSTUpdatedMaterial (type: esriFieldTypeString, alias: Customer Side Updated Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BRASS: Brass], [CCP: Concrete Steel Cylinder], ... 23 more ...)
• CUSTUpdatedDiameter (type: esriFieldTypeDouble, alias: Customer Side Updated Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 0.5"], [0.75: 0.75"], [1: 1"], ... 12 more ...)
• CUSTUpdatedBuildDate (type: esriFieldTypeDate, alias: Customer Side Updated Build Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CUSTVerificationSource (type: esriFieldTypeString, alias: Customer Side Verification Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [As-Builts: As-Builts], [Blue Slip/Tap Card: Blue Slip/Tap Card], [Construction Permit: Construction Permit], ... 6 more ...)
• CUSTAsBuiltImprvmtReference (type: esriFieldTypeString, alias: Customer Side As-Built / Imporvement Plan Reference, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ConstructionPermitReference (type: esriFieldTypeString, alias: Customer Side Construction Permit Reference, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, 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)

Types:

ID: 25
Name: Residential Lateral
Domains:

• Field Name: DATASOURCE
  Inherited
  
• Field Name: PRESSUREZONECODE
  Inherited
  
• Field Name: PRESSUREZONENAME
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: DIAMETER
  Coded Values:[0.5: 0.5"], [0.75: 0.75"], [1: 1"], More
  
Templates:

Name: Residential Lateral
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SUBTYPECD: 25

---

ID: 24
Name: Commercial Lateral
Domains:

• Field Name: DATASOURCE
  Inherited
  
• Field Name: PRESSUREZONECODE
  Inherited
  
• Field Name: PRESSUREZONENAME
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: DIAMETER
  Coded Values:[0.5: 0.5"], [0.75: 0.75"], [1: 1"], More
  
Templates:

Name: Commercial Lateral
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SUBTYPECD: 24

---

ID: 26
Name: Fire Lateral
Domains:

• Field Name: DATASOURCE
  Inherited
  
• Field Name: PRESSUREZONECODE
  Inherited
  
• Field Name: PRESSUREZONENAME
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: DIAMETER
  Coded Values:[0.5: 0.5"], [0.75: 0.75"], [1: 1"], More
  
Templates:

Name: Fire Lateral
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SUBTYPECD: 26

---

ID: 29
Name: Park Lateral
Domains:

• Field Name: DATASOURCE
  Inherited
  
• Field Name: PRESSUREZONECODE
  Inherited
  
• Field Name: PRESSUREZONENAME
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: DIAMETER
  Coded Values:[0.5: 0.5"], [0.75: 0.75"], [1: 1"], More
  
Templates:

Name: Park Lateral
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SUBTYPECD: 29

---

ID: 34
Name: Unknown Service Lateral
Domains:

• Field Name: DATASOURCE
  Inherited
  
• Field Name: PRESSUREZONECODE
  Inherited
  
• Field Name: PRESSUREZONENAME
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: DIAMETER
  Coded Values:[0.5: 0.5"], [0.75: 0.75"], [1: 1"], More
  
Templates:

Name: Unknown Service Lateral
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SUBTYPECD: 34

---

ID: 33
Name: Unknown Lateral
Domains:

• Field Name: DATASOURCE
  Inherited
  
• Field Name: PRESSUREZONECODE
  Inherited
  
• Field Name: PRESSUREZONENAME
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: DIAMETER
  Coded Values:[0.5: 0.5"], [0.75: 0.75"], [1: 1"], More
  
Templates:

Name: Unknown Lateral
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SUBTYPECD: 33

---


Relationships:
• TO_CIS (0) -- Related To: CIS_PREMISE_SURVEY_TABLE_CUSTOMER (2)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/28/2023 1:26:44 AM

Schema Last Edit Date: 5/28/2023 1:26:44 AM

Data Last Edit Date: 5/28/2023 1:25:56 AM

Tables:

CIS_PREMISE_SURVEY_TABLE_ (1)


Name: CIS_PREMISE_SURVEY_TABLE_

Display Field: CIS_FIRST_NAME

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• CUST (type: esriFieldTypeString, alias: CUST, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CIS_NUMBER (type: esriFieldTypeDouble, alias: CIS NUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CMTR_PREMISE_NO (type: esriFieldTypeDouble, alias: CMTR PREMISE NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CIS_FIRST_NAME (type: esriFieldTypeString, alias: CIS FIRST NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CIS_LAST_NAME (type: esriFieldTypeString, alias: CIS LAST NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PREM_ZIP (type: esriFieldTypeString, alias: PREM ZIP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pressure_District_Text (type: esriFieldTypeString, alias: pressure District Text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• class_description (type: esriFieldTypeString, alias: class description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• rates_Text (type: esriFieldTypeString, alias: rates Text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• METERNUMBER (type: esriFieldTypeString, alias: METERNUMBER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PREMISE_ID_CIS (type: esriFieldTypeString, alias: PREMISE_ID_CIS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• METER_NUMBER_CIS (type: esriFieldTypeString, alias: METER_NUMBER_CIS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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)

Templates:

Name: CIS_PREMISE_SURVEY_TABLE_
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:


Relationships:
• PREMISEID_TO_TABLE (1) -- Related To: CIS_PREMISE_SURVEY_TABLE_CUSTOMER (2)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/28/2023 1:26:44 AM

Schema Last Edit Date: 5/28/2023 1:26:44 AM

Data Last Edit Date: 5/28/2023 1:25:56 AM

CIS_PREMISE_SURVEY_TABLE_CUSTOMER (2)


Name: CIS_PREMISE_SURVEY_TABLE_CUSTOMER

Display Field: InspectorName

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• PREMISEID (type: esriFieldTypeInteger, alias: Premise ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• material_ (type: esriFieldTypeString, alias: RPU Side Updated Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BRASS: Brass], [CCP: Concrete Steel Cylinder], ... 23 more ...)
• diameter_dbl (type: esriFieldTypeDouble, alias: RPU Side Updated Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 0.5"], [0.75: 0.75"], [1: 1"], ... 12 more ...)
• RPUUpdatedInstallDate (type: esriFieldTypeDate, alias: RPU Side Updated Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RPUUpdatedPremiseID (type: esriFieldTypeInteger, alias: RPU Side Updated Premise ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RPUVerificationSource (type: esriFieldTypeString, alias: RPU Side Verification Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [As-Builts: As-Builts], [Blue Slip/Tap Card: Blue Slip/Tap Card], [Construction Permit: Construction Permit], ... 6 more ...)
• RPUAsBuiltImprvmtReference (type: esriFieldTypeString, alias: RPU As-Built / Imporvement Plan Reference, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• notes_ (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LeadGooseneck_ (type: esriFieldTypeString, alias: Lead Gooseneck, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• Shape_Length (type: esriFieldTypeDouble, alias: Shape_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TestLocation (type: esriFieldTypeString, alias: Test Location, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Meter: Meter], [Building: Building], [Other: Other])
• OtherLocation (type: esriFieldTypeString, alias: Other Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TestType (type: esriFieldTypeString, alias: Test Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [3M Test Kit: 3M Test Kit], [Excavation: Excavation], [Other: Other], ... 3 more ...)
• OtherTest (type: esriFieldTypeString, alias: Other Test, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InspectedMaterialType (type: esriFieldTypeString, alias: Inspected Material Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BRASS: Brass], [CCP: Concrete Steel Cylinder], ... 23 more ...)
• InspectedLineSize (type: esriFieldTypeDouble, alias: Inspected Line Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 0.5"], [0.75: 0.75"], [1: 1"], ... 12 more ...)
• InspectorName (type: esriFieldTypeString, alias: Inspector Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Al Orozco: Al Orozco], [Brad Kelvington: Brad Kelvington], [Danny Bertotti: Danny Bertotti], ... 7 more ...)
• InspectionDate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Inspectionnotes (type: esriFieldTypeString, alias: Inspection Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CUSTUpdatedMaterial (type: esriFieldTypeString, alias: Customer Side Updated Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BRASS: Brass], [CCP: Concrete Steel Cylinder], ... 23 more ...)
• CUSTUpdatedDiameter (type: esriFieldTypeDouble, alias: Customer Side Updated Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 0.5"], [0.75: 0.75"], [1: 1"], ... 12 more ...)
• CUSTUpdatedBuildDate (type: esriFieldTypeDate, alias: Customer Side Updated Build Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CUSTVerificationSource (type: esriFieldTypeString, alias: Customer Side Verification Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [As-Builts: As-Builts], [Blue Slip/Tap Card: Blue Slip/Tap Card], [Construction Permit: Construction Permit], ... 7 more ...)
• CUSTAsBuiltImprvmtReference (type: esriFieldTypeString, alias: Customer As-Built / Imporvement Plan Reference, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ConstructionPermitReference (type: esriFieldTypeString, alias: Construction Permit Reference, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• PREMISE_ID_CIS (type: esriFieldTypeString, alias: PREMISE_ID_CIS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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)

Templates:

Name: CIS_PREMISE_SURVEY_TABLE_CUSTOMER
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:


Relationships:
• TO_LATERALS (0) -- Related To: LCRR Laterals (0)
• TABLE_TO_PREMISEID (1) -- Related To: CIS_PREMISE_SURVEY_TABLE_ (1)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/28/2023 1:26:44 AM

Schema Last Edit Date: 5/28/2023 1:26:44 AM

Data Last Edit Date: 5/28/2023 1:25:56 AM