Data Export

The Fracta platform allows you to download your data in both GIS (zipped ESRI shapefiles) and CSV format, to be used on your desktop GIS application or excel spreadsheet program.

To export your data, go to the Data / Export data tab and click on the ‘Download’ dropdown button located in the app toolbar, select the type of file you would like to download and click the icon button next to it.

The table below defines what each of the columns present on the exported file refers to.

Column	English	Japanese
native_pipe_id	Pipe segment ID	管路セグメントID
asset_id	Pipe segment ID by Fracta	Fractaが付与した管路セグメントID
diameter	Diameter	口径
material	Material	材質
install_year	Installation year	埋設年
geometry	Location	位置
length	Length	長さ
break_count	Accumulated break count	累積漏水回数
lof_3	Likelihood of failure (LOF) in 3 months	3ヶ月以内の漏水確率
lof_6	Likelihood of failure (LOF) in 6 months	6ヶ月以内の漏水確率
lof_12	Likelihood of failure (LOF) in 1 year	1年以内の漏水確率
lof_24	Likelihood of failure (LOF) in 2 years	2年以内の漏水確率
lof_rank_absolute	Rank of LOF	漏水確率の順位
lof_risk_level	Risk Level, which is absolute risk class of LOF based on predefined thresholds of LOF values	LOFレベル: 漏水確率の固定値で分けた絶対リスク階級
lof_risk_rank	Risk Rank, which is relative risk class of LOF based on percentile thresholds	診断ランク: 漏水確率 のパーセンタイルで分けた相対リスク階級
lof_risk_driver_1_name	1st risk driver of Failure	漏水と相関する要因 (1位)
lof_risk_driver_2_name	2nd risk driver of Failure	漏水と相関する要因 (2位)
lof_risk_driver_3_name	3rd risk driver of Failure	漏水と相関する要因 (3位)
lof_risk_driver_4_name	4th risk driver of Failure	漏水と相関する要因 (4位)
lof_risk_driver_5_name	5th risk driver of Failure	漏水と相関する要因 (5位)