Data Import

In order to gain the most accurate picture of your pipelines and risk, it's important to start with properly prepared and uploaded data to the Analyzer.

Preparing Your Data for Upload

Preparing your data correctly allows the Fracta’s algorithm to clean and process your files better.

Pipe Assets is a required dataset. We recommend uploading a Break data containing your historical breaks for better results.

We accept the following file formats:

• Pipe Assets : shp files ( zipped along with other metadata files as a zip folder), .gpkg files, .geojson files

• Break History: .xls files, .csv files, shp files ( zipped along with other metadata files as a zip folder), .gpkg files, .geojson files

We recommend that your Pipe Asset file have following 3 data columns in the given format:

• Pipe installation year Sample formats: YYYY, YYYY-MM-DD, YYYY-MM-DD Time

• Pipe material Sample format: ‘Copper’, CU , other string values

• Pipe diameter Sample format: 6, 6.0, 6”, 6 inches

We recommend that your Breaks file have following 2 (or in case of csv files, 3) data columns in the given format:

• Associated Pipe ID Sample formats: Any

• Break Date Sample format: YYYY, YYYY-MM-DD, YYYY-MM-DD Time

• Location ( if break file is not in Geoformat)

  • Longitude and Latitude Sample format: 123.998, 234.987 etc.

  • Address/ Location : Sample: ‘234, Beale Street, Sunnyvale, CA’ More complete addresses will give better geolocation results.

Uploading and Importing your Data

To upload your existing pipeline data files go to the main navigation bar and click on the Data -> Import Data section. Then click on the “Upload Pipe Asset Data” button located in the header section of the app.

After providing a dataset name, click on one of the options, upload a .gpkg/geojson or a .zip file containing your .ArcGIS(.shp) files, select the file(s) from your computer and then click “Next”.

After clicking “Next” and the Pipeline Data file was successfully uploaded, you will be able to upload any Pipeline Break History files from the next step. If you don’t have any Pipeline Break Data please omit this step. In the next step you will have the option to upload any Pipeline Pressure data file.

At this point your file(s) will be uploaded to our system.

Configuring and Editing Your Data

After successfully uploading the data files, the next step will be to configure the data.

On the first screen, you will be able to view and match the column names for the data you have imported to our required attributes.

Select or input a column name for each attribute. If the attribute is not available in your data, leave the field blank. Note that at least one of fields for the Diameter, Install Year and/or Material are required.

Hit 'Next' on the bottom right of the window to advance to the second screen. Here you can select or input all material symbols used in your data. If the material is not used, leave the field blank. If you find that a material in your dataset does not match any specific material category on screen, then add it under “Other”. All materials that are not entered into one of the 6 categories, will be classified by Fracta as “Unknown”. After mapping your data labels click the start button and the Fracta’s Engine will start processing your data, this process might take some time, the processing waiting time will depend on the size of your data files, after the Analyzer process is completed, the Fracta’s software will redirect you to the results page.