Layers:

Layer: vector_pub.DBO.Streets_Maintenance_Plan (0)

Name: vector_pub.DBO.Streets_Maintenance_Plan

Display Field: STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 1258ca5b8d614846a56bdddb5f2e7aba

Copyright Text:

Default Visibility: true

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: -1.197969E8
YMin: -8.92122E7
XMax: 1627500.1769606918
YMax: 7239472.051650688
Spatial Reference: 102743  (3566)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [68, 65, 130, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• REVIEWED ( type: esriFieldTypeString, alias: REVIEWED, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REVIEWED , Coded Values: [YES: YES] , [NO: NO] , [UNKNOWN: UNKNOWN] )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• STREETNAME ( type: esriFieldTypeString, alias: STREET NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: STREETNAME )
• FROMSTREET ( type: esriFieldTypeString, alias: FROM STREET, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FROMSTREET )
• TOSTREET ( type: esriFieldTypeString, alias: TO STREET, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TOSTREET )
• STREETFAMILY ( type: esriFieldTypeString, alias: STREET FAMILY, editable: true, nullable: true, length: 100, defaultValue: null, modelName: STREETFAMILY )
• WIDTH ( type: esriFieldTypeDouble, alias: WIDTH, editable: true, nullable: true, defaultValue: null, modelName: WIDTH )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH, editable: true, nullable: true, defaultValue: null, modelName: LENGTH )
• AREAYARDS ( type: esriFieldTypeDouble, alias: AREA SQ YARDS, editable: true, nullable: true, defaultValue: null, modelName: AREAYARDS )
• LST ( type: esriFieldTypeString, alias: LST, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LST )
• LSTYEAR ( type: esriFieldTypeString, alias: LST YEAR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LSTYEAR )
• CONSTRUCTYEAR ( type: esriFieldTypeString, alias: CONSTRUCT YEAR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONSTRUCTYEAR )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• REGION ( type: esriFieldTypeString, alias: REGION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REGION )
• SEGMENTS90 ( type: esriFieldTypeString, alias: 90 SEGMENTS, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SEGMENTS90 )
• SEGMENTS15 ( type: esriFieldTypeString, alias: 15 SEGMENTS, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SEGMENTS15 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STATUS )
• DESIGNED_FLOW ( type: esriFieldTypeString, alias: DESIGNED_FLOW, editable: true, nullable: true, length: 30, defaultValue: null, modelName: DESIGNED_FLOW )
• SIMPLENAME ( type: esriFieldTypeString, alias: SIMPLENAME, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SIMPLENAME )
• FLYDATE ( type: esriFieldTypeDate, alias: FLYDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FLYDATE )
• CURRENT_PASER ( type: esriFieldTypeDouble, alias: CURRENT_PASER, editable: true, nullable: true, defaultValue: null, modelName: CURRENT_PASER )
• TREATMENT_CODE ( type: esriFieldTypeString, alias: TREATMENT_CODE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: TREATMENT_CODE , Coded Values: [C1: Commercial Crack seal at yr 4] , [C2: Commercial Crack seal and chip seal at yr 8] , [C3: Commercial Crack seal at yr 15] , ...13 more... )
• YearLastUpdated ( type: esriFieldTypeInteger, alias: YEAR_LAST_UPDATED, editable: true, nullable: true, defaultValue: null, modelName: YearLastUpdated )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )
• FULLNAME ( type: esriFieldTypeString, alias: Full Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FULLNAME )
Templates:
• Name: vector_pub.DBO.Streets_Maintenance_Plan
  Description:
  Prototype:
  TREATMENT_CODE: null
  REVIEWED: null
  YearLastUpdated: null
  STREETNAME: null
  FROMSTREET: null
  TOSTREET: null
  STREETFAMILY: null
  WIDTH: null
  LENGTH: null
  AREAYARDS: null
  LST: null
  LSTYEAR: null
  CONSTRUCTYEAR: null
  FULLNAME: null
  REGION: null
  SEGMENTS90: null
  SEGMENTS15: null
  STATUS: null
  DESIGNED_FLOW: null
  SIMPLENAME: null
  FLYDATE: null
  CURRENT_PASER: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• vector_pub.DBO.PAVEMENT_StreetHistory (0) -- Related To: Street History (9)
• PAVEMENT_FieldPASER (1) -- Related To: PAVEMENT Field PASER (5)
• PAVEMENT_TreatmentRecords (2) -- Related To: Treatment Records (12)

Layer: vector_pub.DBO.PAVEMENT_RECOMMENDED_TREATMENT_STREETS (1)

Name: vector_pub.DBO.PAVEMENT_RECOMMENDED_TREATMENT_STREETS

Display Field: Year

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 1258ca5b8d614846a56bdddb5f2e7aba

Copyright Text:

Default Visibility: true

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 1595553.5764838904
YMin: 7216888.922604397
XMax: 1627500.1769606322
YMax: 7239472.051650643
Spatial Reference: 102743  (3566)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [119, 63, 135, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Year ( type: esriFieldTypeInteger, alias: Year, editable: true, nullable: true, defaultValue: null, modelName: Year )
• Streets_GlobalID ( type: esriFieldTypeGUID, alias: Streets_GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Streets_GlobalID )
• Recommended_Treatment_Code ( type: esriFieldTypeString, alias: Recommended Treatment Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Recommended_Treatment_Code , Coded Values: [C1: Commercial Crack seal at yr 4] , [C2: Commercial Crack seal and chip seal at yr 8] , [C3: Commercial Crack seal at yr 15] , ...13 more... )
• Post_Treatment_PASER_Rating ( type: esriFieldTypeDouble, alias: Post Treatment PASER Rating, editable: true, nullable: true, defaultValue: null, modelName: Post_Treatment_PASER_Rating )
• Treatment_Cost ( type: esriFieldTypeDouble, alias: Treatment Cost, editable: true, nullable: true, defaultValue: null, modelName: Treatment_Cost )
• Treatment_Linear_Unit_Cost ( type: esriFieldTypeDouble, alias: Treatment Linear Unit Cost, editable: true, nullable: true, defaultValue: null, modelName: Treatment_Linear_Unit_Cost )
• Treatment_Linear_Unit ( type: esriFieldTypeString, alias: Treatment Linear Unit, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Treatment_Linear_Unit )
• Treatment_Area_Unit_Cost ( type: esriFieldTypeDouble, alias: Treatment Area Unit Cost, editable: true, nullable: true, defaultValue: null, modelName: Treatment_Area_Unit_Cost )
• Treatment_Area_Unit ( type: esriFieldTypeString, alias: Treatment Area Unit, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Treatment_Area_Unit )
• Project_GlobalID ( type: esriFieldTypeGUID, alias: Project_GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Project_GlobalID )
• ProjectID ( type: esriFieldTypeString, alias: ProjectID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )
• COMPLETED ( type: esriFieldTypeString, alias: Completed?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: COMPLETED , Coded Values: [Yes: Yes] , [No: No] )
• STREETFAMILY ( type: esriFieldTypeString, alias: Street Family, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STREETFAMILY )
Templates:
• Name: vector_pub.DBO.PAVEMENT_RECOMMENDED_TREATMENT_STREETS
  Description:
  Prototype:
  COMPLETED: null
  STREETFAMILY: null
  Year: null
  Streets_GlobalID: null
  Recommended_Treatment_Code: null
  Post_Treatment_PASER_Rating: null
  Treatment_Cost: null
  Treatment_Linear_Unit_Cost: null
  Treatment_Linear_Unit: null
  Treatment_Area_Unit_Cost: null
  Treatment_Area_Unit: null
  Project_GlobalID: null
  ProjectID: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• vector_pub.DBO.PAVEMENTProjects (3) -- Related To: Projects (7)

Layer: vector_pub.DBO.PAVEMENT_DEGRADATION_CURVE_STREETS (2)

Name: vector_pub.DBO.PAVEMENT_DEGRADATION_CURVE_STREETS

Display Field: Year

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 1258ca5b8d614846a56bdddb5f2e7aba

Copyright Text:

Default Visibility: true

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 1595553.5764838904
YMin: 7216888.922604397
XMax: 1627500.1769606322
YMax: 7239472.051650643
Spatial Reference: 102743  (3566)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [135, 99, 43, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Streets_GUID ( type: esriFieldTypeGUID, alias: Streets_GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Streets_GUID )
• Projects_GUID ( type: esriFieldTypeGUID, alias: Projects_GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Projects_GUID )
• Year ( type: esriFieldTypeInteger, alias: Year, editable: true, nullable: true, defaultValue: null, modelName: Year )
• PASER ( type: esriFieldTypeDouble, alias: PASER, editable: true, nullable: true, defaultValue: null, modelName: PASER )
• Treatment_Recommended ( type: esriFieldTypeString, alias: Treatment Recommended, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Treatment_Recommended , Coded Values: [C1: Commercial Crack seal at yr 4] , [C2: Commercial Crack seal and chip seal at yr 8] , [C3: Commercial Crack seal at yr 15] , ...13 more... )
• Treatment_Completed ( type: esriFieldTypeString, alias: Treatment_Completed, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Treatment_Completed )
• ProjectID ( type: esriFieldTypeString, alias: ProjectID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )
Templates:
• Name: vector_pub.DBO.PAVEMENT_DEGRADATION_CURVE_STREETS
  Description:
  Prototype:
  Treatment_Completed: null
  ProjectID: null
  Streets_GUID: null
  Projects_GUID: null
  Year: null
  PASER: null
  Treatment_Recommended: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• vector_pub.DBO.PAVEMENTProjects (4) -- Related To: Projects (7)

Tables:

Table: PAVEMENT Base Update Log (3)

Name: PAVEMENT Base Update Log

Display Field: Date_Ran

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1258ca5b8d614846a56bdddb5f2e7aba

Copyright Text:

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Date_Ran ( type: esriFieldTypeDate, alias: Date_Ran, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_Ran )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Status )
• From_Project ( type: esriFieldTypeString, alias: From Project, editable: true, nullable: true, length: 100, defaultValue: null, modelName: From_Project )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
Templates:
• Name: PAVEMENT Base Update Log
  Description:
  Prototype:
  From_Project: null
  Status: null
  Date_Ran: null
  
  Drawing Tool: esriFeatureEditToolNone

Table: DegradationCurvesByYear (4)

Name: DegradationCurvesByYear

Display Field: Year

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1258ca5b8d614846a56bdddb5f2e7aba

Copyright Text:

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Streets_GUID ( type: esriFieldTypeGUID, alias: Streets_GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Streets_GUID )
• Projects_GUID ( type: esriFieldTypeGUID, alias: Projects_GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Projects_GUID )
• Year ( type: esriFieldTypeInteger, alias: Year, editable: true, nullable: true, defaultValue: null, modelName: Year )
• PASER ( type: esriFieldTypeDouble, alias: PASER, editable: true, nullable: true, defaultValue: null, modelName: PASER )
• Treatment_Recommended ( type: esriFieldTypeString, alias: Treatment Recommended, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Treatment_Recommended , Coded Values: [C1: Commercial Crack seal at yr 4] , [C2: Commercial Crack seal and chip seal at yr 8] , [C3: Commercial Crack seal at yr 15] , ...13 more... )
• Treatment_Completed ( type: esriFieldTypeString, alias: Treatment_Completed, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Treatment_Completed )
• ProjectID ( type: esriFieldTypeString, alias: ProjectID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectID )
Templates:
• Name: DegradationCurvesByYear
  Description:
  Prototype:
  Treatment_Completed: null
  ProjectID: null
  Streets_GUID: null
  Projects_GUID: null
  Year: null
  PASER: null
  Treatment_Recommended: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• vector_pub.DBO.PAVEMENTProjects (5) -- Related To: Projects (7)

Table: PAVEMENT Field PASER (5)

Name: PAVEMENT Field PASER

Display Field: PASER

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1258ca5b8d614846a56bdddb5f2e7aba

Copyright Text:

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Streets_GUID ( type: esriFieldTypeGUID, alias: Streets GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Streets_GUID )
• PASER ( type: esriFieldTypeInteger, alias: PASER, editable: true, nullable: true, defaultValue: null, modelName: PASER )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 1500, defaultValue: null, modelName: Notes )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Year_ ( type: esriFieldTypeInteger, alias: Year_, editable: true, nullable: true, defaultValue: null, modelName: Year_ )
• FieldDate ( type: esriFieldTypeDate, alias: Field Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FieldDate )
Templates:
• Name: PAVEMENT Field PASER
  Description:
  Prototype:
  Year_: null
  FieldDate: null
  Streets_GUID: null
  PASER: null
  Notes: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Streets_Maintenance_Plan (1) -- Related To: vector_pub.DBO.Streets_Maintenance_Plan (0)

Table: vector_pub.DBO.PAVEMENT_OverrideTreatments (6)

Name: vector_pub.DBO.PAVEMENT_OverrideTreatments

Display Field: TreatmentID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1258ca5b8d614846a56bdddb5f2e7aba

Copyright Text:

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• TreatmentID ( type: esriFieldTypeString, alias: TreatmentID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TreatmentID , Coded Values: [C1: Commercial Crack seal at yr 4] , [C2: Commercial Crack seal and chip seal at yr 8] , [C3: Commercial Crack seal at yr 15] , ...13 more... )
• BeginHoldYear ( type: esriFieldTypeInteger, alias: BeginHoldYear, editable: true, nullable: true, defaultValue: null, modelName: BeginHoldYear )
• ImplementYear ( type: esriFieldTypeInteger, alias: ImplementYear, editable: true, nullable: true, defaultValue: null, modelName: ImplementYear )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 1500, defaultValue: null, modelName: Notes )
• ProjectGUID ( type: esriFieldTypeGUID, alias: ProjectGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ProjectGUID )
• StreetGUID ( type: esriFieldTypeGUID, alias: StreetGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: StreetGUID )
• ProjectID ( type: esriFieldTypeString, alias: ProjectID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
Templates:
• Name: vector_pub.DBO.PAVEMENT_OverrideTreatments
  Description:
  Prototype:
  ProjectID: null
  StreetGUID: null
  TreatmentID: null
  BeginHoldYear: null
  ImplementYear: null
  Notes: null
  ProjectGUID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• vector_pub.DBO.PAVEMENTProjects (6) -- Related To: Projects (7)

Table: Projects (7)

Name: Projects

Display Field: Author

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1258ca5b8d614846a56bdddb5f2e7aba

Copyright Text:

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Author ( type: esriFieldTypeString, alias: Author, editable: true, nullable: true, length: 120, defaultValue: null, modelName: Author )
• Year ( type: esriFieldTypeInteger, alias: Year, editable: true, nullable: true, defaultValue: null, modelName: Year )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Description )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Budget ( type: esriFieldTypeDouble, alias: Budget, editable: true, nullable: true, defaultValue: null, modelName: Budget )
• ProjectID ( type: esriFieldTypeString, alias: ProjectID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectID )
• NumberOfYears ( type: esriFieldTypeInteger, alias: NumberOfYears, editable: true, nullable: true, defaultValue: null, modelName: NumberOfYears )
• Inflation ( type: esriFieldTypeDouble, alias: Inflation, editable: true, nullable: true, defaultValue: null, modelName: Inflation )
Templates:
• Name: Projects
  Description:
  Prototype:
  NumberOfYears: null
  ProjectID: null
  Author: null
  Year: null
  Description: null
  Inflation: null
  Budget: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• vector_pub.DBO.PAVEMENTDegradationCurvesByYear (5) -- Related To: DegradationCurvesByYear (4)
