Name: Texas BLE Study History

Display Field: Study_Name

Type: Table

Geometry Type: N/A

Description: This table represents the history of Base Level Engineering (BLE) studies by HUC 8 watersheds across Texas. It includes information on study versions, study type, deliverables, and associated funding and contract management details.The table is related to the Texas BLE Study Status feature layer through the Study_Code field, enabling users to track the evolution of studies over time.

Service Item Id: 800ab7d738a84c459695802e1bdaf252

Copyright Text: TWDB, USGS

Default Visibility: false

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: N/A

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
Supports TrueCurve: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: N/A

Fields:

• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• Study_Code ( nullable: true, length: 255, alias: HUC 8 Code, type: esriFieldTypeString )
• Study_Name ( nullable: true, length: 255, alias: Watershed Name, type: esriFieldTypeString )
• Study_Version ( nullable: true, alias: Study Version, type: esriFieldTypeSmallInteger )
• Notes ( nullable: true, length: 1073741822, alias: Notes, type: esriFieldTypeString )
• Study_Type ( nullable: true, length: 255, alias: Study Type, type: esriFieldTypeString , Coded Values: [1D: 1D] , [2D: 2D] )
• Hydrology_Source ( nullable: true, length: 255, alias: Hydrology Source, type: esriFieldTypeString , Coded Values: [Atlas 14: Atlas 14] , [Atlas 15: Atlas 15] , [Other: Other] )
• LiDAR_Collections ( nullable: true, length: 1073741822, alias: LiDAR Collections, type: esriFieldTypeString )
• Study_Start_Date ( nullable: true, length: 8, alias: Study Start Date, type: esriFieldTypeDate )
• Report_Date ( nullable: true, length: 8, alias: Report Date, type: esriFieldTypeDate )
• Refresh_Type ( nullable: true, length: 255, alias: Refresh Type, type: esriFieldTypeString , Coded Values: [Initial BLE: Initial BLE] , [1D to 2D: 1D to 2D] , [Routine Refresh: Routine Refresh] , ...2 more... )
• Refresh_Notes ( nullable: true, length: 1073741822, alias: Refresh Notes, type: esriFieldTypeString )
• Validation_Result ( nullable: true, length: 255, alias: Validation Result, type: esriFieldTypeString , Coded Values: [Pass: Pass] , [Fail: Fail] )
• Validation_FY ( nullable: true, alias: Validation FY, type: esriFieldTypeSmallInteger )
• Next_Validation_FY ( nullable: true, alias: Next Validation FY, type: esriFieldTypeSmallInteger )
• Validation_Notes ( nullable: true, length: 1073741822, alias: Validation Notes, type: esriFieldTypeString )
• Delivered_to_USGS ( nullable: true, length: 255, alias: Delivered to USGS, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• USGS_Delivery_Date ( nullable: true, length: 8, alias: USGS Delivery Date, type: esriFieldTypeDate )
• eBFE_Viewer_Status ( nullable: true, length: 255, alias: eBFE Viewer Status, type: esriFieldTypeString , Coded Values: [In Progress: In Progress] , [Not Shown: Not Shown] , [Archived: Archived] , ...1 more... )
• eBFE_Viewer_Upload_Date ( nullable: true, length: 8, alias: eBFE Viewer Upload Date, type: esriFieldTypeDate )
• Final_on_S3 ( nullable: true, length: 255, alias: Final Study on S3, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• Models_URL ( nullable: true, length: 1073741822, alias: Models URL, type: esriFieldTypeString )
• Documents_URL ( nullable: true, length: 1073741822, alias: Documents URL, type: esriFieldTypeString )
• Spatial_Data_URL ( nullable: true, length: 1073741822, alias: Spatial Data URL, type: esriFieldTypeString )
• Engineers_Stamp ( nullable: true, length: 255, alias: Engineer’s Stamp, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• Certificate_of_Compliance ( nullable: true, length: 255, alias: Certificate of Compliance, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• Models_Checked ( nullable: true, length: 255, alias: Models Checked, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• MIP_Status ( nullable: true, length: 255, alias: MIP Status, type: esriFieldTypeString , Coded Values: [Not Started: Not Started] , [Pending: Pending] , [Submitted: Submitted] , ...4 more... )
• MIP_Delivery_Date ( nullable: true, length: 8, alias: MIP Delivery Date, type: esriFieldTypeDate )
• MIP_Case_Number ( nullable: true, length: 255, alias: MIP Case Number, type: esriFieldTypeString )
• MIP_Notes ( nullable: true, length: 1073741822, alias: MIP Notes, type: esriFieldTypeString )
• Contractor ( nullable: true, length: 255, alias: Contractor, type: esriFieldTypeString )
• Work_Order ( nullable: true, length: 255, alias: Work Order, type: esriFieldTypeString )
• Funding_Source ( nullable: true, length: 255, alias: Funding Source, type: esriFieldTypeString , Coded Values: [CTP: Cooperating Technical Partners] , [State: State] , [TBD: TBD] , ...2 more... )
• Organization ( nullable: true, length: 255, alias: Organization, type: esriFieldTypeString , Coded Values: [FEMA: FEMA] , [TWDB: TWDB] , [TWDB/SARA: TWDB/SARA] , ...1 more... )

Relationships:

• Texas_BLE_Study_Status (0) -- Related To: Texas BLE Study Status (0)

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

  Iteminfo   Thumbnail   Metadata