Name: CatchBasins_activities

Display Field: assettype

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: true

Sources

Description: AttributeJoin

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: -14999999.9999899
YMin: 2699999.99999804
XMax: -6199999.99999581
YMax: 6499999.99999407
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":null,"valueExpression":"return IIf($feature.adoptionstatus == \"Adopted\", \"Adopted\", \"Available\")","valueExpressionTitle":"Adoption Status","uniqueValueInfos":[{"value":"Available","label":"Available","symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"8ae359dc-d1d1-477b-a635-80090970dd23","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAiCAYAAABbXymAAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACQ0lEQVRIicXVIW/bYBDG8f9JRQUlRokcNslS0Kp3wErBWFEy5C8w8vpjJB4eGLXB+KSiuqgaGqgCaq0oUsBQo5gspCCDNxC7c9NYsVNVOxLFln96fLn3csQr1dF/h1W1CyAiyxfBBTQELGAq1wEy4EpEJq1gVR0B43z9YNL7GdlqQfZ7Qff4BADr+WbY6xtVHQMfRCTdC6vqBBgn8ynJfEq2Wjzey1abz/R+BkA8CLCef6mqoYgktXCZNLq7ZvLzuu4tHyu8uSBbLYgHQayqeTX5I1z0dJzMp43QspL5lFGvz7DXj4HnMDDM1w8mumuOljX6/hX9+LmjqrZsSRW26f2M5fqhNVwmt55vgX9w0QaTzKcHoRXYqGpXRJavfvI6APmfw9qw9WwH2CQWkUxVMY7Lcj07CB72+pRWNTFANj49N+Xwt63RBr4qv1fh0Dju7SGocdwycfYMLtqRx4OgE95ctIKt5wNk1aW0PRWh9fzL7R2xL20BR9XrT2ARSVU1i88C8+7ySyN4cnpepn2y4XbNcWgc93bU67Pvh7SeX/Y22r73DC56ncSDwKbfPu2FgaTRPi4q6hyfWOv51B1z6/kYx80pdkMjWESWqhrFg2C8CzaOy+TtOUBaHoimiRGRiaoO40FgtsfPej6d45NMRMK65/ctoWh7/OrGqxW8a/zqxqttYijGzzguQO14tYaL8cvis8Dkm3+XvWkbwUVtFpQDNEjbGC73NZA3SdsYBviR/6odrRfB77tvdp6wF8Nt69Xgv7YrBXl4I+DqAAAAAElFTkSuQmCC","contentType":"image/png","width":16,"height":24.999999999999996}},{"value":"Adopted","label":"Adopted","symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"c6892a1c-397a-4f27-aeb8-c1ce047872c0","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAiCAYAAABbXymAAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACQElEQVRIicWWv07bUBjFfx/FDbJaefDkqFnNinS71EtfIOkzdLp5jCSPYT8GYe3SgQlLrGQtwgtUQkUuUtR8HWJTJyTkmgrxTf4j/3R8fO7x3eeFZv/VwaraBRCRq/8CV6A+YAHTuA6QAyciMm4FVtUBMFqUhbm/nDK/zpnf5LzxuwD4sTWdXt+o6gj4IiLTnWBVHQOjcpZRXmTMb/KHe/Xx/Y8lJ0hS/Ngeq+pQRLKt4Frp3fmEX+db3/Jhbk+HzK9zgiRNVbVoKn8AV56OylnmBK2nnGUc9AZ0ev0UeAwG+ouyMHfnE2doPT+/DYi+aqSqtrakCbb3l1P+lE5p2qjcj60F/oErG0x5kT317NPgiww/tkZVuyJy9eIrLwJY/C6eDWo8GwFLxSKSqypeaJ7tcedDn5rVVAyQvzsamTr8beegNwA4qc+b4KEXmrPnQL3Q0On1Ydkhq+DKjiJI0uj2dNgK7B9agLxZSuupGPqxPV7viF1q/dgCrKysFbCITFU1D5LUXE8/OoHfH41rtSsfZ1OOh15ozg56A3Z9SD+2tbePeuARuPI6Cz6ldid46W3m1MfVTPb8yPqxpZxtXuZ+bPFCU1B1gxNYRK5UdRIk6WgT2AtN7e20XhCuihGRsar2gyQ16/HzDy17fpSLyNZc7iqhyXr8tsWrFXhT/LbFq61iqOLnhcsdwLZ4tQZX8cuDJDWLsnBS6wSuZllQIeCg1hlc9zVQuKh1BgPMi++tKs8Z/Lb7udWf9vW3sW3nL9cRBNSb52EwAAAAAElFTkSuQmCC","contentType":"image/png","width":16,"height":24.999999999999996}}]}}

HasZ: true

HasM: true

Has Attachments: true

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: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [210: Drop Inlet], [204: Infiltration], ... 1 more ...)
• assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• surfacewater (type: esriFieldTypeSmallInteger, alias: Receives Surface Water, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• exitsystem (type: esriFieldTypeSmallInteger, alias: Water Exiting System, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Waterway], [2: Other System], ... 1 more ...)
• installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• lifecyclestatus (type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 7 more ...)
• rimelevation (type: esriFieldTypeDouble, alias: Rim Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• invertelev (type: esriFieldTypeDouble, alias: Invert Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• assetlength (type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• width (type: esriFieldTypeDouble, alias: Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• depth (type: esriFieldTypeDouble, alias: Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• material (type: esriFieldTypeSmallInteger, alias: Wall Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: ABS Plastic - ABS], [5: Cast Iron - CAS], ... 9 more ...)
• material2 (type: esriFieldTypeSmallInteger, alias: Frame Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: ABS Plastic - ABS], [5: Cast Iron - CAS], ... 9 more ...)
• additionaldevice (type: esriFieldTypeSmallInteger, alias: Sump, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• designtype (type: esriFieldTypeSmallInteger, alias: Opening Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Curb Opening], [2: Grate], ... 1 more ...)
• additionaldetails (type: esriFieldTypeSmallInteger, alias: Inlet Shape, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Round], [2: Square], ... 1 more ...)
• signage (type: esriFieldTypeSmallInteger, alias: Signage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
• maintby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• spatialsource (type: esriFieldTypeSmallInteger, alias: Spatial Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: As-Built], [2: CAD], ... 3 more ...)
• spatialconfidence (type: esriFieldTypeSmallInteger, alias: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: High], [2: Medium], ... 1 more ...)
• symbolrotation (type: esriFieldTypeSmallInteger, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 359])
• globalid (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• 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)
• lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• updatedby (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• ESRIGNSS_RECEIVER (type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, 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_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_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_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_FIXDATETIME (type: esriFieldTypeDate, alias: Fix Time, SQL Type: sqlTypeOther, length: 8, 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)
• adoptedby (type: esriFieldTypeString, alias: Adopted By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• adoptedon (type: esriFieldTypeDate, alias: Adopted On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• nickname (type: esriFieldTypeString, alias: Nickname, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fulladdr (type: esriFieldTypeString, alias: Nearest Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• adoptionstatus (type: esriFieldTypeString, alias: Adoption Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Available: Available], [Adopted: Adopted])
• publicview (type: esriFieldTypeString, alias: Publicly Visible, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• activitydate (type: esriFieldTypeDate, alias: Activity Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• assetglobalid (type: esriFieldTypeGUID, alias: Asset GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• username (type: esriFieldTypeString, alias: Username, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• globalid_1643314265589 (type: esriFieldTypeGUID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• notes_1643314265589 (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Types:

ID: 0
Name: Unknown
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: surfacewater
  Inherited
  
• Field Name: exitsystem
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: symbolrotation
  Inherited
  
• Field Name: ESRIGNSS_FIXTYPE
  Inherited
  
• Field Name: ESRIGNSS_STATIONID
  Inherited
  
• Field Name: ESRIGNSS_NUMSATS
  Inherited
  
• Field Name: additionaldevice
  Inherited
  
• Field Name: additionaldetails
  Inherited
  
• Field Name: signage
  Inherited
  
• Field Name: designtype
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: material2
  Inherited
  
Templates:

Name: Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ownedby: 1
• exitsystem: 0
• maintby: 1
• signage: 0
• additionaldevice: 0
• designtype: 0
• additionaldetails: 0
• lifecyclestatus: 8
• material2: 0
• material: 0
• surfacewater: 0
• spatialsource: 0
• spatialconfidence: 0
• assettype: 0

---

ID: 204
Name: Infiltration
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: surfacewater
  Inherited
  
• Field Name: exitsystem
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: symbolrotation
  Inherited
  
• Field Name: ESRIGNSS_FIXTYPE
  Inherited
  
• Field Name: ESRIGNSS_STATIONID
  Inherited
  
• Field Name: ESRIGNSS_NUMSATS
  Inherited
  
• Field Name: additionaldevice
  Inherited
  
• Field Name: additionaldetails
  Inherited
  
• Field Name: signage
  Inherited
  
• Field Name: designtype
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: material2
  Inherited
  
Templates:

Name: Infiltration
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• maintby: 1
• exitsystem: 0
• signage: 0
• additionaldevice: 0
• designtype: 0
• additionaldetails: 0
• lifecyclestatus: 8
• material2: 0
• material: 0
• surfacewater: 0
• ownedby: 1
• spatialsource: 0
• spatialconfidence: 0
• assettype: 204

---

ID: 205
Name: Sediment Trap
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: surfacewater
  Inherited
  
• Field Name: exitsystem
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: symbolrotation
  Inherited
  
• Field Name: ESRIGNSS_FIXTYPE
  Inherited
  
• Field Name: ESRIGNSS_STATIONID
  Inherited
  
• Field Name: ESRIGNSS_NUMSATS
  Inherited
  
• Field Name: additionaldevice
  Inherited
  
• Field Name: additionaldetails
  Inherited
  
• Field Name: signage
  Inherited
  
• Field Name: designtype
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: material2
  Inherited
  
Templates:

Name: Sediment Trap
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• maintby: 1
• exitsystem: 0
• signage: 0
• additionaldevice: 0
• designtype: 0
• additionaldetails: 0
• lifecyclestatus: 8
• material2: 0
• material: 0
• surfacewater: 0
• ownedby: 1
• spatialsource: 0
• spatialconfidence: 0
• assettype: 205

---

ID: 210
Name: Drop Inlet
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: surfacewater
  Inherited
  
• Field Name: exitsystem
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: symbolrotation
  Inherited
  
• Field Name: ESRIGNSS_FIXTYPE
  Inherited
  
• Field Name: ESRIGNSS_STATIONID
  Inherited
  
• Field Name: ESRIGNSS_NUMSATS
  Inherited
  
• Field Name: additionaldevice
  Inherited
  
• Field Name: additionaldetails
  Inherited
  
• Field Name: signage
  Inherited
  
• Field Name: designtype
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: material2
  Inherited
  
Templates:

Name: Drop Inlet
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• exitsystem: 0
• signage: 0
• ownedby: 1
• surfacewater: 0
• spatialsource: 0
• maintby: 1
• additionaldevice: 0
• designtype: 0
• additionaldetails: 0
• lifecyclestatus: 8
• material2: 0
• material: 0
• spatialconfidence: 0
• assettype: 210

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/5/2025 11:18:07 AM

Schema Last Edit Date: 10/5/2025 11:17:59 AM

Data Last Edit Date: 10/5/2025 11:17:59 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat