Layer: Laterals (ID:88)

View In: Map Viewer

Name: Laterals

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

This feature represents sewer laterals for customer residential or commercial. Based on the ESRI Local Government Information Model, modified as seen fit to meet our needs and the needs of our clients in order to store, manage, and display geographic data. Data is 1.) Collected (through line markers) using mapping-grade GPS receivers using SBAS corrections, and/or 2.) Digitized based on best available references.

Copyright Text: RCAP Solutions, Geographic Information Services, ESRI Local Government Information Model

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[85,255,0,255],"width":1.5}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
S_LATERAL_ID (type: esriFieldTypeString, alias: Sewer Lateral ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ACTIVE (type: esriFieldTypeString, alias: Active Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
INSTALLDATE (type: esriFieldTypeDate, alias: Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
STREET_NAME (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
STREET_NO (type: esriFieldTypeString, alias: House Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
LOCDESC (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
OWNER_NAME (type: esriFieldTypeString, alias: Owner Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SIZE (type: esriFieldTypeDouble, alias: Size / Diameter Pipe, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: 4"], [6: 6"], [0: OTH], ... 1 more ...)
MATERIAL (type: esriFieldTypeString, alias: Material Service Line (Utility Side), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [ABS: ABS Plastic (black roll)], [CAS: Cast Iron], [VCP: Vitrified Clay Pipe], ... 10 more ...)
COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
DAMAGE (type: esriFieldTypeString, alias: Damage / Maintenance Request, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [3: Fair (some aging / wear & tear)], [1: Very Good (relatively new)], [2: Good (newer, with no problems)], ... 2 more ...)
INSPECTED (type: esriFieldTypeString, alias: Inspected, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
INSPECTION_DATE (type: esriFieldTypeDate, alias: INSPECTION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LENGTH (type: esriFieldTypeDouble, alias: Length (Design Engineering), SQL Type: sqlTypeOther, nullable: true, editable: true)
DISTANCE (type: esriFieldTypeInteger, alias: Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
MAINTBY (type: esriFieldTypeSmallInteger, alias: Managed By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Utility Owned], [0: Private / Customer])
RISK (type: esriFieldTypeSmallInteger, alias: Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
RISK_RANKING (type: esriFieldTypeSmallInteger, alias: Risk Ranking, SQL Type: sqlTypeOther, nullable: true, editable: true)
EXPECTED_USEFUL_LIFE (type: esriFieldTypeSmallInteger, alias: Expected Useful Life, SQL Type: sqlTypeOther, nullable: true, editable: true)
REMAINING_USEFUL_LIFE (type: esriFieldTypeSingle, alias: Remaining Useful Life, SQL Type: sqlTypeOther, nullable: true, editable: true)
REPLACEMENT_COST (type: esriFieldTypeSingle, alias: Replacement Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
UNIT_COST (type: esriFieldTypeSingle, alias: Unit Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
COF (type: esriFieldTypeSmallInteger, alias: Consequence of Failure, SQL Type: sqlTypeOther, nullable: true, editable: true)
CF_ASSET_SIZE (type: esriFieldTypeString, alias: CF Asset Size, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Less than 4" = 1], [2: 4" = 2], [3: 6" = 3], ... 4 more ...)
CF_OVERALL_CUST_IMPACT (type: esriFieldTypeString, alias: CF Overall Customer Imapct, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: 10% = 1], [2: 10-30% = 2], [3: 30-50% = 3], ... 4 more ...)
CF_SIGNIF_IMPORTANT_CUST (type: esriFieldTypeString, alias: CF Critical Customers, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Residential Only = 1], [2: School / Church = 2], [3: Downtown Businesses = 3], ... 4 more ...)
CF_MAINTENANCE_ACCESSIBILITY (type: esriFieldTypeString, alias: CF Maintenance Accesibility, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Right of Way - no traffic control = 1], [2: Right of Way - with traffic control = 2], [3: Public lands with vehicle access = 3], ... 4 more ...)
POF (type: esriFieldTypeSmallInteger, alias: Probability of Failure, SQL Type: sqlTypeOther, nullable: true, editable: true)
PF_ASSET_STATUS (type: esriFieldTypeString, alias: PF Asset Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Fully Functional = 1], [2: Operates with difficulty = 2], [3: Operates but unreliable = 3], ... 4 more ...)
PF_MAINTENANCE_HISTORY (type: esriFieldTypeString, alias: PF Maintenance History, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [1: Recommended best practices regularly followed = 1], [2: Assets are adequately maintained = 2], [3: No maintenance history = 3], ... 4 more ...)
PF_CAPACITY (type: esriFieldTypeString, alias: PF Capacity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Excess capacity = 1], [2: Limited capacity concerns = 2], [3: Moderate concerns / Limited Fire Flow / Sewer Surcharges = 3], ... 4 more ...)
MODIFYUSER (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
MODIFYDATE (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
CREATOR (type: esriFieldTypeString, alias: CREATOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
CREATEDATE (type: esriFieldTypeDate, alias: CREATEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
ESRIGNSS_H_RMS (type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_V_RMS (type: esriFieldTypeDouble, alias: Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_POSITIONSOURCETYPE (type: esriFieldTypeSmallInteger, alias: Position source type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: User defined], [2: Integrated (System) Location Provider], ... 2 more ...)
ESRIGNSS_RECEIVER (type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ESRIGNSS_ALTITUDE (type: esriFieldTypeDouble, alias: Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_FIXDATETIME (type: esriFieldTypeDate, alias: Fix Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ESRIGNSS_FIXTYPE (type: esriFieldTypeSmallInteger, alias: Fix Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Fix not valid], [1: GPS], [2: Differential GPS], ... 2 more ...)
ESRIGNSS_CORRECTIONAGE (type: esriFieldTypeDouble, alias: Correction Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_STATIONID (type: esriFieldTypeSmallInteger, alias: Station ID, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 1023])
ESRIGNSS_NUMSATS (type: esriFieldTypeSmallInteger, alias: Number of Satellites, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 99])
ESRIGNSS_PDOP (type: esriFieldTypeDouble, alias: Positional dilution of precision (3D), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_HDOP (type: esriFieldTypeDouble, alias: Horizontal Ground Precision, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_VDOP (type: esriFieldTypeDouble, alias: Vertical (Elevation) Precision, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_DIRECTION (type: esriFieldTypeDouble, alias: Direction of travel (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_SPEED (type: esriFieldTypeDouble, alias: Ground Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRISNSR_AZIMUTH (type: esriFieldTypeDouble, alias: Compass reading of Phone / Tablet (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_AVG_H_RMS (type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_AVG_V_RMS (type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_AVG_POSITIONS (type: esriFieldTypeSmallInteger, alias: Averaged Positions, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_H_STDDEV (type: esriFieldTypeDouble, alias: Standard Deviation (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
POINT_X (type: esriFieldTypeDouble, alias: Calculated Point X (Longitude), SQL Type: sqlTypeOther, nullable: true, editable: true)
POINT_Y (type: esriFieldTypeDouble, alias: Calculated Point Y (Latitude), SQL Type: sqlTypeOther, nullable: true, editable: true)
POINT_Z (type: esriFieldTypeDouble, alias: Calculated Point Z (Elevation Height), SQL Type: sqlTypeOther, nullable: true, editable: true)
CALC_XYZ_SOURCE (type: esriFieldTypeString, alias: Calculated Coordinate Source Reference, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SEQUENTIAL_ID (type: esriFieldTypeString, alias: Sequential ID to assist with Asset ID., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

SIZE: 4
MATERIAL: HDPE
DAMAGE: No
INSPECTED: No
MAINTBY: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/22/2023 12:43:50 PM

Schema Last Edit Date: 8/22/2023 12:43:50 PM

Data Last Edit Date: 8/22/2023 12:43:50 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Query Attachments Add Features Update Features Delete Features Apply Edits Calculate Generate Renderer Validate SQL Get Estimates ConvertFormat