Query
Data mining and custom reporting tool.
Query is an important reference and reporting tool that everyone in the company can use to access information about your asset base, such as pipelines or facilities. This data mining software tool allows the user to complete complex searches and trending analyses within your IRAS enterprise database. There are no programming, SQL, or GIS skills required as the intuitive query builder allows users to create custom query criteria in plain English. You can display the resulting information in a tabular format that can then be further manipulated using statistical sorting and filtering tools provided for analysis and an-hoc report creation.
Query Features
- Mine any asset attribute in the database
- Apply filters for selection criteria
- Export results or summaries into an Excel©, XML, HTML, or Text supported file formats
- Generate custom reports
- Identify locations where two or more factors may co-exist (i.e. interaction of threats)
- Sorting, grouping, aggregation and custom filtering tools built in
- Dynamically segments results only using the data you select
- Save ‘Projects’ to bookmark specific locations or to create query templates
- Share your Projects with others.
Access any dataset in the IRAS Enterprise database:
- Spatial Data Sources – SDE (GIS vector layers, imagery, shape files, etc)
- All pipeline asset information
- Pipeline operating information
- HCA’s and class locations
- CP readings
- Direct Assessment Data (ECDA, SCCDA, etc.)
- ILI data
- Excavation data
- Incident history
- Current or historical risk assessment results including stored case studies
- Custom data attributes