• vector_pub.DBO.PAVEMENT_RECOMMENDED_TREATMENT_STREETS (3) -- Related To: vector_pub.DBO.PAVEMENT_RECOMMENDED_TREATMENT_STREETS (1)
• vector_pub.DBO.PAVEMENT_OverrideTreatments (6) -- Related To: vector_pub.DBO.PAVEMENT_OverrideTreatments (6)
• vector_pub.DBO.PAVEMENT_DEGRADATION_CURVE_STREETS (4) -- Related To: vector_pub.DBO.PAVEMENT_DEGRADATION_CURVE_STREETS (2)
• vector_pub.DBO.PAVEMENTRecommendedTreatments (7) -- Related To: RecommendedTreatments (8)

Table: RecommendedTreatments (8)

Name: RecommendedTreatments

Display Field: Year

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1258ca5b8d614846a56bdddb5f2e7aba

Copyright Text:

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Year ( type: esriFieldTypeInteger, alias: Year, editable: true, nullable: true, defaultValue: null, modelName: Year )
• Streets_GlobalID ( type: esriFieldTypeGUID, alias: Streets_GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Streets_GlobalID )
• Recommended_Treatment_Code ( type: esriFieldTypeString, alias: Recommended Treatment Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Recommended_Treatment_Code , Coded Values: [C1: Commercial Crack seal at yr 4] , [C2: Commercial Crack seal and chip seal at yr 8] , [C3: Commercial Crack seal at yr 15] , ...13 more... )
• Post_Treatment_PASER_Rating ( type: esriFieldTypeDouble, alias: Post Treatment PASER Rating, editable: true, nullable: true, defaultValue: null, modelName: Post_Treatment_PASER_Rating )
• Treatment_Cost ( type: esriFieldTypeDouble, alias: Treatment Cost, editable: true, nullable: true, defaultValue: null, modelName: Treatment_Cost )
• Treatment_Linear_Unit_Cost ( type: esriFieldTypeDouble, alias: Treatment Linear Unit Cost, editable: true, nullable: true, defaultValue: null, modelName: Treatment_Linear_Unit_Cost )
• Treatment_Linear_Unit ( type: esriFieldTypeString, alias: Treatment Linear Unit, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Treatment_Linear_Unit )
• Treatment_Area_Unit_Cost ( type: esriFieldTypeDouble, alias: Treatment Area Unit Cost, editable: true, nullable: true, defaultValue: null, modelName: Treatment_Area_Unit_Cost )
• Treatment_Area_Unit ( type: esriFieldTypeString, alias: Treatment Area Unit, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Treatment_Area_Unit )
• Project_GlobalID ( type: esriFieldTypeGUID, alias: Project_GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Project_GlobalID )
• ProjectID ( type: esriFieldTypeString, alias: ProjectID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectID )
Templates:
• Name: RecommendedTreatments
  Description:
  Prototype:
  Project_GlobalID: null
  ProjectID: null
  Year: null
  Streets_GlobalID: null
  Recommended_Treatment_Code: null
  Post_Treatment_PASER_Rating: null
  Treatment_Cost: null
  Treatment_Linear_Unit_Cost: null
  Treatment_Linear_Unit: null
  Treatment_Area_Unit_Cost: null
  Treatment_Area_Unit: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• vector_pub.DBO.PAVEMENTProjects (7) -- Related To: Projects (7)

