Name: CPIP Polygons

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

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: 572180.999975868
YMin: 4815401.04204642
XMax: 617392.7366
YMax: 4870014.49995476
Spatial Reference: 26917 (26917)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[239,252,214,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

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:

Fields:

• 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)
• ProjectID (type: esriFieldTypeString, alias: Project ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StreetName (type: esriFieldTypeString, alias: Street Name or Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Municipality (type: esriFieldTypeString, alias: Municipality, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Ward (type: esriFieldTypeString, alias: Ward, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WorkType_orig (type: esriFieldTypeString, alias: Work Type Old, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PhasePolygon (type: esriFieldTypeSmallInteger, alias: Phase, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: DESIGN], [1: CONSTRUCTION], [2: WARRANTY], ... 1 more ...)
• Subphase (type: esriFieldTypeSmallInteger, alias: Sub-Phase, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Environmental Assessment], [1: Pre-Design], [2: Detailed Design], ... 7 more ...)
• LocationFrom (type: esriFieldTypeString, alias: Location From, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LocationTo (type: esriFieldTypeString, alias: Location To, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WarrantyStartDate (type: esriFieldTypeDate, alias: Construction Completion / Warranty Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WarrantyStartDateStatus (type: esriFieldTypeSmallInteger, alias: Status of Construction Completion / Warranty Start Date, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Target], [1: Actual])
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ConflictResolved (type: esriFieldTypeString, alias: Conflict Resolved, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ConflictResolutionDate (type: esriFieldTypeDate, alias: Conflict Resolution Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ConflictNotes (type: esriFieldTypeString, alias: Conflict Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ConstructionStartDate (type: esriFieldTypeDate, alias: Construction Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ConstructionStartDateStatus (type: esriFieldTypeSmallInteger, alias: Status of Construction Start Date, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Target], [1: Actual])
• ID1 (type: esriFieldTypeInteger, alias: ID1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Division_orig (type: esriFieldTypeString, alias: Division Old, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• EditionDate (type: esriFieldTypeDate, alias: Edition Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SodRestorationDate (type: esriFieldTypeDate, alias: Sod Restoration Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SodRestorationDateStatus (type: esriFieldTypeSmallInteger, alias: Sod Restoration Date Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Estimated], [1: Scheduled], [2: Completed])
• ConcreteRestorationDate (type: esriFieldTypeDate, alias: Concrete Restoration Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ConcreteRestorationDateStatus (type: esriFieldTypeSmallInteger, alias: Concrete Restoration Date Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Estimated], [1: Scheduled], [2: Completed])
• AsphaltRestorationDate (type: esriFieldTypeDate, alias: Asphalt Restoration Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AsphaltRestorationDateStatus (type: esriFieldTypeSmallInteger, alias: Asphalt Restoration Date Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Estimated], [1: Scheduled], [2: Completed])
• ConstructionCompletedPerc (type: esriFieldTypeSmallInteger, alias: Percentage of Construction Completed, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0 - 30%], [1: 30 - 60%], [2: 60 - 90%], ... 1 more ...)
• CostCentre (type: esriFieldTypeString, alias: Cost Centre / Budget Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Division (type: esriFieldTypeSmallInteger, alias: Division, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Water], [1: Wastewater], [2: Transportation])
• WorkType (type: esriFieldTypeSmallInteger, alias: Work Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Watermain Replacement], [1: Watermain Installation for Growth], [2: Watermain Rehabilitation], ... 24 more ...)
• WorkTypeDetails (type: esriFieldTypeSmallInteger, alias: Work Type Details, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Requiring excavation / open cut], [1: Tunneling], [2: Trenchless / no excavation required])
• WorkTypeDescription (type: esriFieldTypeSmallInteger, alias: Work Type Description, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Replacing the aging water pipe to improve the water system. The new pipe is installed by digging trenches.], [1: Replacing the aging water pipe to improve the water system. The new pipe is installed by tunneling underground.], [2: Installing a new water pipe to support growth and expand the capacity of the underground water system. The new pipe is installed by digging trenches.], ... 32 more ...)
• UtilitiesImpacted (type: esriFieldTypeString, alias: Utilities Impacted and Status of Relocation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SpecialInfoForPWDCS (type: esriFieldTypeString, alias: Special info for PWDCS, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• TreeRemovals (type: esriFieldTypeSmallInteger, alias: Tree Removals, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• RestorationResponsible (type: esriFieldTypeSmallInteger, alias: Restoration Responsible, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Region of Peel], [1: City of Mississauga], [2: City of Brampton], ... 1 more ...)
• ProjectManagerPolygon (type: esriFieldTypeSmallInteger, alias: Project Manager Polygon, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Abid Al Hadi, Maad], [1: Abreu, David], [2: Alfalahi, Osama], ... 43 more ...)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: CPIP Polygons
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Relationships:

• DEVPUB.SDE.CPIP_Projects (0) -- Related To: CPIP Projects (2)

Is Data Versioned: false

Has Contingent Values: true

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/13/2024 5:43:32 AM

Schema Last Edit Date: 8/13/2024 5:43:32 AM

Data Last Edit Date: 7/12/2024 2:41:03 PM

Child Resources:   Field Groups   Contingent Values

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