Name: Sanitary Prioritization File Links

Display Field: File_Name

Type: Table

Geometry Type: N/A

Description: Linking table enabling the file deliverables for the Sanitary Prioritization project to be associated with the GIS sanitary pipe assets. Deliverables include PDF reports, CCTV video files, and Excel spreadsheets. This table can be used to link one or more project files with the respective parent GIS feature by using the Asset ID. This requires the deliverable files to have file names referencing the Asset ID.This table was generated using a python script that scanned the file names in the deliverables folder and extracted the asset ID and other information. The script and list of unlinked files can be found here: I:\Projects\2025\Sanitary Prioritization\Python

Service Item Id: 657e704d1fac4dbe85710ac20a928192

Copyright Text: Town of Cochrane Geomatics Services

Default Visibility: false

MaxRecordCount: 4000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Neighbourhood ( type: esriFieldTypeString, alias: Neighbourhood, length: 200 )
• File_Year ( type: esriFieldTypeSmallInteger, alias: File Year )
• File_Date ( type: esriFieldTypeDate, alias: File Date, length: 8 )
• File_Type ( type: esriFieldTypeString, alias: File Type, length: 10 )
• File_Name ( type: esriFieldTypeString, alias: File Name, length: 200 )
• Parent_Pipe_Type ( type: esriFieldTypeString, alias: Parent Pipe Type, length: 30 , Coded Values: [Forcemain: Forcemain] , [Main: Main] , [Syphon: Syphon] )
• Asset_ID ( type: esriFieldTypeString, alias: Asset ID, length: 30 )
• Path ( type: esriFieldTypeString, alias: Path, length: 1000 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata