Name: CPIP Polygons Join Projects

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)
• ProjectManager (type: esriFieldTypeSmallInteger, alias: Project Manager, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Abid Al Hadi, Maad], [1: Abreu, David], [2: Alfalahi, Osama], ... 43 more ...)
• PrimaryContact (type: esriFieldTypeString, alias: Primary Contact for Customer Inquiries, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [0: Abid Al Hadi, Maad], [1: Abreu, David], [2: Alfalahi, Osama], ... 41 more ...)
• StreetName (type: esriFieldTypeString, alias: Street Name or Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• 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)
• 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)
• TeamResponsible (type: esriFieldTypeString, alias: Team Responsible, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Contract Administration and Oversight], [2: Condition Assessment and Rehabilitation], [3: Development], ... 6 more ...)
• 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 ...)
• AgencyResponsible (type: esriFieldTypeString, alias: Agency Responsible, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Bell Canada], [2: City of Brampton], [3: City of Mississauga], ... 12 more ...)
• 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 ...)
• CS4CPSupport (type: esriFieldTypeSmallInteger, alias: Receiving CS4CP Support, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• ProjectWebsite (type: esriFieldTypeString, alias: Project Website, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Phase (type: esriFieldTypeSmallInteger, alias: Phase, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: DESIGN], [1: CONSTRUCTION], [2: WARRANTY], ... 1 more ...)
• ProjectStatus (type: esriFieldTypeString, alias: Project Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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 ...)
• DetailedDesignCompletedPerc (type: esriFieldTypeSmallInteger, alias: Percentage of Detailed Design Completed, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0 - 30%], [1: 30 - 60%], [2: 60 - 90%], ... 1 more ...)
• 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 ...)
• ConsultantRFPIssueDate (type: esriFieldTypeDate, alias: Consultant RFP Issue Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ConsultantRFPIssueDateStatus (type: esriFieldTypeSmallInteger, alias: Status of Consultant RFP Issue Date, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Target], [1: Actual])
• ConstructionTenderIssueDate (type: esriFieldTypeDate, alias: Construction Tender Issue Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ConstructionTenderDateStatus (type: esriFieldTypeSmallInteger, alias: Status of Construction Tender Issue Date, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Target], [1: Actual])
• 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])
• 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])
• SubstantialCompletionDate (type: esriFieldTypeDate, alias: Substantial Completion Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SubstantialCompletionStatus (type: esriFieldTypeSmallInteger, alias: Status of Substantial Completion Date, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Target], [1: Actual])
• 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])
• WarrantyEndDate (type: esriFieldTypeDate, alias: Warranty Acceptance Period End, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WarrantyEndDateStatus (type: esriFieldTypeSmallInteger, alias: Status of Warranty End Date, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Target], [1: Actual])
• EACompletionDate (type: esriFieldTypeDate, alias: Date of EA Completion, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WaterTaking (type: esriFieldTypeSmallInteger, alias: Dewatering, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• TreeRemovals (type: esriFieldTypeSmallInteger, alias: Tree Removals, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• Inspector (type: esriFieldTypeSmallInteger, alias: Inspector, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Arkaxhiu, Mirgjen ], [1: Barua, Tapan ], [2: Basi, Abhijeet ], ... 38 more ...)
• Consultant (type: esriFieldTypeSmallInteger, alias: Consultant, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: AECOM Canada Ltd.], [1: Ainley & Associates Ltd.], [2: Amec Foster Wheeler Americas Limited], ... 44 more ...)
• Contractor (type: esriFieldTypeSmallInteger, alias: Contractor, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Accurate HD Ltd.], [2: Alliance Verdi Civil Inc.], [3: Alwahesh Contracting Inc.], ... 108 more ...)
• CapitalProjectNickName (type: esriFieldTypeString, alias: Capital Project Nickname, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CostCentre (type: esriFieldTypeString, alias: Cost Centre / Budget Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• ContractAdministration (type: esriFieldTypeSmallInteger, alias: Contract Administration, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: In-house], [1: Consultant])
• AsBuiltStatus (type: esriFieldTypeSmallInteger, alias: As-Built Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: To Be Prepared by Consultant], [1: To Be Prepared In-House], [2: Follow-up with PM], ... 8 more ...)
• AsBuiltComments (type: esriFieldTypeString, alias: As Built Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IFCAvailable (type: esriFieldTypeSmallInteger, alias: IFC Available, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• ContractNumber (type: esriFieldTypeString, alias: Document Number for Contractor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DocNumForConsultant (type: esriFieldTypeString, alias: Document Number For Consultant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DeficiencyList (type: esriFieldTypeString, alias: Deficiency List, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InspectionLevel (type: esriFieldTypeSmallInteger, alias: Inspection Level, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Region Full Time Inspection with Region CA], [1: Region Full Time Inspection with Consultant CA], [2: Region Part Time Inspection], ... 2 more ...)
• UtilitiesImpacted (type: esriFieldTypeString, alias: Utilities Impacted and Status of Relocation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ConflictNotes (type: esriFieldTypeString, alias: Conflict Notes, 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)
• SpecialInfoForPWDCS (type: esriFieldTypeString, alias: Special info for PWDCS, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• BICPSurvey (type: esriFieldTypeString, alias: BICP Survey Required, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BICPSurveyConducted (type: esriFieldTypeSmallInteger, alias: BICP Survey Conducted, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: BICP survey to be completed], [1: BICP survey completed], [2: BICP survey not required])
• BICPSurveyDate (type: esriFieldTypeDate, alias: Date BICP Survey Uploaded to e-Blast Application, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CollaborativeCommunication (type: esriFieldTypeString, alias: Project Part Of Collaborative Communication, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CS4CPDiscussionItems (type: esriFieldTypeString, alias: CS4CP Discussion Items, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CS4CPNotes (type: esriFieldTypeString, alias: CS4CP Notes, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• CS4CPProjectLaunchDate (type: esriFieldTypeDate, alias: CS4CP Project Launch Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateOfFeedback (type: esriFieldTypeDate, alias: Date All Feedback Collected From Affected Residents / Businesses , SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NextNotice (type: esriFieldTypeDate, alias: Anticipated Date Of Next Notice, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NextUpcomingNotice (type: esriFieldTypeSmallInteger, alias: Next Upcoming Notice, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Air vent letter], [0: Advance notice], [2: Backyard easement letter - Sewer relining], ... 27 more ...)
• TotalNumberAffectedUnits (type: esriFieldTypeSmallInteger, alias: Total Number Of Households/Businesses Affected Within Project Area , SQL Type: sqlTypeOther, nullable: true, editable: true)
• WorkType_orig (type: esriFieldTypeString, alias: Work Type Old, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Division_orig (type: esriFieldTypeString, alias: Division Old, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• 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)
• GlobalID_1 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• ID1 (type: esriFieldTypeInteger, alias: ID1, SQL Type: sqlTypeOther, 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 ...)
• ProjectManagerPolygon (type: esriFieldTypeSmallInteger, alias: Project Manager, 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 Join Projects
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

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   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat