Name: Road Maintenance Plan

Display Field: St_Name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: [StName] The full street name of the centerline segment being modeled. [St_From] Cross street representing the start or end of the centerline segment referenced in the [StName] field. Unlike in geocoding, this does not necessarily mean the start or end, in terms of digitized geometry directions. This field simply defines the boundaries of the segment. [St_To] Cross street representing the start or end of the centerline segment referenced in the [StName] field. Unlike in geocoding, this does not necessarily mean the start or end, in terms of digitized geometry directions. This field simply defines the boundaries of the segment. [Neighborhood] The CONA neighborhood boundary that best represents the centerline centroid. If a centerline serves as a border to a neighborhood boundary, it will be associated with the neighboorhood that the majority of the project covers. [PlanYear] The 4 digit planned year the work is going to occur. Will not store past years. [WorkStatus] Describes the current status of the project. Statuses include "Future", "Completed", "On-Hold", "Not Planned". A project will only have a status of "Completed" for the duration of the fiscal year. After the fiscal year, the completed projects will be appended to the Road Maintenance History table for record, and the status will be changed back to "Not Planned".[WorkType] The work to be performed on the road way. Values include "Mill and Overlay", "Slurry Seal", "Crack Seal", "Reconstruction"[Responsibility] The entity responsible for the planned work. Values include "Public Service", "Engineering", "Private", "Other"[Comment] Comment field to make production notes. [Sq_Yrds] Square yardage of the associated road way segment. Managment can use this field to approximate the size of the project and associated cost. This field is calculated by multiplying the centerline shapelength field by the pavement width field and dividing by 9.[CostEst_Slurry] Estimated cost to slurry seal the road way segment. Calculated by multiplying square yards by cost per yard for slurry seal maintenance. Most recent cost per square yard used is $2.58[CostEst_Overlay Estimated cost to mill and overlay the road way segment. Calculated by multiplying square yards by cost per yard for mill and overlay maintenance. Most recent cost per square yard used is $12.25[Width] Width of roadway in feet, taken from centerline. [MaximoID] Maximo ID for the road way, taken from centerline.

Copyright Text: Public Services Transportation Division GIS, City of San Marcos

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 250000

Max Scale: 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: 2282089.6948625594
YMin: 1.3824471654048055E7
XMax: 2335452.387349546
YMax: 1.3898115278414056E7
Spatial Reference: 102740  (2278)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 145, 136, 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 )
• St_Name ( type: esriFieldTypeString, alias: StName, length: 50 )
• St_From ( type: esriFieldTypeString, alias: St_From, length: 75 )
• St_To ( type: esriFieldTypeString, alias: St_To, length: 75 )
• Neighborhood ( type: esriFieldTypeString, alias: Neighborhood, length: 50 , Coded Values: [Blanco Gardens: Blanco Gardens] , [Blanco River North: Blanco River North] , [Blanco Vista: Blanco Vista] , ...32 more... )
• PlanYear ( type: esriFieldTypeSmallInteger, alias: PlanYear )
• WorkStatus ( type: esriFieldTypeString, alias: WorkStatus, length: 50 , Coded Values: [Future: Future] , [Completed: Completed] , [On-Hold: On-Hold] , ...3 more... )
• WorkType ( type: esriFieldTypeString, alias: WorkType, length: 50 , Coded Values: [Mill and Overlay: Mill and Overlay] , [Other: Other] , [Slurry Seal: Slurry Seal] , ...2 more... )
• Responsibility ( type: esriFieldTypeString, alias: Responsibility, length: 50 , Coded Values: [Public Works: Public Works] , [Public Services: Public Services] , [Private: Private] , ...2 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 200 )
• Sq_Yrds ( type: esriFieldTypeDouble, alias: Sq_Yrds )
• SlurryCost ( type: esriFieldTypeDouble, alias: CostEst_Slurry )
• OverlayCost ( type: esriFieldTypeDouble, alias: CostEst_Overlay )
• Width ( type: esriFieldTypeDouble, alias: Width )
• MaximoID ( type: esriFieldTypeString, alias: MaximoID, length: 15 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• 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 )
• CompletedDate ( type: esriFieldTypeDate, alias: CompletedDate, length: 8 )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• NumLanes ( type: esriFieldTypeSmallInteger, alias: Number of Lanes )
• LaneMiles ( type: esriFieldTypeSingle, alias: Lane Miles )

Relationships:

• RoadMaintenancePlan (0) -- Related To: RoadMaintenanceHistory (1)

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

  Iteminfo   Thumbnail   Metadata