Name: Fitting

Display Field: assettype

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 2500

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1013018.42860828
YMin: 1831828.91079036
XMax: 1053821.57774264
YMax: 1886573.11424554
Spatial Reference: 102671 (3435)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"assettype","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"16909c2bc3a63febee6e65585b5a3d7a","imageData":"iVBORw0KGgoAAAANSUhEUgAAABwAAAAcCAYAAAByDd+UAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACvUlEQVRIie3VP2gTURwH8N81aUGpDiFCI7qoAesW4lTNVtEWEaxNg1EcWuy7E4c6av+9GJvROgj3LqJDkSimiqZBii5inEpLnaxQN6O5aCgSxSV/nvyuJpzJXZI2RRz8Qrjk3uM+ud/7vTsr/OVY/4MYQsglQRC6oEYEQUgVCoVr4XA411RJCSFXBUEI1ZvHOQeLxbKPUuqjlOY3BYqiOAoAN/a2HgLXtuNgt+4xnRvLTkMmn+xTVfUBpfSsGWoKSpI0xjkPInZsxxC8V5chkXphONfj7IVTO6+U0H5VVcEMNQRFURznnF/XY3cSIUisPtfG43xJO54U3NoRx2YG31SinFLqr0SrQFEUJwGAmmFGyfxIwYV7RytRbzqdLnq93nPRaLRgCBJCfPWwA+7O8nfb7l2w9vlrLdRns9lWAWDcEGxpaXFgt2GDGGEnhvvAT0n598yneYgEwhChShXatd2roXjNmiXFYDdig1RilxVs2j/jnxzW7nI+/KSMrqSWwb3/SHOPNgRrjZXAemkIxLXSr11lcEy/nk2DeKG1VAZsDrvh+IellYawDZV0Ye61aVkRbDTWRidiN2LpKku7EE9oY02DHmevti2w6zBYspHD5zXw1uJ9rcS3yZR25/oc7HBBp8MFP4vZ+iDn/C0A5GLZ6VbcvLifcF+VUH358A8YYTcHZsHe3gEvv9/VzhWLxUVTkDH2SpKkgUw++agWahTELnpGy9jH3Ds8PaYoCjMFMbIsPyWEeDP5ZNQMxdIaYR5njx6bYIxN1SxpKYqiPJMkqf832lZCqx7gPesHXDNEdRhljAU31DSyLMcIIYjOItrdPgSnXYOGc7FBdFiQMRbY1LZQFGVOFMUzmXzy8cNvgTaonxBjbKKpfcgYi0uS1A0A629b83yRZTmyJRtfluUEAOCn6Vi34iL/NPgL/mOSgYwkP/sAAAAASUVORK5CYII=","contentType":"image/png","width":21,"height":21,"angle":0,"xoffset":0,"yoffset":0},"value":"Fitting","label":"Fitting"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,211,252,255],"toColor":[187,211,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,252,179,255],"toColor":[194,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,196,179,255],"toColor":[252,196,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,187,247,255],"toColor":[252,187,247,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,252,248,255],"toColor":[187,252,248,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,238,179,255],"toColor":[252,238,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[188,182,252,255],"toColor":[188,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,204,225,255],"toColor":[252,204,225,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[220,252,212,255],"toColor":[220,252,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,240,252,255],"toColor":[204,240,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[230,212,252,255],"toColor":[230,212,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,229,212,255],"toColor":[252,229,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,189,255],"toColor":[252,179,189,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field: assettype

Fields:

• assettype (type: esriFieldTypeString, alias: Asset type, SQL Type: sqlTypeOther, length: 100, nullable: false, editable: true, Coded Values: [Fitting: Fitting])
• fittingtype (type: esriFieldTypeString, alias: Fitting Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Clamp: Clamp], [Corporation Stop: Corporation Stop], [Coupling: Coupling], ... 19 more ...)
• assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• lifecyclestatus (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 100, nullable: false, editable: true, Coded Values: [Proposed: Proposed], [Approved: Approved], [Under Construction: Under Construction], ... 6 more ...)
• installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 1/2"], [0.75: 3/4"], [1: 1"], ... 26 more ...)
• inservicedate (type: esriFieldTypeDate, alias: In-Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• lastmaint (type: esriFieldTypeDate, alias: Last Maintenance, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• retireddate (type: esriFieldTypeDate, alias: Retired Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• ownedby (type: esriFieldTypeString, alias: Owned By, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Our Agency: Our Agency], [Private: Private], [Other: Other])
• maintby (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Our Agency: Our Agency], [Private: Private], [Other: Other])
• spatialsource (type: esriFieldTypeString, alias: Spatial Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [As-Built: As-Built], [CAD: CAD], [Digitized: Digitized], ... 2 more ...)
• spatialconfidence (type: esriFieldTypeString, alias: Spatial Confidence, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [High: High], [Medium: Medium], [Low: Low])
• CreationDate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• 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)
• 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], ... 3 more ...)
• ESRIGNSS_RECEIVER (type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, 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_ALTITUDE (type: esriFieldTypeDouble, alias: Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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_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: PDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_HDOP (type: esriFieldTypeDouble, alias: HDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_VDOP (type: esriFieldTypeDouble, alias: VDOP, 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: Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRISNSR_AZIMUTH (type: esriFieldTypeDouble, alias: Compass reading (°), 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)

Types:

ID: Fitting
Name: Fitting
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: fittingtype
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: ESRIGNSS_POSITIONSOURCETYPE
  Inherited
  
• Field Name: ESRIGNSS_FIXTYPE
  Inherited
  
• Field Name: ESRIGNSS_STATIONID
  Inherited
  
• Field Name: ESRIGNSS_NUMSATS
  Inherited
  
Templates:

Name: Fitting
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ownedby: Our Agency
• assettype: Fitting
• lifecyclestatus: In Service
• maintby: Our Agency

---

Relationships:

• FittingRelate (8) -- Related To: FittingRelate (26)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/22/2025 9:01:14 PM

Schema Last Edit Date: 6/27/2024 8:29:32 PM

Data Last Edit Date: 6/22/2025 9:01:14 PM

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