Name: GMs_Join_CCTV_Table

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text:

Min. Scale: 5000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 906704.202341996
YMin: 558996.347600155
XMax: 942285.199093245
YMax: 580480.695707493
Spatial Reference: 102658 (2236)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":2}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.FACILITYID","title":""},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","removeDuplicates":"none","useCodedValues":true,"maxScale":0,"minScale":5000,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[255,255,255,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[0,77,168,255],"haloSize":1,"font":{"family":"Tahoma","size":8,"style":"normal","weight":"bold","decoration":"none"}}}]}

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:

Type ID Field:

Fields:

• FACILITYID (type: esriFieldTypeString, alias: Facility Identifier, SQL Type: sqlTypeOther, length: 20, 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: 20, nullable: true, editable: true, Coded Values: [ABS: ABS Plastic], [AC: Asbestos Cement], [ASP: Asphalt], ... 39 more ...)
• DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 3/4"], [1: 1"], [1.25: 1 1/4"], ... 27 more ...)
• MAINSHAPE (type: esriFieldTypeString, alias: Main Shape, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Circular: Circular], [Horseshoe: Horseshoe], [Oblong: Oblong], ... 5 more ...)
• LINERTYPE (type: esriFieldTypeString, alias: Liner Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CP: Cured in Place], [FF: Fold and Form or Deform/Reform], [SN: Segmented Panel], ... 4 more ...)
• FROMMH (type: esriFieldTypeString, alias: From Manhole, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• TOMH (type: esriFieldTypeString, alias: To Manhole, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• WATERTYPE (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Treated: Treated Water], [Combined: Combined Waste Water], [Potable: Potable Water], ... 6 more ...)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• ACTIVEFLAG (type: esriFieldTypeSmallInteger, alias: Active Flag, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• OWNEDBY (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: North Miami], [2: Miami-Dade], [3: Others], ... 4 more ...)
• MAINTBY (type: esriFieldTypeSmallInteger, alias: Managed By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: North Miami], [3: Others], [2: Miami-Dade], ... 1 more ...)
• SUMFLOW (type: esriFieldTypeDouble, alias: Flow Summary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DOWNELEV (type: esriFieldTypeDouble, alias: Downstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UPELEV (type: esriFieldTypeDouble, alias: Upstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLOPE (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BASIN (type: esriFieldTypeString, alias: BASIN, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BASIN_2 (type: esriFieldTypeSmallInteger, alias: BASIN_2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LINED (type: esriFieldTypeString, alias: LINED, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Lined_Date (type: esriFieldTypeDate, alias: Lined_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AssetStatus (type: esriFieldTypeSmallInteger, alias: In use or abandoned, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Abandoned], [1: In use], [2: Unknown], ... 2 more ...)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DIAM1 (type: esriFieldTypeDouble, alias: DIAM1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• H_Link (type: esriFieldTypeString, alias: H_Link, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• WarrantyDate (type: esriFieldTypeDate, alias: Warranty Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LegacyID (type: esriFieldTypeString, alias: Legacy ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Condition (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Excellent: Excellent], [Very Good: Very Good], [Good: Good], ... 4 more ...)
• ConditionDate (type: esriFieldTypeDate, alias: Condition Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MyLength (type: esriFieldTypeDouble, alias: My length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeOther, nullable: true, editable: false)
• Further_action (type: esriFieldTypeString, alias: Further_action, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• ProjectID (type: esriFieldTypeString, alias: ProjectID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• RepairOrInspect (type: esriFieldTypeString, alias: RepairOrInspect, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• PayApp (type: esriFieldTypeInteger, alias: PayApp, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Task_Status (type: esriFieldTypeString, alias: Task_Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Task_ID (type: esriFieldTypeInteger, alias: Task_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BasinID (type: esriFieldTypeString, alias: BasinID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• WorkOrderID (type: esriFieldTypeString, alias: WorkOrderID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Pay_Item_ID (type: esriFieldTypeString, alias: Pay_Item_ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Date_Done (type: esriFieldTypeDate, alias: Date_Done, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• UnitsDone (type: esriFieldTypeDouble, alias: UnitsDone, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UnitCost (type: esriFieldTypeDouble, alias: UnitCost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Facitlity_Type (type: esriFieldTypeString, alias: Facitlity_Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• GM_ID (type: esriFieldTypeString, alias: GM_ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Lateral_ID (type: esriFieldTypeString, alias: Lateral_ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• ManholeID (type: esriFieldTypeString, alias: ManholeID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Recommendations (type: esriFieldTypeString, alias: Recommendations, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• CommentsStaff (type: esriFieldTypeString, alias: CommentsStaff, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• EstUnits (type: esriFieldTypeDouble, alias: EstUnits, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

Name: GravityMainFromServer
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/12/2021 7:09:41 PM

Schema Last Edit Date: 2/12/2021 7:09:41 PM

Data Last Edit Date: 2/12/2021 7:09:41 PM

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