Name: Option 1 - Council Approved Funding

Display Field: asset_id

Type: Table

Description: Layer created by Jane Cremers 11/7/19

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Time Info:

Start Time Field: event_start
End Time Field: event_end
Track ID Field: null
Time Extent
[1/1/2020 12:00:00 AM UTC, 12/31/2029 12:00:00 AM UTC]

Time Reference: UTC
Time Interval: 1
Time Interval Units: esriTimeUnitsYears
Has Live Data: false
Export Options:

Use Time: false
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: object_id

Unique ID Field:

Name : object_id

IsSystemMaintained : True

Global ID Field: global_id

Type ID Field:

Fields:

• object_id (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• global_id (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• event_start (type: esriFieldTypeDate, alias: Event Start, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: true)
• event_end (type: esriFieldTypeDate, alias: Event End, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: true)
• simulation_year (type: esriFieldTypeString, alias: Year, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• simulation_years (type: esriFieldTypeString, alias: Years, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• unique_asset_id (type: esriFieldTypeString, alias: Unique Asset Id, SQL Type: sqlTypeOther, length: 5000, nullable: false, editable: true)
• network_measure (type: esriFieldTypeDouble, alias: Network Measure, SQL Type: sqlTypeOther, nullable: false, editable: true)
• assetname (type: esriFieldTypeString, alias: Asset Name, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• asset_id (type: esriFieldTypeString, alias: Asset Id, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• unit_cost_variation (type: esriFieldTypeString, alias: Unit Cost Variation, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• reacting_soil (type: esriFieldTypeString, alias: Reacting_Soil, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• road_name (type: esriFieldTypeString, alias: Road_Name, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• segment_description (type: esriFieldTypeString, alias: Segment_Description, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• treatment_name (type: esriFieldTypeString, alias: Treatment Name, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• estimated_cost (type: esriFieldTypeDouble, alias: Estimated Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• roughness (type: esriFieldTypeInteger, alias: Roughness, SQL Type: sqlTypeOther, nullable: true, editable: true)
• rutting (type: esriFieldTypeInteger, alias: Rutting, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pavement_defect (type: esriFieldTypeInteger, alias: Pavement_Defect, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pavement_defects__moderate_ (type: esriFieldTypeInteger, alias: Pavement_Defects__Moderate_, SQL Type: sqlTypeOther, nullable: true, editable: true)
• crocodile_cracking (type: esriFieldTypeInteger, alias: Crocodile_Cracking, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pavement_defects__extreme_ (type: esriFieldTypeInteger, alias: Pavement_Defects__Extreme_, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cracking_moderate (type: esriFieldTypeInteger, alias: Cracking_Moderate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cracking_extreme (type: esriFieldTypeInteger, alias: Cracking_Extreme, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ravelling (type: esriFieldTypeInteger, alias: Ravelling, SQL Type: sqlTypeOther, nullable: true, editable: true)
• stripping (type: esriFieldTypeInteger, alias: Stripping, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ravelling_severity_2 (type: esriFieldTypeInteger, alias: Ravelling_Severity_2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ravelling_severity_3 (type: esriFieldTypeInteger, alias: Ravelling_Severity_3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• surface_distress (type: esriFieldTypeInteger, alias: Surface_Distress, SQL Type: sqlTypeOther, nullable: true, editable: true)
• settlement_length (type: esriFieldTypeInteger, alias: Settlement_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• osi_service_index (type: esriFieldTypeInteger, alias: OSI (Service Index), SQL Type: sqlTypeOther, nullable: true, editable: true)
• hierarchy (type: esriFieldTypeString, alias: Hierarchy, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• surface_type (type: esriFieldTypeString, alias: Surface_Type, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• urban_rural_category (type: esriFieldTypeString, alias: Urban_Rural_Category, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• polishing (type: esriFieldTypeString, alias: Polishing, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• sub_class (type: esriFieldTypeString, alias: Sub_Class, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/11/2019 7:01:10 AM

Schema Last Edit Date: 7/11/2019 7:01:10 AM

Data Last Edit Date: 7/11/2019 7:01:10 AM

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