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: 90b47a73209f47e3a28b2415f81eb656

Copyright Text:

Default Visibility: true

MaxRecordCount: 50000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: 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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• REVIEWED ( type: esriFieldTypeString, alias: REVIEWED, length: 255 , Coded Values: [YES: YES] , [NO: NO] , [UNKNOWN: UNKNOWN] )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• STREETNAME ( type: esriFieldTypeString, alias: STREET NAME, length: 100 )
• FROMSTREET ( type: esriFieldTypeString, alias: FROM STREET, length: 100 )
• TOSTREET ( type: esriFieldTypeString, alias: TO STREET, length: 100 )
• STREETFAMILY ( type: esriFieldTypeString, alias: STREET FAMILY, length: 100 )
• WIDTH ( type: esriFieldTypeDouble, alias: WIDTH )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH )
• AREAYARDS ( type: esriFieldTypeDouble, alias: AREA SQ YARDS )
• LST ( type: esriFieldTypeString, alias: LST, length: 50 )
• LSTYEAR ( type: esriFieldTypeString, alias: LST YEAR, length: 50 )
• CONSTRUCTYEAR ( type: esriFieldTypeString, alias: CONSTRUCT YEAR, length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• REGION ( type: esriFieldTypeString, alias: REGION, length: 50 )
• SEGMENTS90 ( type: esriFieldTypeString, alias: 90 SEGMENTS, length: 30 )
• SEGMENTS15 ( type: esriFieldTypeString, alias: 15 SEGMENTS, length: 30 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 30 )
• DESIGNED_FLOW ( type: esriFieldTypeString, alias: DESIGNED_FLOW, length: 30 )
• SIMPLENAME ( type: esriFieldTypeString, alias: SIMPLENAME, length: 20 )
• FLYDATE ( type: esriFieldTypeDate, alias: FLYDATE, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• CURRENT_PASER ( type: esriFieldTypeDouble, alias: CURRENT_PASER )
• TREATMENT_CODE ( type: esriFieldTypeString, alias: TREATMENT_CODE, length: 5 , 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 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• FULLNAME ( type: esriFieldTypeString, alias: Full Name, length: 100 )

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: 90b47a73209f47e3a28b2415f81eb656

Copyright Text:

Default Visibility: true

MaxRecordCount: 50000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: 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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Year ( type: esriFieldTypeInteger, alias: Year )
• Streets_GlobalID ( type: esriFieldTypeGUID, alias: Streets_GlobalID, length: 38 )
• Recommended_Treatment_Code ( type: esriFieldTypeString, alias: Recommended Treatment Code, length: 50 , 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 )
• Treatment_Cost ( type: esriFieldTypeDouble, alias: Treatment Cost )
• Treatment_Linear_Unit_Cost ( type: esriFieldTypeDouble, alias: Treatment Linear Unit Cost )
• Treatment_Linear_Unit ( type: esriFieldTypeString, alias: Treatment Linear Unit, length: 50 )
• Treatment_Area_Unit_Cost ( type: esriFieldTypeDouble, alias: Treatment Area Unit Cost )
• Treatment_Area_Unit ( type: esriFieldTypeString, alias: Treatment Area Unit, length: 50 )
• Project_GlobalID ( type: esriFieldTypeGUID, alias: Project_GlobalID, length: 38 )
• ProjectID ( type: esriFieldTypeString, alias: ProjectID, length: 255 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• COMPLETED ( type: esriFieldTypeString, alias: Completed?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• STREETFAMILY ( type: esriFieldTypeString, alias: Street Family, length: 20 )

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: 90b47a73209f47e3a28b2415f81eb656

Copyright Text:

Default Visibility: true

MaxRecordCount: 50000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: 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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Streets_GUID ( type: esriFieldTypeGUID, alias: Streets_GUID, length: 38 )
• Projects_GUID ( type: esriFieldTypeGUID, alias: Projects_GUID, length: 38 )
• Year ( type: esriFieldTypeInteger, alias: Year )
• PASER ( type: esriFieldTypeDouble, alias: PASER )
• Treatment_Recommended ( type: esriFieldTypeString, alias: Treatment Recommended, length: 3 , 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, length: 3 )
• ProjectID ( type: esriFieldTypeString, alias: ProjectID, length: 255 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )

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: null

Service Item Id: 90b47a73209f47e3a28b2415f81eb656

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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 )
• Date_Ran ( type: esriFieldTypeDate, alias: Date_Ran, length: 8 )
• Status ( type: esriFieldTypeString, alias: Status, length: 10 )
• From_Project ( type: esriFieldTypeString, alias: From Project, length: 100 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Table: DegradationCurvesByYear (4)

Name: DegradationCurvesByYear

Display Field: Year

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 90b47a73209f47e3a28b2415f81eb656

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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 )
• Streets_GUID ( type: esriFieldTypeGUID, alias: Streets_GUID, length: 38 )
• Projects_GUID ( type: esriFieldTypeGUID, alias: Projects_GUID, length: 38 )
• Year ( type: esriFieldTypeInteger, alias: Year )
• PASER ( type: esriFieldTypeDouble, alias: PASER )
• Treatment_Recommended ( type: esriFieldTypeString, alias: Treatment Recommended, length: 3 , 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, length: 3 )
• ProjectID ( type: esriFieldTypeString, alias: ProjectID, length: 255 )

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: null

Service Item Id: 90b47a73209f47e3a28b2415f81eb656

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Streets_GUID ( type: esriFieldTypeGUID, alias: Streets GUID, length: 38 )
• PASER ( type: esriFieldTypeInteger, alias: PASER )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 1500 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Year_ ( type: esriFieldTypeInteger, alias: Year_ )
• FieldDate ( type: esriFieldTypeDate, alias: Field Date, length: 8 )

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: null

Service Item Id: 90b47a73209f47e3a28b2415f81eb656

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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 )
• TreatmentID ( type: esriFieldTypeString, alias: TreatmentID, length: 50 , 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 )
• ImplementYear ( type: esriFieldTypeInteger, alias: ImplementYear )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 1500 )
• ProjectGUID ( type: esriFieldTypeGUID, alias: ProjectGUID, length: 38 )
• StreetGUID ( type: esriFieldTypeGUID, alias: StreetGUID, length: 38 )
• ProjectID ( type: esriFieldTypeString, alias: ProjectID, length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

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: null

Service Item Id: 90b47a73209f47e3a28b2415f81eb656

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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 )
• Author ( type: esriFieldTypeString, alias: Author, length: 120 )
• Year ( type: esriFieldTypeInteger, alias: Year )
• Description ( type: esriFieldTypeString, alias: Description, length: 500 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Budget ( type: esriFieldTypeDouble, alias: Budget )
• ProjectID ( type: esriFieldTypeString, alias: ProjectID, length: 255 )
• NumberOfYears ( type: esriFieldTypeInteger, alias: NumberOfYears )
• Inflation ( type: esriFieldTypeDouble, alias: Inflation )

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: null

Service Item Id: 90b47a73209f47e3a28b2415f81eb656

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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 )
• Year ( type: esriFieldTypeInteger, alias: Year )
• Streets_GlobalID ( type: esriFieldTypeGUID, alias: Streets_GlobalID, length: 38 )
• Recommended_Treatment_Code ( type: esriFieldTypeString, alias: Recommended Treatment Code, length: 50 , 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 )
• Treatment_Cost ( type: esriFieldTypeDouble, alias: Treatment Cost )
• Treatment_Linear_Unit_Cost ( type: esriFieldTypeDouble, alias: Treatment Linear Unit Cost )
• Treatment_Linear_Unit ( type: esriFieldTypeString, alias: Treatment Linear Unit, length: 50 )
• Treatment_Area_Unit_Cost ( type: esriFieldTypeDouble, alias: Treatment Area Unit Cost )
• Treatment_Area_Unit ( type: esriFieldTypeString, alias: Treatment Area Unit, length: 50 )
• Project_GlobalID ( type: esriFieldTypeGUID, alias: Project_GlobalID, length: 38 )
• ProjectID ( type: esriFieldTypeString, alias: ProjectID, length: 255 )

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: null

Service Item Id: 90b47a73209f47e3a28b2415f81eb656

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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 )
• Street_GUID ( type: esriFieldTypeGUID, alias: Street_GUID, length: 38 )
• Date ( type: esriFieldTypeDate, alias: Date, length: 8 )
• PASER ( type: esriFieldTypeDouble, alias: PASER )
• Last_Treatment ( type: esriFieldTypeString, alias: Last Treatment, length: 10 , 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, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Year_ ( type: esriFieldTypeSmallInteger, alias: Year )

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: null

Service Item Id: 90b47a73209f47e3a28b2415f81eb656

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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 )
• Family ( type: esriFieldTypeString, alias: Family, length: 255 )
• Last_Treatment_Code ( type: esriFieldTypeString, alias: Last Treatment Code, length: 255 , 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 )
• PASER_2 ( type: esriFieldTypeDouble, alias: PASER_2 )
• Override_Exclusion ( type: esriFieldTypeString, alias: Override Exclusion, length: 255 )
• Recommended_Treatment_Code ( type: esriFieldTypeString, alias: Recommended Treatment Code, length: 255 , 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, length: 255 )
• Resulting_PASER ( type: esriFieldTypeDouble, alias: Resulting PASER )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• AGE_1 ( type: esriFieldTypeDouble, alias: AGE_1 )
• AGE_2 ( type: esriFieldTypeDouble, alias: AGE_2 )
• New_Apparent_Age ( type: esriFieldTypeDouble, alias: New Apparent Age )

Table: vector_pub.DBO.PAVEMENTTreatmentLookup (11)

Name: vector_pub.DBO.PAVEMENTTreatmentLookup

Display Field: Family

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 90b47a73209f47e3a28b2415f81eb656

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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 )
• Family ( type: esriFieldTypeString, alias: Family, length: 255 )
• Treatment ( type: esriFieldTypeString, alias: Treatment, length: 255 )
• Treatment_Code ( type: esriFieldTypeString, alias: Treatment Code, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Linear_Cost ( type: esriFieldTypeDouble, alias: Linear Cost )
• Linear_Units ( type: esriFieldTypeString, alias: Linear Units, length: 50 )
• Area_Cost ( type: esriFieldTypeDouble, alias: Area Cost )
• Area_Units ( type: esriFieldTypeString, alias: Area Units, length: 50 )

Table: Treatment Records (12)

Name: Treatment Records

Display Field: Treatment_Type

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 90b47a73209f47e3a28b2415f81eb656

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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 )
• Streets_GUID ( type: esriFieldTypeGUID, alias: Streets GUID, length: 38 )
• Treatment_Type ( type: esriFieldTypeString, alias: Treatment Type, length: 50 , 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 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 )
• Pre_Treatment_PASER ( type: esriFieldTypeDouble, alias: Pre Treatment PASER )
• Post_Treatment_PASER ( type: esriFieldTypeDouble, alias: Post Treatment PASER )
• Treatment_Notes ( type: esriFieldTypeString, alias: Treatment Notes, length: 2000 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Year_ ( type: esriFieldTypeInteger, alias: Year_ )
• TreatmentDate ( type: esriFieldTypeDate, alias: Treatment Date, length: 8 )

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: null

Service Item Id: 90b47a73209f47e3a28b2415f81eb656

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 50000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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 )
• Year ( type: esriFieldTypeInteger, alias: Year )
• FREQUENCY ( type: esriFieldTypeInteger, alias: FREQUENCY )
• MEAN_PASER ( type: esriFieldTypeDouble, alias: MEAN_PASER )