Table: Street History (9)

Name: Street History

Display Field: Date

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1258ca5b8d614846a56bdddb5f2e7aba

Copyright Text:

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Street_GUID ( type: esriFieldTypeGUID, alias: Street_GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Street_GUID )
• Date ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date )
• PASER ( type: esriFieldTypeDouble, alias: PASER, editable: true, nullable: true, defaultValue: null, modelName: PASER )
• Last_Treatment ( type: esriFieldTypeString, alias: Last Treatment, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Last_Treatment , Coded Values: [R1: Slurry Seal - Year 1] , [R2: Crack Seal - Year 2] , [R3: Crack Seal & Slurry Seal - Year 6] , ...5 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Year_ ( type: esriFieldTypeSmallInteger, alias: Year, editable: true, nullable: true, defaultValue: null, modelName: Year_ )
Templates:
• Name: Street History
  Description:
  Prototype:
  Last_Treatment: null
  Year_: null
  Street_GUID: null
  Date: null
  PASER: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• vector_pub.DBO.Streets_Maintenance_Plan (0) -- Related To: vector_pub.DBO.Streets_Maintenance_Plan (0)

Table: vector_pub.DBO.PAVEMENTTreatmentGuidelines (10)

Name: vector_pub.DBO.PAVEMENTTreatmentGuidelines

Display Field: Family

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1258ca5b8d614846a56bdddb5f2e7aba

Copyright Text:

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Family ( type: esriFieldTypeString, alias: Family, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Family )
• Last_Treatment_Code ( type: esriFieldTypeString, alias: Last Treatment Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Last_Treatment_Code , Coded Values: [C1: Commercial Crack seal at yr 4] , [C2: Commercial Crack seal and chip seal at yr 8] , [C3: Commercial Crack seal at yr 15] , ...13 more... )
• PASER_1 ( type: esriFieldTypeDouble, alias: PASER_1, editable: true, nullable: true, defaultValue: null, modelName: PASER_1 )
• PASER_2 ( type: esriFieldTypeDouble, alias: PASER_2, editable: true, nullable: true, defaultValue: null, modelName: PASER_2 )
• Override_Exclusion ( type: esriFieldTypeString, alias: Override Exclusion, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Override_Exclusion )
• Recommended_Treatment_Code ( type: esriFieldTypeString, alias: Recommended Treatment Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Recommended_Treatment_Code , Coded Values: [C1: Commercial Crack seal at yr 4] , [C2: Commercial Crack seal and chip seal at yr 8] , [C3: Commercial Crack seal at yr 15] , ...13 more... )
• Reduction_in_Apparent_Age_Year ( type: esriFieldTypeString, alias: Reduction_in_Apparent_Age_Year, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Reduction_in_Apparent_Age_Year )
• Resulting_PASER ( type: esriFieldTypeDouble, alias: Resulting PASER, editable: true, nullable: true, defaultValue: null, modelName: Resulting_PASER )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• AGE_1 ( type: esriFieldTypeDouble, alias: AGE_1, editable: true, nullable: true, defaultValue: null, modelName: AGE_1 )
• AGE_2 ( type: esriFieldTypeDouble, alias: AGE_2, editable: true, nullable: true, defaultValue: null, modelName: AGE_2 )
• New_Apparent_Age ( type: esriFieldTypeDouble, alias: New Apparent Age, editable: true, nullable: true, defaultValue: null, modelName: New_Apparent_Age )
Templates:
• Name: vector_pub.DBO.PAVEMENTTreatmentGuidelines
  Description:
  Prototype:
  AGE_2: null
  AGE_1: null
  Family: null
  Last_Treatment_Code: null
  PASER_1: null
  PASER_2: null
  Override_Exclusion: null
  Recommended_Treatment_Code: null
  Reduction_in_Apparent_Age_Year: null
  Resulting_PASER: null
  New_Apparent_Age: null
  
  Drawing Tool: esriFeatureEditToolNone

Table: vector_pub.DBO.PAVEMENTTreatmentLookup (11)

Name: vector_pub.DBO.PAVEMENTTreatmentLookup

Display Field: Family

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1258ca5b8d614846a56bdddb5f2e7aba

Copyright Text:

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Family ( type: esriFieldTypeString, alias: Family, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Family )
• Treatment ( type: esriFieldTypeString, alias: Treatment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Treatment )
• Treatment_Code ( type: esriFieldTypeString, alias: Treatment Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Treatment_Code )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Linear_Cost ( type: esriFieldTypeDouble, alias: Linear Cost, editable: true, nullable: true, defaultValue: null, modelName: Linear_Cost )
• Linear_Units ( type: esriFieldTypeString, alias: Linear Units, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Linear_Units )
• Area_Cost ( type: esriFieldTypeDouble, alias: Area Cost, editable: true, nullable: true, defaultValue: null, modelName: Area_Cost )
• Area_Units ( type: esriFieldTypeString, alias: Area Units, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Area_Units )
Templates:
• Name: vector_pub.DBO.PAVEMENTTreatmentLookup
  Description:
  Prototype:
  Area_Cost: null
  Linear_Units: null
  Family: null
  Treatment: null
  Treatment_Code: null
  Area_Units: null
  Linear_Cost: null
  
  Drawing Tool: esriFeatureEditToolNone

Table: Treatment Records (12)

Name: Treatment Records

Display Field: Treatment_Type

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1258ca5b8d614846a56bdddb5f2e7aba

Copyright Text:

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Streets_GUID ( type: esriFieldTypeGUID, alias: Streets GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Streets_GUID )
• Treatment_Type ( type: esriFieldTypeString, alias: Treatment Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Treatment_Type , Coded Values: [C1: Commercial Crack seal at yr 4] , [C2: Commercial Crack seal and chip seal at yr 8] , [C3: Commercial Crack seal at yr 15] , ...13 more... )
• Cost ( type: esriFieldTypeDouble, alias: Cost, editable: true, nullable: true, defaultValue: null, modelName: Cost )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status )
• Pre_Treatment_PASER ( type: esriFieldTypeDouble, alias: Pre Treatment PASER, editable: true, nullable: true, defaultValue: null, modelName: Pre_Treatment_PASER )
• Post_Treatment_PASER ( type: esriFieldTypeDouble, alias: Post Treatment PASER, editable: true, nullable: true, defaultValue: null, modelName: Post_Treatment_PASER )
• Treatment_Notes ( type: esriFieldTypeString, alias: Treatment Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: Treatment_Notes )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Year_ ( type: esriFieldTypeInteger, alias: Year_, editable: true, nullable: true, defaultValue: null, modelName: Year_ )
• TreatmentDate ( type: esriFieldTypeDate, alias: Treatment Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TreatmentDate )
Templates:
• Name: Treatment Records
  Description:
  Prototype:
  Year_: null
  TreatmentDate: null
  Streets_GUID: null
  Treatment_Type: null
  Cost: null
  Status: null
  Pre_Treatment_PASER: null
  Post_Treatment_PASER: null
  Treatment_Notes: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Streets_Maintenance_Plan (2) -- Related To: vector_pub.DBO.Streets_Maintenance_Plan (0)

Table: vector_pub.DBO.PAVEMENTYearlySummary (13)

Name: vector_pub.DBO.PAVEMENTYearlySummary

Display Field: Year

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1258ca5b8d614846a56bdddb5f2e7aba

Copyright Text:

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Year ( type: esriFieldTypeInteger, alias: Year, editable: true, nullable: true, defaultValue: null, modelName: Year )
• FREQUENCY ( type: esriFieldTypeInteger, alias: FREQUENCY, editable: true, nullable: true, defaultValue: null, modelName: FREQUENCY )
• MEAN_PASER ( type: esriFieldTypeDouble, alias: MEAN_PASER, editable: true, nullable: true, defaultValue: null, modelName: MEAN_PASER )
Templates:
• Name: vector_pub.DBO.PAVEMENTYearlySummary
  Description:
  Prototype:
  FREQUENCY: null
  MEAN_PASER: null
  Year: null
  
  Drawing Tool: esriFeatureEditToolNone