Name: SWP_turnouts
Display Field: SourceDoc_Feature_Name
Type: Feature Layer
Geometry Type: esriGeometryMultipoint
Description: This is a multipoint dataset of State Water Project assets. The multipoints in this dataset represent various types of assets, such as vaults, buildings, bridges, culverts, turnouts, and turnins. Most features have been assigned an SWP Asset Register Object ID, Functional Location, Asset Description, Asset Level, and Asset Type. The Object ID serves as a unique identifier and is either the feature's Functional Location or its Equipment ID.This dataset is intended to be the authoritative repository for SWP point assets. While the data is not complete at this time, continual updates will lead to an eventual replacement the atlas dataset i17_StateWaterProject_Points. Almost all assets for South Bay Aqueduct are included in this dataset. However, for the rest of the SWP, only culverts, turnouts, turnins, vaults, and a few other assets are included. Point assets were digitized and mapped from a combination of sources, including GPS points, SWP Strip Maps, SWP Blue Book, and aerial photography. Assets taken from the Blue Book were linear-referenced based on Blue Book mile posts. There are 38 features excluding turnouts and turnins that are not included in the Asset Register and thus do not have an assigned Object ID. Turnouts and turnins in this dataset primarily come from two different sources: the SWP Blue Book and the SWP Strip Maps. Extensive work was done to harmonize the differences between these two sources and to eliminate duplicate data. However, there are still a large number of turnouts that could not be identified in the Asset Register and thus do not have an assigned Object ID. There are likely many duplicates amongst these. There are also 12 turnouts in Oroville Field Division that could not be spatially located, but are included in the attribute table. The Asset Register does not include any turnins, so a temporary unique ID was assigned to them. This dataset has relationship classes with six other tables: i17_StateWaterProject_BlueBook_Table1_Conveyance_Points i17_StateWaterProject_BlueBook_Table5_DeliveryStructures i17_StateWaterProject_BlueBook_Table6_PumpIns i17_StateWaterProject _Culverts i17_StateWaterProject _Turnouts All tables except i17_StateWaterProject_BlueBook_Table6_PumpIns are related through the Asset Register Object ID field. i17_StateWaterProject_BlueBook_Table6_PumpIns is related through the Turnin_ID field. The first three tables are digital versions of SWP Blue Book tables 1, 5, and 6, and contain additional information on conveyance points, turnouts, and turnins that come specifically from the Blue Book. The last two tables contain additional information on culverts and turnouts that has been collected by DOE Geomatics Branch over the years.This dataset is current as of 5/230/2024.
Copyright Text: Division of Engineering, Geomatics Branch; Division of Operations and Maintenance
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: 1475410.8510445
YMin: -970648.761051393
XMax: 3075157.20240443
YMax: 674449.020938822
Spatial Reference: 26743 (26743)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[0,92,230,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,92,230,255],"width":0}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
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)
- AssetRegister_Object (type: esriFieldTypeString, alias: AssetRegister_Object, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- AssetRegister_Functional_Loc (type: esriFieldTypeString, alias: AssetRegister_Functional_Loc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- AssetRegister_Description (type: esriFieldTypeString, alias: AssetRegister_Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- AssetRegister_Level (type: esriFieldTypeString, alias: AssetRegister_Level, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Asset_Type (type: esriFieldTypeString, alias: Asset_Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SourceDoc_Feature_Name (type: esriFieldTypeString, alias: Feature_Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SourceDoc_Mile_Post (type: esriFieldTypeString, alias: MP_Catcher, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Branch (type: esriFieldTypeString, alias: Branch, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Source (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Size (type: esriFieldTypeString, alias: Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Specification_Number (type: esriFieldTypeString, alias: Spec_Numbers, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Flag_BlueBook (type: esriFieldTypeString, alias: Flag_BlueBook, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Flag_StripMaps (type: esriFieldTypeString, alias: Flag_StripMaps, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Flag_GoMap (type: esriFieldTypeString, alias: Flag_GoMap, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Date_Data_Applies_To (type: esriFieldTypeDate, alias: Date_Data_Applies_To, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Date_Record_Last_Edited (type: esriFieldTypeDate, alias: Date_Record_Last_Edited, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Record_Last_Edited_By (type: esriFieldTypeString, alias: Record_Last_Edited_By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- TurnIn_ID (type: esriFieldTypeSmallInteger, alias: TurnIn_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: SWP_turnouts
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 2/2/2026 4:28:19 PM
Schema Last Edit Date: 2/2/2026 4:28:19 PM
Data Last Edit Date: 2/2/2026 4:28:19 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat