these are my cypher codes with I talked about .
CREATE CONSTRAINT ON (s:DD_Survey_12IN) ASSERT s.SURV12_ID is UNIQUE;
CREATE CONSTRAINT ON (c:DR_Casing_9IN) ASSERT c.CAS9_ID is UNIQUE;
CREATE CONSTRAINT ON (w:WL_CBL_9IN) ASSERT w.CBL9_ID is UNIQUE;
//SURVEY, CASING, CBL.
USING PERIODIC COMMIT
LOAD CSV with headers FROM "file:/V_CBL+CAS+Survey12in.csv" AS line
WITH line, split(line.Timing, '/') as time
CREATE (survey:HF4_3_2H:DD_Survey_12IN {SURV12_ID: ToFloat (line.SURV12_ID)})
set survey.houre =TOINT (time[2]),
survey.minutes =TOINT(time[0]),
survey.second =TOINT(time[1]),
survey.Sur12_WellDepth =ToFloat (line.SUR12_Well depth),
survey.Sounding =ToFloat (line.sounding),
survey.Well_Oblique =ToFloat (line.Well oblique),
survey.Position =ToFloat (line.position),
survey.Heavy_Surface =ToFloat (line.Heavy surface),
survey.surface.Magnetic_surface =ToFloat (line.Magnetic surface),
survey.Gravity =ToFloat (line.Gravity),
survey.Magnetic_field_intensity =ToFloat (line.Magnetic field intensity),
survey.Magnetic_inclination =ToFloat (line.Magnetic inclination),
survey.temperature =ToFloat (line.temperature),
survey.GX =ToFloat (line.Gx),
survey.GY =ToFloat (line.Gy),
survey.GZ =ToFloat (line.Gz),
survey.BX =ToFloat (line.Bx),
survey.BY =ToFloat (line.By),
survey.BZ =ToFloat (line.Bz)
CREATE (casing:HF4_3_2H:DR_Casing_9IN {CAS9_ID: ToFloat (line.CAS9_ID)})
set casing.CAS9_No =ToFloat (line.CAS_No.,
casing.CAS9_Factory =line.CAS_Factory,
casing.CAS9_Grade =line.CAS_Grade,
casing.CAS9_Thickness_mm =ToFloat (line.CAS_Thickness_mm),
casing.CAS9_OD_mm =ToFloat (line.CAS_OD_mm),
casing.CAS9_SubLength_m =ToFloat (line.CAS_Sub Length_m),
casing.CAS9_TotalLenght_m =ToFloat (line.CAS_Total Length_m),
casing.CAS9_Depth_m =ToFloat (line.CAS_Depth_m),
casing.CAS9_Remarks =ToFloat (line.CAS_Remark)
CREATE (cbl:HF4_3_2H:WL_CBL_9IN {CBL9_ID: ToFloat (line.CBL9_ID)})
set cbl.CBL_Depth_m =ToFloat (line.CBL_DEPTH_m),
cbl.CBL_TEN_KG =ToFloat (line.CBL_TEN_KG),
cbl.CBL_GR_GAPI =ToFloat (line.CBL_GR_GAPI),
cbl.CBL_CCL_mv =ToFloat (line.CBL_CCL_mv),
cbl.CBL_mv =ToFloat (line.CBL_mv),
cbl.CBL_WF1 =ToFloat (line.CBL_WF1)
CREATE (casing)-[a:Correlation_Incl]->(survey)
CREATE (cbl) -[a:Correlation_Incl]->(survey)
CREATE (cbl) -[r:Correlation_CCL]->(casing)
set a.Incl = CASE line.Magnetic inclination WHEN 0 then false ELSE true END,
r.ccl = CASE line.CBL_CCL_mv WHEN 0 THEN false ELSE true END
;