Name: PRSM_Projects_Related_to_Vulnerable_Bridges
Display Field: Project_Nickname
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description: North Region Project are pulled from PRSM and filtered based on North Regions employees needs. The script is run on a weekly basis on Monday or Tuesday to update the data and is republished afterwards."
The associated data are considered Department of Transportation, Caltrans, enterprise GIS data, which meet all appropriate requirements of the Department of Transportation, Caltrans, Spatial Data Standards, as defined by the current North Region Geospatial Workflow Guidance document that is current as of latest update of data. Department of Transportation, Caltrans, makes no warranties or guarantees either expressed or implied as to the completeness, accuracy, or correctness of the data. Department of Transportation, Caltrans, neither accepts nor assumes liability arising from or for any incorrect, incomplete, or misleading subject data. The official Department of Transportation, Caltrans, GIS Steward for this data set is Aaron Ott, who may be contacted at 530-741-7378, or at aaron.ott@dot.ca.gov. Comments, problems, improvements, updates, or suggestions should be forwarded to the official GIS Steward as available and appropriate. The service will be updated on a weekly basis or as often as we can. The current procedures in updating the PRSM data follows a 6 step processes of running python scripts. Contact Hervey Lee on the location of the file:
1. Beta The script is used the newest downloaded file from PRSM and clean out all the unnecessary fields.
2. PointsCheck and LinesCheck The script overwrite previous files and uses TableToTablet conversion to convert PRSM data into Points and Lines
3. ThirdStep The script uses the Postmile tool and creates the points and lines. There is no evaluation if the tool does not see the Postmile.
4. FourthStep The script combines the Points and Lines into 1 file.
5. FifthStep LineCheck and FifthStep_PointCheck These two scripts looks for missing entries that did not go through the Postmile Tool.
6. FifthStep Combines all features and missing entries into 1 feature class.
7. SixthStep Cleans the data by inserting phase and removing zeroes in front of the route.
Copyright Text: North Region
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -745274.44827005
YMin: 9126218.81955537
XMax: 16666.5439011239
YMax: 9842537.96402053
Spatial Reference: 102600 (102600)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[112,168,0,255],"width":2}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: true
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- Join_Count (type: esriFieldTypeInteger, alias: Join_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TARGET_FID (type: esriFieldTypeInteger, alias: TARGET_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Project_EA (type: esriFieldTypeString, alias: Project EA, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Project_County (type: esriFieldTypeString, alias: Project County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Project_Route (type: esriFieldTypeString, alias: Project Route, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Project_Begin_Postmile (type: esriFieldTypeString, alias: Project Begin Postmile, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Project_End_Postmile (type: esriFieldTypeString, alias: Project End Postmile, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Project_Nickname (type: esriFieldTypeString, alias: Project Nickname, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Project_Work_Description (type: esriFieldTypeString, alias: Project Work Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Project_Description (type: esriFieldTypeString, alias: Project Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Project_Manager (type: esriFieldTypeString, alias: Project Manager, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Project_Phase (type: esriFieldTypeString, alias: Project Phase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SHOPP_ID (type: esriFieldTypeString, alias: SHOPP ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Bridge_ID (type: esriFieldTypeString, alias: Bridge ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Bridge_Name (type: esriFieldTypeString, alias: Bridge Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Bridge_County (type: esriFieldTypeString, alias: Bridge County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Bridge_Route (type: esriFieldTypeString, alias: Bridge Route, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Bridge_Postmile (type: esriFieldTypeString, alias: Bridge Postmile, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Bridge_Latitude (type: esriFieldTypeString, alias: Bridge Latitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Bridge_Longitude (type: esriFieldTypeString, alias: Bridge Longitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Bridge_Priority (type: esriFieldTypeSmallInteger, alias: Bridge Priority, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Templates:
Name: PRSM_Projects_Related_to_Vulnerable_Bridges
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 2/11/2022 7:46:12 PM
Schema Last Edit Date: 2/11/2022 7:46:12 PM
Data Last Edit Date: 2/11/2022 7:46:12 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat